[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 3027 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50342_1 | 100 | 27425 | 360 | 4 | 2023-07-04 | 51.23 | 2023-06-22 | 2049.10 | 1 | SO50342 | 2023-06-29 | 163.93 | 1105.81 | |
SO73442_1 | 100 | 21779 | 477 | 4 | 2024-08-23 | 0.12 | 2024-08-11 | 4.99 | 1 | SO73442 | 2024-08-18 | 0.40 | 1.87 | |
SO44164_1 | 100 | 28088 | 310 | 4 | 2021-11-08 | 89.46 | 2021-10-27 | 3578.27 | 1 | SO44164 | 2021-11-03 | 286.26 | 2171.29 | |
SO66491_1 | 100 | 26604 | 561 | 4 | 2024-05-21 | 59.60 | 2024-05-09 | 2384.07 | 1 | SO66491 | 2024-05-16 | 190.73 | 1481.94 | |
SO44450_1 | 100 | 28294 | 310 | 4 | 2021-12-29 | 89.46 | 2021-12-17 | 3578.27 | 1 | SO44450 | 2021-12-24 | 286.26 | 2171.29 | |
SO69830_2 | 100 | 11188 | 537 | 4 | 2024-07-06 | 0.88 | 2024-06-24 | 35.00 | 2 | SO69830 | 2024-07-01 | 2.80 | 13.09 | |
SO51219_4 | 100 | 25086 | 463 | 4 | 2023-09-04 | 0.61 | 2023-08-23 | 24.49 | 4 | SO51219 | 2023-08-30 | 1.96 | 9.16 | |
SO70562_2 | 100 | 12412 | 528 | 4 | 2024-07-16 | 0.12 | 2024-07-04 | 4.99 | 2 | SO70562 | 2024-07-11 | 0.40 | 1.87 | |
SO70565_1 | 100 | 19990 | 598 | 4 | 2024-07-16 | 13.50 | 2024-07-04 | 539.99 | 1 | SO70565 | 2024-07-11 | 43.20 | 294.58 | |
SO52177_1 | 100 | 23729 | 529 | 4 | 2023-10-09 | 0.10 | 2023-09-27 | 3.99 | 1 | SO52177 | 2023-10-04 | 0.32 | 1.49 | |
SO62855_4 | 100 | 14457 | 465 | 4 | 2024-03-30 | 0.61 | 2024-03-18 | 24.49 | 4 | SO62855 | 2024-03-25 | 1.96 | 9.16 | |
SO44631_1 | 100 | 28629 | 310 | 4 | 2022-01-13 | 89.46 | 2022-01-01 | 3578.27 | 1 | SO44631 | 2022-01-08 | 286.26 | 2171.29 | |
SO51469_5 | 100 | 11168 | 480 | 4 | 2023-09-20 | 0.06 | 2023-09-08 | 2.29 | 5 | SO51469 | 2023-09-15 | 0.18 | 0.86 | |
SO51435_1 | 100 | 24413 | 576 | 4 | 2023-09-17 | 59.60 | 2023-09-05 | 2384.07 | 1 | SO51435 | 2023-09-12 | 190.73 | 1481.94 | |
SO44004_1 | 100 | 28061 | 310 | 4 | 2021-10-21 | 89.46 | 2021-10-09 | 3578.27 | 1 | SO44004 | 2021-10-16 | 286.26 | 2171.29 | |
SO57424_1 | 100 | 20097 | 386 | 4 | 2024-01-06 | 28.01 | 2023-12-25 | 1120.49 | 1 | SO57424 | 2024-01-01 | 89.64 | 713.08 | |
SO72378_3 | 100 | 15190 | 237 | 4 | 2024-08-09 | 1.25 | 2024-07-28 | 49.99 | 3 | SO72378 | 2024-08-04 | 4.00 | 38.49 | |
SO66049_2 | 100 | 13030 | 487 | 4 | 2024-05-14 | 1.37 | 2024-05-02 | 54.99 | 2 | SO66049 | 2024-05-09 | 4.40 | 20.57 | |
SO68561_2 | 100 | 27600 | 480 | 4 | 2024-06-21 | 0.06 | 2024-06-09 | 2.29 | 2 | SO68561 | 2024-06-16 | 0.18 | 0.86 | |
SO61811_1 | 100 | 18504 | 475 | 4 | 2024-03-13 | 1.75 | 2024-03-01 | 69.99 | 1 | SO61811 | 2024-03-08 | 5.60 | 26.18 | |
SO53717_1 | 100 | 21756 | 604 | 4 | 2023-11-04 | 13.50 | 2023-10-23 | 539.99 | 1 | SO53717 | 2023-10-30 | 43.20 | 343.65 | |
SO52460_3 | 100 | 22275 | 491 | 4 | 2023-10-14 | 1.35 | 2023-10-02 | 53.99 | 3 | SO52460 | 2023-10-09 | 4.32 | 41.57 | |
SO63079_2 | 100 | 23197 | 482 | 4 | 2024-04-03 | 0.22 | 2024-03-22 | 8.99 | 2 | SO63079 | 2024-03-29 | 0.72 | 3.36 | |
SO56034_1 | 100 | 24513 | 529 | 4 | 2023-12-15 | 0.10 | 2023-12-03 | 3.99 | 1 | SO56034 | 2023-12-10 | 0.32 | 1.49 | |
SO56928_1 | 100 | 15544 | 528 | 4 | 2024-01-01 | 0.12 | 2023-12-20 | 4.99 | 1 | SO56928 | 2023-12-27 | 0.40 | 1.87 | |
SO71324_4 | 100 | 17420 | 480 | 4 | 2024-07-27 | 0.06 | 2024-07-15 | 2.29 | 4 | SO71324 | 2024-07-22 | 0.18 | 0.86 | |
SO57992_6 | 100 | 11273 | 217 | 4 | 2024-01-17 | 0.87 | 2024-01-05 | 34.99 | 6 | SO57992 | 2024-01-12 | 2.80 | 13.09 | |
SO71464_1 | 100 | 15337 | 587 | 4 | 2024-07-29 | 19.24 | 2024-07-17 | 769.49 | 1 | SO71464 | 2024-07-24 | 61.56 | 419.78 | |
SO61931_1 | 100 | 27619 | 530 | 4 | 2024-03-15 | 0.12 | 2024-03-03 | 4.99 | 1 | SO61931 | 2024-03-10 | 0.40 | 1.87 | |
SO56738_2 | 100 | 13221 | 485 | 4 | 2023-12-28 | 0.55 | 2023-12-16 | 21.98 | 2 | SO56738 | 2023-12-23 | 1.76 | 8.22 | |
SO70427_4 | 100 | 15338 | 480 | 2 | 4 | 2024-07-14 | 0.06 | 2024-07-02 | 2.29 | 4 | SO70427 | 2024-07-09 | 0.18 | 0.86 |
SO72314_2 | 100 | 13151 | 478 | 4 | 2024-08-08 | 0.25 | 2024-07-27 | 9.99 | 2 | SO72314 | 2024-08-03 | 0.80 | 3.74 | |
SO66186_3 | 100 | 12882 | 217 | 4 | 2024-05-16 | 0.87 | 2024-05-04 | 34.99 | 3 | SO66186 | 2024-05-11 | 2.80 | 13.09 | |
SO53389_1 | 100 | 13855 | 588 | 4 | 2023-11-01 | 19.24 | 2023-10-20 | 769.49 | 1 | SO53389 | 2023-10-27 | 61.56 | 419.78 | |
SO57838_1 | 100 | 23127 | 584 | 4 | 2024-01-14 | 13.50 | 2024-01-02 | 539.99 | 1 | SO57838 | 2024-01-09 | 43.20 | 343.65 | |
SO51346_1 | 100 | 11270 | 363 | 4 | 2023-09-12 | 57.37 | 2023-08-31 | 2294.99 | 1 | SO51346 | 2023-09-07 | 183.60 | 1251.98 | |
SO53115_1 | 100 | 11806 | 537 | 4 | 2023-10-27 | 0.88 | 2023-10-15 | 35.00 | 1 | SO53115 | 2023-10-22 | 2.80 | 13.09 | |
SO59444_2 | 100 | 11867 | 528 | 4 | 2024-02-07 | 0.12 | 2024-01-26 | 4.99 | 2 | SO59444 | 2024-02-02 | 0.40 | 1.87 | |
SO59335_4 | 100 | 25403 | 222 | 4 | 2024-02-05 | 0.87 | 2024-01-24 | 34.99 | 4 | SO59335 | 2024-01-31 | 2.80 | 13.09 | |
SO71584_1 | 100 | 16337 | 528 | 4 | 2024-07-31 | 0.12 | 2024-07-19 | 4.99 | 1 | SO71584 | 2024-07-26 | 0.40 | 1.87 | |
SO70394_1 | 100 | 22890 | 528 | 4 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 1 | SO70394 | 2024-07-09 | 0.40 | 1.87 | |
SO55135_1 | 100 | 24673 | 561 | 4 | 2023-11-30 | 59.60 | 2023-11-18 | 2384.07 | 1 | SO55135 | 2023-11-25 | 190.73 | 1481.94 | |
SO72024_2 | 100 | 18313 | 480 | 2 | 4 | 2024-08-04 | 0.06 | 2024-07-23 | 2.29 | 2 | SO72024 | 2024-07-30 | 0.18 | 0.86 |
SO59806_3 | 100 | 13473 | 477 | 4 | 2024-02-12 | 0.12 | 2024-01-31 | 4.99 | 3 | SO59806 | 2024-02-07 | 0.40 | 1.87 | |
SO64943_1 | 100 | 22993 | 604 | 4 | 2024-04-29 | 13.50 | 2024-04-17 | 539.99 | 1 | SO64943 | 2024-04-24 | 43.20 | 343.65 | |
SO63805_1 | 100 | 24739 | 564 | 4 | 2024-04-11 | 59.60 | 2024-03-30 | 2384.07 | 1 | SO63805 | 2024-04-06 | 190.73 | 1481.94 | |
SO46222_1 | 100 | 14891 | 336 | 4 | 2022-07-18 | 17.48 | 2022-07-06 | 699.10 | 1 | SO46222 | 2022-07-13 | 55.93 | 413.15 | |
SO58802_2 | 100 | 14388 | 214 | 4 | 2024-01-31 | 0.87 | 2024-01-19 | 34.99 | 2 | SO58802 | 2024-01-26 | 2.80 | 13.09 | |
SO67005_3 | 100 | 26626 | 479 | 4 | 2024-05-29 | 0.22 | 2024-05-17 | 8.99 | 3 | SO67005 | 2024-05-24 | 0.72 | 3.36 | |
SO64401_2 | 100 | 16900 | 480 | 2 | 4 | 2024-04-21 | 0.06 | 2024-04-09 | 2.29 | 2 | SO64401 | 2024-04-16 | 0.18 | 0.86 |
SO67242_2 | 100 | 15540 | 485 | 4 | 2024-06-02 | 0.55 | 2024-05-21 | 21.98 | 2 | SO67242 | 2024-05-28 | 1.76 | 8.22 | |
SO61457_2 | 100 | 15516 | 480 | 2 | 4 | 2024-03-07 | 0.06 | 2024-02-24 | 2.29 | 2 | SO61457 | 2024-03-02 | 0.18 | 0.86 |
SO52822_2 | 100 | 11650 | 528 | 4 | 2023-10-21 | 0.12 | 2023-10-09 | 4.99 | 2 | SO52822 | 2023-10-16 | 0.40 | 1.87 | |
SO57525_1 | 100 | 25390 | 578 | 4 | 2024-01-08 | 30.37 | 2023-12-27 | 1214.85 | 1 | SO57525 | 2024-01-03 | 97.19 | 755.15 | |
SO66052_1 | 100 | 15542 | 357 | 2 | 4 | 2024-05-14 | 58.00 | 2024-05-02 | 2319.99 | 1 | SO66052 | 2024-05-09 | 185.60 | 1265.62 |
SO52494_2 | 100 | 18967 | 489 | 4 | 2023-10-15 | 1.35 | 2023-10-03 | 53.99 | 2 | SO52494 | 2023-10-10 | 4.32 | 41.57 | |
SO59433_1 | 100 | 19243 | 475 | 4 | 2024-02-07 | 1.75 | 2024-01-26 | 69.99 | 1 | SO59433 | 2024-02-02 | 5.60 | 26.18 | |
SO68030_1 | 100 | 11184 | 529 | 4 | 2024-06-13 | 0.10 | 2024-06-01 | 3.99 | 1 | SO68030 | 2024-06-08 | 0.32 | 1.49 | |
SO58577_1 | 100 | 23040 | 604 | 4 | 2024-01-27 | 13.50 | 2024-01-15 | 539.99 | 1 | SO58577 | 2024-01-22 | 43.20 | 343.65 | |
SO70985_2 | 100 | 17582 | 478 | 4 | 2024-07-22 | 0.25 | 2024-07-10 | 9.99 | 2 | SO70985 | 2024-07-17 | 0.80 | 3.74 |
Generated 2024-09-20 12:26:13.403 UTC