[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 2876 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50341_1 | 100 | 27289 | 356 | 4 | 2023-08-24 | 51.79 | 2023-08-12 | 2071.42 | 1 | SO50341 | 2023-08-19 | 165.71 | 1117.86 | |
SO65763_2 | 100 | 20504 | 477 | 4 | 2024-06-30 | 0.12 | 2024-06-18 | 4.99 | 2 | SO65763 | 2024-06-25 | 0.40 | 1.87 | |
SO73523_1 | 100 | 24406 | 529 | 4 | 2024-10-14 | 0.10 | 2024-10-02 | 3.99 | 1 | SO73523 | 2024-10-09 | 0.32 | 1.49 | |
SO68172_1 | 100 | 25082 | 540 | 4 | 2024-08-05 | 0.82 | 2024-07-24 | 32.60 | 1 | SO68172 | 2024-07-31 | 2.61 | 12.19 | |
SO44684_1 | 100 | 28643 | 310 | 4 | 2022-03-13 | 89.46 | 2022-03-01 | 3578.27 | 1 | SO44684 | 2022-03-08 | 286.26 | 2171.29 | |
SO57949_1 | 100 | 22099 | 604 | 4 | 2024-03-07 | 13.50 | 2024-02-24 | 539.99 | 1 | SO57949 | 2024-03-02 | 43.20 | 343.65 | |
SO59879_2 | 100 | 13455 | 485 | 4 | 2024-04-04 | 0.55 | 2024-03-23 | 21.98 | 2 | SO59879 | 2024-03-30 | 1.76 | 8.22 | |
SO64847_1 | 100 | 20750 | 382 | 4 | 2024-06-17 | 28.01 | 2024-06-05 | 1120.49 | 1 | SO64847 | 2024-06-12 | 89.64 | 713.08 | |
SO61896_3 | 100 | 11852 | 222 | 4 | 2024-05-04 | 0.87 | 2024-04-22 | 34.99 | 3 | SO61896 | 2024-04-29 | 2.80 | 13.09 | |
SO68995_2 | 100 | 19883 | 225 | 4 | 2024-08-17 | 0.22 | 2024-08-05 | 8.99 | 2 | SO68995 | 2024-08-12 | 0.72 | 6.92 | |
SO66541_2 | 100 | 20641 | 479 | 4 | 2024-07-12 | 0.22 | 2024-06-30 | 8.99 | 2 | SO66541 | 2024-07-07 | 0.72 | 3.36 | |
SO70562_4 | 100 | 12412 | 217 | 4 | 2024-09-05 | 0.87 | 2024-08-24 | 34.99 | 4 | SO70562 | 2024-08-31 | 2.80 | 13.09 | |
SO69274_3 | 100 | 16843 | 228 | 4 | 2024-08-21 | 1.25 | 2024-08-09 | 49.99 | 3 | SO69274 | 2024-08-16 | 4.00 | 38.49 | |
SO55217_2 | 100 | 11890 | 528 | 4 | 2024-01-22 | 0.12 | 2024-01-10 | 4.99 | 2 | SO55217 | 2024-01-17 | 0.40 | 1.87 | |
SO73208_1 | 100 | 17178 | 477 | 4 | 2024-10-10 | 0.12 | 2024-09-28 | 4.99 | 1 | SO73208 | 2024-10-05 | 0.40 | 1.87 | |
SO58274_1 | 100 | 16490 | 372 | 4 | 2024-03-13 | 61.08 | 2024-03-01 | 2443.35 | 1 | SO58274 | 2024-03-08 | 195.47 | 1554.95 | |
SO54780_1 | 100 | 24424 | 529 | 4 | 2024-01-14 | 0.10 | 2024-01-02 | 3.99 | 1 | SO54780 | 2024-01-09 | 0.32 | 1.49 | |
SO61390_2 | 100 | 27458 | 530 | 4 | 2024-04-26 | 0.12 | 2024-04-14 | 4.99 | 2 | SO61390 | 2024-04-21 | 0.40 | 1.87 | |
SO55992_1 | 100 | 18358 | 477 | 4 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO55992 | 2024-01-29 | 0.40 | 1.87 | |
SO71762_2 | 100 | 27569 | 564 | 4 | 2024-09-22 | 59.60 | 2024-09-10 | 2384.07 | 2 | SO71762 | 2024-09-17 | 190.73 | 1481.94 | |
SO53705_2 | 100 | 16897 | 490 | 4 | 2023-12-25 | 1.35 | 2023-12-13 | 53.99 | 2 | SO53705 | 2023-12-20 | 4.32 | 41.57 | |
SO61450_1 | 100 | 22775 | 536 | 4 | 2024-04-27 | 0.75 | 2024-04-15 | 29.99 | 1 | SO61450 | 2024-04-22 | 2.40 | 11.22 | |
SO66736_2 | 100 | 16102 | 477 | 4 | 2024-07-15 | 0.12 | 2024-07-03 | 4.99 | 2 | SO66736 | 2024-07-10 | 0.40 | 1.87 | |
SO64424_1 | 100 | 14645 | 589 | 4 | 2024-06-11 | 19.24 | 2024-05-30 | 769.49 | 1 | SO64424 | 2024-06-06 | 61.56 | 419.78 | |
SO73405_3 | 100 | 24286 | 538 | 4 | 2024-10-12 | 0.54 | 2024-09-30 | 21.49 | 3 | SO73405 | 2024-10-07 | 1.72 | 8.04 | |
SO64044_2 | 100 | 23041 | 538 | 4 | 2024-06-05 | 0.54 | 2024-05-24 | 21.49 | 2 | SO64044 | 2024-05-31 | 1.72 | 8.04 | |
SO52630_2 | 100 | 23502 | 480 | 2 | 4 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 2 | SO52630 | 2023-12-03 | 0.18 | 0.86 |
SO62716_1 | 100 | 18663 | 225 | 4 | 2024-05-18 | 0.22 | 2024-05-06 | 8.99 | 1 | SO62716 | 2024-05-13 | 0.72 | 6.92 | |
SO74085_2 | 100 | 19112 | 539 | 4 | 2024-10-21 | 0.62 | 2024-10-09 | 24.99 | 2 | SO74085 | 2024-10-16 | 2.00 | 9.35 | |
SO69151_2 | 100 | 23811 | 482 | 4 | 2024-08-19 | 0.22 | 2024-08-07 | 8.99 | 2 | SO69151 | 2024-08-14 | 0.72 | 3.36 | |
SO73302_1 | 100 | 20649 | 378 | 4 | 2024-10-11 | 61.08 | 2024-09-29 | 2443.35 | 1 | SO73302 | 2024-10-06 | 195.47 | 1554.95 | |
SO57447_3 | 100 | 17698 | 482 | 4 | 2024-02-27 | 0.22 | 2024-02-15 | 8.99 | 3 | SO57447 | 2024-02-22 | 0.72 | 3.36 | |
SO57808_4 | 100 | 26557 | 484 | 4 | 2024-03-05 | 0.20 | 2024-02-22 | 7.95 | 4 | SO57808 | 2024-02-29 | 0.64 | 2.97 | |
SO72717_4 | 100 | 18979 | 217 | 4 | 2024-10-03 | 0.87 | 2024-09-21 | 34.99 | 4 | SO72717 | 2024-09-28 | 2.80 | 13.09 | |
SO51539_3 | 100 | 19160 | 490 | 4 | 2023-11-14 | 1.35 | 2023-11-02 | 53.99 | 3 | SO51539 | 2023-11-09 | 4.32 | 41.57 | |
SO60658_3 | 100 | 21245 | 484 | 4 | 2024-04-16 | 0.20 | 2024-04-04 | 7.95 | 3 | SO60658 | 2024-04-11 | 0.64 | 2.97 | |
SO74947_1 | 100 | 24686 | 529 | 4 | 2024-11-17 | 0.10 | 2024-11-05 | 3.99 | 1 | SO74947 | 2024-11-12 | 0.32 | 1.49 | |
SO72455_3 | 100 | 23150 | 484 | 4 | 2024-09-30 | 0.20 | 2024-09-18 | 7.95 | 3 | SO72455 | 2024-09-25 | 0.64 | 2.97 | |
SO46115_1 | 100 | 12104 | 312 | 4 | 2022-08-23 | 89.46 | 2022-08-11 | 3578.27 | 1 | SO46115 | 2022-08-18 | 286.26 | 2171.29 | |
SO64741_3 | 100 | 27529 | 465 | 4 | 2024-06-16 | 0.61 | 2024-06-04 | 24.49 | 3 | SO64741 | 2024-06-11 | 1.96 | 9.16 | |
SO57590_3 | 100 | 22136 | 479 | 4 | 2024-02-29 | 0.22 | 2024-02-17 | 8.99 | 3 | SO57590 | 2024-02-24 | 0.72 | 3.36 | |
SO65340_1 | 100 | 27039 | 530 | 4 | 2024-06-23 | 0.12 | 2024-06-11 | 4.99 | 1 | SO65340 | 2024-06-18 | 0.40 | 1.87 | |
SO57862_2 | 100 | 25197 | 529 | 4 | 2024-03-06 | 0.10 | 2024-02-23 | 3.99 | 2 | SO57862 | 2024-03-01 | 0.32 | 1.49 | |
SO72342_1 | 100 | 24330 | 604 | 4 | 2024-09-28 | 13.50 | 2024-09-16 | 539.99 | 1 | SO72342 | 2024-09-23 | 43.20 | 343.65 | |
SO71765_1 | 100 | 20090 | 606 | 4 | 2024-09-22 | 13.50 | 2024-09-10 | 539.99 | 1 | SO71765 | 2024-09-17 | 43.20 | 343.65 | |
SO65040_1 | 100 | 25841 | 535 | 4 | 2024-06-21 | 0.62 | 2024-06-09 | 24.99 | 1 | SO65040 | 2024-06-16 | 2.00 | 9.35 | |
SO48510_1 | 100 | 26631 | 354 | 4 | 2023-04-04 | 51.79 | 2023-03-23 | 2071.42 | 1 | SO48510 | 2023-03-30 | 165.71 | 1117.86 | |
SO56298_1 | 100 | 14122 | 485 | 4 | 2024-02-09 | 0.55 | 2024-01-28 | 21.98 | 1 | SO56298 | 2024-02-04 | 1.76 | 8.22 | |
SO72429_3 | 100 | 22137 | 529 | 4 | 2024-09-29 | 0.10 | 2024-09-17 | 3.99 | 3 | SO72429 | 2024-09-24 | 0.32 | 1.49 | |
SO65821_1 | 100 | 25369 | 529 | 4 | 2024-07-01 | 0.10 | 2024-06-19 | 3.99 | 1 | SO65821 | 2024-06-26 | 0.32 | 1.49 | |
SO69219_2 | 100 | 12947 | 225 | 4 | 2024-08-20 | 0.22 | 2024-08-08 | 8.99 | 2 | SO69219 | 2024-08-15 | 0.72 | 6.92 | |
SO56313_5 | 100 | 16973 | 483 | 4 | 2024-02-09 | 3.00 | 2024-01-28 | 120.00 | 5 | SO56313 | 2024-02-04 | 9.60 | 44.88 | |
SO56663_1 | 100 | 14441 | 485 | 4 | 2024-02-16 | 0.55 | 2024-02-04 | 21.98 | 1 | SO56663 | 2024-02-11 | 1.76 | 8.22 | |
SO73230_3 | 100 | 15520 | 463 | 4 | 2024-10-10 | 0.61 | 2024-09-28 | 24.49 | 3 | SO73230 | 2024-10-05 | 1.96 | 9.16 | |
SO54050_1 | 100 | 11686 | 488 | 4 | 2024-01-01 | 1.35 | 2023-12-20 | 53.99 | 1 | SO54050 | 2023-12-27 | 4.32 | 41.57 | |
SO57870_1 | 100 | 18572 | 225 | 4 | 2024-03-06 | 0.22 | 2024-02-23 | 8.99 | 1 | SO57870 | 2024-03-01 | 0.72 | 6.92 |
Generated 2024-11-10 12:45:28.126 UTC