[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2319 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51973_1 | 6 | 22846 | 537 | 9 | 2023-11-29 | 0.88 | 2023-11-17 | 35.00 | 1 | SO51973 | 2023-11-24 | 2.80 | 13.09 | |
SO51973_2 | 6 | 22846 | 528 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 2 | SO51973 | 2023-11-24 | 0.40 | 1.87 | |
SO51973_3 | 6 | 22846 | 217 | 9 | 2023-11-29 | 0.87 | 2023-11-17 | 34.99 | 3 | SO51973 | 2023-11-24 | 2.80 | 13.09 | |
SO51974_1 | 6 | 15136 | 222 | 9 | 2023-11-29 | 0.87 | 2023-11-17 | 34.99 | 1 | SO51974 | 2023-11-24 | 2.80 | 13.09 | |
SO51975_1 | 6 | 11763 | 463 | 9 | 2023-11-29 | 0.61 | 2023-11-17 | 24.49 | 1 | SO51975 | 2023-11-24 | 1.96 | 9.16 | |
SO51976_1 | 6 | 17074 | 225 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 1 | SO51976 | 2023-11-24 | 0.72 | 6.92 | |
SO51976_2 | 6 | 17074 | 228 | 9 | 2023-11-29 | 1.25 | 2023-11-17 | 49.99 | 2 | SO51976 | 2023-11-24 | 4.00 | 38.49 | |
SO51977_1 | 6 | 18191 | 225 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 1 | SO51977 | 2023-11-24 | 0.72 | 6.92 | |
SO51978_1 | 6 | 19969 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 1 | SO51978 | 2023-11-24 | 0.40 | 1.87 | |
SO51978_2 | 6 | 19969 | 479 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 2 | SO51978 | 2023-11-24 | 0.72 | 3.36 | |
SO51978_3 | 6 | 19969 | 491 | 9 | 2023-11-29 | 1.35 | 2023-11-17 | 53.99 | 3 | SO51978 | 2023-11-24 | 4.32 | 41.57 | |
SO52014_1 | 6 | 16664 | 588 | 9 | 2023-11-29 | 19.24 | 2023-11-17 | 769.49 | 1 | SO52014 | 2023-11-24 | 61.56 | 419.78 | |
SO52014_2 | 6 | 16664 | 536 | 9 | 2023-11-29 | 0.75 | 2023-11-17 | 29.99 | 2 | SO52014 | 2023-11-24 | 2.40 | 11.22 | |
SO52018_1 | 6 | 18470 | 376 | 9 | 2023-11-29 | 61.08 | 2023-11-17 | 2443.35 | 1 | SO52018 | 2023-11-24 | 195.47 | 1554.95 | |
SO52019_1 | 6 | 23411 | 382 | 9 | 2023-11-30 | 28.01 | 2023-11-18 | 1120.49 | 1 | SO52019 | 2023-11-25 | 89.64 | 713.08 | |
SO52019_2 | 6 | 23411 | 479 | 9 | 2023-11-30 | 0.22 | 2023-11-18 | 8.99 | 2 | SO52019 | 2023-11-25 | 0.72 | 3.36 | |
SO52019_3 | 6 | 23411 | 477 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 3 | SO52019 | 2023-11-25 | 0.40 | 1.87 | |
SO52024_1 | 6 | 19087 | 485 | 9 | 2023-11-30 | 0.55 | 2023-11-18 | 21.98 | 1 | SO52024 | 2023-11-25 | 1.76 | 8.22 | |
SO52024_2 | 6 | 19087 | 478 | 9 | 2023-11-30 | 0.25 | 2023-11-18 | 9.99 | 2 | SO52024 | 2023-11-25 | 0.80 | 3.74 | |
SO52024_3 | 6 | 19087 | 477 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 3 | SO52024 | 2023-11-25 | 0.40 | 1.87 | |
SO52025_1 | 6 | 18293 | 485 | 9 | 2023-11-30 | 0.55 | 2023-11-18 | 21.98 | 1 | SO52025 | 2023-11-25 | 1.76 | 8.22 | |
SO52025_2 | 6 | 18293 | 478 | 9 | 2023-11-30 | 0.25 | 2023-11-18 | 9.99 | 2 | SO52025 | 2023-11-25 | 0.80 | 3.74 | |
SO52025_3 | 6 | 18293 | 477 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 3 | SO52025 | 2023-11-25 | 0.40 | 1.87 | |
SO52025_4 | 6 | 18293 | 222 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 4 | SO52025 | 2023-11-25 | 2.80 | 13.09 | |
SO52026_1 | 6 | 29287 | 477 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 1 | SO52026 | 2023-11-25 | 0.40 | 1.87 | |
SO52027_1 | 6 | 27981 | 530 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 1 | SO52027 | 2023-11-25 | 0.40 | 1.87 | |
SO52027_2 | 6 | 27981 | 214 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 2 | SO52027 | 2023-11-25 | 2.80 | 13.09 | |
SO52028_1 | 6 | 26132 | 528 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 1 | SO52028 | 2023-11-25 | 0.40 | 1.87 | |
SO52028_2 | 6 | 26132 | 214 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 2 | SO52028 | 2023-11-25 | 2.80 | 13.09 | |
SO52029_1 | 6 | 24494 | 478 | 9 | 2023-11-30 | 0.25 | 2023-11-18 | 9.99 | 1 | SO52029 | 2023-11-25 | 0.80 | 3.74 | |
SO52030_1 | 6 | 11125 | 484 | 9 | 2023-11-30 | 0.20 | 2023-11-18 | 7.95 | 1 | SO52030 | 2023-11-25 | 0.64 | 2.97 | |
SO52031_1 | 6 | 19088 | 480 | 9 | 2023-11-30 | 0.06 | 2023-11-18 | 2.29 | 1 | SO52031 | 2023-11-25 | 0.18 | 0.86 | |
SO52060_1 | 6 | 18699 | 582 | 9 | 2023-11-30 | 42.52 | 2023-11-18 | 1700.99 | 1 | SO52060 | 2023-11-25 | 136.08 | 1082.51 | |
SO52060_2 | 6 | 18699 | 539 | 9 | 2023-11-30 | 0.62 | 2023-11-18 | 24.99 | 2 | SO52060 | 2023-11-25 | 2.00 | 9.35 | |
SO52060_3 | 6 | 18699 | 529 | 9 | 2023-11-30 | 0.10 | 2023-11-18 | 3.99 | 3 | SO52060 | 2023-11-25 | 0.32 | 1.49 | |
SO52061_1 | 6 | 20158 | 584 | 9 | 2023-11-30 | 13.50 | 2023-11-18 | 539.99 | 1 | SO52061 | 2023-11-25 | 43.20 | 343.65 | |
SO52061_2 | 6 | 20158 | 222 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 2 | SO52061 | 2023-11-25 | 2.80 | 13.09 | |
SO52065_1 | 6 | 23311 | 382 | 9 | 2023-12-01 | 28.01 | 2023-11-19 | 1120.49 | 1 | SO52065 | 2023-11-26 | 89.64 | 713.08 | |
SO52065_2 | 6 | 23311 | 217 | 9 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 2 | SO52065 | 2023-11-26 | 2.80 | 13.09 | |
SO52068_1 | 6 | 13635 | 535 | 9 | 2023-12-01 | 0.62 | 2023-11-19 | 24.99 | 1 | SO52068 | 2023-11-26 | 2.00 | 9.35 | |
SO52068_2 | 6 | 13635 | 528 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 2 | SO52068 | 2023-11-26 | 0.40 | 1.87 | |
SO52068_3 | 6 | 13635 | 480 | 2 | 9 | 2023-12-01 | 0.06 | 2023-11-19 | 2.29 | 3 | SO52068 | 2023-11-26 | 0.18 | 0.86 |
SO52069_1 | 6 | 20453 | 538 | 9 | 2023-12-01 | 0.54 | 2023-11-19 | 21.49 | 1 | SO52069 | 2023-11-26 | 1.72 | 8.04 | |
SO52070_1 | 6 | 20237 | 538 | 9 | 2023-12-01 | 0.54 | 2023-11-19 | 21.49 | 1 | SO52070 | 2023-11-26 | 1.72 | 8.04 | |
SO52071_1 | 6 | 21366 | 528 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 1 | SO52071 | 2023-11-26 | 0.40 | 1.87 | |
SO52071_2 | 6 | 21366 | 217 | 9 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 2 | SO52071 | 2023-11-26 | 2.80 | 13.09 | |
SO52072_1 | 6 | 11113 | 478 | 9 | 2023-12-01 | 0.25 | 2023-11-19 | 9.99 | 1 | SO52072 | 2023-11-26 | 0.80 | 3.74 | |
SO52072_2 | 6 | 11113 | 477 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 2 | SO52072 | 2023-11-26 | 0.40 | 1.87 | |
SO52072_3 | 6 | 11113 | 217 | 9 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 3 | SO52072 | 2023-11-26 | 2.80 | 13.09 | |
SO52073_1 | 6 | 12247 | 228 | 9 | 2023-12-01 | 1.25 | 2023-11-19 | 49.99 | 1 | SO52073 | 2023-11-26 | 4.00 | 38.49 | |
SO52107_1 | 6 | 18272 | 378 | 9 | 2023-12-02 | 61.08 | 2023-11-20 | 2443.35 | 1 | SO52107 | 2023-11-27 | 195.47 | 1554.95 | |
SO52107_2 | 6 | 18272 | 214 | 9 | 2023-12-02 | 0.87 | 2023-11-20 | 34.99 | 2 | SO52107 | 2023-11-27 | 2.80 | 13.09 | |
SO52114_1 | 6 | 15592 | 539 | 9 | 2023-12-02 | 0.62 | 2023-11-20 | 24.99 | 1 | SO52114 | 2023-11-27 | 2.00 | 9.35 | |
SO52115_1 | 6 | 21883 | 537 | 9 | 2023-12-02 | 0.88 | 2023-11-20 | 35.00 | 1 | SO52115 | 2023-11-27 | 2.80 | 13.09 | |
SO52115_2 | 6 | 21883 | 528 | 9 | 2023-12-02 | 0.12 | 2023-11-20 | 4.99 | 2 | SO52115 | 2023-11-27 | 0.40 | 1.87 | |
SO52115_3 | 6 | 21883 | 480 | 9 | 2023-12-02 | 0.06 | 2023-11-20 | 2.29 | 3 | SO52115 | 2023-11-27 | 0.18 | 0.86 | |
SO52116_1 | 6 | 27968 | 530 | 9 | 2023-12-02 | 0.12 | 2023-11-20 | 4.99 | 1 | SO52116 | 2023-11-27 | 0.40 | 1.87 | |
SO52116_2 | 6 | 27968 | 214 | 9 | 2023-12-02 | 0.87 | 2023-11-20 | 34.99 | 2 | SO52116 | 2023-11-27 | 2.80 | 13.09 | |
SO52117_1 | 6 | 22028 | 476 | 9 | 2023-12-02 | 1.75 | 2023-11-20 | 69.99 | 1 | SO52117 | 2023-11-27 | 5.60 | 26.18 | |
SO52118_1 | 6 | 25923 | 529 | 9 | 2023-12-02 | 0.10 | 2023-11-20 | 3.99 | 1 | SO52118 | 2023-11-27 | 0.32 | 1.49 |
Generated 2024-11-14 05:41:25.136 UTC