[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > < SKIP 23 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44441_1 | 19 | 22118 | 312 | 6 | 2021-12-25 | 89.46 | 2021-12-13 | 3578.27 | 1 | SO44441 | 2021-12-20 | 286.26 | 2171.29 | |
SO44464_1 | 19 | 22120 | 314 | 6 | 2021-12-31 | 89.46 | 2021-12-19 | 3578.27 | 1 | SO44464 | 2021-12-26 | 286.26 | 2171.29 | |
SO44466_1 | 19 | 26640 | 334 | 6 | 2021-12-31 | 17.48 | 2021-12-19 | 699.10 | 1 | SO44466 | 2021-12-26 | 55.93 | 413.15 | |
SO44588_1 | 19 | 26683 | 342 | 6 | 2022-01-06 | 17.48 | 2021-12-25 | 699.10 | 1 | SO44588 | 2022-01-01 | 55.93 | 413.15 | |
SO44677_1 | 19 | 22233 | 310 | 6 | 2022-01-20 | 89.46 | 2022-01-08 | 3578.27 | 1 | SO44677 | 2022-01-15 | 286.26 | 2171.29 | |
SO44678_1 | 19 | 22121 | 310 | 6 | 2022-01-20 | 89.46 | 2022-01-08 | 3578.27 | 1 | SO44678 | 2022-01-15 | 286.26 | 2171.29 | |
SO44694_1 | 19 | 22232 | 311 | 6 | 2022-01-23 | 89.46 | 2022-01-11 | 3578.27 | 1 | SO44694 | 2022-01-18 | 286.26 | 2171.29 | |
SO44695_1 | 19 | 19855 | 346 | 6 | 2022-01-23 | 85.00 | 2022-01-11 | 3399.99 | 1 | SO44695 | 2022-01-18 | 272.00 | 1912.15 | |
SO44699_1 | 19 | 22234 | 313 | 6 | 2022-01-25 | 89.46 | 2022-01-13 | 3578.27 | 1 | SO44699 | 2022-01-20 | 286.26 | 2171.29 | |
SO44713_1 | 19 | 22128 | 313 | 6 | 2022-01-28 | 89.46 | 2022-01-16 | 3578.27 | 1 | SO44713 | 2022-01-23 | 286.26 | 2171.29 | |
SO44715_1 | 19 | 22182 | 314 | 6 | 2022-01-28 | 89.46 | 2022-01-16 | 3578.27 | 1 | SO44715 | 2022-01-23 | 286.26 | 2171.29 | |
SO44716_1 | 19 | 22230 | 314 | 6 | 2022-01-28 | 89.46 | 2022-01-16 | 3578.27 | 1 | SO44716 | 2022-01-23 | 286.26 | 2171.29 | |
SO44721_1 | 19 | 26643 | 342 | 6 | 2022-01-29 | 17.48 | 2022-01-17 | 699.10 | 1 | SO44721 | 2022-01-24 | 55.93 | 413.15 | |
SO44811_1 | 19 | 22732 | 311 | 6 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44811 | 2022-01-29 | 286.26 | 2171.29 | |
SO44851_1 | 19 | 22299 | 310 | 6 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44851 | 2022-02-04 | 286.26 | 2171.29 | |
SO44853_1 | 19 | 19874 | 348 | 6 | 2022-02-09 | 84.37 | 2022-01-28 | 3374.99 | 1 | SO44853 | 2022-02-04 | 270.00 | 1898.09 | |
SO44855_1 | 19 | 26692 | 320 | 6 | 2022-02-09 | 17.48 | 2022-01-28 | 699.10 | 1 | SO44855 | 2022-02-04 | 55.93 | 413.15 | |
SO44892_1 | 19 | 22267 | 313 | 6 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44892 | 2022-02-09 | 286.26 | 2171.29 | |
SO44937_1 | 19 | 22251 | 311 | 6 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44937 | 2022-02-15 | 286.26 | 2171.29 | |
SO44957_1 | 19 | 22247 | 310 | 6 | 2022-02-22 | 89.46 | 2022-02-10 | 3578.27 | 1 | SO44957 | 2022-02-17 | 286.26 | 2171.29 | |
SO44960_1 | 19 | 22373 | 314 | 6 | 2022-02-22 | 89.46 | 2022-02-10 | 3578.27 | 1 | SO44960 | 2022-02-17 | 286.26 | 2171.29 | |
SO44969_1 | 19 | 22713 | 312 | 6 | 2022-02-23 | 89.46 | 2022-02-11 | 3578.27 | 1 | SO44969 | 2022-02-18 | 286.26 | 2171.29 | |
SO44983_1 | 19 | 22252 | 310 | 6 | 2022-02-25 | 89.46 | 2022-02-13 | 3578.27 | 1 | SO44983 | 2022-02-20 | 286.26 | 2171.29 | |
SO45011_1 | 19 | 22268 | 313 | 6 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45011 | 2022-02-24 | 286.26 | 2171.29 | |
SO45081_1 | 19 | 26782 | 338 | 6 | 2022-03-05 | 17.48 | 2022-02-21 | 699.10 | 1 | SO45081 | 2022-02-28 | 55.93 | 413.15 | |
SO45094_1 | 19 | 22785 | 310 | 6 | 2022-03-07 | 89.46 | 2022-02-23 | 3578.27 | 1 | SO45094 | 2022-03-02 | 286.26 | 2171.29 | |
SO45101_1 | 19 | 22748 | 313 | 6 | 2022-03-09 | 89.46 | 2022-02-25 | 3578.27 | 1 | SO45101 | 2022-03-04 | 286.26 | 2171.29 | |
SO45105_1 | 19 | 22765 | 312 | 6 | 2022-03-10 | 89.46 | 2022-02-26 | 3578.27 | 1 | SO45105 | 2022-03-05 | 286.26 | 2171.29 | |
SO45106_1 | 19 | 19987 | 348 | 6 | 2022-03-10 | 84.37 | 2022-02-26 | 3374.99 | 1 | SO45106 | 2022-03-05 | 270.00 | 1898.09 | |
SO45108_1 | 19 | 22975 | 310 | 6 | 2022-03-10 | 89.46 | 2022-02-26 | 3578.27 | 1 | SO45108 | 2022-03-05 | 286.26 | 2171.29 | |
SO45123_1 | 19 | 22971 | 311 | 6 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO45123 | 2022-03-08 | 286.26 | 2171.29 | |
SO45134_1 | 19 | 22895 | 314 | 6 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45134 | 2022-03-10 | 286.26 | 2171.29 | |
SO45142_1 | 19 | 22901 | 311 | 6 | 2022-03-16 | 89.46 | 2022-03-04 | 3578.27 | 1 | SO45142 | 2022-03-11 | 286.26 | 2171.29 | |
SO45165_1 | 19 | 22881 | 313 | 6 | 2022-03-20 | 89.46 | 2022-03-08 | 3578.27 | 1 | SO45165 | 2022-03-15 | 286.26 | 2171.29 | |
SO45193_1 | 19 | 22889 | 310 | 6 | 2022-03-24 | 89.46 | 2022-03-12 | 3578.27 | 1 | SO45193 | 2022-03-19 | 286.26 | 2171.29 | |
SO45208_1 | 19 | 19884 | 344 | 6 | 2022-03-26 | 85.00 | 2022-03-14 | 3399.99 | 1 | SO45208 | 2022-03-21 | 272.00 | 1912.15 | |
SO45219_1 | 19 | 22893 | 313 | 6 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO45219 | 2022-03-23 | 286.26 | 2171.29 | |
SO45221_1 | 19 | 22903 | 314 | 6 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO45221 | 2022-03-23 | 286.26 | 2171.29 | |
SO45252_1 | 19 | 22877 | 312 | 6 | 2022-04-03 | 89.46 | 2022-03-22 | 3578.27 | 1 | SO45252 | 2022-03-29 | 286.26 | 2171.29 | |
SO45346_1 | 100 | 28648 | 312 | 6 | 2022-04-05 | 89.46 | 2022-03-24 | 3578.27 | 1 | SO45346 | 2022-03-31 | 286.26 | 2171.29 | |
SO45353_1 | 100 | 28630 | 310 | 6 | 2022-04-06 | 89.46 | 2022-03-25 | 3578.27 | 1 | SO45353 | 2022-04-01 | 286.26 | 2171.29 | |
SO55566_1 | 19 | 11802 | 529 | 6 | 2023-12-07 | 0.10 | 2023-11-25 | 3.99 | 1 | SO55566 | 2023-12-02 | 0.32 | 1.49 | |
SO55566_2 | 19 | 11802 | 538 | 6 | 2023-12-07 | 0.54 | 2023-11-25 | 21.49 | 2 | SO55566 | 2023-12-02 | 1.72 | 8.04 | |
SO55566_3 | 19 | 11802 | 480 | 6 | 2023-12-07 | 0.06 | 2023-11-25 | 2.29 | 3 | SO55566 | 2023-12-02 | 0.18 | 0.86 | |
SO55568_1 | 19 | 21238 | 535 | 6 | 2023-12-07 | 0.62 | 2023-11-25 | 24.99 | 1 | SO55568 | 2023-12-02 | 2.00 | 9.35 | |
SO55568_2 | 19 | 21238 | 528 | 6 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 2 | SO55568 | 2023-12-02 | 0.40 | 1.87 | |
SO55568_3 | 19 | 21238 | 480 | 2 | 6 | 2023-12-07 | 0.06 | 2023-11-25 | 2.29 | 3 | SO55568 | 2023-12-02 | 0.18 | 0.86 |
SO55569_1 | 19 | 17387 | 528 | 6 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 1 | SO55569 | 2023-12-02 | 0.40 | 1.87 | |
SO55569_2 | 19 | 17387 | 535 | 6 | 2023-12-07 | 0.62 | 2023-11-25 | 24.99 | 2 | SO55569 | 2023-12-02 | 2.00 | 9.35 | |
SO55569_3 | 19 | 17387 | 478 | 6 | 2023-12-07 | 0.25 | 2023-11-25 | 9.99 | 3 | SO55569 | 2023-12-02 | 0.80 | 3.74 | |
SO55569_4 | 19 | 17387 | 225 | 6 | 2023-12-07 | 0.22 | 2023-11-25 | 8.99 | 4 | SO55569 | 2023-12-02 | 0.72 | 6.92 | |
SO55569_5 | 19 | 17387 | 477 | 6 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 5 | SO55569 | 2023-12-02 | 0.40 | 1.87 | |
SO55571_1 | 19 | 11200 | 535 | 6 | 2023-12-07 | 0.62 | 2023-11-25 | 24.99 | 1 | SO55571 | 2023-12-02 | 2.00 | 9.35 | |
SO55571_2 | 19 | 11200 | 480 | 6 | 2023-12-07 | 0.06 | 2023-11-25 | 2.29 | 2 | SO55571 | 2023-12-02 | 0.18 | 0.86 | |
SO55572_1 | 19 | 11091 | 529 | 6 | 2023-12-07 | 0.10 | 2023-11-25 | 3.99 | 1 | SO55572 | 2023-12-02 | 0.32 | 1.49 | |
SO55572_2 | 19 | 11091 | 540 | 6 | 2023-12-07 | 0.82 | 2023-11-25 | 32.60 | 2 | SO55572 | 2023-12-02 | 2.61 | 12.19 |
Generated 2024-09-20 17:53:32.795 UTC