[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 1500 < SKIP 1991 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO64212_1 | 100 | 20545 | 374 | 1 | 2024-04-19 | 61.08 | 2024-04-07 | 2443.35 | 1 | SO64212 | 2024-04-14 | 195.47 | 1554.95 | |
SO68040_1 | 100 | 26256 | 541 | 1 | 2024-06-14 | 0.72 | 2024-06-02 | 28.99 | 1 | SO68040 | 2024-06-09 | 2.32 | 10.84 | |
SO71399_1 | 100 | 12148 | 528 | 1 | 2024-07-29 | 0.12 | 2024-07-17 | 4.99 | 1 | SO71399 | 2024-07-24 | 0.40 | 1.87 | |
SO56817_2 | 100 | 16134 | 481 | 1 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 2 | SO56817 | 2023-12-26 | 0.72 | 3.36 | |
SO68591_2 | 100 | 13184 | 478 | 1 | 2024-06-22 | 0.25 | 2024-06-10 | 9.99 | 2 | SO68591 | 2024-06-17 | 0.80 | 3.74 | |
SO71439_1 | 100 | 23875 | 536 | 1 | 2024-07-30 | 0.75 | 2024-07-18 | 29.99 | 1 | SO71439 | 2024-07-25 | 2.40 | 11.22 | |
SO74821_2 | 100 | 21301 | 477 | 1 | 2024-09-24 | 0.12 | 2024-09-12 | 4.99 | 2 | SO74821 | 2024-09-19 | 0.40 | 1.87 | |
SO71294_1 | 100 | 29029 | 530 | 1 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 1 | SO71294 | 2024-07-23 | 0.40 | 1.87 | |
SO73050_1 | 100 | 28081 | 529 | 1 | 2024-08-19 | 0.10 | 2024-08-07 | 3.99 | 1 | SO73050 | 2024-08-14 | 0.32 | 1.49 | |
SO74729_4 | 100 | 24438 | 463 | 1 | 2024-09-21 | 0.61 | 2024-09-09 | 24.49 | 4 | SO74729 | 2024-09-16 | 1.96 | 9.16 | |
SO64192_1 | 100 | 11214 | 480 | 1 | 2024-04-19 | 0.06 | 2024-04-07 | 2.29 | 1 | SO64192 | 2024-04-14 | 0.18 | 0.86 | |
SO53641_1 | 100 | 18816 | 474 | 1 | 2023-11-04 | 1.75 | 2023-10-23 | 69.99 | 1 | SO53641 | 2023-10-30 | 5.60 | 26.18 | |
SO71660_3 | 100 | 12366 | 217 | 1 | 2024-08-02 | 0.87 | 2024-07-21 | 34.99 | 3 | SO71660 | 2024-07-28 | 2.80 | 13.09 | |
SO74114_1 | 100 | 21495 | 478 | 1 | 2024-09-02 | 0.25 | 2024-08-21 | 9.99 | 1 | SO74114 | 2024-08-28 | 0.80 | 3.74 | |
SO70809_4 | 100 | 23857 | 214 | 1 | 2024-07-20 | 0.87 | 2024-07-08 | 34.99 | 4 | SO70809 | 2024-07-15 | 2.80 | 13.09 | |
SO67033_1 | 100 | 25179 | 529 | 1 | 2024-05-31 | 0.10 | 2024-05-19 | 3.99 | 1 | SO67033 | 2024-05-26 | 0.32 | 1.49 | |
SO72673_1 | 100 | 16725 | 528 | 1 | 2024-08-14 | 0.12 | 2024-08-02 | 4.99 | 1 | SO72673 | 2024-08-09 | 0.40 | 1.87 | |
SO53958_1 | 100 | 11718 | 537 | 1 | 2023-11-10 | 0.88 | 2023-10-29 | 35.00 | 1 | SO53958 | 2023-11-05 | 2.80 | 13.09 | |
SO53638_1 | 100 | 19728 | 476 | 1 | 2023-11-04 | 1.75 | 2023-10-23 | 69.99 | 1 | SO53638 | 2023-10-30 | 5.60 | 26.18 | |
SO54726_3 | 100 | 27509 | 214 | 1 | 2023-11-24 | 0.87 | 2023-11-12 | 34.99 | 3 | SO54726 | 2023-11-19 | 2.80 | 13.09 | |
SO51915_3 | 100 | 20200 | 540 | 1 | 2023-10-04 | 0.82 | 2023-09-22 | 32.60 | 3 | SO51915 | 2023-09-29 | 2.61 | 12.19 | |
SO73591_2 | 100 | 28019 | 480 | 2 | 1 | 2024-08-26 | 0.06 | 2024-08-14 | 2.29 | 2 | SO73591 | 2024-08-21 | 0.18 | 0.86 |
SO70338_1 | 100 | 15335 | 528 | 1 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 1 | SO70338 | 2024-07-09 | 0.40 | 1.87 | |
SO55716_2 | 100 | 11936 | 537 | 1 | 2023-12-10 | 0.88 | 2023-11-28 | 35.00 | 2 | SO55716 | 2023-12-05 | 2.80 | 13.09 | |
SO58892_1 | 100 | 28859 | 585 | 1 | 2024-02-02 | 18.56 | 2024-01-21 | 742.35 | 1 | SO58892 | 2024-01-28 | 59.39 | 461.44 | |
SO53228_2 | 100 | 11889 | 537 | 1 | 2023-10-30 | 0.88 | 2023-10-18 | 35.00 | 2 | SO53228 | 2023-10-25 | 2.80 | 13.09 | |
SO47640_1 | 100 | 26317 | 354 | 1 | 2022-12-01 | 51.79 | 2022-11-19 | 2071.42 | 1 | SO47640 | 2022-11-26 | 165.71 | 1117.86 | |
SO63989_2 | 100 | 23059 | 529 | 1 | 2024-04-15 | 0.10 | 2024-04-03 | 3.99 | 2 | SO63989 | 2024-04-10 | 0.32 | 1.49 | |
SO66336_4 | 100 | 22037 | 484 | 1 | 2024-05-20 | 0.20 | 2024-05-08 | 7.95 | 4 | SO66336 | 2024-05-15 | 0.64 | 2.97 | |
SO62986_3 | 100 | 14411 | 528 | 1 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 3 | SO62986 | 2024-03-28 | 0.40 | 1.87 | |
SO73907_2 | 100 | 13311 | 484 | 1 | 2024-08-30 | 0.20 | 2024-08-18 | 7.95 | 2 | SO73907 | 2024-08-25 | 0.64 | 2.97 | |
SO60888_1 | 100 | 17518 | 604 | 1 | 2024-02-29 | 13.50 | 2024-02-17 | 539.99 | 1 | SO60888 | 2024-02-24 | 43.20 | 343.65 | |
SO51183_1 | 100 | 20662 | 581 | 1 | 2023-09-03 | 42.52 | 2023-08-22 | 1700.99 | 1 | SO51183 | 2023-08-29 | 136.08 | 1082.51 | |
SO61011_3 | 100 | 14366 | 483 | 1 | 2024-03-02 | 3.00 | 2024-02-19 | 120.00 | 3 | SO61011 | 2024-02-26 | 9.60 | 44.88 | |
SO74247_4 | 100 | 12145 | 228 | 1 | 2024-09-05 | 1.25 | 2024-08-24 | 49.99 | 4 | SO74247 | 2024-08-31 | 4.00 | 38.49 | |
SO72017_1 | 100 | 25149 | 529 | 1 | 2024-08-05 | 0.10 | 2024-07-24 | 3.99 | 1 | SO72017 | 2024-07-31 | 0.32 | 1.49 | |
SO53831_1 | 100 | 11889 | 484 | 1 | 2023-11-08 | 0.20 | 2023-10-27 | 7.95 | 1 | SO53831 | 2023-11-03 | 0.64 | 2.97 | |
SO56661_2 | 100 | 15331 | 480 | 2 | 1 | 2023-12-28 | 0.06 | 2023-12-16 | 2.29 | 2 | SO56661 | 2023-12-23 | 0.18 | 0.86 |
SO56609_1 | 100 | 11304 | 480 | 1 | 2023-12-27 | 0.06 | 2023-12-15 | 2.29 | 1 | SO56609 | 2023-12-22 | 0.18 | 0.86 | |
SO69062_1 | 100 | 12913 | 355 | 1 | 2024-06-29 | 58.00 | 2024-06-17 | 2319.99 | 1 | SO69062 | 2024-06-24 | 185.60 | 1265.62 | |
SO52039_4 | 100 | 21762 | 225 | 1 | 2023-10-07 | 0.22 | 2023-09-25 | 8.99 | 4 | SO52039 | 2023-10-02 | 0.72 | 6.92 | |
SO71600_2 | 100 | 17401 | 537 | 1 | 2024-08-01 | 0.88 | 2024-07-20 | 35.00 | 2 | SO71600 | 2024-07-27 | 2.80 | 13.09 | |
SO60943_2 | 100 | 24645 | 491 | 1 | 2024-03-01 | 1.35 | 2024-02-18 | 53.99 | 2 | SO60943 | 2024-02-25 | 4.32 | 41.57 | |
SO55192_3 | 100 | 28991 | 222 | 1 | 2023-12-03 | 0.87 | 2023-11-21 | 34.99 | 3 | SO55192 | 2023-11-28 | 2.80 | 13.09 | |
SO68412_1 | 100 | 13169 | 483 | 1 | 2024-06-20 | 3.00 | 2024-06-08 | 120.00 | 1 | SO68412 | 2024-06-15 | 9.60 | 44.88 | |
SO66799_3 | 100 | 14405 | 465 | 1 | 2024-05-27 | 0.61 | 2024-05-15 | 24.49 | 3 | SO66799 | 2024-05-22 | 1.96 | 9.16 | |
SO74888_2 | 100 | 25932 | 465 | 1 | 2024-09-26 | 0.61 | 2024-09-14 | 24.49 | 2 | SO74888 | 2024-09-21 | 1.96 | 9.16 | |
SO73477_1 | 100 | 26304 | 579 | 1 | 2024-08-24 | 30.37 | 2024-08-12 | 1214.85 | 1 | SO73477 | 2024-08-19 | 97.19 | 755.15 | |
SO70036_1 | 100 | 27015 | 530 | 1 | 2024-07-10 | 0.12 | 2024-06-28 | 4.99 | 1 | SO70036 | 2024-07-05 | 0.40 | 1.87 | |
SO53649_2 | 100 | 13363 | 237 | 2 | 1 | 2023-11-04 | 1.25 | 2023-10-23 | 49.99 | 2 | SO53649 | 2023-10-30 | 4.00 | 38.49 |
SO52376_1 | 100 | 11843 | 231 | 1 | 2023-10-14 | 1.25 | 2023-10-02 | 49.99 | 1 | SO52376 | 2023-10-09 | 4.00 | 38.49 | |
SO48536_1 | 100 | 14256 | 387 | 1 | 2023-02-15 | 25.01 | 2023-02-03 | 1000.44 | 1 | SO48536 | 2023-02-10 | 80.04 | 605.65 | |
SO66033_1 | 100 | 29330 | 529 | 1 | 2024-05-15 | 0.10 | 2024-05-03 | 3.99 | 1 | SO66033 | 2024-05-10 | 0.32 | 1.49 | |
SO70544_1 | 100 | 17588 | 225 | 1 | 2024-07-17 | 0.22 | 2024-07-05 | 8.99 | 1 | SO70544 | 2024-07-12 | 0.72 | 6.92 | |
SO59592_1 | 100 | 23200 | 536 | 1 | 2024-02-10 | 0.75 | 2024-01-29 | 29.99 | 1 | SO59592 | 2024-02-05 | 2.40 | 11.22 | |
SO63043_2 | 100 | 12121 | 528 | 1 | 2024-04-03 | 0.12 | 2024-03-22 | 4.99 | 2 | SO63043 | 2024-03-29 | 0.40 | 1.87 | |
SO64013_1 | 100 | 28010 | 530 | 1 | 2024-04-16 | 0.12 | 2024-04-04 | 4.99 | 1 | SO64013 | 2024-04-11 | 0.40 | 1.87 | |
SO45824_1 | 100 | 11696 | 312 | 1 | 2022-06-06 | 89.46 | 2022-05-25 | 3578.27 | 1 | SO45824 | 2022-06-01 | 286.26 | 2171.29 | |
SO66170_1 | 100 | 19816 | 476 | 1 | 2024-05-17 | 1.75 | 2024-05-05 | 69.99 | 1 | SO66170 | 2024-05-12 | 5.60 | 26.18 | |
SO54786_2 | 100 | 16991 | 214 | 1 | 2023-11-25 | 0.87 | 2023-11-13 | 34.99 | 2 | SO54786 | 2023-11-20 | 2.80 | 13.09 | |
SO68417_1 | 100 | 26450 | 538 | 1 | 2024-06-20 | 0.54 | 2024-06-08 | 21.49 | 1 | SO68417 | 2024-06-15 | 1.72 | 8.04 | |
SO70979_3 | 100 | 12425 | 228 | 1 | 2024-07-23 | 1.25 | 2024-07-11 | 49.99 | 3 | SO70979 | 2024-07-18 | 4.00 | 38.49 |
Generated 2024-09-21 05:51:53.317 UTC