[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2147 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO45735_1 | 6 | 19792 | 314 | 9 | 2022-07-16 | 89.46 | 2022-07-04 | 3578.27 | 1 | SO45735 | 2022-07-11 | 286.26 | 2171.29 | |
SO63999_3 | 6 | 16175 | 480 | 9 | 2024-06-05 | 0.06 | 2024-05-24 | 2.29 | 3 | SO63999 | 2024-05-31 | 0.18 | 0.86 | |
SO69316_1 | 6 | 15140 | 217 | 9 | 2024-08-22 | 0.87 | 2024-08-10 | 34.99 | 1 | SO69316 | 2024-08-17 | 2.80 | 13.09 | |
SO45736_1 | 6 | 19960 | 310 | 9 | 2022-07-16 | 89.46 | 2022-07-04 | 3578.27 | 1 | SO45736 | 2022-07-11 | 286.26 | 2171.29 | |
SO64000_1 | 6 | 14311 | 539 | 9 | 2024-06-05 | 0.62 | 2024-05-24 | 24.99 | 1 | SO64000 | 2024-05-31 | 2.00 | 9.35 | |
SO69371_1 | 6 | 15227 | 359 | 9 | 2024-08-22 | 57.37 | 2024-08-10 | 2294.99 | 1 | SO69371 | 2024-08-17 | 183.60 | 1251.98 | |
SO45737_1 | 6 | 19965 | 311 | 9 | 2022-07-16 | 89.46 | 2022-07-04 | 3578.27 | 1 | SO45737 | 2022-07-11 | 286.26 | 2171.29 | |
SO64000_2 | 6 | 14311 | 529 | 9 | 2024-06-05 | 0.10 | 2024-05-24 | 3.99 | 2 | SO64000 | 2024-05-31 | 0.32 | 1.49 | |
SO69371_2 | 6 | 15227 | 528 | 9 | 2024-08-22 | 0.12 | 2024-08-10 | 4.99 | 2 | SO69371 | 2024-08-17 | 0.40 | 1.87 | |
SO45738_1 | 6 | 11900 | 346 | 9 | 2022-07-16 | 85.00 | 2022-07-04 | 3399.99 | 1 | SO45738 | 2022-07-11 | 272.00 | 1912.15 | |
SO64000_3 | 6 | 14311 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 3 | SO64000 | 2024-05-31 | 2.80 | 13.09 | |
SO69371_3 | 6 | 15227 | 537 | 9 | 2024-08-22 | 0.88 | 2024-08-10 | 35.00 | 3 | SO69371 | 2024-08-17 | 2.80 | 13.09 | |
SO45739_1 | 6 | 11903 | 348 | 9 | 2022-07-16 | 84.37 | 2022-07-04 | 3374.99 | 1 | SO45739 | 2022-07-11 | 270.00 | 1898.09 | |
SO64001_1 | 6 | 17724 | 485 | 9 | 2024-06-05 | 0.55 | 2024-05-24 | 21.98 | 1 | SO64001 | 2024-05-31 | 1.76 | 8.22 | |
SO69371_4 | 6 | 15227 | 485 | 9 | 2024-08-22 | 0.55 | 2024-08-10 | 21.98 | 4 | SO69371 | 2024-08-17 | 1.76 | 8.22 | |
SO45740_1 | 6 | 19786 | 314 | 9 | 2022-07-17 | 89.46 | 2022-07-05 | 3578.27 | 1 | SO45740 | 2022-07-12 | 286.26 | 2171.29 | |
SO64001_2 | 6 | 17724 | 478 | 9 | 2024-06-05 | 0.25 | 2024-05-24 | 9.99 | 2 | SO64001 | 2024-05-31 | 0.80 | 3.74 | |
SO69371_5 | 6 | 15227 | 471 | 9 | 2024-08-22 | 1.59 | 2024-08-10 | 63.50 | 5 | SO69371 | 2024-08-17 | 5.08 | 23.75 | |
SO45741_1 | 6 | 19788 | 314 | 9 | 2022-07-17 | 89.46 | 2022-07-05 | 3578.27 | 1 | SO45741 | 2022-07-12 | 286.26 | 2171.29 | |
SO64001_3 | 6 | 17724 | 477 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 3 | SO64001 | 2024-05-31 | 0.40 | 1.87 | |
SO69372_1 | 6 | 26027 | 388 | 9 | 2024-08-22 | 28.01 | 2024-08-10 | 1120.49 | 1 | SO69372 | 2024-08-17 | 89.64 | 713.08 | |
SO45742_1 | 6 | 19620 | 312 | 9 | 2022-07-17 | 89.46 | 2022-07-05 | 3578.27 | 1 | SO45742 | 2022-07-12 | 286.26 | 2171.29 | |
SO64002_1 | 6 | 22957 | 477 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 1 | SO64002 | 2024-05-31 | 0.40 | 1.87 | |
SO69372_2 | 6 | 26027 | 214 | 9 | 2024-08-22 | 0.87 | 2024-08-10 | 34.99 | 2 | SO69372 | 2024-08-17 | 2.80 | 13.09 | |
SO45743_1 | 6 | 19631 | 313 | 9 | 2022-07-17 | 89.46 | 2022-07-05 | 3578.27 | 1 | SO45743 | 2022-07-12 | 286.26 | 2171.29 | |
SO64002_2 | 6 | 22957 | 214 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64002 | 2024-05-31 | 2.80 | 13.09 | |
SO69373_1 | 6 | 29294 | 606 | 2 | 9 | 2024-08-22 | 13.50 | 2024-08-10 | 539.99 | 1 | SO69373 | 2024-08-17 | 43.20 | 343.65 |
SO45744_1 | 6 | 11894 | 351 | 9 | 2022-07-17 | 84.37 | 2022-07-05 | 3374.99 | 1 | SO45744 | 2022-07-12 | 270.00 | 1898.09 | |
SO64003_1 | 6 | 15026 | 530 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 1 | SO64003 | 2024-05-31 | 0.40 | 1.87 | |
SO69373_2 | 6 | 29294 | 479 | 9 | 2024-08-22 | 0.22 | 2024-08-10 | 8.99 | 2 | SO69373 | 2024-08-17 | 0.72 | 3.36 | |
SO64004_1 | 6 | 28213 | 530 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 1 | SO64004 | 2024-05-31 | 0.40 | 1.87 | |
SO69373_3 | 6 | 29294 | 477 | 9 | 2024-08-22 | 0.12 | 2024-08-10 | 4.99 | 3 | SO69373 | 2024-08-17 | 0.40 | 1.87 | |
SO64004_2 | 6 | 28213 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64004 | 2024-05-31 | 2.80 | 13.09 | |
SO69374_1 | 6 | 24274 | 604 | 9 | 2024-08-22 | 13.50 | 2024-08-10 | 539.99 | 1 | SO69374 | 2024-08-17 | 43.20 | 343.65 | |
SO64005_1 | 6 | 14237 | 231 | 9 | 2024-06-05 | 1.25 | 2024-05-24 | 49.99 | 1 | SO64005 | 2024-05-31 | 4.00 | 38.49 | |
SO69374_2 | 6 | 24274 | 222 | 9 | 2024-08-22 | 0.87 | 2024-08-10 | 34.99 | 2 | SO69374 | 2024-08-17 | 2.80 | 13.09 | |
SO64005_2 | 6 | 14237 | 481 | 9 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 2 | SO64005 | 2024-05-31 | 0.72 | 3.36 | |
SO69375_1 | 6 | 21892 | 378 | 9 | 2024-08-22 | 61.08 | 2024-08-10 | 2443.35 | 1 | SO69375 | 2024-08-17 | 195.47 | 1554.95 | |
SO64006_1 | 6 | 13956 | 234 | 9 | 2024-06-05 | 1.25 | 2024-05-24 | 49.99 | 1 | SO64006 | 2024-05-31 | 4.00 | 38.49 | |
SO69375_2 | 6 | 21892 | 217 | 9 | 2024-08-22 | 0.87 | 2024-08-10 | 34.99 | 2 | SO69375 | 2024-08-17 | 2.80 | 13.09 | |
SO64039_1 | 6 | 21189 | 581 | 9 | 2024-06-05 | 42.52 | 2024-05-24 | 1700.99 | 1 | SO64039 | 2024-05-31 | 136.08 | 1082.51 | |
SO69376_1 | 6 | 21568 | 376 | 9 | 2024-08-22 | 61.08 | 2024-08-10 | 2443.35 | 1 | SO69376 | 2024-08-17 | 195.47 | 1554.95 | |
SO64039_2 | 6 | 21189 | 529 | 9 | 2024-06-05 | 0.10 | 2024-05-24 | 3.99 | 2 | SO64039 | 2024-05-31 | 0.32 | 1.49 | |
SO69376_2 | 6 | 21568 | 540 | 9 | 2024-08-22 | 0.82 | 2024-08-10 | 32.60 | 2 | SO69376 | 2024-08-17 | 2.61 | 12.19 | |
SO64039_3 | 6 | 21189 | 539 | 9 | 2024-06-05 | 0.62 | 2024-05-24 | 24.99 | 3 | SO64039 | 2024-05-31 | 2.00 | 9.35 | |
SO69376_3 | 6 | 21568 | 480 | 9 | 2024-08-22 | 0.06 | 2024-08-10 | 2.29 | 3 | SO69376 | 2024-08-17 | 0.18 | 0.86 | |
SO64039_4 | 6 | 21189 | 214 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 4 | SO64039 | 2024-05-31 | 2.80 | 13.09 | |
SO69377_1 | 6 | 21875 | 380 | 9 | 2024-08-22 | 61.08 | 2024-08-10 | 2443.35 | 1 | SO69377 | 2024-08-17 | 195.47 | 1554.95 | |
SO64040_1 | 6 | 24005 | 604 | 9 | 2024-06-05 | 13.50 | 2024-05-24 | 539.99 | 1 | SO64040 | 2024-05-31 | 43.20 | 343.65 | |
SO69377_2 | 6 | 21875 | 214 | 9 | 2024-08-22 | 0.87 | 2024-08-10 | 34.99 | 2 | SO69377 | 2024-08-17 | 2.80 | 13.09 | |
SO64040_2 | 6 | 24005 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64040 | 2024-05-31 | 2.80 | 13.09 | |
SO69378_1 | 6 | 15590 | 353 | 9 | 2024-08-22 | 58.00 | 2024-08-10 | 2319.99 | 1 | SO69378 | 2024-08-17 | 185.60 | 1265.62 | |
SO64041_1 | 6 | 13529 | 374 | 9 | 2024-06-05 | 61.08 | 2024-05-24 | 2443.35 | 1 | SO64041 | 2024-05-31 | 195.47 | 1554.95 | |
SO69378_2 | 6 | 15590 | 528 | 9 | 2024-08-22 | 0.12 | 2024-08-10 | 4.99 | 2 | SO69378 | 2024-08-17 | 0.40 | 1.87 | |
SO64041_2 | 6 | 13529 | 529 | 9 | 2024-06-05 | 0.10 | 2024-05-24 | 3.99 | 2 | SO64041 | 2024-05-31 | 0.32 | 1.49 | |
SO69378_3 | 6 | 15590 | 537 | 9 | 2024-08-22 | 0.88 | 2024-08-10 | 35.00 | 3 | SO69378 | 2024-08-17 | 2.80 | 13.09 | |
SO64041_3 | 6 | 13529 | 540 | 9 | 2024-06-05 | 0.82 | 2024-05-24 | 32.60 | 3 | SO64041 | 2024-05-31 | 2.61 | 12.19 | |
SO69378_4 | 6 | 15590 | 485 | 9 | 2024-08-22 | 0.55 | 2024-08-10 | 21.98 | 4 | SO69378 | 2024-08-17 | 1.76 | 8.22 | |
SO64041_4 | 6 | 13529 | 473 | 9 | 2024-06-05 | 1.59 | 2024-05-24 | 63.50 | 4 | SO64041 | 2024-05-31 | 5.08 | 23.75 | |
SO69378_5 | 6 | 15590 | 481 | 9 | 2024-08-22 | 0.22 | 2024-08-10 | 8.99 | 5 | SO69378 | 2024-08-17 | 0.72 | 3.36 | |
SO64042_1 | 6 | 11032 | 355 | 9 | 2024-06-05 | 58.00 | 2024-05-24 | 2319.99 | 1 | SO64042 | 2024-05-31 | 185.60 | 1265.62 | |
SO69567_1 | 6 | 14100 | 535 | 9 | 2024-08-23 | 0.62 | 2024-08-11 | 24.99 | 1 | SO69567 | 2024-08-18 | 2.00 | 9.35 | |
SO64042_2 | 6 | 11032 | 537 | 9 | 2024-06-05 | 0.88 | 2024-05-24 | 35.00 | 2 | SO64042 | 2024-05-31 | 2.80 | 13.09 | |
SO69567_2 | 6 | 14100 | 480 | 9 | 2024-08-23 | 0.06 | 2024-08-11 | 2.29 | 2 | SO69567 | 2024-08-18 | 0.18 | 0.86 | |
SO64042_3 | 6 | 11032 | 528 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 3 | SO64042 | 2024-05-31 | 0.40 | 1.87 | |
SO69568_1 | 6 | 12357 | 528 | 9 | 2024-08-23 | 0.12 | 2024-08-11 | 4.99 | 1 | SO69568 | 2024-08-18 | 0.40 | 1.87 | |
SO64042_4 | 6 | 11032 | 485 | 9 | 2024-06-05 | 0.55 | 2024-05-24 | 21.98 | 4 | SO64042 | 2024-05-31 | 1.76 | 8.22 | |
SO69568_2 | 6 | 12357 | 535 | 9 | 2024-08-23 | 0.62 | 2024-08-11 | 24.99 | 2 | SO69568 | 2024-08-18 | 2.00 | 9.35 | |
SO64042_5 | 6 | 11032 | 478 | 9 | 2024-06-05 | 0.25 | 2024-05-24 | 9.99 | 5 | SO64042 | 2024-05-31 | 0.80 | 3.74 | |
SO69568_3 | 6 | 12357 | 214 | 9 | 2024-08-23 | 0.87 | 2024-08-11 | 34.99 | 3 | SO69568 | 2024-08-18 | 2.80 | 13.09 | |
SO64042_6 | 6 | 11032 | 477 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 6 | SO64042 | 2024-05-31 | 0.40 | 1.87 | |
SO69568_4 | 6 | 12357 | 465 | 9 | 2024-08-23 | 0.61 | 2024-08-11 | 24.49 | 4 | SO69568 | 2024-08-18 | 1.96 | 9.16 | |
SO64042_7 | 6 | 11032 | 480 | 9 | 2024-06-05 | 0.06 | 2024-05-24 | 2.29 | 7 | SO64042 | 2024-05-31 | 0.18 | 0.86 | |
SO69569_1 | 6 | 16030 | 536 | 9 | 2024-08-23 | 0.75 | 2024-08-11 | 29.99 | 1 | SO69569 | 2024-08-18 | 2.40 | 11.22 | |
SO64050_1 | 6 | 29094 | 571 | 9 | 2024-06-05 | 18.56 | 2024-05-24 | 742.35 | 1 | SO64050 | 2024-05-31 | 59.39 | 461.44 | |
SO69569_2 | 6 | 16030 | 528 | 9 | 2024-08-23 | 0.12 | 2024-08-11 | 4.99 | 2 | SO69569 | 2024-08-18 | 0.40 | 1.87 | |
SO64050_2 | 6 | 29094 | 488 | 9 | 2024-06-05 | 1.35 | 2024-05-24 | 53.99 | 2 | SO64050 | 2024-05-31 | 4.32 | 41.57 | |
SO69569_3 | 6 | 16030 | 480 | 9 | 2024-08-23 | 0.06 | 2024-08-11 | 2.29 | 3 | SO69569 | 2024-08-18 | 0.18 | 0.86 | |
SO64051_1 | 6 | 29342 | 569 | 9 | 2024-06-05 | 18.56 | 2024-05-24 | 742.35 | 1 | SO64051 | 2024-05-31 | 59.39 | 461.44 | |
SO69570_1 | 6 | 18450 | 538 | 9 | 2024-08-23 | 0.54 | 2024-08-11 | 21.49 | 1 | SO69570 | 2024-08-18 | 1.72 | 8.04 | |
SO64051_2 | 6 | 29342 | 222 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64051 | 2024-05-31 | 2.80 | 13.09 | |
SO69570_2 | 6 | 18450 | 529 | 9 | 2024-08-23 | 0.10 | 2024-08-11 | 3.99 | 2 | SO69570 | 2024-08-18 | 0.32 | 1.49 | |
SO64051_3 | 6 | 29342 | 465 | 9 | 2024-06-05 | 0.61 | 2024-05-24 | 24.49 | 3 | SO64051 | 2024-05-31 | 1.96 | 9.16 | |
SO69571_1 | 6 | 23419 | 477 | 9 | 2024-08-23 | 0.12 | 2024-08-11 | 4.99 | 1 | SO69571 | 2024-08-18 | 0.40 | 1.87 | |
SO64052_1 | 6 | 27879 | 560 | 9 | 2024-06-05 | 30.37 | 2024-05-24 | 1214.85 | 1 | SO64052 | 2024-05-31 | 97.19 | 755.15 | |
SO69571_2 | 6 | 23419 | 222 | 9 | 2024-08-23 | 0.87 | 2024-08-11 | 34.99 | 2 | SO69571 | 2024-08-18 | 2.80 | 13.09 | |
SO64052_2 | 6 | 27879 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64052 | 2024-05-31 | 2.80 | 13.09 | |
SO69572_1 | 6 | 11045 | 228 | 9 | 2024-08-23 | 1.25 | 2024-08-11 | 49.99 | 1 | SO69572 | 2024-08-18 | 4.00 | 38.49 | |
SO64052_3 | 6 | 27879 | 472 | 9 | 2024-06-05 | 1.59 | 2024-05-24 | 63.50 | 3 | SO64052 | 2024-05-31 | 5.08 | 23.75 | |
SO69573_1 | 6 | 18743 | 480 | 9 | 2024-08-23 | 0.06 | 2024-08-11 | 2.29 | 1 | SO69573 | 2024-08-18 | 0.18 | 0.86 | |
SO64053_1 | 6 | 23996 | 605 | 9 | 2024-06-05 | 13.50 | 2024-05-24 | 539.99 | 1 | SO64053 | 2024-05-31 | 43.20 | 343.65 | |
SO69573_2 | 6 | 18743 | 484 | 9 | 2024-08-23 | 0.20 | 2024-08-11 | 7.95 | 2 | SO69573 | 2024-08-18 | 0.64 | 2.97 | |
SO64053_2 | 6 | 23996 | 479 | 9 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 2 | SO64053 | 2024-05-31 | 0.72 | 3.36 | |
SO69574_1 | 6 | 18258 | 225 | 9 | 2024-08-23 | 0.22 | 2024-08-11 | 8.99 | 1 | SO69574 | 2024-08-18 | 0.72 | 6.92 | |
SO64053_3 | 6 | 23996 | 477 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 3 | SO64053 | 2024-05-31 | 0.40 | 1.87 | |
SO69625_1 | 6 | 26433 | 384 | 9 | 2024-08-23 | 28.01 | 2024-08-11 | 1120.49 | 1 | SO69625 | 2024-08-18 | 89.64 | 713.08 | |
SO64053_4 | 6 | 23996 | 225 | 9 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 4 | SO64053 | 2024-05-31 | 0.72 | 6.92 | |
SO69626_1 | 6 | 18334 | 384 | 9 | 2024-08-23 | 28.01 | 2024-08-11 | 1120.49 | 1 | SO69626 | 2024-08-18 | 89.64 | 713.08 | |
SO64055_1 | 6 | 15242 | 539 | 9 | 2024-06-06 | 0.62 | 2024-05-25 | 24.99 | 1 | SO64055 | 2024-06-01 | 2.00 | 9.35 | |
SO69627_1 | 6 | 21999 | 374 | 9 | 2024-08-23 | 61.08 | 2024-08-11 | 2443.35 | 1 | SO69627 | 2024-08-18 | 195.47 | 1554.95 | |
SO64055_2 | 6 | 15242 | 480 | 9 | 2024-06-06 | 0.06 | 2024-05-25 | 2.29 | 2 | SO64055 | 2024-06-01 | 0.18 | 0.86 | |
SO69627_2 | 6 | 21999 | 222 | 9 | 2024-08-23 | 0.87 | 2024-08-11 | 34.99 | 2 | SO69627 | 2024-08-18 | 2.80 | 13.09 | |
SO64056_1 | 6 | 17058 | 536 | 9 | 2024-06-06 | 0.75 | 2024-05-25 | 29.99 | 1 | SO64056 | 2024-06-01 | 2.40 | 11.22 | |
SO69628_1 | 6 | 24463 | 580 | 9 | 2024-08-23 | 42.52 | 2024-08-11 | 1700.99 | 1 | SO69628 | 2024-08-18 | 136.08 | 1082.51 | |
SO64057_1 | 6 | 22206 | 528 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 1 | SO64057 | 2024-06-01 | 0.40 | 1.87 | |
SO69628_2 | 6 | 24463 | 217 | 9 | 2024-08-23 | 0.87 | 2024-08-11 | 34.99 | 2 | SO69628 | 2024-08-18 | 2.80 | 13.09 | |
SO64057_2 | 6 | 22206 | 537 | 9 | 2024-06-06 | 0.88 | 2024-05-25 | 35.00 | 2 | SO64057 | 2024-06-01 | 2.80 | 13.09 | |
SO69629_1 | 6 | 22004 | 581 | 9 | 2024-08-23 | 42.52 | 2024-08-11 | 1700.99 | 1 | SO69629 | 2024-08-18 | 136.08 | 1082.51 | |
SO64057_3 | 6 | 22206 | 480 | 9 | 2024-06-06 | 0.06 | 2024-05-25 | 2.29 | 3 | SO64057 | 2024-06-01 | 0.18 | 0.86 | |
SO69629_2 | 6 | 22004 | 222 | 9 | 2024-08-23 | 0.87 | 2024-08-11 | 34.99 | 2 | SO69629 | 2024-08-18 | 2.80 | 13.09 | |
SO64057_4 | 6 | 22206 | 486 | 9 | 2024-06-06 | 3.98 | 2024-05-25 | 159.00 | 4 | SO64057 | 2024-06-01 | 12.72 | 59.47 | |
SO69630_1 | 6 | 15647 | 583 | 9 | 2024-08-23 | 42.52 | 2024-08-11 | 1700.99 | 1 | SO69630 | 2024-08-18 | 136.08 | 1082.51 |
Generated 2024-11-11 00:29:27.127 UTC