[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 187 < SKIP 2749 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO68103_1 | 100 | 11726 | 225 | 1 | 2024-06-14 | 0.22 | 2024-06-02 | 8.99 | 1 | SO68103 | 2024-06-09 | 0.72 | 6.92 |
SO68103_2 | 100 | 11726 | 491 | 1 | 2024-06-14 | 1.35 | 2024-06-02 | 53.99 | 2 | SO68103 | 2024-06-09 | 4.32 | 41.57 |
SO68110_1 | 100 | 24634 | 540 | 1 | 2024-06-14 | 0.82 | 2024-06-02 | 32.60 | 1 | SO68110 | 2024-06-09 | 2.61 | 12.19 |
SO68110_2 | 100 | 24634 | 529 | 1 | 2024-06-14 | 0.10 | 2024-06-02 | 3.99 | 2 | SO68110 | 2024-06-09 | 0.32 | 1.49 |
SO68110_3 | 100 | 24634 | 222 | 1 | 2024-06-14 | 0.87 | 2024-06-02 | 34.99 | 3 | SO68110 | 2024-06-09 | 2.80 | 13.09 |
SO68110_4 | 100 | 24634 | 228 | 1 | 2024-06-14 | 1.25 | 2024-06-02 | 49.99 | 4 | SO68110 | 2024-06-09 | 4.00 | 38.49 |
SO68110_5 | 100 | 24634 | 482 | 1 | 2024-06-14 | 0.22 | 2024-06-02 | 8.99 | 5 | SO68110 | 2024-06-09 | 0.72 | 3.36 |
SO68112_1 | 100 | 23497 | 536 | 1 | 2024-06-14 | 0.75 | 2024-06-02 | 29.99 | 1 | SO68112 | 2024-06-09 | 2.40 | 11.22 |
SO57442_4 | 100 | 24236 | 228 | 1 | 2024-01-07 | 1.25 | 2023-12-26 | 49.99 | 4 | SO57442 | 2024-01-02 | 4.00 | 38.49 |
SO68116_1 | 100 | 18861 | 475 | 1 | 2024-06-14 | 1.75 | 2024-06-02 | 69.99 | 1 | SO68116 | 2024-06-09 | 5.60 | 26.18 |
SO57443_1 | 100 | 25342 | 535 | 1 | 2024-01-07 | 0.62 | 2023-12-26 | 24.99 | 1 | SO57443 | 2024-01-02 | 2.00 | 9.35 |
SO68116_2 | 100 | 18861 | 471 | 1 | 2024-06-14 | 1.59 | 2024-06-02 | 63.50 | 2 | SO68116 | 2024-06-09 | 5.08 | 23.75 |
SO57444_1 | 100 | 23736 | 528 | 1 | 2024-01-07 | 0.12 | 2023-12-26 | 4.99 | 1 | SO57444 | 2024-01-02 | 0.40 | 1.87 |
SO68128_1 | 100 | 13244 | 485 | 1 | 2024-06-14 | 0.55 | 2024-06-02 | 21.98 | 1 | SO68128 | 2024-06-09 | 1.76 | 8.22 |
SO57444_2 | 100 | 23736 | 536 | 1 | 2024-01-07 | 0.75 | 2023-12-26 | 29.99 | 2 | SO57444 | 2024-01-02 | 2.40 | 11.22 |
SO68128_2 | 100 | 13244 | 222 | 1 | 2024-06-14 | 0.87 | 2024-06-02 | 34.99 | 2 | SO68128 | 2024-06-09 | 2.80 | 13.09 |
SO57444_3 | 100 | 23736 | 484 | 1 | 2024-01-07 | 0.20 | 2023-12-26 | 7.95 | 3 | SO57444 | 2024-01-02 | 0.64 | 2.97 |
SO68128_3 | 100 | 13244 | 467 | 1 | 2024-06-14 | 0.61 | 2024-06-02 | 24.49 | 3 | SO68128 | 2024-06-09 | 1.96 | 9.16 |
SO57448_1 | 100 | 16857 | 477 | 1 | 2024-01-07 | 0.12 | 2023-12-26 | 4.99 | 1 | SO57448 | 2024-01-02 | 0.40 | 1.87 |
SO68133_1 | 100 | 12915 | 359 | 1 | 2024-06-14 | 57.37 | 2024-06-02 | 2294.99 | 1 | SO68133 | 2024-06-09 | 183.60 | 1251.98 |
SO57448_2 | 100 | 16857 | 234 | 1 | 2024-01-07 | 1.25 | 2023-12-26 | 49.99 | 2 | SO57448 | 2024-01-02 | 4.00 | 38.49 |
SO68133_2 | 100 | 12915 | 478 | 1 | 2024-06-14 | 0.25 | 2024-06-02 | 9.99 | 2 | SO68133 | 2024-06-09 | 0.80 | 3.74 |
SO57449_1 | 100 | 15981 | 528 | 1 | 2024-01-07 | 0.12 | 2023-12-26 | 4.99 | 1 | SO57449 | 2024-01-02 | 0.40 | 1.87 |
SO68133_3 | 100 | 12915 | 477 | 1 | 2024-06-14 | 0.12 | 2024-06-02 | 4.99 | 3 | SO68133 | 2024-06-09 | 0.40 | 1.87 |
SO57449_2 | 100 | 15981 | 483 | 1 | 2024-01-07 | 3.00 | 2023-12-26 | 120.00 | 2 | SO57449 | 2024-01-02 | 9.60 | 44.88 |
SO68133_4 | 100 | 12915 | 484 | 1 | 2024-06-14 | 0.20 | 2024-06-02 | 7.95 | 4 | SO68133 | 2024-06-09 | 0.64 | 2.97 |
SO57462_1 | 100 | 13305 | 485 | 1 | 2024-01-07 | 0.55 | 2023-12-26 | 21.98 | 1 | SO57462 | 2024-01-02 | 1.76 | 8.22 |
SO68140_1 | 100 | 24798 | 576 | 1 | 2024-06-14 | 59.60 | 2024-06-02 | 2384.07 | 1 | SO68140 | 2024-06-09 | 190.73 | 1481.94 |
SO57462_2 | 100 | 13305 | 228 | 1 | 2024-01-07 | 1.25 | 2023-12-26 | 49.99 | 2 | SO57462 | 2024-01-02 | 4.00 | 38.49 |
SO68140_2 | 100 | 24798 | 477 | 1 | 2024-06-14 | 0.12 | 2024-06-02 | 4.99 | 2 | SO68140 | 2024-06-09 | 0.40 | 1.87 |
SO57466_1 | 100 | 13419 | 361 | 1 | 2024-01-07 | 57.37 | 2023-12-26 | 2294.99 | 1 | SO57466 | 2024-01-02 | 183.60 | 1251.98 |
SO68140_3 | 100 | 24798 | 479 | 1 | 2024-06-14 | 0.22 | 2024-06-02 | 8.99 | 3 | SO68140 | 2024-06-09 | 0.72 | 3.36 |
SO57469_1 | 100 | 11745 | 357 | 1 | 2024-01-07 | 58.00 | 2023-12-26 | 2319.99 | 1 | SO57469 | 2024-01-02 | 185.60 | 1265.62 |
SO68140_4 | 100 | 24798 | 482 | 1 | 2024-06-14 | 0.22 | 2024-06-02 | 8.99 | 4 | SO68140 | 2024-06-09 | 0.72 | 3.36 |
SO57469_2 | 100 | 11745 | 478 | 1 | 2024-01-07 | 0.25 | 2023-12-26 | 9.99 | 2 | SO57469 | 2024-01-02 | 0.80 | 3.74 |
SO68142_1 | 100 | 28664 | 560 | 1 | 2024-06-14 | 30.37 | 2024-06-02 | 1214.85 | 1 | SO68142 | 2024-06-09 | 97.19 | 755.15 |
SO57469_3 | 100 | 11745 | 477 | 1 | 2024-01-07 | 0.12 | 2023-12-26 | 4.99 | 3 | SO57469 | 2024-01-02 | 0.40 | 1.87 |
SO68145_1 | 100 | 18371 | 581 | 1 | 2024-06-14 | 42.52 | 2024-06-02 | 1700.99 | 1 | SO68145 | 2024-06-09 | 136.08 | 1082.51 |
SO57469_4 | 100 | 11745 | 222 | 1 | 2024-01-07 | 0.87 | 2023-12-26 | 34.99 | 4 | SO57469 | 2024-01-02 | 2.80 | 13.09 |
SO68145_2 | 100 | 18371 | 490 | 1 | 2024-06-14 | 1.35 | 2024-06-02 | 53.99 | 2 | SO68145 | 2024-06-09 | 4.32 | 41.57 |
SO57475_1 | 100 | 28869 | 565 | 1 | 2024-01-07 | 18.56 | 2023-12-26 | 742.35 | 1 | SO57475 | 2024-01-02 | 59.39 | 461.44 |
SO68152_1 | 100 | 28610 | 225 | 1 | 2024-06-15 | 0.22 | 2024-06-03 | 8.99 | 1 | SO68152 | 2024-06-10 | 0.72 | 6.92 |
SO57475_2 | 100 | 28869 | 222 | 1 | 2024-01-07 | 0.87 | 2023-12-26 | 34.99 | 2 | SO57475 | 2024-01-02 | 2.80 | 13.09 |
SO68164_1 | 100 | 29212 | 529 | 1 | 2024-06-15 | 0.10 | 2024-06-03 | 3.99 | 1 | SO68164 | 2024-06-10 | 0.32 | 1.49 |
SO57495_1 | 100 | 24725 | 529 | 1 | 2024-01-08 | 0.10 | 2023-12-27 | 3.99 | 1 | SO57495 | 2024-01-03 | 0.32 | 1.49 |
SO68164_2 | 100 | 29212 | 539 | 1 | 2024-06-15 | 0.62 | 2024-06-03 | 24.99 | 2 | SO68164 | 2024-06-10 | 2.00 | 9.35 |
SO57495_2 | 100 | 24725 | 540 | 1 | 2024-01-08 | 0.82 | 2023-12-27 | 32.60 | 2 | SO57495 | 2024-01-03 | 2.61 | 12.19 |
SO68164_3 | 100 | 29212 | 480 | 1 | 2024-06-15 | 0.06 | 2024-06-03 | 2.29 | 3 | SO68164 | 2024-06-10 | 0.18 | 0.86 |
SO57495_3 | 100 | 24725 | 480 | 1 | 2024-01-08 | 0.06 | 2023-12-27 | 2.29 | 3 | SO57495 | 2024-01-03 | 0.18 | 0.86 |
SO68164_4 | 100 | 29212 | 486 | 1 | 2024-06-15 | 3.98 | 2024-06-03 | 159.00 | 4 | SO68164 | 2024-06-10 | 12.72 | 59.47 |
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 |
SO68167_1 | 100 | 28361 | 530 | 1 | 2024-06-15 | 0.12 | 2024-06-03 | 4.99 | 1 | SO68167 | 2024-06-10 | 0.40 | 1.87 |
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 |
SO68167_2 | 100 | 28361 | 225 | 1 | 2024-06-15 | 0.22 | 2024-06-03 | 8.99 | 2 | SO68167 | 2024-06-10 | 0.72 | 6.92 |
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 |
SO68171_1 | 100 | 26087 | 535 | 1 | 2024-06-15 | 0.62 | 2024-06-03 | 24.99 | 1 | SO68171 | 2024-06-10 | 2.00 | 9.35 |
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 |
SO68171_2 | 100 | 26087 | 528 | 1 | 2024-06-15 | 0.12 | 2024-06-03 | 4.99 | 2 | SO68171 | 2024-06-10 | 0.40 | 1.87 |
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 |
SO68171_3 | 100 | 26087 | 214 | 1 | 2024-06-15 | 0.87 | 2024-06-03 | 34.99 | 3 | SO68171 | 2024-06-10 | 2.80 | 13.09 |
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 |
SO68173_1 | 100 | 21415 | 478 | 1 | 2024-06-15 | 0.25 | 2024-06-03 | 9.99 | 1 | SO68173 | 2024-06-10 | 0.80 | 3.74 |
Generated 2024-09-20 07:07:10.373 UTC