[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 235 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63223_16 | 70F5-4AD9-A9 | PO13427118669 | 100 | 292 | 483 | 2 | 638 | 7 | 15.31 | 2024-05-25 | 765.60 | 18.76 | 2024-05-13 | 11 | 44.88 | 1 | 750.29 | 16 | SO63223 | 2024-05-20 | 60.02 | 493.68 | 69.60 | 0.02 |
SO46652_34 | D7E0-44F6-86 | PO3509195138 | 36 | 292 | 216 | 8 | 139 | 7 | 18.50 | 2022-10-23 | 185.04 | 4.16 | 2022-10-11 | 11 | 13.88 | 1 | 166.54 | 34 | SO46652 | 2022-10-18 | 13.32 | 152.66 | 16.82 | 0.10 |
SO53475_1 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 545 | 481 | 7 | 2023-12-24 | 24.29 | 0.61 | 2023-12-12 | 1 | 17.98 | 1 | 24.29 | 1 | SO53475 | 2023-12-19 | 1.94 | 17.98 | 24.29 | |||
SO46627_4 | A7A2-45B6-97 | PO13485114699 | 100 | 292 | 460 | 265 | 7 | 2022-10-23 | 323.96 | 8.10 | 2022-10-11 | 6 | 37.12 | 1 | 323.96 | 4 | SO46627 | 2022-10-18 | 25.92 | 222.73 | 53.99 | |||
SO71855_1 | 7E9B-4F60-8E | PO18589189353 | 100 | 292 | 606 | 67 | 7 | 2024-09-23 | 323.99 | 8.10 | 2024-09-11 | 1 | 343.65 | 1 | 323.99 | 1 | SO71855 | 2024-09-18 | 25.92 | 343.65 | 323.99 | |||
SO46627_9 | A7A2-45B6-97 | PO13485114699 | 100 | 292 | 360 | 265 | 7 | 2022-10-23 | 3688.38 | 92.21 | 2022-10-11 | 3 | 1105.81 | 1 | 3688.38 | 9 | SO46627 | 2022-10-18 | 295.07 | 3317.43 | 1229.46 | |||
SO51104_17 | D008-4004-A4 | PO13340177593 | 100 | 292 | 533 | 355 | 7 | 2023-10-23 | 299.75 | 7.49 | 2023-10-11 | 2 | 136.79 | 1 | 299.75 | 17 | SO51104 | 2023-10-18 | 23.98 | 273.57 | 149.87 | |||
SO65208_2 | EC05-4765-B6 | PO1450163231 | 100 | 292 | 359 | 571 | 7 | 2024-06-23 | 2753.99 | 68.85 | 2024-06-11 | 2 | 1251.98 | 1 | 2753.99 | 2 | SO65208 | 2024-06-18 | 220.32 | 2503.96 | 1376.99 | |||
SO71801_20 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 584 | 481 | 7 | 2024-09-23 | 647.99 | 16.20 | 2024-09-11 | 2 | 343.65 | 1 | 647.99 | 20 | SO71801 | 2024-09-18 | 51.84 | 687.30 | 323.99 | |||
SO69429_19 | 3A09-48B2-AA | PO13369166572 | 100 | 292 | 481 | 391 | 7 | 2024-08-23 | 43.15 | 1.08 | 2024-08-11 | 8 | 3.36 | 1 | 43.15 | 19 | SO69429 | 2024-08-18 | 3.45 | 26.90 | 5.39 | |||
SO48763_14 | 06A5-45C0-A2 | PO3509163189 | 36 | 292 | 343 | 139 | 7 | 2023-04-25 | 939.59 | 23.49 | 2023-04-13 | 2 | 486.71 | 1 | 939.59 | 14 | SO48763 | 2023-04-20 | 75.17 | 973.41 | 469.79 | |||
SO51168_1 | 10E0-426C-9D | PO3509110394 | 36 | 292 | 606 | 139 | 7 | 2023-10-23 | 647.99 | 16.20 | 2023-10-11 | 2 | 343.65 | 1 | 647.99 | 1 | SO51168 | 2023-10-18 | 51.84 | 687.30 | 323.99 | |||
SO49833_24 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 427 | 355 | 7 | 2023-07-24 | 209.26 | 5.23 | 2023-07-12 | 1 | 185.82 | 1 | 209.26 | 24 | SO49833 | 2023-07-19 | 16.74 | 185.82 | 209.26 | |||
SO47678_5 | 9125-42C2-9B | PO13485115736 | 100 | 292 | 358 | 265 | 7 | 2023-01-23 | 3688.38 | 92.21 | 2023-01-11 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO47678 | 2023-01-18 | 295.07 | 3317.43 | 1229.46 | |||
SO63179_6 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 516 | 535 | 7 | 2024-05-25 | 70.45 | 1.76 | 2024-05-13 | 3 | 17.38 | 1 | 70.45 | 6 | SO63179 | 2024-05-20 | 5.64 | 52.13 | 23.48 | |||
SO46981_28 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 337 | 638 | 7 | 2022-11-23 | 1879.18 | 46.98 | 2022-11-11 | 4 | 486.71 | 1 | 1879.18 | 28 | SO46981 | 2022-11-18 | 150.33 | 1946.83 | 469.79 | |||
SO53475_6 | FFE3-4820-88 | PO15515192405 | 100 | 292 | 584 | 481 | 7 | 2023-12-24 | 2591.95 | 64.80 | 2023-12-12 | 8 | 343.65 | 1 | 2591.95 | 6 | SO53475 | 2023-12-19 | 207.36 | 2749.20 | 323.99 | |||
SO69464_10 | 8924-465B-BE | PO2668146931 | 100 | 292 | 601 | 535 | 7 | 2024-08-23 | 64.79 | 1.62 | 2024-08-11 | 2 | 23.97 | 1 | 64.79 | 10 | SO69464 | 2024-08-18 | 5.18 | 47.94 | 32.39 | |||
SO69431_2 | CD00-4F2A-B8 | PO13166196609 | 100 | 292 | 359 | 656 | 7 | 2024-08-23 | 4130.98 | 103.27 | 2024-08-11 | 3 | 1251.98 | 1 | 4130.98 | 2 | SO69431 | 2024-08-18 | 330.48 | 3755.94 | 1376.99 | |||
SO69447_26 | 1C7A-4B97-AA | PO11223139140 | 100 | 292 | 556 | 632 | 7 | 2024-08-23 | 105.29 | 2.63 | 2024-08-11 | 1 | 77.92 | 1 | 105.29 | 26 | SO69447 | 2024-08-18 | 8.42 | 77.92 | 105.29 | |||
SO55311_16 | 2309-401E-BD | PO3509171799 | 36 | 292 | 465 | 139 | 7 | 2024-01-23 | 117.55 | 2.94 | 2024-01-11 | 8 | 9.16 | 1 | 117.55 | 16 | SO55311 | 2024-01-18 | 9.40 | 73.27 | 14.69 | |||
SO63217_4 | 4893-4FE9-B2 | PO13108196385 | 100 | 292 | 567 | 103 | 7 | 2024-05-25 | 890.82 | 22.27 | 2024-05-13 | 2 | 461.44 | 1 | 890.82 | 4 | SO63217 | 2024-05-20 | 71.27 | 922.89 | 445.41 | |||
SO48010_19 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 297 | 175 | 7 | 2023-02-23 | 3680.73 | 92.02 | 2023-02-11 | 5 | 653.70 | 1 | 3680.73 | 19 | SO48010 | 2023-02-18 | 294.46 | 3268.49 | 736.15 | |||
SO51104_27 | D008-4004-A4 | PO13340177593 | 100 | 292 | 600 | 355 | 7 | 2023-10-23 | 647.99 | 16.20 | 2023-10-11 | 2 | 294.58 | 1 | 647.99 | 27 | SO51104 | 2023-10-18 | 51.84 | 589.16 | 323.99 |
Generated 2024-11-10 12:32:34.749 UTC