[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2531 > < TAKE 31 >
31 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48363_18 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 221 | 130 | 4 | 2023-02-01 | 141.31 | 3.53 | 2023-01-20 | 7 | 13.88 | 1 | 141.31 | 18 | SO48363 | 2023-01-27 | 11.30 | 97.15 | 20.19 |
SO44520_4 | 5BE0-436B-8C | PO12499152870 | 100 | 282 | 310 | 78 | 4 | 2022-01-02 | 6440.89 | 161.02 | 2021-12-21 | 3 | 2171.29 | 1 | 6440.89 | 4 | SO44520 | 2021-12-28 | 515.27 | 6513.88 | 2146.96 |
SO71902_34 | AEC9-4070-9D | PO5539125166 | 100 | 282 | 487 | 61 | 4 | 2024-08-02 | 164.97 | 4.12 | 2024-07-21 | 5 | 20.57 | 1 | 164.97 | 34 | SO71902 | 2024-07-28 | 13.20 | 102.83 | 32.99 |
SO44754_10 | 2F58-4025-92 | PO15834116970 | 100 | 283 | 315 | 417 | 4 | 2022-02-01 | 1749.59 | 43.74 | 2022-01-20 | 2 | 884.71 | 1 | 1749.59 | 10 | SO44754 | 2022-01-27 | 139.97 | 1769.42 | 874.79 |
SO47374_16 | C6BE-481A-A0 | PO16182131046 | 100 | 287 | 224 | 23 | 4 | 2022-11-02 | 10.37 | 0.26 | 2022-10-21 | 2 | 5.23 | 1 | 10.37 | 16 | SO47374 | 2022-10-28 | 0.83 | 10.46 | 5.19 |
SO65232_29 | 3D4B-4E94-8F | PO9715132845 | 100 | 281 | 474 | 490 | 4 | 2024-05-02 | 293.96 | 7.35 | 2024-04-20 | 7 | 26.18 | 1 | 293.96 | 29 | SO65232 | 2024-04-27 | 23.52 | 183.23 | 41.99 |
SO51833_1 | 67A5-4BBC-8F | PO5684113634 | 100 | 282 | 363 | 385 | 4 | 2023-10-02 | 2753.99 | 68.85 | 2023-09-20 | 2 | 1251.98 | 1 | 2753.99 | 1 | SO51833 | 2023-09-27 | 220.32 | 2503.96 | 1376.99 |
SO67273_55 | 9BAE-4E69-B9 | PO13688176638 | 100 | 282 | 487 | 475 | 4 | 2024-06-02 | 197.96 | 4.95 | 2024-05-21 | 6 | 20.57 | 1 | 197.96 | 55 | SO67273 | 2024-05-28 | 15.84 | 123.40 | 32.99 |
SO49851_34 | 14FB-4B97-95 | PO2494142030 | 100 | 281 | 233 | 184 | 4 | 2023-06-02 | 57.68 | 1.44 | 2023-05-21 | 2 | 29.08 | 1 | 57.68 | 34 | SO49851 | 2023-05-28 | 4.61 | 58.16 | 28.84 |
SO71857_9 | CD4E-4DE8-81 | PO16269151631 | 100 | 287 | 380 | 624 | 4 | 2024-08-02 | 1466.01 | 36.65 | 2024-07-21 | 1 | 1554.95 | 1 | 1466.01 | 9 | SO71857 | 2024-07-28 | 117.28 | 1554.95 | 1466.01 |
SO49538_14 | CB52-4E7E-9B | PO6786132021 | 100 | 281 | 216 | 3 | 4 | 2023-05-02 | 80.75 | 2.02 | 2023-04-20 | 4 | 13.88 | 1 | 80.75 | 14 | SO49538 | 2023-04-27 | 6.46 | 55.51 | 20.19 |
SO51827_12 | B106-4221-AD | PO4611117026 | 100 | 287 | 502 | 131 | 4 | 2023-10-02 | 200.05 | 5.00 | 2023-09-20 | 1 | 199.85 | 1 | 200.05 | 12 | SO51827 | 2023-09-27 | 16.00 | 199.85 | 200.05 |
SO71787_14 | 94A7-4406-B3 | PO18038111279 | 100 | 287 | 492 | 509 | 4 | 2024-08-02 | 602.35 | 15.06 | 2024-07-21 | 1 | 601.74 | 1 | 602.35 | 14 | SO71787 | 2024-07-28 | 48.19 | 601.74 | 602.35 |
SO48363_2 | A9C9-4B7B-9B | PO3915186343 | 100 | 283 | 385 | 130 | 4 | 2023-02-01 | 600.26 | 15.01 | 2023-01-20 | 1 | 605.65 | 1 | 600.26 | 2 | SO48363 | 2023-01-27 | 48.02 | 605.65 | 600.26 |
SO65167_7 | D40C-4211-94 | PO18125182344 | 100 | 287 | 482 | 311 | 4 | 2024-05-02 | 5.39 | 0.13 | 2024-04-20 | 1 | 3.36 | 1 | 5.39 | 7 | SO65167 | 2024-04-27 | 0.43 | 3.36 | 5.39 |
SO53583_37 | 582E-4A53-9A | PO5597118655 | 100 | 281 | 359 | 75 | 4 | 2023-11-02 | 8261.96 | 206.55 | 2023-10-21 | 6 | 1251.98 | 1 | 8261.96 | 37 | SO53583 | 2023-10-28 | 660.96 | 7511.89 | 1376.99 |
SO46617_4 | 3FDB-4564-98 | PO14413119944 | 100 | 287 | 286 | 383 | 4 | 2022-09-01 | 551.81 | 13.80 | 2022-08-20 | 3 | 170.14 | 1 | 551.81 | 4 | SO46617 | 2022-08-27 | 44.15 | 510.43 | 183.94 |
SO45566_1 | E2D7-4E06-80 | PO5974110725 | 100 | 282 | 316 | 330 | 4 | 2022-05-02 | 874.79 | 21.87 | 2022-04-20 | 1 | 884.71 | 1 | 874.79 | 1 | SO45566 | 2022-04-27 | 69.98 | 884.71 | 874.79 |
SO44768_26 | 18BD-48B8-95 | PO261164909 | 100 | 283 | 215 | 647 | 4 | 2022-02-01 | 121.12 | 3.03 | 2022-01-20 | 6 | 12.03 | 1 | 121.12 | 26 | SO44768 | 2022-01-27 | 9.69 | 72.17 | 20.19 |
SO47056_57 | 53BF-4950-9E | PO7656118289 | 100 | 282 | 460 | 403 | 4 | 2022-10-02 | 539.94 | 13.50 | 2022-09-20 | 10 | 37.12 | 1 | 539.94 | 57 | SO47056 | 2022-09-27 | 43.20 | 371.21 | 53.99 |
SO51809_38 | F690-4F1D-B1 | PO6438145374 | 100 | 281 | 353 | 309 | 4 | 2023-10-02 | 2783.99 | 69.60 | 2023-09-20 | 2 | 1265.62 | 1 | 2783.99 | 38 | SO51809 | 2023-09-27 | 222.72 | 2531.24 | 1391.99 |
SO51154_42 | 2A76-4451-99 | PO7859157852 | 100 | 287 | 430 | 221 | 4 | 2023-09-01 | 356.90 | 8.92 | 2023-08-20 | 1 | 360.94 | 1 | 356.90 | 42 | SO51154 | 2023-08-27 | 28.55 | 360.94 | 356.90 |
SO48375_21 | B5F1-4C2A-94 | PO5597156214 | 100 | 283 | 458 | 75 | 4 | 2023-02-01 | 179.98 | 4.50 | 2023-01-20 | 4 | 30.93 | 1 | 179.98 | 21 | SO48375 | 2023-01-27 | 14.40 | 123.73 | 44.99 |
SO49489_4 | 7419-48A5-B8 | PO16182158783 | 100 | 287 | 468 | 23 | 4 | 2023-05-02 | 113.97 | 2.85 | 2023-04-20 | 5 | 15.67 | 1 | 113.97 | 4 | SO49489 | 2023-04-27 | 9.12 | 78.35 | 22.79 |
SO46992_36 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 379 | 97 | 4 | 2022-10-02 | 5235.75 | 130.89 | 2022-09-20 | 4 | 1320.68 | 1 | 5235.75 | 36 | SO46992 | 2022-09-27 | 418.86 | 5282.74 | 1308.94 |
SO55322_6 | D600-436A-B7 | PO7859118281 | 100 | 287 | 477 | 221 | 4 | 2023-12-02 | 11.98 | 0.30 | 2023-11-20 | 4 | 1.87 | 1 | 11.98 | 6 | SO55322 | 2023-11-27 | 0.96 | 7.47 | 2.99 |
SO51836_9 | 8AA7-498C-8C | PO6351139034 | 100 | 281 | 582 | 255 | 4 | 2023-10-02 | 2041.19 | 51.03 | 2023-09-20 | 2 | 1082.51 | 1 | 2041.19 | 9 | SO51836 | 2023-09-27 | 163.30 | 2165.02 | 1020.59 |
SO65176_3 | 2516-4DF3-BB | PO17052135284 | 100 | 282 | 564 | 420 | 4 | 2024-05-02 | 5721.77 | 143.04 | 2024-04-20 | 4 | 1481.94 | 1 | 5721.77 | 3 | SO65176 | 2024-04-27 | 457.74 | 5927.75 | 1430.44 |
SO53460_33 | 3BD9-47C3-94 | PO19343112747 | 100 | 282 | 440 | 24 | 4 | 2023-11-02 | 4294.50 | 107.36 | 2023-10-21 | 5 | 868.63 | 1 | 4294.50 | 33 | SO53460 | 2023-10-28 | 343.56 | 4343.17 | 858.90 |
SO63201_1 | 8299-4DE4-AD | PO15689136917 | 100 | 281 | 584 | 328 | 4 | 2024-04-03 | 1295.98 | 32.40 | 2024-03-22 | 4 | 343.65 | 1 | 1295.98 | 1 | SO63201 | 2024-03-29 | 103.68 | 1374.60 | 323.99 |
SO47355_16 | 6B7D-4E47-B5 | PO19343125466 | 100 | 282 | 389 | 24 | 4 | 2022-11-02 | 2401.05 | 60.03 | 2022-10-21 | 4 | 605.65 | 1 | 2401.05 | 16 | SO47355 | 2022-10-28 | 192.08 | 2422.60 | 600.26 |
Generated 2024-09-19 20:38:14.301 UTC