[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > SKIP 1000 < SKIP 1972 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO58579_1 | 98 | 23987 | 386 | 10 | 2024-03-18 | 28.01 | 2024-03-06 | 1120.49 | 1 | SO58579 | 2024-03-13 | 89.64 | 713.08 | |
SO64848_3 | 98 | 24058 | 222 | 10 | 2024-06-17 | 0.87 | 2024-06-05 | 34.99 | 3 | SO64848 | 2024-06-12 | 2.80 | 13.09 | |
SO52990_1 | 98 | 20588 | 535 | 10 | 2023-12-15 | 0.62 | 2023-12-03 | 24.99 | 1 | SO52990 | 2023-12-10 | 2.00 | 9.35 | |
SO58579_2 | 98 | 23987 | 539 | 10 | 2024-03-18 | 0.62 | 2024-03-06 | 24.99 | 2 | SO58579 | 2024-03-13 | 2.00 | 9.35 | |
SO64864_1 | 98 | 13689 | 355 | 10 | 2024-06-18 | 58.00 | 2024-06-06 | 2319.99 | 1 | SO64864 | 2024-06-13 | 185.60 | 1265.62 | |
SO52990_2 | 98 | 20588 | 480 | 10 | 2023-12-15 | 0.06 | 2023-12-03 | 2.29 | 2 | SO52990 | 2023-12-10 | 0.18 | 0.86 | |
SO58579_3 | 98 | 23987 | 480 | 2 | 10 | 2024-03-18 | 0.06 | 2024-03-06 | 2.29 | 3 | SO58579 | 2024-03-13 | 0.18 | 0.86 |
SO64881_1 | 98 | 14199 | 530 | 10 | 2024-06-18 | 0.12 | 2024-06-06 | 4.99 | 1 | SO64881 | 2024-06-13 | 0.40 | 1.87 | |
SO52992_1 | 98 | 27806 | 529 | 10 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 1 | SO52992 | 2023-12-10 | 0.32 | 1.49 | |
SO58583_1 | 98 | 28747 | 562 | 10 | 2024-03-18 | 59.60 | 2024-03-06 | 2384.07 | 1 | SO58583 | 2024-03-13 | 190.73 | 1481.94 | |
SO64881_2 | 98 | 14199 | 541 | 10 | 2024-06-18 | 0.72 | 2024-06-06 | 28.99 | 2 | SO64881 | 2024-06-13 | 2.32 | 10.84 | |
SO52993_1 | 98 | 26865 | 529 | 10 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 1 | SO52993 | 2023-12-10 | 0.32 | 1.49 | |
SO58583_2 | 98 | 28747 | 477 | 10 | 2024-03-18 | 0.12 | 2024-03-06 | 4.99 | 2 | SO58583 | 2024-03-13 | 0.40 | 1.87 | |
SO64881_3 | 98 | 14199 | 214 | 10 | 2024-06-18 | 0.87 | 2024-06-06 | 34.99 | 3 | SO64881 | 2024-06-13 | 2.80 | 13.09 | |
SO52993_2 | 98 | 26865 | 483 | 10 | 2023-12-15 | 3.00 | 2023-12-03 | 120.00 | 2 | SO52993 | 2023-12-10 | 9.60 | 44.88 | |
SO58583_3 | 98 | 28747 | 479 | 10 | 2024-03-18 | 0.22 | 2024-03-06 | 8.99 | 3 | SO58583 | 2024-03-13 | 0.72 | 3.36 | |
SO64894_1 | 98 | 27132 | 584 | 10 | 2024-06-18 | 13.50 | 2024-06-06 | 539.99 | 1 | SO64894 | 2024-06-13 | 43.20 | 343.65 | |
SO52994_1 | 98 | 16193 | 530 | 10 | 2023-12-15 | 0.12 | 2023-12-03 | 4.99 | 1 | SO52994 | 2023-12-10 | 0.40 | 1.87 | |
SO58585_1 | 98 | 12404 | 359 | 10 | 2024-03-19 | 57.37 | 2024-03-07 | 2294.99 | 1 | SO58585 | 2024-03-14 | 183.60 | 1251.98 | |
SO64894_2 | 98 | 27132 | 538 | 10 | 2024-06-18 | 0.54 | 2024-06-06 | 21.49 | 2 | SO64894 | 2024-06-13 | 1.72 | 8.04 | |
SO53005_1 | 98 | 11493 | 363 | 10 | 2023-12-16 | 57.37 | 2023-12-04 | 2294.99 | 1 | SO53005 | 2023-12-11 | 183.60 | 1251.98 | |
SO58585_2 | 98 | 12404 | 478 | 10 | 2024-03-19 | 0.25 | 2024-03-07 | 9.99 | 2 | SO58585 | 2024-03-14 | 0.80 | 3.74 | |
SO64894_3 | 98 | 27132 | 480 | 2 | 10 | 2024-06-18 | 0.06 | 2024-06-06 | 2.29 | 3 | SO64894 | 2024-06-13 | 0.18 | 0.86 |
SO53005_2 | 98 | 11493 | 222 | 10 | 2023-12-16 | 0.87 | 2023-12-04 | 34.99 | 2 | SO53005 | 2023-12-11 | 2.80 | 13.09 | |
SO58585_3 | 98 | 12404 | 214 | 10 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 3 | SO58585 | 2024-03-14 | 2.80 | 13.09 | |
SO64894_4 | 98 | 27132 | 484 | 10 | 2024-06-18 | 0.20 | 2024-06-06 | 7.95 | 4 | SO64894 | 2024-06-13 | 0.64 | 2.97 | |
SO53037_1 | 98 | 18632 | 528 | 10 | 2023-12-16 | 0.12 | 2023-12-04 | 4.99 | 1 | SO53037 | 2023-12-11 | 0.40 | 1.87 | |
SO58585_4 | 98 | 12404 | 489 | 10 | 2024-03-19 | 1.35 | 2024-03-07 | 53.99 | 4 | SO58585 | 2024-03-14 | 4.32 | 41.57 | |
SO64904_1 | 98 | 17959 | 599 | 10 | 2024-06-19 | 13.50 | 2024-06-07 | 539.99 | 1 | SO64904 | 2024-06-14 | 43.20 | 294.58 | |
SO53037_2 | 98 | 18632 | 535 | 10 | 2023-12-16 | 0.62 | 2023-12-04 | 24.99 | 2 | SO53037 | 2023-12-11 | 2.00 | 9.35 | |
SO58586_1 | 98 | 12277 | 357 | 10 | 2024-03-19 | 58.00 | 2024-03-07 | 2319.99 | 1 | SO58586 | 2024-03-14 | 185.60 | 1265.62 | |
SO64904_2 | 98 | 17959 | 535 | 10 | 2024-06-19 | 0.62 | 2024-06-07 | 24.99 | 2 | SO64904 | 2024-06-14 | 2.00 | 9.35 | |
SO53037_3 | 98 | 18632 | 480 | 2 | 10 | 2023-12-16 | 0.06 | 2023-12-04 | 2.29 | 3 | SO53037 | 2023-12-11 | 0.18 | 0.86 |
SO58586_2 | 98 | 12277 | 537 | 10 | 2024-03-19 | 0.88 | 2024-03-07 | 35.00 | 2 | SO58586 | 2024-03-14 | 2.80 | 13.09 | |
SO64904_3 | 98 | 17959 | 480 | 10 | 2024-06-19 | 0.06 | 2024-06-07 | 2.29 | 3 | SO64904 | 2024-06-14 | 0.18 | 0.86 | |
SO53040_1 | 98 | 28410 | 538 | 10 | 2023-12-16 | 0.54 | 2023-12-04 | 21.49 | 1 | SO53040 | 2023-12-11 | 1.72 | 8.04 | |
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 |
Generated 2024-11-10 12:44:39.596 UTC