[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 335 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO62138_1 | 6 | 13527 | 378 | 9 | 2024-05-12 | 61.08 | 2024-04-30 | 2443.35 | 1 | SO62138 | 2024-05-07 | 195.47 | 1554.95 | |
SO68680_1 | 6 | 12706 | 561 | 9 | 2024-08-16 | 59.60 | 2024-08-04 | 2384.07 | 1 | SO68680 | 2024-08-11 | 190.73 | 1481.94 | |
SO43781_1 | 6 | 16495 | 312 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43781 | 2021-11-11 | 286.26 | 2171.29 | |
SO55595_2 | 100 | 19121 | 485 | 4 | 2024-01-31 | 0.55 | 2024-01-19 | 21.98 | 2 | SO55595 | 2024-01-26 | 1.76 | 8.22 | |
SO62138_2 | 6 | 13527 | 529 | 9 | 2024-05-12 | 0.10 | 2024-04-30 | 3.99 | 2 | SO62138 | 2024-05-07 | 0.32 | 1.49 | |
SO68680_2 | 6 | 12706 | 479 | 9 | 2024-08-16 | 0.22 | 2024-08-04 | 8.99 | 2 | SO68680 | 2024-08-11 | 0.72 | 3.36 | |
SO43782_1 | 6 | 16516 | 312 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43782 | 2021-11-11 | 286.26 | 2171.29 | |
SO55595_3 | 100 | 19121 | 478 | 4 | 2024-01-31 | 0.25 | 2024-01-19 | 9.99 | 3 | SO55595 | 2024-01-26 | 0.80 | 3.74 | |
SO62138_3 | 6 | 13527 | 540 | 9 | 2024-05-12 | 0.82 | 2024-04-30 | 32.60 | 3 | SO62138 | 2024-05-07 | 2.61 | 12.19 | |
SO68680_3 | 6 | 12706 | 477 | 9 | 2024-08-16 | 0.12 | 2024-08-04 | 4.99 | 3 | SO68680 | 2024-08-11 | 0.40 | 1.87 | |
SO43783_1 | 6 | 16620 | 312 | 9 | 2021-11-16 | 89.46 | 2021-11-04 | 3578.27 | 1 | SO43783 | 2021-11-11 | 286.26 | 2171.29 | |
SO55595_4 | 100 | 19121 | 477 | 4 | 2024-01-31 | 0.12 | 2024-01-19 | 4.99 | 4 | SO55595 | 2024-01-26 | 0.40 | 1.87 | |
SO62139_1 | 6 | 17354 | 378 | 9 | 2024-05-12 | 61.08 | 2024-04-30 | 2443.35 | 1 | SO62139 | 2024-05-07 | 195.47 | 1554.95 | |
SO68680_4 | 6 | 12706 | 234 | 9 | 2024-08-16 | 1.25 | 2024-08-04 | 49.99 | 4 | SO68680 | 2024-08-11 | 4.00 | 38.49 | |
SO43784_1 | 100 | 27667 | 310 | 4 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43784 | 2021-11-12 | 286.26 | 2171.29 | |
SO55595_5 | 100 | 19121 | 487 | 4 | 2024-01-31 | 1.37 | 2024-01-19 | 54.99 | 5 | SO55595 | 2024-01-26 | 4.40 | 20.57 | |
SO62139_2 | 6 | 17354 | 484 | 9 | 2024-05-12 | 0.20 | 2024-04-30 | 7.95 | 2 | SO62139 | 2024-05-07 | 0.64 | 2.97 | |
SO68681_1 | 6 | 13012 | 573 | 9 | 2024-08-16 | 59.60 | 2024-08-04 | 2384.07 | 1 | SO68681 | 2024-08-11 | 190.73 | 1481.94 | |
SO43785_1 | 39 | 11601 | 311 | 7 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43785 | 2021-11-12 | 286.26 | 2171.29 | |
SO55596_1 | 100 | 19122 | 594 | 4 | 2024-01-31 | 14.12 | 2024-01-19 | 564.99 | 1 | SO55596 | 2024-01-26 | 45.20 | 308.22 | |
SO62140_1 | 6 | 17351 | 374 | 9 | 2024-05-12 | 61.08 | 2024-04-30 | 2443.35 | 1 | SO62140 | 2024-05-07 | 195.47 | 1554.95 | |
SO68681_2 | 6 | 13012 | 479 | 9 | 2024-08-16 | 0.22 | 2024-08-04 | 8.99 | 2 | SO68681 | 2024-08-11 | 0.72 | 3.36 | |
SO43786_1 | 39 | 11607 | 311 | 7 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43786 | 2021-11-12 | 286.26 | 2171.29 | |
SO55596_2 | 100 | 19122 | 478 | 4 | 2024-01-31 | 0.25 | 2024-01-19 | 9.99 | 2 | SO55596 | 2024-01-26 | 0.80 | 3.74 | |
SO62140_2 | 6 | 17351 | 540 | 9 | 2024-05-12 | 0.82 | 2024-04-30 | 32.60 | 2 | SO62140 | 2024-05-07 | 2.61 | 12.19 | |
SO68681_3 | 6 | 13012 | 477 | 9 | 2024-08-16 | 0.12 | 2024-08-04 | 4.99 | 3 | SO68681 | 2024-08-11 | 0.40 | 1.87 | |
SO43787_1 | 29 | 29385 | 344 | 8 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43787 | 2021-11-12 | 272.00 | 1912.15 | |
SO55596_3 | 100 | 19122 | 225 | 4 | 2024-01-31 | 0.22 | 2024-01-19 | 8.99 | 3 | SO55596 | 2024-01-26 | 0.72 | 6.92 | |
SO62140_3 | 6 | 17351 | 529 | 9 | 2024-05-12 | 0.10 | 2024-04-30 | 3.99 | 3 | SO62140 | 2024-05-07 | 0.32 | 1.49 | |
SO68681_4 | 6 | 13012 | 491 | 9 | 2024-08-16 | 1.35 | 2024-08-04 | 53.99 | 4 | SO68681 | 2024-08-11 | 4.32 | 41.57 | |
SO43788_1 | 98 | 11239 | 351 | 10 | 2021-11-17 | 84.37 | 2021-11-05 | 3374.99 | 1 | SO43788 | 2021-11-12 | 270.00 | 1898.09 | |
SO55596_4 | 100 | 19122 | 477 | 4 | 2024-01-31 | 0.12 | 2024-01-19 | 4.99 | 4 | SO55596 | 2024-01-26 | 0.40 | 1.87 | |
SO62140_4 | 6 | 17351 | 214 | 9 | 2024-05-12 | 0.87 | 2024-04-30 | 34.99 | 4 | SO62140 | 2024-05-07 | 2.80 | 13.09 | |
SO68682_1 | 6 | 13075 | 573 | 9 | 2024-08-16 | 59.60 | 2024-08-04 | 2384.07 | 1 | SO68682 | 2024-08-11 | 190.73 | 1481.94 | |
SO43789_1 | 100 | 25865 | 351 | 1 | 2021-11-17 | 84.37 | 2021-11-05 | 3374.99 | 1 | SO43789 | 2021-11-12 | 270.00 | 1898.09 | |
SO55597_1 | 19 | 13284 | 363 | 2 | 6 | 2024-01-31 | 57.37 | 2024-01-19 | 2294.99 | 1 | SO55597 | 2024-01-26 | 183.60 | 1251.98 |
SO62140_5 | 6 | 17351 | 465 | 9 | 2024-05-12 | 0.61 | 2024-04-30 | 24.49 | 5 | SO62140 | 2024-05-07 | 1.96 | 9.16 | |
SO68682_2 | 6 | 13075 | 541 | 9 | 2024-08-16 | 0.72 | 2024-08-04 | 28.99 | 2 | SO68682 | 2024-08-11 | 2.32 | 10.84 | |
SO43790_1 | 100 | 25857 | 344 | 1 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43790 | 2021-11-12 | 272.00 | 1912.15 | |
SO55597_2 | 19 | 13284 | 487 | 6 | 2024-01-31 | 1.37 | 2024-01-19 | 54.99 | 2 | SO55597 | 2024-01-26 | 4.40 | 20.57 | |
SO62141_1 | 6 | 24485 | 386 | 9 | 2024-05-12 | 28.01 | 2024-04-30 | 1120.49 | 1 | SO62141 | 2024-05-07 | 89.64 | 713.08 | |
SO68682_3 | 6 | 13075 | 530 | 9 | 2024-08-16 | 0.12 | 2024-08-04 | 4.99 | 3 | SO68682 | 2024-08-11 | 0.40 | 1.87 | |
SO43791_1 | 6 | 16484 | 314 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43791 | 2021-11-12 | 286.26 | 2171.29 | |
SO55597_3 | 19 | 13284 | 463 | 6 | 2024-01-31 | 0.61 | 2024-01-19 | 24.49 | 3 | SO55597 | 2024-01-26 | 1.96 | 9.16 | |
SO62141_2 | 6 | 24485 | 489 | 9 | 2024-05-12 | 1.35 | 2024-04-30 | 53.99 | 2 | SO62141 | 2024-05-07 | 4.32 | 41.57 | |
SO68682_4 | 6 | 13075 | 217 | 9 | 2024-08-16 | 0.87 | 2024-08-04 | 34.99 | 4 | SO68682 | 2024-08-11 | 2.80 | 13.09 | |
SO43792_1 | 6 | 16623 | 312 | 9 | 2021-11-17 | 89.46 | 2021-11-05 | 3578.27 | 1 | SO43792 | 2021-11-12 | 286.26 | 2171.29 | |
SO55598_1 | 100 | 12941 | 353 | 2 | 1 | 2024-01-31 | 58.00 | 2024-01-19 | 2319.99 | 1 | SO55598 | 2024-01-26 | 185.60 | 1265.62 |
SO62142_1 | 6 | 13128 | 359 | 9 | 2024-05-12 | 57.37 | 2024-04-30 | 2294.99 | 1 | SO62142 | 2024-05-07 | 183.60 | 1251.98 | |
SO68682_5 | 6 | 13075 | 463 | 9 | 2024-08-16 | 0.61 | 2024-08-04 | 24.49 | 5 | SO68682 | 2024-08-11 | 1.96 | 9.16 | |
SO43793_1 | 6 | 11000 | 344 | 9 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43793 | 2021-11-12 | 272.00 | 1912.15 | |
SO55598_2 | 100 | 12941 | 487 | 1 | 2024-01-31 | 1.37 | 2024-01-19 | 54.99 | 2 | SO55598 | 2024-01-26 | 4.40 | 20.57 | |
SO62142_2 | 6 | 13128 | 214 | 9 | 2024-05-12 | 0.87 | 2024-04-30 | 34.99 | 2 | SO62142 | 2024-05-07 | 2.80 | 13.09 | |
SO68683_1 | 6 | 17259 | 590 | 9 | 2024-08-17 | 19.24 | 2024-08-05 | 769.49 | 1 | SO68683 | 2024-08-12 | 61.56 | 419.78 | |
SO43794_1 | 6 | 11029 | 347 | 9 | 2021-11-17 | 85.00 | 2021-11-05 | 3399.99 | 1 | SO43794 | 2021-11-12 | 272.00 | 1912.15 | |
SO55599_1 | 100 | 11040 | 353 | 1 | 2024-01-31 | 58.00 | 2024-01-19 | 2319.99 | 1 | SO55599 | 2024-01-26 | 185.60 | 1265.62 |
Generated 2024-11-14 16:52:18.924 UTC