[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 2423 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48063_31 | AEA4-4489-90 | PO5858143254 | 100 | 285 | 393 | 566 | 5 | 2023-01-03 | 688.47 | 17.21 | 2022-12-22 | 5 | 101.89 | 1 | 688.47 | 31 | SO48063 | 2022-12-29 | 55.08 | 509.47 | 137.69 | |||
SO49836_7 | 0E32-48F7-89 | PO12644185975 | 100 | 285 | 216 | 530 | 5 | 2023-06-03 | 60.56 | 1.51 | 2023-05-22 | 3 | 13.88 | 1 | 60.56 | 7 | SO49836 | 2023-05-29 | 4.84 | 41.63 | 20.19 | |||
SO45329_10 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 212 | 566 | 5 | 2022-04-05 | 80.75 | 2.02 | 2022-03-24 | 4 | 12.03 | 1 | 80.75 | 10 | SO45329 | 2022-03-31 | 6.46 | 48.11 | 20.19 | |||
SO51137_23 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 516 | 494 | 5 | 2023-09-02 | 93.94 | 2.35 | 2023-08-21 | 4 | 17.38 | 1 | 93.94 | 23 | SO51137 | 2023-08-28 | 7.51 | 69.51 | 23.48 | |||
SO46933_31 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 387 | 206 | 5 | 2022-10-03 | 1200.53 | 30.01 | 2022-09-21 | 2 | 605.65 | 1 | 1200.53 | 31 | SO46933 | 2022-09-28 | 96.04 | 1211.30 | 600.26 | |||
SO50756_3 | C414-447C-84 | PO9570119689 | 100 | 285 | 230 | 585 | 5 | 2023-08-03 | 57.68 | 1.44 | 2023-07-22 | 2 | 29.08 | 1 | 57.68 | 3 | SO50756 | 2023-07-29 | 4.61 | 58.16 | 28.84 | |||
SO71948_1 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 606 | 170 | 5 | 2024-08-03 | 971.98 | 24.30 | 2024-07-22 | 3 | 343.65 | 1 | 971.98 | 1 | SO71948 | 2024-07-29 | 77.76 | 1030.95 | 323.99 | |||
SO45329_15 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 350 | 566 | 5 | 2022-04-05 | 4049.99 | 101.25 | 2022-03-24 | 2 | 1898.09 | 1 | 4049.99 | 15 | SO45329 | 2022-03-31 | 324.00 | 3796.19 | 2024.99 | |||
SO47965_8 | 953F-437D-84 | PO19546111394 | 100 | 285 | 286 | 206 | 5 | 2023-01-03 | 367.88 | 9.20 | 2022-12-22 | 2 | 170.14 | 1 | 367.88 | 8 | SO47965 | 2022-12-29 | 29.43 | 340.29 | 183.94 | |||
SO45802_16 | 8C6D-42B3-AA | PO1189157476 | 100 | 285 | 316 | 423 | 5 | 2022-06-03 | 1749.59 | 43.74 | 2022-05-22 | 2 | 884.71 | 1 | 1749.59 | 16 | SO45802 | 2022-05-29 | 139.97 | 1769.42 | 874.79 | |||
SO47726_7 | 7256-4599-93 | PO9657190563 | 100 | 285 | 421 | 315 | 5 | 2022-12-03 | 588.99 | 14.72 | 2022-11-21 | 3 | 145.28 | 1 | 588.99 | 7 | SO47726 | 2022-11-28 | 47.12 | 435.85 | 196.33 | |||
SO46630_24 | F512-40F2-91 | PO12644161356 | 100 | 285 | 445 | 530 | 5 | 2022-09-02 | 71.99 | 1.80 | 2022-08-21 | 2 | 24.75 | 1 | 71.99 | 24 | SO46630 | 2022-08-28 | 5.76 | 49.49 | 35.99 | |||
SO69513_6 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 408 | 45 | 5 | 2024-07-03 | 144.32 | 3.61 | 2024-06-21 | 2 | 53.40 | 1 | 144.32 | 6 | SO69513 | 2024-06-28 | 11.55 | 106.80 | 72.16 | |||
SO53524_31 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 495 | 611 | 5 | 2023-11-03 | 1807.04 | 45.18 | 2023-10-22 | 3 | 601.74 | 1 | 1807.04 | 31 | SO53524 | 2023-10-29 | 144.56 | 1805.23 | 602.35 | |||
SO46604_21 | 8062-4A97-B3 | PO522154989 | 100 | 285 | 233 | 676 | 5 | 2022-09-02 | 201.88 | 5.05 | 2022-08-21 | 7 | 29.08 | 1 | 201.88 | 21 | SO46604 | 2022-08-28 | 16.15 | 203.56 | 28.84 | |||
SO69513_2 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 386 | 45 | 5 | 2024-07-03 | 672.29 | 16.81 | 2024-06-21 | 1 | 713.08 | 1 | 672.29 | 2 | SO69513 | 2024-06-28 | 53.78 | 713.08 | 672.29 | |||
SO46033_1 | 253E-48E3-85 | PO18560157809 | 100 | 285 | 332 | 531 | 5 | 2022-07-03 | 838.92 | 20.97 | 2022-06-21 | 2 | 413.15 | 1 | 838.92 | 1 | SO46033 | 2022-06-28 | 67.11 | 826.29 | 419.46 | |||
SO53625_1 | 98EA-458A-B9 | PO9744185498 | 100 | 285 | 400 | 98 | 5 | 2023-11-03 | 37.15 | 0.93 | 2023-10-22 | 1 | 27.49 | 1 | 37.15 | 1 | SO53625 | 2023-10-29 | 2.97 | 27.49 | 37.15 | |||
SO46028_8 | 7BBE-413C-83 | PO19546126425 | 100 | 285 | 312 | 206 | 5 | 2022-07-03 | 2146.96 | 53.67 | 2022-06-21 | 1 | 2171.29 | 1 | 2146.96 | 8 | SO46028 | 2022-06-28 | 171.76 | 2171.29 | 2146.96 | |||
SO53474_31 | E5B6-4103-8D | PO15457187993 | 100 | 285 | 556 | 297 | 5 | 2023-11-03 | 210.59 | 5.26 | 2023-10-22 | 2 | 77.92 | 1 | 210.59 | 31 | SO53474 | 2023-10-29 | 16.85 | 155.84 | 105.29 | |||
SO47053_11 | 686D-414B-82 | PO7598127510 | 100 | 285 | 407 | 45 | 5 | 2022-10-03 | 65.60 | 1.64 | 2022-09-21 | 1 | 48.55 | 1 | 65.60 | 11 | SO47053 | 2022-09-28 | 5.25 | 48.55 | 65.60 | |||
SO71866_14 | 029A-46BE-80 | PO14297151936 | 100 | 285 | 500 | 627 | 5 | 2024-08-03 | 1204.69 | 30.12 | 2024-07-22 | 2 | 601.74 | 1 | 1204.69 | 14 | SO71866 | 2024-07-29 | 96.38 | 1203.49 | 602.35 | |||
SO49822_5 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 354 | 676 | 5 | 2023-06-03 | 2485.70 | 62.14 | 2023-05-22 | 2 | 1117.86 | 1 | 2485.70 | 5 | SO49822 | 2023-05-29 | 198.86 | 2235.71 | 1242.85 | |||
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 | |||
SO47416_2 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 254 | 90 | 5 | 2022-11-03 | 1471.51 | 36.79 | 2022-10-22 | 8 | 170.14 | 1 | 1471.51 | 2 | SO47416 | 2022-10-29 | 117.72 | 1361.14 | 183.94 | |||
SO65207_26 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 234 | 611 | 5 | 2024-05-03 | 89.98 | 2.25 | 2024-04-21 | 3 | 38.49 | 1 | 89.98 | 26 | SO65207 | 2024-04-28 | 7.20 | 115.48 | 29.99 | |||
SO43875_10 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 346 | 2 | 278 | 5 | 473.28 | 2021-10-03 | 23663.93 | 579.77 | 2021-09-21 | 12 | 1912.15 | 1 | 23190.65 | 10 | SO43875 | 2021-09-28 | 1855.25 | 22945.85 | 1971.99 | 0.02 |
SO57126_8 | 6350-4E4D-85 | PO7598164370 | 100 | 285 | 243 | 45 | 5 | 2024-01-03 | 2576.70 | 64.42 | 2023-12-22 | 3 | 868.63 | 1 | 2576.70 | 8 | SO57126 | 2023-12-29 | 206.14 | 2605.90 | 858.90 | |||
SO47416_23 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 331 | 90 | 5 | 2022-11-03 | 2818.76 | 70.47 | 2022-10-22 | 6 | 486.71 | 1 | 2818.76 | 23 | SO47416 | 2022-10-29 | 225.50 | 2920.24 | 469.79 | |||
SO47067_17 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 239 | 135 | 5 | 2022-10-03 | 780.82 | 19.52 | 2022-09-21 | 1 | 722.26 | 1 | 780.82 | 17 | SO47067 | 2022-09-28 | 62.47 | 722.26 | 780.82 |
Generated 2024-09-20 06:22:42.175 UTC