[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1601 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55871_3 | 6 | 15261 | 465 | 9 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 3 | SO55871 | 2023-12-07 | 1.96 | 9.16 | |
SO44833_1 | 100 | 28842 | 310 | 4 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44833 | 2022-02-01 | 286.26 | 2171.29 | |
SO55872_1 | 6 | 24375 | 538 | 9 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO55872 | 2023-12-07 | 1.72 | 8.04 | |
SO44834_1 | 100 | 25952 | 350 | 4 | 2022-02-06 | 84.37 | 2022-01-25 | 3374.99 | 1 | SO44834 | 2022-02-01 | 270.00 | 1898.09 | |
SO55872_2 | 6 | 24375 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO55872 | 2023-12-07 | 0.18 | 0.86 | |
SO44835_1 | 6 | 18338 | 311 | 9 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44835 | 2022-02-01 | 286.26 | 2171.29 | |
SO55872_3 | 6 | 24375 | 484 | 9 | 2023-12-12 | 0.20 | 2023-11-30 | 7.95 | 3 | SO55872 | 2023-12-07 | 0.64 | 2.97 | |
SO44836_1 | 6 | 18465 | 314 | 9 | 2022-02-06 | 89.46 | 2022-01-25 | 3578.27 | 1 | SO44836 | 2022-02-01 | 286.26 | 2171.29 | |
SO55873_1 | 6 | 29116 | 478 | 9 | 2023-12-12 | 0.25 | 2023-11-30 | 9.99 | 1 | SO55873 | 2023-12-07 | 0.80 | 3.74 | |
SO44837_1 | 29 | 13808 | 312 | 8 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44837 | 2022-02-02 | 286.26 | 2171.29 | |
SO55873_2 | 6 | 29116 | 477 | 9 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 2 | SO55873 | 2023-12-07 | 0.40 | 1.87 | |
SO44838_1 | 29 | 14138 | 311 | 8 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44838 | 2022-02-02 | 286.26 | 2171.29 | |
SO55873_3 | 6 | 29116 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 3 | SO55873 | 2023-12-07 | 0.18 | 0.86 | |
SO44839_1 | 100 | 28825 | 314 | 1 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44839 | 2022-02-02 | 286.26 | 2171.29 | |
SO55874_1 | 6 | 16615 | 540 | 9 | 2023-12-12 | 0.82 | 2023-11-30 | 32.60 | 1 | SO55874 | 2023-12-07 | 2.61 | 12.19 | |
SO44840_1 | 100 | 28857 | 314 | 4 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44840 | 2022-02-02 | 286.26 | 2171.29 | |
SO55874_2 | 6 | 16615 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 2 | SO55874 | 2023-12-07 | 0.32 | 1.49 | |
SO44841_1 | 6 | 18335 | 314 | 9 | 2022-02-07 | 89.46 | 2022-01-26 | 3578.27 | 1 | SO44841 | 2022-02-02 | 286.26 | 2171.29 | |
SO55874_3 | 6 | 16615 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 3 | SO55874 | 2023-12-07 | 0.18 | 0.86 | |
SO44842_1 | 29 | 14140 | 310 | 8 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44842 | 2022-02-03 | 286.26 | 2171.29 | |
SO55875_1 | 6 | 18271 | 225 | 9 | 2023-12-12 | 0.22 | 2023-11-30 | 8.99 | 1 | SO55875 | 2023-12-07 | 0.72 | 6.92 | |
SO44843_1 | 100 | 29058 | 312 | 4 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44843 | 2022-02-03 | 286.26 | 2171.29 | |
SO55876_1 | 6 | 14683 | 487 | 9 | 2023-12-12 | 1.37 | 2023-11-30 | 54.99 | 1 | SO55876 | 2023-12-07 | 4.40 | 20.57 | |
SO44844_1 | 100 | 29139 | 314 | 4 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44844 | 2022-02-03 | 286.26 | 2171.29 | |
SO55877_1 | 19 | 11619 | 488 | 6 | 2023-12-12 | 1.35 | 2023-11-30 | 53.99 | 1 | SO55877 | 2023-12-07 | 4.32 | 41.57 | |
SO44845_1 | 100 | 28845 | 313 | 1 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44845 | 2022-02-03 | 286.26 | 2171.29 | |
SO55877_2 | 19 | 11619 | 465 | 6 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 2 | SO55877 | 2023-12-07 | 1.96 | 9.16 | |
SO44846_1 | 6 | 18334 | 314 | 9 | 2022-02-08 | 89.46 | 2022-01-27 | 3578.27 | 1 | SO44846 | 2022-02-03 | 286.26 | 2171.29 | |
SO55878_1 | 100 | 11622 | 480 | 1 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 1 | SO55878 | 2023-12-07 | 0.18 | 0.86 | |
SO44847_1 | 6 | 11445 | 346 | 9 | 2022-02-08 | 85.00 | 2022-01-27 | 3399.99 | 1 | SO44847 | 2022-02-03 | 272.00 | 1912.15 | |
SO55879_1 | 6 | 11749 | 535 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 1 | SO55879 | 2023-12-07 | 2.00 | 9.35 | |
SO44848_1 | 39 | 28418 | 348 | 7 | 2022-02-09 | 84.37 | 2022-01-28 | 3374.99 | 1 | SO44848 | 2022-02-04 | 270.00 | 1898.09 | |
SO55880_1 | 19 | 11277 | 529 | 6 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 1 | SO55880 | 2023-12-07 | 0.32 | 1.49 | |
SO44849_1 | 39 | 17996 | 322 | 7 | 2022-02-09 | 17.48 | 2022-01-28 | 699.10 | 1 | SO44849 | 2022-02-04 | 55.93 | 413.15 | |
SO55880_2 | 19 | 11277 | 222 | 6 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 2 | SO55880 | 2023-12-07 | 2.80 | 13.09 | |
SO44850_1 | 29 | 19417 | 336 | 8 | 2022-02-09 | 17.48 | 2022-01-28 | 699.10 | 1 | SO44850 | 2022-02-04 | 55.93 | 413.15 | |
SO55881_1 | 100 | 28028 | 530 | 1 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 1 | SO55881 | 2023-12-07 | 0.40 | 1.87 | |
SO44851_1 | 19 | 22299 | 310 | 6 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44851 | 2022-02-04 | 286.26 | 2171.29 | |
SO55881_2 | 100 | 28028 | 217 | 1 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 2 | SO55881 | 2023-12-07 | 2.80 | 13.09 | |
SO44852_1 | 100 | 29128 | 311 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44852 | 2022-02-04 | 286.26 | 2171.29 | |
SO55881_3 | 100 | 28028 | 463 | 1 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 3 | SO55881 | 2023-12-07 | 1.96 | 9.16 | |
SO44853_1 | 19 | 19874 | 348 | 6 | 2022-02-09 | 84.37 | 2022-01-28 | 3374.99 | 1 | SO44853 | 2022-02-04 | 270.00 | 1898.09 | |
SO55882_1 | 100 | 28086 | 530 | 4 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 1 | SO55882 | 2023-12-07 | 0.40 | 1.87 | |
SO44854_1 | 100 | 29004 | 311 | 4 | 2022-02-09 | 89.46 | 2022-01-28 | 3578.27 | 1 | SO44854 | 2022-02-04 | 286.26 | 2171.29 | |
SO55882_2 | 100 | 28086 | 480 | 2 | 4 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO55882 | 2023-12-07 | 0.18 | 0.86 |
SO44855_1 | 19 | 26692 | 320 | 6 | 2022-02-09 | 17.48 | 2022-01-28 | 699.10 | 1 | SO44855 | 2022-02-04 | 55.93 | 413.15 | |
SO55882_3 | 100 | 28086 | 486 | 4 | 2023-12-12 | 3.98 | 2023-11-30 | 159.00 | 3 | SO55882 | 2023-12-07 | 12.72 | 59.47 | |
SO44856_1 | 100 | 14651 | 328 | 1 | 2022-02-09 | 17.48 | 2022-01-28 | 699.10 | 1 | SO44856 | 2022-02-04 | 55.93 | 413.15 | |
SO55883_1 | 19 | 16721 | 538 | 6 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO55883 | 2023-12-07 | 1.72 | 8.04 | |
SO55883_2 | 19 | 16721 | 480 | 6 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO55883 | 2023-12-07 | 0.18 | 0.86 | |
SO55884_1 | 100 | 25959 | 535 | 4 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 1 | SO55884 | 2023-12-07 | 2.00 | 9.35 | |
SO55884_2 | 100 | 25959 | 480 | 4 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 2 | SO55884 | 2023-12-07 | 0.18 | 0.86 | |
SO55885_1 | 19 | 11519 | 538 | 6 | 2023-12-12 | 0.54 | 2023-11-30 | 21.49 | 1 | SO55885 | 2023-12-07 | 1.72 | 8.04 | |
SO55885_2 | 19 | 11519 | 529 | 6 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 2 | SO55885 | 2023-12-07 | 0.32 | 1.49 | |
SO55885_3 | 19 | 11519 | 214 | 6 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 3 | SO55885 | 2023-12-07 | 2.80 | 13.09 | |
SO55886_1 | 100 | 25848 | 535 | 4 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 1 | SO55886 | 2023-12-07 | 2.00 | 9.35 |
Generated 2024-09-20 09:55:13.701 UTC