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