[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 28 > < TAKE 24 >
24 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51857_10 | 918B-493C-BA | PO3683131763 | 100 | 292 | 521 | 85 | 7 | 2023-10-04 | 81.36 | 2.03 | 2023-09-22 | 5 | 12.04 | 1 | 81.36 | 10 | SO51857 | 2023-09-29 | 6.51 | 60.21 | 16.27 |
SO48005_24 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 422 | 638 | 7 | 2023-01-04 | 337.70 | 8.44 | 2022-12-23 | 5 | 49.98 | 1 | 337.70 | 24 | SO48005 | 2022-12-30 | 27.02 | 249.89 | 67.54 |
SO55252_8 | 1F1C-4667-AE | PO13340115824 | 100 | 292 | 472 | 355 | 7 | 2023-12-04 | 152.40 | 3.81 | 2023-11-22 | 4 | 23.75 | 1 | 152.40 | 8 | SO55252 | 2023-11-29 | 12.19 | 95.00 | 38.10 |
SO47705_15 | 44B1-4219-8A | PO3509151426 | 36 | 292 | 448 | 139 | 7 | 2022-12-04 | 71.96 | 1.80 | 2022-11-22 | 6 | 8.25 | 1 | 71.96 | 15 | SO47705 | 2022-11-29 | 5.76 | 49.48 | 11.99 |
SO71820_9 | D332-4AF2-A3 | PO12673129941 | 100 | 292 | 547 | 499 | 7 | 2024-08-04 | 194.38 | 4.86 | 2024-07-23 | 4 | 35.96 | 1 | 194.38 | 9 | SO71820 | 2024-07-30 | 15.55 | 143.84 | 48.59 |
SO53478_17 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 542 | 121 | 7 | 2023-11-04 | 97.18 | 2.43 | 2023-10-23 | 4 | 17.98 | 1 | 97.18 | 17 | SO53478 | 2023-10-30 | 7.77 | 71.91 | 24.29 |
SO63195_1 | D694-40F2-A4 | PO13311146003 | 100 | 292 | 583 | 301 | 7 | 2024-04-05 | 1020.59 | 25.51 | 2024-03-24 | 1 | 1082.51 | 1 | 1020.59 | 1 | SO63195 | 2024-03-31 | 81.65 | 1082.51 | 1020.59 |
SO71801_2 | 0DBE-43DA-9A | PO15515173664 | 100 | 292 | 547 | 481 | 7 | 2024-08-04 | 48.59 | 1.21 | 2024-07-23 | 1 | 35.96 | 1 | 48.59 | 2 | SO71801 | 2024-07-30 | 3.89 | 35.96 | 48.59 |
SO49129_40 | 1D0F-41F4-9F | PO12702195272 | 100 | 292 | 397 | 175 | 7 | 2023-04-06 | 48.59 | 1.21 | 2023-03-25 | 2 | 17.98 | 1 | 48.59 | 40 | SO49129 | 2023-04-01 | 3.89 | 35.96 | 24.29 |
SO69531_3 | 1871-4E54-BE | PO3683141039 | 100 | 292 | 586 | 85 | 7 | 2024-07-04 | 1336.23 | 33.41 | 2024-06-22 | 3 | 461.44 | 1 | 1336.23 | 3 | SO69531 | 2024-06-29 | 106.90 | 1384.33 | 445.41 |
SO57051_5 | 0E3B-4DB5-83 | PO13427178709 | 100 | 292 | 545 | 638 | 7 | 2024-01-04 | 48.59 | 1.21 | 2023-12-23 | 2 | 17.98 | 1 | 48.59 | 5 | SO57051 | 2023-12-30 | 3.89 | 35.96 | 24.29 |
SO69437_58 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 491 | 175 | 7 | 2024-07-04 | 291.55 | 7.29 | 2024-06-22 | 9 | 41.57 | 1 | 291.55 | 58 | SO69437 | 2024-06-29 | 23.32 | 374.15 | 32.39 |
SO46626_29 | CFB3-4671-A6 | PO13340194893 | 100 | 292 | 456 | 355 | 7 | 2022-09-03 | 179.98 | 4.50 | 2022-08-22 | 4 | 30.93 | 1 | 179.98 | 29 | SO46626 | 2022-08-29 | 14.40 | 123.73 | 44.99 |
SO50681_13 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 383 | 499 | 7 | 2023-08-04 | 600.26 | 15.01 | 2023-07-23 | 1 | 605.65 | 1 | 600.26 | 13 | SO50681 | 2023-07-30 | 48.02 | 605.65 | 600.26 |
SO57043_3 | F448-4B5D-89 | PO15080130371 | 100 | 292 | 560 | 283 | 7 | 2024-01-04 | 1457.82 | 36.45 | 2023-12-23 | 2 | 755.15 | 1 | 1457.82 | 3 | SO57043 | 2023-12-30 | 116.63 | 1510.30 | 728.91 |
SO57150_29 | 0163-41B3-92 | PO3683172338 | 100 | 292 | 578 | 85 | 7 | 2024-01-04 | 2915.64 | 72.89 | 2023-12-23 | 4 | 755.15 | 1 | 2915.64 | 29 | SO57150 | 2023-12-30 | 233.25 | 3020.60 | 728.91 |
SO48317_26 | FA92-4B66-88 | PO15515198588 | 100 | 292 | 414 | 481 | 7 | 2023-02-03 | 447.09 | 11.18 | 2023-01-22 | 3 | 110.28 | 1 | 447.09 | 26 | SO48317 | 2023-01-29 | 35.77 | 330.85 | 149.03 |
SO69437_21 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 517 | 175 | 7 | 2024-07-04 | 94.75 | 2.37 | 2024-06-22 | 3 | 23.37 | 1 | 94.75 | 21 | SO69437 | 2024-06-29 | 7.58 | 70.12 | 31.58 |
SO57028_9 | E080-4171-A4 | PO16704183706 | 100 | 292 | 483 | 680 | 7 | 2024-01-04 | 432.00 | 10.80 | 2023-12-23 | 6 | 44.88 | 1 | 432.00 | 9 | SO57028 | 2023-12-30 | 34.56 | 269.28 | 72.00 |
SO53478_10 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 516 | 121 | 7 | 2023-11-04 | 93.94 | 2.35 | 2023-10-23 | 4 | 17.38 | 1 | 93.94 | 10 | SO53478 | 2023-10-30 | 7.51 | 69.51 | 23.48 |
SO47377_15 | FA63-499A-AB | PO15515156459 | 100 | 292 | 333 | 481 | 7 | 2022-11-04 | 2348.97 | 58.72 | 2022-10-23 | 5 | 486.71 | 1 | 2348.97 | 15 | SO47377 | 2022-10-30 | 187.92 | 2433.53 | 469.79 |
SO48010_5 | 81A7-4B68-B2 | PO12702168891 | 100 | 292 | 427 | 175 | 7 | 2023-01-04 | 627.77 | 15.69 | 2022-12-23 | 3 | 185.82 | 1 | 627.77 | 5 | SO48010 | 2022-12-30 | 50.22 | 557.46 | 209.26 |
SO46981_50 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 286 | 638 | 7 | 2022-10-04 | 551.81 | 13.80 | 2022-09-22 | 3 | 170.14 | 1 | 551.81 | 50 | SO46981 | 2022-09-29 | 44.15 | 510.43 | 183.94 |
SO49504_10 | 2AE7-49E4-83 | PO12673121193 | 100 | 292 | 333 | 499 | 7 | 2023-05-04 | 939.59 | 23.49 | 2023-04-22 | 2 | 486.71 | 1 | 939.59 | 10 | SO49504 | 2023-04-29 | 75.17 | 973.41 | 469.79 |
Generated 2024-09-21 14:49:33.538 UTC