[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '7' > SHUFFLE < SKIP 327 > < TAKE 60 >
60 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50404_1 | 100 | 11382 | 358 | 7 | 2023-08-29 | 51.23 | 2023-08-17 | 2049.10 | 1 | SO50404 | 2023-08-24 | 163.93 | 1105.81 | |
SO46712_1 | 100 | 13779 | 373 | 7 | 2022-10-27 | 54.54 | 2022-10-15 | 2181.56 | 1 | SO46712 | 2022-10-22 | 174.53 | 1320.68 | |
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 | |
SO64563_2 | 100 | 17953 | 528 | 7 | 2024-06-13 | 0.12 | 2024-06-01 | 4.99 | 2 | SO64563 | 2024-06-08 | 0.40 | 1.87 | |
SO65853_4 | 100 | 17779 | 214 | 7 | 2024-07-01 | 0.87 | 2024-06-19 | 34.99 | 4 | SO65853 | 2024-06-26 | 2.80 | 13.09 | |
SO63831_3 | 100 | 22632 | 477 | 7 | 2024-06-02 | 0.12 | 2024-05-21 | 4.99 | 3 | SO63831 | 2024-05-28 | 0.40 | 1.87 | |
SO74301_2 | 100 | 24877 | 529 | 7 | 2024-10-27 | 0.10 | 2024-10-15 | 3.99 | 2 | SO74301 | 2024-10-22 | 0.32 | 1.49 | |
SO64644_3 | 100 | 18025 | 480 | 7 | 2024-06-14 | 0.06 | 2024-06-02 | 2.29 | 3 | SO64644 | 2024-06-09 | 0.18 | 0.86 | |
SO66399_1 | 100 | 20954 | 529 | 7 | 2024-07-10 | 0.10 | 2024-06-28 | 3.99 | 1 | SO66399 | 2024-07-05 | 0.32 | 1.49 | |
SO56253_1 | 100 | 11566 | 530 | 7 | 2024-02-08 | 0.12 | 2024-01-27 | 4.99 | 1 | SO56253 | 2024-02-03 | 0.40 | 1.87 | |
SO71993_1 | 100 | 28740 | 390 | 7 | 2024-09-23 | 28.01 | 2024-09-11 | 1120.49 | 1 | SO71993 | 2024-09-18 | 89.64 | 713.08 | |
SO57403_1 | 100 | 27163 | 530 | 7 | 2024-02-26 | 0.12 | 2024-02-14 | 4.99 | 1 | SO57403 | 2024-02-21 | 0.40 | 1.87 | |
SO54566_1 | 100 | 27836 | 530 | 7 | 2024-01-10 | 0.12 | 2023-12-29 | 4.99 | 1 | SO54566 | 2024-01-05 | 0.40 | 1.87 | |
SO53173_1 | 100 | 25759 | 568 | 13 | 7 | 2023-12-18 | 18.56 | 2023-12-06 | 742.35 | 1 | SO53173 | 2023-12-13 | 59.39 | 461.44 |
SO74743_2 | 100 | 15111 | 481 | 7 | 2024-11-10 | 0.22 | 2024-10-29 | 8.99 | 2 | SO74743 | 2024-11-05 | 0.72 | 3.36 | |
SO66635_4 | 100 | 22641 | 214 | 7 | 2024-07-13 | 0.87 | 2024-07-01 | 34.99 | 4 | SO66635 | 2024-07-08 | 2.80 | 13.09 | |
SO56629_1 | 100 | 21662 | 538 | 7 | 2024-02-15 | 0.54 | 2024-02-03 | 21.49 | 1 | SO56629 | 2024-02-10 | 1.72 | 8.04 | |
SO44039_1 | 39 | 17971 | 342 | 7 | 2021-12-17 | 17.48 | 2021-12-05 | 699.10 | 1 | SO44039 | 2021-12-12 | 55.93 | 413.15 | |
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 | |
SO62127_3 | 100 | 11248 | 477 | 7 | 2024-05-08 | 0.12 | 2024-04-26 | 4.99 | 3 | SO62127 | 2024-05-03 | 0.40 | 1.87 | |
SO63504_1 | 100 | 13575 | 376 | 7 | 2024-05-28 | 61.08 | 2024-05-16 | 2443.35 | 1 | SO63504 | 2024-05-23 | 195.47 | 1554.95 | |
SO64988_1 | 100 | 17883 | 536 | 7 | 2024-06-20 | 0.75 | 2024-06-08 | 29.99 | 1 | SO64988 | 2024-06-15 | 2.40 | 11.22 | |
SO67694_3 | 100 | 12754 | 479 | 7 | 2024-07-28 | 0.22 | 2024-07-16 | 8.99 | 3 | SO67694 | 2024-07-23 | 0.72 | 3.36 | |
SO47898_1 | 100 | 19276 | 323 | 7 | 2023-02-14 | 19.57 | 2023-02-02 | 782.99 | 1 | SO47898 | 2023-02-09 | 62.64 | 486.71 | |
SO58805_3 | 100 | 22397 | 480 | 7 | 2024-03-22 | 0.06 | 2024-03-10 | 2.29 | 3 | SO58805 | 2024-03-17 | 0.18 | 0.86 | |
SO52017_4 | 100 | 12131 | 480 | 7 | 2023-11-25 | 0.06 | 2023-11-13 | 2.29 | 4 | SO52017 | 2023-11-20 | 0.18 | 0.86 | |
SO56306_1 | 100 | 21121 | 538 | 7 | 2024-02-09 | 0.54 | 2024-01-28 | 21.49 | 1 | SO56306 | 2024-02-04 | 1.72 | 8.04 | |
SO67028_2 | 100 | 20910 | 535 | 7 | 2024-07-20 | 0.62 | 2024-07-08 | 24.99 | 2 | SO67028 | 2024-07-15 | 2.00 | 9.35 | |
SO66499_3 | 100 | 22654 | 480 | 7 | 2024-07-11 | 0.06 | 2024-06-29 | 2.29 | 3 | SO66499 | 2024-07-06 | 0.18 | 0.86 | |
SO59649_1 | 100 | 12631 | 359 | 7 | 2024-04-01 | 57.37 | 2024-03-20 | 2294.99 | 1 | SO59649 | 2024-03-27 | 183.60 | 1251.98 | |
SO57883_2 | 100 | 28882 | 480 | 2 | 7 | 2024-03-06 | 0.06 | 2024-02-23 | 2.29 | 2 | SO57883 | 2024-03-01 | 0.18 | 0.86 |
SO63704_1 | 100 | 12265 | 357 | 2 | 7 | 2024-05-31 | 58.00 | 2024-05-19 | 2319.99 | 1 | SO63704 | 2024-05-26 | 185.60 | 1265.62 |
SO51602_2 | 100 | 11439 | 214 | 7 | 2023-11-17 | 0.87 | 2023-11-05 | 34.99 | 2 | SO51602 | 2023-11-12 | 2.80 | 13.09 | |
SO58189_3 | 100 | 16580 | 529 | 7 | 2024-03-11 | 0.10 | 2024-02-28 | 3.99 | 3 | SO58189 | 2024-03-06 | 0.32 | 1.49 | |
SO54253_1 | 100 | 11577 | 359 | 7 | 2024-01-05 | 57.37 | 2023-12-24 | 2294.99 | 1 | SO54253 | 2023-12-31 | 183.60 | 1251.98 | |
SO55066_3 | 100 | 16557 | 480 | 7 | 2024-01-19 | 0.06 | 2024-01-07 | 2.29 | 3 | SO55066 | 2024-01-14 | 0.18 | 0.86 | |
SO68710_2 | 100 | 24125 | 225 | 7 | 2024-08-13 | 0.22 | 2024-08-01 | 8.99 | 2 | SO68710 | 2024-08-08 | 0.72 | 6.92 | |
SO54040_4 | 100 | 11572 | 225 | 7 | 2024-01-01 | 0.22 | 2023-12-20 | 8.99 | 4 | SO54040 | 2023-12-27 | 0.72 | 6.92 | |
SO49686_1 | 100 | 16051 | 377 | 7 | 2023-07-08 | 54.54 | 2023-06-26 | 2181.56 | 1 | SO49686 | 2023-07-03 | 174.53 | 1320.68 | |
SO65512_3 | 100 | 15067 | 222 | 7 | 2024-06-26 | 0.87 | 2024-06-14 | 34.99 | 3 | SO65512 | 2024-06-21 | 2.80 | 13.09 | |
SO62587_1 | 100 | 15710 | 583 | 7 | 2024-05-16 | 42.52 | 2024-05-04 | 1700.99 | 1 | SO62587 | 2024-05-11 | 136.08 | 1082.51 | |
SO61626_1 | 100 | 12752 | 529 | 7 | 2024-04-30 | 0.10 | 2024-04-18 | 3.99 | 1 | SO61626 | 2024-04-25 | 0.32 | 1.49 | |
SO54415_1 | 100 | 12562 | 478 | 7 | 2024-01-07 | 0.25 | 2023-12-26 | 9.99 | 1 | SO54415 | 2024-01-02 | 0.80 | 3.74 | |
SO72235_1 | 100 | 28886 | 530 | 7 | 2024-09-27 | 0.12 | 2024-09-15 | 4.99 | 1 | SO72235 | 2024-09-22 | 0.40 | 1.87 | |
SO51502_5 | 100 | 19475 | 214 | 7 | 2023-11-12 | 0.87 | 2023-10-31 | 34.99 | 5 | SO51502 | 2023-11-07 | 2.80 | 13.09 | |
SO70147_2 | 100 | 17834 | 237 | 2 | 7 | 2024-08-30 | 1.25 | 2024-08-18 | 49.99 | 2 | SO70147 | 2024-08-25 | 4.00 | 38.49 |
SO57595_3 | 100 | 14719 | 485 | 7 | 2024-03-01 | 0.55 | 2024-02-18 | 21.98 | 3 | SO57595 | 2024-02-25 | 1.76 | 8.22 | |
SO51502_2 | 100 | 19475 | 485 | 7 | 2023-11-12 | 0.55 | 2023-10-31 | 21.98 | 2 | SO51502 | 2023-11-07 | 1.76 | 8.22 | |
SO66673_2 | 100 | 16555 | 539 | 7 | 2024-07-14 | 0.62 | 2024-07-02 | 24.99 | 2 | SO66673 | 2024-07-09 | 2.00 | 9.35 | |
SO51393_1 | 100 | 16394 | 376 | 7 | 2023-11-05 | 61.08 | 2023-10-24 | 2443.35 | 1 | SO51393 | 2023-10-31 | 195.47 | 1554.95 | |
SO51307_1 | 100 | 11336 | 355 | 7 | 2023-10-31 | 58.00 | 2023-10-19 | 2319.99 | 1 | SO51307 | 2023-10-26 | 185.60 | 1265.62 | |
SO59533_1 | 100 | 21132 | 538 | 7 | 2024-03-30 | 0.54 | 2024-03-18 | 21.49 | 1 | SO59533 | 2024-03-25 | 1.72 | 8.04 | |
SO60117_2 | 100 | 19517 | 217 | 7 | 2024-04-07 | 0.87 | 2024-03-26 | 34.99 | 2 | SO60117 | 2024-04-02 | 2.80 | 13.09 | |
SO58899_1 | 100 | 22316 | 605 | 7 | 2024-03-23 | 13.50 | 2024-03-11 | 539.99 | 1 | SO58899 | 2024-03-18 | 43.20 | 343.65 | |
SO67933_2 | 100 | 23748 | 530 | 7 | 2024-08-01 | 0.12 | 2024-07-20 | 4.99 | 2 | SO67933 | 2024-07-27 | 0.40 | 1.87 | |
SO65879_5 | 100 | 17973 | 483 | 7 | 2024-07-02 | 3.00 | 2024-06-20 | 120.00 | 5 | SO65879 | 2024-06-27 | 9.60 | 44.88 | |
SO63358_4 | 100 | 20826 | 463 | 7 | 2024-05-25 | 0.61 | 2024-05-13 | 24.49 | 4 | SO63358 | 2024-05-20 | 1.96 | 9.16 | |
SO68312_2 | 100 | 22377 | 529 | 7 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 2 | SO68312 | 2024-08-02 | 0.32 | 1.49 | |
SO69253_3 | 100 | 19899 | 477 | 7 | 2024-08-21 | 0.12 | 2024-08-09 | 4.99 | 3 | SO69253 | 2024-08-16 | 0.40 | 1.87 | |
SO62295_2 | 100 | 15921 | 478 | 7 | 2024-05-11 | 0.25 | 2024-04-29 | 9.99 | 2 | SO62295 | 2024-05-06 | 0.80 | 3.74 |
Generated 2024-11-10 11:13:48.789 UTC