[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 209 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56162_1 | 98 | 14529 | 540 | 10 | 2023-12-16 | 0.82 | 2023-12-04 | 32.60 | 1 | SO56162 | 2023-12-11 | 2.61 | 12.19 | |
SO43801_1 | 98 | 13583 | 311 | 10 | 2021-09-24 | 89.46 | 2021-09-12 | 3578.27 | 1 | SO43801 | 2021-09-19 | 286.26 | 2171.29 | |
SO56162_2 | 98 | 14529 | 529 | 10 | 2023-12-16 | 0.10 | 2023-12-04 | 3.99 | 2 | SO56162 | 2023-12-11 | 0.32 | 1.49 | |
SO43804_1 | 98 | 13585 | 310 | 10 | 2021-09-25 | 89.46 | 2021-09-13 | 3578.27 | 1 | SO43804 | 2021-09-20 | 286.26 | 2171.29 | |
SO56162_3 | 98 | 14529 | 486 | 10 | 2023-12-16 | 3.98 | 2023-12-04 | 159.00 | 3 | SO56162 | 2023-12-11 | 12.72 | 59.47 | |
SO43823_1 | 98 | 19942 | 342 | 10 | 2021-09-28 | 17.48 | 2021-09-16 | 699.10 | 1 | SO43823 | 2021-09-23 | 55.93 | 413.15 | |
SO56163_1 | 98 | 13814 | 540 | 10 | 2023-12-16 | 0.82 | 2023-12-04 | 32.60 | 1 | SO56163 | 2023-12-11 | 2.61 | 12.19 | |
SO43832_1 | 98 | 13584 | 310 | 10 | 2021-09-29 | 89.46 | 2021-09-17 | 3578.27 | 1 | SO43832 | 2021-09-24 | 286.26 | 2171.29 | |
SO56163_2 | 98 | 13814 | 237 | 10 | 2023-12-16 | 1.25 | 2023-12-04 | 49.99 | 2 | SO56163 | 2023-12-11 | 4.00 | 38.49 | |
SO43935_1 | 98 | 20048 | 334 | 10 | 2021-10-06 | 17.48 | 2021-09-24 | 699.10 | 1 | SO43935 | 2021-10-01 | 55.93 | 413.15 | |
SO56163_3 | 98 | 13814 | 465 | 10 | 2023-12-16 | 0.61 | 2023-12-04 | 24.49 | 3 | SO56163 | 2023-12-11 | 1.96 | 9.16 | |
SO43941_1 | 98 | 13600 | 314 | 10 | 2021-10-07 | 89.46 | 2021-09-25 | 3578.27 | 1 | SO43941 | 2021-10-02 | 286.26 | 2171.29 | |
SO56171_1 | 98 | 14196 | 478 | 10 | 2023-12-16 | 0.25 | 2023-12-04 | 9.99 | 1 | SO56171 | 2023-12-11 | 0.80 | 3.74 | |
SO43953_1 | 98 | 20049 | 342 | 10 | 2021-10-09 | 17.48 | 2021-09-27 | 699.10 | 1 | SO43953 | 2021-10-04 | 55.93 | 413.15 | |
SO56171_2 | 98 | 14196 | 477 | 10 | 2023-12-16 | 0.12 | 2023-12-04 | 4.99 | 2 | SO56171 | 2023-12-11 | 0.40 | 1.87 | |
SO43954_1 | 98 | 13602 | 311 | 10 | 2021-10-09 | 89.46 | 2021-09-27 | 3578.27 | 1 | SO43954 | 2021-10-04 | 286.26 | 2171.29 | |
SO56171_3 | 98 | 14196 | 491 | 10 | 2023-12-16 | 1.35 | 2023-12-04 | 53.99 | 3 | SO56171 | 2023-12-11 | 4.32 | 41.57 | |
SO43955_1 | 98 | 13661 | 314 | 10 | 2021-10-09 | 89.46 | 2021-09-27 | 3578.27 | 1 | SO43955 | 2021-10-04 | 286.26 | 2171.29 | |
SO56188_1 | 98 | 12645 | 357 | 10 | 2023-12-17 | 58.00 | 2023-12-05 | 2319.99 | 1 | SO56188 | 2023-12-12 | 185.60 | 1265.62 | |
SO43974_1 | 98 | 13687 | 312 | 10 | 2021-10-13 | 89.46 | 2021-10-01 | 3578.27 | 1 | SO43974 | 2021-10-08 | 286.26 | 2171.29 | |
SO56188_2 | 98 | 12645 | 537 | 10 | 2023-12-17 | 0.88 | 2023-12-05 | 35.00 | 2 | SO56188 | 2023-12-12 | 2.80 | 13.09 | |
SO43988_1 | 98 | 11244 | 344 | 10 | 2021-10-16 | 85.00 | 2021-10-04 | 3399.99 | 1 | SO43988 | 2021-10-11 | 272.00 | 1912.15 | |
SO56188_3 | 98 | 12645 | 480 | 10 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 3 | SO56188 | 2023-12-12 | 0.18 | 0.86 | |
SO44010_1 | 98 | 13680 | 310 | 10 | 2021-10-21 | 89.46 | 2021-10-09 | 3578.27 | 1 | SO44010 | 2021-10-16 | 286.26 | 2171.29 | |
SO56193_1 | 98 | 20173 | 380 | 10 | 2023-12-17 | 61.08 | 2023-12-05 | 2443.35 | 1 | SO56193 | 2023-12-12 | 195.47 | 1554.95 | |
SO44015_1 | 98 | 13693 | 311 | 10 | 2021-10-22 | 89.46 | 2021-10-10 | 3578.27 | 1 | SO44015 | 2021-10-17 | 286.26 | 2171.29 | |
SO56193_2 | 98 | 20173 | 529 | 10 | 2023-12-17 | 0.10 | 2023-12-05 | 3.99 | 2 | SO56193 | 2023-12-12 | 0.32 | 1.49 | |
SO44016_1 | 98 | 11247 | 350 | 10 | 2021-10-22 | 84.37 | 2021-10-10 | 3374.99 | 1 | SO44016 | 2021-10-17 | 270.00 | 1898.09 | |
SO56193_3 | 98 | 20173 | 540 | 10 | 2023-12-17 | 0.82 | 2023-12-05 | 32.60 | 3 | SO56193 | 2023-12-12 | 2.61 | 12.19 | |
SO44031_1 | 98 | 13689 | 313 | 10 | 2021-10-25 | 89.46 | 2021-10-13 | 3578.27 | 1 | SO44031 | 2021-10-20 | 286.26 | 2171.29 | |
SO56193_4 | 98 | 20173 | 480 | 10 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 4 | SO56193 | 2023-12-12 | 0.18 | 0.86 | |
SO44032_1 | 98 | 11243 | 344 | 10 | 2021-10-25 | 85.00 | 2021-10-13 | 3399.99 | 1 | SO44032 | 2021-10-20 | 272.00 | 1912.15 | |
SO56207_1 | 98 | 17895 | 535 | 10 | 2023-12-17 | 0.62 | 2023-12-05 | 24.99 | 1 | SO56207 | 2023-12-12 | 2.00 | 9.35 | |
SO44042_1 | 98 | 13678 | 313 | 10 | 2021-10-27 | 89.46 | 2021-10-15 | 3578.27 | 1 | SO44042 | 2021-10-22 | 286.26 | 2171.29 | |
SO56207_2 | 98 | 17895 | 528 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 2 | SO56207 | 2023-12-12 | 0.40 | 1.87 | |
SO44043_1 | 98 | 13679 | 311 | 10 | 2021-10-27 | 89.46 | 2021-10-15 | 3578.27 | 1 | SO44043 | 2021-10-22 | 286.26 | 2171.29 | |
SO56208_1 | 98 | 19328 | 539 | 10 | 2023-12-17 | 0.62 | 2023-12-05 | 24.99 | 1 | SO56208 | 2023-12-12 | 2.00 | 9.35 | |
SO44044_1 | 98 | 13690 | 314 | 10 | 2021-10-27 | 89.46 | 2021-10-15 | 3578.27 | 1 | SO44044 | 2021-10-22 | 286.26 | 2171.29 | |
SO56208_2 | 98 | 19328 | 480 | 10 | 2023-12-17 | 0.06 | 2023-12-05 | 2.29 | 2 | SO56208 | 2023-12-12 | 0.18 | 0.86 | |
SO44051_1 | 98 | 13691 | 310 | 10 | 2021-10-29 | 89.46 | 2021-10-17 | 3578.27 | 1 | SO44051 | 2021-10-24 | 286.26 | 2171.29 | |
SO56210_1 | 98 | 17879 | 530 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO56210 | 2023-12-12 | 0.40 | 1.87 | |
SO44063_1 | 98 | 11240 | 344 | 10 | 2021-10-31 | 85.00 | 2021-10-19 | 3399.99 | 1 | SO44063 | 2021-10-26 | 272.00 | 1912.15 | |
SO56210_2 | 98 | 17879 | 237 | 10 | 2023-12-17 | 1.25 | 2023-12-05 | 49.99 | 2 | SO56210 | 2023-12-12 | 4.00 | 38.49 | |
SO44134_1 | 98 | 13821 | 310 | 10 | 2021-11-02 | 89.46 | 2021-10-21 | 3578.27 | 1 | SO44134 | 2021-10-28 | 286.26 | 2171.29 | |
SO56223_1 | 98 | 23760 | 382 | 2 | 10 | 2023-12-17 | 28.01 | 2023-12-05 | 1120.49 | 1 | SO56223 | 2023-12-12 | 89.64 | 713.08 |
SO44138_1 | 98 | 13765 | 310 | 10 | 2021-11-03 | 89.46 | 2021-10-22 | 3578.27 | 1 | SO44138 | 2021-10-29 | 286.26 | 2171.29 | |
SO56223_2 | 98 | 23760 | 491 | 10 | 2023-12-17 | 1.35 | 2023-12-05 | 53.99 | 2 | SO56223 | 2023-12-12 | 4.32 | 41.57 | |
SO44139_1 | 98 | 13792 | 311 | 10 | 2021-11-03 | 89.46 | 2021-10-22 | 3578.27 | 1 | SO44139 | 2021-10-29 | 286.26 | 2171.29 | |
SO56223_3 | 98 | 23760 | 225 | 10 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 3 | SO56223 | 2023-12-12 | 0.72 | 6.92 | |
SO44152_1 | 98 | 11334 | 346 | 10 | 2021-11-05 | 85.00 | 2021-10-24 | 3399.99 | 1 | SO44152 | 2021-10-31 | 272.00 | 1912.15 | |
SO56225_1 | 98 | 12658 | 357 | 2 | 10 | 2023-12-18 | 58.00 | 2023-12-06 | 2319.99 | 1 | SO56225 | 2023-12-13 | 185.60 | 1265.62 |
SO44161_1 | 98 | 13772 | 314 | 10 | 2021-11-07 | 89.46 | 2021-10-26 | 3578.27 | 1 | SO44161 | 2021-11-02 | 286.26 | 2171.29 | |
SO56225_2 | 98 | 12658 | 225 | 10 | 2023-12-18 | 0.22 | 2023-12-06 | 8.99 | 2 | SO56225 | 2023-12-13 | 0.72 | 6.92 | |
SO44173_1 | 98 | 13784 | 312 | 10 | 2021-11-09 | 89.46 | 2021-10-28 | 3578.27 | 1 | SO44173 | 2021-11-04 | 286.26 | 2171.29 | |
SO56225_3 | 98 | 12658 | 217 | 10 | 2023-12-18 | 0.87 | 2023-12-06 | 34.99 | 3 | SO56225 | 2023-12-13 | 2.80 | 13.09 | |
SO44177_1 | 98 | 11337 | 350 | 10 | 2021-11-10 | 84.37 | 2021-10-29 | 3374.99 | 1 | SO44177 | 2021-11-05 | 270.00 | 1898.09 |
Generated 2024-09-19 17:35:01.431 UTC