[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 195 > < TAKE 28 >
28 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO58971_2 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 499 | 611 | 5 | 2024-03-26 | 1204.69 | 30.12 | 2024-03-14 | 2 | 601.74 | 1 | 1204.69 | 2 | SO58971 | 2024-03-21 | 96.38 | 1203.49 | 602.35 | |||
| SO51693_9 | 6FEB-4D5B-92 | PO19546179477 | 100 | 285 | 584 | 206 | 5 | 2023-11-25 | 971.98 | 24.30 | 2023-11-13 | 3 | 343.65 | 1 | 971.98 | 9 | SO51693 | 2023-11-20 | 77.76 | 1030.95 | 323.99 | |||
| SO48075_3 | DB59-481D-87 | PO7598114627 | 100 | 285 | 375 | 45 | 5 | 2023-02-25 | 2617.88 | 65.45 | 2023-02-13 | 2 | 1320.68 | 1 | 2617.88 | 3 | SO48075 | 2023-02-20 | 209.43 | 2641.37 | 1308.94 | |||
| SO65207_28 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 225 | 611 | 5 | 2024-06-25 | 32.36 | 0.81 | 2024-06-13 | 6 | 6.92 | 1 | 32.36 | 28 | SO65207 | 2024-06-20 | 2.59 | 41.53 | 5.39 | |||
| SO45312_2 | FE78-461F-B7 | PO1276154927 | 100 | 285 | 215 | 548 | 5 | 2022-05-28 | 20.19 | 0.50 | 2022-05-16 | 1 | 12.03 | 1 | 20.19 | 2 | SO45312 | 2022-05-23 | 1.61 | 12.03 | 20.19 | |||
| SO44518_5 | 359F-48A3-B9 | PO12586169040 | 100 | 285 | 229 | 278 | 5 | 2022-02-25 | 57.68 | 1.44 | 2022-02-13 | 2 | 31.72 | 1 | 57.68 | 5 | SO44518 | 2022-02-20 | 4.61 | 63.45 | 28.84 | |||
| SO71850_6 | 3DA6-4E97-9F | PO18241134627 | 100 | 285 | 555 | 477 | 5 | 2024-09-25 | 63.90 | 1.60 | 2024-09-13 | 1 | 47.29 | 1 | 63.90 | 6 | SO71850 | 2024-09-20 | 5.11 | 47.29 | 63.90 | |||
| SO45802_15 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 235 | 423 | 5 | 2022-07-26 | 115.36 | 2.88 | 2022-07-14 | 4 | 31.72 | 1 | 115.36 | 15 | SO45802 | 2022-07-21 | 9.23 | 126.90 | 28.84 | |||
| SO47726_29 | 7256-4599-93 | PO9657190563 | 100 | 285 | 221 | 315 | 5 | 2023-01-25 | 80.75 | 2.02 | 2023-01-13 | 4 | 13.88 | 1 | 80.75 | 29 | SO47726 | 2023-01-20 | 6.46 | 55.51 | 20.19 | |||
| SO48051_2 | D18B-421F-99 | PO3596190178 | 100 | 285 | 364 | 476 | 5 | 2023-02-25 | 3887.96 | 97.20 | 2023-02-13 | 6 | 598.44 | 1 | 3887.96 | 2 | SO48051 | 2023-02-20 | 311.04 | 3590.61 | 647.99 | |||
| SO65220_17 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 472 | 297 | 5 | 2024-06-25 | 114.30 | 2.86 | 2024-06-13 | 3 | 23.75 | 1 | 114.30 | 17 | SO65220 | 2024-06-20 | 9.14 | 71.25 | 38.10 | |||
| SO46045_18 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 238 | 584 | 5 | 2022-08-25 | 758.08 | 18.95 | 2022-08-13 | 1 | 747.97 | 1 | 758.08 | 18 | SO46045 | 2022-08-20 | 60.65 | 747.97 | 758.08 | |||
| SO49088_1 | ED04-4B44-9B | PO11542199639 | 100 | 285 | 323 | 62 | 5 | 2023-05-28 | 1409.38 | 35.23 | 2023-05-16 | 3 | 486.71 | 1 | 1409.38 | 1 | SO49088 | 2023-05-23 | 112.75 | 1460.12 | 469.79 | |||
| SO69510_8 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 474 | 422 | 5 | 2024-08-25 | 335.95 | 8.40 | 2024-08-13 | 8 | 26.18 | 1 | 335.95 | 8 | SO69510 | 2024-08-20 | 26.88 | 209.41 | 41.99 | |||
| SO51760_21 | 2C2D-41C9-8C | PO9918180623 | 100 | 285 | 493 | 260 | 5 | 2023-11-25 | 1000.26 | 25.01 | 2023-11-13 | 5 | 199.85 | 1 | 1000.26 | 21 | SO51760 | 2023-11-20 | 80.02 | 999.26 | 200.05 | |||
| SO46047_7 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 218 | 99 | 5 | 2022-08-25 | 5.70 | 0.14 | 2022-08-13 | 1 | 3.40 | 1 | 5.70 | 7 | SO46047 | 2022-08-20 | 0.46 | 3.40 | 5.70 | |||
| SO65220_11 | 6D87-4C24-98 | PO15457146892 | 100 | 285 | 573 | 297 | 5 | 2024-06-25 | 1430.44 | 35.76 | 2024-06-13 | 1 | 1481.94 | 1 | 1430.44 | 11 | SO65220 | 2024-06-20 | 114.44 | 1481.94 | 1430.44 | |||
| SO59076_2 | 6CC1-43A5-AC | PO9744156348 | 100 | 285 | 359 | 98 | 5 | 2024-03-26 | 1376.99 | 34.42 | 2024-03-14 | 1 | 1251.98 | 1 | 1376.99 | 2 | SO59076 | 2024-03-21 | 110.16 | 1251.98 | 1376.99 | |||
| SO50756_16 | C414-447C-84 | PO9570119689 | 100 | 285 | 364 | 585 | 5 | 2023-09-25 | 1943.98 | 48.60 | 2023-09-13 | 3 | 598.44 | 1 | 1943.98 | 16 | SO50756 | 2023-09-20 | 155.52 | 1795.31 | 647.99 | |||
| SO71866_21 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 555 | 627 | 5 | 2024-09-25 | 127.80 | 3.20 | 2024-09-13 | 2 | 47.29 | 1 | 127.80 | 21 | SO71866 | 2024-09-20 | 10.22 | 94.57 | 63.90 | |||
| SO61173_28 | 6B8D-47B8-8E | PO522171689 | 100 | 285 | 475 | 676 | 5 | 2024-04-26 | 41.99 | 1.05 | 2024-04-14 | 1 | 26.18 | 1 | 41.99 | 28 | SO61173 | 2024-04-21 | 3.36 | 26.18 | 41.99 | |||
| SO43861_12 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 220 | 584 | 5 | 2021-11-25 | 80.75 | 2.02 | 2021-11-13 | 4 | 12.03 | 1 | 80.75 | 12 | SO43861 | 2021-11-20 | 6.46 | 48.11 | 20.19 | |||
| SO46933_28 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 385 | 206 | 5 | 2022-11-25 | 1800.79 | 45.02 | 2022-11-13 | 3 | 605.65 | 1 | 1800.79 | 28 | SO46933 | 2022-11-20 | 144.06 | 1816.95 | 600.26 | |||
| SO50703_24 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 383 | 90 | 5 | 2023-09-25 | 2401.05 | 60.03 | 2023-09-13 | 4 | 605.65 | 1 | 2401.05 | 24 | SO50703 | 2023-09-20 | 192.08 | 2422.60 | 600.26 | |||
| SO49473_9 | EAA2-43E2-87 | PO2813142084 | 100 | 283 | 343 | 90 | 5 | 2023-06-25 | 3288.56 | 82.21 | 2023-06-13 | 7 | 486.71 | 1 | 3288.56 | 9 | SO49473 | 2023-06-20 | 263.08 | 3406.95 | 469.79 | |||
| SO71839_19 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 484 | 2 | 611 | 5 | 1.01 | 2024-09-25 | 50.72 | 1.24 | 2024-09-13 | 11 | 2.97 | 1 | 49.71 | 19 | SO71839 | 2024-09-20 | 3.98 | 32.71 | 4.61 | 0.02 |
| SO47993_5 | 48A5-4EA7-AE | PO15051142366 | 100 | 285 | 224 | 207 | 5 | 2023-02-25 | 31.12 | 0.78 | 2023-02-13 | 6 | 5.23 | 1 | 31.12 | 5 | SO47993 | 2023-02-20 | 2.49 | 31.38 | 5.19 | |||
| SO44799_1 | 2146-417A-8D | PO9106161251 | 100 | 285 | 304 | 602 | 5 | 2022-03-27 | 1429.41 | 35.74 | 2022-03-15 | 2 | 617.03 | 1 | 1429.41 | 1 | SO44799 | 2022-03-22 | 114.35 | 1234.06 | 714.70 |
Generated 2024-11-13 03:10:39.846 UTC