[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '6' > SHUFFLE < SKIP 509 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65243_6 | F88F-4FB2-85 | PO11194174051 | 19 | 284 | 506 | 48 | 6 | 2024-06-27 | 200.05 | 5.00 | 2024-06-15 | 1 | 199.85 | 1 | 200.05 | 6 | SO65243 | 2024-06-22 | 16.00 | 199.85 | 200.05 | |||
SO49855_36 | 0C94-4D84-A4 | PO18473166459 | 19 | 291 | 362 | 442 | 6 | 2023-07-28 | 1229.46 | 30.74 | 2023-07-16 | 1 | 1105.81 | 1 | 1229.46 | 36 | SO49855 | 2023-07-23 | 98.36 | 1105.81 | 1229.46 | |||
SO53535_14 | 8195-45C7-93 | PO18502176746 | 19 | 291 | 577 | 154 | 6 | 2023-12-28 | 2915.64 | 72.89 | 2023-12-16 | 4 | 755.15 | 1 | 2915.64 | 14 | SO53535 | 2023-12-23 | 233.25 | 3020.60 | 728.91 | |||
SO57024_10 | DED7-4CEF-90 | PO17661138970 | 19 | 284 | 523 | 264 | 6 | 2024-02-27 | 31.58 | 0.79 | 2024-02-15 | 1 | 23.37 | 1 | 31.58 | 10 | SO57024 | 2024-02-22 | 2.53 | 23.37 | 31.58 | |||
SO71921_6 | F38D-4417-84 | PO2233121230 | 19 | 291 | 471 | 262 | 6 | 2024-09-27 | 152.40 | 3.81 | 2024-09-15 | 4 | 23.75 | 1 | 152.40 | 6 | SO71921 | 2024-09-22 | 12.19 | 95.00 | 38.10 | |||
SO69540_8 | 75AA-4D8C-83 | PO1856168639 | 19 | 291 | 496 | 263 | 6 | 2024-08-27 | 602.35 | 15.06 | 2024-08-15 | 1 | 601.74 | 1 | 602.35 | 8 | SO69540 | 2024-08-22 | 48.19 | 601.74 | 602.35 | |||
SO53464_20 | E113-419B-8F | PO17545119283 | 19 | 291 | 384 | 155 | 6 | 2023-12-28 | 2016.88 | 50.42 | 2023-12-16 | 3 | 713.08 | 1 | 2016.88 | 20 | SO53464 | 2023-12-23 | 161.35 | 2139.24 | 672.29 | |||
SO43898_25 | 420C-4ECE-85 | PO4901196283 | 19 | 284 | 253 | 84 | 6 | 2021-11-27 | 892.90 | 22.32 | 2021-11-15 | 5 | 176.20 | 1 | 892.90 | 25 | SO43898 | 2021-11-22 | 71.43 | 881.00 | 178.58 | |||
SO44498_8 | 7715-4053-B5 | PO17748167942 | 19 | 284 | 338 | 102 | 6 | 2022-02-27 | 419.46 | 10.49 | 2022-02-15 | 1 | 413.15 | 1 | 419.46 | 8 | SO44498 | 2022-02-22 | 33.56 | 413.15 | 419.46 | |||
SO67268_29 | 9708-4E22-A4 | PO15312122688 | 19 | 291 | 484 | 299 | 6 | 2024-07-28 | 47.70 | 1.19 | 2024-07-16 | 10 | 2.97 | 1 | 47.70 | 29 | SO67268 | 2024-07-23 | 3.82 | 29.73 | 4.77 | |||
SO44283_7 | D5FF-488D-B7 | PO18444150042 | 19 | 288 | 342 | 2 | 227 | 6 | 97.31 | 2022-01-27 | 4865.72 | 119.21 | 2022-01-15 | 12 | 413.15 | 1 | 4768.41 | 7 | SO44283 | 2022-01-22 | 381.47 | 4957.76 | 405.48 | 0.02 |
SO53484_23 | CEC0-499D-80 | PO14790120337 | 19 | 291 | 590 | 497 | 6 | 2023-12-28 | 923.39 | 23.08 | 2023-12-16 | 2 | 419.78 | 1 | 923.39 | 23 | SO53484 | 2023-12-23 | 73.87 | 839.56 | 461.69 | |||
SO46074_5 | 5178-4FDE-97 | PO2088179248 | 19 | 288 | 262 | 136 | 6 | 2022-08-27 | 183.94 | 4.60 | 2022-08-15 | 1 | 181.49 | 1 | 183.94 | 5 | SO46074 | 2022-08-22 | 14.72 | 181.49 | 183.94 | |||
SO47399_1 | B5FA-4CC2-8C | PO10962177551 | 19 | 284 | 367 | 685 | 6 | 2022-12-28 | 3239.97 | 81.00 | 2022-12-16 | 5 | 598.44 | 1 | 3239.97 | 1 | SO47399 | 2022-12-23 | 259.20 | 2992.18 | 647.99 | |||
SO69560_18 | B1B6-43F4-BC | PO9077167302 | 19 | 291 | 597 | 100 | 6 | 2024-08-27 | 971.98 | 24.30 | 2024-08-15 | 3 | 294.58 | 1 | 971.98 | 18 | SO69560 | 2024-08-22 | 77.76 | 883.74 | 323.99 | |||
SO51160_39 | 3F3F-4135-B0 | PO4495157262 | 19 | 291 | 398 | 496 | 6 | 2023-10-27 | 160.34 | 4.01 | 2023-10-15 | 6 | 19.78 | 1 | 160.34 | 39 | SO51160 | 2023-10-22 | 12.83 | 118.65 | 26.72 | |||
SO67316_1 | 6F7E-4455-9E | PO4495115494 | 19 | 291 | 363 | 496 | 6 | 2024-07-28 | 5507.98 | 137.70 | 2024-07-16 | 4 | 1251.98 | 1 | 5507.98 | 1 | SO67316 | 2024-07-23 | 440.64 | 5007.93 | 1376.99 | |||
SO45522_10 | DB6E-40EF-A4 | PO19401195812 | 19 | 288 | 342 | 173 | 6 | 2022-06-27 | 419.46 | 10.49 | 2022-06-15 | 1 | 413.15 | 1 | 419.46 | 10 | SO45522 | 2022-06-22 | 33.56 | 413.15 | 419.46 | |||
SO51704_6 | 13FA-4729-A9 | PO17661178081 | 19 | 284 | 552 | 264 | 6 | 2023-11-27 | 109.79 | 2.74 | 2023-11-15 | 2 | 40.62 | 1 | 109.79 | 6 | SO51704 | 2023-11-22 | 8.78 | 81.24 | 54.89 | |||
SO58953_16 | 99EE-491E-BD | PO11107122647 | 19 | 284 | 477 | 156 | 6 | 2024-03-28 | 8.98 | 0.22 | 2024-03-16 | 3 | 1.87 | 1 | 8.98 | 16 | SO58953 | 2024-03-23 | 0.72 | 5.60 | 2.99 | |||
SO47012_7 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 453 | 66 | 6 | 2022-11-27 | 215.96 | 5.40 | 2022-11-15 | 6 | 24.75 | 1 | 215.96 | 7 | SO47012 | 2022-11-22 | 17.28 | 148.48 | 35.99 | |||
SO44081_3 | 32E7-4EA4-9F | PO18299115585 | 19 | 288 | 348 | 118 | 6 | 2021-12-28 | 10124.97 | 253.12 | 2021-12-16 | 5 | 1898.09 | 1 | 10124.97 | 3 | SO44081 | 2021-12-23 | 810.00 | 9490.47 | 2024.99 | |||
SO47973_45 | B9F1-47DA-87 | PO18705118148 | 19 | 291 | 337 | 479 | 6 | 2023-02-27 | 939.59 | 23.49 | 2023-02-15 | 2 | 486.71 | 1 | 939.59 | 45 | SO47973 | 2023-02-22 | 75.17 | 973.41 | 469.79 | |||
SO46950_3 | AAC1-43D9-A3 | PO17806144306 | 19 | 291 | 221 | 101 | 6 | 2022-11-27 | 60.56 | 1.51 | 2022-11-15 | 3 | 13.88 | 1 | 60.56 | 3 | SO46950 | 2022-11-22 | 4.84 | 41.63 | 20.19 | |||
SO44288_29 | 6F5C-4E3C-B5 | PO14732190246 | 19 | 288 | 215 | 514 | 6 | 2022-01-27 | 80.75 | 2.02 | 2022-01-15 | 4 | 12.03 | 1 | 80.75 | 29 | SO44288 | 2022-01-22 | 6.46 | 48.11 | 20.19 | |||
SO45553_8 | 87C3-40D7-80 | PO1885177550 | 19 | 284 | 351 | 588 | 6 | 2022-06-27 | 4049.99 | 101.25 | 2022-06-15 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO45553 | 2022-06-22 | 324.00 | 3796.19 | 2024.99 | |||
SO46062_18 | 114A-41C0-B5 | PO11600112515 | 19 | 288 | 270 | 569 | 6 | 2022-08-27 | 183.94 | 4.60 | 2022-08-15 | 1 | 181.49 | 1 | 183.94 | 18 | SO46062 | 2022-08-22 | 14.72 | 181.49 | 183.94 | |||
SO71792_24 | 5257-4FC4-A5 | PO17545115036 | 19 | 291 | 380 | 155 | 6 | 2024-09-27 | 8796.06 | 219.90 | 2024-09-15 | 6 | 1554.95 | 1 | 8796.06 | 24 | SO71792 | 2024-09-22 | 703.68 | 9329.69 | 1466.01 |
Generated 2024-11-14 08:12:44.383 UTC