[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 1295 > < TAKE 28 >
28 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimResellerId | DimSalesTerritoryId | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71826_26 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 353 | 176 | 8 | 2024-09-26 | 6959.97 | 174.00 | 2024-09-14 | 5 | 1265.62 | 1 | 6959.97 | 26 | SO71826 | 2024-09-21 | 556.80 | 6328.10 | 1391.99 |
SO71826_27 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 309 | 176 | 8 | 2024-09-26 | 818.70 | 20.47 | 2024-09-14 | 1 | 747.20 | 1 | 818.70 | 27 | SO71826 | 2024-09-21 | 65.50 | 747.20 | 818.70 |
SO71826_28 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 542 | 176 | 8 | 2024-09-26 | 24.29 | 0.61 | 2024-09-14 | 1 | 17.98 | 1 | 24.29 | 28 | SO71826 | 2024-09-21 | 1.94 | 17.98 | 24.29 |
SO71826_29 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 543 | 176 | 8 | 2024-09-26 | 111.76 | 2.79 | 2024-09-14 | 3 | 27.57 | 1 | 111.76 | 29 | SO71826 | 2024-09-21 | 8.94 | 82.70 | 37.25 |
SO71826_30 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 517 | 176 | 8 | 2024-09-26 | 31.58 | 0.79 | 2024-09-14 | 1 | 23.37 | 1 | 31.58 | 30 | SO71826 | 2024-09-21 | 2.53 | 23.37 | 31.58 |
SO71826_31 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 533 | 176 | 8 | 2024-09-26 | 299.75 | 7.49 | 2024-09-14 | 2 | 136.79 | 1 | 299.75 | 31 | SO71826 | 2024-09-21 | 23.98 | 273.57 | 149.87 |
SO71826_32 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 524 | 176 | 8 | 2024-09-26 | 158.43 | 3.96 | 2024-09-14 | 1 | 144.59 | 1 | 158.43 | 32 | SO71826 | 2024-09-21 | 12.67 | 144.59 | 158.43 |
SO71826_33 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 511 | 176 | 8 | 2024-09-26 | 873.82 | 21.85 | 2024-09-14 | 4 | 199.38 | 1 | 873.82 | 33 | SO71826 | 2024-09-21 | 69.91 | 797.50 | 218.45 |
SO71826_34 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 512 | 176 | 8 | 2024-09-26 | 1092.27 | 27.31 | 2024-09-14 | 5 | 199.38 | 1 | 1092.27 | 34 | SO71826 | 2024-09-21 | 87.38 | 996.88 | 218.45 |
SO71826_35 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 231 | 176 | 8 | 2024-09-26 | 149.97 | 3.75 | 2024-09-14 | 5 | 38.49 | 1 | 149.97 | 35 | SO71826 | 2024-09-21 | 12.00 | 192.46 | 29.99 |
SO71826_36 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 488 | 176 | 8 | 2024-09-26 | 64.79 | 1.62 | 2024-09-14 | 2 | 41.57 | 1 | 64.79 | 36 | SO71826 | 2024-09-21 | 5.18 | 83.14 | 32.39 |
SO71826_37 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 491 | 176 | 8 | 2024-09-26 | 129.58 | 3.24 | 2024-09-14 | 4 | 41.57 | 1 | 129.58 | 37 | SO71826 | 2024-09-21 | 10.37 | 166.29 | 32.39 |
SO71826_38 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 465 | 176 | 8 | 2024-09-26 | 58.78 | 1.47 | 2024-09-14 | 4 | 9.16 | 1 | 58.78 | 38 | SO71826 | 2024-09-21 | 4.70 | 36.64 | 14.69 |
SO71826_39 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 471 | 176 | 8 | 2024-09-26 | 228.60 | 5.72 | 2024-09-14 | 6 | 23.75 | 1 | 228.60 | 39 | SO71826 | 2024-09-21 | 18.29 | 142.49 | 38.10 |
SO71826_40 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 472 | 176 | 8 | 2024-09-26 | 114.30 | 2.86 | 2024-09-14 | 3 | 23.75 | 1 | 114.30 | 40 | SO71826 | 2024-09-21 | 9.14 | 71.25 | 38.10 |
SO71826_41 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 225 | 176 | 8 | 2024-09-26 | 16.18 | 0.40 | 2024-09-14 | 3 | 6.92 | 1 | 16.18 | 41 | SO71826 | 2024-09-21 | 1.29 | 20.77 | 5.39 |
SO71826_42 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 483 | 176 | 8 | 2024-09-26 | 216.00 | 5.40 | 2024-09-14 | 3 | 44.88 | 1 | 216.00 | 42 | SO71826 | 2024-09-21 | 17.28 | 134.64 | 72.00 |
SO71826_43 | 2BC5-437A-AF | PO11397155355 | 36 | 295 | 484 | 176 | 8 | 2024-09-26 | 23.85 | 0.60 | 2024-09-14 | 5 | 2.97 | 1 | 23.85 | 43 | SO71826 | 2024-09-21 | 1.91 | 14.87 | 4.77 |
SO71834_1 | B39D-48C8-81 | PO377116268 | 36 | 295 | 554 | 633 | 8 | 2024-09-26 | 54.94 | 1.37 | 2024-09-14 | 1 | 40.66 | 1 | 54.94 | 1 | SO71834 | 2024-09-21 | 4.40 | 40.66 | 54.94 |
SO71834_2 | B39D-48C8-81 | PO377116268 | 36 | 295 | 502 | 633 | 8 | 2024-09-26 | 200.05 | 5.00 | 2024-09-14 | 1 | 199.85 | 1 | 200.05 | 2 | SO71834 | 2024-09-21 | 16.00 | 199.85 | 200.05 |
SO71834_3 | B39D-48C8-81 | PO377116268 | 36 | 295 | 548 | 633 | 8 | 2024-09-26 | 48.59 | 1.21 | 2024-09-14 | 1 | 35.96 | 1 | 48.59 | 3 | SO71834 | 2024-09-21 | 3.89 | 35.96 | 48.59 |
SO71834_4 | B39D-48C8-81 | PO377116268 | 36 | 295 | 573 | 633 | 8 | 2024-09-26 | 1430.44 | 35.76 | 2024-09-14 | 1 | 1481.94 | 1 | 1430.44 | 4 | SO71834 | 2024-09-21 | 114.44 | 1481.94 | 1430.44 |
SO71892_1 | 5153-412B-84 | PO4814151834 | 36 | 295 | 501 | 464 | 8 | 2024-09-26 | 72.88 | 1.82 | 2024-09-14 | 1 | 53.93 | 1 | 72.88 | 1 | SO71892 | 2024-09-21 | 5.83 | 53.93 | 72.88 |
SO71892_2 | 5153-412B-84 | PO4814151834 | 36 | 295 | 564 | 464 | 8 | 2024-09-26 | 1430.44 | 35.76 | 2024-09-14 | 1 | 1481.94 | 1 | 1430.44 | 2 | SO71892 | 2024-09-21 | 114.44 | 1481.94 | 1430.44 |
SO71892_3 | 5153-412B-84 | PO4814151834 | 36 | 295 | 217 | 464 | 8 | 2024-09-26 | 146.96 | 3.67 | 2024-09-14 | 7 | 13.09 | 1 | 146.96 | 3 | SO71892 | 2024-09-21 | 11.76 | 91.60 | 20.99 |
SO71892_4 | 5153-412B-84 | PO4814151834 | 36 | 295 | 570 | 464 | 8 | 2024-09-26 | 1336.23 | 33.41 | 2024-09-14 | 3 | 461.44 | 1 | 1336.23 | 4 | SO71892 | 2024-09-21 | 106.90 | 1384.33 | 445.41 |
SO71892_5 | 5153-412B-84 | PO4814151834 | 36 | 295 | 493 | 464 | 8 | 2024-09-26 | 200.05 | 5.00 | 2024-09-14 | 1 | 199.85 | 1 | 200.05 | 5 | SO71892 | 2024-09-21 | 16.00 | 199.85 | 200.05 |
SO71892_6 | 5153-412B-84 | PO4814151834 | 36 | 295 | 465 | 464 | 8 | 2024-09-26 | 44.08 | 1.10 | 2024-09-14 | 3 | 9.16 | 1 | 44.08 | 6 | SO71892 | 2024-09-21 | 3.53 | 27.48 | 14.69 |
Generated 2024-11-13 07:54:11.831 UTC