[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2250 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51829_1 | 448A-443D-89 | PO5655146578 | 100 | 287 | 497 | 563 | 4 | 2023-11-23 | 602.35 | 15.06 | 2023-11-11 | 1 | 601.74 | 1 | 602.35 | 1 | SO51829 | 2023-11-18 | 48.19 | 601.74 | 602.35 | |||
SO69466_6 | 8B97-4CC6-8A | PO2523169620 | 100 | 287 | 372 | 167 | 4 | 2024-08-23 | 2932.02 | 73.30 | 2024-08-11 | 2 | 1554.95 | 1 | 2932.02 | 6 | SO69466 | 2024-08-18 | 234.56 | 3109.90 | 1466.01 | |||
SO55251_25 | 2481-4FF1-80 | PO13659159365 | 100 | 287 | 353 | 437 | 4 | 2024-01-23 | 9743.96 | 243.60 | 2024-01-11 | 7 | 1265.62 | 1 | 9743.96 | 25 | SO55251 | 2024-01-18 | 779.52 | 8859.34 | 1391.99 | |||
SO45074_8 | 7225-40DF-B0 | PO7859191751 | 100 | 287 | 215 | 221 | 4 | 2022-04-25 | 100.93 | 2.52 | 2022-04-13 | 5 | 12.03 | 1 | 100.93 | 8 | SO45074 | 2022-04-20 | 8.07 | 60.14 | 20.19 | |||
SO48769_35 | A39E-4380-A6 | PO7859190388 | 100 | 287 | 381 | 221 | 4 | 2023-04-25 | 1800.79 | 45.02 | 2023-04-13 | 3 | 605.65 | 1 | 1800.79 | 35 | SO48769 | 2023-04-20 | 144.06 | 1816.95 | 600.26 | |||
SO47039_3 | B548-493E-AE | PO5684166879 | 100 | 282 | 356 | 385 | 4 | 2022-11-23 | 2485.70 | 62.14 | 2022-11-11 | 2 | 1117.86 | 1 | 2485.70 | 3 | SO47039 | 2022-11-18 | 198.86 | 2235.71 | 1242.85 | |||
SO49498_3 | D9E7-4090-86 | PO16472151816 | 100 | 287 | 381 | 239 | 4 | 2023-06-23 | 600.26 | 15.01 | 2023-06-11 | 1 | 605.65 | 1 | 600.26 | 3 | SO49498 | 2023-06-18 | 48.02 | 605.65 | 600.26 | |||
SO59023_4 | 9975-4F2A-A7 | PO5539149469 | 100 | 282 | 487 | 61 | 4 | 2024-03-24 | 98.98 | 2.47 | 2024-03-12 | 3 | 20.57 | 1 | 98.98 | 4 | SO59023 | 2024-03-19 | 7.92 | 61.70 | 32.99 | |||
SO53460_8 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 467 | 24 | 4 | 2023-12-24 | 58.78 | 1.47 | 2023-12-12 | 4 | 9.16 | 1 | 58.78 | 8 | SO53460 | 2023-12-19 | 4.70 | 36.64 | 14.69 | |||
SO58982_3 | EEA8-4A3B-AF | PO18125159249 | 100 | 287 | 374 | 311 | 4 | 2024-03-24 | 1466.01 | 36.65 | 2024-03-12 | 1 | 1554.95 | 1 | 1466.01 | 3 | SO58982 | 2024-03-19 | 117.28 | 1554.95 | 1466.01 | |||
SO46057_5 | 6F2B-45A4-9C | PO12499164653 | 100 | 282 | 324 | 78 | 4 | 2022-08-23 | 2936.21 | 73.41 | 2022-08-11 | 7 | 413.15 | 1 | 2936.21 | 5 | SO46057 | 2022-08-18 | 234.90 | 2892.02 | 419.46 | |||
SO55247_4 | 5120-4FF2-97 | PO13833112210 | 100 | 287 | 572 | 95 | 4 | 2024-01-23 | 445.41 | 11.14 | 2024-01-11 | 1 | 461.44 | 1 | 445.41 | 4 | SO55247 | 2024-01-18 | 35.63 | 461.44 | 445.41 | |||
SO71889_2 | 79BB-4639-B8 | PO6786144643 | 100 | 281 | 488 | 3 | 4 | 2024-09-23 | 161.97 | 4.05 | 2024-09-11 | 5 | 41.57 | 1 | 161.97 | 2 | SO71889 | 2024-09-18 | 12.96 | 207.86 | 32.39 | |||
SO53583_35 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 309 | 75 | 4 | 2023-12-24 | 818.70 | 20.47 | 2023-12-12 | 1 | 747.20 | 1 | 818.70 | 35 | SO53583 | 2023-12-19 | 65.50 | 747.20 | 818.70 | |||
SO71890_11 | D31D-413E-BB | PO5510169156 | 100 | 287 | 484 | 5 | 4 | 2024-09-23 | 4.77 | 0.12 | 2024-09-11 | 1 | 2.97 | 1 | 4.77 | 11 | SO71890 | 2024-09-18 | 0.38 | 2.97 | 4.77 | |||
SO71815_1 | F2AE-44B9-94 | PO13021155785 | 100 | 282 | 287 | 276 | 4 | 2024-09-23 | 202.33 | 5.06 | 2024-09-11 | 1 | 204.63 | 1 | 202.33 | 1 | SO71815 | 2024-09-18 | 16.19 | 204.63 | 202.33 | |||
SO50738_26 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 286 | 130 | 4 | 2023-09-23 | 183.94 | 4.60 | 2023-09-11 | 1 | 170.14 | 1 | 183.94 | 26 | SO50738 | 2023-09-18 | 14.72 | 170.14 | 183.94 | |||
SO47400_36 | F0B3-44C1-8F | PO10701186775 | 100 | 282 | 224 | 4 | 133 | 4 | 10.81 | 2022-12-24 | 108.05 | 2.43 | 2022-12-12 | 25 | 5.23 | 1 | 97.25 | 36 | SO47400 | 2022-12-19 | 7.78 | 130.74 | 4.32 | 0.10 |
SO67273_8 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 559 | 475 | 4 | 2024-07-24 | 36.43 | 0.91 | 2024-07-12 | 3 | 8.99 | 1 | 36.43 | 8 | SO67273 | 2024-07-19 | 2.91 | 26.96 | 12.14 | |||
SO48049_18 | C09A-49F5-80 | PO3799136256 | 100 | 282 | 364 | 312 | 4 | 2023-02-23 | 1943.98 | 48.60 | 2023-02-11 | 3 | 598.44 | 1 | 1943.98 | 18 | SO48049 | 2023-02-18 | 155.52 | 1795.31 | 647.99 | |||
SO53607_11 | 329F-491C-8E | PO5510117855 | 100 | 287 | 465 | 5 | 4 | 2023-12-24 | 44.08 | 1.10 | 2023-12-12 | 3 | 9.16 | 1 | 44.08 | 11 | SO53607 | 2023-12-19 | 3.53 | 27.48 | 14.69 | |||
SO55249_42 | 0527-4C9D-BA | PO13688172507 | 100 | 282 | 597 | 475 | 4 | 2024-01-23 | 323.99 | 8.10 | 2024-01-11 | 1 | 294.58 | 1 | 323.99 | 42 | SO55249 | 2024-01-18 | 25.92 | 294.58 | 323.99 | |||
SO50720_13 | 38E2-4AA6-B4 | PO9715181953 | 100 | 281 | 397 | 490 | 4 | 2023-09-23 | 72.88 | 1.82 | 2023-09-11 | 3 | 17.98 | 1 | 72.88 | 13 | SO50720 | 2023-09-18 | 5.83 | 53.93 | 24.29 | |||
SO57034_9 | 57D0-46D3-B7 | PO15689142548 | 100 | 281 | 372 | 328 | 4 | 2024-02-23 | 8796.06 | 219.90 | 2024-02-11 | 6 | 1554.95 | 1 | 8796.06 | 9 | SO57034 | 2024-02-18 | 703.68 | 9329.69 | 1466.01 | |||
SO69528_37 | 2644-4747-86 | PO6438163496 | 100 | 272 | 515 | 309 | 4 | 2024-08-23 | 32.54 | 0.81 | 2024-08-11 | 2 | 12.04 | 1 | 32.54 | 37 | SO69528 | 2024-08-18 | 2.60 | 24.08 | 16.27 | |||
SO71848_5 | 7082-4BF5-AB | PO18763153352 | 100 | 287 | 568 | 59 | 4 | 2024-09-23 | 890.82 | 22.27 | 2024-09-11 | 2 | 461.44 | 1 | 890.82 | 5 | SO71848 | 2024-09-18 | 71.27 | 922.89 | 445.41 | |||
SO44520_25 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 338 | 78 | 4 | 2022-02-23 | 419.46 | 10.49 | 2022-02-11 | 1 | 413.15 | 1 | 419.46 | 25 | SO44520 | 2022-02-18 | 33.56 | 413.15 | 419.46 | |||
SO50738_2 | 531C-4E52-80 | PO3915159731 | 100 | 281 | 448 | 130 | 4 | 2023-09-23 | 47.98 | 1.20 | 2023-09-11 | 4 | 8.25 | 1 | 47.98 | 2 | SO50738 | 2023-09-18 | 3.84 | 32.98 | 11.99 | |||
SO47056_16 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 453 | 403 | 4 | 2022-11-23 | 215.96 | 5.40 | 2022-11-11 | 6 | 24.75 | 1 | 215.96 | 16 | SO47056 | 2022-11-18 | 17.28 | 148.48 | 35.99 | |||
SO44564_2 | 142F-443C-90 | PO7656157194 | 100 | 282 | 272 | 403 | 4 | 2022-02-23 | 183.94 | 4.60 | 2022-02-11 | 1 | 181.49 | 1 | 183.94 | 2 | SO44564 | 2022-02-18 | 14.72 | 181.49 | 183.94 |
Generated 2024-11-10 04:39:18.763 UTC