[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 0 SHUFFLE < SKIP 1083 > < TAKE 24 >
24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO53563_15 | C955-44BD-A8 | PO9599165865 | 100 | 285 | 240 | 170 | 5 | 2023-11-03 | 2576.70 | 64.42 | 2023-10-22 | 3 | 868.63 | 1 | 2576.70 | 15 | SO53563 | 2023-10-29 | 206.14 | 2605.90 | 858.90 | |||
SO61223_1 | BA78-42F5-A5 | PO11861157968 | 100 | 283 | 474 | 17 | 5 | 2024-03-04 | 83.99 | 2.10 | 2024-02-21 | 2 | 26.18 | 1 | 83.99 | 1 | SO61223 | 2024-02-28 | 6.72 | 52.35 | 41.99 | |||
SO45062_15 | 017E-486E-BC | PO1189166374 | 100 | 285 | 342 | 423 | 5 | 2022-03-05 | 419.46 | 10.49 | 2022-02-21 | 1 | 413.15 | 1 | 419.46 | 15 | SO45062 | 2022-02-28 | 33.56 | 413.15 | 419.46 | |||
SO51693_14 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 580 | 206 | 5 | 2023-10-03 | 2041.19 | 51.03 | 2023-09-21 | 2 | 1082.51 | 1 | 2041.19 | 14 | SO51693 | 2023-09-28 | 163.30 | 2165.02 | 1020.59 | |||
SO55331_20 | 4195-4A79-A3 | PO9889143385 | 100 | 285 | 475 | 494 | 5 | 2023-12-03 | 41.99 | 1.05 | 2023-11-21 | 1 | 26.18 | 1 | 41.99 | 20 | SO55331 | 2023-11-28 | 3.36 | 26.18 | 41.99 | |||
SO46996_2 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 369 | 512 | 5 | 2022-10-03 | 5864.04 | 146.60 | 2022-09-21 | 4 | 1518.79 | 1 | 5864.04 | 2 | SO46996 | 2022-09-28 | 469.12 | 6075.15 | 1466.01 | |||
SO69533_20 | AC2B-4C39-84 | PO3596133486 | 100 | 285 | 594 | 16 | 476 | 5 | 90.40 | 2024-07-03 | 226.00 | 3.39 | 2024-06-21 | 2 | 308.22 | 1 | 135.60 | 20 | SO69533 | 2024-06-28 | 10.85 | 616.44 | 113.00 | 0.40 |
SO69565_6 | F165-437F-B9 | PO9773181473 | 100 | 285 | 555 | 8 | 5 | 2024-07-03 | 63.90 | 1.60 | 2024-06-21 | 1 | 47.29 | 1 | 63.90 | 6 | SO69565 | 2024-06-28 | 5.11 | 47.29 | 63.90 | |||
SO45288_2 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 342 | 584 | 5 | 2022-04-05 | 838.92 | 20.97 | 2022-03-24 | 2 | 413.15 | 1 | 838.92 | 2 | SO45288 | 2022-03-31 | 67.11 | 826.29 | 419.46 | |||
SO50701_3 | B67A-4C0A-B3 | PO2407199018 | 100 | 285 | 254 | 225 | 5 | 2023-08-03 | 183.94 | 4.60 | 2023-07-22 | 1 | 170.14 | 1 | 183.94 | 3 | SO50701 | 2023-07-29 | 14.72 | 170.14 | 183.94 | |||
SO50286_1 | 1FB9-4638-B9 | PO5278149050 | 100 | 285 | 417 | 224 | 5 | 2023-07-03 | 324.45 | 8.11 | 2023-06-21 | 1 | 300.12 | 1 | 324.45 | 1 | SO50286 | 2023-06-28 | 25.96 | 300.12 | 324.45 | |||
SO47042_24 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 367 | 566 | 5 | 2022-10-03 | 2591.98 | 64.80 | 2022-09-21 | 4 | 598.44 | 1 | 2591.98 | 24 | SO47042 | 2022-09-28 | 207.36 | 2393.74 | 647.99 | |||
SO47725_30 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 454 | 81 | 5 | 2022-12-03 | 35.99 | 0.90 | 2022-11-21 | 1 | 24.75 | 1 | 35.99 | 30 | SO47725 | 2022-11-28 | 2.88 | 24.75 | 35.99 | |||
SO44507_11 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 346 | 99 | 5 | 2022-01-03 | 4079.99 | 102.00 | 2021-12-22 | 2 | 1912.15 | 1 | 4079.99 | 11 | SO44507 | 2021-12-29 | 326.40 | 3824.31 | 2039.99 | |||
SO49133_2 | 50D5-4F65-92 | PO9512136037 | 100 | 285 | 329 | 135 | 5 | 2023-04-05 | 1879.18 | 46.98 | 2023-03-24 | 4 | 486.71 | 1 | 1879.18 | 2 | SO49133 | 2023-03-31 | 150.33 | 1946.83 | 469.79 | |||
SO57126_6 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 386 | 45 | 5 | 2024-01-03 | 2016.88 | 50.42 | 2023-12-22 | 3 | 713.08 | 1 | 2016.88 | 6 | SO57126 | 2023-12-29 | 161.35 | 2139.24 | 672.29 | |||
SO65207_8 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 214 | 611 | 5 | 2024-05-03 | 125.96 | 3.15 | 2024-04-21 | 6 | 13.09 | 1 | 125.96 | 8 | SO65207 | 2024-04-28 | 10.08 | 78.52 | 20.99 | |||
SO50306_1 | D376-4A40-86 | PO5858194676 | 100 | 285 | 447 | 566 | 5 | 2023-07-03 | 60.00 | 1.50 | 2023-06-21 | 4 | 10.31 | 1 | 60.00 | 1 | SO50306 | 2023-06-28 | 4.80 | 41.25 | 15.00 | |||
SO49088_3 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 325 | 62 | 5 | 2023-04-05 | 469.79 | 11.74 | 2023-03-24 | 1 | 486.71 | 1 | 469.79 | 3 | SO49088 | 2023-03-31 | 37.58 | 486.71 | 469.79 | |||
SO51137_26 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 596 | 494 | 5 | 2023-09-02 | 647.99 | 16.20 | 2023-08-21 | 2 | 294.58 | 1 | 647.99 | 26 | SO51137 | 2023-08-28 | 51.84 | 589.16 | 323.99 | |||
SO45815_7 | 80EF-464E-97 | PO9657174967 | 100 | 285 | 215 | 315 | 5 | 2022-06-03 | 20.19 | 0.50 | 2022-05-22 | 1 | 12.03 | 1 | 20.19 | 7 | SO45815 | 2022-05-29 | 1.61 | 12.03 | 20.19 | |||
SO47042_22 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 360 | 566 | 5 | 2022-10-03 | 3688.38 | 92.21 | 2022-09-21 | 3 | 1105.81 | 1 | 3688.38 | 22 | SO47042 | 2022-09-28 | 295.07 | 3317.43 | 1229.46 | |||
SO57074_7 | FF65-4261-97 | PO9918191120 | 100 | 285 | 503 | 260 | 5 | 2024-01-03 | 200.05 | 5.00 | 2023-12-22 | 1 | 199.85 | 1 | 200.05 | 7 | SO57074 | 2023-12-29 | 16.00 | 199.85 | 200.05 | |||
SO48063_15 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 445 | 566 | 5 | 2023-01-03 | 107.98 | 2.70 | 2022-12-22 | 3 | 24.75 | 1 | 107.98 | 15 | SO48063 | 2022-12-29 | 8.64 | 74.24 | 35.99 |
Generated 2024-09-21 00:33:34.337 UTC