[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2344 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO70227_3 | 6 | 15756 | 528 | 9 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 3 | SO70227 | 2024-08-29 | 0.40 | 1.87 | |
SO47084_1 | 6 | 21561 | 370 | 9 | 2022-11-27 | 61.08 | 2022-11-15 | 2443.35 | 1 | SO47084 | 2022-11-22 | 195.47 | 1518.79 | |
SO70227_4 | 6 | 15756 | 214 | 9 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 4 | SO70227 | 2024-08-29 | 2.80 | 13.09 | |
SO47090_1 | 6 | 21394 | 377 | 9 | 2022-11-28 | 54.54 | 2022-11-16 | 2181.56 | 1 | SO47090 | 2022-11-23 | 174.53 | 1320.68 | |
SO70228_1 | 6 | 13050 | 361 | 9 | 2024-09-03 | 57.37 | 2024-08-22 | 2294.99 | 1 | SO70228 | 2024-08-29 | 183.60 | 1251.98 | |
SO47097_1 | 6 | 21257 | 370 | 9 | 2022-11-29 | 61.08 | 2022-11-17 | 2443.35 | 1 | SO47097 | 2022-11-24 | 195.47 | 1518.79 | |
SO70228_2 | 6 | 13050 | 537 | 9 | 2024-09-03 | 0.88 | 2024-08-22 | 35.00 | 2 | SO70228 | 2024-08-29 | 2.80 | 13.09 | |
SO47098_1 | 6 | 12667 | 360 | 9 | 2022-11-29 | 51.23 | 2022-11-17 | 2049.10 | 1 | SO47098 | 2022-11-24 | 163.93 | 1105.81 | |
SO70246_1 | 6 | 15120 | 586 | 9 | 2024-09-03 | 18.56 | 2024-08-22 | 742.35 | 1 | SO70246 | 2024-08-29 | 59.39 | 461.44 | |
SO47099_1 | 6 | 26134 | 325 | 9 | 2022-11-29 | 19.57 | 2022-11-17 | 782.99 | 1 | SO47099 | 2022-11-24 | 62.64 | 486.71 | |
SO70246_2 | 6 | 15120 | 541 | 9 | 2024-09-03 | 0.72 | 2024-08-22 | 28.99 | 2 | SO70246 | 2024-08-29 | 2.32 | 10.84 | |
SO47114_1 | 6 | 21387 | 373 | 9 | 2022-12-01 | 54.54 | 2022-11-19 | 2181.56 | 1 | SO47114 | 2022-11-26 | 174.53 | 1320.68 | |
SO70246_3 | 6 | 15120 | 530 | 9 | 2024-09-03 | 0.12 | 2024-08-22 | 4.99 | 3 | SO70246 | 2024-08-29 | 0.40 | 1.87 | |
SO47115_1 | 6 | 21393 | 370 | 9 | 2022-12-01 | 61.08 | 2022-11-19 | 2443.35 | 1 | SO47115 | 2022-11-26 | 195.47 | 1518.79 | |
SO70246_4 | 6 | 15120 | 217 | 9 | 2024-09-03 | 0.87 | 2024-08-22 | 34.99 | 4 | SO70246 | 2024-08-29 | 2.80 | 13.09 | |
SO47116_1 | 6 | 24611 | 387 | 9 | 2022-12-01 | 25.01 | 2022-11-19 | 1000.44 | 1 | SO47116 | 2022-11-26 | 80.04 | 605.65 | |
SO70247_1 | 6 | 29299 | 584 | 9 | 2024-09-03 | 13.50 | 2024-08-22 | 539.99 | 1 | SO70247 | 2024-08-29 | 43.20 | 343.65 | |
SO47117_1 | 6 | 12586 | 354 | 9 | 2022-12-01 | 51.79 | 2022-11-19 | 2071.42 | 1 | SO47117 | 2022-11-26 | 165.71 | 1117.86 | |
SO70247_2 | 6 | 29299 | 479 | 9 | 2024-09-03 | 0.22 | 2024-08-22 | 8.99 | 2 | SO70247 | 2024-08-29 | 0.72 | 3.36 | |
SO47127_1 | 6 | 21258 | 371 | 9 | 2022-12-02 | 54.54 | 2022-11-20 | 2181.56 | 1 | SO47127 | 2022-11-27 | 174.53 | 1320.68 | |
SO70251_1 | 6 | 11148 | 528 | 9 | 2024-09-04 | 0.12 | 2024-08-23 | 4.99 | 1 | SO70251 | 2024-08-30 | 0.40 | 1.87 | |
SO47128_1 | 6 | 21556 | 368 | 9 | 2022-12-02 | 61.08 | 2022-11-20 | 2443.35 | 1 | SO47128 | 2022-11-27 | 195.47 | 1518.79 | |
SO70251_2 | 6 | 11148 | 535 | 9 | 2024-09-04 | 0.62 | 2024-08-23 | 24.99 | 2 | SO70251 | 2024-08-30 | 2.00 | 9.35 | |
SO47129_1 | 6 | 12677 | 352 | 9 | 2022-12-02 | 51.79 | 2022-11-20 | 2071.42 | 1 | SO47129 | 2022-11-27 | 165.71 | 1117.86 | |
SO70251_3 | 6 | 11148 | 480 | 2 | 9 | 2024-09-04 | 0.06 | 2024-08-23 | 2.29 | 3 | SO70251 | 2024-08-30 | 0.18 | 0.86 |
SO47136_1 | 6 | 21389 | 379 | 9 | 2022-12-03 | 54.54 | 2022-11-21 | 2181.56 | 1 | SO47136 | 2022-11-28 | 174.53 | 1320.68 | |
SO70252_1 | 6 | 18763 | 490 | 9 | 2024-09-04 | 1.35 | 2024-08-23 | 53.99 | 1 | SO70252 | 2024-08-30 | 4.32 | 41.57 | |
SO47141_1 | 6 | 21225 | 371 | 9 | 2022-12-04 | 54.54 | 2022-11-22 | 2181.56 | 1 | SO47141 | 2022-11-29 | 174.53 | 1320.68 | |
SO70253_1 | 6 | 28310 | 530 | 9 | 2024-09-04 | 0.12 | 2024-08-23 | 4.99 | 1 | SO70253 | 2024-08-30 | 0.40 | 1.87 | |
SO47142_1 | 6 | 21230 | 369 | 2 | 9 | 2022-12-04 | 61.08 | 2022-11-22 | 2443.35 | 1 | SO47142 | 2022-11-29 | 195.47 | 1518.79 |
SO70254_1 | 6 | 11371 | 237 | 9 | 2024-09-04 | 1.25 | 2024-08-23 | 49.99 | 1 | SO70254 | 2024-08-30 | 4.00 | 38.49 | |
SO47143_1 | 6 | 12684 | 362 | 2 | 9 | 2022-12-04 | 51.23 | 2022-11-22 | 2049.10 | 1 | SO47143 | 2022-11-29 | 163.93 | 1105.81 |
SO70298_1 | 6 | 26152 | 384 | 9 | 2024-09-04 | 28.01 | 2024-08-23 | 1120.49 | 1 | SO70298 | 2024-08-30 | 89.64 | 713.08 | |
SO47144_1 | 6 | 26033 | 343 | 9 | 2022-12-04 | 19.57 | 2022-11-22 | 782.99 | 1 | SO47144 | 2022-11-29 | 62.64 | 486.71 | |
SO70298_2 | 6 | 26152 | 214 | 9 | 2024-09-04 | 0.87 | 2024-08-23 | 34.99 | 2 | SO70298 | 2024-08-30 | 2.80 | 13.09 | |
SO47145_1 | 6 | 26131 | 339 | 9 | 2022-12-04 | 19.57 | 2022-11-22 | 782.99 | 1 | SO47145 | 2022-11-29 | 62.64 | 486.71 | |
SO70309_1 | 6 | 13616 | 564 | 9 | 2024-09-04 | 59.60 | 2024-08-23 | 2384.07 | 1 | SO70309 | 2024-08-30 | 190.73 | 1481.94 | |
SO47148_1 | 6 | 21259 | 377 | 9 | 2022-12-05 | 54.54 | 2022-11-23 | 2181.56 | 1 | SO47148 | 2022-11-30 | 174.53 | 1320.68 | |
SO70309_2 | 6 | 13616 | 530 | 9 | 2024-09-04 | 0.12 | 2024-08-23 | 4.99 | 2 | SO70309 | 2024-08-30 | 0.40 | 1.87 | |
SO47149_1 | 6 | 12669 | 360 | 9 | 2022-12-05 | 51.23 | 2022-11-23 | 2049.10 | 1 | SO47149 | 2022-11-30 | 163.93 | 1105.81 | |
SO70309_3 | 6 | 13616 | 541 | 9 | 2024-09-04 | 0.72 | 2024-08-23 | 28.99 | 3 | SO70309 | 2024-08-30 | 2.32 | 10.84 | |
SO47153_1 | 6 | 26024 | 321 | 9 | 2022-12-06 | 19.57 | 2022-11-24 | 782.99 | 1 | SO47153 | 2022-12-01 | 62.64 | 486.71 | |
SO70309_4 | 6 | 13616 | 487 | 9 | 2024-09-04 | 1.37 | 2024-08-23 | 54.99 | 4 | SO70309 | 2024-08-30 | 4.40 | 20.57 | |
SO47154_1 | 6 | 26133 | 335 | 9 | 2022-12-06 | 19.57 | 2022-11-24 | 782.99 | 1 | SO47154 | 2022-12-01 | 62.64 | 486.71 | |
SO70310_1 | 6 | 25939 | 606 | 9 | 2024-09-04 | 13.50 | 2024-08-23 | 539.99 | 1 | SO70310 | 2024-08-30 | 43.20 | 343.65 | |
SO47160_1 | 6 | 21403 | 369 | 2 | 9 | 2022-12-07 | 61.08 | 2022-11-25 | 2443.35 | 1 | SO47160 | 2022-12-02 | 195.47 | 1518.79 |
SO70310_2 | 6 | 25939 | 529 | 9 | 2024-09-04 | 0.10 | 2024-08-23 | 3.99 | 2 | SO70310 | 2024-08-30 | 0.32 | 1.49 | |
SO47161_1 | 6 | 21408 | 375 | 9 | 2022-12-07 | 54.54 | 2022-11-25 | 2181.56 | 1 | SO47161 | 2022-12-02 | 174.53 | 1320.68 | |
SO70310_3 | 6 | 25939 | 538 | 9 | 2024-09-04 | 0.54 | 2024-08-23 | 21.49 | 3 | SO70310 | 2024-08-30 | 1.72 | 8.04 | |
SO47162_1 | 6 | 21418 | 371 | 9 | 2022-12-07 | 54.54 | 2022-11-25 | 2181.56 | 1 | SO47162 | 2022-12-02 | 174.53 | 1320.68 | |
SO70311_1 | 6 | 29313 | 604 | 9 | 2024-09-04 | 13.50 | 2024-08-23 | 539.99 | 1 | SO70311 | 2024-08-30 | 43.20 | 343.65 | |
SO47163_1 | 6 | 12671 | 362 | 2 | 9 | 2022-12-07 | 51.23 | 2022-11-25 | 2049.10 | 1 | SO47163 | 2022-12-02 | 163.93 | 1105.81 |
SO70313_1 | 6 | 12997 | 535 | 9 | 2024-09-05 | 0.62 | 2024-08-24 | 24.99 | 1 | SO70313 | 2024-08-31 | 2.00 | 9.35 | |
SO47170_1 | 6 | 21228 | 377 | 9 | 2022-12-08 | 54.54 | 2022-11-26 | 2181.56 | 1 | SO47170 | 2022-12-03 | 174.53 | 1320.68 | |
SO70313_2 | 6 | 12997 | 480 | 9 | 2024-09-05 | 0.06 | 2024-08-24 | 2.29 | 2 | SO70313 | 2024-08-31 | 0.18 | 0.86 | |
SO47171_1 | 6 | 21552 | 373 | 9 | 2022-12-08 | 54.54 | 2022-11-26 | 2181.56 | 1 | SO47171 | 2022-12-03 | 174.53 | 1320.68 | |
SO70313_3 | 6 | 12997 | 484 | 9 | 2024-09-05 | 0.20 | 2024-08-24 | 7.95 | 3 | SO70313 | 2024-08-31 | 0.64 | 2.97 | |
SO47172_1 | 6 | 12668 | 352 | 9 | 2022-12-08 | 51.79 | 2022-11-26 | 2071.42 | 1 | SO47172 | 2022-12-03 | 165.71 | 1117.86 | |
SO70314_1 | 6 | 14317 | 539 | 9 | 2024-09-05 | 0.62 | 2024-08-24 | 24.99 | 1 | SO70314 | 2024-08-31 | 2.00 | 9.35 | |
SO47173_1 | 6 | 12675 | 356 | 9 | 2022-12-08 | 51.79 | 2022-11-26 | 2071.42 | 1 | SO47173 | 2022-12-03 | 165.71 | 1117.86 | |
SO70314_2 | 6 | 14317 | 529 | 9 | 2024-09-05 | 0.10 | 2024-08-24 | 3.99 | 2 | SO70314 | 2024-08-31 | 0.32 | 1.49 | |
SO47174_1 | 6 | 12584 | 354 | 9 | 2022-12-08 | 51.79 | 2022-11-26 | 2071.42 | 1 | SO47174 | 2022-12-03 | 165.71 | 1117.86 | |
SO70314_3 | 6 | 14317 | 480 | 9 | 2024-09-05 | 0.06 | 2024-08-24 | 2.29 | 3 | SO70314 | 2024-08-31 | 0.18 | 0.86 | |
SO47184_1 | 6 | 21380 | 379 | 9 | 2022-12-09 | 54.54 | 2022-11-27 | 2181.56 | 1 | SO47184 | 2022-12-04 | 174.53 | 1320.68 | |
SO70315_1 | 6 | 18191 | 473 | 9 | 2024-09-05 | 1.59 | 2024-08-24 | 63.50 | 1 | SO70315 | 2024-08-31 | 5.08 | 23.75 | |
SO47197_1 | 6 | 21218 | 377 | 9 | 2022-12-10 | 54.54 | 2022-11-28 | 2181.56 | 1 | SO47197 | 2022-12-05 | 174.53 | 1320.68 | |
SO70315_2 | 6 | 18191 | 485 | 9 | 2024-09-05 | 0.55 | 2024-08-24 | 21.98 | 2 | SO70315 | 2024-08-31 | 1.76 | 8.22 | |
SO47208_1 | 6 | 21359 | 369 | 2 | 9 | 2022-12-12 | 61.08 | 2022-11-30 | 2443.35 | 1 | SO47208 | 2022-12-07 | 195.47 | 1518.79 |
SO70316_1 | 6 | 12997 | 541 | 9 | 2024-09-05 | 0.72 | 2024-08-24 | 28.99 | 1 | SO70316 | 2024-08-31 | 2.32 | 10.84 | |
SO47209_1 | 6 | 21379 | 370 | 9 | 2022-12-12 | 61.08 | 2022-11-30 | 2443.35 | 1 | SO47209 | 2022-12-07 | 195.47 | 1518.79 | |
SO70316_2 | 6 | 12997 | 530 | 9 | 2024-09-05 | 0.12 | 2024-08-24 | 4.99 | 2 | SO70316 | 2024-08-31 | 0.40 | 1.87 | |
SO47210_1 | 6 | 24609 | 389 | 9 | 2022-12-12 | 25.01 | 2022-11-30 | 1000.44 | 1 | SO47210 | 2022-12-07 | 80.04 | 605.65 | |
SO70316_3 | 6 | 12997 | 225 | 9 | 2024-09-05 | 0.22 | 2024-08-24 | 8.99 | 3 | SO70316 | 2024-08-31 | 0.72 | 6.92 | |
SO47211_1 | 6 | 12578 | 362 | 2 | 9 | 2022-12-12 | 51.23 | 2022-11-30 | 2049.10 | 1 | SO47211 | 2022-12-07 | 163.93 | 1105.81 |
SO70356_1 | 6 | 21987 | 372 | 9 | 2024-09-05 | 61.08 | 2024-08-24 | 2443.35 | 1 | SO70356 | 2024-08-31 | 195.47 | 1554.95 | |
SO47212_1 | 6 | 12580 | 360 | 9 | 2022-12-12 | 51.23 | 2022-11-30 | 2049.10 | 1 | SO47212 | 2022-12-07 | 163.93 | 1105.81 | |
SO70356_2 | 6 | 21987 | 479 | 9 | 2024-09-05 | 0.22 | 2024-08-24 | 8.99 | 2 | SO70356 | 2024-08-31 | 0.72 | 3.36 | |
SO47217_1 | 6 | 21222 | 375 | 9 | 2022-12-13 | 54.54 | 2022-12-01 | 2181.56 | 1 | SO47217 | 2022-12-08 | 174.53 | 1320.68 | |
SO70356_3 | 6 | 21987 | 477 | 9 | 2024-09-05 | 0.12 | 2024-08-24 | 4.99 | 3 | SO70356 | 2024-08-31 | 0.40 | 1.87 | |
SO47218_1 | 6 | 21361 | 369 | 2 | 9 | 2022-12-13 | 61.08 | 2022-12-01 | 2443.35 | 1 | SO47218 | 2022-12-08 | 195.47 | 1518.79 |
SO70357_1 | 6 | 22181 | 374 | 9 | 2024-09-05 | 61.08 | 2024-08-24 | 2443.35 | 1 | SO70357 | 2024-08-31 | 195.47 | 1554.95 | |
SO47219_1 | 6 | 12577 | 362 | 2 | 9 | 2022-12-13 | 51.23 | 2022-12-01 | 2049.10 | 1 | SO47219 | 2022-12-08 | 163.93 | 1105.81 |
SO70357_2 | 6 | 22181 | 479 | 9 | 2024-09-05 | 0.22 | 2024-08-24 | 8.99 | 2 | SO70357 | 2024-08-31 | 0.72 | 3.36 | |
SO47220_1 | 6 | 12579 | 358 | 9 | 2022-12-13 | 51.23 | 2022-12-01 | 2049.10 | 1 | SO47220 | 2022-12-08 | 163.93 | 1105.81 | |
SO70357_3 | 6 | 22181 | 477 | 9 | 2024-09-05 | 0.12 | 2024-08-24 | 4.99 | 3 | SO70357 | 2024-08-31 | 0.40 | 1.87 | |
SO47230_1 | 6 | 21256 | 371 | 9 | 2022-12-14 | 54.54 | 2022-12-02 | 2181.56 | 1 | SO47230 | 2022-12-09 | 174.53 | 1320.68 | |
SO70357_4 | 6 | 22181 | 214 | 9 | 2024-09-05 | 0.87 | 2024-08-24 | 34.99 | 4 | SO70357 | 2024-08-31 | 2.80 | 13.09 | |
SO47239_1 | 6 | 21384 | 371 | 9 | 2022-12-15 | 54.54 | 2022-12-03 | 2181.56 | 1 | SO47239 | 2022-12-10 | 174.53 | 1320.68 | |
SO70358_1 | 6 | 15646 | 583 | 9 | 2024-09-05 | 42.52 | 2024-08-24 | 1700.99 | 1 | SO70358 | 2024-08-31 | 136.08 | 1082.51 | |
SO47240_1 | 6 | 24612 | 381 | 9 | 2022-12-15 | 25.01 | 2022-12-03 | 1000.44 | 1 | SO47240 | 2022-12-10 | 80.04 | 605.65 | |
SO70358_2 | 6 | 15646 | 489 | 9 | 2024-09-05 | 1.35 | 2024-08-24 | 53.99 | 2 | SO70358 | 2024-08-31 | 4.32 | 41.57 | |
SO47241_1 | 6 | 21559 | 368 | 9 | 2022-12-15 | 61.08 | 2022-12-03 | 2443.35 | 1 | SO47241 | 2022-12-10 | 195.47 | 1518.79 | |
SO70359_1 | 6 | 12589 | 596 | 9 | 2024-09-05 | 13.50 | 2024-08-24 | 539.99 | 1 | SO70359 | 2024-08-31 | 43.20 | 294.58 | |
SO47250_1 | 6 | 21217 | 379 | 9 | 2022-12-16 | 54.54 | 2022-12-04 | 2181.56 | 1 | SO47250 | 2022-12-11 | 174.53 | 1320.68 | |
SO70359_2 | 6 | 12589 | 485 | 9 | 2024-09-05 | 0.55 | 2024-08-24 | 21.98 | 2 | SO70359 | 2024-08-31 | 1.76 | 8.22 | |
SO47251_1 | 6 | 21226 | 377 | 9 | 2022-12-16 | 54.54 | 2022-12-04 | 2181.56 | 1 | SO47251 | 2022-12-11 | 174.53 | 1320.68 | |
SO70359_3 | 6 | 12589 | 489 | 9 | 2024-09-05 | 1.35 | 2024-08-24 | 53.99 | 3 | SO70359 | 2024-08-31 | 4.32 | 41.57 | |
SO47252_1 | 6 | 12676 | 352 | 9 | 2022-12-16 | 51.79 | 2022-12-04 | 2071.42 | 1 | SO47252 | 2022-12-11 | 165.71 | 1117.86 | |
SO70360_1 | 6 | 15755 | 355 | 9 | 2024-09-05 | 58.00 | 2024-08-24 | 2319.99 | 1 | SO70360 | 2024-08-31 | 185.60 | 1265.62 | |
SO47253_1 | 6 | 12683 | 356 | 9 | 2022-12-16 | 51.79 | 2022-12-04 | 2071.42 | 1 | SO47253 | 2022-12-11 | 165.71 | 1117.86 | |
SO70360_2 | 6 | 15755 | 214 | 9 | 2024-09-05 | 0.87 | 2024-08-24 | 34.99 | 2 | SO70360 | 2024-08-31 | 2.80 | 13.09 | |
SO47262_1 | 6 | 21560 | 379 | 9 | 2022-12-17 | 54.54 | 2022-12-05 | 2181.56 | 1 | SO47262 | 2022-12-12 | 174.53 | 1320.68 | |
SO70361_1 | 6 | 15717 | 353 | 9 | 2024-09-05 | 58.00 | 2024-08-24 | 2319.99 | 1 | SO70361 | 2024-08-31 | 185.60 | 1265.62 | |
SO47263_1 | 6 | 12589 | 358 | 9 | 2022-12-17 | 51.23 | 2022-12-05 | 2049.10 | 1 | SO47263 | 2022-12-12 | 163.93 | 1105.81 | |
SO70361_2 | 6 | 15717 | 528 | 9 | 2024-09-05 | 0.12 | 2024-08-24 | 4.99 | 2 | SO70361 | 2024-08-31 | 0.40 | 1.87 | |
SO47266_1 | 6 | 21555 | 377 | 9 | 2022-12-18 | 54.54 | 2022-12-06 | 2181.56 | 1 | SO47266 | 2022-12-13 | 174.53 | 1320.68 | |
SO70361_3 | 6 | 15717 | 537 | 9 | 2024-09-05 | 0.88 | 2024-08-24 | 35.00 | 3 | SO70361 | 2024-08-31 | 2.80 | 13.09 | |
SO47267_1 | 6 | 12674 | 352 | 9 | 2022-12-18 | 51.79 | 2022-12-06 | 2071.42 | 1 | SO47267 | 2022-12-13 | 165.71 | 1117.86 | |
SO70361_4 | 6 | 15717 | 480 | 9 | 2024-09-05 | 0.06 | 2024-08-24 | 2.29 | 4 | SO70361 | 2024-08-31 | 0.18 | 0.86 | |
SO47268_1 | 6 | 21402 | 375 | 9 | 2022-12-18 | 54.54 | 2022-12-06 | 2181.56 | 1 | SO47268 | 2022-12-13 | 174.53 | 1320.68 | |
SO70373_1 | 6 | 11032 | 570 | 9 | 2024-09-05 | 18.56 | 2024-08-24 | 742.35 | 1 | SO70373 | 2024-08-31 | 59.39 | 461.44 | |
SO47277_1 | 6 | 21219 | 371 | 9 | 2022-12-19 | 54.54 | 2022-12-07 | 2181.56 | 1 | SO47277 | 2022-12-14 | 174.53 | 1320.68 |
Generated 2024-11-13 04:07:54.625 UTC