[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 818 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50370_1 | 100 | 17941 | 377 | 8 | 2023-07-06 | 54.54 | 2023-06-24 | 2181.56 | 1 | SO50370 | 2023-07-01 | 174.53 | 1320.68 | |
SO50377_1 | 100 | 20913 | 333 | 8 | 2023-07-07 | 19.57 | 2023-06-25 | 782.99 | 1 | SO50377 | 2023-07-02 | 62.64 | 486.71 | |
SO50386_1 | 100 | 17942 | 373 | 8 | 2023-07-08 | 54.54 | 2023-06-26 | 2181.56 | 1 | SO50386 | 2023-07-03 | 174.53 | 1320.68 | |
SO50389_1 | 100 | 12813 | 362 | 2 | 8 | 2023-07-08 | 51.23 | 2023-06-26 | 2049.10 | 1 | SO50389 | 2023-07-03 | 163.93 | 1105.81 |
SO50403_1 | 100 | 20914 | 321 | 8 | 2023-07-09 | 19.57 | 2023-06-27 | 782.99 | 1 | SO50403 | 2023-07-04 | 62.64 | 486.71 | |
SO50414_1 | 100 | 19285 | 387 | 8 | 2023-07-10 | 25.01 | 2023-06-28 | 1000.44 | 1 | SO50414 | 2023-07-05 | 80.04 | 605.65 | |
SO50415_1 | 100 | 20970 | 323 | 8 | 2023-07-10 | 19.57 | 2023-06-28 | 782.99 | 1 | SO50415 | 2023-07-05 | 62.64 | 486.71 | |
SO50432_1 | 100 | 17940 | 377 | 8 | 2023-07-12 | 54.54 | 2023-06-30 | 2181.56 | 1 | SO50432 | 2023-07-07 | 174.53 | 1320.68 | |
SO50433_1 | 100 | 21008 | 327 | 8 | 2023-07-12 | 19.57 | 2023-06-30 | 782.99 | 1 | SO50433 | 2023-07-07 | 62.64 | 486.71 | |
SO50438_1 | 100 | 17929 | 371 | 8 | 2023-07-13 | 54.54 | 2023-07-01 | 2181.56 | 1 | SO50438 | 2023-07-08 | 174.53 | 1320.68 | |
SO50465_1 | 100 | 19294 | 381 | 8 | 2023-07-15 | 25.01 | 2023-07-03 | 1000.44 | 1 | SO50465 | 2023-07-10 | 80.04 | 605.65 | |
SO50471_1 | 100 | 12807 | 352 | 8 | 2023-07-15 | 51.79 | 2023-07-03 | 2071.42 | 1 | SO50471 | 2023-07-10 | 165.71 | 1117.86 | |
SO50476_1 | 100 | 20980 | 341 | 8 | 2023-07-16 | 19.57 | 2023-07-04 | 782.99 | 1 | SO50476 | 2023-07-11 | 62.64 | 486.71 | |
SO50503_1 | 100 | 19286 | 389 | 8 | 2023-07-19 | 25.01 | 2023-07-07 | 1000.44 | 1 | SO50503 | 2023-07-14 | 80.04 | 605.65 | |
SO62843_1 | 100 | 21836 | 477 | 8 | 2024-03-30 | 0.12 | 2024-03-18 | 4.99 | 1 | SO62843 | 2024-03-25 | 0.40 | 1.87 | |
SO62845_1 | 100 | 24563 | 529 | 8 | 2024-03-30 | 0.10 | 2024-03-18 | 3.99 | 1 | SO62845 | 2024-03-25 | 0.32 | 1.49 | |
SO62845_2 | 100 | 24563 | 480 | 8 | 2024-03-30 | 0.06 | 2024-03-18 | 2.29 | 2 | SO62845 | 2024-03-25 | 0.18 | 0.86 | |
SO62869_1 | 100 | 28376 | 382 | 8 | 2024-03-30 | 28.01 | 2024-03-18 | 1120.49 | 1 | SO62869 | 2024-03-25 | 89.64 | 713.08 | |
SO62869_2 | 100 | 28376 | 479 | 8 | 2024-03-30 | 0.22 | 2024-03-18 | 8.99 | 2 | SO62869 | 2024-03-25 | 0.72 | 3.36 | |
SO62869_3 | 100 | 28376 | 477 | 8 | 2024-03-30 | 0.12 | 2024-03-18 | 4.99 | 3 | SO62869 | 2024-03-25 | 0.40 | 1.87 | |
SO62885_1 | 100 | 24053 | 376 | 8 | 2024-03-31 | 61.08 | 2024-03-19 | 2443.35 | 1 | SO62885 | 2024-03-26 | 195.47 | 1554.95 | |
SO62887_1 | 100 | 15084 | 353 | 8 | 2024-03-31 | 58.00 | 2024-03-19 | 2319.99 | 1 | SO62887 | 2024-03-26 | 185.60 | 1265.62 | |
SO62887_2 | 100 | 15084 | 478 | 8 | 2024-03-31 | 0.25 | 2024-03-19 | 9.99 | 2 | SO62887 | 2024-03-26 | 0.80 | 3.74 | |
SO62887_3 | 100 | 15084 | 477 | 8 | 2024-03-31 | 0.12 | 2024-03-19 | 4.99 | 3 | SO62887 | 2024-03-26 | 0.40 | 1.87 | |
SO62887_4 | 100 | 15084 | 472 | 8 | 2024-03-31 | 1.59 | 2024-03-19 | 63.50 | 4 | SO62887 | 2024-03-26 | 5.08 | 23.75 | |
SO62906_1 | 100 | 17853 | 528 | 8 | 2024-03-31 | 0.12 | 2024-03-19 | 4.99 | 1 | SO62906 | 2024-03-26 | 0.40 | 1.87 | |
SO62906_2 | 100 | 17853 | 535 | 8 | 2024-03-31 | 0.62 | 2024-03-19 | 24.99 | 2 | SO62906 | 2024-03-26 | 2.00 | 9.35 | |
SO62909_1 | 100 | 21821 | 477 | 8 | 2024-03-31 | 0.12 | 2024-03-19 | 4.99 | 1 | SO62909 | 2024-03-26 | 0.40 | 1.87 | |
SO62909_2 | 100 | 21821 | 214 | 8 | 2024-03-31 | 0.87 | 2024-03-19 | 34.99 | 2 | SO62909 | 2024-03-26 | 2.80 | 13.09 | |
SO62909_3 | 100 | 21821 | 225 | 8 | 2024-03-31 | 0.22 | 2024-03-19 | 8.99 | 3 | SO62909 | 2024-03-26 | 0.72 | 6.92 | |
SO62913_1 | 100 | 14528 | 530 | 8 | 2024-03-31 | 0.12 | 2024-03-19 | 4.99 | 1 | SO62913 | 2024-03-26 | 0.40 | 1.87 | |
SO62928_1 | 100 | 16199 | 576 | 8 | 2024-03-31 | 59.60 | 2024-03-19 | 2384.07 | 1 | SO62928 | 2024-03-26 | 190.73 | 1481.94 | |
SO62928_2 | 100 | 16199 | 214 | 8 | 2024-03-31 | 0.87 | 2024-03-19 | 34.99 | 2 | SO62928 | 2024-03-26 | 2.80 | 13.09 | |
SO62944_1 | 100 | 13540 | 584 | 8 | 2024-03-31 | 13.50 | 2024-03-19 | 539.99 | 1 | SO62944 | 2024-03-26 | 43.20 | 343.65 | |
SO62944_2 | 100 | 13540 | 479 | 8 | 2024-03-31 | 0.22 | 2024-03-19 | 8.99 | 2 | SO62944 | 2024-03-26 | 0.72 | 3.36 | |
SO62945_1 | 100 | 25744 | 574 | 8 | 2024-03-31 | 59.60 | 2024-03-19 | 2384.07 | 1 | SO62945 | 2024-03-26 | 190.73 | 1481.94 | |
SO62945_2 | 100 | 25744 | 541 | 8 | 2024-03-31 | 0.72 | 2024-03-19 | 28.99 | 2 | SO62945 | 2024-03-26 | 2.32 | 10.84 | |
SO62945_3 | 100 | 25744 | 530 | 8 | 2024-03-31 | 0.12 | 2024-03-19 | 4.99 | 3 | SO62945 | 2024-03-26 | 0.40 | 1.87 | |
SO62945_4 | 100 | 25744 | 480 | 8 | 2024-03-31 | 0.06 | 2024-03-19 | 2.29 | 4 | SO62945 | 2024-03-26 | 0.18 | 0.86 | |
SO62945_5 | 100 | 25744 | 484 | 8 | 2024-03-31 | 0.20 | 2024-03-19 | 7.95 | 5 | SO62945 | 2024-03-26 | 0.64 | 2.97 | |
SO62954_1 | 100 | 28902 | 372 | 8 | 2024-04-01 | 61.08 | 2024-03-20 | 2443.35 | 1 | SO62954 | 2024-03-27 | 195.47 | 1554.95 | |
SO62954_2 | 100 | 28902 | 529 | 8 | 2024-04-01 | 0.10 | 2024-03-20 | 3.99 | 2 | SO62954 | 2024-03-27 | 0.32 | 1.49 | |
SO62954_3 | 100 | 28902 | 540 | 8 | 2024-04-01 | 0.82 | 2024-03-20 | 32.60 | 3 | SO62954 | 2024-03-27 | 2.61 | 12.19 | |
SO62954_4 | 100 | 28902 | 234 | 8 | 2024-04-01 | 1.25 | 2024-03-20 | 49.99 | 4 | SO62954 | 2024-03-27 | 4.00 | 38.49 | |
SO62973_1 | 100 | 20143 | 536 | 8 | 2024-04-01 | 0.75 | 2024-03-20 | 29.99 | 1 | SO62973 | 2024-03-27 | 2.40 | 11.22 | |
SO62973_2 | 100 | 20143 | 480 | 2 | 8 | 2024-04-01 | 0.06 | 2024-03-20 | 2.29 | 2 | SO62973 | 2024-03-27 | 0.18 | 0.86 |
SO62975_1 | 100 | 21844 | 477 | 8 | 2024-04-01 | 0.12 | 2024-03-20 | 4.99 | 1 | SO62975 | 2024-03-27 | 0.40 | 1.87 | |
SO62975_2 | 100 | 21844 | 217 | 8 | 2024-04-01 | 0.87 | 2024-03-20 | 34.99 | 2 | SO62975 | 2024-03-27 | 2.80 | 13.09 | |
SO62976_1 | 100 | 24080 | 529 | 8 | 2024-04-01 | 0.10 | 2024-03-20 | 3.99 | 1 | SO62976 | 2024-03-27 | 0.32 | 1.49 | |
SO62976_2 | 100 | 24080 | 228 | 8 | 2024-04-01 | 1.25 | 2024-03-20 | 49.99 | 2 | SO62976 | 2024-03-27 | 4.00 | 38.49 | |
SO62980_1 | 100 | 13594 | 478 | 8 | 2024-04-01 | 0.25 | 2024-03-20 | 9.99 | 1 | SO62980 | 2024-03-27 | 0.80 | 3.74 | |
SO62980_2 | 100 | 13594 | 222 | 8 | 2024-04-01 | 0.87 | 2024-03-20 | 34.99 | 2 | SO62980 | 2024-03-27 | 2.80 | 13.09 | |
SO62987_1 | 100 | 25745 | 562 | 8 | 2024-04-01 | 59.60 | 2024-03-20 | 2384.07 | 1 | SO62987 | 2024-03-27 | 190.73 | 1481.94 | |
SO62987_2 | 100 | 25745 | 541 | 8 | 2024-04-01 | 0.72 | 2024-03-20 | 28.99 | 2 | SO62987 | 2024-03-27 | 2.32 | 10.84 | |
SO62987_3 | 100 | 25745 | 530 | 8 | 2024-04-01 | 0.12 | 2024-03-20 | 4.99 | 3 | SO62987 | 2024-03-27 | 0.40 | 1.87 | |
SO62987_4 | 100 | 25745 | 487 | 8 | 2024-04-01 | 1.37 | 2024-03-20 | 54.99 | 4 | SO62987 | 2024-03-27 | 4.40 | 20.57 | |
SO63014_1 | 100 | 20930 | 589 | 8 | 2024-04-02 | 19.24 | 2024-03-21 | 769.49 | 1 | SO63014 | 2024-03-28 | 61.56 | 419.78 | |
SO63014_2 | 100 | 20930 | 528 | 8 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO63014 | 2024-03-28 | 0.40 | 1.87 | |
SO63014_3 | 100 | 20930 | 536 | 8 | 2024-04-02 | 0.75 | 2024-03-21 | 29.99 | 3 | SO63014 | 2024-03-28 | 2.40 | 11.22 | |
SO63017_1 | 100 | 15117 | 363 | 8 | 2024-04-02 | 57.37 | 2024-03-21 | 2294.99 | 1 | SO63017 | 2024-03-28 | 183.60 | 1251.98 | |
SO63017_2 | 100 | 15117 | 478 | 8 | 2024-04-02 | 0.25 | 2024-03-21 | 9.99 | 2 | SO63017 | 2024-03-28 | 0.80 | 3.74 | |
SO63017_3 | 100 | 15117 | 477 | 8 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 3 | SO63017 | 2024-03-28 | 0.40 | 1.87 |
Generated 2024-09-20 17:50:37.303 UTC