[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2687 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO63935_1 | 6 | 24161 | 604 | 9 | 2024-06-03 | 13.50 | 2024-05-22 | 539.99 | 1 | SO63935 | 2024-05-29 | 43.20 | 343.65 | |
SO45752_1 | 6 | 19772 | 314 | 9 | 2022-07-18 | 89.46 | 2022-07-06 | 3578.27 | 1 | SO45752 | 2022-07-13 | 286.26 | 2171.29 | |
SO45753_1 | 6 | 19966 | 311 | 9 | 2022-07-18 | 89.46 | 2022-07-06 | 3578.27 | 1 | SO45753 | 2022-07-13 | 286.26 | 2171.29 | |
SO45763_1 | 6 | 19959 | 314 | 9 | 2022-07-20 | 89.46 | 2022-07-08 | 3578.27 | 1 | SO45763 | 2022-07-15 | 286.26 | 2171.29 | |
SO45764_1 | 6 | 19652 | 310 | 9 | 2022-07-20 | 89.46 | 2022-07-08 | 3578.27 | 1 | SO45764 | 2022-07-15 | 286.26 | 2171.29 | |
SO45770_1 | 6 | 19956 | 311 | 9 | 2022-07-21 | 89.46 | 2022-07-09 | 3578.27 | 1 | SO45770 | 2022-07-16 | 286.26 | 2171.29 | |
SO45772_1 | 6 | 19785 | 313 | 9 | 2022-07-22 | 89.46 | 2022-07-10 | 3578.27 | 1 | SO45772 | 2022-07-17 | 286.26 | 2171.29 | |
SO45773_1 | 6 | 19949 | 311 | 9 | 2022-07-22 | 89.46 | 2022-07-10 | 3578.27 | 1 | SO45773 | 2022-07-17 | 286.26 | 2171.29 | |
SO45777_1 | 6 | 11907 | 346 | 9 | 2022-07-23 | 85.00 | 2022-07-11 | 3399.99 | 1 | SO45777 | 2022-07-18 | 272.00 | 1912.15 | |
SO45819_1 | 6 | 20160 | 312 | 9 | 2022-07-24 | 89.46 | 2022-07-12 | 3578.27 | 1 | SO45819 | 2022-07-19 | 286.26 | 2171.29 | |
SO45820_1 | 6 | 25832 | 340 | 9 | 2022-07-24 | 17.48 | 2022-07-12 | 699.10 | 1 | SO45820 | 2022-07-19 | 55.93 | 413.15 | |
SO45822_1 | 6 | 20246 | 312 | 9 | 2022-07-25 | 89.46 | 2022-07-13 | 3578.27 | 1 | SO45822 | 2022-07-20 | 286.26 | 2171.29 | |
SO45823_1 | 6 | 20253 | 311 | 9 | 2022-07-25 | 89.46 | 2022-07-13 | 3578.27 | 1 | SO45823 | 2022-07-20 | 286.26 | 2171.29 | |
SO45829_1 | 6 | 20245 | 310 | 9 | 2022-07-26 | 89.46 | 2022-07-14 | 3578.27 | 1 | SO45829 | 2022-07-21 | 286.26 | 2171.29 | |
SO45830_1 | 6 | 20151 | 314 | 9 | 2022-07-26 | 89.46 | 2022-07-14 | 3578.27 | 1 | SO45830 | 2022-07-21 | 286.26 | 2171.29 | |
SO45831_1 | 6 | 20158 | 313 | 9 | 2022-07-26 | 89.46 | 2022-07-14 | 3578.27 | 1 | SO45831 | 2022-07-21 | 286.26 | 2171.29 | |
SO45832_1 | 6 | 11916 | 351 | 9 | 2022-07-26 | 84.37 | 2022-07-14 | 3374.99 | 1 | SO45832 | 2022-07-21 | 270.00 | 1898.09 | |
SO45838_1 | 6 | 20213 | 311 | 9 | 2022-07-27 | 89.46 | 2022-07-15 | 3578.27 | 1 | SO45838 | 2022-07-22 | 286.26 | 2171.29 | |
SO45839_1 | 6 | 11915 | 349 | 9 | 2022-07-27 | 84.37 | 2022-07-15 | 3374.99 | 1 | SO45839 | 2022-07-22 | 270.00 | 1898.09 | |
SO45849_1 | 6 | 20154 | 312 | 9 | 2022-07-29 | 89.46 | 2022-07-17 | 3578.27 | 1 | SO45849 | 2022-07-24 | 286.26 | 2171.29 | |
SO45856_1 | 6 | 20247 | 311 | 9 | 2022-07-30 | 89.46 | 2022-07-18 | 3578.27 | 1 | SO45856 | 2022-07-25 | 286.26 | 2171.29 | |
SO45857_1 | 6 | 11919 | 351 | 9 | 2022-07-30 | 84.37 | 2022-07-18 | 3374.99 | 1 | SO45857 | 2022-07-25 | 270.00 | 1898.09 | |
SO45858_1 | 6 | 11952 | 350 | 9 | 2022-07-30 | 84.37 | 2022-07-18 | 3374.99 | 1 | SO45858 | 2022-07-25 | 270.00 | 1898.09 | |
SO45864_1 | 6 | 19968 | 311 | 9 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO45864 | 2022-07-27 | 286.26 | 2171.29 | |
SO45865_1 | 6 | 20157 | 312 | 9 | 2022-08-01 | 89.46 | 2022-07-20 | 3578.27 | 1 | SO45865 | 2022-07-27 | 286.26 | 2171.29 | |
SO45871_1 | 6 | 25919 | 326 | 9 | 2022-08-02 | 17.48 | 2022-07-21 | 699.10 | 1 | SO45871 | 2022-07-28 | 55.93 | 413.15 | |
SO45875_1 | 6 | 20242 | 310 | 9 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO45875 | 2022-07-29 | 286.26 | 2171.29 | |
SO45876_1 | 6 | 19975 | 314 | 9 | 2022-08-03 | 89.46 | 2022-07-22 | 3578.27 | 1 | SO45876 | 2022-07-29 | 286.26 | 2171.29 | |
SO45877_1 | 6 | 11910 | 351 | 9 | 2022-08-03 | 84.37 | 2022-07-22 | 3374.99 | 1 | SO45877 | 2022-07-29 | 270.00 | 1898.09 | |
SO45888_1 | 6 | 20217 | 310 | 9 | 2022-08-04 | 89.46 | 2022-07-23 | 3578.27 | 1 | SO45888 | 2022-07-30 | 286.26 | 2171.29 | |
SO45889_1 | 6 | 11920 | 350 | 9 | 2022-08-04 | 84.37 | 2022-07-23 | 3374.99 | 1 | SO45889 | 2022-07-30 | 270.00 | 1898.09 | |
SO45892_1 | 6 | 20226 | 312 | 9 | 2022-08-05 | 89.46 | 2022-07-24 | 3578.27 | 1 | SO45892 | 2022-07-31 | 286.26 | 2171.29 | |
SO45904_1 | 6 | 20241 | 311 | 9 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO45904 | 2022-08-02 | 286.26 | 2171.29 | |
SO45905_1 | 6 | 20152 | 311 | 9 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO45905 | 2022-08-02 | 286.26 | 2171.29 | |
SO45906_1 | 6 | 20159 | 312 | 9 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO45906 | 2022-08-02 | 286.26 | 2171.29 | |
SO45907_1 | 6 | 20214 | 310 | 9 | 2022-08-07 | 89.46 | 2022-07-26 | 3578.27 | 1 | SO45907 | 2022-08-02 | 286.26 | 2171.29 | |
SO45908_1 | 6 | 11918 | 347 | 9 | 2022-08-07 | 85.00 | 2022-07-26 | 3399.99 | 1 | SO45908 | 2022-08-02 | 272.00 | 1912.15 | |
SO45909_1 | 6 | 11947 | 349 | 9 | 2022-08-07 | 84.37 | 2022-07-26 | 3374.99 | 1 | SO45909 | 2022-08-02 | 270.00 | 1898.09 | |
SO45914_1 | 6 | 11929 | 349 | 9 | 2022-08-08 | 84.37 | 2022-07-27 | 3374.99 | 1 | SO45914 | 2022-08-03 | 270.00 | 1898.09 | |
SO45915_1 | 6 | 11930 | 347 | 9 | 2022-08-08 | 85.00 | 2022-07-27 | 3399.99 | 1 | SO45915 | 2022-08-03 | 272.00 | 1912.15 | |
SO45916_1 | 6 | 11964 | 346 | 9 | 2022-08-08 | 85.00 | 2022-07-27 | 3399.99 | 1 | SO45916 | 2022-08-03 | 272.00 | 1912.15 | |
SO45925_1 | 6 | 11942 | 347 | 9 | 2022-08-09 | 85.00 | 2022-07-28 | 3399.99 | 1 | SO45925 | 2022-08-04 | 272.00 | 1912.15 | |
SO45931_1 | 6 | 20249 | 310 | 9 | 2022-08-10 | 89.46 | 2022-07-29 | 3578.27 | 1 | SO45931 | 2022-08-05 | 286.26 | 2171.29 | |
SO45932_1 | 6 | 20211 | 310 | 9 | 2022-08-10 | 89.46 | 2022-07-29 | 3578.27 | 1 | SO45932 | 2022-08-05 | 286.26 | 2171.29 | |
SO45940_1 | 6 | 20244 | 313 | 9 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO45940 | 2022-08-07 | 286.26 | 2171.29 | |
SO45941_1 | 6 | 19978 | 310 | 9 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO45941 | 2022-08-07 | 286.26 | 2171.29 | |
SO45942_1 | 6 | 20219 | 312 | 9 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO45942 | 2022-08-07 | 286.26 | 2171.29 | |
SO45943_1 | 6 | 20221 | 310 | 9 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO45943 | 2022-08-07 | 286.26 | 2171.29 | |
SO45944_1 | 6 | 20225 | 312 | 9 | 2022-08-12 | 89.46 | 2022-07-31 | 3578.27 | 1 | SO45944 | 2022-08-07 | 286.26 | 2171.29 | |
SO45945_1 | 6 | 25920 | 324 | 9 | 2022-08-12 | 17.48 | 2022-07-31 | 699.10 | 1 | SO45945 | 2022-08-07 | 55.93 | 413.15 | |
SO45946_1 | 6 | 11914 | 350 | 9 | 2022-08-12 | 84.37 | 2022-07-31 | 3374.99 | 1 | SO45946 | 2022-08-07 | 270.00 | 1898.09 | |
SO45947_1 | 6 | 11943 | 351 | 9 | 2022-08-12 | 84.37 | 2022-07-31 | 3374.99 | 1 | SO45947 | 2022-08-07 | 270.00 | 1898.09 | |
SO45949_1 | 6 | 19970 | 310 | 9 | 2022-08-13 | 89.46 | 2022-08-01 | 3578.27 | 1 | SO45949 | 2022-08-08 | 286.26 | 2171.29 | |
SO45950_1 | 6 | 19974 | 312 | 9 | 2022-08-13 | 89.46 | 2022-08-01 | 3578.27 | 1 | SO45950 | 2022-08-08 | 286.26 | 2171.29 | |
SO45951_1 | 6 | 11944 | 348 | 9 | 2022-08-13 | 84.37 | 2022-08-01 | 3374.99 | 1 | SO45951 | 2022-08-08 | 270.00 | 1898.09 | |
SO45952_1 | 6 | 11969 | 347 | 9 | 2022-08-13 | 85.00 | 2022-08-01 | 3399.99 | 1 | SO45952 | 2022-08-08 | 272.00 | 1912.15 | |
SO45956_1 | 6 | 19979 | 312 | 9 | 2022-08-14 | 89.46 | 2022-08-02 | 3578.27 | 1 | SO45956 | 2022-08-09 | 286.26 | 2171.29 | |
SO45962_1 | 6 | 20227 | 310 | 9 | 2022-08-15 | 89.46 | 2022-08-03 | 3578.27 | 1 | SO45962 | 2022-08-10 | 286.26 | 2171.29 | |
SO45963_1 | 6 | 20238 | 310 | 9 | 2022-08-15 | 89.46 | 2022-08-03 | 3578.27 | 1 | SO45963 | 2022-08-10 | 286.26 | 2171.29 | |
SO45964_1 | 6 | 20215 | 310 | 9 | 2022-08-15 | 89.46 | 2022-08-03 | 3578.27 | 1 | SO45964 | 2022-08-10 | 286.26 | 2171.29 | |
SO45965_1 | 6 | 25921 | 320 | 9 | 2022-08-15 | 17.48 | 2022-08-03 | 699.10 | 1 | SO45965 | 2022-08-10 | 55.93 | 413.15 | |
SO45966_1 | 6 | 11946 | 345 | 9 | 2022-08-15 | 85.00 | 2022-08-03 | 3399.99 | 1 | SO45966 | 2022-08-10 | 272.00 | 1912.15 | |
SO45969_1 | 6 | 20156 | 310 | 9 | 2022-08-16 | 89.46 | 2022-08-04 | 3578.27 | 1 | SO45969 | 2022-08-11 | 286.26 | 2171.29 | |
SO45970_1 | 6 | 11963 | 348 | 9 | 2022-08-16 | 84.37 | 2022-08-04 | 3374.99 | 1 | SO45970 | 2022-08-11 | 270.00 | 1898.09 | |
SO45976_1 | 6 | 20239 | 314 | 9 | 2022-08-17 | 89.46 | 2022-08-05 | 3578.27 | 1 | SO45976 | 2022-08-12 | 286.26 | 2171.29 | |
SO63936_1 | 6 | 21166 | 374 | 9 | 2024-06-03 | 61.08 | 2024-05-22 | 2443.35 | 1 | SO63936 | 2024-05-29 | 195.47 | 1554.95 | |
SO63936_2 | 6 | 21166 | 477 | 9 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 2 | SO63936 | 2024-05-29 | 0.40 | 1.87 | |
SO63936_3 | 6 | 21166 | 479 | 9 | 2024-06-03 | 0.22 | 2024-05-22 | 8.99 | 3 | SO63936 | 2024-05-29 | 0.72 | 3.36 | |
SO63936_4 | 6 | 21166 | 225 | 9 | 2024-06-03 | 0.22 | 2024-05-22 | 8.99 | 4 | SO63936 | 2024-05-29 | 0.72 | 6.92 | |
SO63937_1 | 6 | 14225 | 363 | 9 | 2024-06-03 | 57.37 | 2024-05-22 | 2294.99 | 1 | SO63937 | 2024-05-29 | 183.60 | 1251.98 | |
SO63937_2 | 6 | 14225 | 478 | 9 | 2024-06-03 | 0.25 | 2024-05-22 | 9.99 | 2 | SO63937 | 2024-05-29 | 0.80 | 3.74 | |
SO63944_1 | 6 | 11964 | 573 | 9 | 2024-06-03 | 59.60 | 2024-05-22 | 2384.07 | 1 | SO63944 | 2024-05-29 | 190.73 | 1481.94 | |
SO63944_2 | 6 | 11964 | 214 | 9 | 2024-06-03 | 0.87 | 2024-05-22 | 34.99 | 2 | SO63944 | 2024-05-29 | 2.80 | 13.09 | |
SO63944_3 | 6 | 11964 | 465 | 9 | 2024-06-03 | 0.61 | 2024-05-22 | 24.49 | 3 | SO63944 | 2024-05-29 | 1.96 | 9.16 | |
SO63945_1 | 6 | 14066 | 571 | 9 | 2024-06-03 | 18.56 | 2024-05-22 | 742.35 | 1 | SO63945 | 2024-05-29 | 59.39 | 461.44 | |
SO63945_2 | 6 | 14066 | 479 | 9 | 2024-06-03 | 0.22 | 2024-05-22 | 8.99 | 2 | SO63945 | 2024-05-29 | 0.72 | 3.36 | |
SO63945_3 | 6 | 14066 | 477 | 9 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 3 | SO63945 | 2024-05-29 | 0.40 | 1.87 | |
SO63945_4 | 6 | 14066 | 480 | 9 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 4 | SO63945 | 2024-05-29 | 0.18 | 0.86 | |
SO63946_1 | 6 | 17240 | 588 | 9 | 2024-06-03 | 19.24 | 2024-05-22 | 769.49 | 1 | SO63946 | 2024-05-29 | 61.56 | 419.78 | |
SO63946_2 | 6 | 17240 | 536 | 9 | 2024-06-03 | 0.75 | 2024-05-22 | 29.99 | 2 | SO63946 | 2024-05-29 | 2.40 | 11.22 | |
SO63946_3 | 6 | 17240 | 528 | 9 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 3 | SO63946 | 2024-05-29 | 0.40 | 1.87 | |
SO63946_4 | 6 | 17240 | 480 | 9 | 2024-06-03 | 0.06 | 2024-05-22 | 2.29 | 4 | SO63946 | 2024-05-29 | 0.18 | 0.86 | |
SO63947_1 | 6 | 21248 | 536 | 9 | 2024-06-04 | 0.75 | 2024-05-23 | 29.99 | 1 | SO63947 | 2024-05-30 | 2.40 | 11.22 | |
SO63947_2 | 6 | 21248 | 528 | 9 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63947 | 2024-05-30 | 0.40 | 1.87 | |
SO63948_1 | 6 | 16705 | 536 | 9 | 2024-06-04 | 0.75 | 2024-05-23 | 29.99 | 1 | SO63948 | 2024-05-30 | 2.40 | 11.22 | |
SO63948_2 | 6 | 16705 | 528 | 9 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63948 | 2024-05-30 | 0.40 | 1.87 | |
SO63949_1 | 6 | 27145 | 537 | 9 | 2024-06-04 | 0.88 | 2024-05-23 | 35.00 | 1 | SO63949 | 2024-05-30 | 2.80 | 13.09 | |
SO63950_1 | 6 | 27592 | 530 | 9 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 1 | SO63950 | 2024-05-30 | 0.40 | 1.87 | |
SO63951_1 | 6 | 26136 | 528 | 9 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 1 | SO63951 | 2024-05-30 | 0.40 | 1.87 | |
SO63951_2 | 6 | 26136 | 214 | 9 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 2 | SO63951 | 2024-05-30 | 2.80 | 13.09 | |
SO63952_1 | 6 | 17076 | 237 | 9 | 2024-06-04 | 1.25 | 2024-05-23 | 49.99 | 1 | SO63952 | 2024-05-30 | 4.00 | 38.49 | |
SO63952_2 | 6 | 17076 | 465 | 9 | 2024-06-04 | 0.61 | 2024-05-23 | 24.49 | 2 | SO63952 | 2024-05-30 | 1.96 | 9.16 | |
SO63953_1 | 6 | 19085 | 480 | 9 | 2024-06-04 | 0.06 | 2024-05-23 | 2.29 | 1 | SO63953 | 2024-05-30 | 0.18 | 0.86 | |
SO63954_1 | 6 | 14685 | 487 | 9 | 2024-06-04 | 1.37 | 2024-05-23 | 54.99 | 1 | SO63954 | 2024-05-30 | 4.40 | 20.57 | |
SO63982_1 | 6 | 24009 | 606 | 2 | 9 | 2024-06-04 | 13.50 | 2024-05-23 | 539.99 | 1 | SO63982 | 2024-05-30 | 43.20 | 343.65 |
SO63982_2 | 6 | 24009 | 463 | 9 | 2024-06-04 | 0.61 | 2024-05-23 | 24.49 | 2 | SO63982 | 2024-05-30 | 1.96 | 9.16 |
Generated 2024-11-10 17:07:27.671 UTC