[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 49 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO51412_1 | 100 | 22312 | 372 | 7 | 2023-11-06 | 61.08 | 2023-10-25 | 2443.35 | 1 | SO51412 | 2023-11-01 | 195.47 | 1554.95 | |
SO69121_1 | 100 | 23972 | 541 | 7 | 2024-08-19 | 0.72 | 2024-08-07 | 28.99 | 1 | SO69121 | 2024-08-14 | 2.32 | 10.84 | |
SO68134_3 | 100 | 12131 | 234 | 7 | 2024-08-04 | 1.25 | 2024-07-23 | 49.99 | 3 | SO68134 | 2024-07-30 | 4.00 | 38.49 | |
SO71451_1 | 100 | 21529 | 536 | 7 | 2024-09-18 | 0.75 | 2024-09-06 | 29.99 | 1 | SO71451 | 2024-09-13 | 2.40 | 11.22 | |
SO59237_2 | 100 | 23936 | 530 | 7 | 2024-03-26 | 0.12 | 2024-03-14 | 4.99 | 2 | SO59237 | 2024-03-21 | 0.40 | 1.87 | |
SO52017_2 | 100 | 12131 | 541 | 7 | 2023-11-25 | 0.72 | 2023-11-13 | 28.99 | 2 | SO52017 | 2023-11-20 | 2.32 | 10.84 | |
SO50844_1 | 100 | 19503 | 327 | 7 | 2023-09-30 | 19.57 | 2023-09-18 | 782.99 | 1 | SO50844 | 2023-09-25 | 62.64 | 486.71 | |
SO65368_3 | 100 | 25688 | 214 | 7 | 2024-06-23 | 0.87 | 2024-06-11 | 34.99 | 3 | SO65368 | 2024-06-18 | 2.80 | 13.09 | |
SO66982_2 | 100 | 23980 | 530 | 7 | 2024-07-19 | 0.12 | 2024-07-07 | 4.99 | 2 | SO66982 | 2024-07-14 | 0.40 | 1.87 | |
SO53195_5 | 100 | 14851 | 225 | 7 | 2023-12-19 | 0.22 | 2023-12-07 | 8.99 | 5 | SO53195 | 2023-12-14 | 0.72 | 6.92 | |
SO50374_1 | 100 | 17787 | 383 | 7 | 2023-08-27 | 25.01 | 2023-08-15 | 1000.44 | 1 | SO50374 | 2023-08-22 | 80.04 | 605.65 | |
SO66858_1 | 100 | 25673 | 530 | 7 | 2024-07-17 | 0.12 | 2024-07-05 | 4.99 | 1 | SO66858 | 2024-07-12 | 0.40 | 1.87 | |
SO44729_1 | 39 | 12307 | 310 | 7 | 2022-03-23 | 89.46 | 2022-03-11 | 3578.27 | 1 | SO44729 | 2022-03-18 | 286.26 | 2171.29 | |
SO68676_3 | 100 | 16203 | 477 | 7 | 2024-08-12 | 0.12 | 2024-07-31 | 4.99 | 3 | SO68676 | 2024-08-07 | 0.40 | 1.87 | |
SO59369_1 | 100 | 25666 | 530 | 7 | 2024-03-28 | 0.12 | 2024-03-16 | 4.99 | 1 | SO59369 | 2024-03-23 | 0.40 | 1.87 | |
SO64030_3 | 100 | 22498 | 480 | 7 | 2024-06-05 | 0.06 | 2024-05-24 | 2.29 | 3 | SO64030 | 2024-05-31 | 0.18 | 0.86 | |
SO49373_1 | 100 | 17752 | 383 | 7 | 2023-06-15 | 25.01 | 2023-06-03 | 1000.44 | 1 | SO49373 | 2023-06-10 | 80.04 | 605.65 | |
SO58316_2 | 100 | 17954 | 528 | 7 | 2024-03-14 | 0.12 | 2024-03-02 | 4.99 | 2 | SO58316 | 2024-03-09 | 0.40 | 1.87 | |
SO71161_1 | 100 | 19945 | 357 | 7 | 2024-09-14 | 58.00 | 2024-09-02 | 2319.99 | 1 | SO71161 | 2024-09-09 | 185.60 | 1265.62 | |
SO66677_3 | 100 | 23749 | 222 | 7 | 2024-07-14 | 0.87 | 2024-07-02 | 34.99 | 3 | SO66677 | 2024-07-09 | 2.80 | 13.09 | |
SO62557_2 | 100 | 11566 | 530 | 7 | 2024-05-15 | 0.12 | 2024-05-03 | 4.99 | 2 | SO62557 | 2024-05-10 | 0.40 | 1.87 | |
SO50031_1 | 100 | 19421 | 343 | 7 | 2023-08-06 | 19.57 | 2023-07-25 | 782.99 | 1 | SO50031 | 2023-08-01 | 62.64 | 486.71 | |
SO56778_2 | 100 | 26882 | 530 | 7 | 2024-02-18 | 0.12 | 2024-02-06 | 4.99 | 2 | SO56778 | 2024-02-13 | 0.40 | 1.87 | |
SO55775_1 | 100 | 18014 | 473 | 7 | 2024-01-30 | 1.59 | 2024-01-18 | 63.50 | 1 | SO55775 | 2024-01-25 | 5.08 | 23.75 | |
SO46161_1 | 100 | 12819 | 311 | 7 | 2022-08-30 | 89.46 | 2022-08-18 | 3578.27 | 1 | SO46161 | 2022-08-25 | 286.26 | 2171.29 | |
SO53815_1 | 100 | 26898 | 541 | 7 | 2023-12-27 | 0.72 | 2023-12-15 | 28.99 | 1 | SO53815 | 2023-12-22 | 2.32 | 10.84 | |
SO62766_1 | 100 | 14141 | 587 | 7 | 2024-05-19 | 19.24 | 2024-05-07 | 769.49 | 1 | SO62766 | 2024-05-14 | 61.56 | 419.78 | |
SO60078_2 | 100 | 15099 | 540 | 7 | 2024-04-07 | 0.82 | 2024-03-26 | 32.60 | 2 | SO60078 | 2024-04-02 | 2.61 | 12.19 | |
SO59203_1 | 100 | 22395 | 606 | 2 | 7 | 2024-03-25 | 13.50 | 2024-03-13 | 539.99 | 1 | SO59203 | 2024-03-20 | 43.20 | 343.65 |
SO66942_3 | 100 | 12395 | 214 | 7 | 2024-07-19 | 0.87 | 2024-07-07 | 34.99 | 3 | SO66942 | 2024-07-14 | 2.80 | 13.09 | |
SO56795_3 | 100 | 12307 | 477 | 7 | 2024-02-18 | 0.12 | 2024-02-06 | 4.99 | 3 | SO56795 | 2024-02-13 | 0.40 | 1.87 | |
SO51317_2 | 100 | 26994 | 479 | 7 | 2023-10-31 | 0.22 | 2023-10-19 | 8.99 | 2 | SO51317 | 2023-10-26 | 0.72 | 3.36 | |
SO59983_1 | 100 | 13605 | 363 | 2 | 7 | 2024-04-06 | 57.37 | 2024-03-25 | 2294.99 | 1 | SO59983 | 2024-04-01 | 183.60 | 1251.98 |
SO53828_1 | 100 | 12296 | 562 | 7 | 2023-12-27 | 59.60 | 2023-12-15 | 2384.07 | 1 | SO53828 | 2023-12-22 | 190.73 | 1481.94 | |
SO64863_2 | 100 | 14154 | 536 | 7 | 2024-06-18 | 0.75 | 2024-06-06 | 29.99 | 2 | SO64863 | 2024-06-13 | 2.40 | 11.22 | |
SO60622_3 | 100 | 22458 | 480 | 7 | 2024-04-15 | 0.06 | 2024-04-03 | 2.29 | 3 | SO60622 | 2024-04-10 | 0.18 | 0.86 | |
SO64706_4 | 100 | 28431 | 486 | 7 | 2024-06-15 | 3.98 | 2024-06-03 | 159.00 | 4 | SO64706 | 2024-06-10 | 12.72 | 59.47 | |
SO57928_1 | 100 | 21099 | 538 | 7 | 2024-03-07 | 0.54 | 2024-02-24 | 21.49 | 1 | SO57928 | 2024-03-02 | 1.72 | 8.04 | |
SO63032_1 | 100 | 26380 | 530 | 7 | 2024-05-23 | 0.12 | 2024-05-11 | 4.99 | 1 | SO63032 | 2024-05-18 | 0.40 | 1.87 | |
SO54849_1 | 100 | 19078 | 528 | 7 | 2024-01-15 | 0.12 | 2024-01-03 | 4.99 | 1 | SO54849 | 2024-01-10 | 0.40 | 1.87 | |
SO65917_2 | 98 | 29445 | 480 | 7 | 2024-07-02 | 0.06 | 2024-06-20 | 2.29 | 2 | SO65917 | 2024-06-27 | 0.18 | 0.86 | |
SO67496_2 | 100 | 16547 | 477 | 7 | 2024-07-26 | 0.12 | 2024-07-14 | 4.99 | 2 | SO67496 | 2024-07-21 | 0.40 | 1.87 | |
SO66564_4 | 100 | 12398 | 217 | 7 | 2024-07-12 | 0.87 | 2024-06-30 | 34.99 | 4 | SO66564 | 2024-07-07 | 2.80 | 13.09 | |
SO68620_3 | 100 | 12132 | 477 | 7 | 2024-08-11 | 0.12 | 2024-07-30 | 4.99 | 3 | SO68620 | 2024-08-06 | 0.40 | 1.87 | |
SO57898_1 | 100 | 21912 | 605 | 7 | 2024-03-06 | 13.50 | 2024-02-23 | 539.99 | 1 | SO57898 | 2024-03-01 | 43.20 | 343.65 | |
SO59861_4 | 100 | 20597 | 234 | 7 | 2024-04-04 | 1.25 | 2024-03-23 | 49.99 | 4 | SO59861 | 2024-03-30 | 4.00 | 38.49 | |
SO54266_4 | 100 | 13555 | 463 | 7 | 2024-01-05 | 0.61 | 2023-12-24 | 24.49 | 4 | SO54266 | 2023-12-31 | 1.96 | 9.16 | |
SO62061_1 | 100 | 22556 | 529 | 7 | 2024-05-07 | 0.10 | 2024-04-25 | 3.99 | 1 | SO62061 | 2024-05-02 | 0.32 | 1.49 | |
SO73045_1 | 100 | 12866 | 363 | 7 | 2024-10-08 | 57.37 | 2024-09-26 | 2294.99 | 1 | SO73045 | 2024-10-03 | 183.60 | 1251.98 | |
SO54958_1 | 100 | 22814 | 477 | 7 | 2024-01-17 | 0.12 | 2024-01-05 | 4.99 | 1 | SO54958 | 2024-01-12 | 0.40 | 1.87 | |
SO68231_1 | 100 | 19444 | 477 | 7 | 2024-08-06 | 0.12 | 2024-07-25 | 4.99 | 1 | SO68231 | 2024-08-01 | 0.40 | 1.87 | |
SO62789_3 | 100 | 15098 | 480 | 7 | 2024-05-19 | 0.06 | 2024-05-07 | 2.29 | 3 | SO62789 | 2024-05-14 | 0.18 | 0.86 | |
SO63655_2 | 100 | 28373 | 540 | 7 | 2024-05-30 | 0.82 | 2024-05-18 | 32.60 | 2 | SO63655 | 2024-05-25 | 2.61 | 12.19 | |
SO63398_2 | 100 | 22314 | 489 | 7 | 2024-05-26 | 1.35 | 2024-05-14 | 53.99 | 2 | SO63398 | 2024-05-21 | 4.32 | 41.57 | |
SO56632_3 | 100 | 26927 | 480 | 2 | 7 | 2024-02-15 | 0.06 | 2024-02-03 | 2.29 | 3 | SO56632 | 2024-02-10 | 0.18 | 0.86 |
SO47155_1 | 100 | 13801 | 370 | 7 | 2022-12-04 | 61.08 | 2022-11-22 | 2443.35 | 1 | SO47155 | 2022-11-29 | 195.47 | 1518.79 | |
SO67959_4 | 100 | 15678 | 225 | 7 | 2024-08-01 | 0.22 | 2024-07-20 | 8.99 | 4 | SO67959 | 2024-07-27 | 0.72 | 6.92 | |
SO54877_3 | 100 | 29412 | 538 | 7 | 2024-01-15 | 0.54 | 2024-01-03 | 21.49 | 3 | SO54877 | 2024-01-10 | 1.72 | 8.04 | |
SO64339_2 | 100 | 16322 | 529 | 7 | 2024-06-10 | 0.10 | 2024-05-29 | 3.99 | 2 | SO64339 | 2024-06-05 | 0.32 | 1.49 | |
SO73779_1 | 100 | 28750 | 388 | 7 | 2024-10-17 | 28.01 | 2024-10-05 | 1120.49 | 1 | SO73779 | 2024-10-12 | 89.64 | 713.08 | |
SO58474_2 | 100 | 11590 | 478 | 7 | 2024-03-17 | 0.25 | 2024-03-05 | 9.99 | 2 | SO58474 | 2024-03-12 | 0.80 | 3.74 | |
SO66381_1 | 100 | 14538 | 588 | 7 | 2024-07-10 | 19.24 | 2024-06-28 | 769.49 | 1 | SO66381 | 2024-07-05 | 61.56 | 419.78 | |
SO68001_4 | 100 | 24076 | 214 | 7 | 2024-08-02 | 0.87 | 2024-07-21 | 34.99 | 4 | SO68001 | 2024-07-28 | 2.80 | 13.09 | |
SO68436_3 | 100 | 26943 | 222 | 7 | 2024-08-09 | 0.87 | 2024-07-28 | 34.99 | 3 | SO68436 | 2024-08-04 | 2.80 | 13.09 | |
SO72124_2 | 100 | 24056 | 529 | 7 | 2024-09-25 | 0.10 | 2024-09-13 | 3.99 | 2 | SO72124 | 2024-09-20 | 0.32 | 1.49 | |
SO68622_1 | 100 | 25479 | 583 | 7 | 2024-08-11 | 42.52 | 2024-07-30 | 1700.99 | 1 | SO68622 | 2024-08-06 | 136.08 | 1082.51 | |
SO56097_1 | 100 | 24693 | 530 | 7 | 2024-02-05 | 0.12 | 2024-01-24 | 4.99 | 1 | SO56097 | 2024-01-31 | 0.40 | 1.87 | |
SO63958_1 | 100 | 15931 | 357 | 7 | 2024-06-04 | 58.00 | 2024-05-23 | 2319.99 | 1 | SO63958 | 2024-05-30 | 185.60 | 1265.62 | |
SO59411_3 | 100 | 22524 | 480 | 7 | 2024-03-29 | 0.06 | 2024-03-17 | 2.29 | 3 | SO59411 | 2024-03-24 | 0.18 | 0.86 | |
SO60622_2 | 100 | 22458 | 538 | 7 | 2024-04-15 | 0.54 | 2024-04-03 | 21.49 | 2 | SO60622 | 2024-04-10 | 1.72 | 8.04 | |
SO54715_2 | 100 | 24110 | 225 | 7 | 2024-01-12 | 0.22 | 2023-12-31 | 8.99 | 2 | SO54715 | 2024-01-07 | 0.72 | 6.92 | |
SO74806_1 | 100 | 19063 | 535 | 7 | 2024-11-12 | 0.62 | 2024-10-31 | 24.99 | 1 | SO74806 | 2024-11-07 | 2.00 | 9.35 | |
SO48703_1 | 100 | 15004 | 369 | 2 | 7 | 2023-04-22 | 61.08 | 2023-04-10 | 2443.35 | 1 | SO48703 | 2023-04-17 | 195.47 | 1518.79 |
SO51906_1 | 100 | 23962 | 541 | 7 | 2023-11-23 | 0.72 | 2023-11-11 | 28.99 | 1 | SO51906 | 2023-11-18 | 2.32 | 10.84 | |
SO47463_1 | 100 | 14203 | 373 | 7 | 2022-12-25 | 54.54 | 2022-12-13 | 2181.56 | 1 | SO47463 | 2022-12-20 | 174.53 | 1320.68 | |
SO57284_2 | 100 | 11352 | 477 | 7 | 2024-02-24 | 0.12 | 2024-02-12 | 4.99 | 2 | SO57284 | 2024-02-19 | 0.40 | 1.87 | |
SO59490_1 | 100 | 12333 | 363 | 7 | 2024-03-30 | 57.37 | 2024-03-18 | 2294.99 | 1 | SO59490 | 2024-03-25 | 183.60 | 1251.98 | |
SO72653_1 | 100 | 17780 | 353 | 2 | 7 | 2024-10-03 | 58.00 | 2024-09-21 | 2319.99 | 1 | SO72653 | 2024-09-28 | 185.60 | 1265.62 |
SO53815_2 | 100 | 26898 | 530 | 7 | 2023-12-27 | 0.12 | 2023-12-15 | 4.99 | 2 | SO53815 | 2023-12-22 | 0.40 | 1.87 | |
SO65057_2 | 100 | 25518 | 214 | 7 | 2024-06-21 | 0.87 | 2024-06-09 | 34.99 | 2 | SO65057 | 2024-06-16 | 2.80 | 13.09 | |
SO68050_2 | 100 | 16202 | 529 | 7 | 2024-08-03 | 0.10 | 2024-07-22 | 3.99 | 2 | SO68050 | 2024-07-29 | 0.32 | 1.49 | |
SO71484_1 | 100 | 20894 | 388 | 7 | 2024-09-18 | 28.01 | 2024-09-06 | 1120.49 | 1 | SO71484 | 2024-09-13 | 89.64 | 713.08 | |
SO75028_1 | 100 | 23934 | 541 | 7 | 2024-11-19 | 0.72 | 2024-11-07 | 28.99 | 1 | SO75028 | 2024-11-14 | 2.32 | 10.84 | |
SO59490_2 | 100 | 12333 | 478 | 7 | 2024-03-30 | 0.25 | 2024-03-18 | 9.99 | 2 | SO59490 | 2024-03-25 | 0.80 | 3.74 | |
SO53763_1 | 100 | 26225 | 571 | 13 | 7 | 2023-12-26 | 18.56 | 2023-12-14 | 742.35 | 1 | SO53763 | 2023-12-21 | 59.39 | 461.44 |
SO62514_3 | 100 | 26976 | 477 | 7 | 2024-05-14 | 0.12 | 2024-05-02 | 4.99 | 3 | SO62514 | 2024-05-09 | 0.40 | 1.87 | |
SO47556_1 | 100 | 14701 | 379 | 7 | 2023-01-07 | 54.54 | 2022-12-26 | 2181.56 | 1 | SO47556 | 2023-01-02 | 174.53 | 1320.68 | |
SO71996_5 | 100 | 11420 | 217 | 7 | 2024-09-23 | 0.87 | 2024-09-11 | 34.99 | 5 | SO71996 | 2024-09-18 | 2.80 | 13.09 | |
SO66020_2 | 100 | 16205 | 485 | 7 | 2024-07-04 | 0.55 | 2024-06-22 | 21.98 | 2 | SO66020 | 2024-06-29 | 1.76 | 8.22 | |
SO64092_1 | 100 | 14932 | 528 | 7 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 1 | SO64092 | 2024-06-01 | 0.40 | 1.87 | |
SO73861_2 | 100 | 19297 | 237 | 7 | 2024-10-18 | 1.25 | 2024-10-06 | 49.99 | 2 | SO73861 | 2024-10-13 | 4.00 | 38.49 | |
SO72125_4 | 100 | 24029 | 481 | 7 | 2024-09-25 | 0.22 | 2024-09-13 | 8.99 | 4 | SO72125 | 2024-09-20 | 0.72 | 3.36 | |
SO54960_2 | 100 | 27966 | 214 | 7 | 2024-01-17 | 0.87 | 2024-01-05 | 34.99 | 2 | SO54960 | 2024-01-12 | 2.80 | 13.09 | |
SO64340_1 | 100 | 21521 | 528 | 7 | 2024-06-10 | 0.12 | 2024-05-29 | 4.99 | 1 | SO64340 | 2024-06-05 | 0.40 | 1.87 | |
SO59286_3 | 100 | 14944 | 478 | 7 | 2024-03-27 | 0.25 | 2024-03-15 | 9.99 | 3 | SO59286 | 2024-03-22 | 0.80 | 3.74 | |
SO67930_1 | 100 | 19374 | 477 | 7 | 2024-08-01 | 0.12 | 2024-07-20 | 4.99 | 1 | SO67930 | 2024-07-27 | 0.40 | 1.87 |
Generated 2024-11-10 23:44:20.590 UTC