[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 1531 < SKIP 2000 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO62487_1 | 19 | 20096 | 535 | 6 | 2024-05-14 | 0.62 | 2024-05-02 | 24.99 | 1 | SO62487 | 2024-05-09 | 2.00 | 9.35 | |
SO62487_2 | 19 | 20096 | 463 | 6 | 2024-05-14 | 0.61 | 2024-05-02 | 24.49 | 2 | SO62487 | 2024-05-09 | 1.96 | 9.16 | |
SO62489_1 | 19 | 12203 | 478 | 6 | 2024-05-14 | 0.25 | 2024-05-02 | 9.99 | 1 | SO62489 | 2024-05-09 | 0.80 | 3.74 | |
SO62489_2 | 19 | 12203 | 477 | 6 | 2024-05-14 | 0.12 | 2024-05-02 | 4.99 | 2 | SO62489 | 2024-05-09 | 0.40 | 1.87 | |
SO62491_1 | 19 | 11500 | 476 | 6 | 2024-05-14 | 1.75 | 2024-05-02 | 69.99 | 1 | SO62491 | 2024-05-09 | 5.60 | 26.18 | |
SO62491_2 | 19 | 11500 | 467 | 2 | 6 | 2024-05-14 | 0.61 | 2024-05-02 | 24.49 | 2 | SO62491 | 2024-05-09 | 1.96 | 9.16 |
SO62493_1 | 19 | 22353 | 528 | 6 | 2024-05-14 | 0.12 | 2024-05-02 | 4.99 | 1 | SO62493 | 2024-05-09 | 0.40 | 1.87 | |
SO62493_2 | 19 | 22353 | 214 | 6 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 2 | SO62493 | 2024-05-09 | 2.80 | 13.09 | |
SO54612_1 | 19 | 11824 | 528 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 1 | SO54612 | 2024-01-06 | 0.40 | 1.87 | |
SO54612_2 | 19 | 11824 | 536 | 6 | 2024-01-11 | 0.75 | 2023-12-30 | 29.99 | 2 | SO54612 | 2024-01-06 | 2.40 | 11.22 | |
SO54612_3 | 19 | 11824 | 217 | 6 | 2024-01-11 | 0.87 | 2023-12-30 | 34.99 | 3 | SO54612 | 2024-01-06 | 2.80 | 13.09 | |
SO54614_1 | 19 | 19015 | 528 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 1 | SO54614 | 2024-01-06 | 0.40 | 1.87 | |
SO54614_2 | 19 | 19015 | 536 | 6 | 2024-01-11 | 0.75 | 2023-12-30 | 29.99 | 2 | SO54614 | 2024-01-06 | 2.40 | 11.22 | |
SO54614_3 | 19 | 19015 | 222 | 6 | 2024-01-11 | 0.87 | 2023-12-30 | 34.99 | 3 | SO54614 | 2024-01-06 | 2.80 | 13.09 | |
SO54614_4 | 19 | 19015 | 463 | 6 | 2024-01-11 | 0.61 | 2023-12-30 | 24.49 | 4 | SO54614 | 2024-01-06 | 1.96 | 9.16 | |
SO54617_1 | 19 | 14502 | 477 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 1 | SO54617 | 2024-01-06 | 0.40 | 1.87 | |
SO54617_2 | 19 | 14502 | 478 | 6 | 2024-01-11 | 0.25 | 2023-12-30 | 9.99 | 2 | SO54617 | 2024-01-06 | 0.80 | 3.74 | |
SO54618_1 | 19 | 14725 | 478 | 6 | 2024-01-11 | 0.25 | 2023-12-30 | 9.99 | 1 | SO54618 | 2024-01-06 | 0.80 | 3.74 | |
SO54618_2 | 19 | 14725 | 477 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 2 | SO54618 | 2024-01-06 | 0.40 | 1.87 | |
SO54618_3 | 19 | 14725 | 487 | 6 | 2024-01-11 | 1.37 | 2023-12-30 | 54.99 | 3 | SO54618 | 2024-01-06 | 4.40 | 20.57 | |
SO54623_1 | 19 | 23798 | 477 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 1 | SO54623 | 2024-01-06 | 0.40 | 1.87 | |
SO54623_2 | 19 | 23798 | 487 | 6 | 2024-01-11 | 1.37 | 2023-12-30 | 54.99 | 2 | SO54623 | 2024-01-06 | 4.40 | 20.57 | |
SO54623_3 | 19 | 23798 | 484 | 6 | 2024-01-11 | 0.20 | 2023-12-30 | 7.95 | 3 | SO54623 | 2024-01-06 | 0.64 | 2.97 | |
SO54626_1 | 19 | 27300 | 528 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 1 | SO54626 | 2024-01-06 | 0.40 | 1.87 | |
SO54626_2 | 19 | 27300 | 480 | 2 | 6 | 2024-01-11 | 0.06 | 2023-12-30 | 2.29 | 2 | SO54626 | 2024-01-06 | 0.18 | 0.86 |
SO54627_1 | 19 | 18919 | 485 | 6 | 2024-01-11 | 0.55 | 2023-12-30 | 21.98 | 1 | SO54627 | 2024-01-06 | 1.76 | 8.22 | |
SO54627_2 | 19 | 18919 | 217 | 6 | 2024-01-11 | 0.87 | 2023-12-30 | 34.99 | 2 | SO54627 | 2024-01-06 | 2.80 | 13.09 | |
SO54627_3 | 19 | 18919 | 234 | 6 | 2024-01-11 | 1.25 | 2023-12-30 | 49.99 | 3 | SO54627 | 2024-01-06 | 4.00 | 38.49 | |
SO54629_1 | 19 | 20086 | 485 | 6 | 2024-01-11 | 0.55 | 2023-12-30 | 21.98 | 1 | SO54629 | 2024-01-06 | 1.76 | 8.22 | |
SO54629_2 | 19 | 20086 | 217 | 6 | 2024-01-11 | 0.87 | 2023-12-30 | 34.99 | 2 | SO54629 | 2024-01-06 | 2.80 | 13.09 | |
SO54636_1 | 19 | 11845 | 528 | 6 | 2024-01-11 | 0.12 | 2023-12-30 | 4.99 | 1 | SO54636 | 2024-01-06 | 0.40 | 1.87 | |
SO54636_2 | 19 | 11845 | 537 | 6 | 2024-01-11 | 0.88 | 2023-12-30 | 35.00 | 2 | SO54636 | 2024-01-06 | 2.80 | 13.09 | |
SO54636_3 | 19 | 11845 | 480 | 6 | 2024-01-11 | 0.06 | 2023-12-30 | 2.29 | 3 | SO54636 | 2024-01-06 | 0.18 | 0.86 | |
SO54640_1 | 19 | 12765 | 580 | 6 | 2024-01-11 | 42.52 | 2023-12-30 | 1700.99 | 1 | SO54640 | 2024-01-06 | 136.08 | 1082.51 | |
SO54640_2 | 19 | 12765 | 228 | 6 | 2024-01-11 | 1.25 | 2023-12-30 | 49.99 | 2 | SO54640 | 2024-01-06 | 4.00 | 38.49 | |
SO54648_1 | 19 | 11888 | 355 | 6 | 2024-01-11 | 58.00 | 2023-12-30 | 2319.99 | 1 | SO54648 | 2024-01-06 | 185.60 | 1265.62 | |
SO54648_2 | 19 | 11888 | 485 | 6 | 2024-01-11 | 0.55 | 2023-12-30 | 21.98 | 2 | SO54648 | 2024-01-06 | 1.76 | 8.22 | |
SO54648_3 | 19 | 11888 | 214 | 6 | 2024-01-11 | 0.87 | 2023-12-30 | 34.99 | 3 | SO54648 | 2024-01-06 | 2.80 | 13.09 | |
SO54655_1 | 19 | 13148 | 388 | 6 | 2024-01-11 | 28.01 | 2023-12-30 | 1120.49 | 1 | SO54655 | 2024-01-06 | 89.64 | 713.08 | |
SO54655_2 | 19 | 13148 | 479 | 6 | 2024-01-11 | 0.22 | 2023-12-30 | 8.99 | 2 | SO54655 | 2024-01-06 | 0.72 | 3.36 | |
SO54655_3 | 19 | 13148 | 484 | 6 | 2024-01-11 | 0.20 | 2023-12-30 | 7.95 | 3 | SO54655 | 2024-01-06 | 0.64 | 2.97 | |
SO54661_1 | 19 | 11176 | 479 | 6 | 2024-01-12 | 0.22 | 2023-12-31 | 8.99 | 1 | SO54661 | 2024-01-07 | 0.72 | 3.36 | |
SO54661_2 | 19 | 11176 | 477 | 6 | 2024-01-12 | 0.12 | 2023-12-31 | 4.99 | 2 | SO54661 | 2024-01-07 | 0.40 | 1.87 | |
SO54662_1 | 19 | 11300 | 484 | 6 | 2024-01-12 | 0.20 | 2023-12-31 | 7.95 | 1 | SO54662 | 2024-01-07 | 0.64 | 2.97 | |
SO54674_1 | 19 | 11211 | 489 | 6 | 2024-01-12 | 1.35 | 2023-12-31 | 53.99 | 1 | SO54674 | 2024-01-07 | 4.32 | 41.57 | |
SO54675_1 | 19 | 11520 | 234 | 6 | 2024-01-12 | 1.25 | 2023-12-31 | 49.99 | 1 | SO54675 | 2024-01-07 | 4.00 | 38.49 | |
SO54675_2 | 19 | 11520 | 467 | 6 | 2024-01-12 | 0.61 | 2023-12-31 | 24.49 | 2 | SO54675 | 2024-01-07 | 1.96 | 9.16 | |
SO54678_1 | 19 | 12928 | 541 | 6 | 2024-01-12 | 0.72 | 2023-12-31 | 28.99 | 1 | SO54678 | 2024-01-07 | 2.32 | 10.84 | |
SO54678_2 | 19 | 12928 | 530 | 6 | 2024-01-12 | 0.12 | 2023-12-31 | 4.99 | 2 | SO54678 | 2024-01-07 | 0.40 | 1.87 | |
SO54682_1 | 19 | 18391 | 225 | 6 | 2024-01-12 | 0.22 | 2023-12-31 | 8.99 | 1 | SO54682 | 2024-01-07 | 0.72 | 6.92 | |
SO54682_2 | 19 | 18391 | 475 | 6 | 2024-01-12 | 1.75 | 2023-12-31 | 69.99 | 2 | SO54682 | 2024-01-07 | 5.60 | 26.18 | |
SO54683_1 | 19 | 25265 | 477 | 6 | 2024-01-12 | 0.12 | 2023-12-31 | 4.99 | 1 | SO54683 | 2024-01-07 | 0.40 | 1.87 | |
SO54683_2 | 19 | 25265 | 237 | 6 | 2024-01-12 | 1.25 | 2023-12-31 | 49.99 | 2 | SO54683 | 2024-01-07 | 4.00 | 38.49 | |
SO54695_1 | 19 | 15478 | 537 | 6 | 2024-01-12 | 0.88 | 2023-12-31 | 35.00 | 1 | SO54695 | 2024-01-07 | 2.80 | 13.09 | |
SO54695_2 | 19 | 15478 | 528 | 6 | 2024-01-12 | 0.12 | 2023-12-31 | 4.99 | 2 | SO54695 | 2024-01-07 | 0.40 | 1.87 | |
SO54695_3 | 19 | 15478 | 214 | 6 | 2024-01-12 | 0.87 | 2023-12-31 | 34.99 | 3 | SO54695 | 2024-01-07 | 2.80 | 13.09 | |
SO54695_4 | 19 | 15478 | 490 | 6 | 2024-01-12 | 1.35 | 2023-12-31 | 53.99 | 4 | SO54695 | 2024-01-07 | 4.32 | 41.57 | |
SO54701_1 | 19 | 16363 | 376 | 6 | 2024-01-12 | 61.08 | 2023-12-31 | 2443.35 | 1 | SO54701 | 2024-01-07 | 195.47 | 1554.95 | |
SO54701_2 | 19 | 16363 | 479 | 6 | 2024-01-12 | 0.22 | 2023-12-31 | 8.99 | 2 | SO54701 | 2024-01-07 | 0.72 | 3.36 | |
SO54701_3 | 19 | 16363 | 477 | 6 | 2024-01-12 | 0.12 | 2023-12-31 | 4.99 | 3 | SO54701 | 2024-01-07 | 0.40 | 1.87 | |
SO54701_4 | 19 | 16363 | 465 | 6 | 2024-01-12 | 0.61 | 2023-12-31 | 24.49 | 4 | SO54701 | 2024-01-07 | 1.96 | 9.16 | |
SO54702_1 | 19 | 14107 | 587 | 6 | 2024-01-12 | 19.24 | 2023-12-31 | 769.49 | 1 | SO54702 | 2024-01-07 | 61.56 | 419.78 |
Generated 2024-11-10 08:11:07.192 UTC