[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 3000 SHUFFLE < SKIP 2031 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63246_13 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 436 | 45 | 5 | 2024-05-29 | 356.90 | 8.92 | 2024-05-17 | 1 | 360.94 | 1 | 356.90 | 13 | SO63246 | 2024-05-24 | 28.55 | 360.94 | 356.90 | |||
SO47053_15 | 686D-414B-82 | PO7598127510 | 100 | 285 | 424 | 45 | 5 | 2022-11-27 | 856.94 | 21.42 | 2022-11-15 | 4 | 158.53 | 1 | 856.94 | 15 | SO47053 | 2022-11-22 | 68.56 | 634.14 | 214.24 | |||
SO47042_46 | 42DB-4E2E-B9 | PO5858114009 | 100 | 285 | 216 | 566 | 5 | 2022-11-27 | 121.12 | 3.03 | 2022-11-15 | 6 | 13.88 | 1 | 121.12 | 46 | SO47042 | 2022-11-22 | 9.69 | 83.27 | 20.19 | |||
SO65207_24 | B20E-440F-A3 | PO1537156240 | 100 | 285 | 562 | 611 | 5 | 2024-06-27 | 4291.33 | 107.28 | 2024-06-15 | 3 | 1481.94 | 1 | 4291.33 | 24 | SO65207 | 2024-06-22 | 343.31 | 4445.81 | 1430.44 | |||
SO69565_4 | F165-437F-B9 | PO9773181473 | 100 | 285 | 572 | 8 | 5 | 2024-08-27 | 445.41 | 11.14 | 2024-08-15 | 1 | 461.44 | 1 | 445.41 | 4 | SO69565 | 2024-08-22 | 35.63 | 461.44 | 445.41 | |||
SO67348_4 | 4BD1-4782-A3 | PO9889141767 | 100 | 285 | 524 | 494 | 5 | 2024-07-28 | 316.86 | 7.92 | 2024-07-16 | 2 | 144.59 | 1 | 316.86 | 4 | SO67348 | 2024-07-23 | 25.35 | 289.19 | 158.43 | |||
SO63181_1 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 545 | 700 | 5 | 2024-05-29 | 48.59 | 1.21 | 2024-05-17 | 2 | 17.98 | 1 | 48.59 | 1 | SO63181 | 2024-05-24 | 3.89 | 35.96 | 24.29 | |||
SO69465_25 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 408 | 700 | 5 | 2024-08-27 | 72.16 | 1.80 | 2024-08-15 | 1 | 53.40 | 1 | 72.16 | 25 | SO69465 | 2024-08-22 | 5.77 | 53.40 | 72.16 | |||
SO46630_32 | F512-40F2-91 | PO12644161356 | 100 | 285 | 367 | 530 | 5 | 2022-10-27 | 4535.96 | 113.40 | 2022-10-15 | 7 | 598.44 | 1 | 4535.96 | 32 | SO46630 | 2022-10-22 | 362.88 | 4189.05 | 647.99 | |||
SO65242_13 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 561 | 627 | 5 | 2024-06-27 | 1430.44 | 35.76 | 2024-06-15 | 1 | 1481.94 | 1 | 1430.44 | 13 | SO65242 | 2024-06-22 | 114.44 | 1481.94 | 1430.44 | |||
SO46636_1 | F0E4-4F58-AB | PO9889175865 | 100 | 285 | 412 | 494 | 5 | 2022-10-27 | 180.13 | 4.50 | 2022-10-15 | 1 | 133.30 | 1 | 180.13 | 1 | SO46636 | 2022-10-22 | 14.41 | 133.30 | 180.13 | |||
SO57064_9 | EDFD-4B3C-AF | PO11542177395 | 100 | 285 | 606 | 62 | 5 | 2024-02-27 | 971.98 | 24.30 | 2024-02-15 | 3 | 343.65 | 1 | 971.98 | 9 | SO57064 | 2024-02-22 | 77.76 | 1030.95 | 323.99 | |||
SO57107_1 | DFFB-43D1-B0 | PO17255149267 | 100 | 285 | 576 | 80 | 5 | 2024-02-27 | 4291.33 | 107.28 | 2024-02-15 | 3 | 1481.94 | 1 | 4291.33 | 1 | SO57107 | 2024-02-22 | 343.31 | 4445.81 | 1430.44 | |||
SO47416_30 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 242 | 90 | 5 | 2022-12-28 | 2342.45 | 58.56 | 2022-12-16 | 3 | 722.26 | 1 | 2342.45 | 30 | SO47416 | 2022-12-23 | 187.40 | 2166.77 | 780.82 | |||
SO53524_17 | 2B2B-440F-8B | PO1537151724 | 100 | 285 | 576 | 611 | 5 | 2023-12-28 | 5721.77 | 143.04 | 2023-12-16 | 4 | 1481.94 | 1 | 5721.77 | 17 | SO53524 | 2023-12-23 | 457.74 | 5927.75 | 1430.44 | |||
SO53551_34 | 8593-405C-AB | PO14297167079 | 100 | 285 | 586 | 13 | 627 | 5 | 150.33 | 2023-12-28 | 1002.17 | 21.30 | 2023-12-16 | 3 | 461.44 | 1 | 851.85 | 34 | SO53551 | 2023-12-23 | 68.15 | 1384.33 | 334.06 | 0.15 |
SO53540_8 | 1C52-4046-BA | PO18241135767 | 100 | 285 | 586 | 13 | 477 | 5 | 100.22 | 2023-12-28 | 668.12 | 14.20 | 2023-12-16 | 2 | 461.44 | 1 | 567.90 | 8 | SO53540 | 2023-12-23 | 45.43 | 922.89 | 334.06 | 0.15 |
SO46933_6 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 335 | 206 | 5 | 2022-11-27 | 469.79 | 11.74 | 2022-11-15 | 1 | 486.71 | 1 | 469.79 | 6 | SO46933 | 2022-11-22 | 37.58 | 486.71 | 469.79 | |||
SO46654_14 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 221 | 8 | 404 | 5 | 3.36 | 2022-10-27 | 33.64 | 0.76 | 2022-10-15 | 2 | 13.88 | 1 | 30.28 | 14 | SO46654 | 2022-10-22 | 2.42 | 27.76 | 16.82 | 0.10 |
SO50307_1 | C275-40B9-98 | PO6293157460 | 100 | 285 | 407 | 612 | 5 | 2023-08-27 | 65.60 | 1.64 | 2023-08-15 | 1 | 48.55 | 1 | 65.60 | 1 | SO50307 | 2023-08-22 | 5.25 | 48.55 | 65.60 | |||
SO47026_21 | 123B-481F-8F | PO3596190739 | 100 | 285 | 420 | 476 | 5 | 2022-11-27 | 566.46 | 14.16 | 2022-11-15 | 4 | 104.80 | 1 | 566.46 | 21 | SO47026 | 2022-11-22 | 45.32 | 419.18 | 141.62 | |||
SO57104_10 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 606 | 531 | 5 | 2024-02-27 | 647.99 | 16.20 | 2024-02-15 | 2 | 343.65 | 1 | 647.99 | 10 | SO57104 | 2024-02-22 | 51.84 | 687.30 | 323.99 | |||
SO71839_17 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 487 | 2 | 611 | 5 | 7.65 | 2024-09-27 | 382.73 | 9.38 | 2024-09-15 | 12 | 20.57 | 1 | 375.08 | 17 | SO71839 | 2024-09-22 | 30.01 | 246.80 | 31.89 | 0.02 |
SO51081_14 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 544 | 676 | 5 | 2023-10-27 | 145.78 | 3.64 | 2023-10-15 | 3 | 35.96 | 1 | 145.78 | 14 | SO51081 | 2023-10-22 | 11.66 | 107.88 | 48.59 | |||
SO53530_13 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 605 | 90 | 5 | 2023-12-28 | 3239.94 | 81.00 | 2023-12-16 | 10 | 343.65 | 1 | 3239.94 | 13 | SO53530 | 2023-12-23 | 259.20 | 3436.50 | 323.99 | |||
SO47416_15 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 454 | 90 | 5 | 2022-12-28 | 215.96 | 5.40 | 2022-12-16 | 6 | 24.75 | 1 | 215.96 | 15 | SO47416 | 2022-12-23 | 17.28 | 148.48 | 35.99 | |||
SO46630_39 | F512-40F2-91 | PO12644161356 | 100 | 285 | 461 | 530 | 5 | 2022-10-27 | 161.98 | 4.05 | 2022-10-15 | 3 | 37.12 | 1 | 161.98 | 39 | SO46630 | 2022-10-22 | 12.96 | 111.36 | 53.99 | |||
SO47416_49 | 6B45-44AB-84 | PO2813155355 | 100 | 281 | 407 | 90 | 5 | 2022-12-28 | 262.41 | 6.56 | 2022-12-16 | 4 | 48.55 | 1 | 262.41 | 49 | SO47416 | 2022-12-23 | 20.99 | 194.18 | 65.60 | |||
SO55234_39 | C6FC-46EE-88 | PO522140495 | 100 | 285 | 588 | 676 | 5 | 2024-01-27 | 1846.78 | 46.17 | 2024-01-15 | 4 | 419.78 | 1 | 1846.78 | 39 | SO55234 | 2024-01-22 | 147.74 | 1679.11 | 461.69 | |||
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 |
SO53530_4 | A31D-483D-A1 | PO2813121313 | 100 | 283 | 463 | 2 | 90 | 5 | 3.41 | 2023-12-28 | 170.45 | 4.18 | 2023-12-16 | 12 | 9.16 | 1 | 167.04 | 4 | SO53530 | 2023-12-23 | 13.36 | 109.91 | 14.20 | 0.02 |
Generated 2024-11-14 05:14:43.561 UTC