[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > SHUFFLE < SKIP 847 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50726_20 | A80B-408E-B3 | PO9599192861 | 100 | 285 | 369 | 170 | 5 | 2023-09-23 | 10262.07 | 256.55 | 2023-09-11 | 7 | 1518.79 | 1 | 10262.07 | 20 | SO50726 | 2023-09-18 | 820.97 | 10631.50 | 1466.01 |
SO45300_18 | 650B-4342-95 | PO12586158748 | 100 | 285 | 223 | 278 | 5 | 2022-05-26 | 15.56 | 0.39 | 2022-05-14 | 3 | 5.71 | 1 | 15.56 | 18 | SO45300 | 2022-05-21 | 1.24 | 17.12 | 5.19 |
SO47040_3 | 5A71-45F5-B9 | PO5568168365 | 100 | 285 | 419 | 422 | 5 | 2022-11-23 | 105.29 | 2.63 | 2022-11-11 | 2 | 38.96 | 1 | 105.29 | 3 | SO47040 | 2022-11-18 | 8.42 | 77.92 | 52.65 |
SO59073_5 | 2631-471F-81 | PO9222113702 | 100 | 285 | 471 | 171 | 5 | 2024-03-24 | 38.10 | 0.95 | 2024-03-12 | 1 | 23.75 | 1 | 38.10 | 5 | SO59073 | 2024-03-19 | 3.05 | 23.75 | 38.10 |
SO45558_1 | 58F7-4886-A6 | PO4089184259 | 100 | 285 | 344 | 368 | 5 | 2022-06-23 | 2039.99 | 51.00 | 2022-06-11 | 1 | 1912.15 | 1 | 2039.99 | 1 | SO45558 | 2022-06-18 | 163.20 | 1912.15 | 2039.99 |
SO69518_30 | 96AA-48F8-80 | PO5800191682 | 100 | 285 | 556 | 63 | 5 | 2024-08-23 | 315.88 | 7.90 | 2024-08-11 | 3 | 77.92 | 1 | 315.88 | 30 | SO69518 | 2024-08-18 | 25.27 | 233.75 | 105.29 |
SO51081_43 | EDBF-4FE1-8F | PO522116846 | 100 | 285 | 587 | 676 | 5 | 2023-10-23 | 923.39 | 23.08 | 2023-10-11 | 2 | 419.78 | 1 | 923.39 | 43 | SO51081 | 2023-10-18 | 73.87 | 839.56 | 461.69 |
SO57149_9 | C32D-4E78-97 | PO5568130124 | 100 | 285 | 234 | 422 | 5 | 2024-02-23 | 89.98 | 2.25 | 2024-02-11 | 3 | 38.49 | 1 | 89.98 | 9 | SO57149 | 2024-02-18 | 7.20 | 115.48 | 29.99 |
SO46056_14 | 4B9A-4022-AA | PO12586180466 | 100 | 285 | 220 | 278 | 5 | 2022-08-23 | 100.93 | 2.52 | 2022-08-11 | 5 | 12.03 | 1 | 100.93 | 14 | SO46056 | 2022-08-18 | 8.07 | 60.14 | 20.19 |
SO46384_6 | 9F38-4366-91 | PO9541189751 | 100 | 285 | 223 | 279 | 5 | 2022-09-23 | 5.19 | 0.13 | 2022-09-11 | 1 | 5.71 | 1 | 5.19 | 6 | SO46384 | 2022-09-18 | 0.41 | 5.71 | 5.19 |
SO63246_9 | 5008-4978-B3 | PO7598198768 | 100 | 285 | 376 | 45 | 5 | 2024-05-25 | 1466.01 | 36.65 | 2024-05-13 | 1 | 1554.95 | 1 | 1466.01 | 9 | SO63246 | 2024-05-20 | 117.28 | 1554.95 | 1466.01 |
SO44775_4 | A5AD-45A6-B0 | PO1943133380 | 100 | 285 | 232 | 525 | 5 | 2022-03-25 | 28.84 | 0.72 | 2022-03-13 | 1 | 31.72 | 1 | 28.84 | 4 | SO44775 | 2022-03-20 | 2.31 | 31.72 | 28.84 |
SO48398_3 | E6C8-48FB-BB | PO9744171621 | 100 | 285 | 360 | 98 | 5 | 2023-03-25 | 1229.46 | 30.74 | 2023-03-13 | 1 | 1105.81 | 1 | 1229.46 | 3 | SO48398 | 2023-03-20 | 98.36 | 1105.81 | 1229.46 |
SO67349_22 | 7BC2-4E87-BA | PO9831186318 | 100 | 285 | 418 | 81 | 5 | 2024-07-24 | 1070.69 | 26.77 | 2024-07-12 | 3 | 360.94 | 1 | 1070.69 | 22 | SO67349 | 2024-07-19 | 85.66 | 1082.83 | 356.90 |
SO58971_34 | 319A-4CAC-B1 | PO1537134870 | 100 | 285 | 467 | 611 | 5 | 2024-03-24 | 73.47 | 1.84 | 2024-03-12 | 5 | 9.16 | 1 | 73.47 | 34 | SO58971 | 2024-03-19 | 5.88 | 45.80 | 14.69 |
SO71839_27 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 498 | 611 | 5 | 2024-09-23 | 602.35 | 15.06 | 2024-09-11 | 1 | 601.74 | 1 | 602.35 | 27 | SO71839 | 2024-09-18 | 48.19 | 601.74 | 602.35 |
SO71948_3 | DCEE-428D-87 | PO9599179297 | 100 | 285 | 547 | 170 | 5 | 2024-09-23 | 242.97 | 6.07 | 2024-09-11 | 5 | 35.96 | 1 | 242.97 | 3 | SO71948 | 2024-09-18 | 19.44 | 179.80 | 48.59 |
SO69513_5 | 21F8-4626-B9 | PO7598121355 | 100 | 285 | 436 | 45 | 5 | 2024-08-23 | 356.90 | 8.92 | 2024-08-11 | 1 | 360.94 | 1 | 356.90 | 5 | SO69513 | 2024-08-18 | 28.55 | 360.94 | 356.90 |
SO67260_40 | 6224-4229-B8 | PO522163557 | 100 | 285 | 361 | 676 | 5 | 2024-07-24 | 2753.99 | 68.85 | 2024-07-12 | 2 | 1251.98 | 1 | 2753.99 | 40 | SO67260 | 2024-07-19 | 220.32 | 2503.96 | 1376.99 |
SO49121_4 | BBAC-4A43-89 | PO11803196527 | 100 | 285 | 469 | 513 | 5 | 2023-05-26 | 22.79 | 0.57 | 2023-05-14 | 1 | 15.67 | 1 | 22.79 | 4 | SO49121 | 2023-05-21 | 1.82 | 15.67 | 22.79 |
SO51108_23 | 8650-4A20-B1 | PO12644151814 | 100 | 285 | 475 | 530 | 5 | 2023-10-23 | 41.99 | 1.05 | 2023-10-11 | 1 | 26.18 | 1 | 41.99 | 23 | SO51108 | 2023-10-18 | 3.36 | 26.18 | 41.99 |
SO71839_23 | 8F89-4B1E-A8 | PO1537119063 | 100 | 285 | 560 | 611 | 5 | 2024-09-23 | 3644.55 | 91.11 | 2024-09-11 | 5 | 755.15 | 1 | 3644.55 | 23 | SO71839 | 2024-09-18 | 291.56 | 3775.75 | 728.91 |
SO47682_2 | 685F-4FCA-A2 | PO12615189875 | 100 | 285 | 468 | 440 | 5 | 2023-01-23 | 68.38 | 1.71 | 2023-01-11 | 3 | 15.67 | 1 | 68.38 | 2 | SO47682 | 2023-01-18 | 5.47 | 47.01 | 22.79 |
SO47455_11 | 41F3-48C2-B7 | PO9599169586 | 100 | 285 | 375 | 170 | 5 | 2022-12-24 | 9162.56 | 229.06 | 2022-12-12 | 7 | 1320.68 | 1 | 9162.56 | 11 | SO47455 | 2022-12-19 | 733.01 | 9244.79 | 1308.94 |
SO49145_5 | 31DA-4BD5-9C | PO5568187962 | 100 | 285 | 358 | 422 | 5 | 2023-05-26 | 2458.92 | 61.47 | 2023-05-14 | 2 | 1105.81 | 1 | 2458.92 | 5 | SO49145 | 2023-05-21 | 196.71 | 2211.62 | 1229.46 |
SO51147_30 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 418 | 81 | 5 | 2023-10-23 | 356.90 | 8.92 | 2023-10-11 | 1 | 360.94 | 1 | 356.90 | 30 | SO51147 | 2023-10-18 | 28.55 | 360.94 | 356.90 |
SO47454_28 | E249-41EE-95 | PO9570119946 | 100 | 285 | 213 | 585 | 5 | 2022-12-24 | 80.75 | 2.02 | 2022-12-12 | 4 | 13.88 | 1 | 80.75 | 28 | SO47454 | 2022-12-19 | 6.46 | 55.51 | 20.19 |
SO44549_1 | 2479-4173-87 | PO5568135148 | 100 | 285 | 232 | 422 | 5 | 2022-02-23 | 144.20 | 3.61 | 2022-02-11 | 5 | 31.72 | 1 | 144.20 | 1 | SO44549 | 2022-02-18 | 11.54 | 158.62 | 28.84 |
SO50757_3 | 5C6E-4693-95 | PO9048116268 | 100 | 285 | 468 | 652 | 5 | 2023-09-23 | 45.59 | 1.14 | 2023-09-11 | 2 | 15.67 | 1 | 45.59 | 3 | SO50757 | 2023-09-18 | 3.65 | 31.34 | 22.79 |
SO47454_7 | E249-41EE-95 | PO9570119946 | 100 | 285 | 412 | 585 | 5 | 2022-12-24 | 360.26 | 9.01 | 2022-12-12 | 2 | 133.30 | 1 | 360.26 | 7 | SO47454 | 2022-12-19 | 28.82 | 266.59 | 180.13 |
Generated 2024-11-10 09:25:41.143 UTC