[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2018 > < TAKE 96 >
96 items
| FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO49915_1 | 6 | 15143 | 354 | 9 | 2023-06-05 | 51.79 | 2023-05-24 | 2071.42 | 1 | SO49915 | 2023-05-31 | 165.71 | 1117.86 | |
| SO49916_1 | 6 | 15145 | 356 | 9 | 2023-06-05 | 51.79 | 2023-05-24 | 2071.42 | 1 | SO49916 | 2023-05-31 | 165.71 | 1117.86 | |
| SO49917_1 | 6 | 24177 | 379 | 9 | 2023-06-05 | 54.54 | 2023-05-24 | 2181.56 | 1 | SO49917 | 2023-05-31 | 174.53 | 1320.68 | |
| SO49918_1 | 6 | 25108 | 385 | 9 | 2023-06-05 | 25.01 | 2023-05-24 | 1000.44 | 1 | SO49918 | 2023-05-31 | 80.04 | 605.65 | |
| SO49922_1 | 6 | 15171 | 360 | 9 | 2023-06-06 | 51.23 | 2023-05-25 | 2049.10 | 1 | SO49922 | 2023-06-01 | 163.93 | 1105.81 | |
| SO49923_1 | 6 | 27338 | 327 | 9 | 2023-06-06 | 19.57 | 2023-05-25 | 782.99 | 1 | SO49923 | 2023-06-01 | 62.64 | 486.71 | |
| SO49933_1 | 6 | 15169 | 352 | 9 | 2023-06-07 | 51.79 | 2023-05-26 | 2071.42 | 1 | SO49933 | 2023-06-02 | 165.71 | 1117.86 | |
| SO49934_1 | 6 | 24266 | 379 | 9 | 2023-06-07 | 54.54 | 2023-05-26 | 2181.56 | 1 | SO49934 | 2023-06-02 | 174.53 | 1320.68 | |
| SO49935_1 | 6 | 26916 | 321 | 9 | 2023-06-07 | 19.57 | 2023-05-26 | 782.99 | 1 | SO49935 | 2023-06-02 | 62.64 | 486.71 | |
| SO49941_1 | 6 | 15022 | 356 | 9 | 2023-06-08 | 51.79 | 2023-05-27 | 2071.42 | 1 | SO49941 | 2023-06-03 | 165.71 | 1117.86 | |
| SO49944_1 | 6 | 15210 | 354 | 9 | 2023-06-08 | 51.79 | 2023-05-27 | 2071.42 | 1 | SO49944 | 2023-06-03 | 165.71 | 1117.86 | |
| SO49945_1 | 6 | 25119 | 389 | 9 | 2023-06-08 | 25.01 | 2023-05-27 | 1000.44 | 1 | SO49945 | 2023-06-03 | 80.04 | 605.65 | |
| SO49948_1 | 6 | 15015 | 362 | 2 | 9 | 2023-06-09 | 51.23 | 2023-05-28 | 2049.10 | 1 | SO49948 | 2023-06-04 | 163.93 | 1105.81 |
| SO49950_1 | 6 | 24163 | 371 | 9 | 2023-06-09 | 54.54 | 2023-05-28 | 2181.56 | 1 | SO49950 | 2023-06-04 | 174.53 | 1320.68 | |
| SO49953_1 | 6 | 15213 | 360 | 9 | 2023-06-10 | 51.23 | 2023-05-29 | 2049.10 | 1 | SO49953 | 2023-06-05 | 163.93 | 1105.81 | |
| SO49954_1 | 6 | 15144 | 360 | 9 | 2023-06-10 | 51.23 | 2023-05-29 | 2049.10 | 1 | SO49954 | 2023-06-05 | 163.93 | 1105.81 | |
| SO49955_1 | 6 | 15152 | 360 | 9 | 2023-06-10 | 51.23 | 2023-05-29 | 2049.10 | 1 | SO49955 | 2023-06-05 | 163.93 | 1105.81 | |
| SO49956_1 | 6 | 25112 | 387 | 9 | 2023-06-10 | 25.01 | 2023-05-29 | 1000.44 | 1 | SO49956 | 2023-06-05 | 80.04 | 605.65 | |
| SO49957_1 | 6 | 25114 | 387 | 9 | 2023-06-10 | 25.01 | 2023-05-29 | 1000.44 | 1 | SO49957 | 2023-06-05 | 80.04 | 605.65 | |
| SO49958_1 | 6 | 24167 | 368 | 9 | 2023-06-10 | 61.08 | 2023-05-29 | 2443.35 | 1 | SO49958 | 2023-06-05 | 195.47 | 1518.79 | |
| SO49959_1 | 6 | 24241 | 368 | 9 | 2023-06-10 | 61.08 | 2023-05-29 | 2443.35 | 1 | SO49959 | 2023-06-05 | 195.47 | 1518.79 | |
| SO49960_1 | 6 | 24249 | 375 | 9 | 2023-06-10 | 54.54 | 2023-05-29 | 2181.56 | 1 | SO49960 | 2023-06-05 | 174.53 | 1320.68 | |
| SO49961_1 | 6 | 26921 | 327 | 9 | 2023-06-10 | 19.57 | 2023-05-29 | 782.99 | 1 | SO49961 | 2023-06-05 | 62.64 | 486.71 | |
| SO49968_1 | 6 | 15029 | 354 | 9 | 2023-06-11 | 51.79 | 2023-05-30 | 2071.42 | 1 | SO49968 | 2023-06-06 | 165.71 | 1117.86 | |
| SO49971_1 | 6 | 15208 | 358 | 9 | 2023-06-11 | 51.23 | 2023-05-30 | 2049.10 | 1 | SO49971 | 2023-06-06 | 163.93 | 1105.81 | |
| SO49972_1 | 6 | 15211 | 356 | 9 | 2023-06-11 | 51.79 | 2023-05-30 | 2071.42 | 1 | SO49972 | 2023-06-06 | 165.71 | 1117.86 | |
| SO49973_1 | 6 | 24173 | 379 | 9 | 2023-06-11 | 54.54 | 2023-05-30 | 2181.56 | 1 | SO49973 | 2023-06-06 | 174.53 | 1320.68 | |
| SO49974_1 | 6 | 24248 | 371 | 9 | 2023-06-11 | 54.54 | 2023-05-30 | 2181.56 | 1 | SO49974 | 2023-06-06 | 174.53 | 1320.68 | |
| SO49980_1 | 6 | 15027 | 358 | 9 | 2023-06-12 | 51.23 | 2023-05-31 | 2049.10 | 1 | SO49980 | 2023-06-07 | 163.93 | 1105.81 | |
| SO49981_1 | 6 | 15032 | 362 | 2 | 9 | 2023-06-12 | 51.23 | 2023-05-31 | 2049.10 | 1 | SO49981 | 2023-06-07 | 163.93 | 1105.81 |
| SO49983_1 | 6 | 15179 | 356 | 9 | 2023-06-12 | 51.79 | 2023-05-31 | 2071.42 | 1 | SO49983 | 2023-06-07 | 165.71 | 1117.86 | |
| SO49984_1 | 6 | 25115 | 383 | 9 | 2023-06-12 | 25.01 | 2023-05-31 | 1000.44 | 1 | SO49984 | 2023-06-07 | 80.04 | 605.65 | |
| SO49987_1 | 6 | 15204 | 362 | 2 | 9 | 2023-06-13 | 51.23 | 2023-06-01 | 2049.10 | 1 | SO49987 | 2023-06-08 | 163.93 | 1105.81 |
| SO49988_1 | 6 | 15120 | 362 | 2 | 9 | 2023-06-13 | 51.23 | 2023-06-01 | 2049.10 | 1 | SO49988 | 2023-06-08 | 163.93 | 1105.81 |
| SO49989_1 | 6 | 15130 | 358 | 9 | 2023-06-13 | 51.23 | 2023-06-01 | 2049.10 | 1 | SO49989 | 2023-06-08 | 163.93 | 1105.81 | |
| SO49990_1 | 6 | 15180 | 356 | 9 | 2023-06-13 | 51.79 | 2023-06-01 | 2071.42 | 1 | SO49990 | 2023-06-08 | 165.71 | 1117.86 | |
| SO50001_1 | 6 | 15183 | 352 | 9 | 2023-06-14 | 51.79 | 2023-06-02 | 2071.42 | 1 | SO50001 | 2023-06-09 | 165.71 | 1117.86 | |
| SO50002_1 | 6 | 24170 | 368 | 9 | 2023-06-14 | 61.08 | 2023-06-02 | 2443.35 | 1 | SO50002 | 2023-06-09 | 195.47 | 1518.79 | |
| SO50003_1 | 6 | 26796 | 337 | 9 | 2023-06-14 | 19.57 | 2023-06-02 | 782.99 | 1 | SO50003 | 2023-06-09 | 62.64 | 486.71 | |
| SO50007_1 | 6 | 15181 | 354 | 9 | 2023-06-15 | 51.79 | 2023-06-03 | 2071.42 | 1 | SO50007 | 2023-06-10 | 165.71 | 1117.86 | |
| SO50008_1 | 6 | 15122 | 356 | 9 | 2023-06-15 | 51.79 | 2023-06-03 | 2071.42 | 1 | SO50008 | 2023-06-10 | 165.71 | 1117.86 | |
| SO50009_1 | 6 | 25111 | 389 | 9 | 2023-06-15 | 25.01 | 2023-06-03 | 1000.44 | 1 | SO50009 | 2023-06-10 | 80.04 | 605.65 | |
| SO50010_1 | 6 | 24171 | 369 | 2 | 9 | 2023-06-15 | 61.08 | 2023-06-03 | 2443.35 | 1 | SO50010 | 2023-06-10 | 195.47 | 1518.79 |
| SO50026_1 | 6 | 15205 | 356 | 9 | 2023-06-16 | 51.79 | 2023-06-04 | 2071.42 | 1 | SO50026 | 2023-06-11 | 165.71 | 1117.86 | |
| SO50027_1 | 6 | 24272 | 371 | 9 | 2023-06-16 | 54.54 | 2023-06-04 | 2181.56 | 1 | SO50027 | 2023-06-11 | 174.53 | 1320.68 | |
| SO50028_1 | 6 | 24273 | 379 | 9 | 2023-06-16 | 54.54 | 2023-06-04 | 2181.56 | 1 | SO50028 | 2023-06-11 | 174.53 | 1320.68 | |
| SO50034_1 | 6 | 15129 | 354 | 9 | 2023-06-17 | 51.79 | 2023-06-05 | 2071.42 | 1 | SO50034 | 2023-06-12 | 165.71 | 1117.86 | |
| SO50035_1 | 6 | 24270 | 373 | 9 | 2023-06-17 | 54.54 | 2023-06-05 | 2181.56 | 1 | SO50035 | 2023-06-12 | 174.53 | 1320.68 | |
| SO50040_1 | 6 | 15043 | 354 | 9 | 2023-06-18 | 51.79 | 2023-06-06 | 2071.42 | 1 | SO50040 | 2023-06-13 | 165.71 | 1117.86 | |
| SO50044_1 | 6 | 24162 | 368 | 9 | 2023-06-18 | 61.08 | 2023-06-06 | 2443.35 | 1 | SO50044 | 2023-06-13 | 195.47 | 1518.79 | |
| SO50045_1 | 6 | 26924 | 327 | 9 | 2023-06-18 | 19.57 | 2023-06-06 | 782.99 | 1 | SO50045 | 2023-06-13 | 62.64 | 486.71 | |
| SO50050_1 | 6 | 15035 | 356 | 9 | 2023-06-19 | 51.79 | 2023-06-07 | 2071.42 | 1 | SO50050 | 2023-06-14 | 165.71 | 1117.86 | |
| SO50051_1 | 6 | 15127 | 356 | 9 | 2023-06-19 | 51.79 | 2023-06-07 | 2071.42 | 1 | SO50051 | 2023-06-14 | 165.71 | 1117.86 | |
| SO50060_1 | 6 | 15151 | 362 | 2 | 9 | 2023-06-20 | 51.23 | 2023-06-08 | 2049.10 | 1 | SO50060 | 2023-06-15 | 163.93 | 1105.81 |
| SO50061_1 | 6 | 24166 | 377 | 9 | 2023-06-20 | 54.54 | 2023-06-08 | 2181.56 | 1 | SO50061 | 2023-06-15 | 174.53 | 1320.68 | |
| SO50062_1 | 6 | 24172 | 373 | 9 | 2023-06-20 | 54.54 | 2023-06-08 | 2181.56 | 1 | SO50062 | 2023-06-15 | 174.53 | 1320.68 | |
| SO50063_1 | 6 | 24175 | 371 | 9 | 2023-06-20 | 54.54 | 2023-06-08 | 2181.56 | 1 | SO50063 | 2023-06-15 | 174.53 | 1320.68 | |
| SO50064_1 | 6 | 24271 | 377 | 9 | 2023-06-20 | 54.54 | 2023-06-08 | 2181.56 | 1 | SO50064 | 2023-06-15 | 174.53 | 1320.68 | |
| SO50065_1 | 6 | 15044 | 358 | 9 | 2023-06-20 | 51.23 | 2023-06-08 | 2049.10 | 1 | SO50065 | 2023-06-15 | 163.93 | 1105.81 | |
| SO50066_1 | 6 | 24242 | 377 | 9 | 2023-06-20 | 54.54 | 2023-06-08 | 2181.56 | 1 | SO50066 | 2023-06-15 | 174.53 | 1320.68 | |
| SO50067_1 | 6 | 26923 | 341 | 9 | 2023-06-20 | 19.57 | 2023-06-08 | 782.99 | 1 | SO50067 | 2023-06-15 | 62.64 | 486.71 | |
| SO50068_1 | 6 | 26797 | 339 | 9 | 2023-06-20 | 19.57 | 2023-06-08 | 782.99 | 1 | SO50068 | 2023-06-15 | 62.64 | 486.71 | |
| SO50072_1 | 6 | 15036 | 362 | 2 | 9 | 2023-06-21 | 51.23 | 2023-06-09 | 2049.10 | 1 | SO50072 | 2023-06-16 | 163.93 | 1105.81 |
| SO50075_1 | 6 | 15170 | 356 | 9 | 2023-06-21 | 51.79 | 2023-06-09 | 2071.42 | 1 | SO50075 | 2023-06-16 | 165.71 | 1117.86 | |
| SO50076_1 | 6 | 24169 | 379 | 9 | 2023-06-21 | 54.54 | 2023-06-09 | 2181.56 | 1 | SO50076 | 2023-06-16 | 174.53 | 1320.68 | |
| SO50077_1 | 6 | 24244 | 368 | 9 | 2023-06-21 | 61.08 | 2023-06-09 | 2443.35 | 1 | SO50077 | 2023-06-16 | 195.47 | 1518.79 | |
| SO50078_1 | 6 | 24251 | 370 | 9 | 2023-06-21 | 61.08 | 2023-06-09 | 2443.35 | 1 | SO50078 | 2023-06-16 | 195.47 | 1518.79 | |
| SO50079_1 | 6 | 24252 | 379 | 9 | 2023-06-21 | 54.54 | 2023-06-09 | 2181.56 | 1 | SO50079 | 2023-06-16 | 174.53 | 1320.68 | |
| SO50085_1 | 6 | 24164 | 373 | 9 | 2023-06-22 | 54.54 | 2023-06-10 | 2181.56 | 1 | SO50085 | 2023-06-17 | 174.53 | 1320.68 | |
| SO50086_1 | 6 | 24174 | 368 | 9 | 2023-06-22 | 61.08 | 2023-06-10 | 2443.35 | 1 | SO50086 | 2023-06-17 | 195.47 | 1518.79 | |
| SO50094_1 | 6 | 15184 | 352 | 9 | 2023-06-23 | 51.79 | 2023-06-11 | 2071.42 | 1 | SO50094 | 2023-06-18 | 165.71 | 1117.86 | |
| SO50095_1 | 6 | 15178 | 362 | 2 | 9 | 2023-06-23 | 51.23 | 2023-06-11 | 2049.10 | 1 | SO50095 | 2023-06-18 | 163.93 | 1105.81 |
| SO50105_1 | 6 | 25113 | 389 | 9 | 2023-06-25 | 25.01 | 2023-06-13 | 1000.44 | 1 | SO50105 | 2023-06-20 | 80.04 | 605.65 | |
| SO50106_1 | 6 | 27299 | 343 | 9 | 2023-06-25 | 19.57 | 2023-06-13 | 782.99 | 1 | SO50106 | 2023-06-20 | 62.64 | 486.71 | |
| SO50111_1 | 6 | 24250 | 377 | 9 | 2023-06-26 | 54.54 | 2023-06-14 | 2181.56 | 1 | SO50111 | 2023-06-21 | 174.53 | 1320.68 | |
| SO50112_1 | 6 | 26917 | 329 | 9 | 2023-06-26 | 19.57 | 2023-06-14 | 782.99 | 1 | SO50112 | 2023-06-21 | 62.64 | 486.71 | |
| SO50120_1 | 6 | 15040 | 352 | 9 | 2023-06-27 | 51.79 | 2023-06-15 | 2071.42 | 1 | SO50120 | 2023-06-22 | 165.71 | 1117.86 | |
| SO50121_1 | 6 | 15042 | 354 | 9 | 2023-06-27 | 51.79 | 2023-06-15 | 2071.42 | 1 | SO50121 | 2023-06-22 | 165.71 | 1117.86 | |
| SO50125_1 | 6 | 15209 | 358 | 9 | 2023-06-27 | 51.23 | 2023-06-15 | 2049.10 | 1 | SO50125 | 2023-06-22 | 163.93 | 1105.81 | |
| SO50126_1 | 6 | 15135 | 356 | 9 | 2023-06-27 | 51.79 | 2023-06-15 | 2071.42 | 1 | SO50126 | 2023-06-22 | 165.71 | 1117.86 | |
| SO50127_1 | 6 | 24176 | 370 | 9 | 2023-06-27 | 61.08 | 2023-06-15 | 2443.35 | 1 | SO50127 | 2023-06-22 | 195.47 | 1518.79 | |
| SO50134_1 | 6 | 15028 | 354 | 9 | 2023-06-28 | 51.79 | 2023-06-16 | 2071.42 | 1 | SO50134 | 2023-06-23 | 165.71 | 1117.86 | |
| SO50135_1 | 6 | 15037 | 354 | 9 | 2023-06-28 | 51.79 | 2023-06-16 | 2071.42 | 1 | SO50135 | 2023-06-23 | 165.71 | 1117.86 | |
| SO50139_1 | 6 | 15182 | 352 | 9 | 2023-06-28 | 51.79 | 2023-06-16 | 2071.42 | 1 | SO50139 | 2023-06-23 | 165.71 | 1117.86 | |
| SO50140_1 | 6 | 24161 | 368 | 9 | 2023-06-28 | 61.08 | 2023-06-16 | 2443.35 | 1 | SO50140 | 2023-06-23 | 195.47 | 1518.79 | |
| SO50141_1 | 6 | 24179 | 369 | 2 | 9 | 2023-06-28 | 61.08 | 2023-06-16 | 2443.35 | 1 | SO50141 | 2023-06-23 | 195.47 | 1518.79 |
| SO50142_1 | 6 | 26920 | 323 | 9 | 2023-06-28 | 19.57 | 2023-06-16 | 782.99 | 1 | SO50142 | 2023-06-23 | 62.64 | 486.71 | |
| SO50149_1 | 6 | 15134 | 354 | 9 | 2023-06-29 | 51.79 | 2023-06-17 | 2071.42 | 1 | SO50149 | 2023-06-24 | 165.71 | 1117.86 | |
| SO50150_1 | 6 | 26919 | 339 | 9 | 2023-06-29 | 19.57 | 2023-06-17 | 782.99 | 1 | SO50150 | 2023-06-24 | 62.64 | 486.71 | |
| SO50151_1 | 6 | 26967 | 335 | 9 | 2023-06-29 | 19.57 | 2023-06-17 | 782.99 | 1 | SO50151 | 2023-06-24 | 62.64 | 486.71 | |
| SO50155_1 | 6 | 15030 | 356 | 9 | 2023-06-30 | 51.79 | 2023-06-18 | 2071.42 | 1 | SO50155 | 2023-06-25 | 165.71 | 1117.86 | |
| SO50156_1 | 6 | 15038 | 358 | 9 | 2023-06-30 | 51.23 | 2023-06-18 | 2049.10 | 1 | SO50156 | 2023-06-25 | 163.93 | 1105.81 | |
| SO50157_1 | 6 | 15121 | 356 | 9 | 2023-06-30 | 51.79 | 2023-06-18 | 2071.42 | 1 | SO50157 | 2023-06-25 | 165.71 | 1117.86 | |
| SO50158_1 | 6 | 15133 | 352 | 9 | 2023-06-30 | 51.79 | 2023-06-18 | 2071.42 | 1 | SO50158 | 2023-06-25 | 165.71 | 1117.86 | |
| SO50159_1 | 6 | 24165 | 370 | 9 | 2023-06-30 | 61.08 | 2023-06-18 | 2443.35 | 1 | SO50159 | 2023-06-25 | 195.47 | 1518.79 | |
| SO50161_1 | 6 | 24247 | 377 | 9 | 2023-06-30 | 54.54 | 2023-06-18 | 2181.56 | 1 | SO50161 | 2023-06-25 | 174.53 | 1320.68 |
Generated 2024-09-21 06:45:23.868 UTC