[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 1161 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO70029_1 | 100 | 12852 | 357 | 8 | 2024-07-09 | 58.00 | 2024-06-27 | 2319.99 | 1 | SO70029 | 2024-07-04 | 185.60 | 1265.62 | |
SO47606_1 | 100 | 15928 | 375 | 8 | 2022-11-25 | 54.54 | 2022-11-13 | 2181.56 | 1 | SO47606 | 2022-11-20 | 174.53 | 1320.68 | |
SO56883_2 | 100 | 20554 | 528 | 8 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56883 | 2023-12-26 | 0.40 | 1.87 | |
SO63659_2 | 100 | 25772 | 488 | 8 | 2024-04-09 | 1.35 | 2024-03-28 | 53.99 | 2 | SO63659 | 2024-04-04 | 4.32 | 41.57 | |
SO70029_2 | 100 | 12852 | 528 | 8 | 2024-07-09 | 0.12 | 2024-06-27 | 4.99 | 2 | SO70029 | 2024-07-04 | 0.40 | 1.87 | |
SO47629_1 | 100 | 15685 | 370 | 8 | 2022-11-28 | 61.08 | 2022-11-16 | 2443.35 | 1 | SO47629 | 2022-11-23 | 195.47 | 1518.79 | |
SO56884_1 | 100 | 22488 | 477 | 8 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 1 | SO56884 | 2023-12-26 | 0.40 | 1.87 | |
SO63665_1 | 100 | 12591 | 478 | 8 | 2024-04-09 | 0.25 | 2024-03-28 | 9.99 | 1 | SO63665 | 2024-04-04 | 0.80 | 3.74 | |
SO70029_3 | 100 | 12852 | 537 | 8 | 2024-07-09 | 0.88 | 2024-06-27 | 35.00 | 3 | SO70029 | 2024-07-04 | 2.80 | 13.09 | |
SO47634_1 | 100 | 11570 | 356 | 8 | 2022-11-28 | 51.79 | 2022-11-16 | 2071.42 | 1 | SO47634 | 2022-11-23 | 165.71 | 1117.86 | |
SO56931_1 | 100 | 14202 | 540 | 8 | 2024-01-01 | 0.82 | 2023-12-20 | 32.60 | 1 | SO56931 | 2023-12-27 | 2.61 | 12.19 | |
SO63665_2 | 100 | 12591 | 477 | 8 | 2024-04-09 | 0.12 | 2024-03-28 | 4.99 | 2 | SO63665 | 2024-04-04 | 0.40 | 1.87 | |
SO70029_4 | 100 | 12852 | 480 | 8 | 2024-07-09 | 0.06 | 2024-06-27 | 2.29 | 4 | SO70029 | 2024-07-04 | 0.18 | 0.86 | |
SO47644_1 | 100 | 15693 | 375 | 8 | 2022-12-01 | 54.54 | 2022-11-19 | 2181.56 | 1 | SO47644 | 2022-11-26 | 174.53 | 1320.68 | |
SO56935_1 | 100 | 25667 | 538 | 8 | 2024-01-01 | 0.54 | 2023-12-20 | 21.49 | 1 | SO56935 | 2023-12-27 | 1.72 | 8.04 | |
SO63665_3 | 100 | 12591 | 217 | 8 | 2024-04-09 | 0.87 | 2024-03-28 | 34.99 | 3 | SO63665 | 2024-04-04 | 2.80 | 13.09 | |
SO70052_1 | 100 | 16280 | 528 | 8 | 2024-07-09 | 0.12 | 2024-06-27 | 4.99 | 1 | SO70052 | 2024-07-04 | 0.40 | 1.87 | |
SO47653_1 | 100 | 20163 | 325 | 8 | 2022-12-02 | 19.57 | 2022-11-20 | 782.99 | 1 | SO47653 | 2022-11-27 | 62.64 | 486.71 | |
SO56935_2 | 100 | 25667 | 480 | 8 | 2024-01-01 | 0.06 | 2023-12-20 | 2.29 | 2 | SO56935 | 2023-12-27 | 0.18 | 0.86 | |
SO63689_1 | 100 | 18133 | 574 | 8 | 2024-04-09 | 59.60 | 2024-03-28 | 2384.07 | 1 | SO63689 | 2024-04-04 | 190.73 | 1481.94 | |
SO70052_2 | 100 | 16280 | 484 | 8 | 2024-07-09 | 0.20 | 2024-06-27 | 7.95 | 2 | SO70052 | 2024-07-04 | 0.64 | 2.97 | |
SO47747_1 | 100 | 16253 | 371 | 8 | 2022-12-05 | 54.54 | 2022-11-23 | 2181.56 | 1 | SO47747 | 2022-11-30 | 174.53 | 1320.68 | |
SO56936_1 | 100 | 12814 | 530 | 8 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56936 | 2023-12-27 | 0.40 | 1.87 | |
SO63699_1 | 100 | 17940 | 580 | 8 | 2024-04-10 | 42.52 | 2024-03-29 | 1700.99 | 1 | SO63699 | 2024-04-05 | 136.08 | 1082.51 | |
SO70066_1 | 100 | 19438 | 579 | 8 | 2024-07-09 | 30.37 | 2024-06-27 | 1214.85 | 1 | SO70066 | 2024-07-04 | 97.19 | 755.15 | |
SO47761_1 | 100 | 20548 | 325 | 8 | 2022-12-07 | 19.57 | 2022-11-25 | 782.99 | 1 | SO47761 | 2022-12-02 | 62.64 | 486.71 | |
SO56936_2 | 100 | 12814 | 465 | 8 | 2024-01-01 | 0.61 | 2023-12-20 | 24.49 | 2 | SO56936 | 2023-12-27 | 1.96 | 9.16 | |
SO63702_1 | 100 | 17209 | 353 | 8 | 2024-04-10 | 58.00 | 2024-03-29 | 2319.99 | 1 | SO63702 | 2024-04-05 | 185.60 | 1265.62 | |
SO70066_2 | 100 | 19438 | 488 | 8 | 2024-07-09 | 1.35 | 2024-06-27 | 53.99 | 2 | SO70066 | 2024-07-04 | 4.32 | 41.57 | |
SO47779_1 | 100 | 16269 | 375 | 8 | 2022-12-10 | 54.54 | 2022-11-28 | 2181.56 | 1 | SO47779 | 2022-12-05 | 174.53 | 1320.68 | |
SO56957_1 | 100 | 13258 | 606 | 8 | 2024-01-01 | 13.50 | 2023-12-20 | 539.99 | 1 | SO56957 | 2023-12-27 | 43.20 | 343.65 | |
SO63702_2 | 100 | 17209 | 222 | 8 | 2024-04-10 | 0.87 | 2024-03-29 | 34.99 | 2 | SO63702 | 2024-04-05 | 2.80 | 13.09 | |
SO70067_1 | 100 | 29363 | 570 | 8 | 2024-07-09 | 18.56 | 2024-06-27 | 742.35 | 1 | SO70067 | 2024-07-04 | 59.39 | 461.44 | |
SO47792_1 | 100 | 16207 | 369 | 2 | 8 | 2022-12-13 | 61.08 | 2022-12-01 | 2443.35 | 1 | SO47792 | 2022-12-08 | 195.47 | 1518.79 |
SO56957_2 | 100 | 13258 | 479 | 8 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 2 | SO56957 | 2023-12-27 | 0.72 | 3.36 | |
SO63720_1 | 100 | 19251 | 539 | 8 | 2024-04-10 | 0.62 | 2024-03-29 | 24.99 | 1 | SO63720 | 2024-04-05 | 2.00 | 9.35 | |
SO70067_2 | 100 | 29363 | 214 | 8 | 2024-07-09 | 0.87 | 2024-06-27 | 34.99 | 2 | SO70067 | 2024-07-04 | 2.80 | 13.09 | |
SO47801_1 | 100 | 20555 | 329 | 8 | 2022-12-14 | 19.57 | 2022-12-02 | 782.99 | 1 | SO47801 | 2022-12-09 | 62.64 | 486.71 | |
SO56957_3 | 100 | 13258 | 477 | 8 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 3 | SO56957 | 2023-12-27 | 0.40 | 1.87 | |
SO63720_2 | 100 | 19251 | 480 | 8 | 2024-04-10 | 0.06 | 2024-03-29 | 2.29 | 2 | SO63720 | 2024-04-05 | 0.18 | 0.86 | |
SO70083_1 | 100 | 21035 | 384 | 8 | 2024-07-09 | 28.01 | 2024-06-27 | 1120.49 | 1 | SO70083 | 2024-07-04 | 89.64 | 713.08 | |
SO47812_1 | 100 | 16252 | 377 | 8 | 2022-12-15 | 54.54 | 2022-12-03 | 2181.56 | 1 | SO47812 | 2022-12-10 | 174.53 | 1320.68 | |
SO56957_4 | 100 | 13258 | 484 | 8 | 2024-01-01 | 0.20 | 2023-12-20 | 7.95 | 4 | SO56957 | 2023-12-27 | 0.64 | 2.97 | |
SO63731_1 | 100 | 27004 | 560 | 8 | 2024-04-10 | 30.37 | 2024-03-29 | 1214.85 | 1 | SO63731 | 2024-04-05 | 97.19 | 755.15 | |
SO70083_2 | 100 | 21035 | 490 | 8 | 2024-07-09 | 1.35 | 2024-06-27 | 53.99 | 2 | SO70083 | 2024-07-04 | 4.32 | 41.57 | |
SO47824_1 | 100 | 16267 | 368 | 8 | 2022-12-16 | 61.08 | 2022-12-04 | 2443.35 | 1 | SO47824 | 2022-12-11 | 195.47 | 1518.79 | |
SO56961_1 | 100 | 13771 | 359 | 8 | 2024-01-02 | 57.37 | 2023-12-21 | 2294.99 | 1 | SO56961 | 2023-12-28 | 183.60 | 1251.98 | |
SO63731_2 | 100 | 27004 | 234 | 8 | 2024-04-10 | 1.25 | 2024-03-29 | 49.99 | 2 | SO63731 | 2024-04-05 | 4.00 | 38.49 | |
SO70084_1 | 100 | 20979 | 384 | 8 | 2024-07-09 | 28.01 | 2024-06-27 | 1120.49 | 1 | SO70084 | 2024-07-04 | 89.64 | 713.08 | |
SO47825_1 | 100 | 20560 | 321 | 8 | 2022-12-16 | 19.57 | 2022-12-04 | 782.99 | 1 | SO47825 | 2022-12-11 | 62.64 | 486.71 | |
SO56961_2 | 100 | 13771 | 528 | 8 | 2024-01-02 | 0.12 | 2023-12-21 | 4.99 | 2 | SO56961 | 2023-12-28 | 0.40 | 1.87 | |
SO63746_1 | 100 | 23903 | 604 | 8 | 2024-04-10 | 13.50 | 2024-03-29 | 539.99 | 1 | SO63746 | 2024-04-05 | 43.20 | 343.65 | |
SO70084_2 | 100 | 20979 | 225 | 8 | 2024-07-09 | 0.22 | 2024-06-27 | 8.99 | 2 | SO70084 | 2024-07-04 | 0.72 | 6.92 | |
SO47840_1 | 100 | 20584 | 335 | 8 | 2022-12-18 | 19.57 | 2022-12-06 | 782.99 | 1 | SO47840 | 2022-12-13 | 62.64 | 486.71 | |
SO56961_3 | 100 | 13771 | 537 | 8 | 2024-01-02 | 0.88 | 2023-12-21 | 35.00 | 3 | SO56961 | 2023-12-28 | 2.80 | 13.09 | |
SO63747_1 | 100 | 23982 | 606 | 8 | 2024-04-10 | 13.50 | 2024-03-29 | 539.99 | 1 | SO63747 | 2024-04-05 | 43.20 | 343.65 | |
SO70084_3 | 100 | 20979 | 214 | 8 | 2024-07-09 | 0.87 | 2024-06-27 | 34.99 | 3 | SO70084 | 2024-07-04 | 2.80 | 13.09 | |
SO47845_1 | 100 | 16206 | 369 | 2 | 8 | 2022-12-19 | 61.08 | 2022-12-07 | 2443.35 | 1 | SO47845 | 2022-12-14 | 195.47 | 1518.79 |
SO56961_4 | 100 | 13771 | 222 | 8 | 2024-01-02 | 0.87 | 2023-12-21 | 34.99 | 4 | SO56961 | 2023-12-28 | 2.80 | 13.09 | |
SO63747_2 | 100 | 23982 | 479 | 8 | 2024-04-10 | 0.22 | 2024-03-29 | 8.99 | 2 | SO63747 | 2024-04-05 | 0.72 | 3.36 |
Generated 2024-09-20 16:52:35.715 UTC