[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2371 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO52114_1 | 6 | 15592 | 539 | 9 | 2023-11-28 | 0.62 | 2023-11-16 | 24.99 | 1 | SO52114 | 2023-11-23 | 2.00 | 9.35 | |
SO52115_1 | 6 | 21883 | 537 | 9 | 2023-11-28 | 0.88 | 2023-11-16 | 35.00 | 1 | SO52115 | 2023-11-23 | 2.80 | 13.09 | |
SO52115_2 | 6 | 21883 | 528 | 9 | 2023-11-28 | 0.12 | 2023-11-16 | 4.99 | 2 | SO52115 | 2023-11-23 | 0.40 | 1.87 | |
SO52115_3 | 6 | 21883 | 480 | 9 | 2023-11-28 | 0.06 | 2023-11-16 | 2.29 | 3 | SO52115 | 2023-11-23 | 0.18 | 0.86 | |
SO52116_1 | 6 | 27968 | 530 | 9 | 2023-11-28 | 0.12 | 2023-11-16 | 4.99 | 1 | SO52116 | 2023-11-23 | 0.40 | 1.87 | |
SO52116_2 | 6 | 27968 | 214 | 9 | 2023-11-28 | 0.87 | 2023-11-16 | 34.99 | 2 | SO52116 | 2023-11-23 | 2.80 | 13.09 | |
SO52117_1 | 6 | 22028 | 476 | 9 | 2023-11-28 | 1.75 | 2023-11-16 | 69.99 | 1 | SO52117 | 2023-11-23 | 5.60 | 26.18 | |
SO52118_1 | 6 | 25923 | 529 | 9 | 2023-11-28 | 0.10 | 2023-11-16 | 3.99 | 1 | SO52118 | 2023-11-23 | 0.32 | 1.49 | |
SO52118_2 | 6 | 25923 | 480 | 9 | 2023-11-28 | 0.06 | 2023-11-16 | 2.29 | 2 | SO52118 | 2023-11-23 | 0.18 | 0.86 | |
SO52119_1 | 6 | 13138 | 529 | 9 | 2023-11-28 | 0.10 | 2023-11-16 | 3.99 | 1 | SO52119 | 2023-11-23 | 0.32 | 1.49 | |
SO52148_1 | 6 | 22950 | 583 | 9 | 2023-11-28 | 42.52 | 2023-11-16 | 1700.99 | 1 | SO52148 | 2023-11-23 | 136.08 | 1082.51 | |
SO52148_2 | 6 | 22950 | 222 | 9 | 2023-11-28 | 0.87 | 2023-11-16 | 34.99 | 2 | SO52148 | 2023-11-23 | 2.80 | 13.09 | |
SO52149_1 | 6 | 28720 | 563 | 9 | 2023-11-28 | 59.60 | 2023-11-16 | 2384.07 | 1 | SO52149 | 2023-11-23 | 190.73 | 1481.94 | |
SO52149_2 | 6 | 28720 | 214 | 9 | 2023-11-28 | 0.87 | 2023-11-16 | 34.99 | 2 | SO52149 | 2023-11-23 | 2.80 | 13.09 | |
SO52153_1 | 6 | 13521 | 372 | 9 | 2023-11-29 | 61.08 | 2023-11-17 | 2443.35 | 1 | SO52153 | 2023-11-24 | 195.47 | 1554.95 | |
SO52154_1 | 6 | 18251 | 374 | 9 | 2023-11-29 | 61.08 | 2023-11-17 | 2443.35 | 1 | SO52154 | 2023-11-24 | 195.47 | 1554.95 | |
SO52154_2 | 6 | 18251 | 479 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 2 | SO52154 | 2023-11-24 | 0.72 | 3.36 | |
SO52154_3 | 6 | 18251 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 3 | SO52154 | 2023-11-24 | 0.40 | 1.87 | |
SO52155_1 | 6 | 18254 | 372 | 9 | 2023-11-29 | 61.08 | 2023-11-17 | 2443.35 | 1 | SO52155 | 2023-11-24 | 195.47 | 1554.95 | |
SO52156_1 | 6 | 16703 | 374 | 2 | 9 | 2023-11-29 | 61.08 | 2023-11-17 | 2443.35 | 1 | SO52156 | 2023-11-24 | 195.47 | 1554.95 |
SO52156_2 | 6 | 16703 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 2 | SO52156 | 2023-11-24 | 0.40 | 1.87 | |
SO52156_3 | 6 | 16703 | 479 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 3 | SO52156 | 2023-11-24 | 0.72 | 3.36 | |
SO52156_4 | 6 | 16703 | 487 | 9 | 2023-11-29 | 1.37 | 2023-11-17 | 54.99 | 4 | SO52156 | 2023-11-24 | 4.40 | 20.57 | |
SO52157_1 | 6 | 24609 | 382 | 9 | 2023-11-29 | 28.01 | 2023-11-17 | 1120.49 | 1 | SO52157 | 2023-11-24 | 89.64 | 713.08 | |
SO52158_1 | 6 | 24613 | 388 | 9 | 2023-11-29 | 28.01 | 2023-11-17 | 1120.49 | 1 | SO52158 | 2023-11-24 | 89.64 | 713.08 | |
SO52158_2 | 6 | 24613 | 539 | 9 | 2023-11-29 | 0.62 | 2023-11-17 | 24.99 | 2 | SO52158 | 2023-11-24 | 2.00 | 9.35 | |
SO52158_3 | 6 | 24613 | 480 | 2 | 9 | 2023-11-29 | 0.06 | 2023-11-17 | 2.29 | 3 | SO52158 | 2023-11-24 | 0.18 | 0.86 |
SO52159_1 | 6 | 11996 | 578 | 9 | 2023-11-29 | 30.37 | 2023-11-17 | 1214.85 | 1 | SO52159 | 2023-11-24 | 97.19 | 755.15 | |
SO52159_2 | 6 | 11996 | 479 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 2 | SO52159 | 2023-11-24 | 0.72 | 3.36 | |
SO52159_3 | 6 | 11996 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 3 | SO52159 | 2023-11-24 | 0.40 | 1.87 | |
SO52159_4 | 6 | 11996 | 487 | 9 | 2023-11-29 | 1.37 | 2023-11-17 | 54.99 | 4 | SO52159 | 2023-11-24 | 4.40 | 20.57 | |
SO52159_5 | 6 | 11996 | 484 | 9 | 2023-11-29 | 0.20 | 2023-11-17 | 7.95 | 5 | SO52159 | 2023-11-24 | 0.64 | 2.97 | |
SO52164_1 | 6 | 11119 | 535 | 9 | 2023-11-29 | 0.62 | 2023-11-17 | 24.99 | 1 | SO52164 | 2023-11-24 | 2.00 | 9.35 | |
SO52164_2 | 6 | 11119 | 480 | 9 | 2023-11-29 | 0.06 | 2023-11-17 | 2.29 | 2 | SO52164 | 2023-11-24 | 0.18 | 0.86 | |
SO52164_3 | 6 | 11119 | 484 | 9 | 2023-11-29 | 0.20 | 2023-11-17 | 7.95 | 3 | SO52164 | 2023-11-24 | 0.64 | 2.97 | |
SO52165_1 | 6 | 16617 | 528 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 1 | SO52165 | 2023-11-24 | 0.40 | 1.87 | |
SO52165_2 | 6 | 16617 | 536 | 9 | 2023-11-29 | 0.75 | 2023-11-17 | 29.99 | 2 | SO52165 | 2023-11-24 | 2.40 | 11.22 | |
SO52165_3 | 6 | 16617 | 214 | 9 | 2023-11-29 | 0.87 | 2023-11-17 | 34.99 | 3 | SO52165 | 2023-11-24 | 2.80 | 13.09 | |
SO52166_1 | 6 | 28533 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 1 | SO52166 | 2023-11-24 | 0.40 | 1.87 | |
SO52205_1 | 6 | 18700 | 583 | 9 | 2023-11-29 | 42.52 | 2023-11-17 | 1700.99 | 1 | SO52205 | 2023-11-24 | 136.08 | 1082.51 | |
SO52205_2 | 6 | 18700 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 2 | SO52205 | 2023-11-24 | 0.40 | 1.87 | |
SO52205_3 | 6 | 18700 | 479 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 3 | SO52205 | 2023-11-24 | 0.72 | 3.36 | |
SO52205_4 | 6 | 18700 | 217 | 9 | 2023-11-29 | 0.87 | 2023-11-17 | 34.99 | 4 | SO52205 | 2023-11-24 | 2.80 | 13.09 | |
SO52206_1 | 6 | 17514 | 600 | 9 | 2023-11-29 | 13.50 | 2023-11-17 | 539.99 | 1 | SO52206 | 2023-11-24 | 43.20 | 294.58 | |
SO52206_2 | 6 | 17514 | 478 | 9 | 2023-11-29 | 0.25 | 2023-11-17 | 9.99 | 2 | SO52206 | 2023-11-24 | 0.80 | 3.74 | |
SO52206_3 | 6 | 17514 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 3 | SO52206 | 2023-11-24 | 0.40 | 1.87 | |
SO52206_4 | 6 | 17514 | 225 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 4 | SO52206 | 2023-11-24 | 0.72 | 6.92 | |
SO52207_1 | 6 | 11056 | 353 | 9 | 2023-11-29 | 58.00 | 2023-11-17 | 2319.99 | 1 | SO52207 | 2023-11-24 | 185.60 | 1265.62 | |
SO52207_2 | 6 | 11056 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 2 | SO52207 | 2023-11-24 | 0.40 | 1.87 | |
SO52207_3 | 6 | 11056 | 478 | 9 | 2023-11-29 | 0.25 | 2023-11-17 | 9.99 | 3 | SO52207 | 2023-11-24 | 0.80 | 3.74 | |
SO52207_4 | 6 | 11056 | 489 | 9 | 2023-11-29 | 1.35 | 2023-11-17 | 53.99 | 4 | SO52207 | 2023-11-24 | 4.32 | 41.57 | |
SO52207_5 | 6 | 11056 | 463 | 9 | 2023-11-29 | 0.61 | 2023-11-17 | 24.49 | 5 | SO52207 | 2023-11-24 | 1.96 | 9.16 | |
SO52210_1 | 6 | 18308 | 376 | 9 | 2023-11-29 | 61.08 | 2023-11-17 | 2443.35 | 1 | SO52210 | 2023-11-24 | 195.47 | 1554.95 | |
SO52210_2 | 6 | 18308 | 479 | 9 | 2023-11-29 | 0.22 | 2023-11-17 | 8.99 | 2 | SO52210 | 2023-11-24 | 0.72 | 3.36 | |
SO52210_3 | 6 | 18308 | 477 | 9 | 2023-11-29 | 0.12 | 2023-11-17 | 4.99 | 3 | SO52210 | 2023-11-24 | 0.40 | 1.87 | |
SO52210_4 | 6 | 18308 | 480 | 9 | 2023-11-29 | 0.06 | 2023-11-17 | 2.29 | 4 | SO52210 | 2023-11-24 | 0.18 | 0.86 | |
SO52211_1 | 6 | 18482 | 376 | 9 | 2023-11-30 | 61.08 | 2023-11-18 | 2443.35 | 1 | SO52211 | 2023-11-25 | 195.47 | 1554.95 | |
SO52211_2 | 6 | 18482 | 479 | 9 | 2023-11-30 | 0.22 | 2023-11-18 | 8.99 | 2 | SO52211 | 2023-11-25 | 0.72 | 3.36 | |
SO52212_1 | 6 | 18275 | 372 | 9 | 2023-11-30 | 61.08 | 2023-11-18 | 2443.35 | 1 | SO52212 | 2023-11-25 | 195.47 | 1554.95 | |
SO52216_1 | 6 | 15140 | 539 | 9 | 2023-11-30 | 0.62 | 2023-11-18 | 24.99 | 1 | SO52216 | 2023-11-25 | 2.00 | 9.35 | |
SO52216_2 | 6 | 15140 | 480 | 9 | 2023-11-30 | 0.06 | 2023-11-18 | 2.29 | 2 | SO52216 | 2023-11-25 | 0.18 | 0.86 | |
SO52217_1 | 6 | 17078 | 536 | 9 | 2023-11-30 | 0.75 | 2023-11-18 | 29.99 | 1 | SO52217 | 2023-11-25 | 2.40 | 11.22 | |
SO52217_2 | 6 | 17078 | 528 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 2 | SO52217 | 2023-11-25 | 0.40 | 1.87 | |
SO52217_3 | 6 | 17078 | 214 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 3 | SO52217 | 2023-11-25 | 2.80 | 13.09 | |
SO52217_4 | 6 | 17078 | 488 | 9 | 2023-11-30 | 1.35 | 2023-11-18 | 53.99 | 4 | SO52217 | 2023-11-25 | 4.32 | 41.57 | |
SO52218_1 | 6 | 21887 | 537 | 9 | 2023-11-30 | 0.88 | 2023-11-18 | 35.00 | 1 | SO52218 | 2023-11-25 | 2.80 | 13.09 | |
SO52218_2 | 6 | 21887 | 528 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 2 | SO52218 | 2023-11-25 | 0.40 | 1.87 | |
SO52219_1 | 6 | 27978 | 530 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 1 | SO52219 | 2023-11-25 | 0.40 | 1.87 | |
SO52219_2 | 6 | 27978 | 465 | 9 | 2023-11-30 | 0.61 | 2023-11-18 | 24.49 | 2 | SO52219 | 2023-11-25 | 1.96 | 9.16 | |
SO52220_1 | 6 | 13998 | 214 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 1 | SO52220 | 2023-11-25 | 2.80 | 13.09 | |
SO52220_2 | 6 | 13998 | 225 | 9 | 2023-11-30 | 0.22 | 2023-11-18 | 8.99 | 2 | SO52220 | 2023-11-25 | 0.72 | 6.92 | |
SO52220_3 | 6 | 13998 | 491 | 9 | 2023-11-30 | 1.35 | 2023-11-18 | 53.99 | 3 | SO52220 | 2023-11-25 | 4.32 | 41.57 | |
SO52221_1 | 6 | 17291 | 489 | 9 | 2023-11-30 | 1.35 | 2023-11-18 | 53.99 | 1 | SO52221 | 2023-11-25 | 4.32 | 41.57 | |
SO52269_1 | 6 | 28719 | 561 | 9 | 2023-11-30 | 59.60 | 2023-11-18 | 2384.07 | 1 | SO52269 | 2023-11-25 | 190.73 | 1481.94 | |
SO52270_1 | 6 | 11947 | 591 | 9 | 2023-11-30 | 14.12 | 2023-11-18 | 564.99 | 1 | SO52270 | 2023-11-25 | 45.20 | 308.22 | |
SO52270_2 | 6 | 11947 | 535 | 9 | 2023-11-30 | 0.62 | 2023-11-18 | 24.99 | 2 | SO52270 | 2023-11-25 | 2.00 | 9.35 | |
SO52270_3 | 6 | 11947 | 528 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 3 | SO52270 | 2023-11-25 | 0.40 | 1.87 | |
SO52270_4 | 6 | 11947 | 217 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 4 | SO52270 | 2023-11-25 | 2.80 | 13.09 | |
SO52271_1 | 6 | 11055 | 353 | 9 | 2023-11-30 | 58.00 | 2023-11-18 | 2319.99 | 1 | SO52271 | 2023-11-25 | 185.60 | 1265.62 | |
SO52271_2 | 6 | 11055 | 537 | 9 | 2023-11-30 | 0.88 | 2023-11-18 | 35.00 | 2 | SO52271 | 2023-11-25 | 2.80 | 13.09 | |
SO52271_3 | 6 | 11055 | 528 | 9 | 2023-11-30 | 0.12 | 2023-11-18 | 4.99 | 3 | SO52271 | 2023-11-25 | 0.40 | 1.87 | |
SO52271_4 | 6 | 11055 | 217 | 9 | 2023-11-30 | 0.87 | 2023-11-18 | 34.99 | 4 | SO52271 | 2023-11-25 | 2.80 | 13.09 | |
SO52278_1 | 6 | 18484 | 378 | 9 | 2023-12-01 | 61.08 | 2023-11-19 | 2443.35 | 1 | SO52278 | 2023-11-26 | 195.47 | 1554.95 | |
SO52278_2 | 6 | 18484 | 529 | 9 | 2023-12-01 | 0.10 | 2023-11-19 | 3.99 | 2 | SO52278 | 2023-11-26 | 0.32 | 1.49 | |
SO52278_3 | 6 | 18484 | 540 | 9 | 2023-12-01 | 0.82 | 2023-11-19 | 32.60 | 3 | SO52278 | 2023-11-26 | 2.61 | 12.19 | |
SO52278_4 | 6 | 18484 | 222 | 9 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 4 | SO52278 | 2023-11-26 | 2.80 | 13.09 | |
SO52279_1 | 6 | 18249 | 372 | 9 | 2023-12-01 | 61.08 | 2023-11-19 | 2443.35 | 1 | SO52279 | 2023-11-26 | 195.47 | 1554.95 | |
SO52279_2 | 6 | 18249 | 477 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 2 | SO52279 | 2023-11-26 | 0.40 | 1.87 | |
SO52279_3 | 6 | 18249 | 479 | 9 | 2023-12-01 | 0.22 | 2023-11-19 | 8.99 | 3 | SO52279 | 2023-11-26 | 0.72 | 3.36 | |
SO52279_4 | 6 | 18249 | 225 | 9 | 2023-12-01 | 0.22 | 2023-11-19 | 8.99 | 4 | SO52279 | 2023-11-26 | 0.72 | 6.92 | |
SO52280_1 | 6 | 18288 | 374 | 9 | 2023-12-01 | 61.08 | 2023-11-19 | 2443.35 | 1 | SO52280 | 2023-11-26 | 195.47 | 1554.95 | |
SO52280_2 | 6 | 18288 | 529 | 9 | 2023-12-01 | 0.10 | 2023-11-19 | 3.99 | 2 | SO52280 | 2023-11-26 | 0.32 | 1.49 | |
SO52280_3 | 6 | 18288 | 540 | 9 | 2023-12-01 | 0.82 | 2023-11-19 | 32.60 | 3 | SO52280 | 2023-11-26 | 2.61 | 12.19 | |
SO52280_4 | 6 | 18288 | 217 | 9 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 4 | SO52280 | 2023-11-26 | 2.80 | 13.09 | |
SO52281_1 | 6 | 14051 | 579 | 9 | 2023-12-01 | 30.37 | 2023-11-19 | 1214.85 | 1 | SO52281 | 2023-11-26 | 97.19 | 755.15 | |
SO52281_2 | 6 | 14051 | 479 | 9 | 2023-12-01 | 0.22 | 2023-11-19 | 8.99 | 2 | SO52281 | 2023-11-26 | 0.72 | 3.36 | |
SO52281_3 | 6 | 14051 | 477 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 3 | SO52281 | 2023-11-26 | 0.40 | 1.87 | |
SO52281_4 | 6 | 14051 | 481 | 2 | 9 | 2023-12-01 | 0.22 | 2023-11-19 | 8.99 | 4 | SO52281 | 2023-11-26 | 0.72 | 3.36 |
SO52285_1 | 6 | 13158 | 535 | 9 | 2023-12-01 | 0.62 | 2023-11-19 | 24.99 | 1 | SO52285 | 2023-11-26 | 2.00 | 9.35 | |
SO52285_2 | 6 | 13158 | 528 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 2 | SO52285 | 2023-11-26 | 0.40 | 1.87 | |
SO52285_3 | 6 | 13158 | 217 | 9 | 2023-12-01 | 0.87 | 2023-11-19 | 34.99 | 3 | SO52285 | 2023-11-26 | 2.80 | 13.09 | |
SO52286_1 | 6 | 11146 | 535 | 9 | 2023-12-01 | 0.62 | 2023-11-19 | 24.99 | 1 | SO52286 | 2023-11-26 | 2.00 | 9.35 | |
SO52286_2 | 6 | 11146 | 528 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 2 | SO52286 | 2023-11-26 | 0.40 | 1.87 | |
SO52286_3 | 6 | 11146 | 477 | 9 | 2023-12-01 | 0.12 | 2023-11-19 | 4.99 | 3 | SO52286 | 2023-11-26 | 0.40 | 1.87 | |
SO52286_4 | 6 | 11146 | 478 | 9 | 2023-12-01 | 0.25 | 2023-11-19 | 9.99 | 4 | SO52286 | 2023-11-26 | 0.80 | 3.74 | |
SO52286_5 | 6 | 11146 | 225 | 9 | 2023-12-01 | 0.22 | 2023-11-19 | 8.99 | 5 | SO52286 | 2023-11-26 | 0.72 | 6.92 | |
SO52287_1 | 6 | 17284 | 539 | 9 | 2023-12-01 | 0.62 | 2023-11-19 | 24.99 | 1 | SO52287 | 2023-11-26 | 2.00 | 9.35 | |
SO52287_2 | 6 | 17284 | 529 | 9 | 2023-12-01 | 0.10 | 2023-11-19 | 3.99 | 2 | SO52287 | 2023-11-26 | 0.32 | 1.49 | |
SO52287_3 | 6 | 17284 | 480 | 9 | 2023-12-01 | 0.06 | 2023-11-19 | 2.29 | 3 | SO52287 | 2023-11-26 | 0.18 | 0.86 | |
SO52288_1 | 6 | 21391 | 536 | 9 | 2023-12-01 | 0.75 | 2023-11-19 | 29.99 | 1 | SO52288 | 2023-11-26 | 2.40 | 11.22 | |
SO52289_1 | 6 | 22839 | 485 | 9 | 2023-12-01 | 0.55 | 2023-11-19 | 21.98 | 1 | SO52289 | 2023-11-26 | 1.76 | 8.22 | |
SO52289_2 | 6 | 22839 | 478 | 9 | 2023-12-01 | 0.25 | 2023-11-19 | 9.99 | 2 | SO52289 | 2023-11-26 | 0.80 | 3.74 |
Generated 2024-11-10 22:08:57.546 UTC