[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 587 > < TAKE 12 >
12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43875_21 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 229 | 278 | 5 | 2021-11-27 | 57.68 | 1.44 | 2021-11-15 | 2 | 31.72 | 1 | 57.68 | 21 | SO43875 | 2021-11-22 | 4.61 | 63.45 | 28.84 | |||
SO47725_8 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 230 | 81 | 5 | 2023-01-27 | 28.84 | 0.72 | 2023-01-15 | 1 | 29.08 | 1 | 28.84 | 8 | SO47725 | 2023-01-22 | 2.31 | 29.08 | 28.84 | |||
SO51147_42 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 546 | 81 | 5 | 2023-10-27 | 37.25 | 0.93 | 2023-10-15 | 1 | 27.57 | 1 | 37.25 | 42 | SO51147 | 2023-10-22 | 2.98 | 27.57 | 37.25 | |||
SO59071_13 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 418 | 170 | 5 | 2024-03-28 | 1070.69 | 26.77 | 2024-03-16 | 3 | 360.94 | 1 | 1070.69 | 13 | SO59071 | 2024-03-23 | 85.66 | 1082.83 | 356.90 | |||
SO43887_1 | 790D-448C-AA | PO1276169981 | 100 | 285 | 332 | 548 | 5 | 2021-11-27 | 419.46 | 10.49 | 2021-11-15 | 1 | 413.15 | 1 | 419.46 | 1 | SO43887 | 2021-11-22 | 33.56 | 413.15 | 419.46 | |||
SO47725_9 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 407 | 81 | 5 | 2023-01-27 | 65.60 | 1.64 | 2023-01-15 | 1 | 48.55 | 1 | 65.60 | 9 | SO47725 | 2023-01-22 | 5.25 | 48.55 | 65.60 | |||
SO51147_43 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 214 | 11 | 81 | 5 | 28.34 | 2023-10-27 | 188.95 | 4.02 | 2023-10-15 | 12 | 13.09 | 1 | 160.60 | 43 | SO51147 | 2023-10-22 | 12.85 | 157.04 | 15.75 | 0.15 |
SO59071_14 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 408 | 170 | 5 | 2024-03-28 | 288.65 | 7.22 | 2024-03-16 | 4 | 53.40 | 1 | 288.65 | 14 | SO59071 | 2024-03-23 | 23.09 | 213.60 | 72.16 | |||
SO43900_1 | 1593-4BBA-9B | PO5568199700 | 100 | 285 | 344 | 422 | 5 | 2021-11-27 | 8159.98 | 204.00 | 2021-11-15 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO43900 | 2021-11-22 | 652.80 | 7648.62 | 2039.99 | |||
SO47725_10 | 2501-4A1D-99 | PO9831133395 | 100 | 285 | 464 | 81 | 5 | 2023-01-27 | 84.77 | 2.12 | 2023-01-15 | 6 | 9.71 | 1 | 84.77 | 10 | SO47725 | 2023-01-22 | 6.78 | 58.28 | 14.13 | |||
SO51147_44 | C4D7-458D-A6 | PO9831167474 | 100 | 285 | 480 | 81 | 5 | 2023-10-27 | 5.50 | 0.14 | 2023-10-15 | 4 | 0.86 | 1 | 5.50 | 44 | SO51147 | 2023-10-22 | 0.44 | 3.43 | 1.37 | |||
SO59071_15 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 463 | 170 | 5 | 2024-03-28 | 14.69 | 0.37 | 2024-03-16 | 1 | 9.16 | 1 | 14.69 | 15 | SO59071 | 2024-03-23 | 1.18 | 9.16 | 14.69 |
Generated 2024-11-14 08:04:16.366 UTC