[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1008 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44024_1 | 6 | 16663 | 314 | 9 | 2021-12-18 | 89.46 | 2021-12-06 | 3578.27 | 1 | SO44024 | 2021-12-13 | 286.26 | 2171.29 | |
SO55659_2 | 100 | 16372 | 529 | 4 | 2024-02-01 | 0.10 | 2024-01-20 | 3.99 | 2 | SO55659 | 2024-01-27 | 0.32 | 1.49 | |
SO62213_2 | 100 | 19736 | 477 | 4 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62213 | 2024-05-08 | 0.40 | 1.87 | |
SO68747_2 | 98 | 17960 | 231 | 10 | 2024-08-18 | 1.25 | 2024-08-06 | 49.99 | 2 | SO68747 | 2024-08-13 | 4.00 | 38.49 | |
SO44025_1 | 6 | 16708 | 314 | 9 | 2021-12-18 | 89.46 | 2021-12-06 | 3578.27 | 1 | SO44025 | 2021-12-13 | 286.26 | 2171.29 | |
SO55659_3 | 100 | 16372 | 540 | 4 | 2024-02-01 | 0.82 | 2024-01-20 | 32.60 | 3 | SO55659 | 2024-01-27 | 2.61 | 12.19 | |
SO62213_3 | 100 | 19736 | 478 | 4 | 2024-05-13 | 0.25 | 2024-05-01 | 9.99 | 3 | SO62213 | 2024-05-08 | 0.80 | 3.74 | |
SO68748_1 | 98 | 14158 | 353 | 10 | 2024-08-18 | 58.00 | 2024-08-06 | 2319.99 | 1 | SO68748 | 2024-08-13 | 185.60 | 1265.62 | |
SO44026_1 | 6 | 17045 | 310 | 9 | 2021-12-18 | 89.46 | 2021-12-06 | 3578.27 | 1 | SO44026 | 2021-12-13 | 286.26 | 2171.29 | |
SO55659_4 | 100 | 16372 | 480 | 4 | 2024-02-01 | 0.06 | 2024-01-20 | 2.29 | 4 | SO55659 | 2024-01-27 | 0.18 | 0.86 | |
SO62213_4 | 100 | 19736 | 487 | 4 | 2024-05-13 | 1.37 | 2024-05-01 | 54.99 | 4 | SO62213 | 2024-05-08 | 4.40 | 20.57 | |
SO68748_2 | 98 | 14158 | 477 | 10 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 2 | SO68748 | 2024-08-13 | 0.40 | 1.87 | |
SO44027_1 | 19 | 21921 | 310 | 6 | 2021-12-19 | 89.46 | 2021-12-07 | 3578.27 | 1 | SO44027 | 2021-12-14 | 286.26 | 2171.29 | |
SO55660_1 | 100 | 12764 | 588 | 1 | 2024-02-01 | 19.24 | 2024-01-20 | 769.49 | 1 | SO55660 | 2024-01-27 | 61.56 | 419.78 | |
SO62213_5 | 100 | 19736 | 490 | 4 | 2024-05-13 | 1.35 | 2024-05-01 | 53.99 | 5 | SO62213 | 2024-05-08 | 4.32 | 41.57 | |
SO68748_3 | 98 | 14158 | 478 | 10 | 2024-08-18 | 0.25 | 2024-08-06 | 9.99 | 3 | SO68748 | 2024-08-13 | 0.80 | 3.74 | |
SO44028_1 | 6 | 17048 | 312 | 9 | 2021-12-19 | 89.46 | 2021-12-07 | 3578.27 | 1 | SO44028 | 2021-12-14 | 286.26 | 2171.29 | |
SO55661_1 | 100 | 12980 | 363 | 2 | 1 | 2024-02-01 | 57.37 | 2024-01-20 | 2294.99 | 1 | SO55661 | 2024-01-27 | 183.60 | 1251.98 |
SO62214_1 | 100 | 19721 | 597 | 1 | 2024-05-13 | 13.50 | 2024-05-01 | 539.99 | 1 | SO62214 | 2024-05-08 | 43.20 | 294.58 | |
SO68748_4 | 98 | 14158 | 473 | 10 | 2024-08-18 | 1.59 | 2024-08-06 | 63.50 | 4 | SO68748 | 2024-08-13 | 5.08 | 23.75 | |
SO44029_1 | 6 | 11050 | 350 | 9 | 2021-12-19 | 84.37 | 2021-12-07 | 3374.99 | 1 | SO44029 | 2021-12-14 | 270.00 | 1898.09 | |
SO55661_2 | 100 | 12980 | 485 | 1 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 2 | SO55661 | 2024-01-27 | 1.76 | 8.22 | |
SO62214_2 | 100 | 19721 | 485 | 1 | 2024-05-13 | 0.55 | 2024-05-01 | 21.98 | 2 | SO62214 | 2024-05-08 | 1.76 | 8.22 | |
SO68749_1 | 98 | 19253 | 598 | 10 | 2024-08-18 | 13.50 | 2024-08-06 | 539.99 | 1 | SO68749 | 2024-08-13 | 43.20 | 294.58 | |
SO44030_1 | 39 | 12131 | 311 | 7 | 2021-12-20 | 89.46 | 2021-12-08 | 3578.27 | 1 | SO44030 | 2021-12-15 | 286.26 | 2171.29 | |
SO55661_3 | 100 | 12980 | 491 | 1 | 2024-02-01 | 1.35 | 2024-01-20 | 53.99 | 3 | SO55661 | 2024-01-27 | 4.32 | 41.57 | |
SO62214_3 | 100 | 19721 | 480 | 2 | 1 | 2024-05-13 | 0.06 | 2024-05-01 | 2.29 | 3 | SO62214 | 2024-05-08 | 0.18 | 0.86 |
SO68750_1 | 100 | 15655 | 597 | 8 | 2024-08-18 | 13.50 | 2024-08-06 | 539.99 | 1 | SO68750 | 2024-08-13 | 43.20 | 294.58 | |
SO44031_1 | 98 | 13689 | 313 | 10 | 2021-12-20 | 89.46 | 2021-12-08 | 3578.27 | 1 | SO44031 | 2021-12-15 | 286.26 | 2171.29 | |
SO55662_1 | 100 | 12926 | 353 | 4 | 2024-02-01 | 58.00 | 2024-01-20 | 2319.99 | 1 | SO55662 | 2024-01-27 | 185.60 | 1265.62 | |
SO62215_1 | 98 | 14191 | 564 | 10 | 2024-05-13 | 59.60 | 2024-05-01 | 2384.07 | 1 | SO62215 | 2024-05-08 | 190.73 | 1481.94 | |
SO68750_2 | 100 | 15655 | 528 | 8 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 2 | SO68750 | 2024-08-13 | 0.40 | 1.87 | |
SO44032_1 | 98 | 11243 | 344 | 10 | 2021-12-20 | 85.00 | 2021-12-08 | 3399.99 | 1 | SO44032 | 2021-12-15 | 272.00 | 1912.15 | |
SO55662_2 | 100 | 12926 | 485 | 4 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 2 | SO55662 | 2024-01-27 | 1.76 | 8.22 | |
SO62216_1 | 100 | 26963 | 578 | 8 | 2024-05-13 | 30.37 | 2024-05-01 | 1214.85 | 1 | SO62216 | 2024-05-08 | 97.19 | 755.15 | |
SO68750_3 | 100 | 15655 | 535 | 8 | 2024-08-18 | 0.62 | 2024-08-06 | 24.99 | 3 | SO68750 | 2024-08-13 | 2.00 | 9.35 | |
SO44033_1 | 6 | 16693 | 314 | 9 | 2021-12-20 | 89.46 | 2021-12-08 | 3578.27 | 1 | SO44033 | 2021-12-15 | 286.26 | 2171.29 | |
SO55662_3 | 100 | 12926 | 478 | 4 | 2024-02-01 | 0.25 | 2024-01-20 | 9.99 | 3 | SO55662 | 2024-01-27 | 0.80 | 3.74 | |
SO62216_2 | 100 | 26963 | 479 | 8 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 2 | SO62216 | 2024-05-08 | 0.72 | 3.36 | |
SO68750_4 | 100 | 15655 | 480 | 2 | 8 | 2024-08-18 | 0.06 | 2024-08-06 | 2.29 | 4 | SO68750 | 2024-08-13 | 0.18 | 0.86 |
SO44034_1 | 6 | 16702 | 313 | 9 | 2021-12-20 | 89.46 | 2021-12-08 | 3578.27 | 1 | SO44034 | 2021-12-15 | 286.26 | 2171.29 | |
SO55663_1 | 98 | 12289 | 579 | 10 | 2024-02-01 | 30.37 | 2024-01-20 | 1214.85 | 1 | SO55663 | 2024-01-27 | 97.19 | 755.15 | |
SO62216_3 | 100 | 26963 | 477 | 8 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 3 | SO62216 | 2024-05-08 | 0.40 | 1.87 | |
SO68751_1 | 100 | 26267 | 538 | 4 | 2024-08-18 | 0.54 | 2024-08-06 | 21.49 | 1 | SO68751 | 2024-08-13 | 1.72 | 8.04 | |
SO44035_1 | 6 | 16707 | 312 | 9 | 2021-12-20 | 89.46 | 2021-12-08 | 3578.27 | 1 | SO44035 | 2021-12-15 | 286.26 | 2171.29 | |
SO55663_2 | 98 | 12289 | 477 | 10 | 2024-02-01 | 0.12 | 2024-01-20 | 4.99 | 2 | SO55663 | 2024-01-27 | 0.40 | 1.87 | |
SO62216_4 | 100 | 26963 | 225 | 8 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 4 | SO62216 | 2024-05-08 | 0.72 | 6.92 | |
SO68752_1 | 100 | 26612 | 541 | 4 | 2024-08-18 | 0.72 | 2024-08-06 | 28.99 | 1 | SO68752 | 2024-08-13 | 2.32 | 10.84 | |
SO44036_1 | 6 | 17046 | 310 | 9 | 2021-12-20 | 89.46 | 2021-12-08 | 3578.27 | 1 | SO44036 | 2021-12-15 | 286.26 | 2171.29 | |
SO55663_3 | 98 | 12289 | 479 | 10 | 2024-02-01 | 0.22 | 2024-01-20 | 8.99 | 3 | SO55663 | 2024-01-27 | 0.72 | 3.36 | |
SO62217_1 | 6 | 23432 | 583 | 9 | 2024-05-13 | 42.52 | 2024-05-01 | 1700.99 | 1 | SO62217 | 2024-05-08 | 136.08 | 1082.51 | |
SO68752_2 | 100 | 26612 | 530 | 4 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 2 | SO68752 | 2024-08-13 | 0.40 | 1.87 | |
SO44037_1 | 6 | 25272 | 328 | 9 | 2021-12-20 | 17.48 | 2021-12-08 | 699.10 | 1 | SO44037 | 2021-12-15 | 55.93 | 413.15 | |
SO55663_4 | 98 | 12289 | 484 | 10 | 2024-02-01 | 0.20 | 2024-01-20 | 7.95 | 4 | SO55663 | 2024-01-27 | 0.64 | 2.97 | |
SO62217_2 | 6 | 23432 | 214 | 9 | 2024-05-13 | 0.87 | 2024-05-01 | 34.99 | 2 | SO62217 | 2024-05-08 | 2.80 | 13.09 | |
SO68752_3 | 100 | 26612 | 463 | 4 | 2024-08-18 | 0.61 | 2024-08-06 | 24.49 | 3 | SO68752 | 2024-08-13 | 1.96 | 9.16 | |
SO44038_1 | 100 | 25868 | 344 | 4 | 2021-12-20 | 85.00 | 2021-12-08 | 3399.99 | 1 | SO44038 | 2021-12-15 | 272.00 | 1912.15 | |
SO55664_1 | 6 | 14303 | 589 | 9 | 2024-02-01 | 19.24 | 2024-01-20 | 769.49 | 1 | SO55664 | 2024-01-27 | 61.56 | 419.78 | |
SO62218_1 | 6 | 20613 | 378 | 9 | 2024-05-13 | 61.08 | 2024-05-01 | 2443.35 | 1 | SO62218 | 2024-05-08 | 195.47 | 1554.95 | |
SO68753_1 | 19 | 12936 | 530 | 6 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 1 | SO68753 | 2024-08-13 | 0.40 | 1.87 | |
SO44039_1 | 39 | 17971 | 342 | 7 | 2021-12-21 | 17.48 | 2021-12-09 | 699.10 | 1 | SO44039 | 2021-12-16 | 55.93 | 413.15 | |
SO55664_2 | 6 | 14303 | 485 | 9 | 2024-02-01 | 0.55 | 2024-01-20 | 21.98 | 2 | SO55664 | 2024-01-27 | 1.76 | 8.22 |
Generated 2024-11-14 05:42:15.518 UTC