[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1790 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46396_1 | 100 | 12442 | 311 | 4 | 2022-09-28 | 89.46 | 2022-09-16 | 3578.27 | 1 | SO46396 | 2022-09-23 | 286.26 | 2171.29 | |
SO56330_1 | 100 | 22886 | 606 | 4 | 2024-02-13 | 13.50 | 2024-02-01 | 539.99 | 1 | SO56330 | 2024-02-08 | 43.20 | 343.65 | |
SO63112_3 | 100 | 20436 | 479 | 4 | 2024-05-28 | 0.22 | 2024-05-16 | 8.99 | 3 | SO63112 | 2024-05-23 | 0.72 | 3.36 | |
SO69682_1 | 100 | 20292 | 475 | 4 | 2024-08-28 | 1.75 | 2024-08-16 | 69.99 | 1 | SO69682 | 2024-08-23 | 5.60 | 26.18 | |
SO46414_1 | 100 | 15006 | 338 | 4 | 2022-09-30 | 17.48 | 2022-09-18 | 699.10 | 1 | SO46414 | 2022-09-25 | 55.93 | 413.15 | |
SO56330_2 | 100 | 22886 | 217 | 4 | 2024-02-13 | 0.87 | 2024-02-01 | 34.99 | 2 | SO56330 | 2024-02-08 | 2.80 | 13.09 | |
SO63306_1 | 100 | 26712 | 541 | 4 | 2024-05-29 | 0.72 | 2024-05-17 | 28.99 | 1 | SO63306 | 2024-05-24 | 2.32 | 10.84 | |
SO69682_2 | 100 | 20292 | 231 | 4 | 2024-08-28 | 1.25 | 2024-08-16 | 49.99 | 2 | SO69682 | 2024-08-23 | 4.00 | 38.49 | |
SO46416_1 | 100 | 12181 | 313 | 4 | 2022-10-01 | 89.46 | 2022-09-19 | 3578.27 | 1 | SO46416 | 2022-09-26 | 286.26 | 2171.29 | |
SO56330_3 | 100 | 22886 | 467 | 4 | 2024-02-13 | 0.61 | 2024-02-01 | 24.49 | 3 | SO56330 | 2024-02-08 | 1.96 | 9.16 | |
SO63306_2 | 100 | 26712 | 530 | 4 | 2024-05-29 | 0.12 | 2024-05-17 | 4.99 | 2 | SO63306 | 2024-05-24 | 0.40 | 1.87 | |
SO69686_1 | 100 | 16120 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69686 | 2024-08-23 | 0.40 | 1.87 | |
SO46417_1 | 100 | 12441 | 314 | 4 | 2022-10-01 | 89.46 | 2022-09-19 | 3578.27 | 1 | SO46417 | 2022-09-26 | 286.26 | 2171.29 | |
SO56346_1 | 100 | 23469 | 536 | 4 | 2024-02-14 | 0.75 | 2024-02-02 | 29.99 | 1 | SO56346 | 2024-02-09 | 2.40 | 11.22 | |
SO63306_3 | 100 | 26712 | 225 | 4 | 2024-05-29 | 0.22 | 2024-05-17 | 8.99 | 3 | SO63306 | 2024-05-24 | 0.72 | 6.92 | |
SO69686_2 | 100 | 16120 | 480 | 2 | 4 | 2024-08-28 | 0.06 | 2024-08-16 | 2.29 | 2 | SO69686 | 2024-08-23 | 0.18 | 0.86 |
SO46422_1 | 100 | 12884 | 311 | 4 | 2022-10-02 | 89.46 | 2022-09-20 | 3578.27 | 1 | SO46422 | 2022-09-27 | 286.26 | 2171.29 | |
SO56348_1 | 100 | 25023 | 540 | 4 | 2024-02-14 | 0.82 | 2024-02-02 | 32.60 | 1 | SO56348 | 2024-02-09 | 2.61 | 12.19 | |
SO63313_1 | 100 | 16677 | 477 | 4 | 2024-05-29 | 0.12 | 2024-05-17 | 4.99 | 1 | SO63313 | 2024-05-24 | 0.40 | 1.87 | |
SO69687_1 | 100 | 15316 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69687 | 2024-08-23 | 0.40 | 1.87 | |
SO46423_1 | 100 | 12362 | 313 | 4 | 2022-10-02 | 89.46 | 2022-09-20 | 3578.27 | 1 | SO46423 | 2022-09-27 | 286.26 | 2171.29 | |
SO56348_2 | 100 | 25023 | 529 | 4 | 2024-02-14 | 0.10 | 2024-02-02 | 3.99 | 2 | SO56348 | 2024-02-09 | 0.32 | 1.49 | |
SO63313_2 | 100 | 16677 | 225 | 4 | 2024-05-29 | 0.22 | 2024-05-17 | 8.99 | 2 | SO63313 | 2024-05-24 | 0.72 | 6.92 | |
SO69687_2 | 100 | 15316 | 480 | 2 | 4 | 2024-08-28 | 0.06 | 2024-08-16 | 2.29 | 2 | SO69687 | 2024-08-23 | 0.18 | 0.86 |
SO46424_1 | 100 | 12435 | 312 | 4 | 2022-10-02 | 89.46 | 2022-09-20 | 3578.27 | 1 | SO46424 | 2022-09-27 | 286.26 | 2171.29 | |
SO56348_3 | 100 | 25023 | 480 | 4 | 2024-02-14 | 0.06 | 2024-02-02 | 2.29 | 3 | SO56348 | 2024-02-09 | 0.18 | 0.86 | |
SO63316_1 | 100 | 14748 | 528 | 4 | 2024-05-29 | 0.12 | 2024-05-17 | 4.99 | 1 | SO63316 | 2024-05-24 | 0.40 | 1.87 | |
SO69688_1 | 100 | 14615 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69688 | 2024-08-23 | 0.40 | 1.87 | |
SO46426_1 | 100 | 26107 | 344 | 4 | 2022-10-02 | 85.00 | 2022-09-20 | 3399.99 | 1 | SO46426 | 2022-09-27 | 272.00 | 1912.15 | |
SO56350_1 | 100 | 22138 | 536 | 4 | 2024-02-14 | 0.75 | 2024-02-02 | 29.99 | 1 | SO56350 | 2024-02-09 | 2.40 | 11.22 | |
SO63316_2 | 100 | 14748 | 483 | 4 | 2024-05-29 | 3.00 | 2024-05-17 | 120.00 | 2 | SO63316 | 2024-05-24 | 9.60 | 44.88 | |
SO69688_2 | 100 | 14615 | 478 | 4 | 2024-08-28 | 0.25 | 2024-08-16 | 9.99 | 2 | SO69688 | 2024-08-23 | 0.80 | 3.74 | |
SO46432_1 | 100 | 15016 | 342 | 4 | 2022-10-03 | 17.48 | 2022-09-21 | 699.10 | 1 | SO46432 | 2022-09-28 | 55.93 | 413.15 | |
SO56350_2 | 100 | 22138 | 528 | 4 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 2 | SO56350 | 2024-02-09 | 0.40 | 1.87 | |
SO63317_1 | 100 | 16017 | 528 | 4 | 2024-05-29 | 0.12 | 2024-05-17 | 4.99 | 1 | SO63317 | 2024-05-24 | 0.40 | 1.87 | |
SO69688_3 | 100 | 14615 | 477 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 3 | SO69688 | 2024-08-23 | 0.40 | 1.87 | |
SO46438_1 | 100 | 12174 | 313 | 4 | 2022-10-04 | 89.46 | 2022-09-22 | 3578.27 | 1 | SO46438 | 2022-09-29 | 286.26 | 2171.29 | |
SO56350_3 | 100 | 22138 | 480 | 4 | 2024-02-14 | 0.06 | 2024-02-02 | 2.29 | 3 | SO56350 | 2024-02-09 | 0.18 | 0.86 | |
SO63317_2 | 100 | 16017 | 487 | 4 | 2024-05-29 | 1.37 | 2024-05-17 | 54.99 | 2 | SO63317 | 2024-05-24 | 4.40 | 20.57 | |
SO69688_4 | 100 | 14615 | 225 | 4 | 2024-08-28 | 0.22 | 2024-08-16 | 8.99 | 4 | SO69688 | 2024-08-23 | 0.72 | 6.92 | |
SO46450_1 | 100 | 12446 | 314 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46450 | 2022-10-01 | 286.26 | 2171.29 | |
SO56352_1 | 100 | 20503 | 478 | 4 | 2024-02-14 | 0.25 | 2024-02-02 | 9.99 | 1 | SO56352 | 2024-02-09 | 0.80 | 3.74 | |
SO63319_1 | 100 | 14241 | 485 | 4 | 2024-05-29 | 0.55 | 2024-05-17 | 21.98 | 1 | SO63319 | 2024-05-24 | 1.76 | 8.22 | |
SO69690_1 | 100 | 14389 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69690 | 2024-08-23 | 0.40 | 1.87 | |
SO46451_1 | 100 | 12709 | 310 | 4 | 2022-10-06 | 89.46 | 2022-09-24 | 3578.27 | 1 | SO46451 | 2022-10-01 | 286.26 | 2171.29 | |
SO56352_2 | 100 | 20503 | 477 | 4 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 2 | SO56352 | 2024-02-09 | 0.40 | 1.87 | |
SO63319_2 | 100 | 14241 | 487 | 4 | 2024-05-29 | 1.37 | 2024-05-17 | 54.99 | 2 | SO63319 | 2024-05-24 | 4.40 | 20.57 | |
SO69690_2 | 100 | 14389 | 480 | 2 | 4 | 2024-08-28 | 0.06 | 2024-08-16 | 2.29 | 2 | SO69690 | 2024-08-23 | 0.18 | 0.86 |
SO46458_1 | 100 | 12771 | 310 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46458 | 2022-10-02 | 286.26 | 2171.29 | |
SO56354_1 | 100 | 15344 | 528 | 4 | 2024-02-14 | 0.12 | 2024-02-02 | 4.99 | 1 | SO56354 | 2024-02-09 | 0.40 | 1.87 | |
SO63319_3 | 100 | 14241 | 484 | 4 | 2024-05-29 | 0.20 | 2024-05-17 | 7.95 | 3 | SO63319 | 2024-05-24 | 0.64 | 2.97 | |
SO69691_1 | 100 | 14499 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69691 | 2024-08-23 | 0.40 | 1.87 | |
SO46459_1 | 100 | 12190 | 313 | 4 | 2022-10-07 | 89.46 | 2022-09-25 | 3578.27 | 1 | SO46459 | 2022-10-02 | 286.26 | 2171.29 | |
SO56363_1 | 100 | 14089 | 589 | 4 | 2024-02-14 | 19.24 | 2024-02-02 | 769.49 | 1 | SO56363 | 2024-02-09 | 61.56 | 419.78 | |
SO63335_1 | 100 | 18947 | 590 | 4 | 2024-05-29 | 19.24 | 2024-05-17 | 769.49 | 1 | SO63335 | 2024-05-24 | 61.56 | 419.78 | |
SO69691_2 | 100 | 14499 | 480 | 4 | 2024-08-28 | 0.06 | 2024-08-16 | 2.29 | 2 | SO69691 | 2024-08-23 | 0.18 | 0.86 |
Generated 2024-11-14 07:49:18.591 UTC