[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '3' > SKIP 0 SHUFFLE < SKIP 2311 > < 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO44772_6 | F5E6-4B81-A3 | PO1624122637 | 100 | 283 | 314 | 579 | 3 | 2022-03-29 | 12881.77 | 322.04 | 2022-03-17 | 6 | 2171.29 | 1 | 12881.77 | 6 | SO44772 | 2022-03-24 | 1030.54 | 13027.77 | 2146.96 | |||
| SO71803_22 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 592 | 16 | 327 | 3 | 90.40 | 2024-09-27 | 226.00 | 3.39 | 2024-09-15 | 2 | 308.22 | 1 | 135.60 | 22 | SO71803 | 2024-09-22 | 10.85 | 616.44 | 113.00 | 0.40 |
| SO46671_3 | 13F6-4858-8D | PO8787194061 | 100 | 282 | 447 | 523 | 3 | 2022-10-27 | 150.00 | 3.75 | 2022-10-15 | 10 | 10.31 | 1 | 150.00 | 3 | SO46671 | 2022-10-22 | 12.00 | 103.13 | 15.00 | |||
| SO71798_19 | AFA9-4B18-AD | PO16994135863 | 100 | 283 | 374 | 306 | 3 | 2024-09-27 | 4398.03 | 109.95 | 2024-09-15 | 3 | 1554.95 | 1 | 4398.03 | 19 | SO71798 | 2024-09-22 | 351.84 | 4664.84 | 1466.01 | |||
| SO67280_10 | D663-42E1-A2 | PO12412130838 | 100 | 281 | 384 | 670 | 3 | 2024-07-28 | 2016.88 | 50.42 | 2024-07-16 | 3 | 713.08 | 1 | 2016.88 | 10 | SO67280 | 2024-07-23 | 161.35 | 2139.24 | 672.29 | |||
| SO67332_6 | E97E-4BCF-92 | PO6235122123 | 100 | 283 | 481 | 431 | 3 | 2024-07-28 | 21.58 | 0.54 | 2024-07-16 | 4 | 3.36 | 1 | 21.58 | 6 | SO67332 | 2024-07-23 | 1.73 | 13.45 | 5.39 | |||
| SO58928_16 | 6C1A-4E73-97 | PO15341119997 | 100 | 281 | 600 | 327 | 3 | 2024-03-28 | 1295.98 | 32.40 | 2024-03-16 | 4 | 294.58 | 1 | 1295.98 | 16 | SO58928 | 2024-03-23 | 103.68 | 1178.32 | 323.99 | |||
| SO71819_4 | DBA3-430C-8B | PO12354153257 | 100 | 283 | 363 | 197 | 3 | 2024-09-27 | 5507.98 | 137.70 | 2024-09-15 | 4 | 1251.98 | 1 | 5507.98 | 4 | SO71819 | 2024-09-22 | 440.64 | 5007.93 | 1376.99 | |||
| SO53454_7 | 278D-445A-99 | PO19633151350 | 100 | 287 | 298 | 149 | 3 | 2023-12-28 | 3239.04 | 80.98 | 2023-12-16 | 4 | 739.04 | 1 | 3239.04 | 7 | SO53454 | 2023-12-23 | 259.12 | 2956.16 | 809.76 | |||
| SO71803_42 | 9C57-4821-9B | PO15341174104 | 100 | 281 | 359 | 327 | 3 | 2024-09-27 | 11015.95 | 275.40 | 2024-09-15 | 8 | 1251.98 | 1 | 11015.95 | 42 | SO71803 | 2024-09-22 | 881.28 | 10015.85 | 1376.99 | |||
| SO44296_2 | DE85-42AB-AC | PO12412194442 | 100 | 283 | 342 | 670 | 3 | 2022-01-27 | 1677.84 | 41.95 | 2022-01-15 | 4 | 413.15 | 1 | 1677.84 | 2 | SO44296 | 2022-01-22 | 134.23 | 1652.59 | 419.46 | |||
| SO55324_25 | 35BE-456A-B8 | PO8787146999 | 100 | 282 | 436 | 523 | 3 | 2024-01-27 | 713.80 | 17.84 | 2024-01-15 | 2 | 360.94 | 1 | 713.80 | 25 | SO55324 | 2024-01-22 | 57.10 | 721.89 | 356.90 | |||
| SO46344_7 | BB3A-4D16-9E | PO14268133810 | 100 | 283 | 318 | 418 | 3 | 2022-09-27 | 874.79 | 21.87 | 2022-09-15 | 1 | 884.71 | 1 | 874.79 | 7 | SO46344 | 2022-09-22 | 69.98 | 884.71 | 874.79 | |||
| SO51717_12 | 9761-4974-87 | PO15254118280 | 100 | 283 | 482 | 377 | 3 | 2023-11-27 | 53.94 | 1.35 | 2023-11-15 | 10 | 3.36 | 1 | 53.94 | 12 | SO51717 | 2023-11-22 | 4.32 | 33.62 | 5.39 | |||
| SO43916_1 | 974B-4BFD-AC | PO8874186100 | 100 | 282 | 348 | 348 | 3 | 2021-11-27 | 10124.97 | 253.12 | 2021-11-15 | 5 | 1898.09 | 1 | 10124.97 | 1 | SO43916 | 2021-11-22 | 810.00 | 9490.47 | 2024.99 | |||
| SO53548_14 | CF97-4D6F-95 | PO14268111072 | 100 | 281 | 581 | 418 | 3 | 2023-12-28 | 5102.97 | 127.57 | 2023-12-16 | 5 | 1082.51 | 1 | 5102.97 | 14 | SO53548 | 2023-12-23 | 408.24 | 5412.55 | 1020.59 | |||
| SO46629_20 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 407 | 670 | 3 | 2022-10-27 | 196.81 | 4.92 | 2022-10-15 | 3 | 48.55 | 1 | 196.81 | 20 | SO46629 | 2022-10-22 | 15.74 | 145.64 | 65.60 | |||
| SO71884_28 | 5F6A-4027-A6 | PO7047195292 | 100 | 281 | 511 | 544 | 3 | 2024-09-27 | 218.45 | 5.46 | 2024-09-15 | 1 | 199.38 | 1 | 218.45 | 28 | SO71884 | 2024-09-22 | 17.48 | 199.38 | 218.45 | |||
| SO44079_13 | A180-4128-A7 | PO19488118734 | 100 | 283 | 229 | 57 | 3 | 2021-12-28 | 144.20 | 3.61 | 2021-12-16 | 5 | 31.72 | 1 | 144.20 | 13 | SO44079 | 2021-12-23 | 11.54 | 158.62 | 28.84 | |||
| SO51151_1 | D7A9-4DF6-B9 | PO8787179219 | 100 | 282 | 487 | 523 | 3 | 2023-10-27 | 263.95 | 6.60 | 2023-10-15 | 8 | 20.57 | 1 | 263.95 | 1 | SO51151 | 2023-10-22 | 21.12 | 164.53 | 32.99 | |||
| SO53499_15 | A47F-48AD-83 | PO12354126576 | 100 | 283 | 217 | 197 | 3 | 2023-12-28 | 62.98 | 1.57 | 2023-12-16 | 3 | 13.09 | 1 | 62.98 | 15 | SO53499 | 2023-12-23 | 5.04 | 39.26 | 20.99 | |||
| SO46980_23 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 377 | 527 | 3 | 2022-11-27 | 1308.94 | 32.72 | 2022-11-15 | 1 | 1320.68 | 1 | 1308.94 | 23 | SO46980 | 2022-11-22 | 104.72 | 1320.68 | 1308.94 | |||
| SO45785_8 | 695A-4F07-88 | PO15428114828 | 100 | 283 | 223 | 646 | 3 | 2022-07-28 | 20.75 | 0.52 | 2022-07-16 | 4 | 5.71 | 1 | 20.75 | 8 | SO45785 | 2022-07-23 | 1.66 | 22.82 | 5.19 | |||
| SO71779_35 | CD9F-4322-BC | PO19633118218 | 100 | 272 | 474 | 149 | 3 | 2024-09-27 | 293.96 | 7.35 | 2024-09-15 | 7 | 26.18 | 1 | 293.96 | 35 | SO71779 | 2024-09-22 | 23.52 | 183.23 | 41.99 | |||
| SO49837_34 | C136-4536-9D | PO12412160791 | 100 | 281 | 286 | 670 | 3 | 2023-07-28 | 1103.63 | 27.59 | 2023-07-16 | 6 | 170.14 | 1 | 1103.63 | 34 | SO49837 | 2023-07-23 | 88.29 | 1020.86 | 183.94 | |||
| SO48379_4 | 703B-461C-A7 | PO7018165155 | 100 | 283 | 456 | 695 | 3 | 2023-03-29 | 179.98 | 4.50 | 2023-03-17 | 4 | 30.93 | 1 | 179.98 | 4 | SO48379 | 2023-03-24 | 14.40 | 123.73 | 44.99 | |||
| SO57186_11 | EF93-4946-97 | PO8845159326 | 100 | 282 | 309 | 546 | 3 | 2024-02-27 | 4912.20 | 122.81 | 2024-02-15 | 6 | 747.20 | 1 | 4912.20 | 11 | SO57186 | 2024-02-22 | 392.98 | 4483.20 | 818.70 | |||
| SO47996_10 | B6EA-4582-9E | PO15370152849 | 100 | 283 | 395 | 381 | 3 | 2023-02-27 | 490.99 | 12.27 | 2023-02-15 | 8 | 45.42 | 1 | 490.99 | 10 | SO47996 | 2023-02-22 | 39.28 | 363.33 | 61.37 | |||
| SO51149_8 | E0BD-412F-A7 | PO6235137860 | 100 | 283 | 231 | 431 | 3 | 2023-10-27 | 59.99 | 1.50 | 2023-10-15 | 2 | 38.49 | 1 | 59.99 | 8 | SO51149 | 2023-10-22 | 4.80 | 76.98 | 29.99 | |||
| SO50322_20 | 4BC2-4C6D-83 | PO8845166508 | 100 | 282 | 224 | 546 | 3 | 2023-08-27 | 20.75 | 0.52 | 2023-08-15 | 4 | 5.23 | 1 | 20.75 | 20 | SO50322 | 2023-08-22 | 1.66 | 20.92 | 5.19 | |||
| SO55238_15 | 3BEA-42A3-9A | PO19314197881 | 100 | 281 | 434 | 622 | 3 | 2024-01-27 | 356.90 | 8.92 | 2024-01-15 | 1 | 360.94 | 1 | 356.90 | 15 | SO55238 | 2024-01-22 | 28.55 | 360.94 | 356.90 |
Generated 2024-11-14 05:22:45.044 UTC