[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1142 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44911_1 | 100 | 25976 | 349 | 4 | 2022-04-08 | 84.37 | 2022-03-27 | 3374.99 | 1 | SO44911 | 2022-04-03 | 270.00 | 1898.09 | |
SO44912_1 | 100 | 28966 | 310 | 4 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44912 | 2022-04-03 | 286.26 | 2171.29 | |
SO44913_1 | 6 | 18468 | 311 | 9 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44913 | 2022-04-03 | 286.26 | 2171.29 | |
SO44914_1 | 6 | 18491 | 311 | 9 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44914 | 2022-04-03 | 286.26 | 2171.29 | |
SO44915_1 | 6 | 18461 | 312 | 9 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44915 | 2022-04-03 | 286.26 | 2171.29 | |
SO44916_1 | 6 | 18463 | 311 | 9 | 2022-04-08 | 89.46 | 2022-03-27 | 3578.27 | 1 | SO44916 | 2022-04-03 | 286.26 | 2171.29 | |
SO44917_1 | 29 | 13842 | 310 | 8 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO44917 | 2022-04-04 | 286.26 | 2171.29 | |
SO44918_1 | 29 | 29466 | 350 | 8 | 2022-04-09 | 84.37 | 2022-03-28 | 3374.99 | 1 | SO44918 | 2022-04-04 | 270.00 | 1898.09 | |
SO44919_1 | 100 | 29017 | 310 | 1 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO44919 | 2022-04-04 | 286.26 | 2171.29 | |
SO44920_1 | 100 | 14648 | 338 | 4 | 2022-04-09 | 17.48 | 2022-03-28 | 699.10 | 1 | SO44920 | 2022-04-04 | 55.93 | 413.15 | |
SO44921_1 | 6 | 18489 | 312 | 9 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO44921 | 2022-04-04 | 286.26 | 2171.29 | |
SO44922_1 | 6 | 18277 | 314 | 9 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO44922 | 2022-04-04 | 286.26 | 2171.29 | |
SO44923_1 | 6 | 18336 | 312 | 9 | 2022-04-09 | 89.46 | 2022-03-28 | 3578.27 | 1 | SO44923 | 2022-04-04 | 286.26 | 2171.29 | |
SO44924_1 | 100 | 28830 | 310 | 1 | 2022-04-10 | 89.46 | 2022-03-29 | 3578.27 | 1 | SO44924 | 2022-04-05 | 286.26 | 2171.29 | |
SO44925_1 | 6 | 18493 | 313 | 9 | 2022-04-10 | 89.46 | 2022-03-29 | 3578.27 | 1 | SO44925 | 2022-04-05 | 286.26 | 2171.29 | |
SO44926_1 | 6 | 25706 | 328 | 9 | 2022-04-10 | 17.48 | 2022-03-29 | 699.10 | 1 | SO44926 | 2022-04-05 | 55.93 | 413.15 | |
SO44927_1 | 6 | 11448 | 348 | 9 | 2022-04-10 | 84.37 | 2022-03-29 | 3374.99 | 1 | SO44927 | 2022-04-05 | 270.00 | 1898.09 | |
SO44928_1 | 98 | 14843 | 314 | 10 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44928 | 2022-04-06 | 286.26 | 2171.29 | |
SO44929_1 | 39 | 12398 | 312 | 7 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44929 | 2022-04-06 | 286.26 | 2171.29 | |
SO44930_1 | 100 | 29110 | 312 | 4 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44930 | 2022-04-06 | 286.26 | 2171.29 | |
SO44931_1 | 100 | 28849 | 312 | 1 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44931 | 2022-04-06 | 286.26 | 2171.29 | |
SO44932_1 | 6 | 18303 | 312 | 9 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44932 | 2022-04-06 | 286.26 | 2171.29 | |
SO44933_1 | 6 | 18276 | 312 | 9 | 2022-04-11 | 89.46 | 2022-03-30 | 3578.27 | 1 | SO44933 | 2022-04-06 | 286.26 | 2171.29 | |
SO44934_1 | 98 | 14771 | 312 | 10 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44934 | 2022-04-07 | 286.26 | 2171.29 | |
SO44935_1 | 39 | 12333 | 312 | 7 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44935 | 2022-04-07 | 286.26 | 2171.29 | |
SO44936_1 | 100 | 29044 | 312 | 1 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44936 | 2022-04-07 | 286.26 | 2171.29 | |
SO44937_1 | 19 | 22251 | 311 | 6 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44937 | 2022-04-07 | 286.26 | 2171.29 | |
SO44938_1 | 100 | 28851 | 314 | 1 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44938 | 2022-04-07 | 286.26 | 2171.29 | |
SO44939_1 | 100 | 28993 | 314 | 1 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44939 | 2022-04-07 | 286.26 | 2171.29 | |
SO44940_1 | 6 | 18490 | 311 | 9 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44940 | 2022-04-07 | 286.26 | 2171.29 | |
SO44941_1 | 6 | 18697 | 310 | 9 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44941 | 2022-04-07 | 286.26 | 2171.29 | |
SO44942_1 | 6 | 18701 | 310 | 9 | 2022-04-12 | 89.46 | 2022-03-31 | 3578.27 | 1 | SO44942 | 2022-04-07 | 286.26 | 2171.29 | |
SO44943_1 | 6 | 25568 | 330 | 9 | 2022-04-12 | 17.48 | 2022-03-31 | 699.10 | 1 | SO44943 | 2022-04-07 | 55.93 | 413.15 | |
SO44944_1 | 6 | 25707 | 332 | 9 | 2022-04-12 | 17.48 | 2022-03-31 | 699.10 | 1 | SO44944 | 2022-04-07 | 55.93 | 413.15 | |
SO44945_1 | 6 | 25710 | 322 | 9 | 2022-04-12 | 17.48 | 2022-03-31 | 699.10 | 1 | SO44945 | 2022-04-07 | 55.93 | 413.15 | |
SO44946_1 | 6 | 11357 | 349 | 9 | 2022-04-12 | 84.37 | 2022-03-31 | 3374.99 | 1 | SO44946 | 2022-04-07 | 270.00 | 1898.09 | |
SO44947_1 | 6 | 11446 | 346 | 9 | 2022-04-12 | 85.00 | 2022-03-31 | 3399.99 | 1 | SO44947 | 2022-04-07 | 272.00 | 1912.15 | |
SO44948_1 | 39 | 12395 | 312 | 7 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO44948 | 2022-04-08 | 286.26 | 2171.29 | |
SO44949_1 | 29 | 29474 | 349 | 8 | 2022-04-13 | 84.37 | 2022-04-01 | 3374.99 | 1 | SO44949 | 2022-04-08 | 270.00 | 1898.09 | |
SO44950_1 | 100 | 28835 | 313 | 4 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO44950 | 2022-04-08 | 286.26 | 2171.29 | |
SO44951_1 | 100 | 28843 | 311 | 4 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO44951 | 2022-04-08 | 286.26 | 2171.29 | |
SO44952_1 | 100 | 25955 | 349 | 4 | 2022-04-13 | 84.37 | 2022-04-01 | 3374.99 | 1 | SO44952 | 2022-04-08 | 270.00 | 1898.09 | |
SO44953_1 | 100 | 28859 | 312 | 1 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO44953 | 2022-04-08 | 286.26 | 2171.29 | |
SO44954_1 | 100 | 28990 | 310 | 4 | 2022-04-13 | 89.46 | 2022-04-01 | 3578.27 | 1 | SO44954 | 2022-04-08 | 286.26 | 2171.29 | |
SO44955_1 | 6 | 25709 | 342 | 9 | 2022-04-13 | 17.48 | 2022-04-01 | 699.10 | 1 | SO44955 | 2022-04-08 | 55.93 | 413.15 | |
SO44956_1 | 6 | 11449 | 351 | 9 | 2022-04-13 | 84.37 | 2022-04-01 | 3374.99 | 1 | SO44956 | 2022-04-08 | 270.00 | 1898.09 | |
SO62156_2 | 6 | 11768 | 217 | 9 | 2024-05-08 | 0.87 | 2024-04-26 | 34.99 | 2 | SO62156 | 2024-05-03 | 2.80 | 13.09 | |
SO44957_1 | 19 | 22247 | 310 | 6 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO44957 | 2022-04-09 | 286.26 | 2171.29 | |
SO62157_1 | 6 | 23099 | 584 | 9 | 2024-05-08 | 13.50 | 2024-04-26 | 539.99 | 1 | SO62157 | 2024-05-03 | 43.20 | 343.65 | |
SO44958_1 | 98 | 20173 | 332 | 10 | 2022-04-14 | 17.48 | 2022-04-02 | 699.10 | 1 | SO44958 | 2022-04-09 | 55.93 | 413.15 | |
SO62158_1 | 100 | 12894 | 477 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62158 | 2024-05-04 | 0.40 | 1.87 | |
SO44959_1 | 100 | 29019 | 312 | 4 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO44959 | 2022-04-09 | 286.26 | 2171.29 | |
SO62158_2 | 100 | 12894 | 479 | 4 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 2 | SO62158 | 2024-05-04 | 0.72 | 3.36 | |
SO44960_1 | 19 | 22373 | 314 | 6 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO44960 | 2022-04-09 | 286.26 | 2171.29 | |
SO62159_1 | 19 | 11223 | 237 | 6 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 1 | SO62159 | 2024-05-04 | 4.00 | 38.49 | |
SO44961_1 | 100 | 29060 | 313 | 4 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO44961 | 2022-04-09 | 286.26 | 2171.29 | |
SO62160_1 | 6 | 14307 | 535 | 9 | 2024-05-09 | 0.62 | 2024-04-27 | 24.99 | 1 | SO62160 | 2024-05-04 | 2.00 | 9.35 | |
SO44962_1 | 100 | 28831 | 310 | 4 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO44962 | 2022-04-09 | 286.26 | 2171.29 | |
SO62160_2 | 6 | 14307 | 528 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 2 | SO62160 | 2024-05-04 | 0.40 | 1.87 | |
SO44963_1 | 100 | 25974 | 346 | 4 | 2022-04-14 | 85.00 | 2022-04-02 | 3399.99 | 1 | SO44963 | 2022-04-09 | 272.00 | 1912.15 | |
SO62160_3 | 6 | 14307 | 480 | 2 | 9 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62160 | 2024-05-04 | 0.18 | 0.86 |
SO44964_1 | 100 | 14647 | 334 | 4 | 2022-04-14 | 17.48 | 2022-04-02 | 699.10 | 1 | SO44964 | 2022-04-09 | 55.93 | 413.15 | |
SO62161_1 | 6 | 17061 | 536 | 9 | 2024-05-09 | 0.75 | 2024-04-27 | 29.99 | 1 | SO62161 | 2024-05-04 | 2.40 | 11.22 | |
SO44965_1 | 100 | 14649 | 332 | 4 | 2022-04-14 | 17.48 | 2022-04-02 | 699.10 | 1 | SO44965 | 2022-04-09 | 55.93 | 413.15 | |
SO62161_2 | 6 | 17061 | 480 | 2 | 9 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 2 | SO62161 | 2024-05-04 | 0.18 | 0.86 |
SO44966_1 | 6 | 18458 | 314 | 9 | 2022-04-14 | 89.46 | 2022-04-02 | 3578.27 | 1 | SO44966 | 2022-04-09 | 286.26 | 2171.29 | |
SO62162_1 | 6 | 22204 | 528 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62162 | 2024-05-04 | 0.40 | 1.87 | |
SO44967_1 | 98 | 14794 | 310 | 10 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44967 | 2022-04-10 | 286.26 | 2171.29 | |
SO62162_2 | 6 | 22204 | 537 | 9 | 2024-05-09 | 0.88 | 2024-04-27 | 35.00 | 2 | SO62162 | 2024-05-04 | 2.80 | 13.09 | |
SO44968_1 | 29 | 19365 | 342 | 8 | 2022-04-15 | 17.48 | 2022-04-03 | 699.10 | 1 | SO44968 | 2022-04-10 | 55.93 | 413.15 | |
SO62162_3 | 6 | 22204 | 480 | 9 | 2024-05-09 | 0.06 | 2024-04-27 | 2.29 | 3 | SO62162 | 2024-05-04 | 0.18 | 0.86 | |
SO44969_1 | 19 | 22713 | 312 | 6 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44969 | 2022-04-10 | 286.26 | 2171.29 | |
SO55611_1 | 100 | 29403 | 604 | 8 | 2024-01-27 | 13.50 | 2024-01-15 | 539.99 | 1 | SO55611 | 2024-01-22 | 43.20 | 343.65 | |
SO62163_1 | 6 | 24897 | 528 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62163 | 2024-05-04 | 0.40 | 1.87 | |
SO44970_1 | 100 | 28820 | 312 | 1 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44970 | 2022-04-10 | 286.26 | 2171.29 | |
SO55611_2 | 100 | 29403 | 479 | 8 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 2 | SO55611 | 2024-01-22 | 0.72 | 3.36 | |
SO62164_1 | 6 | 22859 | 477 | 9 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 1 | SO62164 | 2024-05-04 | 0.40 | 1.87 | |
SO44971_1 | 100 | 28989 | 313 | 1 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44971 | 2022-04-10 | 286.26 | 2171.29 | |
SO55611_3 | 100 | 29403 | 477 | 8 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55611 | 2024-01-22 | 0.40 | 1.87 | |
SO62165_1 | 6 | 28951 | 478 | 9 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 1 | SO62165 | 2024-05-04 | 0.80 | 3.74 | |
SO44972_1 | 100 | 29016 | 311 | 1 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44972 | 2022-04-10 | 286.26 | 2171.29 | |
SO55611_4 | 100 | 29403 | 488 | 8 | 2024-01-27 | 1.35 | 2024-01-15 | 53.99 | 4 | SO55611 | 2024-01-22 | 4.32 | 41.57 | |
SO62166_1 | 6 | 15240 | 478 | 9 | 2024-05-09 | 0.25 | 2024-04-27 | 9.99 | 1 | SO62166 | 2024-05-04 | 0.80 | 3.74 | |
SO44973_1 | 6 | 18482 | 314 | 9 | 2022-04-15 | 89.46 | 2022-04-03 | 3578.27 | 1 | SO44973 | 2022-04-10 | 286.26 | 2171.29 | |
SO55611_5 | 100 | 29403 | 225 | 8 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 5 | SO55611 | 2024-01-22 | 0.72 | 6.92 | |
SO62167_1 | 6 | 17283 | 225 | 9 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 1 | SO62167 | 2024-05-04 | 0.72 | 6.92 | |
SO44974_1 | 98 | 14776 | 312 | 10 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44974 | 2022-04-11 | 286.26 | 2171.29 | |
SO55612_1 | 98 | 25760 | 605 | 10 | 2024-01-27 | 13.50 | 2024-01-15 | 539.99 | 1 | SO55612 | 2024-01-22 | 43.20 | 343.65 | |
SO62167_2 | 6 | 17283 | 231 | 9 | 2024-05-09 | 1.25 | 2024-04-27 | 49.99 | 2 | SO62167 | 2024-05-04 | 4.00 | 38.49 | |
SO44975_1 | 100 | 28823 | 311 | 1 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44975 | 2022-04-11 | 286.26 | 2171.29 | |
SO55612_2 | 98 | 25760 | 538 | 10 | 2024-01-27 | 0.54 | 2024-01-15 | 21.49 | 2 | SO55612 | 2024-01-22 | 1.72 | 8.04 | |
SO62168_1 | 6 | 13954 | 465 | 9 | 2024-05-09 | 0.61 | 2024-04-27 | 24.49 | 1 | SO62168 | 2024-05-04 | 1.96 | 9.16 | |
SO44976_1 | 100 | 28824 | 311 | 1 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44976 | 2022-04-11 | 286.26 | 2171.29 | |
SO55612_3 | 98 | 25760 | 529 | 10 | 2024-01-27 | 0.10 | 2024-01-15 | 3.99 | 3 | SO55612 | 2024-01-22 | 0.32 | 1.49 | |
SO62169_1 | 6 | 18247 | 225 | 9 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 1 | SO62169 | 2024-05-04 | 0.72 | 6.92 | |
SO44977_1 | 100 | 29010 | 313 | 4 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44977 | 2022-04-11 | 286.26 | 2171.29 | |
SO55612_4 | 98 | 25760 | 480 | 10 | 2024-01-27 | 0.06 | 2024-01-15 | 2.29 | 4 | SO55612 | 2024-01-22 | 0.18 | 0.86 | |
SO62170_1 | 6 | 11150 | 225 | 9 | 2024-05-09 | 0.22 | 2024-04-27 | 8.99 | 1 | SO62170 | 2024-05-04 | 0.72 | 6.92 | |
SO44978_1 | 100 | 14652 | 322 | 4 | 2022-04-16 | 17.48 | 2022-04-04 | 699.10 | 1 | SO44978 | 2022-04-11 | 55.93 | 413.15 | |
SO55613_1 | 6 | 15577 | 539 | 9 | 2024-01-28 | 0.62 | 2024-01-16 | 24.99 | 1 | SO55613 | 2024-01-23 | 2.00 | 9.35 | |
SO62171_1 | 6 | 14123 | 540 | 9 | 2024-05-09 | 0.82 | 2024-04-27 | 32.60 | 1 | SO62171 | 2024-05-04 | 2.61 | 12.19 | |
SO44979_1 | 6 | 18469 | 310 | 9 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44979 | 2022-04-11 | 286.26 | 2171.29 | |
SO55613_2 | 6 | 15577 | 231 | 9 | 2024-01-28 | 1.25 | 2024-01-16 | 49.99 | 2 | SO55613 | 2024-01-23 | 4.00 | 38.49 | |
SO62172_1 | 100 | 17787 | 581 | 7 | 2024-05-09 | 42.52 | 2024-04-27 | 1700.99 | 1 | SO62172 | 2024-05-04 | 136.08 | 1082.51 | |
SO44980_1 | 6 | 18699 | 310 | 9 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44980 | 2022-04-11 | 286.26 | 2171.29 | |
SO55613_3 | 6 | 15577 | 225 | 9 | 2024-01-28 | 0.22 | 2024-01-16 | 8.99 | 3 | SO55613 | 2024-01-23 | 0.72 | 6.92 | |
SO62172_2 | 100 | 17787 | 539 | 7 | 2024-05-09 | 0.62 | 2024-04-27 | 24.99 | 2 | SO62172 | 2024-05-04 | 2.00 | 9.35 | |
SO44981_1 | 6 | 18462 | 310 | 9 | 2022-04-16 | 89.46 | 2022-04-04 | 3578.27 | 1 | SO44981 | 2022-04-11 | 286.26 | 2171.29 | |
SO55614_1 | 6 | 19584 | 538 | 9 | 2024-01-28 | 0.54 | 2024-01-16 | 21.49 | 1 | SO55614 | 2024-01-23 | 1.72 | 8.04 | |
SO62173_1 | 100 | 11420 | 599 | 7 | 2024-05-09 | 13.50 | 2024-04-27 | 539.99 | 1 | SO62173 | 2024-05-04 | 43.20 | 294.58 | |
SO44982_1 | 100 | 29132 | 312 | 4 | 2022-04-17 | 89.46 | 2022-04-05 | 3578.27 | 1 | SO44982 | 2022-04-12 | 286.26 | 2171.29 | |
SO55614_2 | 6 | 19584 | 529 | 9 | 2024-01-28 | 0.10 | 2024-01-16 | 3.99 | 2 | SO55614 | 2024-01-23 | 0.32 | 1.49 |
Generated 2024-11-10 21:02:23.554 UTC