[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 488 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56672_1 | 98 | 16454 | 530 | 10 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO56672 | 2023-12-22 | 0.40 | 1.87 | |
SO56672_2 | 98 | 16454 | 480 | 2 | 10 | 2023-12-27 | 0.06 | 2023-12-15 | 2.29 | 2 | SO56672 | 2023-12-22 | 0.18 | 0.86 |
SO56673_1 | 98 | 13816 | 541 | 10 | 2023-12-27 | 0.72 | 2023-12-15 | 28.99 | 1 | SO56673 | 2023-12-22 | 2.32 | 10.84 | |
SO56673_2 | 98 | 13816 | 530 | 10 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 2 | SO56673 | 2023-12-22 | 0.40 | 1.87 | |
SO56673_3 | 98 | 13816 | 480 | 10 | 2023-12-27 | 0.06 | 2023-12-15 | 2.29 | 3 | SO56673 | 2023-12-22 | 0.18 | 0.86 | |
SO56673_4 | 98 | 13816 | 483 | 10 | 2023-12-27 | 3.00 | 2023-12-15 | 120.00 | 4 | SO56673 | 2023-12-22 | 9.60 | 44.88 | |
SO56673_5 | 98 | 13816 | 234 | 10 | 2023-12-27 | 1.25 | 2023-12-15 | 49.99 | 5 | SO56673 | 2023-12-22 | 4.00 | 38.49 | |
SO56673_6 | 98 | 13816 | 225 | 10 | 2023-12-27 | 0.22 | 2023-12-15 | 8.99 | 6 | SO56673 | 2023-12-22 | 0.72 | 6.92 | |
SO56675_1 | 98 | 26232 | 530 | 10 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO56675 | 2023-12-22 | 0.40 | 1.87 | |
SO56692_1 | 98 | 12634 | 363 | 10 | 2023-12-28 | 57.37 | 2023-12-16 | 2294.99 | 1 | SO56692 | 2023-12-23 | 183.60 | 1251.98 | |
SO56692_2 | 98 | 12634 | 480 | 10 | 2023-12-28 | 0.06 | 2023-12-16 | 2.29 | 2 | SO56692 | 2023-12-23 | 0.18 | 0.86 | |
SO56728_1 | 98 | 16200 | 485 | 10 | 2023-12-28 | 0.55 | 2023-12-16 | 21.98 | 1 | SO56728 | 2023-12-23 | 1.76 | 8.22 | |
SO56728_2 | 98 | 16200 | 222 | 10 | 2023-12-28 | 0.87 | 2023-12-16 | 34.99 | 2 | SO56728 | 2023-12-23 | 2.80 | 13.09 | |
SO56729_1 | 98 | 23219 | 477 | 10 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56729 | 2023-12-23 | 0.40 | 1.87 | |
SO56729_2 | 98 | 23219 | 222 | 10 | 2023-12-28 | 0.87 | 2023-12-16 | 34.99 | 2 | SO56729 | 2023-12-23 | 2.80 | 13.09 | |
SO56731_1 | 98 | 22540 | 477 | 10 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 1 | SO56731 | 2023-12-23 | 0.40 | 1.87 | |
SO56731_2 | 98 | 22540 | 465 | 10 | 2023-12-28 | 0.61 | 2023-12-16 | 24.49 | 2 | SO56731 | 2023-12-23 | 1.96 | 9.16 | |
SO56737_1 | 98 | 13493 | 478 | 10 | 2023-12-28 | 0.25 | 2023-12-16 | 9.99 | 1 | SO56737 | 2023-12-23 | 0.80 | 3.74 | |
SO56737_2 | 98 | 13493 | 477 | 10 | 2023-12-28 | 0.12 | 2023-12-16 | 4.99 | 2 | SO56737 | 2023-12-23 | 0.40 | 1.87 | |
SO56744_1 | 98 | 14770 | 586 | 10 | 2023-12-28 | 18.56 | 2023-12-16 | 742.35 | 1 | SO56744 | 2023-12-23 | 59.39 | 461.44 | |
SO56744_2 | 98 | 14770 | 541 | 10 | 2023-12-28 | 0.72 | 2023-12-16 | 28.99 | 2 | SO56744 | 2023-12-23 | 2.32 | 10.84 | |
SO56745_1 | 98 | 14778 | 565 | 10 | 2023-12-28 | 18.56 | 2023-12-16 | 742.35 | 1 | SO56745 | 2023-12-23 | 59.39 | 461.44 | |
SO56745_2 | 98 | 14778 | 484 | 10 | 2023-12-28 | 0.20 | 2023-12-16 | 7.95 | 2 | SO56745 | 2023-12-23 | 0.64 | 2.97 | |
SO56756_1 | 98 | 23753 | 390 | 10 | 2023-12-28 | 28.01 | 2023-12-16 | 1120.49 | 1 | SO56756 | 2023-12-23 | 89.64 | 713.08 | |
SO56756_2 | 98 | 23753 | 539 | 10 | 2023-12-28 | 0.62 | 2023-12-16 | 24.99 | 2 | SO56756 | 2023-12-23 | 2.00 | 9.35 | |
SO56756_3 | 98 | 23753 | 529 | 10 | 2023-12-28 | 0.10 | 2023-12-16 | 3.99 | 3 | SO56756 | 2023-12-23 | 0.32 | 1.49 | |
SO56756_4 | 98 | 23753 | 214 | 10 | 2023-12-28 | 0.87 | 2023-12-16 | 34.99 | 4 | SO56756 | 2023-12-23 | 2.80 | 13.09 | |
SO56756_5 | 98 | 23753 | 225 | 10 | 2023-12-28 | 0.22 | 2023-12-16 | 8.99 | 5 | SO56756 | 2023-12-23 | 0.72 | 6.92 | |
SO56764_1 | 98 | 24549 | 374 | 10 | 2023-12-29 | 61.08 | 2023-12-17 | 2443.35 | 1 | SO56764 | 2023-12-24 | 195.47 | 1554.95 | |
SO56764_2 | 98 | 24549 | 540 | 10 | 2023-12-29 | 0.82 | 2023-12-17 | 32.60 | 2 | SO56764 | 2023-12-24 | 2.61 | 12.19 | |
SO56764_3 | 98 | 24549 | 529 | 10 | 2023-12-29 | 0.10 | 2023-12-17 | 3.99 | 3 | SO56764 | 2023-12-24 | 0.32 | 1.49 | |
SO56764_4 | 98 | 24549 | 217 | 10 | 2023-12-29 | 0.87 | 2023-12-17 | 34.99 | 4 | SO56764 | 2023-12-24 | 2.80 | 13.09 | |
SO56777_1 | 98 | 12504 | 529 | 10 | 2023-12-29 | 0.10 | 2023-12-17 | 3.99 | 1 | SO56777 | 2023-12-24 | 0.32 | 1.49 | |
SO56777_2 | 98 | 12504 | 540 | 10 | 2023-12-29 | 0.82 | 2023-12-17 | 32.60 | 2 | SO56777 | 2023-12-24 | 2.61 | 12.19 | |
SO56777_3 | 98 | 12504 | 463 | 10 | 2023-12-29 | 0.61 | 2023-12-17 | 24.49 | 3 | SO56777 | 2023-12-24 | 1.96 | 9.16 | |
SO56781_1 | 98 | 13507 | 478 | 10 | 2023-12-29 | 0.25 | 2023-12-17 | 9.99 | 1 | SO56781 | 2023-12-24 | 0.80 | 3.74 | |
SO56781_2 | 98 | 13507 | 477 | 10 | 2023-12-29 | 0.12 | 2023-12-17 | 4.99 | 2 | SO56781 | 2023-12-24 | 0.40 | 1.87 | |
SO56792_1 | 98 | 23747 | 382 | 10 | 2023-12-29 | 28.01 | 2023-12-17 | 1120.49 | 1 | SO56792 | 2023-12-24 | 89.64 | 713.08 | |
SO56792_2 | 98 | 23747 | 479 | 10 | 2023-12-29 | 0.22 | 2023-12-17 | 8.99 | 2 | SO56792 | 2023-12-24 | 0.72 | 3.36 | |
SO56792_3 | 98 | 23747 | 477 | 10 | 2023-12-29 | 0.12 | 2023-12-17 | 4.99 | 3 | SO56792 | 2023-12-24 | 0.40 | 1.87 | |
SO56792_4 | 98 | 23747 | 484 | 10 | 2023-12-29 | 0.20 | 2023-12-17 | 7.95 | 4 | SO56792 | 2023-12-24 | 0.64 | 2.97 | |
SO56797_1 | 98 | 12630 | 363 | 2 | 10 | 2023-12-30 | 57.37 | 2023-12-18 | 2294.99 | 1 | SO56797 | 2023-12-25 | 183.60 | 1251.98 |
SO56797_2 | 98 | 12630 | 537 | 10 | 2023-12-30 | 0.88 | 2023-12-18 | 35.00 | 2 | SO56797 | 2023-12-25 | 2.80 | 13.09 | |
SO56797_3 | 98 | 12630 | 528 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56797 | 2023-12-25 | 0.40 | 1.87 | |
SO56806_1 | 98 | 20710 | 376 | 10 | 2023-12-30 | 61.08 | 2023-12-18 | 2443.35 | 1 | SO56806 | 2023-12-25 | 195.47 | 1554.95 | |
SO56806_2 | 98 | 20710 | 479 | 10 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56806 | 2023-12-25 | 0.72 | 3.36 | |
SO56806_3 | 98 | 20710 | 477 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56806 | 2023-12-25 | 0.40 | 1.87 | |
SO56822_1 | 98 | 16193 | 485 | 10 | 2023-12-30 | 0.55 | 2023-12-18 | 21.98 | 1 | SO56822 | 2023-12-25 | 1.76 | 8.22 | |
SO56822_2 | 98 | 16193 | 471 | 10 | 2023-12-30 | 1.59 | 2023-12-18 | 63.50 | 2 | SO56822 | 2023-12-25 | 5.08 | 23.75 | |
SO56826_1 | 98 | 27945 | 529 | 10 | 2023-12-30 | 0.10 | 2023-12-18 | 3.99 | 1 | SO56826 | 2023-12-25 | 0.32 | 1.49 | |
SO56826_2 | 98 | 27945 | 225 | 10 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56826 | 2023-12-25 | 0.72 | 6.92 | |
SO56828_1 | 98 | 14553 | 541 | 10 | 2023-12-30 | 0.72 | 2023-12-18 | 28.99 | 1 | SO56828 | 2023-12-25 | 2.32 | 10.84 | |
SO56828_2 | 98 | 14553 | 530 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 2 | SO56828 | 2023-12-25 | 0.40 | 1.87 | |
SO56828_3 | 98 | 14553 | 217 | 10 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 3 | SO56828 | 2023-12-25 | 2.80 | 13.09 | |
SO56829_1 | 98 | 15444 | 530 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 1 | SO56829 | 2023-12-25 | 0.40 | 1.87 | |
SO56829_2 | 98 | 15444 | 237 | 10 | 2023-12-30 | 1.25 | 2023-12-18 | 49.99 | 2 | SO56829 | 2023-12-25 | 4.00 | 38.49 | |
SO56837_1 | 98 | 11388 | 579 | 10 | 2023-12-30 | 30.37 | 2023-12-18 | 1214.85 | 1 | SO56837 | 2023-12-25 | 97.19 | 755.15 | |
SO56837_2 | 98 | 11388 | 491 | 10 | 2023-12-30 | 1.35 | 2023-12-18 | 53.99 | 2 | SO56837 | 2023-12-25 | 4.32 | 41.57 | |
SO56850_1 | 98 | 28365 | 574 | 10 | 2023-12-30 | 59.60 | 2023-12-18 | 2384.07 | 1 | SO56850 | 2023-12-25 | 190.73 | 1481.94 | |
SO56850_2 | 98 | 28365 | 479 | 10 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56850 | 2023-12-25 | 0.72 | 3.36 | |
SO56850_3 | 98 | 28365 | 477 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56850 | 2023-12-25 | 0.40 | 1.87 | |
SO56850_4 | 98 | 28365 | 214 | 10 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 4 | SO56850 | 2023-12-25 | 2.80 | 13.09 | |
SO56882_1 | 98 | 17886 | 535 | 10 | 2023-12-31 | 0.62 | 2023-12-19 | 24.99 | 1 | SO56882 | 2023-12-26 | 2.00 | 9.35 | |
SO56882_2 | 98 | 17886 | 477 | 10 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56882 | 2023-12-26 | 0.40 | 1.87 | |
SO56882_3 | 98 | 17886 | 225 | 10 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 3 | SO56882 | 2023-12-26 | 0.72 | 6.92 | |
SO56892_1 | 98 | 13586 | 225 | 10 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 1 | SO56892 | 2023-12-26 | 0.72 | 6.92 | |
SO56906_1 | 98 | 12640 | 575 | 10 | 2023-12-31 | 59.60 | 2023-12-19 | 2384.07 | 1 | SO56906 | 2023-12-26 | 190.73 | 1481.94 | |
SO56906_2 | 98 | 12640 | 225 | 10 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 2 | SO56906 | 2023-12-26 | 0.72 | 6.92 | |
SO56908_1 | 98 | 12653 | 363 | 10 | 2024-01-01 | 57.37 | 2023-12-20 | 2294.99 | 1 | SO56908 | 2023-12-27 | 183.60 | 1251.98 | |
SO56908_2 | 98 | 12653 | 478 | 10 | 2024-01-01 | 0.25 | 2023-12-20 | 9.99 | 2 | SO56908 | 2023-12-27 | 0.80 | 3.74 | |
SO56908_3 | 98 | 12653 | 477 | 10 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 3 | SO56908 | 2023-12-27 | 0.40 | 1.87 | |
SO56908_4 | 98 | 12653 | 491 | 10 | 2024-01-01 | 1.35 | 2023-12-20 | 53.99 | 4 | SO56908 | 2023-12-27 | 4.32 | 41.57 | |
SO56908_5 | 98 | 12653 | 465 | 10 | 2024-01-01 | 0.61 | 2023-12-20 | 24.49 | 5 | SO56908 | 2023-12-27 | 1.96 | 9.16 | |
SO56916_1 | 98 | 17744 | 598 | 10 | 2024-01-01 | 13.50 | 2023-12-20 | 539.99 | 1 | SO56916 | 2023-12-27 | 43.20 | 294.58 | |
SO56916_2 | 98 | 17744 | 222 | 10 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 2 | SO56916 | 2023-12-27 | 2.80 | 13.09 | |
SO56916_3 | 98 | 17744 | 225 | 10 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 3 | SO56916 | 2023-12-27 | 0.72 | 6.92 | |
SO56917_1 | 98 | 24558 | 372 | 10 | 2024-01-01 | 61.08 | 2023-12-20 | 2443.35 | 1 | SO56917 | 2023-12-27 | 195.47 | 1554.95 | |
SO56917_2 | 98 | 24558 | 217 | 10 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 2 | SO56917 | 2023-12-27 | 2.80 | 13.09 | |
SO56917_3 | 98 | 24558 | 225 | 10 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 3 | SO56917 | 2023-12-27 | 0.72 | 6.92 | |
SO56932_1 | 98 | 16192 | 485 | 10 | 2024-01-01 | 0.55 | 2023-12-20 | 21.98 | 1 | SO56932 | 2023-12-27 | 1.76 | 8.22 | |
SO56932_2 | 98 | 16192 | 234 | 10 | 2024-01-01 | 1.25 | 2023-12-20 | 49.99 | 2 | SO56932 | 2023-12-27 | 4.00 | 38.49 | |
SO56937_1 | 98 | 17881 | 530 | 10 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56937 | 2023-12-27 | 0.40 | 1.87 | |
SO56937_2 | 98 | 17881 | 487 | 10 | 2024-01-01 | 1.37 | 2023-12-20 | 54.99 | 2 | SO56937 | 2023-12-27 | 4.40 | 20.57 | |
SO56955_1 | 98 | 28916 | 604 | 10 | 2024-01-01 | 13.50 | 2023-12-20 | 539.99 | 1 | SO56955 | 2023-12-27 | 43.20 | 343.65 | |
SO56955_2 | 98 | 28916 | 477 | 10 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 2 | SO56955 | 2023-12-27 | 0.40 | 1.87 | |
SO56955_3 | 98 | 28916 | 479 | 10 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 3 | SO56955 | 2023-12-27 | 0.72 | 3.36 | |
SO56955_4 | 98 | 28916 | 484 | 10 | 2024-01-01 | 0.20 | 2023-12-20 | 7.95 | 4 | SO56955 | 2023-12-27 | 0.64 | 2.97 | |
SO56960_1 | 98 | 13251 | 353 | 10 | 2024-01-02 | 58.00 | 2023-12-21 | 2319.99 | 1 | SO56960 | 2023-12-28 | 185.60 | 1265.62 | |
SO45425_1 | 98 | 15056 | 310 | 10 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO45425 | 2022-04-12 | 286.26 | 2171.29 | |
SO45428_1 | 98 | 11414 | 346 | 10 | 2022-04-17 | 85.00 | 2022-04-05 | 3399.99 | 1 | SO45428 | 2022-04-12 | 272.00 | 1912.15 | |
SO45435_1 | 98 | 20562 | 336 | 10 | 2022-04-18 | 17.48 | 2022-04-06 | 699.10 | 1 | SO45435 | 2022-04-13 | 55.93 | 413.15 | |
SO45467_1 | 98 | 11422 | 345 | 10 | 2022-04-26 | 85.00 | 2022-04-14 | 3399.99 | 1 | SO45467 | 2022-04-21 | 272.00 | 1912.15 | |
SO45593_1 | 98 | 15118 | 310 | 10 | 2022-05-05 | 89.46 | 2022-04-23 | 3578.27 | 1 | SO45593 | 2022-04-30 | 286.26 | 2171.29 | |
SO45596_1 | 98 | 20564 | 332 | 10 | 2022-05-05 | 17.48 | 2022-04-23 | 699.10 | 1 | SO45596 | 2022-04-30 | 55.93 | 413.15 | |
SO45617_1 | 98 | 15354 | 311 | 10 | 2022-05-08 | 89.46 | 2022-04-26 | 3578.27 | 1 | SO45617 | 2022-05-03 | 286.26 | 2171.29 | |
SO45645_1 | 98 | 11482 | 351 | 10 | 2022-05-13 | 84.37 | 2022-05-01 | 3374.99 | 1 | SO45645 | 2022-05-08 | 270.00 | 1898.09 |
Generated 2024-09-20 12:29:56.587 UTC