[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SKIP 4000 SHUFFLE < SKIP 124 > < TAKE 30 >
30 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO50756_11 | C414-447C-84 | PO9570119689 | 100 | 285 | 297 | 585 | 5 | 2023-09-26 | 1472.29 | 36.81 | 2023-09-14 | 2 | 653.70 | 1 | 1472.29 | 11 | SO50756 | 2023-09-21 | 117.78 | 1307.39 | 736.15 | |||
| SO69394_3 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 386 | 206 | 5 | 2024-08-26 | 672.29 | 16.81 | 2024-08-14 | 1 | 713.08 | 1 | 672.29 | 3 | SO69394 | 2024-08-21 | 53.78 | 713.08 | 672.29 | |||
| SO67349_13 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 471 | 3 | 81 | 5 | 34.93 | 2024-07-27 | 698.50 | 16.59 | 2024-07-15 | 20 | 23.75 | 1 | 663.58 | 13 | SO67349 | 2024-07-22 | 53.09 | 474.98 | 34.93 | 0.05 |
| SO47454_27 | E249-41EE-95 | PO9570119946 | 100 | 285 | 421 | 585 | 5 | 2022-12-27 | 785.32 | 19.63 | 2022-12-15 | 4 | 145.28 | 1 | 785.32 | 27 | SO47454 | 2022-12-22 | 62.83 | 581.13 | 196.33 | |||
| SO65242_3 | 0175-4222-B3 | PO14297142992 | 100 | 285 | 565 | 627 | 5 | 2024-06-26 | 445.41 | 11.14 | 2024-06-14 | 1 | 461.44 | 1 | 445.41 | 3 | SO65242 | 2024-06-21 | 35.63 | 461.44 | 445.41 | |||
| SO69419_3 | 09D7-42E3-8E | PO15051119574 | 100 | 285 | 476 | 207 | 5 | 2024-08-26 | 251.96 | 6.30 | 2024-08-14 | 6 | 26.18 | 1 | 251.96 | 3 | SO69419 | 2024-08-21 | 20.16 | 157.06 | 41.99 | |||
| SO65272_1 | 2BA5-452C-BA | PO9106157142 | 100 | 285 | 400 | 602 | 5 | 2024-06-26 | 37.15 | 0.93 | 2024-06-14 | 1 | 27.49 | 1 | 37.15 | 1 | SO65272 | 2024-06-21 | 2.97 | 27.49 | 37.15 | |||
| SO57088_29 | EA31-4951-8A | PO2842199218 | 100 | 285 | 547 | 700 | 5 | 2024-02-26 | 145.78 | 3.64 | 2024-02-14 | 3 | 35.96 | 1 | 145.78 | 29 | SO57088 | 2024-02-21 | 11.66 | 107.88 | 48.59 | |||
| SO63124_12 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 583 | 206 | 5 | 2024-05-28 | 2041.19 | 51.03 | 2024-05-16 | 2 | 1082.51 | 1 | 2041.19 | 12 | SO63124 | 2024-05-23 | 163.30 | 2165.02 | 1020.59 | |||
| SO69465_37 | B8B2-4B14-99 | PO2842153886 | 100 | 285 | 418 | 700 | 5 | 2024-08-26 | 356.90 | 8.92 | 2024-08-14 | 1 | 360.94 | 1 | 356.90 | 37 | SO69465 | 2024-08-21 | 28.55 | 360.94 | 356.90 | |||
| SO58993_5 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 576 | 627 | 5 | 2024-03-27 | 1430.44 | 35.76 | 2024-03-15 | 1 | 1481.94 | 1 | 1430.44 | 5 | SO58993 | 2024-03-22 | 114.44 | 1481.94 | 1430.44 | |||
| SO65248_10 | A7B5-4EE1-98 | PO9599164617 | 100 | 285 | 372 | 170 | 5 | 2024-06-26 | 8796.06 | 219.90 | 2024-06-14 | 6 | 1554.95 | 1 | 8796.06 | 10 | SO65248 | 2024-06-21 | 703.68 | 9329.69 | 1466.01 | |||
| SO71821_1 | 3D95-45AC-A2 | PO11977190694 | 100 | 285 | 408 | 675 | 5 | 2024-09-26 | 288.65 | 7.22 | 2024-09-14 | 4 | 53.40 | 1 | 288.65 | 1 | SO71821 | 2024-09-21 | 23.09 | 213.60 | 72.16 | |||
| SO61257_7 | B93D-4A2D-BA | PO3741176337 | 100 | 285 | 580 | 404 | 5 | 2024-04-27 | 3061.78 | 76.54 | 2024-04-15 | 3 | 1082.51 | 1 | 3061.78 | 7 | SO61257 | 2024-04-22 | 244.94 | 3247.53 | 1020.59 | |||
| SO50703_41 | 4A3D-44CB-B3 | PO2813140706 | 100 | 283 | 458 | 90 | 5 | 2023-09-26 | 179.98 | 4.50 | 2023-09-14 | 4 | 30.93 | 1 | 179.98 | 41 | SO50703 | 2023-09-21 | 14.40 | 123.73 | 44.99 | |||
| SO69518_19 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 525 | 63 | 5 | 2024-08-26 | 633.72 | 15.84 | 2024-08-14 | 4 | 144.59 | 1 | 633.72 | 19 | SO69518 | 2024-08-21 | 50.70 | 578.38 | 158.43 | |||
| SO58993_22 | EEB4-42E9-B9 | PO14297167367 | 100 | 285 | 573 | 627 | 5 | 2024-03-27 | 2860.88 | 71.52 | 2024-03-15 | 2 | 1481.94 | 1 | 2860.88 | 22 | SO58993 | 2024-03-22 | 228.87 | 2963.88 | 1430.44 | |||
| SO58989_7 | 0A23-4D44-A4 | PO11977137958 | 100 | 285 | 240 | 675 | 5 | 2024-03-27 | 858.90 | 21.47 | 2024-03-15 | 1 | 868.63 | 1 | 858.90 | 7 | SO58989 | 2024-03-22 | 68.71 | 868.63 | 858.90 | |||
| SO63190_1 | 9392-46BC-92 | PO18734125624 | 100 | 283 | 512 | 449 | 5 | 2024-05-28 | 218.45 | 5.46 | 2024-05-16 | 1 | 199.38 | 1 | 218.45 | 1 | SO63190 | 2024-05-23 | 17.48 | 199.38 | 218.45 | |||
| SO47406_2 | 0982-4EFC-9A | PO435113234 | 100 | 285 | 439 | 651 | 5 | 2022-12-27 | 1561.64 | 39.04 | 2022-12-15 | 2 | 722.26 | 1 | 1561.64 | 2 | SO47406 | 2022-12-22 | 124.93 | 1444.51 | 780.82 | |||
| SO69394_12 | A04D-4E1B-B4 | PO19546195663 | 100 | 285 | 605 | 206 | 5 | 2024-08-26 | 971.98 | 24.30 | 2024-08-14 | 3 | 343.65 | 1 | 971.98 | 12 | SO69394 | 2024-08-21 | 77.76 | 1030.95 | 323.99 | |||
| SO57017_22 | 4C6E-47EA-AD | PO19546126186 | 100 | 285 | 546 | 206 | 5 | 2024-02-26 | 111.76 | 2.79 | 2024-02-14 | 3 | 27.57 | 1 | 111.76 | 22 | SO57017 | 2024-02-21 | 8.94 | 82.70 | 37.25 | |||
| SO63124_10 | 5CAE-4C1D-85 | PO19546167735 | 100 | 285 | 382 | 206 | 5 | 2024-05-28 | 672.29 | 16.81 | 2024-05-16 | 1 | 713.08 | 1 | 672.29 | 10 | SO63124 | 2024-05-23 | 53.78 | 713.08 | 672.29 | |||
| SO57074_16 | FF65-4261-97 | PO9918191120 | 100 | 285 | 568 | 260 | 5 | 2024-02-26 | 1336.23 | 33.41 | 2024-02-14 | 3 | 461.44 | 1 | 1336.23 | 16 | SO57074 | 2024-02-21 | 106.90 | 1384.33 | 445.41 | |||
| SO50757_1 | 5C6E-4693-95 | PO9048116268 | 100 | 285 | 358 | 652 | 5 | 2023-09-26 | 1229.46 | 30.74 | 2023-09-14 | 1 | 1105.81 | 1 | 1229.46 | 1 | SO50757 | 2023-09-21 | 98.36 | 1105.81 | 1229.46 | |||
| SO69510_4 | 20D6-41A2-8F | PO5568198481 | 100 | 285 | 483 | 422 | 5 | 2024-08-26 | 144.00 | 3.60 | 2024-08-14 | 2 | 44.88 | 1 | 144.00 | 4 | SO69510 | 2024-08-21 | 11.52 | 89.76 | 72.00 | |||
| SO63181_14 | CB4E-4CF5-87 | PO2842135731 | 100 | 285 | 584 | 700 | 5 | 2024-05-28 | 1619.97 | 40.50 | 2024-05-16 | 5 | 343.65 | 1 | 1619.97 | 14 | SO63181 | 2024-05-23 | 129.60 | 1718.25 | 323.99 | |||
| SO58924_14 | D17F-4E31-90 | PO15457121920 | 100 | 285 | 577 | 297 | 5 | 2024-03-27 | 1457.82 | 36.45 | 2024-03-15 | 2 | 755.15 | 1 | 1457.82 | 14 | SO58924 | 2024-03-22 | 116.63 | 1510.30 | 728.91 | |||
| SO51081_22 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 491 | 676 | 5 | 2023-10-26 | 323.94 | 8.10 | 2023-10-14 | 10 | 41.57 | 1 | 323.94 | 22 | SO51081 | 2023-10-21 | 25.92 | 415.72 | 32.39 | |||
| SO50756_30 | C414-447C-84 | PO9570119689 | 100 | 285 | 458 | 585 | 5 | 2023-09-26 | 89.99 | 2.25 | 2023-09-14 | 2 | 30.93 | 1 | 89.99 | 30 | SO50756 | 2023-09-21 | 7.20 | 61.87 | 44.99 |
Generated 2024-11-13 04:57:54.747 UTC