[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 1000 < SKIP 2421 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO60039_1 | 98 | 26876 | 606 | 10 | 2024-04-06 | 13.50 | 2024-03-25 | 539.99 | 1 | SO60039 | 2024-04-01 | 43.20 | 343.65 | |
SO60039_2 | 98 | 26876 | 477 | 10 | 2024-04-06 | 0.12 | 2024-03-25 | 4.99 | 2 | SO60039 | 2024-04-01 | 0.40 | 1.87 | |
SO60039_3 | 98 | 26876 | 479 | 10 | 2024-04-06 | 0.22 | 2024-03-25 | 8.99 | 3 | SO60039 | 2024-04-01 | 0.72 | 3.36 | |
SO60039_4 | 98 | 26876 | 214 | 10 | 2024-04-06 | 0.87 | 2024-03-25 | 34.99 | 4 | SO60039 | 2024-04-01 | 2.80 | 13.09 | |
SO60044_1 | 98 | 12612 | 359 | 10 | 2024-04-07 | 57.37 | 2024-03-26 | 2294.99 | 1 | SO60044 | 2024-04-02 | 183.60 | 1251.98 | |
SO60044_2 | 98 | 12612 | 478 | 10 | 2024-04-07 | 0.25 | 2024-03-26 | 9.99 | 2 | SO60044 | 2024-04-02 | 0.80 | 3.74 | |
SO60044_3 | 98 | 12612 | 217 | 10 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 3 | SO60044 | 2024-04-02 | 2.80 | 13.09 | |
SO60045_1 | 98 | 12856 | 357 | 2 | 10 | 2024-04-07 | 58.00 | 2024-03-26 | 2319.99 | 1 | SO60045 | 2024-04-02 | 185.60 | 1265.62 |
SO60045_2 | 98 | 12856 | 478 | 10 | 2024-04-07 | 0.25 | 2024-03-26 | 9.99 | 2 | SO60045 | 2024-04-02 | 0.80 | 3.74 | |
SO60045_3 | 98 | 12856 | 477 | 10 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 3 | SO60045 | 2024-04-02 | 0.40 | 1.87 | |
SO60045_4 | 98 | 12856 | 490 | 10 | 2024-04-07 | 1.35 | 2024-03-26 | 53.99 | 4 | SO60045 | 2024-04-02 | 4.32 | 41.57 | |
SO60056_1 | 98 | 21130 | 583 | 10 | 2024-04-07 | 42.52 | 2024-03-26 | 1700.99 | 1 | SO60056 | 2024-04-02 | 136.08 | 1082.51 | |
SO60083_1 | 98 | 12550 | 538 | 10 | 2024-04-07 | 0.54 | 2024-03-26 | 21.49 | 1 | SO60083 | 2024-04-02 | 1.72 | 8.04 | |
SO60083_2 | 98 | 12550 | 529 | 10 | 2024-04-07 | 0.10 | 2024-03-26 | 3.99 | 2 | SO60083 | 2024-04-02 | 0.32 | 1.49 | |
SO60083_3 | 98 | 12550 | 480 | 10 | 2024-04-07 | 0.06 | 2024-03-26 | 2.29 | 3 | SO60083 | 2024-04-02 | 0.18 | 0.86 | |
SO60084_1 | 98 | 14806 | 541 | 10 | 2024-04-07 | 0.72 | 2024-03-26 | 28.99 | 1 | SO60084 | 2024-04-02 | 2.32 | 10.84 | |
SO60084_2 | 98 | 14806 | 530 | 10 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 2 | SO60084 | 2024-04-02 | 0.40 | 1.87 | |
SO60084_3 | 98 | 14806 | 222 | 10 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 3 | SO60084 | 2024-04-02 | 2.80 | 13.09 | |
SO60084_4 | 98 | 14806 | 237 | 10 | 2024-04-07 | 1.25 | 2024-03-26 | 49.99 | 4 | SO60084 | 2024-04-02 | 4.00 | 38.49 | |
SO60086_1 | 98 | 12334 | 541 | 10 | 2024-04-07 | 0.72 | 2024-03-26 | 28.99 | 1 | SO60086 | 2024-04-02 | 2.32 | 10.84 | |
SO60086_2 | 98 | 12334 | 530 | 10 | 2024-04-07 | 0.12 | 2024-03-26 | 4.99 | 2 | SO60086 | 2024-04-02 | 0.40 | 1.87 | |
SO60086_3 | 98 | 12334 | 480 | 10 | 2024-04-07 | 0.06 | 2024-03-26 | 2.29 | 3 | SO60086 | 2024-04-02 | 0.18 | 0.86 | |
SO60086_4 | 98 | 12334 | 484 | 10 | 2024-04-07 | 0.20 | 2024-03-26 | 7.95 | 4 | SO60086 | 2024-04-02 | 0.64 | 2.97 | |
SO60118_1 | 98 | 24015 | 390 | 10 | 2024-04-07 | 28.01 | 2024-03-26 | 1120.49 | 1 | SO60118 | 2024-04-02 | 89.64 | 713.08 | |
SO60118_2 | 98 | 24015 | 222 | 10 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 2 | SO60118 | 2024-04-02 | 2.80 | 13.09 | |
SO60128_1 | 98 | 16046 | 588 | 10 | 2024-04-08 | 19.24 | 2024-03-27 | 769.49 | 1 | SO60128 | 2024-04-03 | 61.56 | 419.78 | |
SO60128_2 | 98 | 16046 | 484 | 10 | 2024-04-08 | 0.20 | 2024-03-27 | 7.95 | 2 | SO60128 | 2024-04-03 | 0.64 | 2.97 | |
SO60148_1 | 98 | 19077 | 528 | 10 | 2024-04-08 | 0.12 | 2024-03-27 | 4.99 | 1 | SO60148 | 2024-04-03 | 0.40 | 1.87 | |
SO60148_2 | 98 | 19077 | 217 | 10 | 2024-04-08 | 0.87 | 2024-03-27 | 34.99 | 2 | SO60148 | 2024-04-03 | 2.80 | 13.09 | |
SO60154_1 | 98 | 29384 | 538 | 10 | 2024-04-08 | 0.54 | 2024-03-27 | 21.49 | 1 | SO60154 | 2024-04-03 | 1.72 | 8.04 | |
SO60154_2 | 98 | 29384 | 480 | 10 | 2024-04-08 | 0.06 | 2024-03-27 | 2.29 | 2 | SO60154 | 2024-04-03 | 0.18 | 0.86 | |
SO60163_1 | 98 | 12394 | 578 | 10 | 2024-04-08 | 30.37 | 2024-03-27 | 1214.85 | 1 | SO60163 | 2024-04-03 | 97.19 | 755.15 | |
SO60190_1 | 98 | 21012 | 582 | 10 | 2024-04-09 | 42.52 | 2024-03-28 | 1700.99 | 1 | SO60190 | 2024-04-04 | 136.08 | 1082.51 | |
SO60190_2 | 98 | 21012 | 479 | 10 | 2024-04-09 | 0.22 | 2024-03-28 | 8.99 | 2 | SO60190 | 2024-04-04 | 0.72 | 3.36 | |
SO60190_3 | 98 | 21012 | 477 | 10 | 2024-04-09 | 0.12 | 2024-03-28 | 4.99 | 3 | SO60190 | 2024-04-04 | 0.40 | 1.87 | |
SO53040_2 | 98 | 28410 | 529 | 10 | 2023-12-16 | 0.10 | 2023-12-04 | 3.99 | 2 | SO53040 | 2023-12-11 | 0.32 | 1.49 | |
SO53040_3 | 98 | 28410 | 217 | 10 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 3 | SO53040 | 2023-12-11 | 2.80 | 13.09 | |
SO53044_1 | 98 | 12602 | 225 | 10 | 2023-12-16 | 0.22 | 2023-12-04 | 8.99 | 1 | SO53044 | 2023-12-11 | 0.72 | 6.92 | |
SO53067_1 | 98 | 22639 | 386 | 10 | 2023-12-16 | 28.01 | 2023-12-04 | 1120.49 | 1 | SO53067 | 2023-12-11 | 89.64 | 713.08 | |
SO53067_2 | 98 | 22639 | 217 | 10 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 2 | SO53067 | 2023-12-11 | 2.80 | 13.09 | |
SO53082_1 | 98 | 19440 | 378 | 10 | 2023-12-17 | 61.08 | 2023-12-05 | 2443.35 | 1 | SO53082 | 2023-12-12 | 195.47 | 1554.95 | |
SO53082_2 | 98 | 19440 | 477 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 2 | SO53082 | 2023-12-12 | 0.40 | 1.87 | |
SO53082_3 | 98 | 19440 | 479 | 10 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 3 | SO53082 | 2023-12-12 | 0.72 | 3.36 | |
SO53082_4 | 98 | 19440 | 222 | 10 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 4 | SO53082 | 2023-12-12 | 2.80 | 13.09 | |
SO53108_1 | 98 | 23770 | 477 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53108 | 2023-12-12 | 0.40 | 1.87 | |
SO53110_1 | 98 | 26037 | 529 | 10 | 2023-12-17 | 0.10 | 2023-12-05 | 3.99 | 1 | SO53110 | 2023-12-12 | 0.32 | 1.49 | |
SO53110_2 | 98 | 26037 | 222 | 10 | 2023-12-17 | 0.87 | 2023-12-05 | 34.99 | 2 | SO53110 | 2023-12-12 | 2.80 | 13.09 | |
SO53113_1 | 98 | 14840 | 530 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 1 | SO53113 | 2023-12-12 | 0.40 | 1.87 | |
SO53113_2 | 98 | 14840 | 541 | 10 | 2023-12-17 | 0.72 | 2023-12-05 | 28.99 | 2 | SO53113 | 2023-12-12 | 2.32 | 10.84 | |
SO53131_1 | 98 | 27956 | 606 | 2 | 10 | 2023-12-17 | 13.50 | 2023-12-05 | 539.99 | 1 | SO53131 | 2023-12-12 | 43.20 | 343.65 |
SO53131_2 | 98 | 27956 | 477 | 10 | 2023-12-17 | 0.12 | 2023-12-05 | 4.99 | 2 | SO53131 | 2023-12-12 | 0.40 | 1.87 | |
SO53131_3 | 98 | 27956 | 479 | 10 | 2023-12-17 | 0.22 | 2023-12-05 | 8.99 | 3 | SO53131 | 2023-12-12 | 0.72 | 3.36 | |
SO53135_1 | 98 | 11413 | 357 | 10 | 2023-12-18 | 58.00 | 2023-12-06 | 2319.99 | 1 | SO53135 | 2023-12-13 | 185.60 | 1265.62 | |
SO53135_2 | 98 | 11413 | 485 | 10 | 2023-12-18 | 0.55 | 2023-12-06 | 21.98 | 2 | SO53135 | 2023-12-13 | 1.76 | 8.22 | |
SO53135_3 | 98 | 11413 | 225 | 10 | 2023-12-18 | 0.22 | 2023-12-06 | 8.99 | 3 | SO53135 | 2023-12-13 | 0.72 | 6.92 | |
SO53141_1 | 98 | 23636 | 372 | 10 | 2023-12-18 | 61.08 | 2023-12-06 | 2443.35 | 1 | SO53141 | 2023-12-13 | 195.47 | 1554.95 | |
SO53141_2 | 98 | 23636 | 529 | 10 | 2023-12-18 | 0.10 | 2023-12-06 | 3.99 | 2 | SO53141 | 2023-12-13 | 0.32 | 1.49 | |
SO53141_3 | 98 | 23636 | 540 | 10 | 2023-12-18 | 0.82 | 2023-12-06 | 32.60 | 3 | SO53141 | 2023-12-13 | 2.61 | 12.19 | |
SO53162_1 | 98 | 26911 | 529 | 10 | 2023-12-18 | 0.10 | 2023-12-06 | 3.99 | 1 | SO53162 | 2023-12-13 | 0.32 | 1.49 | |
SO53163_1 | 98 | 28918 | 538 | 10 | 2023-12-18 | 0.54 | 2023-12-06 | 21.49 | 1 | SO53163 | 2023-12-13 | 1.72 | 8.04 |
Generated 2024-11-10 07:09:26.918 UTC