[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '5' > < SKIP 593 > < TAKE 30 >
30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59070_1 | 6AFE-4CF6-88 | PO9251141063 | 100 | 285 | 522 | 351 | 5 | 2024-02-02 | 23.48 | 0.59 | 2024-01-21 | 1 | 17.38 | 1 | 23.48 | 1 | SO59070 | 2024-01-28 | 1.88 | 17.38 | 23.48 | |||
SO43875_7 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 344 | 278 | 5 | 2021-10-03 | 12239.96 | 306.00 | 2021-09-21 | 6 | 1912.15 | 1 | 12239.96 | 7 | SO43875 | 2021-09-28 | 979.20 | 11472.93 | 2039.99 | |||
SO47703_5 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 422 | 404 | 5 | 2022-12-03 | 67.54 | 1.69 | 2022-11-21 | 1 | 49.98 | 1 | 67.54 | 5 | SO47703 | 2022-11-28 | 5.40 | 49.98 | 67.54 | |||
SO51701_2 | 9BDF-42CB-8A | PO17255146915 | 100 | 285 | 564 | 14 | 80 | 5 | 381.45 | 2023-10-03 | 1907.26 | 38.15 | 2023-09-21 | 2 | 1481.94 | 1 | 1525.80 | 2 | SO51701 | 2023-09-28 | 122.06 | 2963.88 | 953.63 | 0.20 |
SO59070_2 | 6AFE-4CF6-88 | PO9251141063 | 100 | 285 | 497 | 351 | 5 | 2024-02-02 | 1204.69 | 30.12 | 2024-01-21 | 2 | 601.74 | 1 | 1204.69 | 2 | SO59070 | 2024-01-28 | 96.38 | 1203.49 | 602.35 | |||
SO43875_8 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 212 | 278 | 5 | 2021-10-03 | 40.37 | 1.01 | 2021-09-21 | 2 | 12.03 | 1 | 40.37 | 8 | SO43875 | 2021-09-28 | 3.23 | 24.06 | 20.19 | |||
SO47703_6 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 343 | 404 | 5 | 2022-12-03 | 1409.38 | 35.23 | 2022-11-21 | 3 | 486.71 | 1 | 1409.38 | 6 | SO47703 | 2022-11-28 | 112.75 | 1460.12 | 469.79 | |||
SO51705_1 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 490 | 441 | 5 | 2023-10-03 | 226.76 | 5.67 | 2023-09-21 | 7 | 41.57 | 1 | 226.76 | 1 | SO51705 | 2023-09-28 | 18.14 | 291.01 | 32.39 | |||
SO59070_3 | 6AFE-4CF6-88 | PO9251141063 | 100 | 285 | 586 | 351 | 5 | 2024-02-02 | 890.82 | 22.27 | 2024-01-21 | 2 | 461.44 | 1 | 890.82 | 3 | SO59070 | 2024-01-28 | 71.27 | 922.89 | 445.41 | |||
SO43875_9 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 307 | 278 | 5 | 2021-10-03 | 3612.97 | 90.32 | 2021-09-21 | 5 | 623.84 | 1 | 3612.97 | 9 | SO43875 | 2021-09-28 | 289.04 | 3119.20 | 722.59 | |||
SO47703_7 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 327 | 404 | 5 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 7 | SO47703 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO51705_2 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 580 | 441 | 5 | 2023-10-03 | 2041.19 | 51.03 | 2023-09-21 | 2 | 1082.51 | 1 | 2041.19 | 2 | SO51705 | 2023-09-28 | 163.30 | 2165.02 | 1020.59 | |||
SO59071_1 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 390 | 170 | 5 | 2024-02-02 | 3361.47 | 84.04 | 2024-01-21 | 5 | 713.08 | 1 | 3361.47 | 1 | SO59071 | 2024-01-28 | 268.92 | 3565.40 | 672.29 | |||
SO43875_10 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 346 | 2 | 278 | 5 | 473.28 | 2021-10-03 | 23663.93 | 579.77 | 2021-09-21 | 12 | 1912.15 | 1 | 23190.65 | 10 | SO43875 | 2021-09-28 | 1855.25 | 22945.85 | 1971.99 | 0.02 |
SO47703_8 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 325 | 404 | 5 | 2022-12-03 | 939.59 | 23.49 | 2022-11-21 | 2 | 486.71 | 1 | 939.59 | 8 | SO47703 | 2022-11-28 | 75.17 | 973.41 | 469.79 | |||
SO51705_3 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 477 | 441 | 5 | 2023-10-03 | 5.99 | 0.15 | 2023-09-21 | 2 | 1.87 | 1 | 5.99 | 3 | SO51705 | 2023-09-28 | 0.48 | 3.73 | 2.99 | |||
SO59071_2 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 382 | 170 | 5 | 2024-02-02 | 4706.06 | 117.65 | 2024-01-21 | 7 | 713.08 | 1 | 4706.06 | 2 | SO59071 | 2024-01-28 | 376.48 | 4991.56 | 672.29 | |||
SO43875_11 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 300 | 278 | 5 | 2021-10-03 | 809.76 | 20.24 | 2021-09-21 | 1 | 699.09 | 1 | 809.76 | 11 | SO43875 | 2021-09-28 | 64.78 | 699.09 | 809.76 | |||
SO47703_9 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 458 | 404 | 5 | 2022-12-03 | 44.99 | 1.12 | 2022-11-21 | 1 | 30.93 | 1 | 44.99 | 9 | SO47703 | 2022-11-28 | 3.60 | 30.93 | 44.99 | |||
SO51705_4 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 484 | 441 | 5 | 2023-10-03 | 9.54 | 0.24 | 2023-09-21 | 2 | 2.97 | 1 | 9.54 | 4 | SO51705 | 2023-09-28 | 0.76 | 5.95 | 4.77 | |||
SO59071_3 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 546 | 170 | 5 | 2024-02-02 | 223.52 | 5.59 | 2024-01-21 | 6 | 27.57 | 1 | 223.52 | 3 | SO59071 | 2024-01-28 | 17.88 | 165.41 | 37.25 | |||
SO43875_12 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 348 | 2 | 278 | 5 | 508.95 | 2021-10-03 | 25447.42 | 623.46 | 2021-09-21 | 13 | 1898.09 | 1 | 24938.48 | 12 | SO43875 | 2021-09-28 | 1995.08 | 24675.23 | 1957.49 | 0.02 |
SO47703_10 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 333 | 404 | 5 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 10 | SO47703 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO51705_5 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 217 | 441 | 5 | 2023-10-03 | 41.99 | 1.05 | 2023-09-21 | 2 | 13.09 | 1 | 41.99 | 5 | SO51705 | 2023-09-28 | 3.36 | 26.17 | 20.99 | |||
SO59071_4 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 378 | 170 | 5 | 2024-02-02 | 4398.03 | 109.95 | 2024-01-21 | 3 | 1554.95 | 1 | 4398.03 | 4 | SO59071 | 2024-01-28 | 351.84 | 4664.84 | 1466.01 | |||
SO43875_13 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 345 | 278 | 5 | 2021-10-03 | 4079.99 | 102.00 | 2021-09-21 | 2 | 1912.15 | 1 | 4079.99 | 13 | SO43875 | 2021-09-28 | 326.40 | 3824.31 | 2039.99 | |||
SO47703_11 | 0E62-43AC-8E | PO3741184156 | 100 | 285 | 456 | 404 | 5 | 2022-12-03 | 314.96 | 7.87 | 2022-11-21 | 7 | 30.93 | 1 | 314.96 | 11 | SO47703 | 2022-11-28 | 25.20 | 216.53 | 44.99 | |||
SO51705_6 | DFFB-4C23-BD | PO16965171069 | 100 | 285 | 547 | 441 | 5 | 2023-10-03 | 194.38 | 4.86 | 2023-09-21 | 4 | 35.96 | 1 | 194.38 | 6 | SO51705 | 2023-09-28 | 15.55 | 143.84 | 48.59 | |||
SO59071_5 | EFC3-4244-A6 | PO9599176835 | 100 | 285 | 490 | 170 | 5 | 2024-02-02 | 32.39 | 0.81 | 2024-01-21 | 1 | 41.57 | 1 | 32.39 | 5 | SO59071 | 2024-01-28 | 2.59 | 41.57 | 32.39 | |||
SO43875_14 | CE1F-4E31-89 | PO12586178184 | 100 | 285 | 349 | 278 | 5 | 2021-10-03 | 16199.95 | 405.00 | 2021-09-21 | 8 | 1898.09 | 1 | 16199.95 | 14 | SO43875 | 2021-09-28 | 1296.00 | 15184.76 | 2024.99 |
Generated 2024-09-20 08:25:41.520 UTC