[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1351 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46287_1 | 100 | 12026 | 312 | 4 | 2022-09-19 | 89.46 | 2022-09-07 | 3578.27 | 1 | SO46287 | 2022-09-14 | 286.26 | 2171.29 | |
SO69675_2 | 100 | 23004 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69675 | 2024-08-22 | 0.40 | 1.87 | |
SO46290_1 | 100 | 26066 | 351 | 4 | 2022-09-19 | 84.37 | 2022-09-07 | 3374.99 | 1 | SO46290 | 2022-09-14 | 270.00 | 1898.09 | |
SO69675_3 | 100 | 23004 | 485 | 4 | 2024-08-27 | 0.55 | 2024-08-15 | 21.98 | 3 | SO69675 | 2024-08-22 | 1.76 | 8.22 | |
SO46296_1 | 100 | 12170 | 314 | 4 | 2022-09-20 | 89.46 | 2022-09-08 | 3578.27 | 1 | SO46296 | 2022-09-15 | 286.26 | 2171.29 | |
SO69676_1 | 100 | 23550 | 536 | 4 | 2024-08-27 | 0.75 | 2024-08-15 | 29.99 | 1 | SO69676 | 2024-08-22 | 2.40 | 11.22 | |
SO46298_1 | 100 | 12071 | 314 | 4 | 2022-09-20 | 89.46 | 2022-09-08 | 3578.27 | 1 | SO46298 | 2022-09-15 | 286.26 | 2171.29 | |
SO69676_2 | 100 | 23550 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69676 | 2024-08-22 | 0.40 | 1.87 | |
SO46306_1 | 100 | 12164 | 311 | 4 | 2022-09-22 | 89.46 | 2022-09-10 | 3578.27 | 1 | SO46306 | 2022-09-17 | 286.26 | 2171.29 | |
SO69676_3 | 100 | 23550 | 485 | 4 | 2024-08-27 | 0.55 | 2024-08-15 | 21.98 | 3 | SO69676 | 2024-08-22 | 1.76 | 8.22 | |
SO46312_1 | 100 | 12153 | 314 | 4 | 2022-09-24 | 89.46 | 2022-09-12 | 3578.27 | 1 | SO46312 | 2022-09-19 | 286.26 | 2171.29 | |
SO69676_4 | 100 | 23550 | 487 | 4 | 2024-08-27 | 1.37 | 2024-08-15 | 54.99 | 4 | SO69676 | 2024-08-22 | 4.40 | 20.57 | |
SO46314_1 | 100 | 12112 | 312 | 4 | 2022-09-24 | 89.46 | 2022-09-12 | 3578.27 | 1 | SO46314 | 2022-09-19 | 286.26 | 2171.29 | |
SO69679_1 | 100 | 21420 | 478 | 4 | 2024-08-27 | 0.25 | 2024-08-15 | 9.99 | 1 | SO69679 | 2024-08-22 | 0.80 | 3.74 | |
SO46316_1 | 100 | 26083 | 351 | 4 | 2022-09-24 | 84.37 | 2022-09-12 | 3374.99 | 1 | SO46316 | 2022-09-19 | 270.00 | 1898.09 | |
SO69679_2 | 100 | 21420 | 477 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69679 | 2024-08-22 | 0.40 | 1.87 | |
SO46317_1 | 100 | 14884 | 334 | 4 | 2022-09-24 | 17.48 | 2022-09-12 | 699.10 | 1 | SO46317 | 2022-09-19 | 55.93 | 413.15 | |
SO69679_3 | 100 | 21420 | 472 | 4 | 2024-08-27 | 1.59 | 2024-08-15 | 63.50 | 3 | SO69679 | 2024-08-22 | 5.08 | 23.75 | |
SO46319_1 | 100 | 12103 | 311 | 4 | 2022-09-25 | 89.46 | 2022-09-13 | 3578.27 | 1 | SO46319 | 2022-09-20 | 286.26 | 2171.29 | |
SO69680_1 | 100 | 23006 | 478 | 4 | 2024-08-27 | 0.25 | 2024-08-15 | 9.99 | 1 | SO69680 | 2024-08-22 | 0.80 | 3.74 | |
SO46320_1 | 100 | 26084 | 351 | 4 | 2022-09-25 | 84.37 | 2022-09-13 | 3374.99 | 1 | SO46320 | 2022-09-20 | 270.00 | 1898.09 | |
SO69680_2 | 100 | 23006 | 477 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69680 | 2024-08-22 | 0.40 | 1.87 | |
SO46390_1 | 100 | 12440 | 313 | 4 | 2022-09-26 | 89.46 | 2022-09-14 | 3578.27 | 1 | SO46390 | 2022-09-21 | 286.26 | 2171.29 | |
SO69680_3 | 100 | 23006 | 463 | 4 | 2024-08-27 | 0.61 | 2024-08-15 | 24.49 | 3 | SO69680 | 2024-08-22 | 1.96 | 9.16 | |
SO46396_1 | 100 | 12442 | 311 | 4 | 2022-09-27 | 89.46 | 2022-09-15 | 3578.27 | 1 | SO46396 | 2022-09-22 | 286.26 | 2171.29 | |
SO69682_1 | 100 | 20292 | 475 | 4 | 2024-08-27 | 1.75 | 2024-08-15 | 69.99 | 1 | SO69682 | 2024-08-22 | 5.60 | 26.18 | |
SO46414_1 | 100 | 15006 | 338 | 4 | 2022-09-29 | 17.48 | 2022-09-17 | 699.10 | 1 | SO46414 | 2022-09-24 | 55.93 | 413.15 | |
SO69682_2 | 100 | 20292 | 231 | 4 | 2024-08-27 | 1.25 | 2024-08-15 | 49.99 | 2 | SO69682 | 2024-08-22 | 4.00 | 38.49 | |
SO46416_1 | 100 | 12181 | 313 | 4 | 2022-09-30 | 89.46 | 2022-09-18 | 3578.27 | 1 | SO46416 | 2022-09-25 | 286.26 | 2171.29 | |
SO69686_1 | 100 | 16120 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69686 | 2024-08-22 | 0.40 | 1.87 | |
SO46417_1 | 100 | 12441 | 314 | 4 | 2022-09-30 | 89.46 | 2022-09-18 | 3578.27 | 1 | SO46417 | 2022-09-25 | 286.26 | 2171.29 | |
SO69686_2 | 100 | 16120 | 480 | 2 | 4 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 2 | SO69686 | 2024-08-22 | 0.18 | 0.86 |
SO46422_1 | 100 | 12884 | 311 | 4 | 2022-10-01 | 89.46 | 2022-09-19 | 3578.27 | 1 | SO46422 | 2022-09-26 | 286.26 | 2171.29 | |
SO69687_1 | 100 | 15316 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69687 | 2024-08-22 | 0.40 | 1.87 | |
SO46423_1 | 100 | 12362 | 313 | 4 | 2022-10-01 | 89.46 | 2022-09-19 | 3578.27 | 1 | SO46423 | 2022-09-26 | 286.26 | 2171.29 | |
SO69687_2 | 100 | 15316 | 480 | 2 | 4 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 2 | SO69687 | 2024-08-22 | 0.18 | 0.86 |
SO46424_1 | 100 | 12435 | 312 | 4 | 2022-10-01 | 89.46 | 2022-09-19 | 3578.27 | 1 | SO46424 | 2022-09-26 | 286.26 | 2171.29 | |
SO69688_1 | 100 | 14615 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69688 | 2024-08-22 | 0.40 | 1.87 | |
SO46426_1 | 100 | 26107 | 344 | 4 | 2022-10-01 | 85.00 | 2022-09-19 | 3399.99 | 1 | SO46426 | 2022-09-26 | 272.00 | 1912.15 | |
SO69688_2 | 100 | 14615 | 478 | 4 | 2024-08-27 | 0.25 | 2024-08-15 | 9.99 | 2 | SO69688 | 2024-08-22 | 0.80 | 3.74 | |
SO46432_1 | 100 | 15016 | 342 | 4 | 2022-10-02 | 17.48 | 2022-09-20 | 699.10 | 1 | SO46432 | 2022-09-27 | 55.93 | 413.15 | |
SO69688_3 | 100 | 14615 | 477 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 3 | SO69688 | 2024-08-22 | 0.40 | 1.87 | |
SO46438_1 | 100 | 12174 | 313 | 4 | 2022-10-03 | 89.46 | 2022-09-21 | 3578.27 | 1 | SO46438 | 2022-09-28 | 286.26 | 2171.29 | |
SO69688_4 | 100 | 14615 | 225 | 4 | 2024-08-27 | 0.22 | 2024-08-15 | 8.99 | 4 | SO69688 | 2024-08-22 | 0.72 | 6.92 | |
SO46450_1 | 100 | 12446 | 314 | 4 | 2022-10-05 | 89.46 | 2022-09-23 | 3578.27 | 1 | SO46450 | 2022-09-30 | 286.26 | 2171.29 | |
SO69690_1 | 100 | 14389 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69690 | 2024-08-22 | 0.40 | 1.87 | |
SO46451_1 | 100 | 12709 | 310 | 4 | 2022-10-05 | 89.46 | 2022-09-23 | 3578.27 | 1 | SO46451 | 2022-09-30 | 286.26 | 2171.29 | |
SO69690_2 | 100 | 14389 | 480 | 2 | 4 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 2 | SO69690 | 2024-08-22 | 0.18 | 0.86 |
SO46458_1 | 100 | 12771 | 310 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46458 | 2022-10-01 | 286.26 | 2171.29 | |
SO69691_1 | 100 | 14499 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69691 | 2024-08-22 | 0.40 | 1.87 | |
SO46459_1 | 100 | 12190 | 313 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46459 | 2022-10-01 | 286.26 | 2171.29 | |
SO69691_2 | 100 | 14499 | 480 | 4 | 2024-08-27 | 0.06 | 2024-08-15 | 2.29 | 2 | SO69691 | 2024-08-22 | 0.18 | 0.86 | |
SO46460_1 | 100 | 12438 | 312 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46460 | 2022-10-01 | 286.26 | 2171.29 | |
SO69691_3 | 100 | 14499 | 484 | 4 | 2024-08-27 | 0.20 | 2024-08-15 | 7.95 | 3 | SO69691 | 2024-08-22 | 0.64 | 2.97 | |
SO46464_1 | 100 | 12885 | 310 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46464 | 2022-10-02 | 286.26 | 2171.29 | |
SO69692_1 | 100 | 14595 | 528 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 1 | SO69692 | 2024-08-22 | 0.40 | 1.87 | |
SO46465_1 | 100 | 12898 | 311 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46465 | 2022-10-02 | 286.26 | 2171.29 | |
SO69692_2 | 100 | 14595 | 214 | 4 | 2024-08-27 | 0.87 | 2024-08-15 | 34.99 | 2 | SO69692 | 2024-08-22 | 2.80 | 13.09 | |
SO46479_1 | 100 | 12768 | 310 | 4 | 2022-10-09 | 89.46 | 2022-09-27 | 3578.27 | 1 | SO46479 | 2022-10-04 | 286.26 | 2171.29 | |
SO69701_1 | 100 | 16141 | 599 | 4 | 2024-08-27 | 13.50 | 2024-08-15 | 539.99 | 1 | SO69701 | 2024-08-22 | 43.20 | 294.58 | |
SO46480_1 | 100 | 26114 | 347 | 4 | 2022-10-09 | 85.00 | 2022-09-27 | 3399.99 | 1 | SO46480 | 2022-10-04 | 272.00 | 1912.15 | |
SO69701_2 | 100 | 16141 | 477 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69701 | 2024-08-22 | 0.40 | 1.87 | |
SO46483_1 | 100 | 12883 | 312 | 4 | 2022-10-10 | 89.46 | 2022-09-28 | 3578.27 | 1 | SO46483 | 2022-10-05 | 286.26 | 2171.29 | |
SO69701_3 | 100 | 16141 | 478 | 4 | 2024-08-27 | 0.25 | 2024-08-15 | 9.99 | 3 | SO69701 | 2024-08-22 | 0.80 | 3.74 | |
SO46485_1 | 100 | 12755 | 313 | 4 | 2022-10-10 | 89.46 | 2022-09-28 | 3578.27 | 1 | SO46485 | 2022-10-05 | 286.26 | 2171.29 | |
SO69701_4 | 100 | 16141 | 222 | 4 | 2024-08-27 | 0.87 | 2024-08-15 | 34.99 | 4 | SO69701 | 2024-08-22 | 2.80 | 13.09 | |
SO46487_1 | 100 | 14913 | 338 | 4 | 2022-10-10 | 17.48 | 2022-09-28 | 699.10 | 1 | SO46487 | 2022-10-05 | 55.93 | 413.15 | |
SO69704_1 | 100 | 16961 | 363 | 4 | 2024-08-27 | 57.37 | 2024-08-15 | 2294.99 | 1 | SO69704 | 2024-08-22 | 183.60 | 1251.98 | |
SO46490_1 | 100 | 12189 | 313 | 4 | 2022-10-11 | 89.46 | 2022-09-29 | 3578.27 | 1 | SO46490 | 2022-10-06 | 286.26 | 2171.29 | |
SO69704_2 | 100 | 16961 | 477 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69704 | 2024-08-22 | 0.40 | 1.87 | |
SO46498_1 | 100 | 12881 | 313 | 4 | 2022-10-13 | 89.46 | 2022-10-01 | 3578.27 | 1 | SO46498 | 2022-10-08 | 286.26 | 2171.29 | |
SO69704_3 | 100 | 16961 | 481 | 4 | 2024-08-27 | 0.22 | 2024-08-15 | 8.99 | 3 | SO69704 | 2024-08-22 | 0.72 | 3.36 | |
SO46504_1 | 100 | 15005 | 342 | 4 | 2022-10-13 | 17.48 | 2022-10-01 | 699.10 | 1 | SO46504 | 2022-10-08 | 55.93 | 413.15 | |
SO69704_4 | 100 | 16961 | 478 | 4 | 2024-08-27 | 0.25 | 2024-08-15 | 9.99 | 4 | SO69704 | 2024-08-22 | 0.80 | 3.74 | |
SO46509_1 | 100 | 12886 | 310 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46509 | 2022-10-09 | 286.26 | 2171.29 | |
SO69705_1 | 100 | 15289 | 590 | 4 | 2024-08-27 | 19.24 | 2024-08-15 | 769.49 | 1 | SO69705 | 2024-08-22 | 61.56 | 419.78 | |
SO46512_1 | 100 | 12209 | 311 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46512 | 2022-10-09 | 286.26 | 2171.29 | |
SO69705_2 | 100 | 15289 | 485 | 4 | 2024-08-27 | 0.55 | 2024-08-15 | 21.98 | 2 | SO69705 | 2024-08-22 | 1.76 | 8.22 | |
SO46521_1 | 100 | 12770 | 310 | 4 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46521 | 2022-10-10 | 286.26 | 2171.29 | |
SO69711_1 | 100 | 23739 | 606 | 4 | 2024-08-27 | 13.50 | 2024-08-15 | 539.99 | 1 | SO69711 | 2024-08-22 | 43.20 | 343.65 | |
SO46522_1 | 100 | 12882 | 312 | 4 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46522 | 2022-10-10 | 286.26 | 2171.29 | |
SO69711_2 | 100 | 23739 | 529 | 4 | 2024-08-27 | 0.10 | 2024-08-15 | 3.99 | 2 | SO69711 | 2024-08-22 | 0.32 | 1.49 | |
SO46523_1 | 100 | 12756 | 313 | 4 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46523 | 2022-10-10 | 286.26 | 2171.29 | |
SO69711_3 | 100 | 23739 | 538 | 4 | 2024-08-27 | 0.54 | 2024-08-15 | 21.49 | 3 | SO69711 | 2024-08-22 | 1.72 | 8.04 | |
SO46524_1 | 100 | 26111 | 351 | 4 | 2022-10-15 | 84.37 | 2022-10-03 | 3374.99 | 1 | SO46524 | 2022-10-10 | 270.00 | 1898.09 | |
SO69711_4 | 100 | 23739 | 484 | 4 | 2024-08-27 | 0.20 | 2024-08-15 | 7.95 | 4 | SO69711 | 2024-08-22 | 0.64 | 2.97 | |
SO46533_1 | 100 | 26106 | 348 | 4 | 2022-10-16 | 84.37 | 2022-10-04 | 3374.99 | 1 | SO46533 | 2022-10-11 | 270.00 | 1898.09 | |
SO69713_1 | 100 | 21699 | 382 | 4 | 2024-08-27 | 28.01 | 2024-08-15 | 1120.49 | 1 | SO69713 | 2024-08-22 | 89.64 | 713.08 | |
SO46538_1 | 100 | 12774 | 310 | 4 | 2022-10-17 | 89.46 | 2022-10-05 | 3578.27 | 1 | SO46538 | 2022-10-12 | 286.26 | 2171.29 | |
SO69713_2 | 100 | 21699 | 477 | 4 | 2024-08-27 | 0.12 | 2024-08-15 | 4.99 | 2 | SO69713 | 2024-08-22 | 0.40 | 1.87 | |
SO46539_1 | 100 | 12200 | 314 | 4 | 2022-10-17 | 89.46 | 2022-10-05 | 3578.27 | 1 | SO46539 | 2022-10-12 | 286.26 | 2171.29 | |
SO69713_3 | 100 | 21699 | 479 | 4 | 2024-08-27 | 0.22 | 2024-08-15 | 8.99 | 3 | SO69713 | 2024-08-22 | 0.72 | 3.36 | |
SO46550_1 | 100 | 26097 | 350 | 4 | 2022-10-18 | 84.37 | 2022-10-06 | 3374.99 | 1 | SO46550 | 2022-10-13 | 270.00 | 1898.09 | |
SO69713_4 | 100 | 21699 | 465 | 4 | 2024-08-27 | 0.61 | 2024-08-15 | 24.49 | 4 | SO69713 | 2024-08-22 | 1.96 | 9.16 | |
SO46551_1 | 100 | 14914 | 330 | 4 | 2022-10-18 | 17.48 | 2022-10-06 | 699.10 | 1 | SO46551 | 2022-10-13 | 55.93 | 413.15 | |
SO69714_1 | 100 | 21700 | 386 | 4 | 2024-08-27 | 28.01 | 2024-08-15 | 1120.49 | 1 | SO69714 | 2024-08-22 | 89.64 | 713.08 |
Generated 2024-11-13 08:48:07.873 UTC