[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 1000 < SKIP 2809 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO65002_1 | 100 | 15396 | 363 | 1 | 2024-04-30 | 57.37 | 2024-04-18 | 2294.99 | 1 | SO65002 | 2024-04-25 | 183.60 | 1251.98 | |
SO65002_2 | 100 | 15396 | 478 | 1 | 2024-04-30 | 0.25 | 2024-04-18 | 9.99 | 2 | SO65002 | 2024-04-25 | 0.80 | 3.74 | |
SO65002_3 | 100 | 15396 | 477 | 1 | 2024-04-30 | 0.12 | 2024-04-18 | 4.99 | 3 | SO65002 | 2024-04-25 | 0.40 | 1.87 | |
SO65002_4 | 100 | 15396 | 487 | 1 | 2024-04-30 | 1.37 | 2024-04-18 | 54.99 | 4 | SO65002 | 2024-04-25 | 4.40 | 20.57 | |
SO65012_1 | 100 | 26116 | 562 | 1 | 2024-04-30 | 59.60 | 2024-04-18 | 2384.07 | 1 | SO65012 | 2024-04-25 | 190.73 | 1481.94 | |
SO65012_2 | 100 | 26116 | 217 | 1 | 2024-04-30 | 0.87 | 2024-04-18 | 34.99 | 2 | SO65012 | 2024-04-25 | 2.80 | 13.09 | |
SO65013_1 | 100 | 26293 | 564 | 1 | 2024-04-30 | 59.60 | 2024-04-18 | 2384.07 | 1 | SO65013 | 2024-04-25 | 190.73 | 1481.94 | |
SO65013_2 | 100 | 26293 | 479 | 1 | 2024-04-30 | 0.22 | 2024-04-18 | 8.99 | 2 | SO65013 | 2024-04-25 | 0.72 | 3.36 | |
SO65013_3 | 100 | 26293 | 477 | 1 | 2024-04-30 | 0.12 | 2024-04-18 | 4.99 | 3 | SO65013 | 2024-04-25 | 0.40 | 1.87 | |
SO65013_4 | 100 | 26293 | 484 | 1 | 2024-04-30 | 0.20 | 2024-04-18 | 7.95 | 4 | SO65013 | 2024-04-25 | 0.64 | 2.97 | |
SO65016_1 | 100 | 22994 | 584 | 1 | 2024-04-30 | 13.50 | 2024-04-18 | 539.99 | 1 | SO65016 | 2024-04-25 | 43.20 | 343.65 | |
SO65037_1 | 100 | 28227 | 538 | 1 | 2024-05-01 | 0.54 | 2024-04-19 | 21.49 | 1 | SO65037 | 2024-04-26 | 1.72 | 8.04 | |
SO65037_2 | 100 | 28227 | 529 | 1 | 2024-05-01 | 0.10 | 2024-04-19 | 3.99 | 2 | SO65037 | 2024-04-26 | 0.32 | 1.49 | |
SO65037_3 | 100 | 28227 | 214 | 1 | 2024-05-01 | 0.87 | 2024-04-19 | 34.99 | 3 | SO65037 | 2024-04-26 | 2.80 | 13.09 | |
SO65039_1 | 100 | 25914 | 535 | 1 | 2024-05-01 | 0.62 | 2024-04-19 | 24.99 | 1 | SO65039 | 2024-04-26 | 2.00 | 9.35 | |
SO65039_2 | 100 | 25914 | 528 | 1 | 2024-05-01 | 0.12 | 2024-04-19 | 4.99 | 2 | SO65039 | 2024-04-26 | 0.40 | 1.87 | |
SO65039_3 | 100 | 25914 | 484 | 1 | 2024-05-01 | 0.20 | 2024-04-19 | 7.95 | 3 | SO65039 | 2024-04-26 | 0.64 | 2.97 | |
SO65044_1 | 100 | 15386 | 528 | 1 | 2024-05-01 | 0.12 | 2024-04-19 | 4.99 | 1 | SO65044 | 2024-04-26 | 0.40 | 1.87 | |
SO65046_1 | 100 | 13881 | 485 | 1 | 2024-05-01 | 0.55 | 2024-04-19 | 21.98 | 1 | SO65046 | 2024-04-26 | 1.76 | 8.22 | |
SO65046_2 | 100 | 13881 | 237 | 2 | 1 | 2024-05-01 | 1.25 | 2024-04-19 | 49.99 | 2 | SO65046 | 2024-04-26 | 4.00 | 38.49 |
SO65061_1 | 100 | 18943 | 587 | 1 | 2024-05-01 | 19.24 | 2024-04-19 | 769.49 | 1 | SO65061 | 2024-04-26 | 61.56 | 419.78 | |
SO65061_2 | 100 | 18943 | 476 | 1 | 2024-05-01 | 1.75 | 2024-04-19 | 69.99 | 2 | SO65061 | 2024-04-26 | 5.60 | 26.18 | |
SO65061_3 | 100 | 18943 | 473 | 1 | 2024-05-01 | 1.59 | 2024-04-19 | 63.50 | 3 | SO65061 | 2024-04-26 | 5.08 | 23.75 | |
SO65063_1 | 100 | 15499 | 353 | 2 | 1 | 2024-05-01 | 58.00 | 2024-04-19 | 2319.99 | 1 | SO65063 | 2024-04-26 | 185.60 | 1265.62 |
SO65063_2 | 100 | 15499 | 483 | 1 | 2024-05-01 | 3.00 | 2024-04-19 | 120.00 | 2 | SO65063 | 2024-04-26 | 9.60 | 44.88 | |
SO65078_1 | 100 | 20693 | 388 | 1 | 2024-05-01 | 28.01 | 2024-04-19 | 1120.49 | 1 | SO65078 | 2024-04-26 | 89.64 | 713.08 | |
SO65078_2 | 100 | 20693 | 222 | 1 | 2024-05-01 | 0.87 | 2024-04-19 | 34.99 | 2 | SO65078 | 2024-04-26 | 2.80 | 13.09 | |
SO65099_1 | 100 | 11838 | 217 | 1 | 2024-05-02 | 0.87 | 2024-04-20 | 34.99 | 1 | SO65099 | 2024-04-27 | 2.80 | 13.09 | |
SO65099_2 | 100 | 11838 | 234 | 1 | 2024-05-02 | 1.25 | 2024-04-20 | 49.99 | 2 | SO65099 | 2024-04-27 | 4.00 | 38.49 | |
SO65108_1 | 100 | 24511 | 540 | 1 | 2024-05-02 | 0.82 | 2024-04-20 | 32.60 | 1 | SO65108 | 2024-04-27 | 2.61 | 12.19 | |
SO65108_2 | 100 | 24511 | 529 | 1 | 2024-05-02 | 0.10 | 2024-04-20 | 3.99 | 2 | SO65108 | 2024-04-27 | 0.32 | 1.49 | |
SO51584_2 | 100 | 22274 | 217 | 1 | 2023-09-26 | 0.87 | 2023-09-14 | 34.99 | 2 | SO51584 | 2023-09-21 | 2.80 | 13.09 | |
SO51596_1 | 100 | 25087 | 560 | 1 | 2023-09-27 | 30.37 | 2023-09-15 | 1214.85 | 1 | SO51596 | 2023-09-22 | 97.19 | 755.15 | |
SO51596_2 | 100 | 25087 | 217 | 1 | 2023-09-27 | 0.87 | 2023-09-15 | 34.99 | 2 | SO51596 | 2023-09-22 | 2.80 | 13.09 | |
SO51608_1 | 100 | 13744 | 587 | 1 | 2023-09-28 | 19.24 | 2023-09-16 | 769.49 | 1 | SO51608 | 2023-09-23 | 61.56 | 419.78 | |
SO51608_2 | 100 | 13744 | 484 | 1 | 2023-09-28 | 0.20 | 2023-09-16 | 7.95 | 2 | SO51608 | 2023-09-23 | 0.64 | 2.97 | |
SO51610_1 | 100 | 11021 | 363 | 1 | 2023-09-28 | 57.37 | 2023-09-16 | 2294.99 | 1 | SO51610 | 2023-09-23 | 183.60 | 1251.98 | |
SO51610_2 | 100 | 11021 | 485 | 1 | 2023-09-28 | 0.55 | 2023-09-16 | 21.98 | 2 | SO51610 | 2023-09-23 | 1.76 | 8.22 | |
SO51610_3 | 100 | 11021 | 487 | 1 | 2023-09-28 | 1.37 | 2023-09-16 | 54.99 | 3 | SO51610 | 2023-09-23 | 4.40 | 20.57 | |
SO51614_1 | 100 | 26308 | 586 | 13 | 1 | 2023-09-28 | 18.56 | 2023-09-16 | 742.35 | 1 | SO51614 | 2023-09-23 | 59.39 | 461.44 |
SO51614_2 | 100 | 26308 | 490 | 1 | 2023-09-28 | 1.35 | 2023-09-16 | 53.99 | 2 | SO51614 | 2023-09-23 | 4.32 | 41.57 | |
SO51615_1 | 100 | 24420 | 563 | 14 | 1 | 2023-09-28 | 59.60 | 2023-09-16 | 2384.07 | 1 | SO51615 | 2023-09-23 | 190.73 | 1481.94 |
SO51615_2 | 100 | 24420 | 482 | 1 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 2 | SO51615 | 2023-09-23 | 0.72 | 3.36 | |
SO51616_1 | 100 | 21466 | 606 | 1 | 2023-09-28 | 13.50 | 2023-09-16 | 539.99 | 1 | SO51616 | 2023-09-23 | 43.20 | 343.65 | |
SO51616_2 | 100 | 21466 | 479 | 1 | 2023-09-28 | 0.22 | 2023-09-16 | 8.99 | 2 | SO51616 | 2023-09-23 | 0.72 | 3.36 | |
SO51616_3 | 100 | 21466 | 477 | 1 | 2023-09-28 | 0.12 | 2023-09-16 | 4.99 | 3 | SO51616 | 2023-09-23 | 0.40 | 1.87 | |
SO51616_4 | 100 | 21466 | 480 | 1 | 2023-09-28 | 0.06 | 2023-09-16 | 2.29 | 4 | SO51616 | 2023-09-23 | 0.18 | 0.86 | |
SO51625_1 | 100 | 18957 | 593 | 1 | 2023-09-29 | 14.12 | 2023-09-17 | 564.99 | 1 | SO51625 | 2023-09-24 | 45.20 | 308.22 | |
SO51625_2 | 100 | 18957 | 485 | 1 | 2023-09-29 | 0.55 | 2023-09-17 | 21.98 | 2 | SO51625 | 2023-09-24 | 1.76 | 8.22 | |
SO51625_3 | 100 | 18957 | 480 | 1 | 2023-09-29 | 0.06 | 2023-09-17 | 2.29 | 3 | SO51625 | 2023-09-24 | 0.18 | 0.86 | |
SO51645_1 | 100 | 15552 | 594 | 1 | 2023-09-30 | 14.12 | 2023-09-18 | 564.99 | 1 | SO51645 | 2023-09-25 | 45.20 | 308.22 | |
SO51645_2 | 100 | 15552 | 478 | 1 | 2023-09-30 | 0.25 | 2023-09-18 | 9.99 | 2 | SO51645 | 2023-09-25 | 0.80 | 3.74 | |
SO51645_3 | 100 | 15552 | 477 | 1 | 2023-09-30 | 0.12 | 2023-09-18 | 4.99 | 3 | SO51645 | 2023-09-25 | 0.40 | 1.87 | |
SO51645_4 | 100 | 15552 | 472 | 1 | 2023-09-30 | 1.59 | 2023-09-18 | 63.50 | 4 | SO51645 | 2023-09-25 | 5.08 | 23.75 | |
SO51647_1 | 100 | 11144 | 363 | 2 | 1 | 2023-09-30 | 57.37 | 2023-09-18 | 2294.99 | 1 | SO51647 | 2023-09-25 | 183.60 | 1251.98 |
SO51647_2 | 100 | 11144 | 487 | 1 | 2023-09-30 | 1.37 | 2023-09-18 | 54.99 | 2 | SO51647 | 2023-09-25 | 4.40 | 20.57 | |
SO51647_3 | 100 | 11144 | 237 | 2 | 1 | 2023-09-30 | 1.25 | 2023-09-18 | 49.99 | 3 | SO51647 | 2023-09-25 | 4.00 | 38.49 |
SO51648_1 | 100 | 11145 | 363 | 1 | 2023-09-30 | 57.37 | 2023-09-18 | 2294.99 | 1 | SO51648 | 2023-09-25 | 183.60 | 1251.98 | |
SO51648_2 | 100 | 11145 | 478 | 1 | 2023-09-30 | 0.25 | 2023-09-18 | 9.99 | 2 | SO51648 | 2023-09-25 | 0.80 | 3.74 | |
SO51648_3 | 100 | 11145 | 477 | 1 | 2023-09-30 | 0.12 | 2023-09-18 | 4.99 | 3 | SO51648 | 2023-09-25 | 0.40 | 1.87 |
Generated 2024-09-20 12:27:48.475 UTC