[ROOT] dt FactInternetSale < WHERE DimProductId EQ ALL < SKIP 2 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43698_1 | 39 | 28389 | 346 | 7 | 2021-09-18 | 85.00 | 2021-09-06 | 3399.99 | 1 | SO43698 | 2021-09-13 | 272.00 | 1912.15 | |
SO55561_1 | 100 | 20045 | 598 | 7 | 2023-12-23 | 13.50 | 2023-12-11 | 539.99 | 1 | SO55561 | 2023-12-18 | 43.20 | 294.58 | |
SO43699_1 | 100 | 25863 | 346 | 1 | 2021-09-18 | 85.00 | 2021-09-06 | 3399.99 | 1 | SO43699 | 2021-09-13 | 272.00 | 1912.15 | |
SO55561_2 | 100 | 20045 | 485 | 7 | 2023-12-23 | 0.55 | 2023-12-11 | 21.98 | 2 | SO55561 | 2023-12-18 | 1.76 | 8.22 | |
SO43700_1 | 100 | 14501 | 336 | 4 | 2021-09-18 | 17.48 | 2021-09-06 | 699.10 | 1 | SO43700 | 2021-09-13 | 55.93 | 413.15 | |
SO55561_3 | 100 | 20045 | 214 | 7 | 2023-12-23 | 0.87 | 2023-12-11 | 34.99 | 3 | SO55561 | 2023-12-18 | 2.80 | 13.09 | |
SO43701_1 | 6 | 11003 | 346 | 9 | 2021-09-18 | 85.00 | 2021-09-06 | 3399.99 | 1 | SO43701 | 2021-09-13 | 272.00 | 1912.15 | |
SO55562_1 | 100 | 11828 | 490 | 1 | 2023-12-23 | 1.35 | 2023-12-11 | 53.99 | 1 | SO55562 | 2023-12-18 | 4.32 | 41.57 | |
SO43702_1 | 100 | 27645 | 311 | 4 | 2021-09-19 | 89.46 | 2021-09-07 | 3578.27 | 1 | SO43702 | 2021-09-14 | 286.26 | 2171.29 | |
SO55563_1 | 100 | 11187 | 529 | 1 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 1 | SO55563 | 2023-12-18 | 0.32 | 1.49 | |
SO43703_1 | 6 | 16624 | 310 | 9 | 2021-09-19 | 89.46 | 2021-09-07 | 3578.27 | 1 | SO43703 | 2021-09-14 | 286.26 | 2171.29 | |
SO55563_2 | 100 | 11187 | 471 | 1 | 2023-12-23 | 1.59 | 2023-12-11 | 63.50 | 2 | SO55563 | 2023-12-18 | 5.08 | 23.75 | |
SO43704_1 | 6 | 11005 | 351 | 9 | 2021-09-19 | 84.37 | 2021-09-07 | 3374.99 | 1 | SO43704 | 2021-09-14 | 270.00 | 1898.09 | |
SO55564_1 | 100 | 29324 | 529 | 1 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 1 | SO55564 | 2023-12-18 | 0.32 | 1.49 | |
SO43705_1 | 6 | 11011 | 344 | 9 | 2021-09-19 | 85.00 | 2021-09-07 | 3399.99 | 1 | SO43705 | 2021-09-14 | 272.00 | 1912.15 | |
SO55564_2 | 100 | 29324 | 222 | 1 | 2023-12-23 | 0.87 | 2023-12-11 | 34.99 | 2 | SO55564 | 2023-12-18 | 2.80 | 13.09 | |
SO43706_1 | 100 | 27621 | 312 | 4 | 2021-09-20 | 89.46 | 2021-09-08 | 3578.27 | 1 | SO43706 | 2021-09-15 | 286.26 | 2171.29 | |
SO55565_1 | 100 | 29251 | 529 | 4 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 1 | SO55565 | 2023-12-18 | 0.32 | 1.49 | |
SO43707_1 | 100 | 27616 | 312 | 4 | 2021-09-20 | 89.46 | 2021-09-08 | 3578.27 | 1 | SO43707 | 2021-09-15 | 286.26 | 2171.29 | |
SO55565_2 | 100 | 29251 | 225 | 4 | 2023-12-23 | 0.22 | 2023-12-11 | 8.99 | 2 | SO55565 | 2023-12-18 | 0.72 | 6.92 | |
SO43708_1 | 98 | 20042 | 330 | 10 | 2021-09-20 | 17.48 | 2021-09-08 | 699.10 | 1 | SO43708 | 2021-09-15 | 55.93 | 413.15 | |
SO55566_1 | 19 | 11802 | 529 | 6 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 1 | SO55566 | 2023-12-18 | 0.32 | 1.49 | |
SO43709_1 | 6 | 16351 | 313 | 9 | 2021-09-20 | 89.46 | 2021-09-08 | 3578.27 | 1 | SO43709 | 2021-09-15 | 286.26 | 2171.29 | |
SO55566_2 | 19 | 11802 | 538 | 6 | 2023-12-23 | 0.54 | 2023-12-11 | 21.49 | 2 | SO55566 | 2023-12-18 | 1.72 | 8.04 | |
SO43710_1 | 6 | 16517 | 314 | 9 | 2021-09-20 | 89.46 | 2021-09-08 | 3578.27 | 1 | SO43710 | 2021-09-15 | 286.26 | 2171.29 | |
SO55566_3 | 19 | 11802 | 480 | 6 | 2023-12-23 | 0.06 | 2023-12-11 | 2.29 | 3 | SO55566 | 2023-12-18 | 0.18 | 0.86 | |
SO43711_1 | 100 | 27606 | 314 | 1 | 2021-09-21 | 89.46 | 2021-09-09 | 3578.27 | 1 | SO43711 | 2021-09-16 | 286.26 | 2171.29 | |
SO55567_1 | 100 | 27658 | 538 | 1 | 2023-12-23 | 0.54 | 2023-12-11 | 21.49 | 1 | SO55567 | 2023-12-18 | 1.72 | 8.04 | |
SO43712_1 | 29 | 13513 | 311 | 8 | 2021-09-21 | 89.46 | 2021-09-09 | 3578.27 | 1 | SO43712 | 2021-09-16 | 286.26 | 2171.29 | |
SO55567_2 | 100 | 27658 | 529 | 1 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 2 | SO55567 | 2023-12-18 | 0.32 | 1.49 | |
SO43713_1 | 100 | 27601 | 310 | 4 | 2021-09-22 | 89.46 | 2021-09-10 | 3578.27 | 1 | SO43713 | 2021-09-17 | 286.26 | 2171.29 | |
SO55567_3 | 100 | 27658 | 480 | 1 | 2023-12-23 | 0.06 | 2023-12-11 | 2.29 | 3 | SO55567 | 2023-12-18 | 0.18 | 0.86 | |
SO43714_1 | 98 | 13591 | 311 | 10 | 2021-09-22 | 89.46 | 2021-09-10 | 3578.27 | 1 | SO43714 | 2021-09-17 | 286.26 | 2171.29 | |
SO55568_1 | 19 | 21238 | 535 | 6 | 2023-12-23 | 0.62 | 2023-12-11 | 24.99 | 1 | SO55568 | 2023-12-18 | 2.00 | 9.35 | |
SO43715_1 | 6 | 16483 | 314 | 9 | 2021-09-22 | 89.46 | 2021-09-10 | 3578.27 | 1 | SO43715 | 2021-09-17 | 286.26 | 2171.29 | |
SO55568_2 | 19 | 21238 | 528 | 6 | 2023-12-23 | 0.12 | 2023-12-11 | 4.99 | 2 | SO55568 | 2023-12-18 | 0.40 | 1.87 | |
SO43716_1 | 6 | 16529 | 311 | 9 | 2021-09-22 | 89.46 | 2021-09-10 | 3578.27 | 1 | SO43716 | 2021-09-17 | 286.26 | 2171.29 | |
SO55568_3 | 19 | 21238 | 480 | 2 | 6 | 2023-12-23 | 0.06 | 2023-12-11 | 2.29 | 3 | SO55568 | 2023-12-18 | 0.18 | 0.86 |
SO43717_1 | 6 | 25249 | 336 | 9 | 2021-09-22 | 17.48 | 2021-09-10 | 699.10 | 1 | SO43717 | 2021-09-17 | 55.93 | 413.15 | |
SO55569_1 | 19 | 17387 | 528 | 6 | 2023-12-23 | 0.12 | 2023-12-11 | 4.99 | 1 | SO55569 | 2023-12-18 | 0.40 | 1.87 | |
SO43718_1 | 100 | 27668 | 311 | 1 | 2021-09-23 | 89.46 | 2021-09-11 | 3578.27 | 1 | SO43718 | 2021-09-18 | 286.26 | 2171.29 | |
SO55569_2 | 19 | 17387 | 535 | 6 | 2023-12-23 | 0.62 | 2023-12-11 | 24.99 | 2 | SO55569 | 2023-12-18 | 2.00 | 9.35 | |
SO43719_1 | 100 | 27612 | 312 | 4 | 2021-09-23 | 89.46 | 2021-09-11 | 3578.27 | 1 | SO43719 | 2021-09-18 | 286.26 | 2171.29 | |
SO55569_3 | 19 | 17387 | 478 | 6 | 2023-12-23 | 0.25 | 2023-12-11 | 9.99 | 3 | SO55569 | 2023-12-18 | 0.80 | 3.74 | |
SO43720_1 | 29 | 13264 | 311 | 8 | 2021-09-23 | 89.46 | 2021-09-11 | 3578.27 | 1 | SO43720 | 2021-09-18 | 286.26 | 2171.29 | |
SO55569_4 | 19 | 17387 | 225 | 6 | 2023-12-23 | 0.22 | 2023-12-11 | 8.99 | 4 | SO55569 | 2023-12-18 | 0.72 | 6.92 | |
SO43721_1 | 98 | 13590 | 310 | 10 | 2021-09-23 | 89.46 | 2021-09-11 | 3578.27 | 1 | SO43721 | 2021-09-18 | 286.26 | 2171.29 | |
SO55569_5 | 19 | 17387 | 477 | 6 | 2023-12-23 | 0.12 | 2023-12-11 | 4.99 | 5 | SO55569 | 2023-12-18 | 0.40 | 1.87 | |
SO43722_1 | 98 | 13581 | 312 | 10 | 2021-09-24 | 89.46 | 2021-09-12 | 3578.27 | 1 | SO43722 | 2021-09-19 | 286.26 | 2171.29 | |
SO55570_1 | 100 | 25372 | 540 | 4 | 2023-12-23 | 0.82 | 2023-12-11 | 32.60 | 1 | SO55570 | 2023-12-18 | 2.61 | 12.19 | |
SO43723_1 | 100 | 14520 | 332 | 1 | 2021-09-24 | 17.48 | 2021-09-12 | 699.10 | 1 | SO43723 | 2021-09-19 | 55.93 | 413.15 | |
SO55571_1 | 19 | 11200 | 535 | 6 | 2023-12-23 | 0.62 | 2023-12-11 | 24.99 | 1 | SO55571 | 2023-12-18 | 2.00 | 9.35 | |
SO43724_1 | 6 | 16520 | 311 | 9 | 2021-09-24 | 89.46 | 2021-09-12 | 3578.27 | 1 | SO43724 | 2021-09-19 | 286.26 | 2171.29 | |
SO55571_2 | 19 | 11200 | 480 | 6 | 2023-12-23 | 0.06 | 2023-12-11 | 2.29 | 2 | SO55571 | 2023-12-18 | 0.18 | 0.86 | |
SO43725_1 | 29 | 13258 | 311 | 8 | 2021-09-25 | 89.46 | 2021-09-13 | 3578.27 | 1 | SO43725 | 2021-09-20 | 286.26 | 2171.29 | |
SO55572_1 | 19 | 11091 | 529 | 6 | 2023-12-23 | 0.10 | 2023-12-11 | 3.99 | 1 | SO55572 | 2023-12-18 | 0.32 | 1.49 | |
SO43726_1 | 100 | 14560 | 332 | 4 | 2021-09-25 | 17.48 | 2021-09-13 | 699.10 | 1 | SO43726 | 2021-09-20 | 55.93 | 413.15 | |
SO55572_2 | 19 | 11091 | 540 | 6 | 2023-12-23 | 0.82 | 2023-12-11 | 32.60 | 2 | SO55572 | 2023-12-18 | 2.61 | 12.19 | |
SO43727_1 | 6 | 16607 | 311 | 9 | 2021-09-25 | 89.46 | 2021-09-13 | 3578.27 | 1 | SO43727 | 2021-09-20 | 286.26 | 2171.29 | |
SO55572_3 | 19 | 11091 | 480 | 6 | 2023-12-23 | 0.06 | 2023-12-11 | 2.29 | 3 | SO55572 | 2023-12-18 | 0.18 | 0.86 | |
SO43728_1 | 100 | 27666 | 313 | 4 | 2021-09-26 | 89.46 | 2021-09-14 | 3578.27 | 1 | SO43728 | 2021-09-21 | 286.26 | 2171.29 | |
SO55573_1 | 100 | 23029 | 536 | 1 | 2023-12-23 | 0.75 | 2023-12-11 | 29.99 | 1 | SO55573 | 2023-12-18 | 2.40 | 11.22 |
Generated 2024-10-06 16:28:27.717 UTC