[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > < SKIP 1455 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO70830_1 | 100 | 26231 | 583 | 7 | 2024-09-09 | 42.52 | 2024-08-28 | 1700.99 | 1 | SO70830 | 2024-09-04 | 136.08 | 1082.51 | |
SO50629_1 | 100 | 16426 | 377 | 7 | 2023-09-21 | 54.54 | 2023-09-09 | 2181.56 | 1 | SO50629 | 2023-09-16 | 174.53 | 1320.68 | |
SO70830_2 | 100 | 26231 | 529 | 7 | 2024-09-09 | 0.10 | 2024-08-28 | 3.99 | 2 | SO70830 | 2024-09-04 | 0.32 | 1.49 | |
SO50763_1 | 100 | 16513 | 373 | 7 | 2023-09-23 | 54.54 | 2023-09-11 | 2181.56 | 1 | SO50763 | 2023-09-18 | 174.53 | 1320.68 | |
SO70830_3 | 100 | 26231 | 539 | 7 | 2024-09-09 | 0.62 | 2024-08-28 | 24.99 | 3 | SO70830 | 2024-09-04 | 2.00 | 9.35 | |
SO50773_1 | 100 | 19903 | 331 | 7 | 2023-09-23 | 19.57 | 2023-09-11 | 782.99 | 1 | SO50773 | 2023-09-18 | 62.64 | 486.71 | |
SO70830_4 | 100 | 26231 | 214 | 7 | 2024-09-09 | 0.87 | 2024-08-28 | 34.99 | 4 | SO70830 | 2024-09-04 | 2.80 | 13.09 | |
SO50777_1 | 100 | 11439 | 354 | 7 | 2023-09-24 | 51.79 | 2023-09-12 | 2071.42 | 1 | SO50777 | 2023-09-19 | 165.71 | 1117.86 | |
SO70831_1 | 100 | 26816 | 580 | 7 | 2024-09-09 | 42.52 | 2024-08-28 | 1700.99 | 1 | SO70831 | 2024-09-04 | 136.08 | 1082.51 | |
SO50778_1 | 100 | 11578 | 356 | 7 | 2023-09-24 | 51.79 | 2023-09-12 | 2071.42 | 1 | SO50778 | 2023-09-19 | 165.71 | 1117.86 | |
SO70831_2 | 100 | 26816 | 217 | 7 | 2024-09-09 | 0.87 | 2024-08-28 | 34.99 | 2 | SO70831 | 2024-09-04 | 2.80 | 13.09 | |
SO50780_1 | 100 | 19945 | 321 | 7 | 2023-09-24 | 19.57 | 2023-09-12 | 782.99 | 1 | SO50780 | 2023-09-19 | 62.64 | 486.71 | |
SO70842_1 | 100 | 22696 | 541 | 7 | 2024-09-09 | 0.72 | 2024-08-28 | 28.99 | 1 | SO70842 | 2024-09-04 | 2.32 | 10.84 | |
SO50782_1 | 100 | 11587 | 360 | 7 | 2023-09-24 | 51.23 | 2023-09-12 | 2049.10 | 1 | SO50782 | 2023-09-19 | 163.93 | 1105.81 | |
SO70842_2 | 100 | 22696 | 530 | 7 | 2024-09-09 | 0.12 | 2024-08-28 | 4.99 | 2 | SO70842 | 2024-09-04 | 0.40 | 1.87 | |
SO50783_1 | 100 | 11588 | 358 | 7 | 2023-09-24 | 51.23 | 2023-09-12 | 2049.10 | 1 | SO50783 | 2023-09-19 | 163.93 | 1105.81 | |
SO70842_3 | 100 | 22696 | 222 | 7 | 2024-09-09 | 0.87 | 2024-08-28 | 34.99 | 3 | SO70842 | 2024-09-04 | 2.80 | 13.09 | |
SO50798_1 | 100 | 17900 | 387 | 7 | 2023-09-26 | 25.01 | 2023-09-14 | 1000.44 | 1 | SO50798 | 2023-09-21 | 80.04 | 605.65 | |
SO70843_1 | 100 | 27779 | 530 | 7 | 2024-09-09 | 0.12 | 2024-08-28 | 4.99 | 1 | SO70843 | 2024-09-04 | 0.40 | 1.87 | |
SO50800_1 | 100 | 11590 | 362 | 2 | 7 | 2023-09-26 | 51.23 | 2023-09-14 | 2049.10 | 1 | SO50800 | 2023-09-21 | 163.93 | 1105.81 |
SO70843_2 | 100 | 27779 | 222 | 7 | 2024-09-09 | 0.87 | 2024-08-28 | 34.99 | 2 | SO70843 | 2024-09-04 | 2.80 | 13.09 | |
SO50807_1 | 100 | 11433 | 360 | 7 | 2023-09-27 | 51.23 | 2023-09-15 | 2049.10 | 1 | SO50807 | 2023-09-22 | 163.93 | 1105.81 | |
SO70856_1 | 100 | 25683 | 578 | 7 | 2024-09-09 | 30.37 | 2024-08-28 | 1214.85 | 1 | SO70856 | 2024-09-04 | 97.19 | 755.15 | |
SO50808_1 | 100 | 11546 | 352 | 7 | 2023-09-27 | 51.79 | 2023-09-15 | 2071.42 | 1 | SO50808 | 2023-09-22 | 165.71 | 1117.86 | |
SO70856_2 | 100 | 25683 | 541 | 7 | 2024-09-09 | 0.72 | 2024-08-28 | 28.99 | 2 | SO70856 | 2024-09-04 | 2.32 | 10.84 | |
SO50816_1 | 100 | 17944 | 387 | 7 | 2023-09-28 | 25.01 | 2023-09-16 | 1000.44 | 1 | SO50816 | 2023-09-23 | 80.04 | 605.65 | |
SO70856_3 | 100 | 25683 | 530 | 7 | 2024-09-09 | 0.12 | 2024-08-28 | 4.99 | 3 | SO70856 | 2024-09-04 | 0.40 | 1.87 | |
SO50826_1 | 100 | 16476 | 379 | 7 | 2023-09-29 | 54.54 | 2023-09-17 | 2181.56 | 1 | SO50826 | 2023-09-24 | 174.53 | 1320.68 | |
SO70856_4 | 100 | 25683 | 480 | 7 | 2024-09-09 | 0.06 | 2024-08-28 | 2.29 | 4 | SO70856 | 2024-09-04 | 0.18 | 0.86 | |
SO50840_1 | 100 | 16436 | 371 | 7 | 2023-09-30 | 54.54 | 2023-09-18 | 2181.56 | 1 | SO50840 | 2023-09-25 | 174.53 | 1320.68 | |
SO70857_1 | 100 | 25452 | 573 | 7 | 2024-09-09 | 59.60 | 2024-08-28 | 2384.07 | 1 | SO70857 | 2024-09-04 | 190.73 | 1481.94 | |
SO50842_1 | 100 | 11479 | 356 | 7 | 2023-09-30 | 51.79 | 2023-09-18 | 2071.42 | 1 | SO50842 | 2023-09-25 | 165.71 | 1117.86 | |
SO70868_1 | 100 | 24022 | 584 | 7 | 2024-09-09 | 13.50 | 2024-08-28 | 539.99 | 1 | SO70868 | 2024-09-04 | 43.20 | 343.65 | |
SO50844_1 | 100 | 19503 | 327 | 7 | 2023-09-30 | 19.57 | 2023-09-18 | 782.99 | 1 | SO50844 | 2023-09-25 | 62.64 | 486.71 | |
SO70868_2 | 100 | 24022 | 538 | 7 | 2024-09-09 | 0.54 | 2024-08-28 | 21.49 | 2 | SO70868 | 2024-09-04 | 1.72 | 8.04 | |
SO50856_1 | 100 | 17949 | 381 | 7 | 2023-10-01 | 25.01 | 2023-09-19 | 1000.44 | 1 | SO50856 | 2023-09-26 | 80.04 | 605.65 | |
SO70879_1 | 100 | 17648 | 363 | 7 | 2024-09-10 | 57.37 | 2024-08-29 | 2294.99 | 1 | SO70879 | 2024-09-05 | 183.60 | 1251.98 | |
SO50865_1 | 100 | 11582 | 362 | 2 | 7 | 2023-10-02 | 51.23 | 2023-09-20 | 2049.10 | 1 | SO50865 | 2023-09-27 | 163.93 | 1105.81 |
SO70879_2 | 100 | 17648 | 478 | 7 | 2024-09-10 | 0.25 | 2024-08-29 | 9.99 | 2 | SO70879 | 2024-09-05 | 0.80 | 3.74 | |
SO50874_1 | 100 | 16570 | 368 | 7 | 2023-10-03 | 61.08 | 2023-09-21 | 2443.35 | 1 | SO50874 | 2023-09-28 | 195.47 | 1518.79 | |
SO70879_3 | 100 | 17648 | 477 | 7 | 2024-09-10 | 0.12 | 2024-08-29 | 4.99 | 3 | SO70879 | 2024-09-05 | 0.40 | 1.87 | |
SO50887_1 | 100 | 16596 | 375 | 7 | 2023-10-04 | 54.54 | 2023-09-22 | 2181.56 | 1 | SO50887 | 2023-09-29 | 174.53 | 1320.68 | |
SO70879_4 | 100 | 17648 | 217 | 7 | 2024-09-10 | 0.87 | 2024-08-29 | 34.99 | 4 | SO70879 | 2024-09-05 | 2.80 | 13.09 | |
SO50889_1 | 100 | 11572 | 352 | 7 | 2023-10-04 | 51.79 | 2023-09-22 | 2071.42 | 1 | SO50889 | 2023-09-29 | 165.71 | 1117.86 | |
SO70904_1 | 100 | 26925 | 541 | 7 | 2024-09-10 | 0.72 | 2024-08-29 | 28.99 | 1 | SO70904 | 2024-09-05 | 2.32 | 10.84 | |
SO50897_1 | 100 | 11432 | 352 | 7 | 2023-10-05 | 51.79 | 2023-09-23 | 2071.42 | 1 | SO50897 | 2023-09-30 | 165.71 | 1117.86 | |
SO70904_2 | 100 | 26925 | 530 | 7 | 2024-09-10 | 0.12 | 2024-08-29 | 4.99 | 2 | SO70904 | 2024-09-05 | 0.40 | 1.87 | |
SO50907_1 | 100 | 17894 | 385 | 7 | 2023-10-06 | 25.01 | 2023-09-24 | 1000.44 | 1 | SO50907 | 2023-10-01 | 80.04 | 605.65 | |
SO70904_3 | 100 | 26925 | 480 | 2 | 7 | 2024-09-10 | 0.06 | 2024-08-29 | 2.29 | 3 | SO70904 | 2024-09-05 | 0.18 | 0.86 |
SO50917_1 | 100 | 16533 | 379 | 7 | 2023-10-07 | 54.54 | 2023-09-25 | 2181.56 | 1 | SO50917 | 2023-10-02 | 174.53 | 1320.68 | |
SO70933_1 | 100 | 20883 | 382 | 7 | 2024-09-10 | 28.01 | 2024-08-29 | 1120.49 | 1 | SO70933 | 2024-09-05 | 89.64 | 713.08 | |
SO50918_1 | 100 | 16547 | 368 | 7 | 2023-10-07 | 61.08 | 2023-09-25 | 2443.35 | 1 | SO50918 | 2023-10-02 | 195.47 | 1518.79 | |
SO70933_2 | 100 | 20883 | 539 | 7 | 2024-09-10 | 0.62 | 2024-08-29 | 24.99 | 2 | SO70933 | 2024-09-05 | 2.00 | 9.35 | |
SO50920_1 | 100 | 11571 | 356 | 7 | 2023-10-07 | 51.79 | 2023-09-25 | 2071.42 | 1 | SO50920 | 2023-10-02 | 165.71 | 1117.86 | |
SO70933_3 | 100 | 20883 | 529 | 7 | 2024-09-10 | 0.10 | 2024-08-29 | 3.99 | 3 | SO70933 | 2024-09-05 | 0.32 | 1.49 | |
SO50930_1 | 100 | 17950 | 381 | 7 | 2023-10-08 | 25.01 | 2023-09-26 | 1000.44 | 1 | SO50930 | 2023-10-03 | 80.04 | 605.65 |
Generated 2024-11-10 12:45:09.331 UTC