[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE SKIP 2298 < SKIP 1062 > < TAKE 31 >
31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO49124_1 | 795F-4192-AD | PO3596184634 | 100 | 285 | 358 | 476 | 5 | 2023-05-30 | 8606.21 | 215.16 | 2023-05-18 | 7 | 1105.81 | 1 | 8606.21 | 1 | SO49124 | 2023-05-25 | 688.50 | 7740.67 | 1229.46 | |||
SO51108_35 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 231 | 530 | 5 | 2023-10-27 | 149.97 | 3.75 | 2023-10-15 | 5 | 38.49 | 1 | 149.97 | 35 | SO51108 | 2023-10-22 | 12.00 | 192.46 | 29.99 | |||
SO49878_8 | 3EF0-4F28-B3 | PO3741190259 | 100 | 285 | 456 | 404 | 5 | 2023-07-28 | 179.98 | 4.50 | 2023-07-16 | 4 | 30.93 | 1 | 179.98 | 8 | SO49878 | 2023-07-23 | 14.40 | 123.73 | 44.99 | |||
SO45337_14 | C8D2-41D4-AF | PO7598166612 | 100 | 285 | 310 | 45 | 5 | 2022-05-30 | 2146.96 | 53.67 | 2022-05-18 | 1 | 2171.29 | 1 | 2146.96 | 14 | SO45337 | 2022-05-25 | 171.76 | 2171.29 | 2146.96 | |||
SO47454_35 | E249-41EE-95 | PO9570119946 | 100 | 285 | 464 | 585 | 5 | 2022-12-28 | 14.13 | 0.35 | 2022-12-16 | 1 | 9.71 | 1 | 14.13 | 35 | SO47454 | 2022-12-23 | 1.13 | 9.71 | 14.13 | |||
SO61230_27 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 596 | 530 | 5 | 2024-04-28 | 971.98 | 24.30 | 2024-04-16 | 3 | 294.58 | 1 | 971.98 | 27 | SO61230 | 2024-04-23 | 77.76 | 883.74 | 323.99 | |||
SO46673_14 | 578D-4F7B-A6 | PO9657163155 | 100 | 285 | 459 | 315 | 5 | 2022-10-27 | 107.99 | 2.70 | 2022-10-15 | 2 | 37.12 | 1 | 107.99 | 14 | SO46673 | 2022-10-22 | 8.64 | 74.24 | 53.99 | |||
SO44132_1 | E16E-4A80-9A | PO9570191688 | 100 | 285 | 351 | 585 | 5 | 2021-12-28 | 4049.99 | 101.25 | 2021-12-16 | 2 | 1898.09 | 1 | 4049.99 | 1 | SO44132 | 2021-12-23 | 324.00 | 3796.19 | 2024.99 | |||
SO55328_40 | 577D-4DE9-B6 | PO9831188161 | 100 | 285 | 217 | 2 | 81 | 5 | 4.46 | 2024-01-27 | 223.24 | 5.47 | 2024-01-15 | 11 | 13.09 | 1 | 218.77 | 40 | SO55328 | 2024-01-22 | 17.50 | 143.95 | 20.29 | 0.02 |
SO71839_26 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 573 | 611 | 5 | 2024-09-27 | 8582.65 | 214.57 | 2024-09-15 | 6 | 1481.94 | 1 | 8582.65 | 26 | SO71839 | 2024-09-22 | 686.61 | 8891.63 | 1430.44 | |||
SO46045_27 | 9345-48CB-A5 | PO16327127643 | 100 | 285 | 310 | 584 | 5 | 2022-08-27 | 4293.92 | 107.35 | 2022-08-15 | 2 | 2171.29 | 1 | 4293.92 | 27 | SO46045 | 2022-08-22 | 343.51 | 4342.59 | 2146.96 | |||
SO67348_21 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 511 | 494 | 5 | 2024-07-28 | 655.36 | 16.38 | 2024-07-16 | 3 | 199.38 | 1 | 655.36 | 21 | SO67348 | 2024-07-23 | 52.43 | 598.13 | 218.45 | |||
SO47416_39 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 221 | 90 | 5 | 2022-12-28 | 100.93 | 2.52 | 2022-12-16 | 5 | 13.88 | 1 | 100.93 | 39 | SO47416 | 2022-12-23 | 8.07 | 69.39 | 20.19 | |||
SO47067_14 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 233 | 3 | 135 | 5 | 19.83 | 2022-11-27 | 396.56 | 9.42 | 2022-11-15 | 15 | 29.08 | 1 | 376.73 | 14 | SO47067 | 2022-11-22 | 30.14 | 436.21 | 26.44 | 0.05 |
SO45796_3 | 8929-4623-95 | PO11861125955 | 100 | 281 | 232 | 17 | 5 | 2022-07-28 | 57.68 | 1.44 | 2022-07-16 | 2 | 31.72 | 1 | 57.68 | 3 | SO45796 | 2022-07-23 | 4.61 | 63.45 | 28.84 | |||
SO71839_41 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 523 | 611 | 5 | 2024-09-27 | 31.58 | 0.79 | 2024-09-15 | 1 | 23.37 | 1 | 31.58 | 41 | SO71839 | 2024-09-22 | 2.53 | 23.37 | 31.58 | |||
SO51147_46 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 482 | 81 | 5 | 2023-10-27 | 5.39 | 0.13 | 2023-10-15 | 1 | 3.36 | 1 | 5.39 | 46 | SO51147 | 2023-10-22 | 0.43 | 3.36 | 5.39 | |||
SO46971_11 | 5CEA-463B-A2 | PO15051144269 | 100 | 285 | 410 | 207 | 5 | 2022-11-27 | 109.34 | 2.73 | 2022-11-15 | 3 | 26.97 | 1 | 109.34 | 11 | SO46971 | 2022-11-22 | 8.75 | 80.91 | 36.45 | |||
SO48359_25 | BFAE-4CA5-83 | PO2813116854 | 100 | 272 | 454 | 90 | 5 | 2023-03-29 | 71.99 | 1.80 | 2023-03-17 | 2 | 24.75 | 1 | 71.99 | 25 | SO48359 | 2023-03-24 | 5.76 | 49.49 | 35.99 | |||
SO44133_16 | 4899-4DD6-93 | PO9599144193 | 100 | 285 | 332 | 170 | 5 | 2021-12-28 | 419.46 | 10.49 | 2021-12-16 | 1 | 413.15 | 1 | 419.46 | 16 | SO44133 | 2021-12-23 | 33.56 | 413.15 | 419.46 | |||
SO71942_6 | A5F9-49B1-92 | PO9222123146 | 100 | 285 | 605 | 171 | 5 | 2024-09-27 | 323.99 | 8.10 | 2024-09-15 | 1 | 343.65 | 1 | 323.99 | 6 | SO71942 | 2024-09-22 | 25.92 | 343.65 | 323.99 | |||
SO69513_14 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 482 | 45 | 5 | 2024-08-27 | 26.97 | 0.67 | 2024-08-15 | 5 | 3.36 | 1 | 26.97 | 14 | SO69513 | 2024-08-22 | 2.16 | 16.81 | 5.39 | |||
SO45288_7 | D4D0-4662-A9 | PO16327170541 | 100 | 285 | 314 | 584 | 5 | 2022-05-30 | 2146.96 | 53.67 | 2022-05-18 | 1 | 2171.29 | 1 | 2146.96 | 7 | SO45288 | 2022-05-25 | 171.76 | 2171.29 | 2146.96 | |||
SO67349_38 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 546 | 81 | 5 | 2024-07-28 | 74.51 | 1.86 | 2024-07-16 | 2 | 27.57 | 1 | 74.51 | 38 | SO67349 | 2024-07-23 | 5.96 | 55.14 | 37.25 | |||
SO45329_15 | CFFE-4184-BD | PO5858128971 | 100 | 285 | 350 | 566 | 5 | 2022-05-30 | 4049.99 | 101.25 | 2022-05-18 | 2 | 1898.09 | 1 | 4049.99 | 15 | SO45329 | 2022-05-25 | 324.00 | 3796.19 | 2024.99 | |||
SO67349_30 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 483 | 81 | 5 | 2024-07-28 | 288.00 | 7.20 | 2024-07-16 | 4 | 44.88 | 1 | 288.00 | 30 | SO67349 | 2024-07-23 | 23.04 | 179.52 | 72.00 | |||
SO65259_1 | A72A-4E95-A8 | PO9251144255 | 100 | 285 | 570 | 351 | 5 | 2024-06-27 | 445.41 | 11.14 | 2024-06-15 | 1 | 461.44 | 1 | 445.41 | 1 | SO65259 | 2024-06-22 | 35.63 | 461.44 | 445.41 | |||
SO49822_13 | 191D-4AD7-93 | PO522119337 | 100 | 285 | 230 | 676 | 5 | 2023-07-28 | 86.52 | 2.16 | 2023-07-16 | 3 | 29.08 | 1 | 86.52 | 13 | SO49822 | 2023-07-23 | 6.92 | 87.24 | 28.84 | |||
SO71950_3 | 7D5C-49FE-BA | PO9744193484 | 100 | 285 | 476 | 98 | 5 | 2024-09-27 | 251.96 | 6.30 | 2024-09-15 | 6 | 26.18 | 1 | 251.96 | 3 | SO71950 | 2024-09-22 | 20.16 | 157.06 | 41.99 | |||
SO51853_13 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 600 | 476 | 5 | 2023-11-27 | 647.99 | 16.20 | 2023-11-15 | 2 | 294.58 | 1 | 647.99 | 13 | SO51853 | 2023-11-22 | 51.84 | 589.16 | 323.99 | |||
SO45062_2 | 017E-486E-BC | PO1189166374 | 100 | 285 | 324 | 423 | 5 | 2022-04-29 | 419.46 | 10.49 | 2022-04-17 | 1 | 413.15 | 1 | 419.46 | 2 | SO45062 | 2022-04-24 | 33.56 | 413.15 | 419.46 |
Generated 2024-11-14 07:39:54.900 UTC