[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL SKIP 4000 SKIP 0 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45821_1 | 100 | 26041 | 346 | 1 | 2022-06-01 | 85.00 | 2022-05-20 | 3399.99 | 1 | SO45821 | 2022-05-27 | 272.00 | 1912.15 | |
SO55879_1 | 6 | 11749 | 535 | 9 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 1 | SO55879 | 2023-12-04 | 2.00 | 9.35 | |
SO62433_2 | 98 | 14542 | 530 | 10 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 2 | SO62433 | 2024-03-15 | 0.40 | 1.87 | |
SO68974_1 | 19 | 11922 | 477 | 6 | 2024-06-24 | 0.12 | 2024-06-12 | 4.99 | 1 | SO68974 | 2024-06-19 | 0.40 | 1.87 | |
SO45822_1 | 6 | 20246 | 312 | 9 | 2022-06-01 | 89.46 | 2022-05-20 | 3578.27 | 1 | SO45822 | 2022-05-27 | 286.26 | 2171.29 | |
SO55880_1 | 19 | 11277 | 529 | 6 | 2023-12-09 | 0.10 | 2023-11-27 | 3.99 | 1 | SO55880 | 2023-12-04 | 0.32 | 1.49 | |
SO62433_3 | 98 | 14542 | 480 | 2 | 10 | 2024-03-20 | 0.06 | 2024-03-08 | 2.29 | 3 | SO62433 | 2024-03-15 | 0.18 | 0.86 |
SO68974_2 | 19 | 11922 | 478 | 6 | 2024-06-24 | 0.25 | 2024-06-12 | 9.99 | 2 | SO68974 | 2024-06-19 | 0.80 | 3.74 | |
SO45823_1 | 6 | 20253 | 311 | 9 | 2022-06-01 | 89.46 | 2022-05-20 | 3578.27 | 1 | SO45823 | 2022-05-27 | 286.26 | 2171.29 | |
SO55880_2 | 19 | 11277 | 222 | 6 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 2 | SO55880 | 2023-12-04 | 2.80 | 13.09 | |
SO62434_1 | 100 | 24864 | 538 | 8 | 2024-03-20 | 0.54 | 2024-03-08 | 21.49 | 1 | SO62434 | 2024-03-15 | 1.72 | 8.04 | |
SO68975_1 | 100 | 20329 | 474 | 4 | 2024-06-24 | 1.75 | 2024-06-12 | 69.99 | 1 | SO68975 | 2024-06-19 | 5.60 | 26.18 | |
SO45824_1 | 100 | 11696 | 312 | 1 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45824 | 2022-05-28 | 286.26 | 2171.29 | |
SO55881_1 | 100 | 28028 | 530 | 1 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55881 | 2023-12-04 | 0.40 | 1.87 | |
SO62434_2 | 100 | 24864 | 529 | 8 | 2024-03-20 | 0.10 | 2024-03-08 | 3.99 | 2 | SO62434 | 2024-03-15 | 0.32 | 1.49 | |
SO68976_1 | 19 | 29012 | 476 | 6 | 2024-06-24 | 1.75 | 2024-06-12 | 69.99 | 1 | SO68976 | 2024-06-19 | 5.60 | 26.18 | |
SO45825_1 | 19 | 23725 | 314 | 6 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45825 | 2022-05-28 | 286.26 | 2171.29 | |
SO55881_2 | 100 | 28028 | 217 | 1 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 2 | SO55881 | 2023-12-04 | 2.80 | 13.09 | |
SO62434_3 | 100 | 24864 | 480 | 2 | 8 | 2024-03-20 | 0.06 | 2024-03-08 | 2.29 | 3 | SO62434 | 2024-03-15 | 0.18 | 0.86 |
SO68976_2 | 19 | 29012 | 225 | 6 | 2024-06-24 | 0.22 | 2024-06-12 | 8.99 | 2 | SO68976 | 2024-06-19 | 0.72 | 6.92 | |
SO45826_1 | 19 | 23858 | 310 | 6 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45826 | 2022-05-28 | 286.26 | 2171.29 | |
SO55881_3 | 100 | 28028 | 463 | 1 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 3 | SO55881 | 2023-12-04 | 1.96 | 9.16 | |
SO62434_4 | 100 | 24864 | 484 | 8 | 2024-03-20 | 0.20 | 2024-03-08 | 7.95 | 4 | SO62434 | 2024-03-15 | 0.64 | 2.97 | |
SO68977_1 | 100 | 16759 | 477 | 4 | 2024-06-24 | 0.12 | 2024-06-12 | 4.99 | 1 | SO68977 | 2024-06-19 | 0.40 | 1.87 | |
SO45827_1 | 98 | 15440 | 312 | 10 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45827 | 2022-05-28 | 286.26 | 2171.29 | |
SO55882_1 | 100 | 28086 | 530 | 4 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55882 | 2023-12-04 | 0.40 | 1.87 | |
SO62434_5 | 100 | 24864 | 483 | 8 | 2024-03-20 | 3.00 | 2024-03-08 | 120.00 | 5 | SO62434 | 2024-03-15 | 9.60 | 44.88 | |
SO68977_2 | 100 | 16759 | 480 | 2 | 4 | 2024-06-24 | 0.06 | 2024-06-12 | 2.29 | 2 | SO68977 | 2024-06-19 | 0.18 | 0.86 |
SO45828_1 | 100 | 14753 | 330 | 1 | 2022-06-02 | 17.48 | 2022-05-21 | 699.10 | 1 | SO45828 | 2022-05-28 | 55.93 | 413.15 | |
SO55882_2 | 100 | 28086 | 480 | 2 | 4 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 2 | SO55882 | 2023-12-04 | 0.18 | 0.86 |
SO62435_1 | 19 | 12430 | 537 | 6 | 2024-03-20 | 0.88 | 2024-03-08 | 35.00 | 1 | SO62435 | 2024-03-15 | 2.80 | 13.09 | |
SO68978_1 | 19 | 11262 | 477 | 6 | 2024-06-24 | 0.12 | 2024-06-12 | 4.99 | 1 | SO68978 | 2024-06-19 | 0.40 | 1.87 | |
SO45829_1 | 6 | 20245 | 310 | 9 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45829 | 2022-05-28 | 286.26 | 2171.29 | |
SO55882_3 | 100 | 28086 | 486 | 4 | 2023-12-09 | 3.98 | 2023-11-27 | 159.00 | 3 | SO55882 | 2023-12-04 | 12.72 | 59.47 | |
SO62435_2 | 19 | 12430 | 528 | 6 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 2 | SO62435 | 2024-03-15 | 0.40 | 1.87 | |
SO68979_1 | 100 | 15857 | 528 | 4 | 2024-06-24 | 0.12 | 2024-06-12 | 4.99 | 1 | SO68979 | 2024-06-19 | 0.40 | 1.87 | |
SO45830_1 | 6 | 20151 | 314 | 9 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45830 | 2022-05-28 | 286.26 | 2171.29 | |
SO55883_1 | 19 | 16721 | 538 | 6 | 2023-12-09 | 0.54 | 2023-11-27 | 21.49 | 1 | SO55883 | 2023-12-04 | 1.72 | 8.04 | |
SO62435_3 | 19 | 12430 | 222 | 6 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 3 | SO62435 | 2024-03-15 | 2.80 | 13.09 | |
SO68980_1 | 100 | 15512 | 528 | 1 | 2024-06-24 | 0.12 | 2024-06-12 | 4.99 | 1 | SO68980 | 2024-06-19 | 0.40 | 1.87 | |
SO45831_1 | 6 | 20158 | 313 | 9 | 2022-06-02 | 89.46 | 2022-05-21 | 3578.27 | 1 | SO45831 | 2022-05-28 | 286.26 | 2171.29 | |
SO55883_2 | 19 | 16721 | 480 | 6 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 2 | SO55883 | 2023-12-04 | 0.18 | 0.86 | |
SO62436_1 | 100 | 12931 | 528 | 4 | 2024-03-20 | 0.12 | 2024-03-08 | 4.99 | 1 | SO62436 | 2024-03-15 | 0.40 | 1.87 | |
SO68980_2 | 100 | 15512 | 485 | 1 | 2024-06-24 | 0.55 | 2024-06-12 | 21.98 | 2 | SO68980 | 2024-06-19 | 1.76 | 8.22 | |
SO45832_1 | 6 | 11916 | 351 | 9 | 2022-06-02 | 84.37 | 2022-05-21 | 3374.99 | 1 | SO45832 | 2022-05-28 | 270.00 | 1898.09 | |
SO55884_1 | 100 | 25959 | 535 | 4 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 1 | SO55884 | 2023-12-04 | 2.00 | 9.35 | |
SO62436_2 | 100 | 12931 | 537 | 4 | 2024-03-20 | 0.88 | 2024-03-08 | 35.00 | 2 | SO62436 | 2024-03-15 | 2.80 | 13.09 | |
SO68980_3 | 100 | 15512 | 222 | 1 | 2024-06-24 | 0.87 | 2024-06-12 | 34.99 | 3 | SO68980 | 2024-06-19 | 2.80 | 13.09 | |
SO45833_1 | 100 | 11815 | 313 | 1 | 2022-06-03 | 89.46 | 2022-05-22 | 3578.27 | 1 | SO45833 | 2022-05-29 | 286.26 | 2171.29 | |
SO55884_2 | 100 | 25959 | 480 | 4 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 2 | SO55884 | 2023-12-04 | 0.18 | 0.86 | |
SO62436_3 | 100 | 12931 | 485 | 4 | 2024-03-20 | 0.55 | 2024-03-08 | 21.98 | 3 | SO62436 | 2024-03-15 | 1.76 | 8.22 | |
SO68981_1 | 100 | 18146 | 485 | 8 | 2024-06-24 | 0.55 | 2024-06-12 | 21.98 | 1 | SO68981 | 2024-06-19 | 1.76 | 8.22 | |
SO45834_1 | 100 | 11816 | 312 | 4 | 2022-06-03 | 89.46 | 2022-05-22 | 3578.27 | 1 | SO45834 | 2022-05-29 | 286.26 | 2171.29 | |
SO55885_1 | 19 | 11519 | 538 | 6 | 2023-12-09 | 0.54 | 2023-11-27 | 21.49 | 1 | SO55885 | 2023-12-04 | 1.72 | 8.04 | |
SO62436_4 | 100 | 12931 | 217 | 4 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 4 | SO62436 | 2024-03-15 | 2.80 | 13.09 | |
SO68981_2 | 100 | 18146 | 478 | 8 | 2024-06-24 | 0.25 | 2024-06-12 | 9.99 | 2 | SO68981 | 2024-06-19 | 0.80 | 3.74 | |
SO45835_1 | 100 | 11688 | 313 | 1 | 2022-06-03 | 89.46 | 2022-05-22 | 3578.27 | 1 | SO45835 | 2022-05-29 | 286.26 | 2171.29 | |
SO55885_2 | 19 | 11519 | 529 | 6 | 2023-12-09 | 0.10 | 2023-11-27 | 3.99 | 2 | SO55885 | 2023-12-04 | 0.32 | 1.49 | |
SO62436_5 | 100 | 12931 | 237 | 4 | 2024-03-20 | 1.25 | 2024-03-08 | 49.99 | 5 | SO62436 | 2024-03-15 | 4.00 | 38.49 | |
SO68982_1 | 98 | 13692 | 539 | 10 | 2024-06-24 | 0.62 | 2024-06-12 | 24.99 | 1 | SO68982 | 2024-06-19 | 2.00 | 9.35 | |
SO45836_1 | 100 | 14823 | 311 | 8 | 2022-06-03 | 89.46 | 2022-05-22 | 3578.27 | 1 | SO45836 | 2022-05-29 | 286.26 | 2171.29 | |
SO55885_3 | 19 | 11519 | 214 | 6 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 3 | SO55885 | 2023-12-04 | 2.80 | 13.09 |
Generated 2024-09-17 18:12:10.570 UTC