[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 554 > < TAKE 24 >
24 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51147_44 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 480 | 81 | 5 | 2023-10-23 | 5.50 | 0.14 | 2023-10-11 | 4 | 0.86 | 1 | 5.50 | 44 | SO51147 | 2023-10-18 | 0.44 | 3.43 | 1.37 | |||
SO43900_2 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 219 | 422 | 5 | 2021-11-23 | 22.80 | 0.57 | 2021-11-11 | 4 | 3.40 | 1 | 22.80 | 2 | SO43900 | 2021-11-18 | 1.82 | 13.59 | 5.70 | |||
SO51147_45 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 440 | 81 | 5 | 2023-10-23 | 858.90 | 21.47 | 2023-10-11 | 1 | 868.63 | 1 | 858.90 | 45 | SO51147 | 2023-10-18 | 68.71 | 868.63 | 858.90 | |||
SO43900_3 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 345 | 422 | 5 | 2021-11-23 | 4079.99 | 102.00 | 2021-11-11 | 2 | 1912.15 | 1 | 4079.99 | 3 | SO43900 | 2021-11-18 | 326.40 | 3824.31 | 2039.99 | |||
SO51147_46 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 482 | 81 | 5 | 2023-10-23 | 5.39 | 0.13 | 2023-10-11 | 1 | 3.36 | 1 | 5.39 | 46 | SO51147 | 2023-10-18 | 0.43 | 3.36 | 5.39 | |||
SO43900_4 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 349 | 422 | 5 | 2021-11-23 | 4049.99 | 101.25 | 2021-11-11 | 2 | 1898.09 | 1 | 4049.99 | 4 | SO43900 | 2021-11-18 | 324.00 | 3796.19 | 2024.99 | |||
SO51147_47 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 430 | 81 | 5 | 2023-10-23 | 713.80 | 17.84 | 2023-10-11 | 2 | 360.94 | 1 | 713.80 | 47 | SO51147 | 2023-10-18 | 57.10 | 721.89 | 356.90 | |||
SO43900_5 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 218 | 422 | 5 | 2021-11-23 | 45.60 | 1.14 | 2021-11-11 | 8 | 3.40 | 1 | 45.60 | 5 | SO43900 | 2021-11-18 | 3.65 | 27.17 | 5.70 | |||
SO51147_48 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 483 | 2 | 81 | 5 | 15.31 | 2023-10-23 | 765.60 | 18.76 | 2023-10-11 | 11 | 44.88 | 1 | 750.29 | 48 | SO51147 | 2023-10-18 | 60.02 | 493.68 | 69.60 | 0.02 |
SO43900_6 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 350 | 422 | 5 | 2021-11-23 | 2024.99 | 50.62 | 2021-11-11 | 1 | 1898.09 | 1 | 2024.99 | 6 | SO43900 | 2021-11-18 | 162.00 | 1898.09 | 2024.99 | |||
SO51147_49 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 225 | 81 | 5 | 2023-10-23 | 53.94 | 1.35 | 2023-10-11 | 10 | 6.92 | 1 | 53.94 | 49 | SO51147 | 2023-10-18 | 4.32 | 69.22 | 5.39 | |||
SO43900_7 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 346 | 422 | 5 | 2021-11-23 | 6119.98 | 153.00 | 2021-11-11 | 3 | 1912.15 | 1 | 6119.98 | 7 | SO43900 | 2021-11-18 | 489.60 | 5736.46 | 2039.99 | |||
SO51147_50 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 488 | 81 | 5 | 2023-10-23 | 129.58 | 3.24 | 2023-10-11 | 4 | 41.57 | 1 | 129.58 | 50 | SO51147 | 2023-10-18 | 10.37 | 166.29 | 32.39 | |||
SO43900_8 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 351 | 422 | 5 | 2021-11-23 | 4049.99 | 101.25 | 2021-11-11 | 2 | 1898.09 | 1 | 4049.99 | 8 | SO43900 | 2021-11-18 | 324.00 | 3796.19 | 2024.99 | |||
SO51158_1 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 482 | 404 | 5 | 2023-10-23 | 48.55 | 1.21 | 2023-10-11 | 9 | 3.36 | 1 | 48.55 | 1 | SO51158 | 2023-10-18 | 3.88 | 30.26 | 5.39 | |||
SO43900_9 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 348 | 422 | 5 | 2021-11-23 | 6074.98 | 151.87 | 2021-11-11 | 3 | 1898.09 | 1 | 6074.98 | 9 | SO43900 | 2021-11-18 | 486.00 | 5694.28 | 2024.99 | |||
SO51158_2 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 545 | 404 | 5 | 2023-10-23 | 24.29 | 0.61 | 2023-10-11 | 1 | 17.98 | 1 | 24.29 | 2 | SO51158 | 2023-10-18 | 1.94 | 17.98 | 24.29 | |||
SO43902_1 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 229 | 566 | 5 | 2021-11-23 | 28.84 | 0.72 | 2021-11-11 | 1 | 31.72 | 1 | 28.84 | 1 | SO43902 | 2021-11-18 | 2.31 | 31.72 | 28.84 | |||
SO51158_3 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 546 | 404 | 5 | 2023-10-23 | 37.25 | 0.93 | 2023-10-11 | 1 | 27.57 | 1 | 37.25 | 3 | SO51158 | 2023-10-18 | 2.98 | 27.57 | 37.25 | |||
SO43902_2 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 351 | 566 | 5 | 2021-11-23 | 4049.99 | 101.25 | 2021-11-11 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO43902 | 2021-11-18 | 324.00 | 3796.19 | 2024.99 | |||
SO51158_4 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 287 | 404 | 5 | 2023-10-23 | 202.33 | 5.06 | 2023-10-11 | 1 | 204.63 | 1 | 202.33 | 4 | SO51158 | 2023-10-18 | 16.19 | 204.63 | 202.33 | |||
SO43902_3 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 347 | 566 | 5 | 2021-11-23 | 6119.98 | 153.00 | 2021-11-11 | 3 | 1912.15 | 1 | 6119.98 | 3 | SO43902 | 2021-11-18 | 489.60 | 5736.46 | 2039.99 | |||
SO51158_5 | 0C39-4657-B5 | PO3741166917 | 100 | 285 | 481 | 404 | 5 | 2023-10-23 | 10.79 | 0.27 | 2023-10-11 | 2 | 3.36 | 1 | 10.79 | 5 | SO51158 | 2023-10-18 | 0.86 | 6.72 | 5.39 | |||
SO43902_4 | E3ED-44B5-B2 | PO5858178400 | 100 | 285 | 292 | 566 | 5 | 2021-11-23 | 818.70 | 20.47 | 2021-11-11 | 1 | 706.81 | 1 | 818.70 | 4 | SO43902 | 2021-11-18 | 65.50 | 706.81 | 818.70 |
Generated 2024-11-11 03:43:11.611 UTC