[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1254 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44933_1 | 6 | 18276 | 312 | 9 | 2022-02-19 | 89.46 | 2022-02-07 | 3578.27 | 1 | SO44933 | 2022-02-14 | 286.26 | 2171.29 | |
SO44940_1 | 6 | 18490 | 311 | 9 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44940 | 2022-02-15 | 286.26 | 2171.29 | |
SO44941_1 | 6 | 18697 | 310 | 9 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44941 | 2022-02-15 | 286.26 | 2171.29 | |
SO44942_1 | 6 | 18701 | 310 | 9 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44942 | 2022-02-15 | 286.26 | 2171.29 | |
SO44943_1 | 6 | 25568 | 330 | 9 | 2022-02-20 | 17.48 | 2022-02-08 | 699.10 | 1 | SO44943 | 2022-02-15 | 55.93 | 413.15 | |
SO44944_1 | 6 | 25707 | 332 | 9 | 2022-02-20 | 17.48 | 2022-02-08 | 699.10 | 1 | SO44944 | 2022-02-15 | 55.93 | 413.15 | |
SO44945_1 | 6 | 25710 | 322 | 9 | 2022-02-20 | 17.48 | 2022-02-08 | 699.10 | 1 | SO44945 | 2022-02-15 | 55.93 | 413.15 | |
SO44946_1 | 6 | 11357 | 349 | 9 | 2022-02-20 | 84.37 | 2022-02-08 | 3374.99 | 1 | SO44946 | 2022-02-15 | 270.00 | 1898.09 | |
SO44947_1 | 6 | 11446 | 346 | 9 | 2022-02-20 | 85.00 | 2022-02-08 | 3399.99 | 1 | SO44947 | 2022-02-15 | 272.00 | 1912.15 | |
SO44955_1 | 6 | 25709 | 342 | 9 | 2022-02-21 | 17.48 | 2022-02-09 | 699.10 | 1 | SO44955 | 2022-02-16 | 55.93 | 413.15 | |
SO44956_1 | 6 | 11449 | 351 | 9 | 2022-02-21 | 84.37 | 2022-02-09 | 3374.99 | 1 | SO44956 | 2022-02-16 | 270.00 | 1898.09 | |
SO44966_1 | 6 | 18458 | 314 | 9 | 2022-02-22 | 89.46 | 2022-02-10 | 3578.27 | 1 | SO44966 | 2022-02-17 | 286.26 | 2171.29 | |
SO44973_1 | 6 | 18482 | 314 | 9 | 2022-02-23 | 89.46 | 2022-02-11 | 3578.27 | 1 | SO44973 | 2022-02-18 | 286.26 | 2171.29 | |
SO44979_1 | 6 | 18469 | 310 | 9 | 2022-02-24 | 89.46 | 2022-02-12 | 3578.27 | 1 | SO44979 | 2022-02-19 | 286.26 | 2171.29 | |
SO44980_1 | 6 | 18699 | 310 | 9 | 2022-02-24 | 89.46 | 2022-02-12 | 3578.27 | 1 | SO44980 | 2022-02-19 | 286.26 | 2171.29 | |
SO44981_1 | 6 | 18462 | 310 | 9 | 2022-02-24 | 89.46 | 2022-02-12 | 3578.27 | 1 | SO44981 | 2022-02-19 | 286.26 | 2171.29 | |
SO44985_1 | 6 | 18692 | 311 | 9 | 2022-02-25 | 89.46 | 2022-02-13 | 3578.27 | 1 | SO44985 | 2022-02-20 | 286.26 | 2171.29 | |
SO44986_1 | 6 | 25708 | 328 | 9 | 2022-02-25 | 17.48 | 2022-02-13 | 699.10 | 1 | SO44986 | 2022-02-20 | 55.93 | 413.15 | |
SO44991_1 | 6 | 18698 | 314 | 9 | 2022-02-26 | 89.46 | 2022-02-14 | 3578.27 | 1 | SO44991 | 2022-02-21 | 286.26 | 2171.29 | |
SO44992_1 | 6 | 18464 | 311 | 9 | 2022-02-26 | 89.46 | 2022-02-14 | 3578.27 | 1 | SO44992 | 2022-02-21 | 286.26 | 2171.29 | |
SO44993_1 | 6 | 11368 | 350 | 9 | 2022-02-26 | 84.37 | 2022-02-14 | 3374.99 | 1 | SO44993 | 2022-02-21 | 270.00 | 1898.09 | |
SO44999_1 | 6 | 18485 | 311 | 9 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO44999 | 2022-02-22 | 286.26 | 2171.29 | |
SO45000_1 | 6 | 18297 | 312 | 9 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO45000 | 2022-02-22 | 286.26 | 2171.29 | |
SO45001_1 | 6 | 18302 | 312 | 9 | 2022-02-27 | 89.46 | 2022-02-15 | 3578.27 | 1 | SO45001 | 2022-02-22 | 286.26 | 2171.29 | |
SO45013_1 | 6 | 18483 | 310 | 9 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45013 | 2022-02-24 | 286.26 | 2171.29 | |
SO45014_1 | 6 | 25705 | 322 | 9 | 2022-03-01 | 17.48 | 2022-02-17 | 699.10 | 1 | SO45014 | 2022-02-24 | 55.93 | 413.15 | |
SO63736_1 | 6 | 11995 | 353 | 9 | 2024-04-10 | 58.00 | 2024-03-29 | 2319.99 | 1 | SO63736 | 2024-04-05 | 185.60 | 1265.62 | |
SO63736_2 | 6 | 11995 | 485 | 9 | 2024-04-10 | 0.55 | 2024-03-29 | 21.98 | 2 | SO63736 | 2024-04-05 | 1.76 | 8.22 | |
SO63736_3 | 6 | 11995 | 472 | 9 | 2024-04-10 | 1.59 | 2024-03-29 | 63.50 | 3 | SO63736 | 2024-04-05 | 5.08 | 23.75 | |
SO63737_1 | 6 | 11034 | 361 | 9 | 2024-04-10 | 57.37 | 2024-03-29 | 2294.99 | 1 | SO63737 | 2024-04-05 | 183.60 | 1251.98 | |
SO63738_1 | 6 | 14030 | 361 | 9 | 2024-04-10 | 57.37 | 2024-03-29 | 2294.99 | 1 | SO63738 | 2024-04-05 | 183.60 | 1251.98 | |
SO63738_2 | 6 | 14030 | 483 | 9 | 2024-04-10 | 3.00 | 2024-03-29 | 120.00 | 2 | SO63738 | 2024-04-05 | 9.60 | 44.88 | |
SO63750_1 | 6 | 11988 | 563 | 9 | 2024-04-10 | 59.60 | 2024-03-29 | 2384.07 | 1 | SO63750 | 2024-04-05 | 190.73 | 1481.94 | |
SO63750_2 | 6 | 11988 | 225 | 9 | 2024-04-10 | 0.22 | 2024-03-29 | 8.99 | 2 | SO63750 | 2024-04-05 | 0.72 | 6.92 | |
SO63751_1 | 6 | 11989 | 575 | 9 | 2024-04-10 | 59.60 | 2024-03-29 | 2384.07 | 1 | SO63751 | 2024-04-05 | 190.73 | 1481.94 | |
SO63752_1 | 6 | 29088 | 567 | 9 | 2024-04-10 | 18.56 | 2024-03-29 | 742.35 | 1 | SO63752 | 2024-04-05 | 59.39 | 461.44 | |
SO63752_2 | 6 | 29088 | 477 | 9 | 2024-04-10 | 0.12 | 2024-03-29 | 4.99 | 2 | SO63752 | 2024-04-05 | 0.40 | 1.87 | |
SO63752_3 | 6 | 29088 | 479 | 9 | 2024-04-10 | 0.22 | 2024-03-29 | 8.99 | 3 | SO63752 | 2024-04-05 | 0.72 | 3.36 | |
SO63753_1 | 6 | 23993 | 605 | 9 | 2024-04-10 | 13.50 | 2024-03-29 | 539.99 | 1 | SO63753 | 2024-04-05 | 43.20 | 343.65 | |
SO63753_2 | 6 | 23993 | 214 | 9 | 2024-04-10 | 0.87 | 2024-03-29 | 34.99 | 2 | SO63753 | 2024-04-05 | 2.80 | 13.09 | |
SO63753_3 | 6 | 23993 | 488 | 9 | 2024-04-10 | 1.35 | 2024-03-29 | 53.99 | 3 | SO63753 | 2024-04-05 | 4.32 | 41.57 | |
SO63754_1 | 6 | 23998 | 605 | 9 | 2024-04-10 | 13.50 | 2024-03-29 | 539.99 | 1 | SO63754 | 2024-04-05 | 43.20 | 343.65 | |
SO63754_2 | 6 | 23998 | 217 | 9 | 2024-04-10 | 0.87 | 2024-03-29 | 34.99 | 2 | SO63754 | 2024-04-05 | 2.80 | 13.09 | |
SO63755_1 | 6 | 12010 | 563 | 9 | 2024-04-10 | 59.60 | 2024-03-29 | 2384.07 | 1 | SO63755 | 2024-04-05 | 190.73 | 1481.94 | |
SO63755_2 | 6 | 12010 | 222 | 9 | 2024-04-10 | 0.87 | 2024-03-29 | 34.99 | 2 | SO63755 | 2024-04-05 | 2.80 | 13.09 | |
SO63755_3 | 6 | 12010 | 465 | 9 | 2024-04-10 | 0.61 | 2024-03-29 | 24.49 | 3 | SO63755 | 2024-04-05 | 1.96 | 9.16 | |
SO63756_1 | 6 | 12039 | 575 | 9 | 2024-04-10 | 59.60 | 2024-03-29 | 2384.07 | 1 | SO63756 | 2024-04-05 | 190.73 | 1481.94 | |
SO63756_2 | 6 | 12039 | 217 | 9 | 2024-04-10 | 0.87 | 2024-03-29 | 34.99 | 2 | SO63756 | 2024-04-05 | 2.80 | 13.09 | |
SO63756_3 | 6 | 12039 | 463 | 9 | 2024-04-10 | 0.61 | 2024-03-29 | 24.49 | 3 | SO63756 | 2024-04-05 | 1.96 | 9.16 | |
SO63758_1 | 6 | 20621 | 378 | 9 | 2024-04-11 | 61.08 | 2024-03-30 | 2443.35 | 1 | SO63758 | 2024-04-06 | 195.47 | 1554.95 | |
SO63758_2 | 6 | 20621 | 540 | 9 | 2024-04-11 | 0.82 | 2024-03-30 | 32.60 | 2 | SO63758 | 2024-04-06 | 2.61 | 12.19 | |
SO63758_3 | 6 | 20621 | 529 | 9 | 2024-04-11 | 0.10 | 2024-03-30 | 3.99 | 3 | SO63758 | 2024-04-06 | 0.32 | 1.49 | |
SO63758_4 | 6 | 20621 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 4 | SO63758 | 2024-04-06 | 2.80 | 13.09 | |
SO63758_5 | 6 | 20621 | 465 | 9 | 2024-04-11 | 0.61 | 2024-03-30 | 24.49 | 5 | SO63758 | 2024-04-06 | 1.96 | 9.16 | |
SO63759_1 | 6 | 15025 | 539 | 9 | 2024-04-11 | 0.62 | 2024-03-30 | 24.99 | 1 | SO63759 | 2024-04-06 | 2.00 | 9.35 | |
SO63760_1 | 6 | 16606 | 536 | 9 | 2024-04-11 | 0.75 | 2024-03-30 | 29.99 | 1 | SO63760 | 2024-04-06 | 2.40 | 11.22 | |
SO63760_2 | 6 | 16606 | 480 | 2 | 9 | 2024-04-11 | 0.06 | 2024-03-30 | 2.29 | 2 | SO63760 | 2024-04-06 | 0.18 | 0.86 |
SO63761_1 | 6 | 24380 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 1 | SO63761 | 2024-04-06 | 0.40 | 1.87 | |
SO63762_1 | 6 | 12665 | 528 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 1 | SO63762 | 2024-04-06 | 0.40 | 1.87 | |
SO63762_2 | 6 | 12665 | 480 | 2 | 9 | 2024-04-11 | 0.06 | 2024-03-30 | 2.29 | 2 | SO63762 | 2024-04-06 | 0.18 | 0.86 |
SO63796_1 | 6 | 24004 | 584 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63796 | 2024-04-06 | 43.20 | 343.65 | |
SO63796_2 | 6 | 24004 | 479 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO63796 | 2024-04-06 | 0.72 | 3.36 | |
SO63796_3 | 6 | 24004 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63796 | 2024-04-06 | 0.40 | 1.87 | |
SO63796_4 | 6 | 24004 | 225 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 4 | SO63796 | 2024-04-06 | 0.72 | 6.92 | |
SO63797_1 | 6 | 24163 | 584 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63797 | 2024-04-06 | 43.20 | 343.65 | |
SO63797_2 | 6 | 24163 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63797 | 2024-04-06 | 2.80 | 13.09 | |
SO63798_1 | 6 | 25242 | 386 | 9 | 2024-04-11 | 28.01 | 2024-03-30 | 1120.49 | 1 | SO63798 | 2024-04-06 | 89.64 | 713.08 | |
SO63799_1 | 6 | 21173 | 376 | 9 | 2024-04-11 | 61.08 | 2024-03-30 | 2443.35 | 1 | SO63799 | 2024-04-06 | 195.47 | 1554.95 | |
SO63799_2 | 6 | 21173 | 214 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63799 | 2024-04-06 | 2.80 | 13.09 | |
SO63800_1 | 6 | 13971 | 359 | 9 | 2024-04-11 | 57.37 | 2024-03-30 | 2294.99 | 1 | SO63800 | 2024-04-06 | 183.60 | 1251.98 | |
SO63800_2 | 6 | 13971 | 478 | 9 | 2024-04-11 | 0.25 | 2024-03-30 | 9.99 | 2 | SO63800 | 2024-04-06 | 0.80 | 3.74 | |
SO63800_3 | 6 | 13971 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63800 | 2024-04-06 | 0.40 | 1.87 | |
SO63801_1 | 6 | 14020 | 353 | 9 | 2024-04-11 | 58.00 | 2024-03-30 | 2319.99 | 1 | SO63801 | 2024-04-06 | 185.60 | 1265.62 | |
SO63801_2 | 6 | 14020 | 480 | 9 | 2024-04-11 | 0.06 | 2024-03-30 | 2.29 | 2 | SO63801 | 2024-04-06 | 0.18 | 0.86 | |
SO63817_1 | 6 | 11952 | 576 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63817 | 2024-04-06 | 190.73 | 1481.94 | |
SO63817_2 | 6 | 11952 | 479 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO63817 | 2024-04-06 | 0.72 | 3.36 | |
SO63817_3 | 6 | 11952 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63817 | 2024-04-06 | 0.40 | 1.87 | |
SO63818_1 | 6 | 27867 | 573 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63818 | 2024-04-06 | 190.73 | 1481.94 | |
SO63818_2 | 6 | 27867 | 465 | 9 | 2024-04-11 | 0.61 | 2024-03-30 | 24.49 | 2 | SO63818 | 2024-04-06 | 1.96 | 9.16 | |
SO63818_3 | 6 | 27867 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 3 | SO63818 | 2024-04-06 | 2.80 | 13.09 | |
SO63819_1 | 6 | 11100 | 563 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63819 | 2024-04-06 | 190.73 | 1481.94 | |
SO63819_2 | 6 | 11100 | 479 | 9 | 2024-04-11 | 0.22 | 2024-03-30 | 8.99 | 2 | SO63819 | 2024-04-06 | 0.72 | 3.36 | |
SO63819_3 | 6 | 11100 | 477 | 9 | 2024-04-11 | 0.12 | 2024-03-30 | 4.99 | 3 | SO63819 | 2024-04-06 | 0.40 | 1.87 | |
SO63820_1 | 6 | 11967 | 574 | 9 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63820 | 2024-04-06 | 190.73 | 1481.94 | |
SO63820_2 | 6 | 11967 | 217 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63820 | 2024-04-06 | 2.80 | 13.09 | |
SO63821_1 | 6 | 29067 | 584 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63821 | 2024-04-06 | 43.20 | 343.65 | |
SO63822_1 | 6 | 29096 | 604 | 9 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63822 | 2024-04-06 | 43.20 | 343.65 | |
SO63822_2 | 6 | 29096 | 214 | 9 | 2024-04-11 | 0.87 | 2024-03-30 | 34.99 | 2 | SO63822 | 2024-04-06 | 2.80 | 13.09 | |
SO63825_1 | 6 | 12992 | 535 | 9 | 2024-04-12 | 0.62 | 2024-03-31 | 24.99 | 1 | SO63825 | 2024-04-07 | 2.00 | 9.35 | |
SO63825_2 | 6 | 12992 | 528 | 9 | 2024-04-12 | 0.12 | 2024-03-31 | 4.99 | 2 | SO63825 | 2024-04-07 | 0.40 | 1.87 | |
SO55817_3 | 6 | 14237 | 480 | 9 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 3 | SO55817 | 2023-12-06 | 0.18 | 0.86 | |
SO55818_1 | 6 | 20419 | 477 | 9 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55818 | 2023-12-06 | 0.40 | 1.87 | |
SO55819_1 | 6 | 15216 | 477 | 9 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55819 | 2023-12-06 | 0.40 | 1.87 | |
SO55819_2 | 6 | 15216 | 478 | 9 | 2023-12-11 | 0.25 | 2023-11-29 | 9.99 | 2 | SO55819 | 2023-12-06 | 0.80 | 3.74 | |
SO55819_3 | 6 | 15216 | 214 | 9 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 3 | SO55819 | 2023-12-06 | 2.80 | 13.09 | |
SO55819_4 | 6 | 15216 | 465 | 9 | 2023-12-11 | 0.61 | 2023-11-29 | 24.49 | 4 | SO55819 | 2023-12-06 | 1.96 | 9.16 | |
SO55820_1 | 6 | 15810 | 540 | 9 | 2023-12-11 | 0.82 | 2023-11-29 | 32.60 | 1 | SO55820 | 2023-12-06 | 2.61 | 12.19 | |
SO55820_2 | 6 | 15810 | 480 | 9 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 2 | SO55820 | 2023-12-06 | 0.18 | 0.86 | |
SO55821_1 | 6 | 13149 | 217 | 9 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 1 | SO55821 | 2023-12-06 | 2.80 | 13.09 | |
SO55858_1 | 6 | 29292 | 225 | 9 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 1 | SO55858 | 2023-12-06 | 0.72 | 6.92 | |
SO55858_2 | 6 | 29292 | 561 | 9 | 2023-12-11 | 59.60 | 2023-11-29 | 2384.07 | 2 | SO55858 | 2023-12-06 | 190.73 | 1481.94 | |
SO55859_1 | 6 | 12342 | 353 | 9 | 2023-12-11 | 58.00 | 2023-11-29 | 2319.99 | 1 | SO55859 | 2023-12-06 | 185.60 | 1265.62 | |
SO55859_2 | 6 | 12342 | 478 | 9 | 2023-12-11 | 0.25 | 2023-11-29 | 9.99 | 2 | SO55859 | 2023-12-06 | 0.80 | 3.74 | |
SO55859_3 | 6 | 12342 | 477 | 9 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 3 | SO55859 | 2023-12-06 | 0.40 | 1.87 | |
SO55859_4 | 6 | 12342 | 222 | 9 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 4 | SO55859 | 2023-12-06 | 2.80 | 13.09 | |
SO55860_1 | 6 | 11112 | 355 | 9 | 2023-12-11 | 58.00 | 2023-11-29 | 2319.99 | 1 | SO55860 | 2023-12-06 | 185.60 | 1265.62 | |
SO55860_2 | 6 | 11112 | 485 | 9 | 2023-12-11 | 0.55 | 2023-11-29 | 21.98 | 2 | SO55860 | 2023-12-06 | 1.76 | 8.22 | |
SO55860_3 | 6 | 11112 | 486 | 9 | 2023-12-11 | 3.98 | 2023-11-29 | 159.00 | 3 | SO55860 | 2023-12-06 | 12.72 | 59.47 | |
SO55867_1 | 6 | 16522 | 384 | 9 | 2023-12-12 | 28.01 | 2023-11-30 | 1120.49 | 1 | SO55867 | 2023-12-07 | 89.64 | 713.08 | |
SO55871_1 | 6 | 15261 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 1 | SO55871 | 2023-12-07 | 0.32 | 1.49 | |
SO55871_2 | 6 | 15261 | 539 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 2 | SO55871 | 2023-12-07 | 2.00 | 9.35 | |
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 |
Generated 2024-09-20 20:36:31.830 UTC