[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 220 > < TAKE 30 >
30 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48393_14 | 5B6A-41B6-BF | PO9599137631 | 100 | 285 | 383 | 170 | 5 | 2023-02-01 | 2401.05 | 60.03 | 2023-01-20 | 4 | 605.65 | 1 | 2401.05 | 14 | SO48393 | 2023-01-27 | 192.08 | 2422.60 | 600.26 |
SO59069_1 | DBC9-4977-94 | PO9106150028 | 100 | 285 | 599 | 602 | 5 | 2024-02-01 | 323.99 | 8.10 | 2024-01-20 | 1 | 294.58 | 1 | 323.99 | 1 | SO59069 | 2024-01-27 | 25.92 | 294.58 | 323.99 |
SO71839_29 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 480 | 611 | 5 | 2024-08-02 | 8.24 | 0.21 | 2024-07-21 | 6 | 0.86 | 1 | 8.24 | 29 | SO71839 | 2024-07-28 | 0.66 | 5.14 | 1.37 |
SO61230_12 | B9F1-4FF8-B4 | PO12644163346 | 100 | 285 | 400 | 530 | 5 | 2024-03-03 | 74.30 | 1.86 | 2024-02-20 | 2 | 27.49 | 1 | 74.30 | 12 | SO61230 | 2024-02-27 | 5.94 | 54.99 | 37.15 |
SO46383_4 | 2398-4D5E-8F | PO9106128085 | 100 | 285 | 304 | 602 | 5 | 2022-08-02 | 1429.41 | 35.74 | 2022-07-21 | 2 | 617.03 | 1 | 1429.41 | 4 | SO46383 | 2022-07-28 | 114.35 | 1234.06 | 714.70 |
SO71802_9 | 6B80-41A7-89 | PO15457184141 | 100 | 285 | 569 | 297 | 5 | 2024-08-02 | 890.82 | 22.27 | 2024-07-21 | 2 | 461.44 | 1 | 890.82 | 9 | SO71802 | 2024-07-28 | 71.27 | 922.89 | 445.41 |
SO57118_24 | 69CB-481B-8D | PO5800191707 | 100 | 285 | 306 | 63 | 5 | 2024-01-02 | 3239.04 | 80.98 | 2023-12-21 | 4 | 739.04 | 1 | 3239.04 | 24 | SO57118 | 2023-12-28 | 259.12 | 2956.16 | 809.76 |
SO48792_1 | F238-4277-97 | PO9976183547 | 100 | 285 | 339 | 242 | 5 | 2023-03-04 | 469.79 | 11.74 | 2023-02-20 | 1 | 486.71 | 1 | 469.79 | 1 | SO48792 | 2023-02-27 | 37.58 | 486.71 | 469.79 |
SO45300_17 | 650B-4342-95 | PO12586158748 | 100 | 285 | 218 | 278 | 5 | 2022-04-04 | 34.20 | 0.86 | 2022-03-23 | 6 | 3.40 | 1 | 34.20 | 17 | SO45300 | 2022-03-30 | 2.74 | 20.38 | 5.70 |
SO51853_11 | 3754-4D33-92 | PO3596145757 | 100 | 285 | 597 | 476 | 5 | 2023-10-02 | 323.99 | 8.10 | 2023-09-20 | 1 | 294.58 | 1 | 323.99 | 11 | SO51853 | 2023-09-27 | 25.92 | 294.58 | 323.99 |
SO47455_15 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 286 | 170 | 5 | 2022-11-02 | 367.88 | 9.20 | 2022-10-21 | 2 | 170.14 | 1 | 367.88 | 15 | SO47455 | 2022-10-28 | 29.43 | 340.29 | 183.94 |
SO49159_7 | 15B4-4CCD-9A | PO7598122487 | 100 | 285 | 373 | 45 | 5 | 2023-04-04 | 1308.94 | 32.72 | 2023-03-23 | 1 | 1320.68 | 1 | 1308.94 | 7 | SO49159 | 2023-03-30 | 104.72 | 1320.68 | 1308.94 |
SO44555_1 | 51FA-451D-A2 | PO6293176988 | 100 | 285 | 332 | 612 | 5 | 2022-01-02 | 1258.38 | 31.46 | 2021-12-21 | 3 | 413.15 | 1 | 1258.38 | 1 | SO44555 | 2021-12-28 | 100.67 | 1239.44 | 419.46 |
SO44128_4 | 2EFE-4DBD-95 | PO9541192839 | 100 | 285 | 344 | 279 | 5 | 2021-11-02 | 2039.99 | 51.00 | 2021-10-21 | 1 | 1912.15 | 1 | 2039.99 | 4 | SO44128 | 2021-10-28 | 163.20 | 1912.15 | 2039.99 |
SO69513_15 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 547 | 45 | 5 | 2024-07-02 | 97.19 | 2.43 | 2024-06-20 | 2 | 35.96 | 1 | 97.19 | 15 | SO69513 | 2024-06-27 | 7.78 | 71.92 | 48.59 |
SO67277_47 | 9AB3-4F34-85 | PO12644174121 | 100 | 272 | 222 | 530 | 5 | 2024-06-02 | 62.98 | 1.57 | 2024-05-21 | 3 | 13.09 | 1 | 62.98 | 47 | SO67277 | 2024-05-28 | 5.04 | 39.26 | 20.99 |
SO51831_2 | C581-4EA9-9D | PO7598131197 | 100 | 285 | 243 | 45 | 5 | 2023-10-02 | 858.90 | 21.47 | 2023-09-20 | 1 | 868.63 | 1 | 858.90 | 2 | SO51831 | 2023-09-27 | 68.71 | 868.63 | 858.90 |
SO48760_3 | D682-4FD4-94 | PO9657199450 | 100 | 285 | 354 | 315 | 5 | 2023-03-04 | 7457.11 | 186.43 | 2023-02-20 | 6 | 1117.86 | 1 | 7457.11 | 3 | SO48760 | 2023-02-27 | 596.57 | 6707.14 | 1242.85 |
SO43861_23 | 0CC0-4166-9E | PO16327172067 | 100 | 285 | 212 | 584 | 5 | 2021-10-02 | 80.75 | 2.02 | 2021-09-20 | 4 | 12.03 | 1 | 80.75 | 23 | SO43861 | 2021-09-27 | 6.46 | 48.11 | 20.19 |
SO57104_4 | D4EE-4716-83 | PO18560117786 | 100 | 285 | 583 | 531 | 5 | 2024-01-02 | 2041.19 | 51.03 | 2023-12-21 | 2 | 1082.51 | 1 | 2041.19 | 4 | SO57104 | 2023-12-28 | 163.30 | 2165.02 | 1020.59 |
SO65283_2 | 8C3A-4D5E-9D | PO4089118931 | 100 | 285 | 359 | 368 | 5 | 2024-05-02 | 2753.99 | 68.85 | 2024-04-20 | 2 | 1251.98 | 1 | 2753.99 | 2 | SO65283 | 2024-04-27 | 220.32 | 2503.96 | 1376.99 |
SO49149_18 | D41E-4EFF-A5 | PO5858123072 | 100 | 285 | 428 | 566 | 5 | 2023-04-04 | 209.26 | 5.23 | 2023-03-23 | 1 | 185.82 | 1 | 209.26 | 18 | SO49149 | 2023-03-30 | 16.74 | 185.82 | 209.26 |
SO57039_3 | 34D9-46BE-B4 | PO15051154053 | 100 | 285 | 471 | 207 | 5 | 2024-01-02 | 76.20 | 1.91 | 2023-12-21 | 2 | 23.75 | 1 | 76.20 | 3 | SO57039 | 2023-12-28 | 6.10 | 47.50 | 38.10 |
SO48730_8 | C918-466B-B1 | PO522152463 | 100 | 285 | 352 | 676 | 5 | 2023-03-04 | 7457.11 | 186.43 | 2023-02-20 | 6 | 1117.86 | 1 | 7457.11 | 8 | SO48730 | 2023-02-27 | 596.57 | 6707.14 | 1242.85 |
SO58974_14 | FB64-4792-81 | PO2813115918 | 100 | 283 | 214 | 90 | 5 | 2024-02-01 | 146.96 | 3.67 | 2024-01-20 | 7 | 13.09 | 1 | 146.96 | 14 | SO58974 | 2024-01-27 | 11.76 | 91.60 | 20.99 |
SO49886_1 | 8B20-4200-8E | PO6554151320 | 100 | 285 | 368 | 387 | 5 | 2023-06-02 | 2932.02 | 73.30 | 2023-05-21 | 2 | 1518.79 | 1 | 2932.02 | 1 | SO49886 | 2023-05-28 | 234.56 | 3037.57 | 1466.01 |
SO71850_8 | 3DA6-4E97-9F | PO18241134627 | 100 | 285 | 572 | 477 | 5 | 2024-08-02 | 445.41 | 11.14 | 2024-07-21 | 1 | 461.44 | 1 | 445.41 | 8 | SO71850 | 2024-07-28 | 35.63 | 461.44 | 445.41 |
SO51137_1 | A47F-4FEF-94 | PO9889144162 | 100 | 285 | 587 | 494 | 5 | 2023-09-01 | 1385.08 | 34.63 | 2023-08-20 | 3 | 419.78 | 1 | 1385.08 | 1 | SO51137 | 2023-08-27 | 110.81 | 1259.34 | 461.69 |
SO47681_8 | 0580-4A09-A8 | PO12644124767 | 100 | 285 | 464 | 530 | 5 | 2022-12-02 | 98.90 | 2.47 | 2022-11-20 | 7 | 9.71 | 1 | 98.90 | 8 | SO47681 | 2022-11-27 | 7.91 | 68.00 | 14.13 |
SO65248_5 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 390 | 170 | 5 | 2024-05-02 | 2016.88 | 50.42 | 2024-04-20 | 3 | 713.08 | 1 | 2016.88 | 5 | SO65248 | 2024-04-27 | 161.35 | 2139.24 | 672.29 |
Generated 2024-09-20 02:49:12.423 UTC