[ROOT] dt FactResellerSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 886 > < TAKE 15 >
15 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO47692_6 | F786-4312-9B | PO10237186654 | 100 | 287 | 323 | 41 | 4 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 6 | SO47692 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO51126_27 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 493 | 205 | 4 | 2023-09-02 | 800.21 | 20.01 | 2023-08-21 | 4 | 199.85 | 1 | 800.21 | 27 | SO51126 | 2023-08-28 | 64.02 | 799.41 | 200.05 | |||
SO59014_12 | E148-47F7-98 | PO5510184760 | 100 | 287 | 490 | 5 | 4 | 2024-02-02 | 64.79 | 1.62 | 2024-01-21 | 2 | 41.57 | 1 | 64.79 | 12 | SO59014 | 2024-01-28 | 5.18 | 83.14 | 32.39 | |||
SO43906_1 | BA78-4228-89 | PO6438197212 | 100 | 283 | 348 | 309 | 4 | 2021-10-03 | 10124.97 | 253.12 | 2021-09-21 | 5 | 1898.09 | 1 | 10124.97 | 1 | SO43906 | 2021-09-28 | 810.00 | 9490.47 | 2024.99 | |||
SO47692_7 | F786-4312-9B | PO10237186654 | 100 | 287 | 325 | 41 | 4 | 2022-12-03 | 469.79 | 11.74 | 2022-11-21 | 1 | 486.71 | 1 | 469.79 | 7 | SO47692 | 2022-11-28 | 37.58 | 486.71 | 469.79 | |||
SO51126_28 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 495 | 205 | 4 | 2023-09-02 | 602.35 | 15.06 | 2023-08-21 | 1 | 601.74 | 1 | 602.35 | 28 | SO51126 | 2023-08-28 | 48.19 | 601.74 | 602.35 | |||
SO59017_1 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 513 | 25 | 4 | 2024-02-02 | 218.45 | 5.46 | 2024-01-21 | 1 | 199.38 | 1 | 218.45 | 1 | SO59017 | 2024-01-28 | 17.48 | 199.38 | 218.45 | |||
SO43906_2 | BA78-4228-89 | PO6438197212 | 100 | 283 | 350 | 309 | 4 | 2021-10-03 | 4049.99 | 101.25 | 2021-09-21 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO43906 | 2021-09-28 | 324.00 | 3796.19 | 2024.99 | |||
SO47692_8 | F786-4312-9B | PO10237186654 | 100 | 287 | 329 | 41 | 4 | 2022-12-03 | 939.59 | 23.49 | 2022-11-21 | 2 | 486.71 | 1 | 939.59 | 8 | SO47692 | 2022-11-28 | 75.17 | 973.41 | 469.79 | |||
SO51126_29 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 499 | 205 | 4 | 2023-09-02 | 3011.73 | 75.29 | 2023-08-21 | 5 | 601.74 | 1 | 3011.73 | 29 | SO51126 | 2023-08-28 | 240.94 | 3008.72 | 602.35 | |||
SO59017_2 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 551 | 25 | 4 | 2024-02-02 | 158.43 | 3.96 | 2024-01-21 | 1 | 144.59 | 1 | 158.43 | 2 | SO59017 | 2024-01-28 | 12.67 | 144.59 | 158.43 | |||
SO43906_3 | BA78-4228-89 | PO6438197212 | 100 | 283 | 218 | 4 | 309 | 4 | 12.35 | 2021-10-03 | 123.50 | 2.78 | 2021-09-21 | 26 | 3.40 | 1 | 111.15 | 3 | SO43906 | 2021-09-28 | 8.89 | 88.30 | 4.75 | 0.10 |
SO47692_9 | F786-4312-9B | PO10237186654 | 100 | 287 | 458 | 41 | 4 | 2022-12-03 | 89.99 | 2.25 | 2022-11-21 | 2 | 30.93 | 1 | 89.99 | 9 | SO47692 | 2022-11-28 | 7.20 | 61.87 | 44.99 | |||
SO51126_30 | 7A9E-43B4-B3 | PO2755153471 | 100 | 282 | 521 | 205 | 4 | 2023-09-02 | 16.27 | 0.41 | 2023-08-21 | 1 | 12.04 | 1 | 16.27 | 30 | SO51126 | 2023-08-28 | 1.30 | 12.04 | 16.27 | |||
SO59017_3 | 1571-4C89-99 | PO4582165909 | 100 | 282 | 595 | 25 | 4 | 2024-02-02 | 338.99 | 8.47 | 2024-01-21 | 1 | 308.22 | 1 | 338.99 | 3 | SO59017 | 2024-01-28 | 27.12 | 308.22 | 338.99 |
Generated 2024-09-20 20:35:36.195 UTC