[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 187 < SKIP 1562 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO57496_1 | 100 | 23822 | 536 | 1 | 2024-01-08 | 0.75 | 2023-12-27 | 29.99 | 1 | SO57496 | 2024-01-03 | 2.40 | 11.22 | |
SO57496_2 | 100 | 23822 | 528 | 1 | 2024-01-08 | 0.12 | 2023-12-27 | 4.99 | 2 | SO57496 | 2024-01-03 | 0.40 | 1.87 | |
SO57496_3 | 100 | 23822 | 480 | 1 | 2024-01-08 | 0.06 | 2023-12-27 | 2.29 | 3 | SO57496 | 2024-01-03 | 0.18 | 0.86 | |
SO57500_1 | 100 | 18676 | 475 | 1 | 2024-01-08 | 1.75 | 2023-12-27 | 69.99 | 1 | SO57500 | 2024-01-03 | 5.60 | 26.18 | |
SO57500_2 | 100 | 18676 | 237 | 1 | 2024-01-08 | 1.25 | 2023-12-27 | 49.99 | 2 | SO57500 | 2024-01-03 | 4.00 | 38.49 | |
SO57502_1 | 100 | 13926 | 485 | 1 | 2024-01-08 | 0.55 | 2023-12-27 | 21.98 | 1 | SO57502 | 2024-01-03 | 1.76 | 8.22 | |
SO57502_2 | 100 | 13926 | 214 | 1 | 2024-01-08 | 0.87 | 2023-12-27 | 34.99 | 2 | SO57502 | 2024-01-03 | 2.80 | 13.09 | |
SO57504_1 | 100 | 14570 | 528 | 1 | 2024-01-08 | 0.12 | 2023-12-27 | 4.99 | 1 | SO57504 | 2024-01-03 | 0.40 | 1.87 | |
SO57504_2 | 100 | 14570 | 214 | 1 | 2024-01-08 | 0.87 | 2023-12-27 | 34.99 | 2 | SO57504 | 2024-01-03 | 2.80 | 13.09 | |
SO57514_1 | 100 | 13052 | 485 | 1 | 2024-01-08 | 0.55 | 2023-12-27 | 21.98 | 1 | SO57514 | 2024-01-03 | 1.76 | 8.22 | |
SO57514_2 | 100 | 13052 | 481 | 1 | 2024-01-08 | 0.22 | 2023-12-27 | 8.99 | 2 | SO57514 | 2024-01-03 | 0.72 | 3.36 | |
SO57545_1 | 100 | 27730 | 529 | 1 | 2024-01-09 | 0.10 | 2023-12-28 | 3.99 | 1 | SO57545 | 2024-01-04 | 0.32 | 1.49 | |
SO57546_1 | 100 | 28278 | 530 | 1 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 1 | SO57546 | 2024-01-04 | 0.40 | 1.87 | |
SO57546_2 | 100 | 28278 | 217 | 1 | 2024-01-09 | 0.87 | 2023-12-28 | 34.99 | 2 | SO57546 | 2024-01-04 | 2.80 | 13.09 | |
SO57549_1 | 100 | 26333 | 528 | 1 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 1 | SO57549 | 2024-01-04 | 0.40 | 1.87 | |
SO57549_2 | 100 | 26333 | 535 | 1 | 2024-01-09 | 0.62 | 2023-12-28 | 24.99 | 2 | SO57549 | 2024-01-04 | 2.00 | 9.35 | |
SO57549_3 | 100 | 26333 | 480 | 2 | 1 | 2024-01-09 | 0.06 | 2023-12-28 | 2.29 | 3 | SO57549 | 2024-01-04 | 0.18 | 0.86 |
SO57555_1 | 100 | 17505 | 528 | 1 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 1 | SO57555 | 2024-01-04 | 0.40 | 1.87 | |
SO57555_2 | 100 | 17505 | 480 | 2 | 1 | 2024-01-09 | 0.06 | 2023-12-28 | 2.29 | 2 | SO57555 | 2024-01-04 | 0.18 | 0.86 |
SO57565_1 | 100 | 11662 | 537 | 1 | 2024-01-09 | 0.88 | 2023-12-28 | 35.00 | 1 | SO57565 | 2024-01-04 | 2.80 | 13.09 | |
SO57565_2 | 100 | 11662 | 480 | 1 | 2024-01-09 | 0.06 | 2023-12-28 | 2.29 | 2 | SO57565 | 2024-01-04 | 0.18 | 0.86 | |
SO57570_1 | 100 | 13014 | 537 | 1 | 2024-01-09 | 0.88 | 2023-12-28 | 35.00 | 1 | SO57570 | 2024-01-04 | 2.80 | 13.09 | |
SO57570_2 | 100 | 13014 | 528 | 1 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 2 | SO57570 | 2024-01-04 | 0.40 | 1.87 | |
SO57570_3 | 100 | 13014 | 217 | 1 | 2024-01-09 | 0.87 | 2023-12-28 | 34.99 | 3 | SO57570 | 2024-01-04 | 2.80 | 13.09 | |
SO57571_1 | 100 | 13703 | 537 | 1 | 2024-01-09 | 0.88 | 2023-12-28 | 35.00 | 1 | SO57571 | 2024-01-04 | 2.80 | 13.09 | |
SO57571_2 | 100 | 13703 | 528 | 1 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 2 | SO57571 | 2024-01-04 | 0.40 | 1.87 | |
SO57571_3 | 100 | 13703 | 214 | 1 | 2024-01-09 | 0.87 | 2023-12-28 | 34.99 | 3 | SO57571 | 2024-01-04 | 2.80 | 13.09 | |
SO57580_1 | 100 | 13414 | 355 | 1 | 2024-01-09 | 58.00 | 2023-12-28 | 2319.99 | 1 | SO57580 | 2024-01-04 | 185.60 | 1265.62 | |
SO57586_1 | 100 | 28870 | 572 | 2 | 1 | 2024-01-09 | 18.56 | 2023-12-28 | 742.35 | 1 | SO57586 | 2024-01-04 | 59.39 | 461.44 |
SO57586_2 | 100 | 28870 | 479 | 1 | 2024-01-09 | 0.22 | 2023-12-28 | 8.99 | 2 | SO57586 | 2024-01-04 | 0.72 | 3.36 | |
SO57586_3 | 100 | 28870 | 477 | 1 | 2024-01-09 | 0.12 | 2023-12-28 | 4.99 | 3 | SO57586 | 2024-01-04 | 0.40 | 1.87 | |
SO57589_1 | 100 | 22135 | 604 | 1 | 2024-01-09 | 13.50 | 2023-12-28 | 539.99 | 1 | SO57589 | 2024-01-04 | 43.20 | 343.65 | |
SO57589_2 | 100 | 22135 | 217 | 1 | 2024-01-09 | 0.87 | 2023-12-28 | 34.99 | 2 | SO57589 | 2024-01-04 | 2.80 | 13.09 | |
SO57602_1 | 100 | 25207 | 535 | 1 | 2024-01-10 | 0.62 | 2023-12-29 | 24.99 | 1 | SO57602 | 2024-01-05 | 2.00 | 9.35 | |
SO57602_2 | 100 | 25207 | 528 | 1 | 2024-01-10 | 0.12 | 2023-12-29 | 4.99 | 2 | SO57602 | 2024-01-05 | 0.40 | 1.87 | |
SO57602_3 | 100 | 25207 | 485 | 1 | 2024-01-10 | 0.55 | 2023-12-29 | 21.98 | 3 | SO57602 | 2024-01-05 | 1.76 | 8.22 | |
SO57602_4 | 100 | 25207 | 214 | 1 | 2024-01-10 | 0.87 | 2023-12-29 | 34.99 | 4 | SO57602 | 2024-01-05 | 2.80 | 13.09 | |
SO57606_1 | 100 | 23280 | 478 | 1 | 2024-01-10 | 0.25 | 2023-12-29 | 9.99 | 1 | SO57606 | 2024-01-05 | 0.80 | 3.74 | |
SO57606_2 | 100 | 23280 | 477 | 1 | 2024-01-10 | 0.12 | 2023-12-29 | 4.99 | 2 | SO57606 | 2024-01-05 | 0.40 | 1.87 | |
SO57608_1 | 100 | 21456 | 478 | 1 | 2024-01-10 | 0.25 | 2023-12-29 | 9.99 | 1 | SO57608 | 2024-01-05 | 0.80 | 3.74 | |
SO57608_2 | 100 | 21456 | 477 | 1 | 2024-01-10 | 0.12 | 2023-12-29 | 4.99 | 2 | SO57608 | 2024-01-05 | 0.40 | 1.87 | |
SO57608_3 | 100 | 21456 | 217 | 1 | 2024-01-10 | 0.87 | 2023-12-29 | 34.99 | 3 | SO57608 | 2024-01-05 | 2.80 | 13.09 | |
SO57608_4 | 100 | 21456 | 490 | 1 | 2024-01-10 | 1.35 | 2023-12-29 | 53.99 | 4 | SO57608 | 2024-01-05 | 4.32 | 41.57 | |
SO45670_1 | 100 | 11541 | 310 | 1 | 2022-05-17 | 89.46 | 2022-05-05 | 3578.27 | 1 | SO45670 | 2022-05-12 | 286.26 | 2171.29 | |
SO45686_1 | 100 | 25998 | 346 | 1 | 2022-05-19 | 85.00 | 2022-05-07 | 3399.99 | 1 | SO45686 | 2022-05-14 | 272.00 | 1912.15 | |
SO45687_1 | 100 | 26005 | 344 | 1 | 2022-05-19 | 85.00 | 2022-05-07 | 3399.99 | 1 | SO45687 | 2022-05-14 | 272.00 | 1912.15 | |
SO45700_1 | 100 | 11278 | 310 | 1 | 2022-05-21 | 89.46 | 2022-05-09 | 3578.27 | 1 | SO45700 | 2022-05-16 | 286.26 | 2171.29 | |
SO45717_1 | 100 | 11325 | 310 | 1 | 2022-05-24 | 89.46 | 2022-05-12 | 3578.27 | 1 | SO45717 | 2022-05-19 | 286.26 | 2171.29 | |
SO45734_1 | 100 | 11630 | 314 | 1 | 2022-05-26 | 89.46 | 2022-05-14 | 3578.27 | 1 | SO45734 | 2022-05-21 | 286.26 | 2171.29 | |
SO45750_1 | 100 | 26001 | 345 | 1 | 2022-05-28 | 85.00 | 2022-05-16 | 3399.99 | 1 | SO45750 | 2022-05-23 | 272.00 | 1912.15 | |
SO45754_1 | 100 | 11529 | 311 | 1 | 2022-05-29 | 89.46 | 2022-05-17 | 3578.27 | 1 | SO45754 | 2022-05-24 | 286.26 | 2171.29 | |
SO45778_1 | 100 | 26002 | 351 | 1 | 2022-06-02 | 84.37 | 2022-05-21 | 3374.99 | 1 | SO45778 | 2022-05-28 | 270.00 | 1898.09 | |
SO45821_1 | 100 | 26041 | 346 | 1 | 2022-06-04 | 85.00 | 2022-05-23 | 3399.99 | 1 | SO45821 | 2022-05-30 | 272.00 | 1912.15 | |
SO45824_1 | 100 | 11696 | 312 | 1 | 2022-06-05 | 89.46 | 2022-05-24 | 3578.27 | 1 | SO45824 | 2022-05-31 | 286.26 | 2171.29 | |
SO45828_1 | 100 | 14753 | 330 | 1 | 2022-06-05 | 17.48 | 2022-05-24 | 699.10 | 1 | SO45828 | 2022-05-31 | 55.93 | 413.15 | |
SO45833_1 | 100 | 11815 | 313 | 1 | 2022-06-06 | 89.46 | 2022-05-25 | 3578.27 | 1 | SO45833 | 2022-06-01 | 286.26 | 2171.29 | |
SO45835_1 | 100 | 11688 | 313 | 1 | 2022-06-06 | 89.46 | 2022-05-25 | 3578.27 | 1 | SO45835 | 2022-06-01 | 286.26 | 2171.29 | |
SO45837_1 | 100 | 26050 | 348 | 1 | 2022-06-06 | 84.37 | 2022-05-25 | 3374.99 | 1 | SO45837 | 2022-06-01 | 270.00 | 1898.09 | |
SO45844_1 | 100 | 11812 | 312 | 1 | 2022-06-07 | 89.46 | 2022-05-26 | 3578.27 | 1 | SO45844 | 2022-06-02 | 286.26 | 2171.29 | |
SO45855_1 | 100 | 14754 | 338 | 1 | 2022-06-09 | 17.48 | 2022-05-28 | 699.10 | 1 | SO45855 | 2022-06-04 | 55.93 | 413.15 | |
SO45867_1 | 100 | 11772 | 312 | 1 | 2022-06-12 | 89.46 | 2022-05-31 | 3578.27 | 1 | SO45867 | 2022-06-07 | 286.26 | 2171.29 | |
SO45873_1 | 100 | 11925 | 314 | 1 | 2022-06-13 | 89.46 | 2022-06-01 | 3578.27 | 1 | SO45873 | 2022-06-08 | 286.26 | 2171.29 |
Generated 2024-09-20 03:42:30.059 UTC