[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '2' > SHUFFLE SKIP 2000 < SKIP 562 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43870_1 | 1722-46CA-96 | PO14326149236 | 100 | 281 | 322 | 107 | 2 | 2021-10-02 | 1258.38 | 31.46 | 2021-09-20 | 3 | 413.15 | 1 | 1258.38 | 1 | SO43870 | 2021-09-27 | 100.67 | 1239.44 | 419.46 | |||
SO55301_47 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 603 | 414 | 2 | 2023-12-02 | 72.89 | 1.82 | 2023-11-20 | 1 | 53.94 | 1 | 72.89 | 47 | SO55301 | 2023-11-27 | 5.83 | 53.94 | 72.89 | |||
SO48336_22 | 48F2-4141-9A | PO11455111823 | 100 | 281 | 233 | 72 | 2 | 2023-02-01 | 288.40 | 7.21 | 2023-01-20 | 10 | 29.08 | 1 | 288.40 | 22 | SO48336 | 2023-01-27 | 23.07 | 290.81 | 28.84 | |||
SO46666_2 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 221 | 8 | 234 | 2 | 6.73 | 2022-09-01 | 67.29 | 1.51 | 2022-08-20 | 4 | 13.88 | 1 | 60.56 | 2 | SO46666 | 2022-08-27 | 4.84 | 55.51 | 16.82 | 0.10 |
SO69473_4 | EC4D-4584-96 | PO18792161947 | 100 | 283 | 594 | 16 | 378 | 2 | 45.20 | 2024-07-02 | 113.00 | 1.70 | 2024-06-20 | 1 | 308.22 | 1 | 67.80 | 4 | SO69473 | 2024-06-27 | 5.42 | 308.22 | 113.00 | 0.40 |
SO46368_21 | BF32-47A9-90 | PO4408111909 | 100 | 281 | 342 | 143 | 2 | 2022-08-02 | 1258.38 | 31.46 | 2022-07-21 | 3 | 413.15 | 1 | 1258.38 | 21 | SO46368 | 2022-07-28 | 100.67 | 1239.44 | 419.46 | |||
SO49888_41 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 216 | 234 | 2 | 2023-06-02 | 181.68 | 4.54 | 2023-05-21 | 9 | 13.88 | 1 | 181.68 | 41 | SO49888 | 2023-05-28 | 14.53 | 124.90 | 20.19 | |||
SO67271_27 | E734-4CEC-A8 | PO13775181029 | 100 | 283 | 487 | 618 | 2 | 2024-06-02 | 65.99 | 1.65 | 2024-05-21 | 2 | 20.57 | 1 | 65.99 | 27 | SO67271 | 2024-05-28 | 5.28 | 41.13 | 32.99 | |||
SO65236_21 | 46EF-4D44-A9 | PO9483140017 | 100 | 283 | 234 | 54 | 2 | 2024-05-02 | 179.96 | 4.50 | 2024-04-20 | 6 | 38.49 | 1 | 179.96 | 21 | SO65236 | 2024-04-27 | 14.40 | 230.95 | 29.99 | |||
SO47706_15 | D1C6-4062-AA | PO3828168588 | 100 | 281 | 393 | 414 | 2 | 2022-12-02 | 275.39 | 6.88 | 2022-11-20 | 2 | 101.89 | 1 | 275.39 | 15 | SO47706 | 2022-11-27 | 22.03 | 203.79 | 137.69 | |||
SO46666_3 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 331 | 234 | 2 | 2022-09-01 | 3288.56 | 82.21 | 2022-08-20 | 7 | 486.71 | 1 | 3288.56 | 3 | SO46666 | 2022-08-27 | 263.08 | 3406.95 | 469.79 | |||
SO46993_12 | F652-4085-A4 | PO11658111433 | 100 | 272 | 399 | 233 | 2 | 2022-10-02 | 135.10 | 3.38 | 2022-09-20 | 4 | 24.99 | 1 | 135.10 | 12 | SO46993 | 2022-09-27 | 10.81 | 99.97 | 33.77 | |||
SO49888_34 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 379 | 234 | 2 | 2023-06-02 | 5235.75 | 130.89 | 2023-05-21 | 4 | 1320.68 | 1 | 5235.75 | 34 | SO49888 | 2023-05-28 | 418.86 | 5282.74 | 1308.94 | |||
SO45809_9 | D8A0-4462-8A | PO5365154898 | 100 | 281 | 330 | 161 | 2 | 2022-06-02 | 1258.38 | 31.46 | 2022-05-21 | 3 | 413.15 | 1 | 1258.38 | 9 | SO45809 | 2022-05-28 | 100.67 | 1239.44 | 419.46 | |||
SO46655_13 | F5D5-409B-94 | PO3828139841 | 100 | 281 | 412 | 414 | 2 | 2022-09-01 | 360.26 | 9.01 | 2022-08-20 | 2 | 133.30 | 1 | 360.26 | 13 | SO46655 | 2022-08-27 | 28.82 | 266.59 | 180.13 | |||
SO50704_4 | 7E83-42D0-A6 | PO3190148529 | 100 | 283 | 239 | 575 | 2 | 2023-08-02 | 1561.64 | 39.04 | 2023-07-21 | 2 | 722.26 | 1 | 1561.64 | 4 | SO50704 | 2023-07-28 | 124.93 | 1444.51 | 780.82 | |||
SO45567_1 | 01C4-4B5B-95 | PO6322144798 | 100 | 281 | 319 | 503 | 2 | 2022-05-02 | 874.79 | 21.87 | 2022-04-20 | 1 | 884.71 | 1 | 874.79 | 1 | SO45567 | 2022-04-27 | 69.98 | 884.71 | 874.79 | |||
SO55301_22 | C4D6-4789-A9 | PO3828165579 | 100 | 283 | 472 | 414 | 2 | 2023-12-02 | 342.90 | 8.57 | 2023-11-20 | 9 | 23.75 | 1 | 342.90 | 22 | SO55301 | 2023-11-27 | 27.43 | 213.74 | 38.10 | |||
SO71949_13 | D52C-4E65-AA | PO9483195097 | 100 | 283 | 472 | 54 | 2 | 2024-08-02 | 76.20 | 1.91 | 2024-07-21 | 2 | 23.75 | 1 | 76.20 | 13 | SO71949 | 2024-07-28 | 6.10 | 47.50 | 38.10 | |||
SO51101_4 | 5853-46B4-AC | PO13775166153 | 100 | 283 | 487 | 618 | 2 | 2023-09-01 | 32.99 | 0.82 | 2023-08-20 | 1 | 20.57 | 1 | 32.99 | 4 | SO51101 | 2023-08-27 | 2.64 | 20.57 | 32.99 | |||
SO46385_18 | F727-48F0-AF | PO9483110086 | 100 | 281 | 270 | 54 | 2 | 2022-08-02 | 367.88 | 9.20 | 2022-07-21 | 2 | 181.49 | 1 | 367.88 | 18 | SO46385 | 2022-07-28 | 29.43 | 362.97 | 183.94 | |||
SO59012_7 | 6620-4CEA-A0 | PO7685122244 | 100 | 283 | 552 | 539 | 2 | 2024-02-01 | 274.47 | 6.86 | 2024-01-20 | 5 | 40.62 | 1 | 274.47 | 7 | SO59012 | 2024-01-27 | 21.96 | 203.11 | 54.89 | |||
SO46986_3 | A56F-42B9-BB | PO12383199580 | 100 | 281 | 422 | 89 | 2 | 2022-10-02 | 270.16 | 6.75 | 2022-09-20 | 4 | 49.98 | 1 | 270.16 | 3 | SO46986 | 2022-09-27 | 21.61 | 199.92 | 67.54 | |||
SO71824_4 | BBB4-42D9-86 | PO11455162600 | 100 | 283 | 545 | 72 | 2 | 2024-08-02 | 97.18 | 2.43 | 2024-07-21 | 4 | 17.98 | 1 | 97.18 | 4 | SO71824 | 2024-07-28 | 7.77 | 71.91 | 24.29 | |||
SO49888_33 | 01BB-49D0-BD | PO6699147895 | 100 | 283 | 335 | 234 | 2 | 2023-06-02 | 1409.38 | 35.23 | 2023-05-21 | 3 | 486.71 | 1 | 1409.38 | 33 | SO49888 | 2023-05-28 | 112.75 | 1460.12 | 469.79 | |||
SO45793_6 | 0B18-49B2-96 | PO13775113238 | 100 | 281 | 326 | 618 | 2 | 2022-06-02 | 419.46 | 10.49 | 2022-05-21 | 1 | 413.15 | 1 | 419.46 | 6 | SO45793 | 2022-05-28 | 33.56 | 413.15 | 419.46 | |||
SO49518_35 | AF02-4E4D-BA | PO9483189305 | 100 | 283 | 460 | 54 | 2 | 2023-05-02 | 215.98 | 5.40 | 2023-04-20 | 4 | 37.12 | 1 | 215.98 | 35 | SO49518 | 2023-04-27 | 17.28 | 148.48 | 53.99 | |||
SO65194_1 | 3164-44BE-9B | PO12325153918 | 100 | 283 | 586 | 53 | 2 | 2024-05-02 | 890.82 | 22.27 | 2024-04-20 | 2 | 461.44 | 1 | 890.82 | 1 | SO65194 | 2024-04-27 | 71.27 | 922.89 | 445.41 | |||
SO53570_18 | 412A-483A-A3 | PO9483124574 | 100 | 283 | 581 | 54 | 2 | 2023-11-02 | 6123.56 | 153.09 | 2023-10-21 | 6 | 1082.51 | 1 | 6123.56 | 18 | SO53570 | 2023-10-28 | 489.89 | 6495.06 | 1020.59 | |||
SO55261_16 | 130D-46E9-9B | PO11484193890 | 100 | 283 | 515 | 594 | 2 | 2023-12-02 | 32.54 | 0.81 | 2023-11-20 | 2 | 12.04 | 1 | 32.54 | 16 | SO55261 | 2023-11-27 | 2.60 | 24.08 | 16.27 | |||
SO44797_32 | 4297-4DF9-A8 | PO9483142524 | 100 | 281 | 212 | 54 | 2 | 2022-02-01 | 60.56 | 1.51 | 2022-01-20 | 3 | 12.03 | 1 | 60.56 | 32 | SO44797 | 2022-01-27 | 4.84 | 36.08 | 20.19 |
Generated 2024-09-19 21:06:38.884 UTC