[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1657 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46254_1 | 100 | 12096 | 310 | 4 | 2022-07-22 | 89.46 | 2022-07-10 | 3578.27 | 1 | SO46254 | 2022-07-17 | 286.26 | 2171.29 | |
SO69742_2 | 100 | 25205 | 528 | 4 | 2024-07-05 | 0.12 | 2024-06-23 | 4.99 | 2 | SO69742 | 2024-06-30 | 0.40 | 1.87 | |
SO46271_1 | 100 | 12172 | 313 | 4 | 2022-07-25 | 89.46 | 2022-07-13 | 3578.27 | 1 | SO46271 | 2022-07-20 | 286.26 | 2171.29 | |
SO69742_3 | 100 | 25205 | 480 | 2 | 4 | 2024-07-05 | 0.06 | 2024-06-23 | 2.29 | 3 | SO69742 | 2024-06-30 | 0.18 | 0.86 |
SO46273_1 | 100 | 26060 | 351 | 4 | 2022-07-25 | 84.37 | 2022-07-13 | 3374.99 | 1 | SO46273 | 2022-07-20 | 270.00 | 1898.09 | |
SO69743_1 | 100 | 28048 | 538 | 4 | 2024-07-05 | 0.54 | 2024-06-23 | 21.49 | 1 | SO69743 | 2024-06-30 | 1.72 | 8.04 | |
SO46274_1 | 100 | 26070 | 350 | 4 | 2022-07-25 | 84.37 | 2022-07-13 | 3374.99 | 1 | SO46274 | 2022-07-20 | 270.00 | 1898.09 | |
SO69743_2 | 100 | 28048 | 225 | 4 | 2024-07-05 | 0.22 | 2024-06-23 | 8.99 | 2 | SO69743 | 2024-06-30 | 0.72 | 6.92 | |
SO46281_1 | 100 | 26057 | 347 | 4 | 2022-07-26 | 85.00 | 2022-07-14 | 3399.99 | 1 | SO46281 | 2022-07-21 | 272.00 | 1912.15 | |
SO69743_3 | 100 | 28048 | 489 | 4 | 2024-07-05 | 1.35 | 2024-06-23 | 53.99 | 3 | SO69743 | 2024-06-30 | 4.32 | 41.57 | |
SO46282_1 | 100 | 26058 | 345 | 4 | 2022-07-26 | 85.00 | 2022-07-14 | 3399.99 | 1 | SO46282 | 2022-07-21 | 272.00 | 1912.15 | |
SO69744_1 | 100 | 24971 | 540 | 4 | 2024-07-05 | 0.82 | 2024-06-23 | 32.60 | 1 | SO69744 | 2024-06-30 | 2.61 | 12.19 | |
SO46283_1 | 100 | 26093 | 351 | 4 | 2022-07-26 | 84.37 | 2022-07-14 | 3374.99 | 1 | SO46283 | 2022-07-21 | 270.00 | 1898.09 | |
SO69744_2 | 100 | 24971 | 483 | 4 | 2024-07-05 | 3.00 | 2024-06-23 | 120.00 | 2 | SO69744 | 2024-06-30 | 9.60 | 44.88 | |
SO46287_1 | 100 | 12026 | 312 | 4 | 2022-07-27 | 89.46 | 2022-07-15 | 3578.27 | 1 | SO46287 | 2022-07-22 | 286.26 | 2171.29 | |
SO69748_1 | 100 | 21145 | 478 | 4 | 2024-07-05 | 0.25 | 2024-06-23 | 9.99 | 1 | SO69748 | 2024-06-30 | 0.80 | 3.74 | |
SO46290_1 | 100 | 26066 | 351 | 4 | 2022-07-27 | 84.37 | 2022-07-15 | 3374.99 | 1 | SO46290 | 2022-07-22 | 270.00 | 1898.09 | |
SO69748_2 | 100 | 21145 | 477 | 4 | 2024-07-05 | 0.12 | 2024-06-23 | 4.99 | 2 | SO69748 | 2024-06-30 | 0.40 | 1.87 | |
SO46296_1 | 100 | 12170 | 314 | 4 | 2022-07-28 | 89.46 | 2022-07-16 | 3578.27 | 1 | SO46296 | 2022-07-23 | 286.26 | 2171.29 | |
SO69748_3 | 100 | 21145 | 487 | 4 | 2024-07-05 | 1.37 | 2024-06-23 | 54.99 | 3 | SO69748 | 2024-06-30 | 4.40 | 20.57 | |
SO46298_1 | 100 | 12071 | 314 | 4 | 2022-07-28 | 89.46 | 2022-07-16 | 3578.27 | 1 | SO46298 | 2022-07-23 | 286.26 | 2171.29 | |
SO69749_1 | 100 | 20325 | 225 | 4 | 2024-07-05 | 0.22 | 2024-06-23 | 8.99 | 1 | SO69749 | 2024-06-30 | 0.72 | 6.92 | |
SO46306_1 | 100 | 12164 | 311 | 4 | 2022-07-30 | 89.46 | 2022-07-18 | 3578.27 | 1 | SO46306 | 2022-07-25 | 286.26 | 2171.29 | |
SO69749_2 | 100 | 20325 | 474 | 4 | 2024-07-05 | 1.75 | 2024-06-23 | 69.99 | 2 | SO69749 | 2024-06-30 | 5.60 | 26.18 | |
SO46312_1 | 100 | 12153 | 314 | 4 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO46312 | 2022-07-27 | 286.26 | 2171.29 | |
SO69761_1 | 100 | 18068 | 353 | 2 | 4 | 2024-07-05 | 58.00 | 2024-06-23 | 2319.99 | 1 | SO69761 | 2024-06-30 | 185.60 | 1265.62 |
SO46314_1 | 100 | 12112 | 312 | 4 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO46314 | 2022-07-27 | 286.26 | 2171.29 | |
SO69761_2 | 100 | 18068 | 483 | 4 | 2024-07-05 | 3.00 | 2024-06-23 | 120.00 | 2 | SO69761 | 2024-06-30 | 9.60 | 44.88 | |
SO46316_1 | 100 | 26083 | 351 | 4 | 2022-08-01 | 84.37 | 2022-07-20 | 3374.99 | 1 | SO46316 | 2022-07-27 | 270.00 | 1898.09 | |
SO69762_1 | 100 | 15309 | 588 | 2 | 4 | 2024-07-05 | 19.24 | 2024-06-23 | 769.49 | 1 | SO69762 | 2024-06-30 | 61.56 | 419.78 |
SO46317_1 | 100 | 14884 | 334 | 4 | 2022-08-01 | 17.48 | 2022-07-20 | 699.10 | 1 | SO46317 | 2022-07-27 | 55.93 | 413.15 | |
SO69762_2 | 100 | 15309 | 476 | 4 | 2024-07-05 | 1.75 | 2024-06-23 | 69.99 | 2 | SO69762 | 2024-06-30 | 5.60 | 26.18 | |
SO46319_1 | 100 | 12103 | 311 | 4 | 2022-08-02 | 89.46 | 2022-07-21 | 3578.27 | 1 | SO46319 | 2022-07-28 | 286.26 | 2171.29 | |
SO69763_1 | 100 | 15312 | 588 | 4 | 2024-07-05 | 19.24 | 2024-06-23 | 769.49 | 1 | SO69763 | 2024-06-30 | 61.56 | 419.78 | |
SO46320_1 | 100 | 26084 | 351 | 4 | 2022-08-02 | 84.37 | 2022-07-21 | 3374.99 | 1 | SO46320 | 2022-07-28 | 270.00 | 1898.09 | |
SO69763_2 | 100 | 15312 | 476 | 4 | 2024-07-05 | 1.75 | 2024-06-23 | 69.99 | 2 | SO69763 | 2024-06-30 | 5.60 | 26.18 | |
SO46390_1 | 100 | 12440 | 313 | 4 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO46390 | 2022-07-29 | 286.26 | 2171.29 | |
SO69763_3 | 100 | 15312 | 225 | 4 | 2024-07-05 | 0.22 | 2024-06-23 | 8.99 | 3 | SO69763 | 2024-06-30 | 0.72 | 6.92 | |
SO46396_1 | 100 | 12442 | 311 | 4 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO46396 | 2022-07-30 | 286.26 | 2171.29 | |
SO69764_1 | 100 | 15333 | 587 | 4 | 2024-07-05 | 19.24 | 2024-06-23 | 769.49 | 1 | SO69764 | 2024-06-30 | 61.56 | 419.78 | |
SO46414_1 | 100 | 15006 | 338 | 4 | 2022-08-06 | 17.48 | 2022-07-25 | 699.10 | 1 | SO46414 | 2022-08-01 | 55.93 | 413.15 | |
SO69764_2 | 100 | 15333 | 225 | 4 | 2024-07-05 | 0.22 | 2024-06-23 | 8.99 | 2 | SO69764 | 2024-06-30 | 0.72 | 6.92 | |
SO46416_1 | 100 | 12181 | 313 | 4 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO46416 | 2022-08-02 | 286.26 | 2171.29 | |
SO69764_3 | 100 | 15333 | 474 | 4 | 2024-07-05 | 1.75 | 2024-06-23 | 69.99 | 3 | SO69764 | 2024-06-30 | 5.60 | 26.18 | |
SO46417_1 | 100 | 12441 | 314 | 4 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO46417 | 2022-08-02 | 286.26 | 2171.29 | |
SO69765_1 | 100 | 15308 | 587 | 4 | 2024-07-05 | 19.24 | 2024-06-23 | 769.49 | 1 | SO69765 | 2024-06-30 | 61.56 | 419.78 | |
SO46422_1 | 100 | 12884 | 311 | 4 | 2022-08-08 | 89.46 | 2022-07-27 | 3578.27 | 1 | SO46422 | 2022-08-03 | 286.26 | 2171.29 | |
SO69765_2 | 100 | 15308 | 476 | 4 | 2024-07-05 | 1.75 | 2024-06-23 | 69.99 | 2 | SO69765 | 2024-06-30 | 5.60 | 26.18 | |
SO46423_1 | 100 | 12362 | 313 | 4 | 2022-08-08 | 89.46 | 2022-07-27 | 3578.27 | 1 | SO46423 | 2022-08-03 | 286.26 | 2171.29 | |
SO69768_1 | 100 | 17399 | 361 | 4 | 2024-07-05 | 57.37 | 2024-06-23 | 2294.99 | 1 | SO69768 | 2024-06-30 | 183.60 | 1251.98 | |
SO46424_1 | 100 | 12435 | 312 | 4 | 2022-08-08 | 89.46 | 2022-07-27 | 3578.27 | 1 | SO46424 | 2022-08-03 | 286.26 | 2171.29 | |
SO69768_2 | 100 | 17399 | 485 | 4 | 2024-07-05 | 0.55 | 2024-06-23 | 21.98 | 2 | SO69768 | 2024-06-30 | 1.76 | 8.22 | |
SO46426_1 | 100 | 26107 | 344 | 4 | 2022-08-08 | 85.00 | 2022-07-27 | 3399.99 | 1 | SO46426 | 2022-08-03 | 272.00 | 1912.15 | |
SO69768_3 | 100 | 17399 | 228 | 4 | 2024-07-05 | 1.25 | 2024-06-23 | 49.99 | 3 | SO69768 | 2024-06-30 | 4.00 | 38.49 | |
SO46432_1 | 100 | 15016 | 342 | 4 | 2022-08-09 | 17.48 | 2022-07-28 | 699.10 | 1 | SO46432 | 2022-08-04 | 55.93 | 413.15 | |
SO69782_1 | 100 | 24996 | 574 | 4 | 2024-07-05 | 59.60 | 2024-06-23 | 2384.07 | 1 | SO69782 | 2024-06-30 | 190.73 | 1481.94 | |
SO46438_1 | 100 | 12174 | 313 | 4 | 2022-08-10 | 89.46 | 2022-07-29 | 3578.27 | 1 | SO46438 | 2022-08-05 | 286.26 | 2171.29 | |
SO69782_2 | 100 | 24996 | 530 | 4 | 2024-07-05 | 0.12 | 2024-06-23 | 4.99 | 2 | SO69782 | 2024-06-30 | 0.40 | 1.87 | |
SO46450_1 | 100 | 12446 | 314 | 4 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO46450 | 2022-08-07 | 286.26 | 2171.29 | |
SO69782_3 | 100 | 24996 | 541 | 4 | 2024-07-05 | 0.72 | 2024-06-23 | 28.99 | 3 | SO69782 | 2024-06-30 | 2.32 | 10.84 | |
SO46451_1 | 100 | 12709 | 310 | 4 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO46451 | 2022-08-07 | 286.26 | 2171.29 | |
SO69784_1 | 100 | 23507 | 606 | 4 | 2024-07-05 | 13.50 | 2024-06-23 | 539.99 | 1 | SO69784 | 2024-06-30 | 43.20 | 343.65 | |
SO46458_1 | 100 | 12771 | 310 | 4 | 2022-08-13 | 89.46 | 2022-08-01 | 3578.27 | 1 | SO46458 | 2022-08-08 | 286.26 | 2171.29 | |
SO69784_2 | 100 | 23507 | 217 | 4 | 2024-07-05 | 0.87 | 2024-06-23 | 34.99 | 2 | SO69784 | 2024-06-30 | 2.80 | 13.09 | |
SO46459_1 | 100 | 12190 | 313 | 4 | 2022-08-13 | 89.46 | 2022-08-01 | 3578.27 | 1 | SO46459 | 2022-08-08 | 286.26 | 2171.29 | |
SO69786_1 | 100 | 14884 | 386 | 4 | 2024-07-05 | 28.01 | 2024-06-23 | 1120.49 | 1 | SO69786 | 2024-06-30 | 89.64 | 713.08 | |
SO46460_1 | 100 | 12438 | 312 | 4 | 2022-08-13 | 89.46 | 2022-08-01 | 3578.27 | 1 | SO46460 | 2022-08-08 | 286.26 | 2171.29 | |
SO69786_2 | 100 | 14884 | 539 | 4 | 2024-07-05 | 0.62 | 2024-06-23 | 24.99 | 2 | SO69786 | 2024-06-30 | 2.00 | 9.35 | |
SO46464_1 | 100 | 12885 | 310 | 4 | 2022-08-14 | 89.46 | 2022-08-02 | 3578.27 | 1 | SO46464 | 2022-08-09 | 286.26 | 2171.29 | |
SO69786_3 | 100 | 14884 | 529 | 4 | 2024-07-05 | 0.10 | 2024-06-23 | 3.99 | 3 | SO69786 | 2024-06-30 | 0.32 | 1.49 | |
SO46465_1 | 100 | 12898 | 311 | 4 | 2022-08-14 | 89.46 | 2022-08-02 | 3578.27 | 1 | SO46465 | 2022-08-09 | 286.26 | 2171.29 | |
SO69786_4 | 100 | 14884 | 222 | 4 | 2024-07-05 | 0.87 | 2024-06-23 | 34.99 | 4 | SO69786 | 2024-06-30 | 2.80 | 13.09 | |
SO46479_1 | 100 | 12768 | 310 | 4 | 2022-08-16 | 89.46 | 2022-08-04 | 3578.27 | 1 | SO46479 | 2022-08-11 | 286.26 | 2171.29 | |
SO69788_1 | 100 | 18798 | 580 | 4 | 2024-07-05 | 42.52 | 2024-06-23 | 1700.99 | 1 | SO69788 | 2024-06-30 | 136.08 | 1082.51 | |
SO46480_1 | 100 | 26114 | 347 | 4 | 2022-08-16 | 85.00 | 2022-08-04 | 3399.99 | 1 | SO46480 | 2022-08-11 | 272.00 | 1912.15 | |
SO69788_2 | 100 | 18798 | 539 | 4 | 2024-07-05 | 0.62 | 2024-06-23 | 24.99 | 2 | SO69788 | 2024-06-30 | 2.00 | 9.35 | |
SO46483_1 | 100 | 12883 | 312 | 4 | 2022-08-17 | 89.46 | 2022-08-05 | 3578.27 | 1 | SO46483 | 2022-08-12 | 286.26 | 2171.29 | |
SO69788_3 | 100 | 18798 | 480 | 4 | 2024-07-05 | 0.06 | 2024-06-23 | 2.29 | 3 | SO69788 | 2024-06-30 | 0.18 | 0.86 | |
SO46485_1 | 100 | 12755 | 313 | 4 | 2022-08-17 | 89.46 | 2022-08-05 | 3578.27 | 1 | SO46485 | 2022-08-12 | 286.26 | 2171.29 | |
SO69805_1 | 100 | 11222 | 529 | 4 | 2024-07-06 | 0.10 | 2024-06-24 | 3.99 | 1 | SO69805 | 2024-07-01 | 0.32 | 1.49 | |
SO46487_1 | 100 | 14913 | 338 | 4 | 2022-08-17 | 17.48 | 2022-08-05 | 699.10 | 1 | SO46487 | 2022-08-12 | 55.93 | 413.15 | |
SO69805_2 | 100 | 11222 | 483 | 4 | 2024-07-06 | 3.00 | 2024-06-24 | 120.00 | 2 | SO69805 | 2024-07-01 | 9.60 | 44.88 | |
SO46490_1 | 100 | 12189 | 313 | 4 | 2022-08-18 | 89.46 | 2022-08-06 | 3578.27 | 1 | SO46490 | 2022-08-13 | 286.26 | 2171.29 | |
SO69805_3 | 100 | 11222 | 225 | 4 | 2024-07-06 | 0.22 | 2024-06-24 | 8.99 | 3 | SO69805 | 2024-07-01 | 0.72 | 6.92 | |
SO46498_1 | 100 | 12881 | 313 | 4 | 2022-08-20 | 89.46 | 2022-08-08 | 3578.27 | 1 | SO46498 | 2022-08-15 | 286.26 | 2171.29 | |
SO69809_1 | 100 | 27997 | 530 | 4 | 2024-07-06 | 0.12 | 2024-06-24 | 4.99 | 1 | SO69809 | 2024-07-01 | 0.40 | 1.87 | |
SO46504_1 | 100 | 15005 | 342 | 4 | 2022-08-20 | 17.48 | 2022-08-08 | 699.10 | 1 | SO46504 | 2022-08-15 | 55.93 | 413.15 | |
SO69810_1 | 100 | 26554 | 541 | 4 | 2024-07-06 | 0.72 | 2024-06-24 | 28.99 | 1 | SO69810 | 2024-07-01 | 2.32 | 10.84 | |
SO46509_1 | 100 | 12886 | 310 | 4 | 2022-08-21 | 89.46 | 2022-08-09 | 3578.27 | 1 | SO46509 | 2022-08-16 | 286.26 | 2171.29 | |
SO69810_2 | 100 | 26554 | 530 | 4 | 2024-07-06 | 0.12 | 2024-06-24 | 4.99 | 2 | SO69810 | 2024-07-01 | 0.40 | 1.87 | |
SO46512_1 | 100 | 12209 | 311 | 4 | 2022-08-21 | 89.46 | 2022-08-09 | 3578.27 | 1 | SO46512 | 2022-08-16 | 286.26 | 2171.29 | |
SO69810_3 | 100 | 26554 | 214 | 4 | 2024-07-06 | 0.87 | 2024-06-24 | 34.99 | 3 | SO69810 | 2024-07-01 | 2.80 | 13.09 | |
SO46521_1 | 100 | 12770 | 310 | 4 | 2022-08-22 | 89.46 | 2022-08-10 | 3578.27 | 1 | SO46521 | 2022-08-17 | 286.26 | 2171.29 | |
SO69811_1 | 100 | 24316 | 529 | 4 | 2024-07-06 | 0.10 | 2024-06-24 | 3.99 | 1 | SO69811 | 2024-07-01 | 0.32 | 1.49 | |
SO46522_1 | 100 | 12882 | 312 | 4 | 2022-08-22 | 89.46 | 2022-08-10 | 3578.27 | 1 | SO46522 | 2022-08-17 | 286.26 | 2171.29 | |
SO69811_2 | 100 | 24316 | 540 | 4 | 2024-07-06 | 0.82 | 2024-06-24 | 32.60 | 2 | SO69811 | 2024-07-01 | 2.61 | 12.19 | |
SO46523_1 | 100 | 12756 | 313 | 4 | 2022-08-22 | 89.46 | 2022-08-10 | 3578.27 | 1 | SO46523 | 2022-08-17 | 286.26 | 2171.29 | |
SO69811_3 | 100 | 24316 | 480 | 4 | 2024-07-06 | 0.06 | 2024-06-24 | 2.29 | 3 | SO69811 | 2024-07-01 | 0.18 | 0.86 | |
SO46524_1 | 100 | 26111 | 351 | 4 | 2022-08-22 | 84.37 | 2022-08-10 | 3374.99 | 1 | SO46524 | 2022-08-17 | 270.00 | 1898.09 | |
SO69814_1 | 100 | 18988 | 474 | 4 | 2024-07-06 | 1.75 | 2024-06-24 | 69.99 | 1 | SO69814 | 2024-07-01 | 5.60 | 26.18 | |
SO46533_1 | 100 | 26106 | 348 | 4 | 2022-08-23 | 84.37 | 2022-08-11 | 3374.99 | 1 | SO46533 | 2022-08-18 | 270.00 | 1898.09 | |
SO69830_1 | 100 | 11188 | 528 | 4 | 2024-07-06 | 0.12 | 2024-06-24 | 4.99 | 1 | SO69830 | 2024-07-01 | 0.40 | 1.87 | |
SO46538_1 | 100 | 12774 | 310 | 4 | 2022-08-24 | 89.46 | 2022-08-12 | 3578.27 | 1 | SO46538 | 2022-08-19 | 286.26 | 2171.29 | |
SO69830_2 | 100 | 11188 | 537 | 4 | 2024-07-06 | 0.88 | 2024-06-24 | 35.00 | 2 | SO69830 | 2024-07-01 | 2.80 | 13.09 | |
SO46539_1 | 100 | 12200 | 314 | 4 | 2022-08-24 | 89.46 | 2022-08-12 | 3578.27 | 1 | SO46539 | 2022-08-19 | 286.26 | 2171.29 | |
SO69830_3 | 100 | 11188 | 214 | 4 | 2024-07-06 | 0.87 | 2024-06-24 | 34.99 | 3 | SO69830 | 2024-07-01 | 2.80 | 13.09 | |
SO46550_1 | 100 | 26097 | 350 | 4 | 2022-08-25 | 84.37 | 2022-08-13 | 3374.99 | 1 | SO46550 | 2022-08-20 | 270.00 | 1898.09 | |
SO69831_1 | 100 | 11527 | 537 | 4 | 2024-07-06 | 0.88 | 2024-06-24 | 35.00 | 1 | SO69831 | 2024-07-01 | 2.80 | 13.09 | |
SO46551_1 | 100 | 14914 | 330 | 4 | 2022-08-25 | 17.48 | 2022-08-13 | 699.10 | 1 | SO46551 | 2022-08-20 | 55.93 | 413.15 | |
SO69831_2 | 100 | 11527 | 480 | 4 | 2024-07-06 | 0.06 | 2024-06-24 | 2.29 | 2 | SO69831 | 2024-07-01 | 0.18 | 0.86 | |
SO46552_1 | 100 | 15017 | 328 | 4 | 2022-08-25 | 17.48 | 2022-08-13 | 699.10 | 1 | SO46552 | 2022-08-20 | 55.93 | 413.15 | |
SO69832_1 | 100 | 13723 | 528 | 4 | 2024-07-06 | 0.12 | 2024-06-24 | 4.99 | 1 | SO69832 | 2024-07-01 | 0.40 | 1.87 |
Generated 2024-09-20 11:49:56.991 UTC