[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 2561 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55874_1 | 6 | 16615 | 540 | 9 | 2024-02-01 | 0.82 | 2024-01-20 | 32.60 | 1 | SO55874 | 2024-01-27 | 2.61 | 12.19 | |
SO62175_2 | 98 | 17782 | 476 | 10 | 2024-05-09 | 1.75 | 2024-04-27 | 69.99 | 2 | SO62175 | 2024-05-04 | 5.60 | 26.18 | |
SO68972_1 | 100 | 23519 | 478 | 4 | 2024-08-17 | 0.25 | 2024-08-05 | 9.99 | 1 | SO68972 | 2024-08-12 | 0.80 | 3.74 | |
SO44826_1 | 39 | 12308 | 314 | 7 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO44826 | 2022-03-23 | 286.26 | 2171.29 | |
SO55874_2 | 6 | 16615 | 529 | 9 | 2024-02-01 | 0.10 | 2024-01-20 | 3.99 | 2 | SO55874 | 2024-01-27 | 0.32 | 1.49 | |
SO62176_1 | 100 | 17873 | 580 | 8 | 2024-05-09 | 42.52 | 2024-04-27 | 1700.99 | 1 | SO62176 | 2024-05-04 | 136.08 | 1082.51 | |
SO68972_2 | 100 | 23519 | 477 | 4 | 2024-08-17 | 0.12 | 2024-08-05 | 4.99 | 2 | SO68972 | 2024-08-12 | 0.40 | 1.87 | |
SO44827_1 | 100 | 25973 | 344 | 1 | 2022-03-28 | 85.00 | 2022-03-16 | 3399.99 | 1 | SO44827 | 2022-03-23 | 272.00 | 1912.15 | |
SO55874_3 | 6 | 16615 | 480 | 9 | 2024-02-01 | 0.06 | 2024-01-20 | 2.29 | 3 | SO55874 | 2024-01-27 | 0.18 | 0.86 | |
SO62176_2 | 100 | 17873 | 228 | 8 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 2 | SO62176 | 2024-05-04 | 4.00 | 38.49 | |
SO68972_3 | 100 | 23519 | 225 | 4 | 2024-08-17 | 0.22 | 2024-08-05 | 8.99 | 3 | SO68972 | 2024-08-12 | 0.72 | 6.92 | |
SO44828_1 | 100 | 28997 | 312 | 4 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO44828 | 2022-03-23 | 286.26 | 2171.29 | |
SO55875_1 | 6 | 18271 | 225 | 9 | 2024-02-01 | 0.22 | 2024-01-20 | 8.99 | 1 | SO55875 | 2024-01-27 | 0.72 | 6.92 | |
SO62176_3 | 100 | 17873 | 225 | 8 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 3 | SO62176 | 2024-05-04 | 0.72 | 6.92 | |
SO68973_1 | 100 | 23260 | 478 | 1 | 2024-08-17 | 0.25 | 2024-08-05 | 9.99 | 1 | SO68973 | 2024-08-12 | 0.80 | 3.74 | |
SO44829_1 | 100 | 14643 | 334 | 1 | 2022-03-28 | 17.48 | 2022-03-16 | 699.10 | 1 | SO44829 | 2022-03-23 | 55.93 | 413.15 | |
SO55876_1 | 6 | 14683 | 487 | 9 | 2024-02-01 | 1.37 | 2024-01-20 | 54.99 | 1 | SO55876 | 2024-01-27 | 4.40 | 20.57 | |
SO62177_1 | 100 | 15357 | 353 | 8 | 2024-05-09 | 58.00 | 2024-04-27 | 2319.99 | 1 | SO62177 | 2024-05-04 | 185.60 | 1265.62 | |
SO68973_2 | 100 | 23260 | 477 | 1 | 2024-08-17 | 0.12 | 2024-08-05 | 4.99 | 2 | SO68973 | 2024-08-12 | 0.40 | 1.87 | |
SO44830_1 | 6 | 18337 | 314 | 9 | 2022-03-28 | 89.46 | 2022-03-16 | 3578.27 | 1 | SO44830 | 2022-03-23 | 286.26 | 2171.29 | |
SO55877_1 | 19 | 11619 | 488 | 6 | 2024-02-01 | 1.35 | 2024-01-20 | 53.99 | 1 | SO55877 | 2024-01-27 | 4.32 | 41.57 | |
SO62177_2 | 100 | 15357 | 477 | 8 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62177 | 2024-05-04 | 0.40 | 1.87 | |
SO68973_3 | 100 | 23260 | 489 | 1 | 2024-08-17 | 1.35 | 2024-08-05 | 53.99 | 3 | SO68973 | 2024-08-12 | 4.32 | 41.57 | |
SO44831_1 | 29 | 29467 | 350 | 8 | 2022-03-29 | 84.37 | 2022-03-17 | 3374.99 | 1 | SO44831 | 2022-03-24 | 270.00 | 1898.09 | |
SO55877_2 | 19 | 11619 | 465 | 6 | 2024-02-01 | 0.61 | 2024-01-20 | 24.49 | 2 | SO55877 | 2024-01-27 | 1.96 | 9.16 | |
SO62177_3 | 100 | 15357 | 478 | 8 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 3 | SO62177 | 2024-05-04 | 0.80 | 3.74 | |
SO68973_4 | 100 | 23260 | 465 | 1 | 2024-08-17 | 0.61 | 2024-08-05 | 24.49 | 4 | SO68973 | 2024-08-12 | 1.96 | 9.16 | |
SO44832_1 | 100 | 28804 | 311 | 4 | 2022-03-29 | 89.46 | 2022-03-17 | 3578.27 | 1 | SO44832 | 2022-03-24 | 286.26 | 2171.29 | |
SO55878_1 | 100 | 11622 | 480 | 1 | 2024-02-01 | 0.06 | 2024-01-20 | 2.29 | 1 | SO55878 | 2024-01-27 | 0.18 | 0.86 | |
SO62177_4 | 100 | 15357 | 217 | 8 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 4 | SO62177 | 2024-05-04 | 2.80 | 13.09 | |
SO68974_1 | 19 | 11922 | 477 | 6 | 2024-08-17 | 0.12 | 2024-08-05 | 4.99 | 1 | SO68974 | 2024-08-12 | 0.40 | 1.87 | |
SO44833_1 | 100 | 28842 | 310 | 4 | 2022-03-29 | 89.46 | 2022-03-17 | 3578.27 | 1 | SO44833 | 2022-03-24 | 286.26 | 2171.29 | |
SO55879_1 | 6 | 11749 | 535 | 9 | 2024-02-01 | 0.62 | 2024-01-20 | 24.99 | 1 | SO55879 | 2024-01-27 | 2.00 | 9.35 | |
SO62178_1 | 100 | 12211 | 359 | 7 | 2024-05-09 | 57.37 | 2024-04-27 | 2294.99 | 1 | SO62178 | 2024-05-04 | 183.60 | 1251.98 | |
SO68974_2 | 19 | 11922 | 478 | 6 | 2024-08-17 | 0.25 | 2024-08-05 | 9.99 | 2 | SO68974 | 2024-08-12 | 0.80 | 3.74 | |
SO44834_1 | 100 | 25952 | 350 | 4 | 2022-03-29 | 84.37 | 2022-03-17 | 3374.99 | 1 | SO44834 | 2022-03-24 | 270.00 | 1898.09 | |
SO55880_1 | 19 | 11277 | 529 | 6 | 2024-02-01 | 0.10 | 2024-01-20 | 3.99 | 1 | SO55880 | 2024-01-27 | 0.32 | 1.49 | |
SO62178_2 | 100 | 12211 | 214 | 7 | 2024-05-09 | 0.87 | 2024-04-27 | 34.99 | 2 | SO62178 | 2024-05-04 | 2.80 | 13.09 | |
SO68975_1 | 100 | 20329 | 474 | 4 | 2024-08-17 | 1.75 | 2024-08-05 | 69.99 | 1 | SO68975 | 2024-08-12 | 5.60 | 26.18 | |
SO44835_1 | 6 | 18338 | 311 | 9 | 2022-03-29 | 89.46 | 2022-03-17 | 3578.27 | 1 | SO44835 | 2022-03-24 | 286.26 | 2171.29 | |
SO55880_2 | 19 | 11277 | 222 | 6 | 2024-02-01 | 0.87 | 2024-01-20 | 34.99 | 2 | SO55880 | 2024-01-27 | 2.80 | 13.09 | |
SO62179_1 | 100 | 11646 | 488 | 1 | 2024-05-09 | 1.35 | 2024-04-27 | 53.99 | 1 | SO62179 | 2024-05-04 | 4.32 | 41.57 | |
SO68976_1 | 19 | 29012 | 476 | 6 | 2024-08-17 | 1.75 | 2024-08-05 | 69.99 | 1 | SO68976 | 2024-08-12 | 5.60 | 26.18 | |
SO44836_1 | 6 | 18465 | 314 | 9 | 2022-03-29 | 89.46 | 2022-03-17 | 3578.27 | 1 | SO44836 | 2022-03-24 | 286.26 | 2171.29 | |
SO55881_1 | 100 | 28028 | 530 | 1 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 1 | SO55881 | 2024-01-27 | 0.40 | 1.87 | |
SO62180_1 | 19 | 28776 | 480 | 4 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 1 | SO62180 | 2024-05-04 | 0.18 | 0.86 | |
SO68976_2 | 19 | 29012 | 225 | 6 | 2024-08-17 | 0.22 | 2024-08-05 | 8.99 | 2 | SO68976 | 2024-08-12 | 0.72 | 6.92 | |
SO44837_1 | 29 | 13808 | 312 | 8 | 2022-03-30 | 89.46 | 2022-03-18 | 3578.27 | 1 | SO44837 | 2022-03-25 | 286.26 | 2171.29 | |
SO55881_2 | 100 | 28028 | 217 | 1 | 2024-02-01 | 0.87 | 2024-01-20 | 34.99 | 2 | SO55881 | 2024-01-27 | 2.80 | 13.09 | |
SO62181_1 | 100 | 28855 | 539 | 4 | 2024-05-09 | 0.62 | 2024-04-27 | 24.99 | 1 | SO62181 | 2024-05-04 | 2.00 | 9.35 | |
SO68977_1 | 100 | 16759 | 477 | 4 | 2024-08-17 | 0.12 | 2024-08-05 | 4.99 | 1 | SO68977 | 2024-08-12 | 0.40 | 1.87 | |
SO44838_1 | 29 | 14138 | 311 | 8 | 2022-03-30 | 89.46 | 2022-03-18 | 3578.27 | 1 | SO44838 | 2022-03-25 | 286.26 | 2171.29 | |
SO55881_3 | 100 | 28028 | 463 | 1 | 2024-02-01 | 0.61 | 2024-01-20 | 24.49 | 3 | SO55881 | 2024-01-27 | 1.96 | 9.16 | |
SO62181_2 | 100 | 28855 | 529 | 4 | 2024-05-09 | 0.10 | 2024-04-27 | 3.99 | 2 | SO62181 | 2024-05-04 | 0.32 | 1.49 | |
SO68977_2 | 100 | 16759 | 480 | 2 | 4 | 2024-08-17 | 0.06 | 2024-08-05 | 2.29 | 2 | SO68977 | 2024-08-12 | 0.18 | 0.86 |
SO44839_1 | 100 | 28825 | 314 | 1 | 2022-03-30 | 89.46 | 2022-03-18 | 3578.27 | 1 | SO44839 | 2022-03-25 | 286.26 | 2171.29 |
Generated 2024-11-10 13:05:02.022 UTC