[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 2609 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO52243_2 | 19 | 22544 | 480 | 6 | 2023-11-30 | 0.06 | 2023-11-18 | 2.29 | 2 | SO52243 | 2023-11-25 | 0.18 | 0.86 | |
SO52243_3 | 19 | 22544 | 483 | 6 | 2023-11-30 | 3.00 | 2023-11-18 | 120.00 | 3 | SO52243 | 2023-11-25 | 9.60 | 44.88 | |
SO52244_1 | 19 | 22154 | 528 | 6 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 1 | SO52244 | 2023-11-25 | 0.40 | 1.87 | |
SO52244_2 | 19 | 22154 | 485 | 6 | 2023-11-30 | 0.55 | 2023-11-18 | 21.98 | 2 | SO52244 | 2023-11-25 | 1.76 | 8.22 | |
SO52244_3 | 19 | 22154 | 478 | 6 | 2023-11-30 | 0.25 | 2023-11-18 | 9.99 | 3 | SO52244 | 2023-11-25 | 0.80 | 3.74 | |
SO52249_1 | 19 | 18871 | 485 | 6 | 2023-11-30 | 0.55 | 2023-11-18 | 21.98 | 1 | SO52249 | 2023-11-25 | 1.76 | 8.22 | |
SO52249_2 | 19 | 18871 | 222 | 6 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 2 | SO52249 | 2023-11-25 | 2.80 | 13.09 | |
SO52261_1 | 19 | 13758 | 537 | 6 | 2023-11-30 | 0.88 | 2023-11-18 | 35.00 | 1 | SO52261 | 2023-11-25 | 2.80 | 13.09 | |
SO52261_2 | 19 | 13758 | 528 | 6 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 2 | SO52261 | 2023-11-25 | 0.40 | 1.87 | |
SO52261_3 | 19 | 13758 | 480 | 6 | 2023-11-30 | 0.06 | 2023-11-18 | 2.29 | 3 | SO52261 | 2023-11-25 | 0.18 | 0.86 | |
SO52299_1 | 19 | 11212 | 530 | 6 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 1 | SO52299 | 2023-11-26 | 0.40 | 1.87 | |
SO52302_1 | 19 | 11724 | 540 | 6 | 2023-12-01 | 0.82 | 2023-11-19 | 32.60 | 1 | SO52302 | 2023-11-26 | 2.61 | 12.19 | |
SO52302_2 | 19 | 11724 | 529 | 6 | 2023-12-01 | 0.10 | 2023-11-19 | 3.99 | 2 | SO52302 | 2023-11-26 | 0.32 | 1.49 | |
SO52302_3 | 19 | 11724 | 217 | 6 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 3 | SO52302 | 2023-11-26 | 2.80 | 13.09 | |
SO52304_1 | 19 | 12202 | 478 | 6 | 2023-12-01 | 0.25 | 2023-11-19 | 9.99 | 1 | SO52304 | 2023-11-26 | 0.80 | 3.74 | |
SO65717_1 | 19 | 13199 | 528 | 6 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 1 | SO65717 | 2024-06-24 | 0.40 | 1.87 | |
SO65717_2 | 19 | 13199 | 537 | 6 | 2024-06-29 | 0.88 | 2024-06-17 | 35.00 | 2 | SO65717 | 2024-06-24 | 2.80 | 13.09 | |
SO65717_3 | 19 | 13199 | 480 | 6 | 2024-06-29 | 0.06 | 2024-06-17 | 2.29 | 3 | SO65717 | 2024-06-24 | 0.18 | 0.86 | |
SO65720_1 | 19 | 18065 | 485 | 6 | 2024-06-29 | 0.55 | 2024-06-17 | 21.98 | 1 | SO65720 | 2024-06-24 | 1.76 | 8.22 | |
SO65720_2 | 19 | 18065 | 472 | 6 | 2024-06-29 | 1.59 | 2024-06-17 | 63.50 | 2 | SO65720 | 2024-06-24 | 5.08 | 23.75 | |
SO65723_1 | 19 | 13241 | 361 | 6 | 2024-06-29 | 57.37 | 2024-06-17 | 2294.99 | 1 | SO65723 | 2024-06-24 | 183.60 | 1251.98 | |
SO65723_2 | 19 | 13241 | 485 | 6 | 2024-06-29 | 0.55 | 2024-06-17 | 21.98 | 2 | SO65723 | 2024-06-24 | 1.76 | 8.22 | |
SO65723_3 | 19 | 13241 | 481 | 6 | 2024-06-29 | 0.22 | 2024-06-17 | 8.99 | 3 | SO65723 | 2024-06-24 | 0.72 | 3.36 | |
SO65724_1 | 19 | 17037 | 355 | 6 | 2024-06-29 | 58.00 | 2024-06-17 | 2319.99 | 1 | SO65724 | 2024-06-24 | 185.60 | 1265.62 | |
SO65724_2 | 19 | 17037 | 478 | 6 | 2024-06-29 | 0.25 | 2024-06-17 | 9.99 | 2 | SO65724 | 2024-06-24 | 0.80 | 3.74 | |
SO65724_3 | 19 | 17037 | 477 | 6 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 3 | SO65724 | 2024-06-24 | 0.40 | 1.87 | |
SO65736_1 | 19 | 14478 | 563 | 6 | 2024-06-29 | 59.60 | 2024-06-17 | 2384.07 | 1 | SO65736 | 2024-06-24 | 190.73 | 1481.94 | |
SO65736_2 | 19 | 14478 | 541 | 6 | 2024-06-29 | 0.72 | 2024-06-17 | 28.99 | 2 | SO65736 | 2024-06-24 | 2.32 | 10.84 | |
SO65736_3 | 19 | 14478 | 530 | 6 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 3 | SO65736 | 2024-06-24 | 0.40 | 1.87 | |
SO65736_4 | 19 | 14478 | 217 | 6 | 2024-06-29 | 0.87 | 2024-06-17 | 34.99 | 4 | SO65736 | 2024-06-24 | 2.80 | 13.09 | |
SO65757_1 | 19 | 11262 | 529 | 6 | 2024-06-30 | 0.10 | 2024-06-18 | 3.99 | 1 | SO65757 | 2024-06-25 | 0.32 | 1.49 | |
SO65758_1 | 19 | 11223 | 530 | 6 | 2024-06-30 | 0.12 | 2024-06-18 | 4.99 | 1 | SO65758 | 2024-06-25 | 0.40 | 1.87 | |
SO65758_2 | 19 | 11223 | 222 | 6 | 2024-06-30 | 0.87 | 2024-06-18 | 34.99 | 2 | SO65758 | 2024-06-25 | 2.80 | 13.09 | |
SO65761_1 | 19 | 11723 | 540 | 6 | 2024-06-30 | 0.82 | 2024-06-18 | 32.60 | 1 | SO65761 | 2024-06-25 | 2.61 | 12.19 | |
SO65824_1 | 19 | 12363 | 536 | 6 | 2024-07-01 | 0.75 | 2024-06-19 | 29.99 | 1 | SO65824 | 2024-06-26 | 2.40 | 11.22 | |
SO65826_1 | 19 | 15564 | 477 | 6 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 1 | SO65826 | 2024-06-26 | 0.40 | 1.87 | |
SO65826_2 | 19 | 15564 | 478 | 6 | 2024-07-01 | 0.25 | 2024-06-19 | 9.99 | 2 | SO65826 | 2024-06-26 | 0.80 | 3.74 | |
SO65828_1 | 19 | 13303 | 482 | 6 | 2024-07-01 | 0.22 | 2024-06-19 | 8.99 | 1 | SO65828 | 2024-06-26 | 0.72 | 3.36 | |
SO65828_2 | 19 | 13303 | 477 | 6 | 2024-07-01 | 0.12 | 2024-06-19 | 4.99 | 2 | SO65828 | 2024-06-26 | 0.40 | 1.87 | |
SO65830_1 | 19 | 21904 | 485 | 6 | 2024-07-01 | 0.55 | 2024-06-19 | 21.98 | 1 | SO65830 | 2024-06-26 | 1.76 | 8.22 | |
SO65830_2 | 19 | 21904 | 491 | 6 | 2024-07-01 | 1.35 | 2024-06-19 | 53.99 | 2 | SO65830 | 2024-06-26 | 4.32 | 41.57 | |
SO65844_1 | 19 | 13144 | 537 | 6 | 2024-07-01 | 0.88 | 2024-06-19 | 35.00 | 1 | SO65844 | 2024-06-26 | 2.80 | 13.09 | |
SO65844_2 | 19 | 13144 | 480 | 6 | 2024-07-01 | 0.06 | 2024-06-19 | 2.29 | 2 | SO65844 | 2024-06-26 | 0.18 | 0.86 | |
SO65844_3 | 19 | 13144 | 484 | 6 | 2024-07-01 | 0.20 | 2024-06-19 | 7.95 | 3 | SO65844 | 2024-06-26 | 0.64 | 2.97 | |
SO65845_1 | 19 | 17348 | 472 | 6 | 2024-07-01 | 1.59 | 2024-06-19 | 63.50 | 1 | SO65845 | 2024-06-26 | 5.08 | 23.75 | |
SO65845_2 | 19 | 17348 | 485 | 6 | 2024-07-01 | 0.55 | 2024-06-19 | 21.98 | 2 | SO65845 | 2024-06-26 | 1.76 | 8.22 | |
SO65847_1 | 19 | 17410 | 485 | 6 | 2024-07-01 | 0.55 | 2024-06-19 | 21.98 | 1 | SO65847 | 2024-06-26 | 1.76 | 8.22 | |
SO65847_2 | 19 | 17410 | 480 | 6 | 2024-07-01 | 0.06 | 2024-06-19 | 2.29 | 2 | SO65847 | 2024-06-26 | 0.18 | 0.86 | |
SO65860_1 | 19 | 14041 | 574 | 6 | 2024-07-01 | 59.60 | 2024-06-19 | 2384.07 | 1 | SO65860 | 2024-06-26 | 190.73 | 1481.94 | |
SO65860_2 | 19 | 14041 | 541 | 6 | 2024-07-01 | 0.72 | 2024-06-19 | 28.99 | 2 | SO65860 | 2024-06-26 | 2.32 | 10.84 | |
SO65865_1 | 19 | 20023 | 384 | 6 | 2024-07-01 | 28.01 | 2024-06-19 | 1120.49 | 1 | SO65865 | 2024-06-26 | 89.64 | 713.08 | |
SO65865_2 | 19 | 20023 | 217 | 6 | 2024-07-01 | 0.87 | 2024-06-19 | 34.99 | 2 | SO65865 | 2024-06-26 | 2.80 | 13.09 | |
SO65881_1 | 19 | 11498 | 477 | 6 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO65881 | 2024-06-27 | 0.40 | 1.87 | |
SO65881_2 | 19 | 11498 | 225 | 6 | 2024-07-02 | 0.22 | 2024-06-20 | 8.99 | 2 | SO65881 | 2024-06-27 | 0.72 | 6.92 | |
SO65881_3 | 19 | 11498 | 479 | 6 | 2024-07-02 | 0.22 | 2024-06-20 | 8.99 | 3 | SO65881 | 2024-06-27 | 0.72 | 3.36 | |
SO65882_1 | 19 | 11215 | 231 | 6 | 2024-07-02 | 1.25 | 2024-06-20 | 49.99 | 1 | SO65882 | 2024-06-27 | 4.00 | 38.49 | |
SO65892_1 | 19 | 11661 | 528 | 6 | 2024-07-02 | 0.12 | 2024-06-20 | 4.99 | 1 | SO65892 | 2024-06-27 | 0.40 | 1.87 | |
SO65892_2 | 19 | 11661 | 535 | 6 | 2024-07-02 | 0.62 | 2024-06-20 | 24.99 | 2 | SO65892 | 2024-06-27 | 2.00 | 9.35 | |
SO65892_3 | 19 | 11661 | 480 | 2 | 6 | 2024-07-02 | 0.06 | 2024-06-20 | 2.29 | 3 | SO65892 | 2024-06-27 | 0.18 | 0.86 |
SO65893_1 | 19 | 11277 | 535 | 6 | 2024-07-02 | 0.62 | 2024-06-20 | 24.99 | 1 | SO65893 | 2024-06-27 | 2.00 | 9.35 |
Generated 2024-11-10 07:53:48.193 UTC