[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SKIP 516 < SKIP 690 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46426_1 | 100 | 26107 | 344 | 4 | 2022-10-01 | 85.00 | 2022-09-19 | 3399.99 | 1 | SO46426 | 2022-09-26 | 272.00 | 1912.15 | |
SO46432_1 | 100 | 15016 | 342 | 4 | 2022-10-02 | 17.48 | 2022-09-20 | 699.10 | 1 | SO46432 | 2022-09-27 | 55.93 | 413.15 | |
SO46438_1 | 100 | 12174 | 313 | 4 | 2022-10-03 | 89.46 | 2022-09-21 | 3578.27 | 1 | SO46438 | 2022-09-28 | 286.26 | 2171.29 | |
SO46450_1 | 100 | 12446 | 314 | 4 | 2022-10-05 | 89.46 | 2022-09-23 | 3578.27 | 1 | SO46450 | 2022-09-30 | 286.26 | 2171.29 | |
SO46451_1 | 100 | 12709 | 310 | 4 | 2022-10-05 | 89.46 | 2022-09-23 | 3578.27 | 1 | SO46451 | 2022-09-30 | 286.26 | 2171.29 | |
SO46458_1 | 100 | 12771 | 310 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46458 | 2022-10-01 | 286.26 | 2171.29 | |
SO46459_1 | 100 | 12190 | 313 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46459 | 2022-10-01 | 286.26 | 2171.29 | |
SO46460_1 | 100 | 12438 | 312 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46460 | 2022-10-01 | 286.26 | 2171.29 | |
SO46464_1 | 100 | 12885 | 310 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46464 | 2022-10-02 | 286.26 | 2171.29 | |
SO46465_1 | 100 | 12898 | 311 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46465 | 2022-10-02 | 286.26 | 2171.29 | |
SO62772_1 | 100 | 28999 | 530 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 1 | SO62772 | 2024-05-17 | 0.40 | 1.87 | |
SO62773_1 | 100 | 27035 | 530 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 1 | SO62773 | 2024-05-17 | 0.40 | 1.87 | |
SO62773_2 | 100 | 27035 | 480 | 2 | 4 | 2024-05-22 | 0.06 | 2024-05-10 | 2.29 | 2 | SO62773 | 2024-05-17 | 0.18 | 0.86 |
SO62774_1 | 100 | 26800 | 541 | 4 | 2024-05-22 | 0.72 | 2024-05-10 | 28.99 | 1 | SO62774 | 2024-05-17 | 2.32 | 10.84 | |
SO62774_2 | 100 | 26800 | 530 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 2 | SO62774 | 2024-05-17 | 0.40 | 1.87 | |
SO62774_3 | 100 | 26800 | 222 | 4 | 2024-05-22 | 0.87 | 2024-05-10 | 34.99 | 3 | SO62774 | 2024-05-17 | 2.80 | 13.09 | |
SO62776_1 | 100 | 26048 | 535 | 4 | 2024-05-22 | 0.62 | 2024-05-10 | 24.99 | 1 | SO62776 | 2024-05-17 | 2.00 | 9.35 | |
SO62776_2 | 100 | 26048 | 528 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 2 | SO62776 | 2024-05-17 | 0.40 | 1.87 | |
SO62776_3 | 100 | 26048 | 480 | 4 | 2024-05-22 | 0.06 | 2024-05-10 | 2.29 | 3 | SO62776 | 2024-05-17 | 0.18 | 0.86 | |
SO62776_4 | 100 | 26048 | 486 | 4 | 2024-05-22 | 3.98 | 2024-05-10 | 159.00 | 4 | SO62776 | 2024-05-17 | 12.72 | 59.47 | |
SO62779_1 | 100 | 24745 | 535 | 4 | 2024-05-22 | 0.62 | 2024-05-10 | 24.99 | 1 | SO62779 | 2024-05-17 | 2.00 | 9.35 | |
SO62779_2 | 100 | 24745 | 528 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 2 | SO62779 | 2024-05-17 | 0.40 | 1.87 | |
SO62780_1 | 100 | 21636 | 478 | 4 | 2024-05-22 | 0.25 | 2024-05-10 | 9.99 | 1 | SO62780 | 2024-05-17 | 0.80 | 3.74 | |
SO62780_2 | 100 | 21636 | 477 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 2 | SO62780 | 2024-05-17 | 0.40 | 1.87 | |
SO62795_1 | 100 | 11672 | 465 | 4 | 2024-05-22 | 0.61 | 2024-05-10 | 24.49 | 1 | SO62795 | 2024-05-17 | 1.96 | 9.16 | |
SO62795_2 | 100 | 11672 | 537 | 4 | 2024-05-22 | 0.88 | 2024-05-10 | 35.00 | 2 | SO62795 | 2024-05-17 | 2.80 | 13.09 | |
SO62804_1 | 100 | 12094 | 353 | 4 | 2024-05-22 | 58.00 | 2024-05-10 | 2319.99 | 1 | SO62804 | 2024-05-17 | 185.60 | 1265.62 | |
SO62804_2 | 100 | 12094 | 537 | 4 | 2024-05-22 | 0.88 | 2024-05-10 | 35.00 | 2 | SO62804 | 2024-05-17 | 2.80 | 13.09 | |
SO62804_3 | 100 | 12094 | 528 | 4 | 2024-05-22 | 0.12 | 2024-05-10 | 4.99 | 3 | SO62804 | 2024-05-17 | 0.40 | 1.87 | |
SO62804_4 | 100 | 12094 | 485 | 4 | 2024-05-22 | 0.55 | 2024-05-10 | 21.98 | 4 | SO62804 | 2024-05-17 | 1.76 | 8.22 | |
SO62804_5 | 100 | 12094 | 480 | 4 | 2024-05-22 | 0.06 | 2024-05-10 | 2.29 | 5 | SO62804 | 2024-05-17 | 0.18 | 0.86 | |
SO62810_1 | 100 | 22790 | 584 | 4 | 2024-05-22 | 13.50 | 2024-05-10 | 539.99 | 1 | SO62810 | 2024-05-17 | 43.20 | 343.65 | |
SO62810_2 | 100 | 22790 | 217 | 4 | 2024-05-22 | 0.87 | 2024-05-10 | 34.99 | 2 | SO62810 | 2024-05-17 | 2.80 | 13.09 | |
SO62811_1 | 100 | 20684 | 580 | 4 | 2024-05-22 | 42.52 | 2024-05-10 | 1700.99 | 1 | SO62811 | 2024-05-17 | 136.08 | 1082.51 | |
SO62811_2 | 100 | 20684 | 539 | 4 | 2024-05-22 | 0.62 | 2024-05-10 | 24.99 | 2 | SO62811 | 2024-05-17 | 2.00 | 9.35 | |
SO62811_3 | 100 | 20684 | 529 | 4 | 2024-05-22 | 0.10 | 2024-05-10 | 3.99 | 3 | SO62811 | 2024-05-17 | 0.32 | 1.49 | |
SO62830_1 | 100 | 11024 | 529 | 4 | 2024-05-23 | 0.10 | 2024-05-11 | 3.99 | 1 | SO62830 | 2024-05-18 | 0.32 | 1.49 | |
SO62830_2 | 100 | 11024 | 480 | 2 | 4 | 2024-05-23 | 0.06 | 2024-05-11 | 2.29 | 2 | SO62830 | 2024-05-18 | 0.18 | 0.86 |
SO62830_3 | 100 | 11024 | 484 | 4 | 2024-05-23 | 0.20 | 2024-05-11 | 7.95 | 3 | SO62830 | 2024-05-18 | 0.64 | 2.97 | |
SO62832_1 | 100 | 28236 | 538 | 4 | 2024-05-23 | 0.54 | 2024-05-11 | 21.49 | 1 | SO62832 | 2024-05-18 | 1.72 | 8.04 | |
SO62832_2 | 100 | 28236 | 529 | 4 | 2024-05-23 | 0.10 | 2024-05-11 | 3.99 | 2 | SO62832 | 2024-05-18 | 0.32 | 1.49 | |
SO62832_3 | 100 | 28236 | 222 | 4 | 2024-05-23 | 0.87 | 2024-05-11 | 34.99 | 3 | SO62832 | 2024-05-18 | 2.80 | 13.09 | |
SO62836_1 | 100 | 25894 | 535 | 4 | 2024-05-23 | 0.62 | 2024-05-11 | 24.99 | 1 | SO62836 | 2024-05-18 | 2.00 | 9.35 | |
SO62836_2 | 100 | 25894 | 465 | 4 | 2024-05-23 | 0.61 | 2024-05-11 | 24.49 | 2 | SO62836 | 2024-05-18 | 1.96 | 9.16 | |
SO62848_1 | 100 | 13228 | 485 | 4 | 2024-05-23 | 0.55 | 2024-05-11 | 21.98 | 1 | SO62848 | 2024-05-18 | 1.76 | 8.22 | |
SO62848_2 | 100 | 13228 | 217 | 4 | 2024-05-23 | 0.87 | 2024-05-11 | 34.99 | 2 | SO62848 | 2024-05-18 | 2.80 | 13.09 | |
SO62849_1 | 100 | 13297 | 485 | 4 | 2024-05-23 | 0.55 | 2024-05-11 | 21.98 | 1 | SO62849 | 2024-05-18 | 1.76 | 8.22 | |
SO62850_1 | 100 | 12067 | 537 | 4 | 2024-05-23 | 0.88 | 2024-05-11 | 35.00 | 1 | SO62850 | 2024-05-18 | 2.80 | 13.09 | |
SO62850_2 | 100 | 12067 | 528 | 4 | 2024-05-23 | 0.12 | 2024-05-11 | 4.99 | 2 | SO62850 | 2024-05-18 | 0.40 | 1.87 | |
SO62850_3 | 100 | 12067 | 214 | 4 | 2024-05-23 | 0.87 | 2024-05-11 | 34.99 | 3 | SO62850 | 2024-05-18 | 2.80 | 13.09 | |
SO62855_1 | 100 | 14457 | 357 | 4 | 2024-05-23 | 58.00 | 2024-05-11 | 2319.99 | 1 | SO62855 | 2024-05-18 | 185.60 | 1265.62 | |
SO62855_2 | 100 | 14457 | 478 | 4 | 2024-05-23 | 0.25 | 2024-05-11 | 9.99 | 2 | SO62855 | 2024-05-18 | 0.80 | 3.74 | |
SO62855_3 | 100 | 14457 | 477 | 4 | 2024-05-23 | 0.12 | 2024-05-11 | 4.99 | 3 | SO62855 | 2024-05-18 | 0.40 | 1.87 | |
SO62855_4 | 100 | 14457 | 465 | 4 | 2024-05-23 | 0.61 | 2024-05-11 | 24.49 | 4 | SO62855 | 2024-05-18 | 1.96 | 9.16 | |
SO62877_1 | 100 | 28591 | 214 | 4 | 2024-05-24 | 0.87 | 2024-05-12 | 34.99 | 1 | SO62877 | 2024-05-19 | 2.80 | 13.09 | |
SO62891_1 | 100 | 28994 | 539 | 4 | 2024-05-24 | 0.62 | 2024-05-12 | 24.99 | 1 | SO62891 | 2024-05-19 | 2.00 | 9.35 | |
SO62892_1 | 100 | 27204 | 530 | 4 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO62892 | 2024-05-19 | 0.40 | 1.87 | |
SO62894_1 | 100 | 26803 | 541 | 4 | 2024-05-24 | 0.72 | 2024-05-12 | 28.99 | 1 | SO62894 | 2024-05-19 | 2.32 | 10.84 | |
SO62894_2 | 100 | 26803 | 530 | 4 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 2 | SO62894 | 2024-05-19 | 0.40 | 1.87 | |
SO62894_3 | 100 | 26803 | 487 | 4 | 2024-05-24 | 1.37 | 2024-05-12 | 54.99 | 3 | SO62894 | 2024-05-19 | 4.40 | 20.57 | |
SO62897_1 | 100 | 24227 | 528 | 4 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO62897 | 2024-05-19 | 0.40 | 1.87 | |
SO62897_2 | 100 | 24227 | 536 | 4 | 2024-05-24 | 0.75 | 2024-05-12 | 29.99 | 2 | SO62897 | 2024-05-19 | 2.40 | 11.22 |
Generated 2024-11-13 08:44:05.787 UTC