[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 187 < SKIP 1235 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51004_1 | 100 | 13978 | 369 | 2 | 1 | 2023-10-15 | 61.08 | 2023-10-03 | 2443.35 | 1 | SO51004 | 2023-10-10 | 195.47 | 1518.79 |
SO62463_2 | 100 | 23181 | 477 | 1 | 2024-05-13 | 0.12 | 2024-05-01 | 4.99 | 2 | SO62463 | 2024-05-08 | 0.40 | 1.87 | |
SO69074_2 | 100 | 27117 | 222 | 1 | 2024-08-18 | 0.87 | 2024-08-06 | 34.99 | 2 | SO69074 | 2024-08-13 | 2.80 | 13.09 | |
SO51006_1 | 100 | 14461 | 389 | 1 | 2023-10-15 | 25.01 | 2023-10-03 | 1000.44 | 1 | SO51006 | 2023-10-10 | 80.04 | 605.65 | |
SO62463_3 | 100 | 23181 | 479 | 1 | 2024-05-13 | 0.22 | 2024-05-01 | 8.99 | 3 | SO62463 | 2024-05-08 | 0.72 | 3.36 | |
SO69076_1 | 100 | 25970 | 560 | 1 | 2024-08-18 | 30.37 | 2024-08-06 | 1214.85 | 1 | SO69076 | 2024-08-13 | 97.19 | 755.15 | |
SO51017_1 | 100 | 15987 | 329 | 1 | 2023-10-16 | 19.57 | 2023-10-04 | 782.99 | 1 | SO51017 | 2023-10-11 | 62.64 | 486.71 | |
SO62463_4 | 100 | 23181 | 214 | 1 | 2024-05-13 | 0.87 | 2024-05-01 | 34.99 | 4 | SO62463 | 2024-05-08 | 2.80 | 13.09 | |
SO69076_2 | 100 | 25970 | 479 | 1 | 2024-08-18 | 0.22 | 2024-08-06 | 8.99 | 2 | SO69076 | 2024-08-13 | 0.72 | 3.36 | |
SO51030_1 | 100 | 27524 | 362 | 2 | 1 | 2023-10-18 | 51.23 | 2023-10-06 | 2049.10 | 1 | SO51030 | 2023-10-13 | 163.93 | 1105.81 |
SO62483_1 | 100 | 11870 | 217 | 1 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 1 | SO62483 | 2024-05-09 | 2.80 | 13.09 | |
SO69076_3 | 100 | 25970 | 477 | 1 | 2024-08-18 | 0.12 | 2024-08-06 | 4.99 | 3 | SO69076 | 2024-08-13 | 0.40 | 1.87 | |
SO51038_1 | 100 | 27559 | 362 | 2 | 1 | 2023-10-19 | 51.23 | 2023-10-07 | 2049.10 | 1 | SO51038 | 2023-10-14 | 163.93 | 1105.81 |
SO62485_1 | 100 | 11197 | 529 | 1 | 2024-05-14 | 0.10 | 2024-05-02 | 3.99 | 1 | SO62485 | 2024-05-09 | 0.32 | 1.49 | |
SO69079_1 | 100 | 19209 | 606 | 1 | 2024-08-18 | 13.50 | 2024-08-06 | 539.99 | 1 | SO69079 | 2024-08-13 | 43.20 | 343.65 | |
SO51046_1 | 100 | 13976 | 371 | 1 | 2023-10-19 | 54.54 | 2023-10-07 | 2181.56 | 1 | SO51046 | 2023-10-14 | 174.53 | 1320.68 | |
SO62485_2 | 100 | 11197 | 480 | 1 | 2024-05-14 | 0.06 | 2024-05-02 | 2.29 | 2 | SO62485 | 2024-05-09 | 0.18 | 0.86 | |
SO69079_2 | 100 | 19209 | 217 | 1 | 2024-08-18 | 0.87 | 2024-08-06 | 34.99 | 2 | SO69079 | 2024-08-13 | 2.80 | 13.09 | |
SO51051_1 | 100 | 27568 | 356 | 1 | 2023-10-20 | 51.79 | 2023-10-08 | 2071.42 | 1 | SO51051 | 2023-10-15 | 165.71 | 1117.86 | |
SO62485_3 | 100 | 11197 | 486 | 1 | 2024-05-14 | 3.98 | 2024-05-02 | 159.00 | 3 | SO62485 | 2024-05-09 | 12.72 | 59.47 | |
SO69080_1 | 100 | 19803 | 584 | 1 | 2024-08-18 | 13.50 | 2024-08-06 | 539.99 | 1 | SO69080 | 2024-08-13 | 43.20 | 343.65 | |
SO51066_1 | 100 | 27556 | 358 | 1 | 2023-10-21 | 51.23 | 2023-10-09 | 2049.10 | 1 | SO51066 | 2023-10-16 | 163.93 | 1105.81 | |
SO62509_1 | 100 | 13327 | 485 | 1 | 2024-05-14 | 0.55 | 2024-05-02 | 21.98 | 1 | SO62509 | 2024-05-09 | 1.76 | 8.22 | |
SO69080_2 | 100 | 19803 | 214 | 1 | 2024-08-18 | 0.87 | 2024-08-06 | 34.99 | 2 | SO69080 | 2024-08-13 | 2.80 | 13.09 | |
SO51076_1 | 100 | 15959 | 329 | 1 | 2023-10-22 | 19.57 | 2023-10-10 | 782.99 | 1 | SO51076 | 2023-10-17 | 62.64 | 486.71 | |
SO62509_2 | 100 | 13327 | 225 | 1 | 2024-05-14 | 0.22 | 2024-05-02 | 8.99 | 2 | SO62509 | 2024-05-09 | 0.72 | 6.92 | |
SO69110_1 | 100 | 20687 | 478 | 1 | 2024-08-19 | 0.25 | 2024-08-07 | 9.99 | 1 | SO69110 | 2024-08-14 | 0.80 | 3.74 | |
SO51183_1 | 100 | 20662 | 581 | 1 | 2023-10-23 | 42.52 | 2023-10-11 | 1700.99 | 1 | SO51183 | 2023-10-18 | 136.08 | 1082.51 | |
SO62510_1 | 100 | 16751 | 374 | 1 | 2024-05-14 | 61.08 | 2024-05-02 | 2443.35 | 1 | SO62510 | 2024-05-09 | 195.47 | 1554.95 | |
SO69112_1 | 100 | 17451 | 477 | 1 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 1 | SO69112 | 2024-08-14 | 0.40 | 1.87 | |
SO51183_2 | 100 | 20662 | 234 | 1 | 2023-10-23 | 1.25 | 2023-10-11 | 49.99 | 2 | SO51183 | 2023-10-18 | 4.00 | 38.49 | |
SO62510_2 | 100 | 16751 | 479 | 1 | 2024-05-14 | 0.22 | 2024-05-02 | 8.99 | 2 | SO62510 | 2024-05-09 | 0.72 | 3.36 | |
SO69112_2 | 100 | 17451 | 222 | 1 | 2024-08-19 | 0.87 | 2024-08-07 | 34.99 | 2 | SO69112 | 2024-08-14 | 2.80 | 13.09 | |
SO51184_1 | 100 | 11263 | 353 | 1 | 2023-10-23 | 58.00 | 2023-10-11 | 2319.99 | 1 | SO51184 | 2023-10-18 | 185.60 | 1265.62 | |
SO62510_3 | 100 | 16751 | 477 | 1 | 2024-05-14 | 0.12 | 2024-05-02 | 4.99 | 3 | SO62510 | 2024-05-09 | 0.40 | 1.87 | |
SO69114_1 | 100 | 18316 | 528 | 1 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 1 | SO69114 | 2024-08-14 | 0.40 | 1.87 | |
SO51184_2 | 100 | 11263 | 537 | 1 | 2023-10-23 | 0.88 | 2023-10-11 | 35.00 | 2 | SO51184 | 2023-10-18 | 2.80 | 13.09 | |
SO62510_4 | 100 | 16751 | 214 | 1 | 2024-05-14 | 0.87 | 2024-05-02 | 34.99 | 4 | SO62510 | 2024-05-09 | 2.80 | 13.09 | |
SO69114_2 | 100 | 18316 | 480 | 2 | 1 | 2024-08-19 | 0.06 | 2024-08-07 | 2.29 | 2 | SO69114 | 2024-08-14 | 0.18 | 0.86 |
SO51184_3 | 100 | 11263 | 528 | 1 | 2023-10-23 | 0.12 | 2023-10-11 | 4.99 | 3 | SO51184 | 2023-10-18 | 0.40 | 1.87 | |
SO62521_1 | 100 | 25420 | 578 | 1 | 2024-05-14 | 30.37 | 2024-05-02 | 1214.85 | 1 | SO62521 | 2024-05-09 | 97.19 | 755.15 | |
SO69115_1 | 100 | 15938 | 528 | 1 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 1 | SO69115 | 2024-08-14 | 0.40 | 1.87 | |
SO51184_4 | 100 | 11263 | 222 | 1 | 2023-10-23 | 0.87 | 2023-10-11 | 34.99 | 4 | SO51184 | 2023-10-18 | 2.80 | 13.09 | |
SO62521_2 | 100 | 25420 | 489 | 1 | 2024-05-14 | 1.35 | 2024-05-02 | 53.99 | 2 | SO62521 | 2024-05-09 | 4.32 | 41.57 | |
SO69115_2 | 100 | 15938 | 480 | 2 | 1 | 2024-08-19 | 0.06 | 2024-08-07 | 2.29 | 2 | SO69115 | 2024-08-14 | 0.18 | 0.86 |
SO51252_1 | 100 | 15551 | 592 | 1 | 2023-10-27 | 14.12 | 2023-10-15 | 564.99 | 1 | SO51252 | 2023-10-22 | 45.20 | 308.22 | |
SO62522_1 | 100 | 29202 | 566 | 1 | 2024-05-14 | 18.56 | 2024-05-02 | 742.35 | 1 | SO62522 | 2024-05-09 | 59.39 | 461.44 | |
SO69129_1 | 100 | 16882 | 363 | 2 | 1 | 2024-08-19 | 57.37 | 2024-08-07 | 2294.99 | 1 | SO69129 | 2024-08-14 | 183.60 | 1251.98 |
SO51252_2 | 100 | 15551 | 535 | 1 | 2023-10-27 | 0.62 | 2023-10-15 | 24.99 | 2 | SO51252 | 2023-10-22 | 2.00 | 9.35 | |
SO62553_1 | 100 | 21273 | 478 | 1 | 2024-05-15 | 0.25 | 2024-05-03 | 9.99 | 1 | SO62553 | 2024-05-10 | 0.80 | 3.74 | |
SO69146_1 | 100 | 27455 | 561 | 1 | 2024-08-19 | 59.60 | 2024-08-07 | 2384.07 | 1 | SO69146 | 2024-08-14 | 190.73 | 1481.94 | |
SO51252_3 | 100 | 15551 | 480 | 1 | 2023-10-27 | 0.06 | 2023-10-15 | 2.29 | 3 | SO51252 | 2023-10-22 | 0.18 | 0.86 | |
SO62553_2 | 100 | 21273 | 477 | 1 | 2024-05-15 | 0.12 | 2024-05-03 | 4.99 | 2 | SO62553 | 2024-05-10 | 0.40 | 1.87 | |
SO69146_2 | 100 | 27455 | 479 | 1 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 2 | SO69146 | 2024-08-14 | 0.72 | 3.36 | |
SO51264_1 | 100 | 11282 | 361 | 1 | 2023-10-28 | 57.37 | 2023-10-16 | 2294.99 | 1 | SO51264 | 2023-10-23 | 183.60 | 1251.98 | |
SO62555_1 | 100 | 13483 | 485 | 1 | 2024-05-15 | 0.55 | 2024-05-03 | 21.98 | 1 | SO62555 | 2024-05-10 | 1.76 | 8.22 | |
SO69146_3 | 100 | 27455 | 477 | 1 | 2024-08-19 | 0.12 | 2024-08-07 | 4.99 | 3 | SO69146 | 2024-08-14 | 0.40 | 1.87 | |
SO51264_2 | 100 | 11282 | 528 | 1 | 2023-10-28 | 0.12 | 2023-10-16 | 4.99 | 2 | SO51264 | 2023-10-23 | 0.40 | 1.87 | |
SO62555_2 | 100 | 13483 | 222 | 1 | 2024-05-15 | 0.87 | 2024-05-03 | 34.99 | 2 | SO62555 | 2024-05-10 | 2.80 | 13.09 | |
SO69146_4 | 100 | 27455 | 473 | 1 | 2024-08-19 | 1.59 | 2024-08-07 | 63.50 | 4 | SO69146 | 2024-08-14 | 5.08 | 23.75 |
Generated 2024-11-10 10:52:59.176 UTC