[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 1782 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56363_2 | 100 | 14089 | 475 | 4 | 2024-02-14 | 1.75 | 2024-02-02 | 69.99 | 2 | SO56363 | 2024-02-09 | 5.60 | 26.18 | |
SO63021_3 | 100 | 23864 | 234 | 4 | 2024-05-27 | 1.25 | 2024-05-15 | 49.99 | 3 | SO63021 | 2024-05-22 | 4.00 | 38.49 | |
SO69691_3 | 100 | 14499 | 484 | 4 | 2024-08-28 | 0.20 | 2024-08-16 | 7.95 | 3 | SO69691 | 2024-08-23 | 0.64 | 2.97 | |
SO46464_1 | 100 | 12885 | 310 | 4 | 2022-10-08 | 89.46 | 2022-09-26 | 3578.27 | 1 | SO46464 | 2022-10-03 | 286.26 | 2171.29 | |
SO56363_3 | 100 | 14089 | 490 | 4 | 2024-02-14 | 1.35 | 2024-02-02 | 53.99 | 3 | SO56363 | 2024-02-09 | 4.32 | 41.57 | |
SO63022_1 | 100 | 22069 | 478 | 4 | 2024-05-27 | 0.25 | 2024-05-15 | 9.99 | 1 | SO63022 | 2024-05-22 | 0.80 | 3.74 | |
SO69692_1 | 100 | 14595 | 528 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 1 | SO69692 | 2024-08-23 | 0.40 | 1.87 | |
SO46465_1 | 100 | 12898 | 311 | 4 | 2022-10-08 | 89.46 | 2022-09-26 | 3578.27 | 1 | SO46465 | 2022-10-03 | 286.26 | 2171.29 | |
SO56364_1 | 100 | 13100 | 357 | 4 | 2024-02-14 | 58.00 | 2024-02-02 | 2319.99 | 1 | SO56364 | 2024-02-09 | 185.60 | 1265.62 | |
SO63022_2 | 100 | 22069 | 477 | 4 | 2024-05-27 | 0.12 | 2024-05-15 | 4.99 | 2 | SO63022 | 2024-05-22 | 0.40 | 1.87 | |
SO69692_2 | 100 | 14595 | 214 | 4 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 2 | SO69692 | 2024-08-23 | 2.80 | 13.09 | |
SO46479_1 | 100 | 12768 | 310 | 4 | 2022-10-10 | 89.46 | 2022-09-28 | 3578.27 | 1 | SO46479 | 2022-10-05 | 286.26 | 2171.29 | |
SO56364_2 | 100 | 13100 | 485 | 4 | 2024-02-14 | 0.55 | 2024-02-02 | 21.98 | 2 | SO56364 | 2024-02-09 | 1.76 | 8.22 | |
SO63022_3 | 100 | 22069 | 484 | 4 | 2024-05-27 | 0.20 | 2024-05-15 | 7.95 | 3 | SO63022 | 2024-05-22 | 0.64 | 2.97 | |
SO69701_1 | 100 | 16141 | 599 | 4 | 2024-08-28 | 13.50 | 2024-08-16 | 539.99 | 1 | SO69701 | 2024-08-23 | 43.20 | 294.58 | |
SO46480_1 | 100 | 26114 | 347 | 4 | 2022-10-10 | 85.00 | 2022-09-28 | 3399.99 | 1 | SO46480 | 2022-10-05 | 272.00 | 1912.15 | |
SO56364_3 | 100 | 13100 | 222 | 4 | 2024-02-14 | 0.87 | 2024-02-02 | 34.99 | 3 | SO56364 | 2024-02-09 | 2.80 | 13.09 | |
SO63025_1 | 100 | 16010 | 528 | 4 | 2024-05-27 | 0.12 | 2024-05-15 | 4.99 | 1 | SO63025 | 2024-05-22 | 0.40 | 1.87 | |
SO69701_2 | 100 | 16141 | 477 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 2 | SO69701 | 2024-08-23 | 0.40 | 1.87 | |
SO46483_1 | 100 | 12883 | 312 | 4 | 2022-10-11 | 89.46 | 2022-09-29 | 3578.27 | 1 | SO46483 | 2022-10-06 | 286.26 | 2171.29 | |
SO56370_1 | 100 | 26486 | 566 | 4 | 2024-02-14 | 18.56 | 2024-02-02 | 742.35 | 1 | SO56370 | 2024-02-09 | 59.39 | 461.44 | |
SO63025_2 | 100 | 16010 | 480 | 2 | 4 | 2024-05-27 | 0.06 | 2024-05-15 | 2.29 | 2 | SO63025 | 2024-05-22 | 0.18 | 0.86 |
SO69701_3 | 100 | 16141 | 478 | 4 | 2024-08-28 | 0.25 | 2024-08-16 | 9.99 | 3 | SO69701 | 2024-08-23 | 0.80 | 3.74 | |
SO46485_1 | 100 | 12755 | 313 | 4 | 2022-10-11 | 89.46 | 2022-09-29 | 3578.27 | 1 | SO46485 | 2022-10-06 | 286.26 | 2171.29 | |
SO56370_2 | 100 | 26486 | 479 | 4 | 2024-02-14 | 0.22 | 2024-02-02 | 8.99 | 2 | SO56370 | 2024-02-09 | 0.72 | 3.36 | |
SO63026_1 | 100 | 15202 | 528 | 4 | 2024-05-27 | 0.12 | 2024-05-15 | 4.99 | 1 | SO63026 | 2024-05-22 | 0.40 | 1.87 | |
SO69701_4 | 100 | 16141 | 222 | 4 | 2024-08-28 | 0.87 | 2024-08-16 | 34.99 | 4 | SO69701 | 2024-08-23 | 2.80 | 13.09 | |
SO46487_1 | 100 | 14913 | 338 | 4 | 2022-10-11 | 17.48 | 2022-09-29 | 699.10 | 1 | SO46487 | 2022-10-06 | 55.93 | 413.15 | |
SO56379_1 | 100 | 28597 | 484 | 4 | 2024-02-15 | 0.20 | 2024-02-03 | 7.95 | 1 | SO56379 | 2024-02-10 | 0.64 | 2.97 | |
SO63026_2 | 100 | 15202 | 484 | 4 | 2024-05-27 | 0.20 | 2024-05-15 | 7.95 | 2 | SO63026 | 2024-05-22 | 0.64 | 2.97 | |
SO69704_1 | 100 | 16961 | 363 | 4 | 2024-08-28 | 57.37 | 2024-08-16 | 2294.99 | 1 | SO69704 | 2024-08-23 | 183.60 | 1251.98 | |
SO46490_1 | 100 | 12189 | 313 | 4 | 2022-10-12 | 89.46 | 2022-09-30 | 3578.27 | 1 | SO46490 | 2022-10-07 | 286.26 | 2171.29 | |
SO56389_1 | 100 | 29206 | 539 | 4 | 2024-02-15 | 0.62 | 2024-02-03 | 24.99 | 1 | SO56389 | 2024-02-10 | 2.00 | 9.35 | |
SO63036_1 | 100 | 11509 | 537 | 4 | 2024-05-27 | 0.88 | 2024-05-15 | 35.00 | 1 | SO63036 | 2024-05-22 | 2.80 | 13.09 | |
SO69704_2 | 100 | 16961 | 477 | 4 | 2024-08-28 | 0.12 | 2024-08-16 | 4.99 | 2 | SO69704 | 2024-08-23 | 0.40 | 1.87 | |
SO46498_1 | 100 | 12881 | 313 | 4 | 2022-10-14 | 89.46 | 2022-10-02 | 3578.27 | 1 | SO46498 | 2022-10-09 | 286.26 | 2171.29 | |
SO56389_2 | 100 | 29206 | 529 | 4 | 2024-02-15 | 0.10 | 2024-02-03 | 3.99 | 2 | SO56389 | 2024-02-10 | 0.32 | 1.49 | |
SO63036_2 | 100 | 11509 | 480 | 4 | 2024-05-27 | 0.06 | 2024-05-15 | 2.29 | 2 | SO63036 | 2024-05-22 | 0.18 | 0.86 | |
SO69704_3 | 100 | 16961 | 481 | 4 | 2024-08-28 | 0.22 | 2024-08-16 | 8.99 | 3 | SO69704 | 2024-08-23 | 0.72 | 3.36 | |
SO46504_1 | 100 | 15005 | 342 | 4 | 2022-10-14 | 17.48 | 2022-10-02 | 699.10 | 1 | SO46504 | 2022-10-09 | 55.93 | 413.15 | |
SO56389_3 | 100 | 29206 | 483 | 4 | 2024-02-15 | 3.00 | 2024-02-03 | 120.00 | 3 | SO56389 | 2024-02-10 | 9.60 | 44.88 | |
SO63036_3 | 100 | 11509 | 486 | 4 | 2024-05-27 | 3.98 | 2024-05-15 | 159.00 | 3 | SO63036 | 2024-05-22 | 12.72 | 59.47 | |
SO69704_4 | 100 | 16961 | 478 | 4 | 2024-08-28 | 0.25 | 2024-08-16 | 9.99 | 4 | SO69704 | 2024-08-23 | 0.80 | 3.74 | |
SO46509_1 | 100 | 12886 | 310 | 4 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46509 | 2022-10-10 | 286.26 | 2171.29 | |
SO56393_1 | 100 | 25441 | 529 | 4 | 2024-02-15 | 0.10 | 2024-02-03 | 3.99 | 1 | SO56393 | 2024-02-10 | 0.32 | 1.49 | |
SO63044_1 | 100 | 12435 | 355 | 4 | 2024-05-27 | 58.00 | 2024-05-15 | 2319.99 | 1 | SO63044 | 2024-05-22 | 185.60 | 1265.62 | |
SO69705_1 | 100 | 15289 | 590 | 4 | 2024-08-28 | 19.24 | 2024-08-16 | 769.49 | 1 | SO69705 | 2024-08-23 | 61.56 | 419.78 | |
SO46512_1 | 100 | 12209 | 311 | 4 | 2022-10-15 | 89.46 | 2022-10-03 | 3578.27 | 1 | SO46512 | 2022-10-10 | 286.26 | 2171.29 | |
SO56393_2 | 100 | 25441 | 540 | 4 | 2024-02-15 | 0.82 | 2024-02-03 | 32.60 | 2 | SO56393 | 2024-02-10 | 2.61 | 12.19 | |
SO63044_2 | 100 | 12435 | 485 | 4 | 2024-05-27 | 0.55 | 2024-05-15 | 21.98 | 2 | SO63044 | 2024-05-22 | 1.76 | 8.22 | |
SO69705_2 | 100 | 15289 | 485 | 4 | 2024-08-28 | 0.55 | 2024-08-16 | 21.98 | 2 | SO69705 | 2024-08-23 | 1.76 | 8.22 | |
SO46521_1 | 100 | 12770 | 310 | 4 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46521 | 2022-10-11 | 286.26 | 2171.29 | |
SO56393_3 | 100 | 25441 | 222 | 4 | 2024-02-15 | 0.87 | 2024-02-03 | 34.99 | 3 | SO56393 | 2024-02-10 | 2.80 | 13.09 | |
SO63050_1 | 100 | 26618 | 570 | 4 | 2024-05-27 | 18.56 | 2024-05-15 | 742.35 | 1 | SO63050 | 2024-05-22 | 59.39 | 461.44 | |
SO69711_1 | 100 | 23739 | 606 | 4 | 2024-08-28 | 13.50 | 2024-08-16 | 539.99 | 1 | SO69711 | 2024-08-23 | 43.20 | 343.65 | |
SO46522_1 | 100 | 12882 | 312 | 4 | 2022-10-16 | 89.46 | 2022-10-04 | 3578.27 | 1 | SO46522 | 2022-10-11 | 286.26 | 2171.29 |
Generated 2024-11-14 05:52:42.510 UTC