[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 2624 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO71142_1 | 100 | 21006 | 388 | 8 | 2024-09-17 | 28.01 | 2024-09-05 | 1120.49 | 1 | SO71142 | 2024-09-12 | 89.64 | 713.08 | |
SO71142_2 | 100 | 21006 | 217 | 8 | 2024-09-17 | 0.87 | 2024-09-05 | 34.99 | 2 | SO71142 | 2024-09-12 | 2.80 | 13.09 | |
SO71144_1 | 100 | 25468 | 605 | 8 | 2024-09-17 | 13.50 | 2024-09-05 | 539.99 | 1 | SO71144 | 2024-09-12 | 43.20 | 343.65 | |
SO71144_2 | 100 | 25468 | 479 | 8 | 2024-09-17 | 0.22 | 2024-09-05 | 8.99 | 2 | SO71144 | 2024-09-12 | 0.72 | 3.36 | |
SO71150_1 | 100 | 19274 | 582 | 8 | 2024-09-17 | 42.52 | 2024-09-05 | 1700.99 | 1 | SO71150 | 2024-09-12 | 136.08 | 1082.51 | |
SO71178_1 | 100 | 13500 | 530 | 8 | 2024-09-18 | 0.12 | 2024-09-06 | 4.99 | 1 | SO71178 | 2024-09-13 | 0.40 | 1.87 | |
SO71178_2 | 100 | 13500 | 222 | 8 | 2024-09-18 | 0.87 | 2024-09-06 | 34.99 | 2 | SO71178 | 2024-09-13 | 2.80 | 13.09 | |
SO71191_1 | 100 | 12291 | 575 | 8 | 2024-09-18 | 59.60 | 2024-09-06 | 2384.07 | 1 | SO71191 | 2024-09-13 | 190.73 | 1481.94 | |
SO71191_2 | 100 | 12291 | 481 | 2 | 8 | 2024-09-18 | 0.22 | 2024-09-06 | 8.99 | 2 | SO71191 | 2024-09-13 | 0.72 | 3.36 |
SO71216_1 | 100 | 25303 | 605 | 8 | 2024-09-18 | 13.50 | 2024-09-06 | 539.99 | 1 | SO71216 | 2024-09-13 | 43.20 | 343.65 | |
SO71216_2 | 100 | 25303 | 214 | 8 | 2024-09-18 | 0.87 | 2024-09-06 | 34.99 | 2 | SO71216 | 2024-09-13 | 2.80 | 13.09 | |
SO71219_1 | 100 | 19188 | 582 | 8 | 2024-09-18 | 42.52 | 2024-09-06 | 1700.99 | 1 | SO71219 | 2024-09-13 | 136.08 | 1082.51 | |
SO71219_2 | 100 | 19188 | 539 | 8 | 2024-09-18 | 0.62 | 2024-09-06 | 24.99 | 2 | SO71219 | 2024-09-13 | 2.00 | 9.35 | |
SO71219_3 | 100 | 19188 | 529 | 8 | 2024-09-18 | 0.10 | 2024-09-06 | 3.99 | 3 | SO71219 | 2024-09-13 | 0.32 | 1.49 | |
SO62843_1 | 100 | 21836 | 477 | 8 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 1 | SO62843 | 2024-05-19 | 0.40 | 1.87 | |
SO62845_1 | 100 | 24563 | 529 | 8 | 2024-05-24 | 0.10 | 2024-05-12 | 3.99 | 1 | SO62845 | 2024-05-19 | 0.32 | 1.49 | |
SO62845_2 | 100 | 24563 | 480 | 8 | 2024-05-24 | 0.06 | 2024-05-12 | 2.29 | 2 | SO62845 | 2024-05-19 | 0.18 | 0.86 | |
SO62869_1 | 100 | 28376 | 382 | 8 | 2024-05-24 | 28.01 | 2024-05-12 | 1120.49 | 1 | SO62869 | 2024-05-19 | 89.64 | 713.08 | |
SO62869_2 | 100 | 28376 | 479 | 8 | 2024-05-24 | 0.22 | 2024-05-12 | 8.99 | 2 | SO62869 | 2024-05-19 | 0.72 | 3.36 | |
SO62869_3 | 100 | 28376 | 477 | 8 | 2024-05-24 | 0.12 | 2024-05-12 | 4.99 | 3 | SO62869 | 2024-05-19 | 0.40 | 1.87 | |
SO62885_1 | 100 | 24053 | 376 | 8 | 2024-05-25 | 61.08 | 2024-05-13 | 2443.35 | 1 | SO62885 | 2024-05-20 | 195.47 | 1554.95 | |
SO62887_1 | 100 | 15084 | 353 | 8 | 2024-05-25 | 58.00 | 2024-05-13 | 2319.99 | 1 | SO62887 | 2024-05-20 | 185.60 | 1265.62 | |
SO62887_2 | 100 | 15084 | 478 | 8 | 2024-05-25 | 0.25 | 2024-05-13 | 9.99 | 2 | SO62887 | 2024-05-20 | 0.80 | 3.74 | |
SO62887_3 | 100 | 15084 | 477 | 8 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 3 | SO62887 | 2024-05-20 | 0.40 | 1.87 | |
SO62887_4 | 100 | 15084 | 472 | 8 | 2024-05-25 | 1.59 | 2024-05-13 | 63.50 | 4 | SO62887 | 2024-05-20 | 5.08 | 23.75 | |
SO62906_1 | 100 | 17853 | 528 | 8 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 1 | SO62906 | 2024-05-20 | 0.40 | 1.87 | |
SO62906_2 | 100 | 17853 | 535 | 8 | 2024-05-25 | 0.62 | 2024-05-13 | 24.99 | 2 | SO62906 | 2024-05-20 | 2.00 | 9.35 | |
SO62909_1 | 100 | 21821 | 477 | 8 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 1 | SO62909 | 2024-05-20 | 0.40 | 1.87 | |
SO62909_2 | 100 | 21821 | 214 | 8 | 2024-05-25 | 0.87 | 2024-05-13 | 34.99 | 2 | SO62909 | 2024-05-20 | 2.80 | 13.09 | |
SO62909_3 | 100 | 21821 | 225 | 8 | 2024-05-25 | 0.22 | 2024-05-13 | 8.99 | 3 | SO62909 | 2024-05-20 | 0.72 | 6.92 | |
SO62913_1 | 100 | 14528 | 530 | 8 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 1 | SO62913 | 2024-05-20 | 0.40 | 1.87 | |
SO62928_1 | 100 | 16199 | 576 | 8 | 2024-05-25 | 59.60 | 2024-05-13 | 2384.07 | 1 | SO62928 | 2024-05-20 | 190.73 | 1481.94 | |
SO62928_2 | 100 | 16199 | 214 | 8 | 2024-05-25 | 0.87 | 2024-05-13 | 34.99 | 2 | SO62928 | 2024-05-20 | 2.80 | 13.09 | |
SO62944_1 | 100 | 13540 | 584 | 8 | 2024-05-25 | 13.50 | 2024-05-13 | 539.99 | 1 | SO62944 | 2024-05-20 | 43.20 | 343.65 | |
SO62944_2 | 100 | 13540 | 479 | 8 | 2024-05-25 | 0.22 | 2024-05-13 | 8.99 | 2 | SO62944 | 2024-05-20 | 0.72 | 3.36 | |
SO62945_1 | 100 | 25744 | 574 | 8 | 2024-05-25 | 59.60 | 2024-05-13 | 2384.07 | 1 | SO62945 | 2024-05-20 | 190.73 | 1481.94 | |
SO62945_2 | 100 | 25744 | 541 | 8 | 2024-05-25 | 0.72 | 2024-05-13 | 28.99 | 2 | SO62945 | 2024-05-20 | 2.32 | 10.84 | |
SO62945_3 | 100 | 25744 | 530 | 8 | 2024-05-25 | 0.12 | 2024-05-13 | 4.99 | 3 | SO62945 | 2024-05-20 | 0.40 | 1.87 | |
SO62945_4 | 100 | 25744 | 480 | 8 | 2024-05-25 | 0.06 | 2024-05-13 | 2.29 | 4 | SO62945 | 2024-05-20 | 0.18 | 0.86 | |
SO62945_5 | 100 | 25744 | 484 | 8 | 2024-05-25 | 0.20 | 2024-05-13 | 7.95 | 5 | SO62945 | 2024-05-20 | 0.64 | 2.97 | |
SO62954_1 | 100 | 28902 | 372 | 8 | 2024-05-26 | 61.08 | 2024-05-14 | 2443.35 | 1 | SO62954 | 2024-05-21 | 195.47 | 1554.95 | |
SO62954_2 | 100 | 28902 | 529 | 8 | 2024-05-26 | 0.10 | 2024-05-14 | 3.99 | 2 | SO62954 | 2024-05-21 | 0.32 | 1.49 | |
SO62954_3 | 100 | 28902 | 540 | 8 | 2024-05-26 | 0.82 | 2024-05-14 | 32.60 | 3 | SO62954 | 2024-05-21 | 2.61 | 12.19 | |
SO62954_4 | 100 | 28902 | 234 | 8 | 2024-05-26 | 1.25 | 2024-05-14 | 49.99 | 4 | SO62954 | 2024-05-21 | 4.00 | 38.49 | |
SO62973_1 | 100 | 20143 | 536 | 8 | 2024-05-26 | 0.75 | 2024-05-14 | 29.99 | 1 | SO62973 | 2024-05-21 | 2.40 | 11.22 | |
SO62973_2 | 100 | 20143 | 480 | 2 | 8 | 2024-05-26 | 0.06 | 2024-05-14 | 2.29 | 2 | SO62973 | 2024-05-21 | 0.18 | 0.86 |
SO62975_1 | 100 | 21844 | 477 | 8 | 2024-05-26 | 0.12 | 2024-05-14 | 4.99 | 1 | SO62975 | 2024-05-21 | 0.40 | 1.87 | |
SO62975_2 | 100 | 21844 | 217 | 8 | 2024-05-26 | 0.87 | 2024-05-14 | 34.99 | 2 | SO62975 | 2024-05-21 | 2.80 | 13.09 | |
SO62976_1 | 100 | 24080 | 529 | 8 | 2024-05-26 | 0.10 | 2024-05-14 | 3.99 | 1 | SO62976 | 2024-05-21 | 0.32 | 1.49 | |
SO62976_2 | 100 | 24080 | 228 | 8 | 2024-05-26 | 1.25 | 2024-05-14 | 49.99 | 2 | SO62976 | 2024-05-21 | 4.00 | 38.49 | |
SO62980_1 | 100 | 13594 | 478 | 8 | 2024-05-26 | 0.25 | 2024-05-14 | 9.99 | 1 | SO62980 | 2024-05-21 | 0.80 | 3.74 | |
SO62980_2 | 100 | 13594 | 222 | 8 | 2024-05-26 | 0.87 | 2024-05-14 | 34.99 | 2 | SO62980 | 2024-05-21 | 2.80 | 13.09 | |
SO62987_1 | 100 | 25745 | 562 | 8 | 2024-05-26 | 59.60 | 2024-05-14 | 2384.07 | 1 | SO62987 | 2024-05-21 | 190.73 | 1481.94 | |
SO62987_2 | 100 | 25745 | 541 | 8 | 2024-05-26 | 0.72 | 2024-05-14 | 28.99 | 2 | SO62987 | 2024-05-21 | 2.32 | 10.84 | |
SO62987_3 | 100 | 25745 | 530 | 8 | 2024-05-26 | 0.12 | 2024-05-14 | 4.99 | 3 | SO62987 | 2024-05-21 | 0.40 | 1.87 | |
SO62987_4 | 100 | 25745 | 487 | 8 | 2024-05-26 | 1.37 | 2024-05-14 | 54.99 | 4 | SO62987 | 2024-05-21 | 4.40 | 20.57 |
Generated 2024-11-14 05:19:50.737 UTC