[ROOT] dt FactInternetSale < WHERE DimProductId EQ ALL < SKIP 2250 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45739_1 | 6 | 11903 | 348 | 9 | 2022-06-11 | 84.37 | 2022-05-30 | 3374.99 | 1 | SO45739 | 2022-06-06 | 270.00 | 1898.09 | |
SO55796_1 | 6 | 16707 | 588 | 9 | 2023-12-26 | 19.24 | 2023-12-14 | 769.49 | 1 | SO55796 | 2023-12-21 | 61.56 | 419.78 | |
SO45740_1 | 6 | 19786 | 314 | 9 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45740 | 2022-06-07 | 286.26 | 2171.29 | |
SO55796_2 | 6 | 16707 | 536 | 9 | 2023-12-26 | 0.75 | 2023-12-14 | 29.99 | 2 | SO55796 | 2023-12-21 | 2.40 | 11.22 | |
SO45741_1 | 6 | 19788 | 314 | 9 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45741 | 2022-06-07 | 286.26 | 2171.29 | |
SO55797_1 | 6 | 14304 | 587 | 9 | 2023-12-26 | 19.24 | 2023-12-14 | 769.49 | 1 | SO55797 | 2023-12-21 | 61.56 | 419.78 | |
SO45742_1 | 6 | 19620 | 312 | 9 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45742 | 2022-06-07 | 286.26 | 2171.29 | |
SO55798_1 | 6 | 20997 | 606 | 9 | 2023-12-26 | 13.50 | 2023-12-14 | 539.99 | 1 | SO55798 | 2023-12-21 | 43.20 | 343.65 | |
SO45743_1 | 6 | 19631 | 313 | 9 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45743 | 2022-06-07 | 286.26 | 2171.29 | |
SO55798_2 | 6 | 20997 | 477 | 9 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 2 | SO55798 | 2023-12-21 | 0.40 | 1.87 | |
SO55798_3 | 6 | 20997 | 479 | 9 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 3 | SO55798 | 2023-12-21 | 0.72 | 3.36 | |
SO55798_4 | 6 | 20997 | 225 | 9 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 4 | SO55798 | 2023-12-21 | 0.72 | 6.92 | |
SO55799_1 | 6 | 29195 | 573 | 9 | 2023-12-26 | 59.60 | 2023-12-14 | 2384.07 | 1 | SO55799 | 2023-12-21 | 190.73 | 1481.94 | |
SO55799_2 | 6 | 29195 | 217 | 9 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 2 | SO55799 | 2023-12-21 | 2.80 | 13.09 | |
SO55800_1 | 6 | 19559 | 376 | 9 | 2023-12-26 | 61.08 | 2023-12-14 | 2443.35 | 1 | SO55800 | 2023-12-21 | 195.47 | 1554.95 | |
SO55800_2 | 6 | 19559 | 214 | 9 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 2 | SO55800 | 2023-12-21 | 2.80 | 13.09 | |
SO55801_1 | 6 | 19084 | 376 | 9 | 2023-12-26 | 61.08 | 2023-12-14 | 2443.35 | 1 | SO55801 | 2023-12-21 | 195.47 | 1554.95 | |
SO55801_2 | 6 | 19084 | 529 | 9 | 2023-12-26 | 0.10 | 2023-12-14 | 3.99 | 2 | SO55801 | 2023-12-21 | 0.32 | 1.49 | |
SO55801_3 | 6 | 19084 | 540 | 9 | 2023-12-26 | 0.82 | 2023-12-14 | 32.60 | 3 | SO55801 | 2023-12-21 | 2.61 | 12.19 | |
SO55801_4 | 6 | 19084 | 214 | 9 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 4 | SO55801 | 2023-12-21 | 2.80 | 13.09 | |
SO55802_1 | 6 | 15832 | 600 | 9 | 2023-12-26 | 13.50 | 2023-12-14 | 539.99 | 1 | SO55802 | 2023-12-21 | 43.20 | 294.58 | |
SO55803_1 | 100 | 24347 | 573 | 4 | 2023-12-26 | 59.60 | 2023-12-14 | 2384.07 | 1 | SO55803 | 2023-12-21 | 190.73 | 1481.94 | |
SO55803_2 | 100 | 24347 | 214 | 4 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 2 | SO55803 | 2023-12-21 | 2.80 | 13.09 | |
SO55804_1 | 100 | 24351 | 564 | 4 | 2023-12-26 | 59.60 | 2023-12-14 | 2384.07 | 1 | SO55804 | 2023-12-21 | 190.73 | 1481.94 | |
SO55804_2 | 100 | 24351 | 225 | 4 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 2 | SO55804 | 2023-12-21 | 0.72 | 6.92 | |
SO55805_1 | 100 | 22043 | 606 | 4 | 2023-12-26 | 13.50 | 2023-12-14 | 539.99 | 1 | SO55805 | 2023-12-21 | 43.20 | 343.65 | |
SO55805_2 | 100 | 22043 | 479 | 4 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 2 | SO55805 | 2023-12-21 | 0.72 | 3.36 | |
SO68695_2 | 19 | 11784 | 528 | 6 | 2024-07-09 | 0.12 | 2024-06-27 | 4.99 | 2 | SO68695 | 2024-07-04 | 0.40 | 1.87 | |
SO55805_3 | 100 | 22043 | 477 | 4 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 3 | SO55805 | 2023-12-21 | 0.40 | 1.87 | |
SO68695_3 | 19 | 11784 | 480 | 2 | 6 | 2024-07-09 | 0.06 | 2024-06-27 | 2.29 | 3 | SO68695 | 2024-07-04 | 0.18 | 0.86 |
SO55805_4 | 100 | 22043 | 214 | 4 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 4 | SO55805 | 2023-12-21 | 2.80 | 13.09 | |
SO68696_1 | 19 | 14363 | 540 | 6 | 2024-07-09 | 0.82 | 2024-06-27 | 32.60 | 1 | SO68696 | 2024-07-04 | 2.61 | 12.19 | |
SO55806_1 | 19 | 18641 | 386 | 6 | 2023-12-26 | 28.01 | 2023-12-14 | 1120.49 | 1 | SO55806 | 2023-12-21 | 89.64 | 713.08 | |
SO68696_2 | 19 | 14363 | 529 | 6 | 2024-07-09 | 0.10 | 2024-06-27 | 3.99 | 2 | SO68696 | 2024-07-04 | 0.32 | 1.49 | |
SO55807_1 | 100 | 19993 | 382 | 1 | 2023-12-26 | 28.01 | 2023-12-14 | 1120.49 | 1 | SO55807 | 2023-12-21 | 89.64 | 713.08 | |
SO68696_3 | 19 | 14363 | 480 | 6 | 2024-07-09 | 0.06 | 2024-06-27 | 2.29 | 3 | SO68696 | 2024-07-04 | 0.18 | 0.86 | |
SO55807_2 | 100 | 19993 | 479 | 1 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 2 | SO55807 | 2023-12-21 | 0.72 | 3.36 | |
SO68697_1 | 100 | 23335 | 536 | 1 | 2024-07-09 | 0.75 | 2024-06-27 | 29.99 | 1 | SO68697 | 2024-07-04 | 2.40 | 11.22 | |
SO55807_3 | 100 | 19993 | 477 | 1 | 2023-12-26 | 0.12 | 2023-12-14 | 4.99 | 3 | SO55807 | 2023-12-21 | 0.40 | 1.87 | |
SO68697_2 | 100 | 23335 | 480 | 2 | 1 | 2024-07-09 | 0.06 | 2024-06-27 | 2.29 | 2 | SO68697 | 2024-07-04 | 0.18 | 0.86 |
SO55807_4 | 100 | 19993 | 237 | 1 | 2023-12-26 | 1.25 | 2023-12-14 | 49.99 | 4 | SO55807 | 2023-12-21 | 4.00 | 38.49 | |
SO68698_1 | 100 | 23741 | 540 | 1 | 2024-07-09 | 0.82 | 2024-06-27 | 32.60 | 1 | SO68698 | 2024-07-04 | 2.61 | 12.19 | |
SO55808_1 | 98 | 23232 | 386 | 10 | 2023-12-26 | 28.01 | 2023-12-14 | 1120.49 | 1 | SO55808 | 2023-12-21 | 89.64 | 713.08 | |
SO68699_1 | 100 | 21687 | 478 | 4 | 2024-07-09 | 0.25 | 2024-06-27 | 9.99 | 1 | SO68699 | 2024-07-04 | 0.80 | 3.74 | |
SO55809_1 | 98 | 23752 | 390 | 10 | 2023-12-26 | 28.01 | 2023-12-14 | 1120.49 | 1 | SO55809 | 2023-12-21 | 89.64 | 713.08 | |
SO68699_2 | 100 | 21687 | 477 | 4 | 2024-07-09 | 0.12 | 2024-06-27 | 4.99 | 2 | SO68699 | 2024-07-04 | 0.40 | 1.87 | |
SO45744_1 | 6 | 11894 | 351 | 9 | 2022-06-12 | 84.37 | 2022-05-31 | 3374.99 | 1 | SO45744 | 2022-06-07 | 270.00 | 1898.09 | |
SO55809_2 | 98 | 23752 | 225 | 10 | 2023-12-26 | 0.22 | 2023-12-14 | 8.99 | 2 | SO55809 | 2023-12-21 | 0.72 | 6.92 | |
SO68699_3 | 100 | 21687 | 225 | 4 | 2024-07-09 | 0.22 | 2024-06-27 | 8.99 | 3 | SO68699 | 2024-07-04 | 0.72 | 6.92 | |
SO45745_1 | 98 | 15089 | 312 | 10 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45745 | 2022-06-08 | 286.26 | 2171.29 | |
SO55809_3 | 98 | 23752 | 217 | 10 | 2023-12-26 | 0.87 | 2023-12-14 | 34.99 | 3 | SO55809 | 2023-12-21 | 2.80 | 13.09 | |
SO68700_1 | 19 | 12936 | 476 | 6 | 2024-07-09 | 1.75 | 2024-06-27 | 69.99 | 1 | SO68700 | 2024-07-04 | 5.60 | 26.18 | |
SO45746_1 | 19 | 23376 | 312 | 6 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45746 | 2022-06-08 | 286.26 | 2171.29 | |
SO55810_1 | 98 | 25757 | 605 | 10 | 2023-12-26 | 13.50 | 2023-12-14 | 539.99 | 1 | SO55810 | 2023-12-21 | 43.20 | 343.65 | |
SO68700_2 | 19 | 12936 | 488 | 6 | 2024-07-09 | 1.35 | 2024-06-27 | 53.99 | 2 | SO68700 | 2024-07-04 | 4.32 | 41.57 | |
SO45747_1 | 100 | 11539 | 314 | 4 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45747 | 2022-06-08 | 286.26 | 2171.29 | |
SO55810_2 | 98 | 25757 | 538 | 10 | 2023-12-26 | 0.54 | 2023-12-14 | 21.49 | 2 | SO55810 | 2023-12-21 | 1.72 | 8.04 | |
SO68701_1 | 100 | 22350 | 477 | 1 | 2024-07-09 | 0.12 | 2024-06-27 | 4.99 | 1 | SO68701 | 2024-07-04 | 0.40 | 1.87 | |
SO45748_1 | 100 | 18046 | 332 | 7 | 2022-06-13 | 17.48 | 2022-06-01 | 699.10 | 1 | SO45748 | 2022-06-08 | 55.93 | 413.15 | |
SO55810_3 | 98 | 25757 | 529 | 10 | 2023-12-26 | 0.10 | 2023-12-14 | 3.99 | 3 | SO55810 | 2023-12-21 | 0.32 | 1.49 | |
SO68701_2 | 100 | 22350 | 478 | 1 | 2024-07-09 | 0.25 | 2024-06-27 | 9.99 | 2 | SO68701 | 2024-07-04 | 0.80 | 3.74 | |
SO45749_1 | 100 | 14797 | 311 | 8 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45749 | 2022-06-08 | 286.26 | 2171.29 |
Generated 2024-10-06 15:55:11.856 UTC