[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2410 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48120_1 | 100 | 15388 | 325 | 4 | 2023-01-08 | 19.57 | 2022-12-27 | 782.99 | 1 | SO48120 | 2023-01-03 | 62.64 | 486.71 | |
SO56657_1 | 100 | 24768 | 540 | 4 | 2023-12-27 | 0.82 | 2023-12-15 | 32.60 | 1 | SO56657 | 2023-12-22 | 2.61 | 12.19 | |
SO63492_1 | 100 | 20653 | 390 | 4 | 2024-04-06 | 28.01 | 2024-03-25 | 1120.49 | 1 | SO63492 | 2024-04-01 | 89.64 | 713.08 | |
SO69911_1 | 100 | 13387 | 361 | 4 | 2024-07-07 | 57.37 | 2024-06-25 | 2294.99 | 1 | SO69911 | 2024-07-02 | 183.60 | 1251.98 | |
SO48125_1 | 100 | 14239 | 389 | 4 | 2023-01-09 | 25.01 | 2022-12-28 | 1000.44 | 1 | SO48125 | 2023-01-04 | 80.04 | 605.65 | |
SO56659_1 | 100 | 18354 | 477 | 4 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO56659 | 2023-12-22 | 0.40 | 1.87 | |
SO63492_2 | 100 | 20653 | 217 | 4 | 2024-04-06 | 0.87 | 2024-03-25 | 34.99 | 2 | SO63492 | 2024-04-01 | 2.80 | 13.09 | |
SO69911_2 | 100 | 13387 | 537 | 4 | 2024-07-07 | 0.88 | 2024-06-25 | 35.00 | 2 | SO69911 | 2024-07-02 | 2.80 | 13.09 | |
SO48128_1 | 100 | 26534 | 352 | 4 | 2023-01-09 | 51.79 | 2022-12-28 | 2071.42 | 1 | SO48128 | 2023-01-04 | 165.71 | 1117.86 | |
SO56659_2 | 100 | 18354 | 484 | 4 | 2023-12-27 | 0.20 | 2023-12-15 | 7.95 | 2 | SO56659 | 2023-12-22 | 0.64 | 2.97 | |
SO63507_1 | 100 | 12095 | 225 | 4 | 2024-04-07 | 0.22 | 2024-03-26 | 8.99 | 1 | SO63507 | 2024-04-02 | 0.72 | 6.92 | |
SO69911_3 | 100 | 13387 | 528 | 4 | 2024-07-07 | 0.12 | 2024-06-25 | 4.99 | 3 | SO69911 | 2024-07-02 | 0.40 | 1.87 | |
SO48140_1 | 100 | 15374 | 331 | 4 | 2023-01-11 | 19.57 | 2022-12-30 | 782.99 | 1 | SO48140 | 2023-01-06 | 62.64 | 486.71 | |
SO56659_3 | 100 | 18354 | 483 | 4 | 2023-12-27 | 3.00 | 2023-12-15 | 120.00 | 3 | SO56659 | 2023-12-22 | 9.60 | 44.88 | |
SO63518_1 | 100 | 23740 | 540 | 4 | 2024-04-07 | 0.82 | 2024-03-26 | 32.60 | 1 | SO63518 | 2024-04-02 | 2.61 | 12.19 | |
SO69911_4 | 100 | 13387 | 480 | 4 | 2024-07-07 | 0.06 | 2024-06-25 | 2.29 | 4 | SO69911 | 2024-07-02 | 0.18 | 0.86 | |
SO48152_1 | 100 | 26536 | 352 | 4 | 2023-01-13 | 51.79 | 2023-01-01 | 2071.42 | 1 | SO48152 | 2023-01-08 | 165.71 | 1117.86 | |
SO56660_1 | 100 | 17335 | 528 | 4 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 1 | SO56660 | 2023-12-22 | 0.40 | 1.87 | |
SO63518_2 | 100 | 23740 | 529 | 4 | 2024-04-07 | 0.10 | 2024-03-26 | 3.99 | 2 | SO63518 | 2024-04-02 | 0.32 | 1.49 | |
SO69912_1 | 100 | 17546 | 359 | 4 | 2024-07-07 | 57.37 | 2024-06-25 | 2294.99 | 1 | SO69912 | 2024-07-02 | 183.60 | 1251.98 | |
SO48153_1 | 100 | 26575 | 362 | 2 | 4 | 2023-01-13 | 51.23 | 2023-01-01 | 2049.10 | 1 | SO48153 | 2023-01-08 | 163.93 | 1105.81 |
SO56663_1 | 100 | 14441 | 485 | 4 | 2023-12-27 | 0.55 | 2023-12-15 | 21.98 | 1 | SO56663 | 2023-12-22 | 1.76 | 8.22 | |
SO63519_1 | 100 | 21767 | 478 | 4 | 2024-04-07 | 0.25 | 2024-03-26 | 9.99 | 1 | SO63519 | 2024-04-02 | 0.80 | 3.74 | |
SO69912_2 | 100 | 17546 | 478 | 4 | 2024-07-07 | 0.25 | 2024-06-25 | 9.99 | 2 | SO69912 | 2024-07-02 | 0.80 | 3.74 | |
SO48166_1 | 100 | 13484 | 368 | 4 | 2023-01-15 | 61.08 | 2023-01-03 | 2443.35 | 1 | SO48166 | 2023-01-10 | 195.47 | 1518.79 | |
SO56663_2 | 100 | 14441 | 483 | 4 | 2023-12-27 | 3.00 | 2023-12-15 | 120.00 | 2 | SO56663 | 2023-12-22 | 9.60 | 44.88 | |
SO63519_2 | 100 | 21767 | 477 | 4 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 2 | SO63519 | 2024-04-02 | 0.40 | 1.87 | |
SO69912_3 | 100 | 17546 | 477 | 4 | 2024-07-07 | 0.12 | 2024-06-25 | 4.99 | 3 | SO69912 | 2024-07-02 | 0.40 | 1.87 | |
SO48167_1 | 100 | 26539 | 362 | 2 | 4 | 2023-01-15 | 51.23 | 2023-01-03 | 2049.10 | 1 | SO48167 | 2023-01-10 | 163.93 | 1105.81 |
SO56674_1 | 100 | 11649 | 537 | 4 | 2023-12-27 | 0.88 | 2023-12-15 | 35.00 | 1 | SO56674 | 2023-12-22 | 2.80 | 13.09 | |
SO63519_3 | 100 | 21767 | 222 | 4 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 3 | SO63519 | 2024-04-02 | 2.80 | 13.09 | |
SO69912_4 | 100 | 17546 | 225 | 4 | 2024-07-07 | 0.22 | 2024-06-25 | 8.99 | 4 | SO69912 | 2024-07-02 | 0.72 | 6.92 | |
SO48175_1 | 100 | 26545 | 354 | 4 | 2023-01-17 | 51.79 | 2023-01-05 | 2071.42 | 1 | SO48175 | 2023-01-12 | 165.71 | 1117.86 | |
SO56674_2 | 100 | 11649 | 480 | 4 | 2023-12-27 | 0.06 | 2023-12-15 | 2.29 | 2 | SO56674 | 2023-12-22 | 0.18 | 0.86 | |
SO63519_4 | 100 | 21767 | 228 | 4 | 2024-04-07 | 1.25 | 2024-03-26 | 49.99 | 4 | SO63519 | 2024-04-02 | 4.00 | 38.49 | |
SO69913_1 | 100 | 17038 | 357 | 4 | 2024-07-07 | 58.00 | 2024-06-25 | 2319.99 | 1 | SO69913 | 2024-07-02 | 185.60 | 1265.62 | |
SO48176_1 | 100 | 15379 | 337 | 4 | 2023-01-17 | 19.57 | 2023-01-05 | 782.99 | 1 | SO48176 | 2023-01-12 | 62.64 | 486.71 | |
SO56676_1 | 100 | 14075 | 485 | 4 | 2023-12-27 | 0.55 | 2023-12-15 | 21.98 | 1 | SO56676 | 2023-12-22 | 1.76 | 8.22 | |
SO63519_5 | 100 | 21767 | 467 | 4 | 2024-04-07 | 0.61 | 2024-03-26 | 24.49 | 5 | SO63519 | 2024-04-02 | 1.96 | 9.16 | |
SO69913_2 | 100 | 17038 | 480 | 4 | 2024-07-07 | 0.06 | 2024-06-25 | 2.29 | 2 | SO69913 | 2024-07-02 | 0.18 | 0.86 | |
SO48182_1 | 100 | 26600 | 360 | 4 | 2023-01-18 | 51.23 | 2023-01-06 | 2049.10 | 1 | SO48182 | 2023-01-13 | 163.93 | 1105.81 | |
SO56676_2 | 100 | 14075 | 222 | 4 | 2023-12-27 | 0.87 | 2023-12-15 | 34.99 | 2 | SO56676 | 2023-12-22 | 2.80 | 13.09 | |
SO63521_1 | 100 | 18417 | 477 | 4 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 1 | SO63521 | 2024-04-02 | 0.40 | 1.87 | |
SO69913_3 | 100 | 17038 | 483 | 4 | 2024-07-07 | 3.00 | 2024-06-25 | 120.00 | 3 | SO69913 | 2024-07-02 | 9.60 | 44.88 | |
SO48192_1 | 100 | 13702 | 377 | 4 | 2023-01-20 | 54.54 | 2023-01-08 | 2181.56 | 1 | SO48192 | 2023-01-15 | 174.53 | 1320.68 | |
SO56677_1 | 100 | 11805 | 537 | 4 | 2023-12-27 | 0.88 | 2023-12-15 | 35.00 | 1 | SO56677 | 2023-12-22 | 2.80 | 13.09 | |
SO63521_2 | 100 | 18417 | 217 | 4 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 2 | SO63521 | 2024-04-02 | 2.80 | 13.09 | |
SO69915_1 | 100 | 17398 | 357 | 4 | 2024-07-07 | 58.00 | 2024-06-25 | 2319.99 | 1 | SO69915 | 2024-07-02 | 185.60 | 1265.62 | |
SO48193_1 | 100 | 26499 | 352 | 4 | 2023-01-20 | 51.79 | 2023-01-08 | 2071.42 | 1 | SO48193 | 2023-01-15 | 165.71 | 1117.86 | |
SO56677_2 | 100 | 11805 | 528 | 4 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 2 | SO56677 | 2023-12-22 | 0.40 | 1.87 | |
SO63522_1 | 100 | 16905 | 477 | 4 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 1 | SO63522 | 2024-04-02 | 0.40 | 1.87 | |
SO69915_2 | 100 | 17398 | 217 | 4 | 2024-07-07 | 0.87 | 2024-06-25 | 34.99 | 2 | SO69915 | 2024-07-02 | 2.80 | 13.09 | |
SO48201_1 | 100 | 26601 | 356 | 4 | 2023-01-21 | 51.79 | 2023-01-09 | 2071.42 | 1 | SO48201 | 2023-01-16 | 165.71 | 1117.86 | |
SO56677_3 | 100 | 11805 | 214 | 4 | 2023-12-27 | 0.87 | 2023-12-15 | 34.99 | 3 | SO56677 | 2023-12-22 | 2.80 | 13.09 | |
SO63531_1 | 100 | 19814 | 591 | 4 | 2024-04-07 | 14.12 | 2024-03-26 | 564.99 | 1 | SO63531 | 2024-04-02 | 45.20 | 308.22 | |
SO69928_1 | 100 | 26094 | 579 | 4 | 2024-07-07 | 30.37 | 2024-06-25 | 1214.85 | 1 | SO69928 | 2024-07-02 | 97.19 | 755.15 | |
SO48206_1 | 100 | 26538 | 352 | 4 | 2023-01-22 | 51.79 | 2023-01-10 | 2071.42 | 1 | SO48206 | 2023-01-17 | 165.71 | 1117.86 | |
SO56678_1 | 100 | 16364 | 374 | 4 | 2023-12-27 | 61.08 | 2023-12-15 | 2443.35 | 1 | SO56678 | 2023-12-22 | 195.47 | 1554.95 | |
SO63531_2 | 100 | 19814 | 535 | 4 | 2024-04-07 | 0.62 | 2024-03-26 | 24.99 | 2 | SO63531 | 2024-04-02 | 2.00 | 9.35 | |
SO69928_2 | 100 | 26094 | 541 | 4 | 2024-07-07 | 0.72 | 2024-06-25 | 28.99 | 2 | SO69928 | 2024-07-02 | 2.32 | 10.84 |
Generated 2024-09-20 08:24:09.577 UTC