[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 296 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63179_1 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 359 | 535 | 7 | 2024-04-03 | 5507.98 | 137.70 | 2024-03-22 | 4 | 1251.98 | 1 | 5507.98 | 1 | SO63179 | 2024-03-29 | 440.64 | 5007.93 | 1376.99 |
SO48005_5 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 377 | 638 | 7 | 2023-01-02 | 2617.88 | 65.45 | 2022-12-21 | 2 | 1320.68 | 1 | 2617.88 | 5 | SO48005 | 2022-12-28 | 209.43 | 2641.37 | 1308.94 |
SO50673_13 | 5E3E-4044-A0 | PO15515116492 | 100 | 292 | 370 | 481 | 7 | 2023-08-02 | 2932.02 | 73.30 | 2023-07-21 | 2 | 1518.79 | 1 | 2932.02 | 13 | SO50673 | 2023-07-28 | 234.56 | 3037.57 | 1466.01 |
SO61231_4 | 9687-4B86-98 | PO13514155381 | 100 | 292 | 222 | 337 | 7 | 2024-03-03 | 41.99 | 1.05 | 2024-02-20 | 2 | 13.09 | 1 | 41.99 | 4 | SO61231 | 2024-02-27 | 3.36 | 26.17 | 20.99 |
SO50681_13 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 383 | 499 | 7 | 2023-08-02 | 600.26 | 15.01 | 2023-07-21 | 1 | 605.65 | 1 | 600.26 | 13 | SO50681 | 2023-07-28 | 48.02 | 605.65 | 600.26 |
SO51739_29 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 513 | 175 | 7 | 2023-10-02 | 436.91 | 10.92 | 2023-09-20 | 2 | 199.38 | 1 | 436.91 | 29 | SO51739 | 2023-09-27 | 34.95 | 398.75 | 218.45 |
SO57119_12 | 588B-4457-8A | PO3712174757 | 100 | 292 | 555 | 662 | 7 | 2024-01-02 | 63.90 | 1.60 | 2023-12-21 | 1 | 47.29 | 1 | 63.90 | 12 | SO57119 | 2023-12-28 | 5.11 | 47.29 | 63.90 |
SO47377_3 | FA63-499A-AB | PO15515156459 | 100 | 292 | 271 | 481 | 7 | 2022-11-02 | 607.00 | 15.17 | 2022-10-21 | 3 | 187.16 | 1 | 607.00 | 3 | SO47377 | 2022-10-28 | 48.56 | 561.47 | 202.33 |
SO49833_5 | 595A-4EFA-AC | PO13340158028 | 100 | 292 | 409 | 355 | 7 | 2023-06-02 | 1046.28 | 26.16 | 2023-05-21 | 5 | 185.82 | 1 | 1046.28 | 5 | SO49833 | 2023-05-28 | 83.70 | 929.10 | 209.26 |
SO69437_46 | AEEE-4ABB-A6 | PO12702116983 | 100 | 292 | 515 | 175 | 7 | 2024-07-02 | 65.09 | 1.63 | 2024-06-20 | 4 | 12.04 | 1 | 65.09 | 46 | SO69437 | 2024-06-27 | 5.21 | 48.17 | 16.27 |
SO65226_10 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 581 | 481 | 7 | 2024-05-02 | 3061.78 | 76.54 | 2024-04-20 | 3 | 1082.51 | 1 | 3061.78 | 10 | SO65226 | 2024-04-27 | 244.94 | 3247.53 | 1020.59 |
SO51724_6 | 9157-480F-8E | PO15080116248 | 100 | 292 | 573 | 283 | 7 | 2023-10-02 | 2860.88 | 71.52 | 2023-09-20 | 2 | 1481.94 | 1 | 2860.88 | 6 | SO51724 | 2023-09-27 | 228.87 | 2963.88 | 1430.44 |
SO50222_17 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 447 | 638 | 7 | 2023-07-02 | 15.00 | 0.38 | 2023-06-20 | 1 | 10.31 | 1 | 15.00 | 17 | SO50222 | 2023-06-27 | 1.20 | 10.31 | 15.00 |
SO51739_21 | AF60-4F2F-9B | PO12702124697 | 100 | 292 | 555 | 175 | 7 | 2023-10-02 | 319.50 | 7.99 | 2023-09-20 | 5 | 47.29 | 1 | 319.50 | 21 | SO51739 | 2023-09-27 | 25.56 | 236.43 | 63.90 |
SO53478_4 | 6005-4C44-A8 | PO15486115045 | 100 | 292 | 513 | 121 | 7 | 2023-11-02 | 436.91 | 10.92 | 2023-10-21 | 2 | 199.38 | 1 | 436.91 | 4 | SO53478 | 2023-10-28 | 34.95 | 398.75 | 218.45 |
SO50222_8 | 4FDE-4C03-A9 | PO13427181046 | 100 | 292 | 375 | 638 | 7 | 2023-07-02 | 3926.81 | 98.17 | 2023-06-20 | 3 | 1320.68 | 1 | 3926.81 | 8 | SO50222 | 2023-06-27 | 314.15 | 3962.05 | 1308.94 |
SO51752_10 | C68C-4AF8-B1 | PO11223127670 | 100 | 292 | 555 | 632 | 7 | 2023-10-02 | 255.60 | 6.39 | 2023-09-20 | 4 | 47.29 | 1 | 255.60 | 10 | SO51752 | 2023-09-27 | 20.45 | 189.14 | 63.90 |
SO46653_2 | 124E-471A-9C | PO3538157862 | 100 | 292 | 448 | 229 | 7 | 2022-09-01 | 11.99 | 0.30 | 2022-08-20 | 1 | 8.25 | 1 | 11.99 | 2 | SO46653 | 2022-08-27 | 0.96 | 8.25 | 11.99 |
SO58943_19 | 8472-486E-87 | PO12673119602 | 100 | 292 | 434 | 499 | 7 | 2024-02-01 | 1427.59 | 35.69 | 2024-01-20 | 4 | 360.94 | 1 | 1427.59 | 19 | SO58943 | 2024-01-27 | 114.21 | 1443.77 | 356.90 |
SO57055_6 | 3CBC-4CD2-B1 | PO13369127604 | 100 | 292 | 547 | 391 | 7 | 2024-01-02 | 48.59 | 1.21 | 2023-12-21 | 1 | 35.96 | 1 | 48.59 | 6 | SO57055 | 2023-12-28 | 3.89 | 35.96 | 48.59 |
SO69535_15 | 0821-419A-83 | PO3567173828 | 100 | 292 | 577 | 193 | 7 | 2024-07-02 | 2915.64 | 72.89 | 2024-06-20 | 4 | 755.15 | 1 | 2915.64 | 15 | SO69535 | 2024-06-27 | 233.25 | 3020.60 | 728.91 |
SO69426_37 | 4194-45D7-B6 | PO13427130433 | 100 | 292 | 434 | 638 | 7 | 2024-07-02 | 1070.69 | 26.77 | 2024-06-20 | 3 | 360.94 | 1 | 1070.69 | 37 | SO69426 | 2024-06-27 | 85.66 | 1082.83 | 356.90 |
SO47680_1 | FD44-4F17-A1 | PO13340181659 | 100 | 292 | 421 | 355 | 7 | 2022-12-02 | 392.66 | 9.82 | 2022-11-20 | 2 | 145.28 | 1 | 392.66 | 1 | SO47680 | 2022-11-27 | 31.41 | 290.57 | 196.33 |
SO50673_22 | 5E3E-4044-A0 | PO15515116492 | 100 | 292 | 331 | 481 | 7 | 2023-08-02 | 939.59 | 23.49 | 2023-07-21 | 2 | 486.71 | 1 | 939.59 | 22 | SO50673 | 2023-07-28 | 75.17 | 973.41 | 469.79 |
SO48005_54 | 634C-42C5-AB | PO13427183371 | 100 | 292 | 280 | 638 | 7 | 2023-01-02 | 367.88 | 9.20 | 2022-12-21 | 2 | 170.14 | 1 | 367.88 | 54 | SO48005 | 2022-12-28 | 29.43 | 340.29 | 183.94 |
SO49488_23 | AB06-4177-BD | PO15515149078 | 100 | 292 | 271 | 481 | 7 | 2023-05-02 | 809.33 | 20.23 | 2023-04-20 | 4 | 187.16 | 1 | 809.33 | 23 | SO49488 | 2023-04-27 | 64.75 | 748.63 | 202.33 |
SO47705_6 | 44B1-4219-8A | PO3509151426 | 36 | 292 | 456 | 139 | 7 | 2022-12-02 | 179.98 | 4.50 | 2022-11-20 | 4 | 30.93 | 1 | 179.98 | 6 | SO47705 | 2022-11-27 | 14.40 | 123.73 | 44.99 |
SO48755_3 | 038B-40BE-A4 | PO13340115035 | 100 | 292 | 367 | 355 | 7 | 2023-03-04 | 647.99 | 16.20 | 2023-02-20 | 1 | 598.44 | 1 | 647.99 | 3 | SO48755 | 2023-02-27 | 51.84 | 598.44 | 647.99 |
SO65226_8 | 55DE-4772-82 | PO15515186601 | 100 | 292 | 231 | 481 | 7 | 2024-05-02 | 119.98 | 3.00 | 2024-04-20 | 4 | 38.49 | 1 | 119.98 | 8 | SO65226 | 2024-04-27 | 9.60 | 153.97 | 29.99 |
SO50681_20 | C44A-4F6F-86 | PO12673115760 | 100 | 292 | 327 | 499 | 7 | 2023-08-02 | 1409.38 | 35.23 | 2023-07-21 | 3 | 486.71 | 1 | 1409.38 | 20 | SO50681 | 2023-07-28 | 112.75 | 1460.12 | 469.79 |
Generated 2024-09-19 21:23:28.625 UTC