[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '6' > SKIP 4000 < SKIP 1281 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO67950_1 | 19 | 26692 | 605 | 6 | 2024-06-11 | 13.50 | 2024-05-30 | 539.99 | 1 | SO67950 | 2024-06-06 | 43.20 | 343.65 | |
SO67950_2 | 19 | 26692 | 538 | 6 | 2024-06-11 | 0.54 | 2024-05-30 | 21.49 | 2 | SO67950 | 2024-06-06 | 1.72 | 8.04 | |
SO67950_3 | 19 | 26692 | 529 | 6 | 2024-06-11 | 0.10 | 2024-05-30 | 3.99 | 3 | SO67950 | 2024-06-06 | 0.32 | 1.49 | |
SO67950_4 | 19 | 26692 | 480 | 6 | 2024-06-11 | 0.06 | 2024-05-30 | 2.29 | 4 | SO67950 | 2024-06-06 | 0.18 | 0.86 | |
SO67979_1 | 19 | 15826 | 529 | 6 | 2024-06-12 | 0.10 | 2024-05-31 | 3.99 | 1 | SO67979 | 2024-06-07 | 0.32 | 1.49 | |
SO67979_2 | 19 | 15826 | 480 | 6 | 2024-06-12 | 0.06 | 2024-05-31 | 2.29 | 2 | SO67979 | 2024-06-07 | 0.18 | 0.86 | |
SO67986_1 | 19 | 15864 | 540 | 6 | 2024-06-12 | 0.82 | 2024-05-31 | 32.60 | 1 | SO67986 | 2024-06-07 | 2.61 | 12.19 | |
SO67986_2 | 19 | 15864 | 529 | 6 | 2024-06-12 | 0.10 | 2024-05-31 | 3.99 | 2 | SO67986 | 2024-06-07 | 0.32 | 1.49 | |
SO67986_3 | 19 | 15864 | 222 | 6 | 2024-06-12 | 0.87 | 2024-05-31 | 34.99 | 3 | SO67986 | 2024-06-07 | 2.80 | 13.09 | |
SO67989_1 | 19 | 12532 | 476 | 6 | 2024-06-12 | 1.75 | 2024-05-31 | 69.99 | 1 | SO67989 | 2024-06-07 | 5.60 | 26.18 | |
SO67989_2 | 19 | 12532 | 463 | 6 | 2024-06-12 | 0.61 | 2024-05-31 | 24.49 | 2 | SO67989 | 2024-06-07 | 1.96 | 9.16 | |
SO67990_1 | 19 | 27282 | 474 | 6 | 2024-06-12 | 1.75 | 2024-05-31 | 69.99 | 1 | SO67990 | 2024-06-07 | 5.60 | 26.18 | |
SO68002_1 | 19 | 14611 | 537 | 6 | 2024-06-12 | 0.88 | 2024-05-31 | 35.00 | 1 | SO68002 | 2024-06-07 | 2.80 | 13.09 | |
SO68002_2 | 19 | 14611 | 528 | 6 | 2024-06-12 | 0.12 | 2024-05-31 | 4.99 | 2 | SO68002 | 2024-06-07 | 0.40 | 1.87 | |
SO68021_1 | 19 | 27014 | 606 | 6 | 2024-06-12 | 13.50 | 2024-05-31 | 539.99 | 1 | SO68021 | 2024-06-07 | 43.20 | 343.65 | |
SO68021_2 | 19 | 27014 | 217 | 6 | 2024-06-12 | 0.87 | 2024-05-31 | 34.99 | 2 | SO68021 | 2024-06-07 | 2.80 | 13.09 | |
SO68022_1 | 19 | 17125 | 605 | 6 | 2024-06-12 | 13.50 | 2024-05-31 | 539.99 | 1 | SO68022 | 2024-06-07 | 43.20 | 343.65 | |
SO68039_1 | 19 | 11142 | 535 | 6 | 2024-06-13 | 0.62 | 2024-06-01 | 24.99 | 1 | SO68039 | 2024-06-08 | 2.00 | 9.35 | |
SO68039_2 | 19 | 11142 | 528 | 6 | 2024-06-13 | 0.12 | 2024-06-01 | 4.99 | 2 | SO68039 | 2024-06-08 | 0.40 | 1.87 | |
SO68039_3 | 19 | 11142 | 222 | 6 | 2024-06-13 | 0.87 | 2024-06-01 | 34.99 | 3 | SO68039 | 2024-06-08 | 2.80 | 13.09 | |
SO68045_1 | 19 | 24744 | 477 | 6 | 2024-06-13 | 0.12 | 2024-06-01 | 4.99 | 1 | SO68045 | 2024-06-08 | 0.40 | 1.87 | |
SO68049_1 | 19 | 22079 | 485 | 6 | 2024-06-13 | 0.55 | 2024-06-01 | 21.98 | 1 | SO68049 | 2024-06-08 | 1.76 | 8.22 | |
SO68049_2 | 19 | 22079 | 480 | 6 | 2024-06-13 | 0.06 | 2024-06-01 | 2.29 | 2 | SO68049 | 2024-06-08 | 0.18 | 0.86 | |
SO68080_1 | 19 | 23592 | 583 | 6 | 2024-06-13 | 42.52 | 2024-06-01 | 1700.99 | 1 | SO68080 | 2024-06-08 | 136.08 | 1082.51 | |
SO68091_1 | 19 | 11223 | 214 | 6 | 2024-06-14 | 0.87 | 2024-06-02 | 34.99 | 1 | SO68091 | 2024-06-09 | 2.80 | 13.09 | |
SO68104_1 | 19 | 11502 | 530 | 6 | 2024-06-14 | 0.12 | 2024-06-02 | 4.99 | 1 | SO68104 | 2024-06-09 | 0.40 | 1.87 | |
SO68104_2 | 19 | 11502 | 480 | 2 | 6 | 2024-06-14 | 0.06 | 2024-06-02 | 2.29 | 2 | SO68104 | 2024-06-09 | 0.18 | 0.86 |
SO68107_1 | 19 | 11845 | 535 | 6 | 2024-06-14 | 0.62 | 2024-06-02 | 24.99 | 1 | SO68107 | 2024-06-09 | 2.00 | 9.35 | |
SO68107_2 | 19 | 11845 | 528 | 6 | 2024-06-14 | 0.12 | 2024-06-02 | 4.99 | 2 | SO68107 | 2024-06-09 | 0.40 | 1.87 | |
SO68107_3 | 19 | 11845 | 222 | 6 | 2024-06-14 | 0.87 | 2024-06-02 | 34.99 | 3 | SO68107 | 2024-06-09 | 2.80 | 13.09 | |
SO68109_1 | 19 | 15468 | 529 | 6 | 2024-06-14 | 0.10 | 2024-06-02 | 3.99 | 1 | SO68109 | 2024-06-09 | 0.32 | 1.49 | |
SO68109_2 | 19 | 15468 | 540 | 6 | 2024-06-14 | 0.82 | 2024-06-02 | 32.60 | 2 | SO68109 | 2024-06-09 | 2.61 | 12.19 | |
SO68109_3 | 19 | 15468 | 480 | 6 | 2024-06-14 | 0.06 | 2024-06-02 | 2.29 | 3 | SO68109 | 2024-06-09 | 0.18 | 0.86 | |
SO68109_4 | 19 | 15468 | 486 | 6 | 2024-06-14 | 3.98 | 2024-06-02 | 159.00 | 4 | SO68109 | 2024-06-09 | 12.72 | 59.47 | |
SO68109_5 | 19 | 15468 | 471 | 6 | 2024-06-14 | 1.59 | 2024-06-02 | 63.50 | 5 | SO68109 | 2024-06-09 | 5.08 | 23.75 | |
SO68111_1 | 19 | 12936 | 536 | 6 | 2024-06-14 | 0.75 | 2024-06-02 | 29.99 | 1 | SO68111 | 2024-06-09 | 2.40 | 11.22 | |
SO68111_2 | 19 | 12936 | 480 | 2 | 6 | 2024-06-14 | 0.06 | 2024-06-02 | 2.29 | 2 | SO68111 | 2024-06-09 | 0.18 | 0.86 |
SO68113_1 | 19 | 18054 | 536 | 6 | 2024-06-14 | 0.75 | 2024-06-02 | 29.99 | 1 | SO68113 | 2024-06-09 | 2.40 | 11.22 | |
SO68113_2 | 19 | 18054 | 528 | 6 | 2024-06-14 | 0.12 | 2024-06-02 | 4.99 | 2 | SO68113 | 2024-06-09 | 0.40 | 1.87 | |
SO68113_3 | 19 | 18054 | 217 | 6 | 2024-06-14 | 0.87 | 2024-06-02 | 34.99 | 3 | SO68113 | 2024-06-09 | 2.80 | 13.09 | |
SO68114_1 | 19 | 11530 | 476 | 6 | 2024-06-14 | 1.75 | 2024-06-02 | 69.99 | 1 | SO68114 | 2024-06-09 | 5.60 | 26.18 | |
SO68117_1 | 19 | 11330 | 477 | 6 | 2024-06-14 | 0.12 | 2024-06-02 | 4.99 | 1 | SO68117 | 2024-06-09 | 0.40 | 1.87 | |
SO68129_1 | 19 | 18389 | 355 | 6 | 2024-06-14 | 58.00 | 2024-06-02 | 2319.99 | 1 | SO68129 | 2024-06-09 | 185.60 | 1265.62 | |
SO68129_2 | 19 | 18389 | 485 | 6 | 2024-06-14 | 0.55 | 2024-06-02 | 21.98 | 2 | SO68129 | 2024-06-09 | 1.76 | 8.22 | |
SO68129_3 | 19 | 18389 | 222 | 6 | 2024-06-14 | 0.87 | 2024-06-02 | 34.99 | 3 | SO68129 | 2024-06-09 | 2.80 | 13.09 | |
SO68129_4 | 19 | 18389 | 463 | 6 | 2024-06-14 | 0.61 | 2024-06-02 | 24.49 | 4 | SO68129 | 2024-06-09 | 1.96 | 9.16 | |
SO68131_1 | 19 | 15283 | 587 | 6 | 2024-06-14 | 19.24 | 2024-06-02 | 769.49 | 1 | SO68131 | 2024-06-09 | 61.56 | 419.78 | |
SO68131_2 | 19 | 15283 | 485 | 6 | 2024-06-14 | 0.55 | 2024-06-02 | 21.98 | 2 | SO68131 | 2024-06-09 | 1.76 | 8.22 | |
SO68131_3 | 19 | 15283 | 237 | 6 | 2024-06-14 | 1.25 | 2024-06-02 | 49.99 | 3 | SO68131 | 2024-06-09 | 4.00 | 38.49 | |
SO68131_4 | 19 | 15283 | 467 | 6 | 2024-06-14 | 0.61 | 2024-06-02 | 24.49 | 4 | SO68131 | 2024-06-09 | 1.96 | 9.16 | |
SO55111_1 | 19 | 26449 | 477 | 6 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 1 | SO55111 | 2023-11-25 | 0.40 | 1.87 | |
SO55127_1 | 19 | 18078 | 485 | 6 | 2023-11-30 | 0.55 | 2023-11-18 | 21.98 | 1 | SO55127 | 2023-11-25 | 1.76 | 8.22 | |
SO55127_2 | 19 | 18078 | 237 | 2 | 6 | 2023-11-30 | 1.25 | 2023-11-18 | 49.99 | 2 | SO55127 | 2023-11-25 | 4.00 | 38.49 |
SO55129_1 | 19 | 15913 | 592 | 6 | 2023-11-30 | 14.12 | 2023-11-18 | 564.99 | 1 | SO55129 | 2023-11-25 | 45.20 | 308.22 | |
SO55129_2 | 19 | 15913 | 535 | 6 | 2023-11-30 | 0.62 | 2023-11-18 | 24.99 | 2 | SO55129 | 2023-11-25 | 2.00 | 9.35 | |
SO55129_3 | 19 | 15913 | 480 | 6 | 2023-11-30 | 0.06 | 2023-11-18 | 2.29 | 3 | SO55129 | 2023-11-25 | 0.18 | 0.86 | |
SO55129_4 | 19 | 15913 | 483 | 6 | 2023-11-30 | 3.00 | 2023-11-18 | 120.00 | 4 | SO55129 | 2023-11-25 | 9.60 | 44.88 | |
SO55151_1 | 19 | 11215 | 530 | 6 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 1 | SO55151 | 2023-11-26 | 0.40 | 1.87 | |
SO55151_2 | 19 | 11215 | 222 | 6 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 2 | SO55151 | 2023-11-26 | 2.80 | 13.09 | |
SO55153_1 | 19 | 20746 | 535 | 6 | 2023-12-01 | 0.62 | 2023-11-19 | 24.99 | 1 | SO55153 | 2023-11-26 | 2.00 | 9.35 | |
SO55153_2 | 19 | 20746 | 528 | 6 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 2 | SO55153 | 2023-11-26 | 0.40 | 1.87 | |
SO55153_3 | 19 | 20746 | 222 | 6 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 3 | SO55153 | 2023-11-26 | 2.80 | 13.09 |
Generated 2024-09-20 17:32:39.937 UTC