[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 2328 > < 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63179_22 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 531 | 535 | 7 | 2024-04-05 | 299.75 | 7.49 | 2024-03-24 | 2 | 136.79 | 1 | 299.75 | 22 | SO63179 | 2024-03-31 | 23.98 | 273.57 | 149.87 |
SO63179_23 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 551 | 535 | 7 | 2024-04-05 | 158.43 | 3.96 | 2024-03-24 | 1 | 144.59 | 1 | 158.43 | 23 | SO63179 | 2024-03-31 | 12.67 | 144.59 | 158.43 |
SO63179_24 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 524 | 535 | 7 | 2024-04-05 | 158.43 | 3.96 | 2024-03-24 | 1 | 144.59 | 1 | 158.43 | 24 | SO63179 | 2024-03-31 | 12.67 | 144.59 | 158.43 |
SO63179_25 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 532 | 535 | 7 | 2024-04-05 | 149.87 | 3.75 | 2024-03-24 | 1 | 136.79 | 1 | 149.87 | 25 | SO63179 | 2024-03-31 | 11.99 | 136.79 | 149.87 |
SO63179_26 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 517 | 535 | 7 | 2024-04-05 | 157.92 | 3.95 | 2024-03-24 | 5 | 23.37 | 1 | 157.92 | 26 | SO63179 | 2024-03-31 | 12.63 | 116.86 | 31.58 |
SO63179_27 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 298 | 535 | 7 | 2024-04-05 | 2429.28 | 60.73 | 2024-03-24 | 3 | 739.04 | 1 | 2429.28 | 27 | SO63179 | 2024-03-31 | 194.34 | 2217.12 | 809.76 |
SO63179_28 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 552 | 535 | 7 | 2024-04-05 | 109.79 | 2.74 | 2024-03-24 | 2 | 40.62 | 1 | 109.79 | 28 | SO63179 | 2024-03-31 | 8.78 | 81.24 | 54.89 |
SO63179_29 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 558 | 535 | 7 | 2024-04-05 | 242.99 | 6.07 | 2024-03-24 | 1 | 179.82 | 1 | 242.99 | 29 | SO63179 | 2024-03-31 | 19.44 | 179.82 | 242.99 |
SO63179_30 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 465 | 535 | 7 | 2024-04-05 | 88.16 | 2.20 | 2024-03-24 | 6 | 9.16 | 1 | 88.16 | 30 | SO63179 | 2024-03-31 | 7.05 | 54.96 | 14.69 |
SO63179_31 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 306 | 535 | 7 | 2024-04-05 | 3239.04 | 80.98 | 2024-03-24 | 4 | 739.04 | 1 | 3239.04 | 31 | SO63179 | 2024-03-31 | 259.12 | 2956.16 | 809.76 |
SO63179_32 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 490 | 535 | 7 | 2024-04-05 | 161.97 | 4.05 | 2024-03-24 | 5 | 41.57 | 1 | 161.97 | 32 | SO63179 | 2024-03-31 | 12.96 | 207.86 | 32.39 |
SO63179_33 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 477 | 535 | 7 | 2024-04-05 | 14.97 | 0.37 | 2024-03-24 | 5 | 1.87 | 1 | 14.97 | 33 | SO63179 | 2024-03-31 | 1.20 | 9.33 | 2.99 |
SO63179_34 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 237 | 535 | 7 | 2024-04-05 | 59.99 | 1.50 | 2024-03-24 | 2 | 38.49 | 1 | 59.99 | 34 | SO63179 | 2024-03-31 | 4.80 | 76.98 | 29.99 |
SO63179_35 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 217 | 535 | 7 | 2024-04-05 | 62.98 | 1.57 | 2024-03-24 | 3 | 13.09 | 1 | 62.98 | 35 | SO63179 | 2024-03-31 | 5.04 | 39.26 | 20.99 |
SO63179_36 | F2C5-4376-B7 | PO2668147145 | 100 | 292 | 361 | 535 | 7 | 2024-04-05 | 2753.99 | 68.85 | 2024-03-24 | 2 | 1251.98 | 1 | 2753.99 | 36 | SO63179 | 2024-03-31 | 220.32 | 2503.96 | 1376.99 |
SO57061_65 | C48C-4776-A7 | PO12702183787 | 100 | 292 | 398 | 175 | 7 | 2024-01-04 | 53.45 | 1.34 | 2023-12-23 | 2 | 19.78 | 1 | 53.45 | 65 | SO57061 | 2023-12-30 | 4.28 | 39.55 | 26.72 |
SO57068_1 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 601 | 632 | 7 | 2024-01-04 | 32.39 | 0.81 | 2023-12-23 | 1 | 23.97 | 1 | 32.39 | 1 | SO57068 | 2023-12-30 | 2.59 | 23.97 | 32.39 |
SO57068_2 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 595 | 632 | 7 | 2024-01-04 | 677.99 | 16.95 | 2023-12-23 | 2 | 308.22 | 1 | 677.99 | 2 | SO57068 | 2023-12-30 | 54.24 | 616.44 | 338.99 |
SO57068_3 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 514 | 632 | 7 | 2024-01-04 | 63.90 | 1.60 | 2023-12-23 | 1 | 47.29 | 1 | 63.90 | 3 | SO57068 | 2023-12-30 | 5.11 | 47.29 | 63.90 |
SO57068_4 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 516 | 632 | 7 | 2024-01-04 | 70.45 | 1.76 | 2023-12-23 | 3 | 17.38 | 1 | 70.45 | 4 | SO57068 | 2023-12-30 | 5.64 | 52.13 | 23.48 |
SO57068_5 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 591 | 632 | 7 | 2024-01-04 | 1355.98 | 33.90 | 2023-12-23 | 4 | 308.22 | 1 | 1355.98 | 5 | SO57068 | 2023-12-30 | 108.48 | 1232.87 | 338.99 |
SO57068_6 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 555 | 632 | 7 | 2024-01-04 | 191.70 | 4.79 | 2023-12-23 | 3 | 47.29 | 1 | 191.70 | 6 | SO57068 | 2023-12-30 | 15.34 | 141.86 | 63.90 |
SO57068_7 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 517 | 632 | 7 | 2024-01-04 | 31.58 | 0.79 | 2023-12-23 | 1 | 23.37 | 1 | 31.58 | 7 | SO57068 | 2023-12-30 | 2.53 | 23.37 | 31.58 |
SO57068_8 | 0E44-4044-B3 | PO11223190191 | 100 | 292 | 544 | 632 | 7 | 2024-01-04 | 97.19 | 2.43 | 2023-12-23 | 2 | 35.96 | 1 | 97.19 | 8 | SO57068 | 2023-12-30 | 7.78 | 71.92 | 48.59 |
Generated 2024-09-21 04:32:49.917 UTC