[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL SHUFFLE < SKIP 409 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44215_1 | 100 | 28180 | 312 | 1 | 2021-11-22 | 89.46 | 2021-11-10 | 3578.27 | 1 | SO44215 | 2021-11-17 | 286.26 | 2171.29 | |
SO73700_1 | 19 | 23057 | 575 | 6 | 2024-08-27 | 59.60 | 2024-08-15 | 2384.07 | 1 | SO73700 | 2024-08-22 | 190.73 | 1481.94 | |
SO66026_1 | 6 | 27144 | 537 | 9 | 2024-05-15 | 0.88 | 2024-05-03 | 35.00 | 1 | SO66026 | 2024-05-10 | 2.80 | 13.09 | |
SO59698_1 | 100 | 25765 | 562 | 1 | 2024-02-11 | 59.60 | 2024-01-30 | 2384.07 | 1 | SO59698 | 2024-02-06 | 190.73 | 1481.94 | |
SO73428_2 | 100 | 11429 | 488 | 7 | 2024-08-24 | 1.35 | 2024-08-12 | 53.99 | 2 | SO73428 | 2024-08-19 | 4.32 | 41.57 | |
SO66425_2 | 100 | 21344 | 222 | 4 | 2024-05-21 | 0.87 | 2024-05-09 | 34.99 | 2 | SO66425 | 2024-05-16 | 2.80 | 13.09 | |
SO61151_1 | 19 | 22995 | 378 | 6 | 2024-03-04 | 61.08 | 2024-02-21 | 2443.35 | 1 | SO61151 | 2024-02-28 | 195.47 | 1554.95 | |
SO64902_2 | 6 | 14318 | 465 | 9 | 2024-04-30 | 0.61 | 2024-04-18 | 24.49 | 2 | SO64902 | 2024-04-25 | 1.96 | 9.16 | |
SO66937_2 | 100 | 23520 | 225 | 1 | 2024-05-29 | 0.22 | 2024-05-17 | 8.99 | 2 | SO66937 | 2024-05-24 | 0.72 | 6.92 | |
SO59116_3 | 100 | 11796 | 478 | 4 | 2024-02-03 | 0.25 | 2024-01-22 | 9.99 | 3 | SO59116 | 2024-01-29 | 0.80 | 3.74 | |
SO66830_1 | 6 | 21964 | 537 | 9 | 2024-05-28 | 0.88 | 2024-05-16 | 35.00 | 1 | SO66830 | 2024-05-23 | 2.80 | 13.09 | |
SO51037_1 | 98 | 21668 | 323 | 10 | 2023-08-29 | 19.57 | 2023-08-17 | 782.99 | 1 | SO51037 | 2023-08-24 | 62.64 | 486.71 | |
SO48260_1 | 19 | 27099 | 323 | 6 | 2023-01-30 | 19.57 | 2023-01-18 | 782.99 | 1 | SO48260 | 2023-01-25 | 62.64 | 486.71 | |
SO65759_1 | 100 | 27034 | 530 | 1 | 2024-05-11 | 0.12 | 2024-04-29 | 4.99 | 1 | SO65759 | 2024-05-06 | 0.40 | 1.87 | |
SO56453_1 | 100 | 20353 | 475 | 4 | 2023-12-24 | 1.75 | 2023-12-12 | 69.99 | 1 | SO56453 | 2023-12-19 | 5.60 | 26.18 | |
SO58191_1 | 98 | 28415 | 575 | 10 | 2024-01-21 | 59.60 | 2024-01-09 | 2384.07 | 1 | SO58191 | 2024-01-16 | 190.73 | 1481.94 | |
SO52066_3 | 100 | 12533 | 225 | 1 | 2023-10-08 | 0.22 | 2023-09-26 | 8.99 | 3 | SO52066 | 2023-10-03 | 0.72 | 6.92 | |
SO67752_2 | 100 | 25977 | 217 | 4 | 2024-06-09 | 0.87 | 2024-05-28 | 34.99 | 2 | SO67752 | 2024-06-04 | 2.80 | 13.09 | |
SO59171_3 | 98 | 12508 | 225 | 10 | 2024-02-04 | 0.22 | 2024-01-23 | 8.99 | 3 | SO59171 | 2024-01-30 | 0.72 | 6.92 | |
SO57617_1 | 98 | 22798 | 539 | 10 | 2024-01-11 | 0.62 | 2023-12-30 | 24.99 | 1 | SO57617 | 2024-01-06 | 2.00 | 9.35 | |
SO67000_3 | 100 | 27142 | 477 | 7 | 2024-05-30 | 0.12 | 2024-05-18 | 4.99 | 3 | SO67000 | 2024-05-25 | 0.40 | 1.87 | |
SO69715_3 | 100 | 18801 | 471 | 4 | 2024-07-05 | 1.59 | 2024-06-23 | 63.50 | 3 | SO69715 | 2024-06-30 | 5.08 | 23.75 | |
SO53960_1 | 100 | 12908 | 472 | 1 | 2023-11-10 | 1.59 | 2023-10-29 | 63.50 | 1 | SO53960 | 2023-11-05 | 5.08 | 23.75 | |
SO56638_4 | 100 | 27883 | 480 | 2 | 8 | 2023-12-27 | 0.06 | 2023-12-15 | 2.29 | 4 | SO56638 | 2023-12-22 | 0.18 | 0.86 |
SO54665_2 | 6 | 16488 | 217 | 9 | 2023-11-23 | 0.87 | 2023-11-11 | 34.99 | 2 | SO54665 | 2023-11-18 | 2.80 | 13.09 | |
SO73520_1 | 100 | 25291 | 529 | 1 | 2024-08-25 | 0.10 | 2024-08-13 | 3.99 | 1 | SO73520 | 2024-08-20 | 0.32 | 1.49 | |
SO51239_2 | 6 | 11076 | 487 | 9 | 2023-09-06 | 1.37 | 2023-08-25 | 54.99 | 2 | SO51239 | 2023-09-01 | 4.40 | 20.57 | |
SO63727_1 | 100 | 16022 | 597 | 1 | 2024-04-11 | 13.50 | 2024-03-30 | 539.99 | 1 | SO63727 | 2024-04-06 | 43.20 | 294.58 | |
SO51552_1 | 100 | 13747 | 589 | 1 | 2023-09-26 | 19.24 | 2023-09-14 | 769.49 | 1 | SO51552 | 2023-09-21 | 61.56 | 419.78 | |
SO63112_2 | 100 | 20436 | 477 | 4 | 2024-04-04 | 0.12 | 2024-03-23 | 4.99 | 2 | SO63112 | 2024-03-30 | 0.40 | 1.87 | |
SO60137_2 | 100 | 25183 | 228 | 1 | 2024-02-18 | 1.25 | 2024-02-06 | 49.99 | 2 | SO60137 | 2024-02-13 | 4.00 | 38.49 | |
SO70878_4 | 100 | 16552 | 473 | 8 | 2024-07-22 | 1.59 | 2024-07-10 | 63.50 | 4 | SO70878 | 2024-07-17 | 5.08 | 23.75 | |
SO52754_1 | 100 | 18635 | 529 | 8 | 2023-10-21 | 0.10 | 2023-10-09 | 3.99 | 1 | SO52754 | 2023-10-16 | 0.32 | 1.49 | |
SO52048_2 | 19 | 19781 | 480 | 2 | 6 | 2023-10-07 | 0.06 | 2023-09-25 | 2.29 | 2 | SO52048 | 2023-10-02 | 0.18 | 0.86 |
SO50484_1 | 98 | 18028 | 375 | 10 | 2023-07-18 | 54.54 | 2023-07-06 | 2181.56 | 1 | SO50484 | 2023-07-13 | 174.53 | 1320.68 | |
SO74943_3 | 100 | 27383 | 222 | 4 | 2024-09-28 | 0.87 | 2024-09-16 | 34.99 | 3 | SO74943 | 2024-09-23 | 2.80 | 13.09 | |
SO74217_1 | 100 | 12478 | 225 | 8 | 2024-09-04 | 0.22 | 2024-08-23 | 8.99 | 1 | SO74217 | 2024-08-30 | 0.72 | 6.92 | |
SO59796_1 | 100 | 11732 | 537 | 2 | 2024-02-13 | 0.88 | 2024-02-01 | 35.00 | 1 | SO59796 | 2024-02-08 | 2.80 | 13.09 | |
SO66102_5 | 19 | 18320 | 228 | 6 | 2024-05-16 | 1.25 | 2024-05-04 | 49.99 | 5 | SO66102 | 2024-05-11 | 4.00 | 38.49 | |
SO48716_1 | 98 | 17626 | 377 | 10 | 2023-03-04 | 54.54 | 2023-02-20 | 2181.56 | 1 | SO48716 | 2023-02-27 | 174.53 | 1320.68 | |
SO73871_2 | 6 | 14679 | 529 | 9 | 2024-08-30 | 0.10 | 2024-08-18 | 3.99 | 2 | SO73871 | 2024-08-25 | 0.32 | 1.49 | |
SO56201_2 | 100 | 18675 | 482 | 4 | 2023-12-19 | 0.22 | 2023-12-07 | 8.99 | 2 | SO56201 | 2023-12-14 | 0.72 | 3.36 | |
SO62058_1 | 100 | 23221 | 529 | 8 | 2024-03-18 | 0.10 | 2024-03-06 | 3.99 | 1 | SO62058 | 2024-03-13 | 0.32 | 1.49 | |
SO62663_3 | 100 | 14510 | 528 | 1 | 2024-03-28 | 0.12 | 2024-03-16 | 4.99 | 3 | SO62663 | 2024-03-23 | 0.40 | 1.87 | |
SO60981_1 | 19 | 15748 | 475 | 6 | 2024-03-02 | 1.75 | 2024-02-19 | 69.99 | 1 | SO60981 | 2024-02-26 | 5.60 | 26.18 | |
SO59157_2 | 100 | 24736 | 540 | 1 | 2024-02-04 | 0.82 | 2024-01-23 | 32.60 | 2 | SO59157 | 2024-01-30 | 2.61 | 12.19 | |
SO70299_3 | 100 | 11171 | 477 | 4 | 2024-07-13 | 0.12 | 2024-07-01 | 4.99 | 3 | SO70299 | 2024-07-08 | 0.40 | 1.87 | |
SO74764_2 | 100 | 23285 | 528 | 1 | 2024-09-22 | 0.12 | 2024-09-10 | 4.99 | 2 | SO74764 | 2024-09-17 | 0.40 | 1.87 | |
SO55802_1 | 6 | 15832 | 600 | 9 | 2023-12-11 | 13.50 | 2023-11-29 | 539.99 | 1 | SO55802 | 2023-12-06 | 43.20 | 294.58 | |
SO69034_1 | 100 | 27041 | 530 | 1 | 2024-06-29 | 0.12 | 2024-06-17 | 4.99 | 1 | SO69034 | 2024-06-24 | 0.40 | 1.87 | |
SO73100_1 | 6 | 24482 | 581 | 9 | 2024-08-20 | 42.52 | 2024-08-08 | 1700.99 | 1 | SO73100 | 2024-08-15 | 136.08 | 1082.51 | |
SO72338_2 | 19 | 15905 | 479 | 6 | 2024-08-09 | 0.22 | 2024-07-28 | 8.99 | 2 | SO72338 | 2024-08-04 | 0.72 | 3.36 | |
SO72790_1 | 6 | 15240 | 529 | 9 | 2024-08-16 | 0.10 | 2024-08-04 | 3.99 | 1 | SO72790 | 2024-08-11 | 0.32 | 1.49 | |
SO70660_3 | 100 | 21704 | 529 | 1 | 2024-07-18 | 0.10 | 2024-07-06 | 3.99 | 3 | SO70660 | 2024-07-13 | 0.32 | 1.49 | |
SO54315_3 | 6 | 28110 | 477 | 9 | 2023-11-16 | 0.12 | 2023-11-04 | 4.99 | 3 | SO54315 | 2023-11-11 | 0.40 | 1.87 | |
SO60663_3 | 100 | 14989 | 480 | 2 | 7 | 2024-02-26 | 0.06 | 2024-02-14 | 2.29 | 3 | SO60663 | 2024-02-21 | 0.18 | 0.86 |
SO62186_3 | 100 | 27474 | 217 | 1 | 2024-03-20 | 0.87 | 2024-03-08 | 34.99 | 3 | SO62186 | 2024-03-15 | 2.80 | 13.09 | |
SO64729_1 | 100 | 28605 | 484 | 4 | 2024-04-27 | 0.20 | 2024-04-15 | 7.95 | 1 | SO64729 | 2024-04-22 | 0.64 | 2.97 | |
SO74107_4 | 100 | 13570 | 222 | 8 | 2024-09-02 | 0.87 | 2024-08-21 | 34.99 | 4 | SO74107 | 2024-08-28 | 2.80 | 13.09 | |
SO61890_1 | 100 | 26912 | 538 | 8 | 2024-03-15 | 0.54 | 2024-03-03 | 21.49 | 1 | SO61890 | 2024-03-10 | 1.72 | 8.04 | |
SO63970_4 | 19 | 23458 | 478 | 6 | 2024-04-15 | 0.25 | 2024-04-03 | 9.99 | 4 | SO63970 | 2024-04-10 | 0.80 | 3.74 | |
SO73166_4 | 100 | 26281 | 214 | 4 | 2024-08-20 | 0.87 | 2024-08-08 | 34.99 | 4 | SO73166 | 2024-08-15 | 2.80 | 13.09 | |
SO55591_2 | 100 | 12757 | 222 | 1 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 2 | SO55591 | 2023-12-03 | 2.80 | 13.09 | |
SO59532_2 | 100 | 26821 | 529 | 8 | 2024-02-09 | 0.10 | 2024-01-28 | 3.99 | 2 | SO59532 | 2024-02-04 | 0.32 | 1.49 | |
SO67088_2 | 100 | 12624 | 214 | 8 | 2024-06-01 | 0.87 | 2024-05-20 | 34.99 | 2 | SO67088 | 2024-05-27 | 2.80 | 13.09 | |
SO71091_1 | 100 | 25660 | 583 | 7 | 2024-07-24 | 42.52 | 2024-07-12 | 1700.99 | 1 | SO71091 | 2024-07-19 | 136.08 | 1082.51 | |
SO60378_1 | 6 | 28488 | 569 | 9 | 2024-02-21 | 18.56 | 2024-02-09 | 742.35 | 1 | SO60378 | 2024-02-16 | 59.39 | 461.44 | |
SO73497_1 | 100 | 25464 | 563 | 7 | 2024-08-24 | 59.60 | 2024-08-12 | 2384.07 | 1 | SO73497 | 2024-08-19 | 190.73 | 1481.94 | |
SO70134_2 | 100 | 18075 | 528 | 4 | 2024-07-11 | 0.12 | 2024-06-29 | 4.99 | 2 | SO70134 | 2024-07-06 | 0.40 | 1.87 | |
SO63893_1 | 98 | 22418 | 583 | 10 | 2024-04-14 | 42.52 | 2024-04-02 | 1700.99 | 1 | SO63893 | 2024-04-09 | 136.08 | 1082.51 | |
SO59475_5 | 100 | 17664 | 465 | 4 | 2024-02-08 | 0.61 | 2024-01-27 | 24.49 | 5 | SO59475 | 2024-02-03 | 1.96 | 9.16 | |
SO54923_3 | 6 | 22951 | 491 | 9 | 2023-11-27 | 1.35 | 2023-11-15 | 53.99 | 3 | SO54923 | 2023-11-22 | 4.32 | 41.57 | |
SO57750_3 | 6 | 21564 | 217 | 9 | 2024-01-14 | 0.87 | 2024-01-02 | 34.99 | 3 | SO57750 | 2024-01-09 | 2.80 | 13.09 | |
SO70559_1 | 19 | 11498 | 528 | 6 | 2024-07-17 | 0.12 | 2024-07-05 | 4.99 | 1 | SO70559 | 2024-07-12 | 0.40 | 1.87 | |
SO72182_2 | 100 | 13255 | 479 | 8 | 2024-08-07 | 0.22 | 2024-07-26 | 8.99 | 2 | SO72182 | 2024-08-02 | 0.72 | 3.36 | |
SO53292_3 | 6 | 15018 | 465 | 9 | 2023-11-01 | 0.61 | 2023-10-20 | 24.49 | 3 | SO53292 | 2023-10-27 | 1.96 | 9.16 | |
SO57656_2 | 100 | 23446 | 480 | 8 | 2024-01-12 | 0.06 | 2023-12-31 | 2.29 | 2 | SO57656 | 2024-01-07 | 0.18 | 0.86 | |
SO72915_5 | 6 | 18338 | 489 | 9 | 2024-08-17 | 1.35 | 2024-08-05 | 53.99 | 5 | SO72915 | 2024-08-12 | 4.32 | 41.57 | |
SO57310_4 | 6 | 15828 | 478 | 9 | 2024-01-06 | 0.25 | 2023-12-25 | 9.99 | 4 | SO57310 | 2024-01-01 | 0.80 | 3.74 | |
SO64012_2 | 100 | 27627 | 530 | 4 | 2024-04-16 | 0.12 | 2024-04-04 | 4.99 | 2 | SO64012 | 2024-04-11 | 0.40 | 1.87 | |
SO65452_1 | 98 | 22429 | 581 | 10 | 2024-05-06 | 42.52 | 2024-04-24 | 1700.99 | 1 | SO65452 | 2024-05-01 | 136.08 | 1082.51 | |
SO72067_3 | 6 | 11071 | 488 | 9 | 2024-08-06 | 1.35 | 2024-07-25 | 53.99 | 3 | SO72067 | 2024-08-01 | 4.32 | 41.57 | |
SO56753_2 | 100 | 22778 | 538 | 4 | 2023-12-29 | 0.54 | 2023-12-17 | 21.49 | 2 | SO56753 | 2023-12-24 | 1.72 | 8.04 | |
SO64497_1 | 100 | 13502 | 530 | 8 | 2024-04-23 | 0.12 | 2024-04-11 | 4.99 | 1 | SO64497 | 2024-04-18 | 0.40 | 1.87 | |
SO58676_2 | 19 | 16479 | 478 | 6 | 2024-01-30 | 0.25 | 2024-01-18 | 9.99 | 2 | SO58676 | 2024-01-25 | 0.80 | 3.74 | |
SO62977_1 | 100 | 20827 | 529 | 7 | 2024-04-02 | 0.10 | 2024-03-21 | 3.99 | 1 | SO62977 | 2024-03-28 | 0.32 | 1.49 | |
SO60210_1 | 100 | 19633 | 477 | 4 | 2024-02-19 | 0.12 | 2024-02-07 | 4.99 | 1 | SO60210 | 2024-02-14 | 0.40 | 1.87 | |
SO64038_1 | 100 | 15404 | 363 | 4 | 2024-04-16 | 57.37 | 2024-04-04 | 2294.99 | 1 | SO64038 | 2024-04-11 | 183.60 | 1251.98 | |
SO60143_3 | 100 | 20507 | 217 | 1 | 2024-02-18 | 0.87 | 2024-02-06 | 34.99 | 3 | SO60143 | 2024-02-13 | 2.80 | 13.09 | |
SO51651_2 | 6 | 11077 | 487 | 9 | 2023-10-01 | 1.37 | 2023-09-19 | 54.99 | 2 | SO51651 | 2023-09-26 | 4.40 | 20.57 | |
SO55150_2 | 100 | 27479 | 480 | 4 | 2023-12-02 | 0.06 | 2023-11-20 | 2.29 | 2 | SO55150 | 2023-11-27 | 0.18 | 0.86 | |
SO64705_1 | 100 | 14571 | 528 | 4 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 1 | SO64705 | 2024-04-21 | 0.40 | 1.87 | |
SO74451_1 | 100 | 14632 | 540 | 6 | 2024-09-12 | 0.82 | 2024-08-31 | 32.60 | 1 | SO74451 | 2024-09-07 | 2.61 | 12.19 | |
SO72668_4 | 100 | 20532 | 467 | 4 | 2024-08-14 | 0.61 | 2024-08-02 | 24.49 | 4 | SO72668 | 2024-08-09 | 1.96 | 9.16 | |
SO68134_2 | 100 | 12131 | 222 | 7 | 2024-06-15 | 0.87 | 2024-06-03 | 34.99 | 2 | SO68134 | 2024-06-10 | 2.80 | 13.09 | |
SO69147_1 | 100 | 27116 | 573 | 1 | 2024-06-30 | 59.60 | 2024-06-18 | 2384.07 | 1 | SO69147 | 2024-06-25 | 190.73 | 1481.94 |
Generated 2024-09-21 08:49:01.724 UTC