[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > SHUFFLE < SKIP 166 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56345_3 | 6 | 11123 | 484 | 9 | 2024-02-10 | 0.20 | 2024-01-29 | 7.95 | 3 | SO56345 | 2024-02-05 | 0.64 | 2.97 | |
SO70522_1 | 6 | 13077 | 563 | 9 | 2024-09-04 | 59.60 | 2024-08-23 | 2384.07 | 1 | SO70522 | 2024-08-30 | 190.73 | 1481.94 | |
SO61920_5 | 6 | 11766 | 225 | 9 | 2024-05-04 | 0.22 | 2024-04-22 | 8.99 | 5 | SO61920 | 2024-04-29 | 0.72 | 6.92 | |
SO66947_1 | 6 | 17301 | 539 | 9 | 2024-07-19 | 0.62 | 2024-07-07 | 24.99 | 1 | SO66947 | 2024-07-14 | 2.00 | 9.35 | |
SO66520_1 | 6 | 13159 | 477 | 9 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 1 | SO66520 | 2024-07-07 | 0.40 | 1.87 | |
SO71557_2 | 6 | 28091 | 222 | 9 | 2024-09-19 | 0.87 | 2024-09-07 | 34.99 | 2 | SO71557 | 2024-09-14 | 2.80 | 13.09 | |
SO63605_3 | 6 | 14032 | 477 | 9 | 2024-05-29 | 0.12 | 2024-05-17 | 4.99 | 3 | SO63605 | 2024-05-24 | 0.40 | 1.87 | |
SO56424_1 | 6 | 22966 | 581 | 9 | 2024-02-11 | 42.52 | 2024-01-30 | 1700.99 | 1 | SO56424 | 2024-02-06 | 136.08 | 1082.51 | |
SO46421_1 | 6 | 25949 | 336 | 9 | 2022-09-27 | 17.48 | 2022-09-15 | 699.10 | 1 | SO46421 | 2022-09-22 | 55.93 | 413.15 | |
SO54760_2 | 6 | 16741 | 217 | 9 | 2024-01-13 | 0.87 | 2024-01-01 | 34.99 | 2 | SO54760 | 2024-01-08 | 2.80 | 13.09 | |
SO47636_1 | 6 | 26142 | 331 | 9 | 2023-01-18 | 19.57 | 2023-01-06 | 782.99 | 1 | SO47636 | 2023-01-13 | 62.64 | 486.71 | |
SO63817_3 | 6 | 11952 | 477 | 9 | 2024-06-01 | 0.12 | 2024-05-20 | 4.99 | 3 | SO63817 | 2024-05-27 | 0.40 | 1.87 | |
SO62403_1 | 6 | 19962 | 538 | 9 | 2024-05-13 | 0.54 | 2024-05-01 | 21.49 | 1 | SO62403 | 2024-05-08 | 1.72 | 8.04 | |
SO58575_4 | 6 | 19790 | 491 | 9 | 2024-03-18 | 1.35 | 2024-03-06 | 53.99 | 4 | SO58575 | 2024-03-13 | 4.32 | 41.57 | |
SO57416_1 | 6 | 28308 | 604 | 9 | 2024-02-26 | 13.50 | 2024-02-14 | 539.99 | 1 | SO57416 | 2024-02-21 | 43.20 | 343.65 | |
SO56489_2 | 6 | 17052 | 536 | 9 | 2024-02-13 | 0.75 | 2024-02-01 | 29.99 | 2 | SO56489 | 2024-02-08 | 2.40 | 11.22 | |
SO70460_3 | 6 | 25013 | 487 | 9 | 2024-09-04 | 1.37 | 2024-08-23 | 54.99 | 3 | SO70460 | 2024-08-30 | 4.40 | 20.57 | |
SO62471_2 | 6 | 13981 | 480 | 9 | 2024-05-14 | 0.06 | 2024-05-02 | 2.29 | 2 | SO62471 | 2024-05-09 | 0.18 | 0.86 | |
SO56748_1 | 6 | 29113 | 562 | 9 | 2024-02-17 | 59.60 | 2024-02-05 | 2384.07 | 1 | SO56748 | 2024-02-12 | 190.73 | 1481.94 | |
SO45838_1 | 6 | 20213 | 311 | 9 | 2022-07-27 | 89.46 | 2022-07-15 | 3578.27 | 1 | SO45838 | 2022-07-22 | 286.26 | 2171.29 | |
SO64859_1 | 6 | 15031 | 225 | 9 | 2024-06-18 | 0.22 | 2024-06-06 | 8.99 | 1 | SO64859 | 2024-06-13 | 0.72 | 6.92 | |
SO68738_2 | 6 | 12999 | 214 | 9 | 2024-08-13 | 0.87 | 2024-08-01 | 34.99 | 2 | SO68738 | 2024-08-08 | 2.80 | 13.09 | |
SO64775_2 | 6 | 25112 | 217 | 9 | 2024-06-16 | 0.87 | 2024-06-04 | 34.99 | 2 | SO64775 | 2024-06-11 | 2.80 | 13.09 | |
SO67554_4 | 6 | 25558 | 488 | 9 | 2024-07-26 | 1.35 | 2024-07-14 | 53.99 | 4 | SO67554 | 2024-07-21 | 4.32 | 41.57 | |
SO64616_2 | 6 | 23543 | 484 | 9 | 2024-06-14 | 0.20 | 2024-06-02 | 7.95 | 2 | SO64616 | 2024-06-09 | 0.64 | 2.97 | |
SO48470_1 | 6 | 23105 | 379 | 9 | 2023-03-31 | 54.54 | 2023-03-19 | 2181.56 | 1 | SO48470 | 2023-03-26 | 174.53 | 1320.68 | |
SO60643_2 | 6 | 19955 | 225 | 9 | 2024-04-16 | 0.22 | 2024-04-04 | 8.99 | 2 | SO60643 | 2024-04-11 | 0.72 | 6.92 | |
SO65669_2 | 6 | 21404 | 463 | 9 | 2024-06-28 | 0.61 | 2024-06-16 | 24.49 | 2 | SO65669 | 2024-06-23 | 1.96 | 9.16 | |
SO64658_1 | 6 | 15037 | 581 | 9 | 2024-06-14 | 42.52 | 2024-06-02 | 1700.99 | 1 | SO64658 | 2024-06-09 | 136.08 | 1082.51 | |
SO71690_4 | 6 | 25714 | 487 | 9 | 2024-09-21 | 1.37 | 2024-09-09 | 54.99 | 4 | SO71690 | 2024-09-16 | 4.40 | 20.57 | |
SO50834_1 | 6 | 24598 | 369 | 2 | 9 | 2023-09-29 | 61.08 | 2023-09-17 | 2443.35 | 1 | SO50834 | 2023-09-24 | 195.47 | 1518.79 |
SO56109_1 | 6 | 20996 | 606 | 2 | 9 | 2024-02-05 | 13.50 | 2024-01-24 | 539.99 | 1 | SO56109 | 2024-01-31 | 43.20 | 343.65 |
SO55084_2 | 6 | 11904 | 485 | 9 | 2024-01-19 | 0.55 | 2024-01-07 | 21.98 | 2 | SO55084 | 2024-01-14 | 1.76 | 8.22 | |
SO73924_4 | 6 | 11048 | 489 | 9 | 2024-10-19 | 1.35 | 2024-10-07 | 53.99 | 4 | SO73924 | 2024-10-14 | 4.32 | 41.57 | |
SO70357_2 | 6 | 22181 | 479 | 9 | 2024-09-02 | 0.22 | 2024-08-21 | 8.99 | 2 | SO70357 | 2024-08-28 | 0.72 | 3.36 | |
SO58718_1 | 6 | 14074 | 540 | 9 | 2024-03-21 | 0.82 | 2024-03-09 | 32.60 | 1 | SO58718 | 2024-03-16 | 2.61 | 12.19 | |
SO70376_2 | 6 | 21956 | 484 | 9 | 2024-09-03 | 0.20 | 2024-08-22 | 7.95 | 2 | SO70376 | 2024-08-29 | 0.64 | 2.97 | |
SO70673_2 | 6 | 27870 | 214 | 9 | 2024-09-06 | 0.87 | 2024-08-25 | 34.99 | 2 | SO70673 | 2024-09-01 | 2.80 | 13.09 | |
SO53123_1 | 6 | 19770 | 605 | 9 | 2023-12-17 | 13.50 | 2023-12-05 | 539.99 | 1 | SO53123 | 2023-12-12 | 43.20 | 343.65 | |
SO67843_3 | 6 | 21884 | 217 | 9 | 2024-07-31 | 0.87 | 2024-07-19 | 34.99 | 3 | SO67843 | 2024-07-26 | 2.80 | 13.09 | |
SO57541_2 | 6 | 27518 | 489 | 9 | 2024-02-29 | 1.35 | 2024-02-17 | 53.99 | 2 | SO57541 | 2024-02-24 | 4.32 | 41.57 | |
SO63295_2 | 6 | 19608 | 529 | 9 | 2024-05-25 | 0.10 | 2024-05-13 | 3.99 | 2 | SO63295 | 2024-05-20 | 0.32 | 1.49 | |
SO73345_1 | 6 | 13623 | 487 | 9 | 2024-10-12 | 1.37 | 2024-09-30 | 54.99 | 1 | SO73345 | 2024-10-07 | 4.40 | 20.57 | |
SO48435_1 | 6 | 22953 | 377 | 9 | 2023-03-27 | 54.54 | 2023-03-15 | 2181.56 | 1 | SO48435 | 2023-03-22 | 174.53 | 1320.68 | |
SO61791_1 | 6 | 18305 | 540 | 9 | 2024-05-03 | 0.82 | 2024-04-21 | 32.60 | 1 | SO61791 | 2024-04-28 | 2.61 | 12.19 | |
SO56761_2 | 6 | 25217 | 222 | 9 | 2024-02-18 | 0.87 | 2024-02-06 | 34.99 | 2 | SO56761 | 2024-02-13 | 2.80 | 13.09 | |
SO63758_4 | 6 | 20621 | 217 | 9 | 2024-06-01 | 0.87 | 2024-05-20 | 34.99 | 4 | SO63758 | 2024-05-27 | 2.80 | 13.09 | |
SO52366_1 | 6 | 19954 | 529 | 9 | 2023-12-03 | 0.10 | 2023-11-21 | 3.99 | 1 | SO52366 | 2023-11-28 | 0.32 | 1.49 | |
SO74876_2 | 100 | 25137 | 480 | 9 | 2024-11-15 | 0.06 | 2024-11-03 | 2.29 | 2 | SO74876 | 2024-11-10 | 0.18 | 0.86 | |
SO45949_1 | 6 | 19970 | 310 | 9 | 2022-08-13 | 89.46 | 2022-08-01 | 3578.27 | 1 | SO45949 | 2022-08-08 | 286.26 | 2171.29 | |
SO54593_1 | 6 | 11071 | 478 | 9 | 2024-01-11 | 0.25 | 2023-12-30 | 9.99 | 1 | SO54593 | 2024-01-06 | 0.80 | 3.74 | |
SO56439_1 | 6 | 16178 | 529 | 9 | 2024-02-12 | 0.10 | 2024-01-31 | 3.99 | 1 | SO56439 | 2024-02-07 | 0.32 | 1.49 | |
SO74097_1 | 6 | 11371 | 535 | 9 | 2024-10-22 | 0.62 | 2024-10-10 | 24.99 | 1 | SO74097 | 2024-10-17 | 2.00 | 9.35 | |
SO47348_1 | 6 | 26028 | 331 | 9 | 2022-12-23 | 19.57 | 2022-12-11 | 782.99 | 1 | SO47348 | 2022-12-18 | 62.64 | 486.71 | |
SO48204_1 | 6 | 26445 | 335 | 9 | 2023-03-14 | 19.57 | 2023-03-02 | 782.99 | 1 | SO48204 | 2023-03-09 | 62.64 | 486.71 | |
SO69089_2 | 6 | 12700 | 222 | 9 | 2024-08-18 | 0.87 | 2024-08-06 | 34.99 | 2 | SO69089 | 2024-08-13 | 2.80 | 13.09 | |
SO67390_3 | 6 | 15135 | 477 | 9 | 2024-07-24 | 0.12 | 2024-07-12 | 4.99 | 3 | SO67390 | 2024-07-19 | 0.40 | 1.87 | |
SO69066_2 | 6 | 17923 | 490 | 9 | 2024-08-18 | 1.35 | 2024-08-06 | 53.99 | 2 | SO69066 | 2024-08-13 | 4.32 | 41.57 | |
SO49754_1 | 6 | 14303 | 360 | 9 | 2023-07-15 | 51.23 | 2023-07-03 | 2049.10 | 1 | SO49754 | 2023-07-10 | 163.93 | 1105.81 | |
SO51059_1 | 6 | 15734 | 352 | 9 | 2023-10-20 | 51.79 | 2023-10-08 | 2071.42 | 1 | SO51059 | 2023-10-15 | 165.71 | 1117.86 | |
SO53079_1 | 6 | 16168 | 540 | 9 | 2023-12-17 | 0.82 | 2023-12-05 | 32.60 | 1 | SO53079 | 2023-12-12 | 2.61 | 12.19 | |
SO72513_1 | 6 | 28120 | 606 | 9 | 2024-09-30 | 13.50 | 2024-09-18 | 539.99 | 1 | SO72513 | 2024-09-25 | 43.20 | 343.65 | |
SO66548_3 | 6 | 21559 | 477 | 9 | 2024-07-12 | 0.12 | 2024-06-30 | 4.99 | 3 | SO66548 | 2024-07-07 | 0.40 | 1.87 | |
SO72849_1 | 6 | 11920 | 564 | 9 | 2024-10-05 | 59.60 | 2024-09-23 | 2384.07 | 1 | SO72849 | 2024-09-30 | 190.73 | 1481.94 | |
SO64686_1 | 6 | 11073 | 477 | 9 | 2024-06-15 | 0.12 | 2024-06-03 | 4.99 | 1 | SO64686 | 2024-06-10 | 0.40 | 1.87 | |
SO69709_2 | 6 | 15785 | 487 | 9 | 2024-08-24 | 1.37 | 2024-08-12 | 54.99 | 2 | SO69709 | 2024-08-19 | 4.40 | 20.57 | |
SO49199_1 | 6 | 26667 | 337 | 9 | 2023-05-28 | 19.57 | 2023-05-16 | 782.99 | 1 | SO49199 | 2023-05-23 | 62.64 | 486.71 | |
SO56788_4 | 6 | 12009 | 463 | 9 | 2024-02-18 | 0.61 | 2024-02-06 | 24.49 | 4 | SO56788 | 2024-02-13 | 1.96 | 9.16 | |
SO70149_2 | 6 | 22909 | 217 | 9 | 2024-08-30 | 0.87 | 2024-08-18 | 34.99 | 2 | SO70149 | 2024-08-25 | 2.80 | 13.09 | |
SO53725_1 | 6 | 26139 | 538 | 9 | 2023-12-26 | 0.54 | 2023-12-14 | 21.49 | 1 | SO53725 | 2023-12-21 | 1.72 | 8.04 | |
SO67487_1 | 6 | 16690 | 536 | 9 | 2024-07-26 | 0.75 | 2024-07-14 | 29.99 | 1 | SO67487 | 2024-07-21 | 2.40 | 11.22 | |
SO61920_1 | 6 | 11766 | 576 | 9 | 2024-05-04 | 59.60 | 2024-04-22 | 2384.07 | 1 | SO61920 | 2024-04-29 | 190.73 | 1481.94 | |
SO57696_1 | 6 | 25130 | 528 | 9 | 2024-03-03 | 0.12 | 2024-02-20 | 4.99 | 1 | SO57696 | 2024-02-27 | 0.40 | 1.87 | |
SO63822_2 | 6 | 29096 | 214 | 9 | 2024-06-01 | 0.87 | 2024-05-20 | 34.99 | 2 | SO63822 | 2024-05-27 | 2.80 | 13.09 | |
SO60817_1 | 6 | 22410 | 606 | 9 | 2024-04-18 | 13.50 | 2024-04-06 | 539.99 | 1 | SO60817 | 2024-04-13 | 43.20 | 343.65 | |
SO70509_2 | 6 | 21985 | 490 | 9 | 2024-09-04 | 1.35 | 2024-08-23 | 53.99 | 2 | SO70509 | 2024-08-30 | 4.32 | 41.57 | |
SO56964_1 | 6 | 27496 | 528 | 9 | 2024-02-22 | 0.12 | 2024-02-10 | 4.99 | 1 | SO56964 | 2024-02-17 | 0.40 | 1.87 | |
SO46299_1 | 6 | 20264 | 314 | 9 | 2022-09-17 | 89.46 | 2022-09-05 | 3578.27 | 1 | SO46299 | 2022-09-12 | 286.26 | 2171.29 | |
SO61429_1 | 6 | 20616 | 372 | 9 | 2024-04-27 | 61.08 | 2024-04-15 | 2443.35 | 1 | SO61429 | 2024-04-22 | 195.47 | 1554.95 | |
SO63552_3 | 6 | 16733 | 480 | 9 | 2024-05-29 | 0.06 | 2024-05-17 | 2.29 | 3 | SO63552 | 2024-05-24 | 0.18 | 0.86 | |
SO61970_3 | 6 | 27877 | 477 | 9 | 2024-05-05 | 0.12 | 2024-04-23 | 4.99 | 3 | SO61970 | 2024-04-30 | 0.40 | 1.87 | |
SO69990_1 | 6 | 15767 | 359 | 9 | 2024-08-28 | 57.37 | 2024-08-16 | 2294.99 | 1 | SO69990 | 2024-08-23 | 183.60 | 1251.98 | |
SO59277_1 | 6 | 16173 | 529 | 9 | 2024-03-27 | 0.10 | 2024-03-15 | 3.99 | 1 | SO59277 | 2024-03-22 | 0.32 | 1.49 | |
SO47328_1 | 6 | 12681 | 360 | 9 | 2022-12-21 | 51.23 | 2022-12-09 | 2049.10 | 1 | SO47328 | 2022-12-16 | 163.93 | 1105.81 | |
SO59459_2 | 6 | 20216 | 463 | 9 | 2024-03-29 | 0.61 | 2024-03-17 | 24.49 | 2 | SO59459 | 2024-03-24 | 1.96 | 9.16 | |
SO57305_3 | 6 | 24362 | 529 | 9 | 2024-02-25 | 0.10 | 2024-02-13 | 3.99 | 3 | SO57305 | 2024-02-20 | 0.32 | 1.49 | |
SO55494_2 | 6 | 20823 | 222 | 9 | 2024-01-25 | 0.87 | 2024-01-13 | 34.99 | 2 | SO55494 | 2024-01-20 | 2.80 | 13.09 | |
SO59902_3 | 6 | 11460 | 530 | 9 | 2024-04-04 | 0.12 | 2024-03-23 | 4.99 | 3 | SO59902 | 2024-03-30 | 0.40 | 1.87 | |
SO65667_1 | 6 | 15043 | 583 | 9 | 2024-06-28 | 42.52 | 2024-06-16 | 1700.99 | 1 | SO65667 | 2024-06-23 | 136.08 | 1082.51 | |
SO69796_1 | 6 | 11966 | 535 | 9 | 2024-08-26 | 0.62 | 2024-08-14 | 24.99 | 1 | SO69796 | 2024-08-21 | 2.00 | 9.35 | |
SO53174_2 | 6 | 22946 | 529 | 9 | 2023-12-18 | 0.10 | 2023-12-06 | 3.99 | 2 | SO53174 | 2023-12-13 | 0.32 | 1.49 | |
SO63477_3 | 6 | 24003 | 234 | 9 | 2024-05-27 | 1.25 | 2024-05-15 | 49.99 | 3 | SO63477 | 2024-05-22 | 4.00 | 38.49 | |
SO55030_2 | 6 | 18490 | 484 | 9 | 2024-01-19 | 0.20 | 2024-01-07 | 7.95 | 2 | SO55030 | 2024-01-14 | 0.64 | 2.97 | |
SO48147_1 | 6 | 22845 | 377 | 9 | 2023-03-04 | 54.54 | 2023-02-20 | 2181.56 | 1 | SO48147 | 2023-02-27 | 174.53 | 1320.68 | |
SO56785_1 | 6 | 16708 | 587 | 9 | 2024-02-18 | 19.24 | 2024-02-06 | 769.49 | 1 | SO56785 | 2024-02-13 | 61.56 | 419.78 | |
SO59902_2 | 6 | 11460 | 541 | 9 | 2024-04-04 | 0.72 | 2024-03-23 | 28.99 | 2 | SO59902 | 2024-03-30 | 2.32 | 10.84 | |
SO51338_1 | 6 | 16339 | 382 | 9 | 2023-11-02 | 28.01 | 2023-10-21 | 1120.49 | 1 | SO51338 | 2023-10-28 | 89.64 | 713.08 | |
SO56112_5 | 6 | 19595 | 467 | 9 | 2024-02-05 | 0.61 | 2024-01-24 | 24.49 | 5 | SO56112 | 2024-01-31 | 1.96 | 9.16 | |
SO73640_2 | 6 | 13631 | 477 | 9 | 2024-10-15 | 0.12 | 2024-10-03 | 4.99 | 2 | SO73640 | 2024-10-10 | 0.40 | 1.87 | |
SO73652_2 | 6 | 19617 | 530 | 9 | 2024-10-16 | 0.12 | 2024-10-04 | 4.99 | 2 | SO73652 | 2024-10-11 | 0.40 | 1.87 | |
SO61099_2 | 6 | 16615 | 528 | 9 | 2024-04-23 | 0.12 | 2024-04-11 | 4.99 | 2 | SO61099 | 2024-04-18 | 0.40 | 1.87 | |
SO44575_1 | 6 | 11110 | 344 | 9 | 2022-02-23 | 85.00 | 2022-02-11 | 3399.99 | 1 | SO44575 | 2022-02-18 | 272.00 | 1912.15 | |
SO49439_1 | 6 | 14064 | 356 | 9 | 2023-06-22 | 51.79 | 2023-06-10 | 2071.42 | 1 | SO49439 | 2023-06-17 | 165.71 | 1117.86 | |
SO63620_4 | 6 | 23992 | 486 | 9 | 2024-05-29 | 3.98 | 2024-05-17 | 159.00 | 4 | SO63620 | 2024-05-24 | 12.72 | 59.47 | |
SO57418_3 | 6 | 11000 | 530 | 9 | 2024-02-26 | 0.12 | 2024-02-14 | 4.99 | 3 | SO57418 | 2024-02-21 | 0.40 | 1.87 | |
SO54808_1 | 6 | 16745 | 372 | 9 | 2024-01-14 | 61.08 | 2024-01-02 | 2443.35 | 1 | SO54808 | 2024-01-09 | 195.47 | 1554.95 | |
SO60464_1 | 6 | 19091 | 480 | 9 | 2024-04-13 | 0.06 | 2024-04-01 | 2.29 | 1 | SO60464 | 2024-04-08 | 0.18 | 0.86 | |
SO65615_2 | 6 | 14238 | 478 | 9 | 2024-06-27 | 0.25 | 2024-06-15 | 9.99 | 2 | SO65615 | 2024-06-22 | 0.80 | 3.74 | |
SO50135_1 | 6 | 15037 | 354 | 9 | 2023-08-17 | 51.79 | 2023-08-05 | 2071.42 | 1 | SO50135 | 2023-08-12 | 165.71 | 1117.86 | |
SO61654_4 | 6 | 11894 | 214 | 9 | 2024-04-30 | 0.87 | 2024-04-18 | 34.99 | 4 | SO61654 | 2024-04-25 | 2.80 | 13.09 | |
SO60846_1 | 6 | 17313 | 225 | 9 | 2024-04-19 | 0.22 | 2024-04-07 | 8.99 | 1 | SO60846 | 2024-04-14 | 0.72 | 6.92 | |
SO52719_1 | 6 | 28326 | 575 | 9 | 2023-12-09 | 59.60 | 2023-11-27 | 2384.07 | 1 | SO52719 | 2023-12-04 | 190.73 | 1481.94 |
Generated 2024-11-10 20:23:14.330 UTC