[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 536 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45817_1 | 100 | 14801 | 311 | 8 | 2022-07-24 | 89.46 | 2022-07-12 | 3578.27 | 1 | SO45817 | 2022-07-19 | 286.26 | 2171.29 | |
SO56631_2 | 100 | 29435 | 530 | 8 | 2024-02-15 | 0.12 | 2024-02-03 | 4.99 | 2 | SO56631 | 2024-02-10 | 0.40 | 1.87 | |
SO62814_4 | 100 | 22685 | 217 | 8 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 4 | SO62814 | 2024-05-14 | 2.80 | 13.09 | |
SO45836_1 | 100 | 14823 | 311 | 8 | 2022-07-27 | 89.46 | 2022-07-15 | 3578.27 | 1 | SO45836 | 2022-07-22 | 286.26 | 2171.29 | |
SO56631_3 | 100 | 29435 | 222 | 8 | 2024-02-15 | 0.87 | 2024-02-03 | 34.99 | 3 | SO56631 | 2024-02-10 | 2.80 | 13.09 | |
SO62825_1 | 100 | 16442 | 372 | 8 | 2024-05-20 | 61.08 | 2024-05-08 | 2443.35 | 1 | SO62825 | 2024-05-15 | 195.47 | 1554.95 | |
SO45840_1 | 100 | 11246 | 349 | 8 | 2022-07-28 | 84.37 | 2022-07-16 | 3374.99 | 1 | SO45840 | 2022-07-23 | 270.00 | 1898.09 | |
SO56638_1 | 100 | 27883 | 567 | 8 | 2024-02-15 | 18.56 | 2024-02-03 | 742.35 | 1 | SO56638 | 2024-02-10 | 59.39 | 461.44 | |
SO62825_2 | 100 | 16442 | 540 | 8 | 2024-05-20 | 0.82 | 2024-05-08 | 32.60 | 2 | SO62825 | 2024-05-15 | 2.61 | 12.19 | |
SO45862_1 | 100 | 14827 | 312 | 8 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO45862 | 2022-07-27 | 286.26 | 2171.29 | |
SO56638_2 | 100 | 27883 | 530 | 8 | 2024-02-15 | 0.12 | 2024-02-03 | 4.99 | 2 | SO56638 | 2024-02-10 | 0.40 | 1.87 | |
SO62825_3 | 100 | 16442 | 529 | 8 | 2024-05-20 | 0.10 | 2024-05-08 | 3.99 | 3 | SO62825 | 2024-05-15 | 0.32 | 1.49 | |
SO45868_1 | 100 | 14819 | 310 | 8 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO45868 | 2022-07-28 | 286.26 | 2171.29 | |
SO56638_3 | 100 | 27883 | 541 | 8 | 2024-02-15 | 0.72 | 2024-02-03 | 28.99 | 3 | SO56638 | 2024-02-10 | 2.32 | 10.84 | |
SO62826_1 | 100 | 15625 | 357 | 2 | 8 | 2024-05-20 | 58.00 | 2024-05-08 | 2319.99 | 1 | SO62826 | 2024-05-15 | 185.60 | 1265.62 |
SO45869_1 | 100 | 14822 | 310 | 8 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO45869 | 2022-07-28 | 286.26 | 2171.29 | |
SO56638_4 | 100 | 27883 | 480 | 2 | 8 | 2024-02-15 | 0.06 | 2024-02-03 | 2.29 | 4 | SO56638 | 2024-02-10 | 0.18 | 0.86 |
SO62826_2 | 100 | 15625 | 485 | 8 | 2024-05-20 | 0.55 | 2024-05-08 | 21.98 | 2 | SO62826 | 2024-05-15 | 1.76 | 8.22 | |
SO45872_1 | 100 | 11249 | 347 | 8 | 2022-08-03 | 85.00 | 2022-07-22 | 3399.99 | 1 | SO45872 | 2022-07-29 | 272.00 | 1912.15 | |
SO56649_1 | 100 | 24723 | 582 | 8 | 2024-02-16 | 42.52 | 2024-02-04 | 1700.99 | 1 | SO56649 | 2024-02-11 | 136.08 | 1082.51 | |
SO62840_1 | 100 | 17837 | 535 | 8 | 2024-05-20 | 0.62 | 2024-05-08 | 24.99 | 1 | SO62840 | 2024-05-15 | 2.00 | 9.35 | |
SO45879_1 | 100 | 19443 | 338 | 8 | 2022-08-04 | 17.48 | 2022-07-23 | 699.10 | 1 | SO45879 | 2022-07-30 | 55.93 | 413.15 | |
SO56649_2 | 100 | 24723 | 539 | 8 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 2 | SO56649 | 2024-02-11 | 2.00 | 9.35 | |
SO62840_2 | 100 | 17837 | 528 | 8 | 2024-05-20 | 0.12 | 2024-05-08 | 4.99 | 2 | SO62840 | 2024-05-15 | 0.40 | 1.87 | |
SO45890_1 | 100 | 11338 | 349 | 8 | 2022-08-05 | 84.37 | 2022-07-24 | 3374.99 | 1 | SO45890 | 2022-07-31 | 270.00 | 1898.09 | |
SO56649_3 | 100 | 24723 | 473 | 8 | 2024-02-16 | 1.59 | 2024-02-04 | 63.50 | 3 | SO56649 | 2024-02-11 | 5.08 | 23.75 | |
SO62840_3 | 100 | 17837 | 225 | 8 | 2024-05-20 | 0.22 | 2024-05-08 | 8.99 | 3 | SO62840 | 2024-05-15 | 0.72 | 6.92 | |
SO45891_1 | 100 | 11380 | 346 | 8 | 2022-08-05 | 85.00 | 2022-07-24 | 3399.99 | 1 | SO45891 | 2022-07-31 | 272.00 | 1912.15 | |
SO56649_4 | 100 | 24723 | 529 | 8 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 4 | SO56649 | 2024-02-11 | 0.32 | 1.49 | |
SO62840_4 | 100 | 17837 | 214 | 8 | 2024-05-20 | 0.87 | 2024-05-08 | 34.99 | 4 | SO62840 | 2024-05-15 | 2.80 | 13.09 | |
SO45894_1 | 100 | 19450 | 332 | 8 | 2022-08-06 | 17.48 | 2022-07-25 | 699.10 | 1 | SO45894 | 2022-08-01 | 55.93 | 413.15 | |
SO56666_1 | 100 | 19259 | 529 | 8 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56666 | 2024-02-11 | 0.32 | 1.49 | |
SO62841_1 | 100 | 17758 | 535 | 8 | 2024-05-20 | 0.62 | 2024-05-08 | 24.99 | 1 | SO62841 | 2024-05-15 | 2.00 | 9.35 | |
SO45917_1 | 100 | 11332 | 346 | 8 | 2022-08-09 | 85.00 | 2022-07-28 | 3399.99 | 1 | SO45917 | 2022-08-04 | 272.00 | 1912.15 | |
SO56666_2 | 100 | 19259 | 539 | 8 | 2024-02-16 | 0.62 | 2024-02-04 | 24.99 | 2 | SO56666 | 2024-02-11 | 2.00 | 9.35 | |
SO62841_2 | 100 | 17758 | 528 | 8 | 2024-05-20 | 0.12 | 2024-05-08 | 4.99 | 2 | SO62841 | 2024-05-15 | 0.40 | 1.87 | |
SO45924_1 | 100 | 14803 | 310 | 8 | 2022-08-09 | 89.46 | 2022-07-28 | 3578.27 | 1 | SO45924 | 2022-08-04 | 286.26 | 2171.29 | |
SO56669_1 | 100 | 17652 | 529 | 8 | 2024-02-16 | 0.10 | 2024-02-04 | 3.99 | 1 | SO56669 | 2024-02-11 | 0.32 | 1.49 | |
SO62841_3 | 100 | 17758 | 480 | 2 | 8 | 2024-05-20 | 0.06 | 2024-05-08 | 2.29 | 3 | SO62841 | 2024-05-15 | 0.18 | 0.86 |
SO45935_1 | 100 | 19439 | 326 | 8 | 2022-08-11 | 17.48 | 2022-07-30 | 699.10 | 1 | SO45935 | 2022-08-06 | 55.93 | 413.15 | |
SO62843_1 | 100 | 21836 | 477 | 8 | 2024-05-20 | 0.12 | 2024-05-08 | 4.99 | 1 | SO62843 | 2024-05-15 | 0.40 | 1.87 | |
SO62845_1 | 100 | 24563 | 529 | 8 | 2024-05-20 | 0.10 | 2024-05-08 | 3.99 | 1 | SO62845 | 2024-05-15 | 0.32 | 1.49 | |
SO62845_2 | 100 | 24563 | 480 | 8 | 2024-05-20 | 0.06 | 2024-05-08 | 2.29 | 2 | SO62845 | 2024-05-15 | 0.18 | 0.86 | |
SO62869_1 | 100 | 28376 | 382 | 8 | 2024-05-20 | 28.01 | 2024-05-08 | 1120.49 | 1 | SO62869 | 2024-05-15 | 89.64 | 713.08 | |
SO62869_2 | 100 | 28376 | 479 | 8 | 2024-05-20 | 0.22 | 2024-05-08 | 8.99 | 2 | SO62869 | 2024-05-15 | 0.72 | 3.36 | |
SO62869_3 | 100 | 28376 | 477 | 8 | 2024-05-20 | 0.12 | 2024-05-08 | 4.99 | 3 | SO62869 | 2024-05-15 | 0.40 | 1.87 | |
SO62885_1 | 100 | 24053 | 376 | 8 | 2024-05-21 | 61.08 | 2024-05-09 | 2443.35 | 1 | SO62885 | 2024-05-16 | 195.47 | 1554.95 | |
SO62887_1 | 100 | 15084 | 353 | 8 | 2024-05-21 | 58.00 | 2024-05-09 | 2319.99 | 1 | SO62887 | 2024-05-16 | 185.60 | 1265.62 | |
SO62887_2 | 100 | 15084 | 478 | 8 | 2024-05-21 | 0.25 | 2024-05-09 | 9.99 | 2 | SO62887 | 2024-05-16 | 0.80 | 3.74 | |
SO62887_3 | 100 | 15084 | 477 | 8 | 2024-05-21 | 0.12 | 2024-05-09 | 4.99 | 3 | SO62887 | 2024-05-16 | 0.40 | 1.87 | |
SO62887_4 | 100 | 15084 | 472 | 8 | 2024-05-21 | 1.59 | 2024-05-09 | 63.50 | 4 | SO62887 | 2024-05-16 | 5.08 | 23.75 | |
SO62906_1 | 100 | 17853 | 528 | 8 | 2024-05-21 | 0.12 | 2024-05-09 | 4.99 | 1 | SO62906 | 2024-05-16 | 0.40 | 1.87 | |
SO62906_2 | 100 | 17853 | 535 | 8 | 2024-05-21 | 0.62 | 2024-05-09 | 24.99 | 2 | SO62906 | 2024-05-16 | 2.00 | 9.35 | |
SO62909_1 | 100 | 21821 | 477 | 8 | 2024-05-21 | 0.12 | 2024-05-09 | 4.99 | 1 | SO62909 | 2024-05-16 | 0.40 | 1.87 | |
SO62909_2 | 100 | 21821 | 214 | 8 | 2024-05-21 | 0.87 | 2024-05-09 | 34.99 | 2 | SO62909 | 2024-05-16 | 2.80 | 13.09 | |
SO62909_3 | 100 | 21821 | 225 | 8 | 2024-05-21 | 0.22 | 2024-05-09 | 8.99 | 3 | SO62909 | 2024-05-16 | 0.72 | 6.92 | |
SO62913_1 | 100 | 14528 | 530 | 8 | 2024-05-21 | 0.12 | 2024-05-09 | 4.99 | 1 | SO62913 | 2024-05-16 | 0.40 | 1.87 | |
SO62928_1 | 100 | 16199 | 576 | 8 | 2024-05-21 | 59.60 | 2024-05-09 | 2384.07 | 1 | SO62928 | 2024-05-16 | 190.73 | 1481.94 | |
SO62928_2 | 100 | 16199 | 214 | 8 | 2024-05-21 | 0.87 | 2024-05-09 | 34.99 | 2 | SO62928 | 2024-05-16 | 2.80 | 13.09 | |
SO62944_1 | 100 | 13540 | 584 | 8 | 2024-05-21 | 13.50 | 2024-05-09 | 539.99 | 1 | SO62944 | 2024-05-16 | 43.20 | 343.65 | |
SO62944_2 | 100 | 13540 | 479 | 8 | 2024-05-21 | 0.22 | 2024-05-09 | 8.99 | 2 | SO62944 | 2024-05-16 | 0.72 | 3.36 | |
SO62945_1 | 100 | 25744 | 574 | 8 | 2024-05-21 | 59.60 | 2024-05-09 | 2384.07 | 1 | SO62945 | 2024-05-16 | 190.73 | 1481.94 |
Generated 2024-11-10 23:35:21.217 UTC