[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 190 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44587_1 | 100 | 28627 | 311 | 4 | 2022-01-06 | 89.46 | 2021-12-25 | 3578.27 | 1 | SO44587 | 2022-01-01 | 286.26 | 2171.29 | |
SO44592_1 | 100 | 28761 | 314 | 4 | 2022-01-07 | 89.46 | 2021-12-26 | 3578.27 | 1 | SO44592 | 2022-01-02 | 286.26 | 2171.29 | |
SO44593_1 | 100 | 28645 | 313 | 4 | 2022-01-07 | 89.46 | 2021-12-26 | 3578.27 | 1 | SO44593 | 2022-01-02 | 286.26 | 2171.29 | |
SO44605_1 | 100 | 28672 | 314 | 4 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44605 | 2022-01-04 | 286.26 | 2171.29 | |
SO44607_1 | 100 | 28774 | 310 | 4 | 2022-01-09 | 89.46 | 2021-12-28 | 3578.27 | 1 | SO44607 | 2022-01-04 | 286.26 | 2171.29 | |
SO44612_1 | 100 | 28675 | 311 | 4 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44612 | 2022-01-05 | 286.26 | 2171.29 | |
SO44614_1 | 100 | 28650 | 312 | 4 | 2022-01-10 | 89.46 | 2021-12-29 | 3578.27 | 1 | SO44614 | 2022-01-05 | 286.26 | 2171.29 | |
SO44625_1 | 100 | 28658 | 314 | 4 | 2022-01-12 | 89.46 | 2021-12-31 | 3578.27 | 1 | SO44625 | 2022-01-07 | 286.26 | 2171.29 | |
SO44630_1 | 100 | 28765 | 312 | 4 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44630 | 2022-01-08 | 286.26 | 2171.29 | |
SO44631_1 | 100 | 28629 | 310 | 4 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44631 | 2022-01-08 | 286.26 | 2171.29 | |
SO44638_1 | 100 | 28651 | 310 | 4 | 2022-01-14 | 89.46 | 2022-01-02 | 3578.27 | 1 | SO44638 | 2022-01-09 | 286.26 | 2171.29 | |
SO44648_1 | 100 | 25916 | 344 | 4 | 2022-01-15 | 85.00 | 2022-01-03 | 3399.99 | 1 | SO44648 | 2022-01-10 | 272.00 | 1912.15 | |
SO44649_1 | 100 | 25924 | 344 | 4 | 2022-01-15 | 85.00 | 2022-01-03 | 3399.99 | 1 | SO44649 | 2022-01-10 | 272.00 | 1912.15 | |
SO44654_1 | 100 | 28619 | 313 | 4 | 2022-01-16 | 89.46 | 2022-01-04 | 3578.27 | 1 | SO44654 | 2022-01-11 | 286.26 | 2171.29 | |
SO44660_1 | 100 | 28775 | 310 | 4 | 2022-01-17 | 89.46 | 2022-01-05 | 3578.27 | 1 | SO44660 | 2022-01-12 | 286.26 | 2171.29 | |
SO44661_1 | 100 | 14639 | 336 | 4 | 2022-01-17 | 17.48 | 2022-01-05 | 699.10 | 1 | SO44661 | 2022-01-12 | 55.93 | 413.15 | |
SO44666_1 | 100 | 28763 | 313 | 4 | 2022-01-18 | 89.46 | 2022-01-06 | 3578.27 | 1 | SO44666 | 2022-01-13 | 286.26 | 2171.29 | |
SO44667_1 | 100 | 28795 | 310 | 4 | 2022-01-18 | 89.46 | 2022-01-06 | 3578.27 | 1 | SO44667 | 2022-01-13 | 286.26 | 2171.29 | |
SO44668_1 | 100 | 28621 | 313 | 4 | 2022-01-18 | 89.46 | 2022-01-06 | 3578.27 | 1 | SO44668 | 2022-01-13 | 286.26 | 2171.29 | |
SO44669_1 | 100 | 25942 | 350 | 4 | 2022-01-18 | 84.37 | 2022-01-06 | 3374.99 | 1 | SO44669 | 2022-01-13 | 270.00 | 1898.09 | |
SO44674_1 | 100 | 28635 | 314 | 4 | 2022-01-19 | 89.46 | 2022-01-07 | 3578.27 | 1 | SO44674 | 2022-01-14 | 286.26 | 2171.29 | |
SO44682_1 | 100 | 28797 | 310 | 4 | 2022-01-21 | 89.46 | 2022-01-09 | 3578.27 | 1 | SO44682 | 2022-01-16 | 286.26 | 2171.29 | |
SO44683_1 | 100 | 28799 | 312 | 4 | 2022-01-21 | 89.46 | 2022-01-09 | 3578.27 | 1 | SO44683 | 2022-01-16 | 286.26 | 2171.29 | |
SO44684_1 | 100 | 28643 | 310 | 4 | 2022-01-21 | 89.46 | 2022-01-09 | 3578.27 | 1 | SO44684 | 2022-01-16 | 286.26 | 2171.29 | |
SO44693_1 | 100 | 28676 | 311 | 4 | 2022-01-23 | 89.46 | 2022-01-11 | 3578.27 | 1 | SO44693 | 2022-01-18 | 286.26 | 2171.29 | |
SO44707_1 | 100 | 28649 | 311 | 4 | 2022-01-26 | 89.46 | 2022-01-14 | 3578.27 | 1 | SO44707 | 2022-01-21 | 286.26 | 2171.29 | |
SO44708_1 | 100 | 25909 | 350 | 4 | 2022-01-26 | 84.37 | 2022-01-14 | 3374.99 | 1 | SO44708 | 2022-01-21 | 270.00 | 1898.09 | |
SO44710_1 | 100 | 28674 | 313 | 4 | 2022-01-27 | 89.46 | 2022-01-15 | 3578.27 | 1 | SO44710 | 2022-01-22 | 286.26 | 2171.29 | |
SO44717_1 | 100 | 14616 | 336 | 4 | 2022-01-28 | 17.48 | 2022-01-16 | 699.10 | 1 | SO44717 | 2022-01-23 | 55.93 | 413.15 | |
SO44725_1 | 100 | 25910 | 345 | 4 | 2022-01-30 | 85.00 | 2022-01-18 | 3399.99 | 1 | SO44725 | 2022-01-25 | 272.00 | 1912.15 | |
SO44726_1 | 100 | 14614 | 332 | 4 | 2022-01-30 | 17.48 | 2022-01-18 | 699.10 | 1 | SO44726 | 2022-01-25 | 55.93 | 413.15 | |
SO44735_1 | 100 | 28673 | 311 | 4 | 2022-02-01 | 89.46 | 2022-01-20 | 3578.27 | 1 | SO44735 | 2022-01-27 | 286.26 | 2171.29 | |
SO44804_1 | 100 | 28829 | 310 | 4 | 2022-02-02 | 89.46 | 2022-01-21 | 3578.27 | 1 | SO44804 | 2022-01-28 | 286.26 | 2171.29 | |
SO44805_1 | 100 | 29011 | 314 | 4 | 2022-02-02 | 89.46 | 2022-01-21 | 3578.27 | 1 | SO44805 | 2022-01-28 | 286.26 | 2171.29 | |
SO44810_1 | 100 | 29126 | 311 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44810 | 2022-01-29 | 286.26 | 2171.29 | |
SO44812_1 | 100 | 28988 | 314 | 4 | 2022-02-03 | 89.46 | 2022-01-22 | 3578.27 | 1 | SO44812 | 2022-01-29 | 286.26 | 2171.29 | |
SO44818_1 | 100 | 28827 | 313 | 4 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44818 | 2022-01-30 | 286.26 | 2171.29 | |
SO44828_1 | 100 | 28997 | 312 | 4 | 2022-02-05 | 89.46 | 2022-01-24 | 3578.27 | 1 | SO44828 | 2022-01-31 | 286.26 | 2171.29 | |
SO44832_1 | 100 | 28804 | 311 | 4 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44832 | 2022-02-01 | 286.26 | 2171.29 | |
SO44833_1 | 100 | 28842 | 310 | 4 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44833 | 2022-02-01 | 286.26 | 2171.29 | |
SO44834_1 | 100 | 25952 | 350 | 4 | 2022-02-06 | 84.37 | 2022-01-25 | 3374.99 | 1 | SO44834 | 2022-02-01 | 270.00 | 1898.09 | |
SO44840_1 | 100 | 28857 | 314 | 4 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44840 | 2022-02-02 | 286.26 | 2171.29 | |
SO44843_1 | 100 | 29058 | 312 | 4 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44843 | 2022-02-03 | 286.26 | 2171.29 | |
SO44844_1 | 100 | 29139 | 314 | 4 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44844 | 2022-02-03 | 286.26 | 2171.29 | |
SO44852_1 | 100 | 29128 | 311 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44852 | 2022-02-04 | 286.26 | 2171.29 | |
SO44854_1 | 100 | 29004 | 311 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44854 | 2022-02-04 | 286.26 | 2171.29 | |
SO44872_1 | 100 | 29111 | 312 | 4 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44872 | 2022-02-06 | 286.26 | 2171.29 | |
SO44873_1 | 100 | 28828 | 312 | 4 | 2022-02-11 | 89.46 | 2022-01-30 | 3578.27 | 1 | SO44873 | 2022-02-06 | 286.26 | 2171.29 | |
SO44875_1 | 100 | 29048 | 313 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44875 | 2022-02-07 | 286.26 | 2171.29 | |
SO44876_1 | 100 | 29056 | 312 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44876 | 2022-02-07 | 286.26 | 2171.29 | |
SO44877_1 | 100 | 29136 | 311 | 4 | 2022-02-12 | 89.46 | 2022-01-31 | 3578.27 | 1 | SO44877 | 2022-02-07 | 286.26 | 2171.29 | |
SO44886_1 | 100 | 29108 | 314 | 4 | 2022-02-13 | 89.46 | 2022-02-01 | 3578.27 | 1 | SO44886 | 2022-02-08 | 286.26 | 2171.29 | |
SO44891_1 | 100 | 28847 | 310 | 4 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44891 | 2022-02-09 | 286.26 | 2171.29 | |
SO44894_1 | 100 | 25943 | 348 | 4 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44894 | 2022-02-09 | 270.00 | 1898.09 | |
SO44895_1 | 100 | 25951 | 351 | 4 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44895 | 2022-02-09 | 270.00 | 1898.09 | |
SO44908_1 | 100 | 29032 | 314 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44908 | 2022-02-11 | 286.26 | 2171.29 | |
SO44909_1 | 100 | 28840 | 310 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44909 | 2022-02-11 | 286.26 | 2171.29 | |
SO44910_1 | 100 | 25969 | 344 | 4 | 2022-02-16 | 85.00 | 2022-02-04 | 3399.99 | 1 | SO44910 | 2022-02-11 | 272.00 | 1912.15 | |
SO44911_1 | 100 | 25976 | 349 | 4 | 2022-02-16 | 84.37 | 2022-02-04 | 3374.99 | 1 | SO44911 | 2022-02-11 | 270.00 | 1898.09 | |
SO44912_1 | 100 | 28966 | 310 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44912 | 2022-02-11 | 286.26 | 2171.29 | |
SO44920_1 | 100 | 14648 | 338 | 4 | 2022-02-17 | 17.48 | 2022-02-05 | 699.10 | 1 | SO44920 | 2022-02-12 | 55.93 | 413.15 | |
SO44930_1 | 100 | 29110 | 312 | 4 | 2022-02-19 | 89.46 | 2022-02-07 | 3578.27 | 1 | SO44930 | 2022-02-14 | 286.26 | 2171.29 | |
SO44950_1 | 100 | 28835 | 313 | 4 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44950 | 2022-02-16 | 286.26 | 2171.29 | |
SO44951_1 | 100 | 28843 | 311 | 4 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44951 | 2022-02-16 | 286.26 | 2171.29 | |
SO44952_1 | 100 | 25955 | 349 | 4 | 2022-02-21 | 84.37 | 2022-02-09 | 3374.99 | 1 | SO44952 | 2022-02-16 | 270.00 | 1898.09 | |
SO44954_1 | 100 | 28990 | 310 | 4 | 2022-02-21 | 89.46 | 2022-02-09 | 3578.27 | 1 | SO44954 | 2022-02-16 | 286.26 | 2171.29 | |
SO55690_1 | 100 | 11649 | 491 | 4 | 2023-12-09 | 1.35 | 2023-11-27 | 53.99 | 1 | SO55690 | 2023-12-04 | 4.32 | 41.57 | |
SO55705_1 | 100 | 17122 | 477 | 4 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 1 | SO55705 | 2023-12-04 | 0.40 | 1.87 | |
SO55705_2 | 100 | 17122 | 489 | 4 | 2023-12-09 | 1.35 | 2023-11-27 | 53.99 | 2 | SO55705 | 2023-12-04 | 4.32 | 41.57 | |
SO55717_1 | 100 | 12410 | 537 | 4 | 2023-12-09 | 0.88 | 2023-11-27 | 35.00 | 1 | SO55717 | 2023-12-04 | 2.80 | 13.09 | |
SO55717_2 | 100 | 12410 | 528 | 4 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 2 | SO55717 | 2023-12-04 | 0.40 | 1.87 | |
SO55720_1 | 100 | 14024 | 587 | 4 | 2023-12-09 | 19.24 | 2023-11-27 | 769.49 | 1 | SO55720 | 2023-12-04 | 61.56 | 419.78 | |
SO55720_2 | 100 | 14024 | 475 | 4 | 2023-12-09 | 1.75 | 2023-11-27 | 69.99 | 2 | SO55720 | 2023-12-04 | 5.60 | 26.18 | |
SO55720_3 | 100 | 14024 | 491 | 4 | 2023-12-09 | 1.35 | 2023-11-27 | 53.99 | 3 | SO55720 | 2023-12-04 | 4.32 | 41.57 | |
SO55720_4 | 100 | 14024 | 225 | 4 | 2023-12-09 | 0.22 | 2023-11-27 | 8.99 | 4 | SO55720 | 2023-12-04 | 0.72 | 6.92 | |
SO55721_1 | 100 | 13202 | 353 | 4 | 2023-12-09 | 58.00 | 2023-11-27 | 2319.99 | 1 | SO55721 | 2023-12-04 | 185.60 | 1265.62 | |
SO55721_2 | 100 | 13202 | 485 | 4 | 2023-12-09 | 0.55 | 2023-11-27 | 21.98 | 2 | SO55721 | 2023-12-04 | 1.76 | 8.22 | |
SO55721_3 | 100 | 13202 | 214 | 4 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 3 | SO55721 | 2023-12-04 | 2.80 | 13.09 | |
SO55722_1 | 100 | 13032 | 363 | 4 | 2023-12-09 | 57.37 | 2023-11-27 | 2294.99 | 1 | SO55722 | 2023-12-04 | 183.60 | 1251.98 | |
SO55722_2 | 100 | 13032 | 480 | 4 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 2 | SO55722 | 2023-12-04 | 0.18 | 0.86 | |
SO55728_1 | 100 | 24804 | 562 | 4 | 2023-12-09 | 59.60 | 2023-11-27 | 2384.07 | 1 | SO55728 | 2023-12-04 | 190.73 | 1481.94 | |
SO55731_1 | 100 | 16504 | 604 | 4 | 2023-12-09 | 13.50 | 2023-11-27 | 539.99 | 1 | SO55731 | 2023-12-04 | 43.20 | 343.65 | |
SO55731_2 | 100 | 16504 | 479 | 4 | 2023-12-09 | 0.22 | 2023-11-27 | 8.99 | 2 | SO55731 | 2023-12-04 | 0.72 | 3.36 | |
SO55731_3 | 100 | 16504 | 477 | 4 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 3 | SO55731 | 2023-12-04 | 0.40 | 1.87 | |
SO55731_4 | 100 | 16504 | 214 | 4 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 4 | SO55731 | 2023-12-04 | 2.80 | 13.09 | |
SO55732_1 | 100 | 19775 | 382 | 2 | 4 | 2023-12-09 | 28.01 | 2023-11-27 | 1120.49 | 1 | SO55732 | 2023-12-04 | 89.64 | 713.08 |
SO55732_2 | 100 | 19775 | 225 | 4 | 2023-12-09 | 0.22 | 2023-11-27 | 8.99 | 2 | SO55732 | 2023-12-04 | 0.72 | 6.92 | |
SO55732_3 | 100 | 19775 | 490 | 4 | 2023-12-09 | 1.35 | 2023-11-27 | 53.99 | 3 | SO55732 | 2023-12-04 | 4.32 | 41.57 | |
SO55758_1 | 100 | 22729 | 536 | 4 | 2023-12-10 | 0.75 | 2023-11-28 | 29.99 | 1 | SO55758 | 2023-12-05 | 2.40 | 11.22 | |
SO55758_2 | 100 | 22729 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 2 | SO55758 | 2023-12-05 | 0.40 | 1.87 | |
SO55758_3 | 100 | 22729 | 217 | 4 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 3 | SO55758 | 2023-12-05 | 2.80 | 13.09 | |
SO55760_1 | 100 | 22077 | 536 | 4 | 2023-12-10 | 0.75 | 2023-11-28 | 29.99 | 1 | SO55760 | 2023-12-05 | 2.40 | 11.22 | |
SO55762_1 | 100 | 21780 | 478 | 4 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 1 | SO55762 | 2023-12-05 | 0.80 | 3.74 | |
SO55762_2 | 100 | 21780 | 477 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 2 | SO55762 | 2023-12-05 | 0.40 | 1.87 | |
SO55762_3 | 100 | 21780 | 487 | 4 | 2023-12-10 | 1.37 | 2023-11-28 | 54.99 | 3 | SO55762 | 2023-12-05 | 4.40 | 20.57 | |
SO55762_4 | 100 | 21780 | 484 | 4 | 2023-12-10 | 0.20 | 2023-11-28 | 7.95 | 4 | SO55762 | 2023-12-05 | 0.64 | 2.97 | |
SO55763_1 | 100 | 23007 | 477 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55763 | 2023-12-05 | 0.40 | 1.87 | |
SO55763_2 | 100 | 23007 | 478 | 4 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 2 | SO55763 | 2023-12-05 | 0.80 | 3.74 | |
SO55767_1 | 100 | 15368 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55767 | 2023-12-05 | 0.40 | 1.87 | |
SO55767_2 | 100 | 15368 | 480 | 2 | 4 | 2023-12-10 | 0.06 | 2023-11-28 | 2.29 | 2 | SO55767 | 2023-12-05 | 0.18 | 0.86 |
SO55768_1 | 100 | 14445 | 485 | 4 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 1 | SO55768 | 2023-12-05 | 1.76 | 8.22 | |
SO55768_2 | 100 | 14445 | 478 | 4 | 2023-12-10 | 0.25 | 2023-11-28 | 9.99 | 2 | SO55768 | 2023-12-05 | 0.80 | 3.74 | |
SO55768_3 | 100 | 14445 | 477 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 3 | SO55768 | 2023-12-05 | 0.40 | 1.87 | |
SO55768_4 | 100 | 14445 | 473 | 4 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 4 | SO55768 | 2023-12-05 | 5.08 | 23.75 | |
SO55770_1 | 100 | 15273 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55770 | 2023-12-05 | 0.40 | 1.87 | |
SO55770_2 | 100 | 15273 | 222 | 4 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO55770 | 2023-12-05 | 2.80 | 13.09 | |
SO55770_3 | 100 | 15273 | 471 | 4 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 3 | SO55770 | 2023-12-05 | 5.08 | 23.75 | |
SO55782_1 | 100 | 11499 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55782 | 2023-12-05 | 0.40 | 1.87 | |
SO55782_2 | 100 | 11499 | 537 | 4 | 2023-12-10 | 0.88 | 2023-11-28 | 35.00 | 2 | SO55782 | 2023-12-05 | 2.80 | 13.09 | |
SO55782_3 | 100 | 11499 | 485 | 4 | 2023-12-10 | 0.55 | 2023-11-28 | 21.98 | 3 | SO55782 | 2023-12-05 | 1.76 | 8.22 | |
SO55782_4 | 100 | 11499 | 484 | 4 | 2023-12-10 | 0.20 | 2023-11-28 | 7.95 | 4 | SO55782 | 2023-12-05 | 0.64 | 2.97 | |
SO55786_1 | 100 | 12960 | 528 | 4 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO55786 | 2023-12-05 | 0.40 | 1.87 |
Generated 2024-09-20 20:33:22.337 UTC