[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO55562_1 | 100 | 11828 | 490 | 1 | 2024-01-31 | 1.35 | 2024-01-19 | 53.99 | 1 | SO55562 | 2024-01-26 | 4.32 | 41.57 |
SO62104_4 | 100 | 24978 | 471 | 1 | 2024-05-12 | 1.59 | 2024-04-30 | 63.50 | 4 | SO62104 | 2024-05-07 | 5.08 | 23.75 |
SO43699_1 | 100 | 25863 | 346 | 1 | 2021-10-27 | 85.00 | 2021-10-15 | 3399.99 | 1 | SO43699 | 2021-10-22 | 272.00 | 1912.15 |
SO55563_1 | 100 | 11187 | 529 | 1 | 2024-01-31 | 0.10 | 2024-01-19 | 3.99 | 1 | SO55563 | 2024-01-26 | 0.32 | 1.49 |
SO62108_1 | 100 | 21353 | 478 | 1 | 2024-05-12 | 0.25 | 2024-04-30 | 9.99 | 1 | SO62108 | 2024-05-07 | 0.80 | 3.74 |
SO43711_1 | 100 | 27606 | 314 | 1 | 2021-10-30 | 89.46 | 2021-10-18 | 3578.27 | 1 | SO43711 | 2021-10-25 | 286.26 | 2171.29 |
SO55563_2 | 100 | 11187 | 471 | 1 | 2024-01-31 | 1.59 | 2024-01-19 | 63.50 | 2 | SO55563 | 2024-01-26 | 5.08 | 23.75 |
SO62108_2 | 100 | 21353 | 217 | 1 | 2024-05-12 | 0.87 | 2024-04-30 | 34.99 | 2 | SO62108 | 2024-05-07 | 2.80 | 13.09 |
SO43718_1 | 100 | 27668 | 311 | 1 | 2021-11-01 | 89.46 | 2021-10-20 | 3578.27 | 1 | SO43718 | 2021-10-27 | 286.26 | 2171.29 |
SO55564_1 | 100 | 29324 | 529 | 1 | 2024-01-31 | 0.10 | 2024-01-19 | 3.99 | 1 | SO55564 | 2024-01-26 | 0.32 | 1.49 |
SO62111_1 | 100 | 17689 | 477 | 1 | 2024-05-12 | 0.12 | 2024-04-30 | 4.99 | 1 | SO62111 | 2024-05-07 | 0.40 | 1.87 |
SO43723_1 | 100 | 14520 | 332 | 1 | 2021-11-02 | 17.48 | 2021-10-21 | 699.10 | 1 | SO43723 | 2021-10-28 | 55.93 | 413.15 |
SO55564_2 | 100 | 29324 | 222 | 1 | 2024-01-31 | 0.87 | 2024-01-19 | 34.99 | 2 | SO55564 | 2024-01-26 | 2.80 | 13.09 |
SO62132_1 | 100 | 19718 | 595 | 1 | 2024-05-12 | 14.12 | 2024-04-30 | 564.99 | 1 | SO62132 | 2024-05-07 | 45.20 | 308.22 |
SO43733_1 | 100 | 27577 | 312 | 1 | 2021-11-04 | 89.46 | 2021-10-23 | 3578.27 | 1 | SO43733 | 2021-10-30 | 286.26 | 2171.29 |
SO55567_1 | 100 | 27658 | 538 | 1 | 2024-01-31 | 0.54 | 2024-01-19 | 21.49 | 1 | SO55567 | 2024-01-26 | 1.72 | 8.04 |
SO62132_2 | 100 | 19718 | 478 | 1 | 2024-05-12 | 0.25 | 2024-04-30 | 9.99 | 2 | SO62132 | 2024-05-07 | 0.80 | 3.74 |
SO43734_1 | 100 | 27604 | 312 | 1 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43734 | 2021-10-31 | 286.26 | 2171.29 |
SO55567_2 | 100 | 27658 | 529 | 1 | 2024-01-31 | 0.10 | 2024-01-19 | 3.99 | 2 | SO55567 | 2024-01-26 | 0.32 | 1.49 |
SO62132_3 | 100 | 19718 | 477 | 1 | 2024-05-12 | 0.12 | 2024-04-30 | 4.99 | 3 | SO62132 | 2024-05-07 | 0.40 | 1.87 |
SO43741_1 | 100 | 27671 | 310 | 1 | 2021-11-07 | 89.46 | 2021-10-26 | 3578.27 | 1 | SO43741 | 2021-11-02 | 286.26 | 2171.29 |
SO55567_3 | 100 | 27658 | 480 | 1 | 2024-01-31 | 0.06 | 2024-01-19 | 2.29 | 3 | SO55567 | 2024-01-26 | 0.18 | 0.86 |
SO62147_1 | 100 | 26616 | 586 | 1 | 2024-05-12 | 18.56 | 2024-04-30 | 742.35 | 1 | SO62147 | 2024-05-07 | 59.39 | 461.44 |
SO43748_1 | 100 | 27625 | 313 | 1 | 2021-11-09 | 89.46 | 2021-10-28 | 3578.27 | 1 | SO43748 | 2021-11-04 | 286.26 | 2171.29 |
SO55573_1 | 100 | 23029 | 536 | 1 | 2024-01-31 | 0.75 | 2024-01-19 | 29.99 | 1 | SO55573 | 2024-01-26 | 2.40 | 11.22 |
SO62147_2 | 100 | 26616 | 225 | 1 | 2024-05-12 | 0.22 | 2024-04-30 | 8.99 | 2 | SO62147 | 2024-05-07 | 0.72 | 6.92 |
SO43749_1 | 100 | 27636 | 314 | 1 | 2021-11-09 | 89.46 | 2021-10-28 | 3578.27 | 1 | SO43749 | 2021-11-04 | 286.26 | 2171.29 |
SO55573_2 | 100 | 23029 | 528 | 1 | 2024-01-31 | 0.12 | 2024-01-19 | 4.99 | 2 | SO55573 | 2024-01-26 | 0.40 | 1.87 |
SO62150_1 | 100 | 23195 | 584 | 1 | 2024-05-12 | 13.50 | 2024-04-30 | 539.99 | 1 | SO62150 | 2024-05-07 | 43.20 | 343.65 |
SO43754_1 | 100 | 27617 | 312 | 1 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43754 | 2021-11-05 | 286.26 | 2171.29 |
SO55573_3 | 100 | 23029 | 485 | 1 | 2024-01-31 | 0.55 | 2024-01-19 | 21.98 | 3 | SO55573 | 2024-01-26 | 1.76 | 8.22 |
SO62150_2 | 100 | 23195 | 477 | 1 | 2024-05-12 | 0.12 | 2024-04-30 | 4.99 | 2 | SO62150 | 2024-05-07 | 0.40 | 1.87 |
SO43768_1 | 100 | 27649 | 312 | 1 | 2021-11-14 | 89.46 | 2021-11-02 | 3578.27 | 1 | SO43768 | 2021-11-09 | 286.26 | 2171.29 |
SO55573_4 | 100 | 23029 | 473 | 1 | 2024-01-31 | 1.59 | 2024-01-19 | 63.50 | 4 | SO55573 | 2024-01-26 | 5.08 | 23.75 |
SO62150_3 | 100 | 23195 | 479 | 1 | 2024-05-12 | 0.22 | 2024-04-30 | 8.99 | 3 | SO62150 | 2024-05-07 | 0.72 | 3.36 |
SO43770_1 | 100 | 27614 | 312 | 1 | 2021-11-14 | 89.46 | 2021-11-02 | 3578.27 | 1 | SO43770 | 2021-11-09 | 286.26 | 2171.29 |
SO55577_1 | 100 | 17392 | 225 | 1 | 2024-01-31 | 0.22 | 2024-01-19 | 8.99 | 1 | SO55577 | 2024-01-26 | 0.72 | 6.92 |
SO62150_4 | 100 | 23195 | 222 | 1 | 2024-05-12 | 0.87 | 2024-04-30 | 34.99 | 4 | SO62150 | 2024-05-07 | 2.80 | 13.09 |
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 |
SO55577_2 | 100 | 17392 | 477 | 1 | 2024-01-31 | 0.12 | 2024-01-19 | 4.99 | 2 | SO55577 | 2024-01-26 | 0.40 | 1.87 |
SO62150_5 | 100 | 23195 | 234 | 1 | 2024-05-12 | 1.25 | 2024-04-30 | 49.99 | 5 | SO62150 | 2024-05-07 | 4.00 | 38.49 |
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 |
SO55579_1 | 100 | 15963 | 528 | 1 | 2024-01-31 | 0.12 | 2024-01-19 | 4.99 | 1 | SO55579 | 2024-01-26 | 0.40 | 1.87 |
SO62179_1 | 100 | 11646 | 488 | 1 | 2024-05-13 | 1.35 | 2024-05-01 | 53.99 | 1 | SO62179 | 2024-05-08 | 4.32 | 41.57 |
SO43805_1 | 100 | 14510 | 328 | 1 | 2021-11-20 | 17.48 | 2021-11-08 | 699.10 | 1 | SO43805 | 2021-11-15 | 55.93 | 413.15 |
SO55579_2 | 100 | 15963 | 214 | 1 | 2024-01-31 | 0.87 | 2024-01-19 | 34.99 | 2 | SO55579 | 2024-01-26 | 2.80 | 13.09 |
SO62182_1 | 100 | 27391 | 530 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 1 | SO62182 | 2024-05-08 | 0.40 | 1.87 |
SO43814_1 | 100 | 25866 | 350 | 1 | 2021-11-22 | 84.37 | 2021-11-10 | 3374.99 | 1 | SO43814 | 2021-11-17 | 270.00 | 1898.09 |
SO55579_3 | 100 | 15963 | 237 | 1 | 2024-01-31 | 1.25 | 2024-01-19 | 49.99 | 3 | SO55579 | 2024-01-26 | 4.00 | 38.49 |
SO62182_2 | 100 | 27391 | 541 | 1 | 2024-05-13 | 0.72 | 2024-05-01 | 28.99 | 2 | SO62182 | 2024-05-08 | 2.32 | 10.84 |
SO43824_1 | 100 | 14558 | 338 | 1 | 2021-11-23 | 17.48 | 2021-11-11 | 699.10 | 1 | SO43824 | 2021-11-18 | 55.93 | 413.15 |
SO55591_1 | 100 | 12757 | 485 | 1 | 2024-01-31 | 0.55 | 2024-01-19 | 21.98 | 1 | SO55591 | 2024-01-26 | 1.76 | 8.22 |
SO62184_1 | 100 | 26451 | 535 | 1 | 2024-05-13 | 0.62 | 2024-05-01 | 24.99 | 1 | SO62184 | 2024-05-08 | 2.00 | 9.35 |
SO43828_1 | 100 | 27605 | 310 | 1 | 2021-11-24 | 89.46 | 2021-11-12 | 3578.27 | 1 | SO43828 | 2021-11-19 | 286.26 | 2171.29 |
SO55591_2 | 100 | 12757 | 222 | 1 | 2024-01-31 | 0.87 | 2024-01-19 | 34.99 | 2 | SO55591 | 2024-01-26 | 2.80 | 13.09 |
SO62184_2 | 100 | 26451 | 480 | 1 | 2024-05-13 | 0.06 | 2024-05-01 | 2.29 | 2 | SO62184 | 2024-05-08 | 0.18 | 0.86 |
SO43839_1 | 100 | 27673 | 311 | 1 | 2021-11-26 | 89.46 | 2021-11-14 | 3578.27 | 1 | SO43839 | 2021-11-21 | 286.26 | 2171.29 |
SO55591_3 | 100 | 12757 | 234 | 1 | 2024-01-31 | 1.25 | 2024-01-19 | 49.99 | 3 | SO55591 | 2024-01-26 | 4.00 | 38.49 |
SO62186_1 | 100 | 27474 | 529 | 1 | 2024-05-13 | 0.10 | 2024-05-01 | 3.99 | 1 | SO62186 | 2024-05-08 | 0.32 | 1.49 |
SO43967_1 | 100 | 28040 | 313 | 1 | 2021-12-07 | 89.46 | 2021-11-25 | 3578.27 | 1 | SO43967 | 2021-12-02 | 286.26 | 2171.29 |
SO55594_1 | 100 | 16951 | 582 | 1 | 2024-01-31 | 42.52 | 2024-01-19 | 1700.99 | 1 | SO55594 | 2024-01-26 | 136.08 | 1082.51 |
SO62186_2 | 100 | 27474 | 538 | 1 | 2024-05-13 | 0.54 | 2024-05-01 | 21.49 | 2 | SO62186 | 2024-05-08 | 1.72 | 8.04 |
Generated 2024-11-14 16:47:01.928 UTC