[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 1265 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59865_2 | 100 | 22681 | 530 | 7 | 2024-04-06 | 0.12 | 2024-03-25 | 4.99 | 2 | SO59865 | 2024-04-01 | 0.40 | 1.87 | |
SO59865_3 | 100 | 22681 | 217 | 7 | 2024-04-06 | 0.87 | 2024-03-25 | 34.99 | 3 | SO59865 | 2024-04-01 | 2.80 | 13.09 | |
SO59865_4 | 100 | 22681 | 491 | 7 | 2024-04-06 | 1.35 | 2024-03-25 | 53.99 | 4 | SO59865 | 2024-04-01 | 4.32 | 41.57 | |
SO59865_5 | 100 | 22681 | 225 | 7 | 2024-04-06 | 0.22 | 2024-03-25 | 8.99 | 5 | SO59865 | 2024-04-01 | 0.72 | 6.92 | |
SO59867_1 | 100 | 11566 | 541 | 7 | 2024-04-06 | 0.72 | 2024-03-25 | 28.99 | 1 | SO59867 | 2024-04-01 | 2.32 | 10.84 | |
SO59867_2 | 100 | 11566 | 530 | 7 | 2024-04-06 | 0.12 | 2024-03-25 | 4.99 | 2 | SO59867 | 2024-04-01 | 0.40 | 1.87 | |
SO59867_3 | 100 | 11566 | 480 | 2 | 7 | 2024-04-06 | 0.06 | 2024-03-25 | 2.29 | 3 | SO59867 | 2024-04-01 | 0.18 | 0.86 |
SO59945_1 | 100 | 20177 | 529 | 7 | 2024-04-07 | 0.10 | 2024-03-26 | 3.99 | 1 | SO59945 | 2024-04-02 | 0.32 | 1.49 | |
SO59945_2 | 100 | 20177 | 480 | 7 | 2024-04-07 | 0.06 | 2024-03-26 | 2.29 | 2 | SO59945 | 2024-04-02 | 0.18 | 0.86 | |
SO59947_1 | 100 | 17759 | 528 | 7 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 1 | SO59947 | 2024-04-02 | 0.40 | 1.87 | |
SO59947_2 | 100 | 17759 | 536 | 7 | 2024-04-07 | 0.75 | 2024-03-26 | 29.99 | 2 | SO59947 | 2024-04-02 | 2.40 | 11.22 | |
SO59947_3 | 100 | 17759 | 480 | 7 | 2024-04-07 | 0.06 | 2024-03-26 | 2.29 | 3 | SO59947 | 2024-04-02 | 0.18 | 0.86 | |
SO59958_1 | 100 | 26953 | 567 | 7 | 2024-04-07 | 18.56 | 2024-03-26 | 742.35 | 1 | SO59958 | 2024-04-02 | 59.39 | 461.44 | |
SO59958_2 | 100 | 26953 | 217 | 7 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 2 | SO59958 | 2024-04-02 | 2.80 | 13.09 | |
SO59958_3 | 100 | 26953 | 225 | 7 | 2024-04-07 | 0.22 | 2024-03-26 | 8.99 | 3 | SO59958 | 2024-04-02 | 0.72 | 6.92 | |
SO50798_1 | 100 | 17900 | 387 | 7 | 2023-09-28 | 25.01 | 2023-09-16 | 1000.44 | 1 | SO50798 | 2023-09-23 | 80.04 | 605.65 | |
SO59972_1 | 100 | 20044 | 386 | 7 | 2024-04-07 | 28.01 | 2024-03-26 | 1120.49 | 1 | SO59972 | 2024-04-02 | 89.64 | 713.08 | |
SO50800_1 | 100 | 11590 | 362 | 2 | 7 | 2023-09-28 | 51.23 | 2023-09-16 | 2049.10 | 1 | SO50800 | 2023-09-23 | 163.93 | 1105.81 |
SO59972_2 | 100 | 20044 | 217 | 7 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 2 | SO59972 | 2024-04-02 | 2.80 | 13.09 | |
SO50807_1 | 100 | 11433 | 360 | 7 | 2023-09-29 | 51.23 | 2023-09-17 | 2049.10 | 1 | SO50807 | 2023-09-24 | 163.93 | 1105.81 | |
SO59983_1 | 100 | 13605 | 363 | 2 | 7 | 2024-04-08 | 57.37 | 2024-03-27 | 2294.99 | 1 | SO59983 | 2024-04-03 | 183.60 | 1251.98 |
SO50808_1 | 100 | 11546 | 352 | 7 | 2023-09-29 | 51.79 | 2023-09-17 | 2071.42 | 1 | SO50808 | 2023-09-24 | 165.71 | 1117.86 | |
SO59984_1 | 100 | 11599 | 353 | 7 | 2024-04-08 | 58.00 | 2024-03-27 | 2319.99 | 1 | SO59984 | 2024-04-03 | 185.60 | 1265.62 | |
SO50816_1 | 100 | 17944 | 387 | 7 | 2023-09-30 | 25.01 | 2023-09-18 | 1000.44 | 1 | SO50816 | 2023-09-25 | 80.04 | 605.65 | |
SO59984_2 | 100 | 11599 | 478 | 7 | 2024-04-08 | 0.25 | 2024-03-27 | 9.99 | 2 | SO59984 | 2024-04-03 | 0.80 | 3.74 | |
SO50826_1 | 100 | 16476 | 379 | 7 | 2023-10-01 | 54.54 | 2023-09-19 | 2181.56 | 1 | SO50826 | 2023-09-26 | 174.53 | 1320.68 | |
SO59984_3 | 100 | 11599 | 477 | 7 | 2024-04-08 | 0.12 | 2024-03-27 | 4.99 | 3 | SO59984 | 2024-04-03 | 0.40 | 1.87 | |
SO50840_1 | 100 | 16436 | 371 | 7 | 2023-10-02 | 54.54 | 2023-09-20 | 2181.56 | 1 | SO50840 | 2023-09-27 | 174.53 | 1320.68 | |
SO59984_4 | 100 | 11599 | 217 | 7 | 2024-04-08 | 0.87 | 2024-03-27 | 34.99 | 4 | SO59984 | 2024-04-03 | 2.80 | 13.09 | |
SO50842_1 | 100 | 11479 | 356 | 7 | 2023-10-02 | 51.79 | 2023-09-20 | 2071.42 | 1 | SO50842 | 2023-09-27 | 165.71 | 1117.86 | |
SO59984_5 | 100 | 11599 | 225 | 7 | 2024-04-08 | 0.22 | 2024-03-27 | 8.99 | 5 | SO59984 | 2024-04-03 | 0.72 | 6.92 | |
SO50844_1 | 100 | 19503 | 327 | 7 | 2023-10-02 | 19.57 | 2023-09-20 | 782.99 | 1 | SO50844 | 2023-09-27 | 62.64 | 486.71 | |
SO59985_1 | 100 | 12632 | 355 | 7 | 2024-04-08 | 58.00 | 2024-03-27 | 2319.99 | 1 | SO59985 | 2024-04-03 | 185.60 | 1265.62 | |
SO50856_1 | 100 | 17949 | 381 | 7 | 2023-10-03 | 25.01 | 2023-09-21 | 1000.44 | 1 | SO50856 | 2023-09-28 | 80.04 | 605.65 | |
SO59986_1 | 100 | 12650 | 359 | 7 | 2024-04-08 | 57.37 | 2024-03-27 | 2294.99 | 1 | SO59986 | 2024-04-03 | 183.60 | 1251.98 | |
SO50865_1 | 100 | 11582 | 362 | 2 | 7 | 2023-10-04 | 51.23 | 2023-09-22 | 2049.10 | 1 | SO50865 | 2023-09-29 | 163.93 | 1105.81 |
SO59986_2 | 100 | 12650 | 478 | 7 | 2024-04-08 | 0.25 | 2024-03-27 | 9.99 | 2 | SO59986 | 2024-04-03 | 0.80 | 3.74 | |
SO50874_1 | 100 | 16570 | 368 | 7 | 2023-10-05 | 61.08 | 2023-09-23 | 2443.35 | 1 | SO50874 | 2023-09-30 | 195.47 | 1518.79 | |
SO59986_3 | 100 | 12650 | 477 | 7 | 2024-04-08 | 0.12 | 2024-03-27 | 4.99 | 3 | SO59986 | 2024-04-03 | 0.40 | 1.87 | |
SO50887_1 | 100 | 16596 | 375 | 7 | 2023-10-06 | 54.54 | 2023-09-24 | 2181.56 | 1 | SO50887 | 2023-10-01 | 174.53 | 1320.68 | |
SO59986_4 | 100 | 12650 | 490 | 7 | 2024-04-08 | 1.35 | 2024-03-27 | 53.99 | 4 | SO59986 | 2024-04-03 | 4.32 | 41.57 | |
SO50889_1 | 100 | 11572 | 352 | 7 | 2023-10-06 | 51.79 | 2023-09-24 | 2071.42 | 1 | SO50889 | 2023-10-01 | 165.71 | 1117.86 | |
SO59986_5 | 100 | 12650 | 225 | 7 | 2024-04-08 | 0.22 | 2024-03-27 | 8.99 | 5 | SO59986 | 2024-04-03 | 0.72 | 6.92 | |
SO50897_1 | 100 | 11432 | 352 | 7 | 2023-10-07 | 51.79 | 2023-09-25 | 2071.42 | 1 | SO50897 | 2023-10-02 | 165.71 | 1117.86 | |
SO60013_1 | 98 | 29387 | 538 | 7 | 2024-04-08 | 0.54 | 2024-03-27 | 21.49 | 1 | SO60013 | 2024-04-03 | 1.72 | 8.04 | |
SO50907_1 | 100 | 17894 | 385 | 7 | 2023-10-08 | 25.01 | 2023-09-26 | 1000.44 | 1 | SO50907 | 2023-10-03 | 80.04 | 605.65 | |
SO60016_1 | 100 | 12720 | 477 | 7 | 2024-04-08 | 0.12 | 2024-03-27 | 4.99 | 1 | SO60016 | 2024-04-03 | 0.40 | 1.87 | |
SO50917_1 | 100 | 16533 | 379 | 7 | 2023-10-09 | 54.54 | 2023-09-27 | 2181.56 | 1 | SO50917 | 2023-10-04 | 174.53 | 1320.68 | |
SO60016_2 | 100 | 12720 | 478 | 7 | 2024-04-08 | 0.25 | 2024-03-27 | 9.99 | 2 | SO60016 | 2024-04-03 | 0.80 | 3.74 | |
SO50918_1 | 100 | 16547 | 368 | 7 | 2023-10-09 | 61.08 | 2023-09-27 | 2443.35 | 1 | SO50918 | 2023-10-04 | 195.47 | 1518.79 | |
SO60016_3 | 100 | 12720 | 222 | 7 | 2024-04-08 | 0.87 | 2024-03-27 | 34.99 | 3 | SO60016 | 2024-04-03 | 2.80 | 13.09 | |
SO50920_1 | 100 | 11571 | 356 | 7 | 2023-10-09 | 51.79 | 2023-09-27 | 2071.42 | 1 | SO50920 | 2023-10-04 | 165.71 | 1117.86 | |
SO60040_1 | 100 | 22423 | 584 | 7 | 2024-04-08 | 13.50 | 2024-03-27 | 539.99 | 1 | SO60040 | 2024-04-03 | 43.20 | 343.65 | |
SO50930_1 | 100 | 17950 | 381 | 7 | 2023-10-10 | 25.01 | 2023-09-28 | 1000.44 | 1 | SO50930 | 2023-10-05 | 80.04 | 605.65 | |
SO60040_2 | 100 | 22423 | 222 | 7 | 2024-04-08 | 0.87 | 2024-03-27 | 34.99 | 2 | SO60040 | 2024-04-03 | 2.80 | 13.09 | |
SO50931_1 | 100 | 16569 | 379 | 7 | 2023-10-10 | 54.54 | 2023-09-28 | 2181.56 | 1 | SO50931 | 2023-10-05 | 174.53 | 1320.68 |
Generated 2024-11-13 03:42:56.543 UTC