[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 5163 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45449_1 | 100 | 14189 | 310 | 8 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45449 | 2022-06-06 | 286.26 | 2171.29 | |
SO56079_1 | 100 | 22068 | 478 | 4 | 2024-02-05 | 0.25 | 2024-01-24 | 9.99 | 1 | SO56079 | 2024-01-31 | 0.80 | 3.74 | |
SO62636_1 | 6 | 14072 | 234 | 9 | 2024-05-17 | 1.25 | 2024-05-05 | 49.99 | 1 | SO62636 | 2024-05-12 | 4.00 | 38.49 | |
SO69153_4 | 100 | 23568 | 480 | 1 | 2024-08-19 | 0.06 | 2024-08-07 | 2.29 | 4 | SO69153 | 2024-08-14 | 0.18 | 0.86 | |
SO45450_1 | 100 | 28624 | 312 | 6 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45450 | 2022-06-06 | 286.26 | 2171.29 | |
SO56079_2 | 100 | 22068 | 477 | 4 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 2 | SO56079 | 2024-01-31 | 0.40 | 1.87 | |
SO62637_1 | 6 | 15020 | 225 | 9 | 2024-05-17 | 0.22 | 2024-05-05 | 8.99 | 1 | SO62637 | 2024-05-12 | 0.72 | 6.92 | |
SO69154_1 | 100 | 20913 | 382 | 8 | 2024-08-19 | 28.01 | 2024-08-07 | 1120.49 | 1 | SO69154 | 2024-08-14 | 89.64 | 713.08 | |
SO45451_1 | 100 | 29279 | 311 | 4 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45451 | 2022-06-06 | 286.26 | 2171.29 | |
SO56079_3 | 100 | 22068 | 225 | 4 | 2024-02-05 | 0.22 | 2024-01-24 | 8.99 | 3 | SO56079 | 2024-01-31 | 0.72 | 6.92 | |
SO62638_1 | 98 | 21669 | 581 | 10 | 2024-05-17 | 42.52 | 2024-05-05 | 1700.99 | 1 | SO62638 | 2024-05-12 | 136.08 | 1082.51 | |
SO69154_2 | 100 | 20913 | 217 | 8 | 2024-08-19 | 0.87 | 2024-08-07 | 34.99 | 2 | SO69154 | 2024-08-14 | 2.80 | 13.09 | |
SO45452_1 | 6 | 19559 | 314 | 9 | 2022-06-11 | 89.46 | 2022-05-30 | 3578.27 | 1 | SO45452 | 2022-06-06 | 286.26 | 2171.29 | |
SO56080_1 | 100 | 23002 | 528 | 1 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56080 | 2024-01-31 | 0.40 | 1.87 | |
SO62639_1 | 100 | 14965 | 600 | 7 | 2024-05-17 | 13.50 | 2024-05-05 | 539.99 | 1 | SO62639 | 2024-05-12 | 43.20 | 294.58 | |
SO69154_3 | 100 | 20913 | 225 | 8 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 3 | SO69154 | 2024-08-14 | 0.72 | 6.92 | |
SO45453_1 | 100 | 12549 | 311 | 7 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45453 | 2022-06-07 | 286.26 | 2171.29 | |
SO56080_2 | 100 | 23002 | 536 | 1 | 2024-02-05 | 0.75 | 2024-01-24 | 29.99 | 2 | SO56080 | 2024-01-31 | 2.40 | 11.22 | |
SO62639_2 | 100 | 14965 | 528 | 7 | 2024-05-17 | 0.12 | 2024-05-05 | 4.99 | 2 | SO62639 | 2024-05-12 | 0.40 | 1.87 | |
SO69155_1 | 100 | 24706 | 605 | 8 | 2024-08-19 | 13.50 | 2024-08-07 | 539.99 | 1 | SO69155 | 2024-08-14 | 43.20 | 343.65 | |
SO45454_1 | 19 | 23074 | 312 | 6 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45454 | 2022-06-07 | 286.26 | 2171.29 | |
SO56080_3 | 100 | 23002 | 485 | 1 | 2024-02-05 | 0.55 | 2024-01-24 | 21.98 | 3 | SO56080 | 2024-01-31 | 1.76 | 8.22 | |
SO62639_3 | 100 | 14965 | 535 | 7 | 2024-05-17 | 0.62 | 2024-05-05 | 24.99 | 3 | SO62639 | 2024-05-12 | 2.00 | 9.35 | |
SO69155_2 | 100 | 24706 | 479 | 8 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 2 | SO69155 | 2024-08-14 | 0.72 | 3.36 | |
SO45455_1 | 100 | 14163 | 310 | 8 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45455 | 2022-06-08 | 286.26 | 2171.29 | |
SO56080_4 | 100 | 23002 | 480 | 1 | 2024-02-05 | 0.06 | 2024-01-24 | 2.29 | 4 | SO56080 | 2024-01-31 | 0.18 | 0.86 | |
SO62639_4 | 100 | 14965 | 480 | 2 | 7 | 2024-05-17 | 0.06 | 2024-05-05 | 2.29 | 4 | SO62639 | 2024-05-12 | 0.18 | 0.86 |
SO69155_3 | 100 | 24706 | 477 | 8 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 3 | SO69155 | 2024-08-14 | 0.40 | 1.87 | |
SO45456_1 | 19 | 23113 | 312 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45456 | 2022-06-08 | 286.26 | 2171.29 | |
SO56080_5 | 100 | 23002 | 484 | 1 | 2024-02-05 | 0.20 | 2024-01-24 | 7.95 | 5 | SO56080 | 2024-01-31 | 0.64 | 2.97 | |
SO62640_1 | 100 | 25492 | 582 | 8 | 2024-05-17 | 42.52 | 2024-05-05 | 1700.99 | 1 | SO62640 | 2024-05-12 | 136.08 | 1082.51 | |
SO69155_4 | 100 | 24706 | 463 | 8 | 2024-08-19 | 0.61 | 2024-08-07 | 24.49 | 4 | SO69155 | 2024-08-14 | 1.96 | 9.16 | |
SO45457_1 | 100 | 27752 | 313 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45457 | 2022-06-08 | 286.26 | 2171.29 | |
SO56081_1 | 100 | 21294 | 478 | 4 | 2024-02-05 | 0.25 | 2024-01-24 | 9.99 | 1 | SO56081 | 2024-01-31 | 0.80 | 3.74 | |
SO62640_2 | 100 | 25492 | 539 | 8 | 2024-05-17 | 0.62 | 2024-05-05 | 24.99 | 2 | SO62640 | 2024-05-12 | 2.00 | 9.35 | |
SO69156_1 | 100 | 12296 | 562 | 7 | 2024-08-19 | 59.60 | 2024-08-07 | 2384.07 | 1 | SO69156 | 2024-08-14 | 190.73 | 1481.94 | |
SO45458_1 | 6 | 19599 | 311 | 9 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45458 | 2022-06-08 | 286.26 | 2171.29 | |
SO56082_1 | 100 | 20789 | 478 | 4 | 2024-02-05 | 0.25 | 2024-01-24 | 9.99 | 1 | SO56082 | 2024-01-31 | 0.80 | 3.74 | |
SO62640_3 | 100 | 25492 | 529 | 8 | 2024-05-17 | 0.10 | 2024-05-05 | 3.99 | 3 | SO62640 | 2024-05-12 | 0.32 | 1.49 | |
SO69156_2 | 100 | 12296 | 477 | 7 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 2 | SO69156 | 2024-08-14 | 0.40 | 1.87 | |
SO45459_1 | 6 | 19605 | 310 | 9 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45459 | 2022-06-08 | 286.26 | 2171.29 | |
SO56082_2 | 100 | 20789 | 477 | 4 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 2 | SO56082 | 2024-01-31 | 0.40 | 1.87 | |
SO62640_4 | 100 | 25492 | 217 | 8 | 2024-05-17 | 0.87 | 2024-05-05 | 34.99 | 4 | SO62640 | 2024-05-12 | 2.80 | 13.09 | |
SO69156_3 | 100 | 12296 | 479 | 7 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 3 | SO69156 | 2024-08-14 | 0.72 | 3.36 | |
SO45460_1 | 6 | 25822 | 334 | 9 | 2022-06-13 | 17.48 | 2022-06-01 | 699.10 | 1 | SO45460 | 2022-06-08 | 55.93 | 413.15 | |
SO56082_3 | 100 | 20789 | 465 | 4 | 2024-02-05 | 0.61 | 2024-01-24 | 24.49 | 3 | SO56082 | 2024-01-31 | 1.96 | 9.16 | |
SO62641_1 | 100 | 15928 | 357 | 8 | 2024-05-17 | 58.00 | 2024-05-05 | 2319.99 | 1 | SO62641 | 2024-05-12 | 185.60 | 1265.62 | |
SO69156_4 | 100 | 12296 | 225 | 7 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 4 | SO69156 | 2024-08-14 | 0.72 | 6.92 | |
SO45461_1 | 100 | 28646 | 311 | 6 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45461 | 2022-06-09 | 286.26 | 2171.29 | |
SO56083_1 | 100 | 19886 | 225 | 1 | 2024-02-05 | 0.22 | 2024-01-24 | 8.99 | 1 | SO56083 | 2024-01-31 | 0.72 | 6.92 | |
SO62641_2 | 100 | 15928 | 477 | 8 | 2024-05-17 | 0.12 | 2024-05-05 | 4.99 | 2 | SO62641 | 2024-05-12 | 0.40 | 1.87 | |
SO69157_1 | 6 | 11025 | 565 | 9 | 2024-08-19 | 18.56 | 2024-08-07 | 742.35 | 1 | SO69157 | 2024-08-14 | 59.39 | 461.44 | |
SO45462_1 | 100 | 28647 | 310 | 6 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45462 | 2022-06-09 | 286.26 | 2171.29 | |
SO56083_2 | 100 | 19886 | 474 | 1 | 2024-02-05 | 1.75 | 2024-01-24 | 69.99 | 2 | SO56083 | 2024-01-31 | 5.60 | 26.18 | |
SO62641_3 | 100 | 15928 | 478 | 8 | 2024-05-17 | 0.25 | 2024-05-05 | 9.99 | 3 | SO62641 | 2024-05-12 | 0.80 | 3.74 | |
SO69157_2 | 6 | 11025 | 488 | 9 | 2024-08-19 | 1.35 | 2024-08-07 | 53.99 | 2 | SO69157 | 2024-08-14 | 4.32 | 41.57 | |
SO45463_1 | 100 | 11171 | 312 | 4 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45463 | 2022-06-09 | 286.26 | 2171.29 | |
SO56084_1 | 19 | 11505 | 474 | 6 | 2024-02-05 | 1.75 | 2024-01-24 | 69.99 | 1 | SO56084 | 2024-01-31 | 5.60 | 26.18 | |
SO62641_4 | 100 | 15928 | 467 | 8 | 2024-05-17 | 0.61 | 2024-05-05 | 24.49 | 4 | SO62641 | 2024-05-12 | 1.96 | 9.16 | |
SO69158_1 | 6 | 14316 | 569 | 9 | 2024-08-19 | 18.56 | 2024-08-07 | 742.35 | 1 | SO69158 | 2024-08-14 | 59.39 | 461.44 | |
SO45464_1 | 6 | 19586 | 314 | 9 | 2022-06-14 | 89.46 | 2022-06-02 | 3578.27 | 1 | SO45464 | 2022-06-09 | 286.26 | 2171.29 | |
SO56084_2 | 19 | 11505 | 490 | 6 | 2024-02-05 | 1.35 | 2024-01-24 | 53.99 | 2 | SO56084 | 2024-01-31 | 4.32 | 41.57 |
Generated 2024-11-10 23:12:44.926 UTC