[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SKIP 0 SHUFFLE < SKIP 4344 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO50000_1 | 100 | 27116 | 352 | 1 | 2023-06-13 | 51.79 | 2023-06-01 | 2071.42 | 1 | SO50000 | 2023-06-08 | 165.71 | 1117.86 | |
SO53031_3 | 100 | 21159 | 222 | 1 | 2023-10-26 | 0.87 | 2023-10-14 | 34.99 | 3 | SO53031 | 2023-10-21 | 2.80 | 13.09 | |
SO69604_2 | 100 | 14625 | 480 | 2 | 1 | 2024-07-03 | 0.06 | 2024-06-21 | 2.29 | 2 | SO69604 | 2024-06-28 | 0.18 | 0.86 |
SO67604_3 | 100 | 13386 | 225 | 1 | 2024-06-06 | 0.22 | 2024-05-25 | 8.99 | 3 | SO67604 | 2024-06-01 | 0.72 | 6.92 | |
SO68317_3 | 100 | 11679 | 217 | 1 | 2024-06-17 | 0.87 | 2024-06-05 | 34.99 | 3 | SO68317 | 2024-06-12 | 2.80 | 13.09 | |
SO65016_1 | 100 | 22994 | 584 | 1 | 2024-04-30 | 13.50 | 2024-04-18 | 539.99 | 1 | SO65016 | 2024-04-25 | 43.20 | 343.65 | |
SO44156_1 | 100 | 25887 | 346 | 1 | 2021-11-06 | 85.00 | 2021-10-25 | 3399.99 | 1 | SO44156 | 2021-11-01 | 272.00 | 1912.15 | |
SO51584_1 | 100 | 22274 | 605 | 1 | 2023-09-26 | 13.50 | 2023-09-14 | 539.99 | 1 | SO51584 | 2023-09-21 | 43.20 | 343.65 | |
SO60095_1 | 100 | 12025 | 359 | 1 | 2024-02-16 | 57.37 | 2024-02-04 | 2294.99 | 1 | SO60095 | 2024-02-11 | 183.60 | 1251.98 | |
SO60781_3 | 100 | 25069 | 217 | 1 | 2024-02-27 | 0.87 | 2024-02-15 | 34.99 | 3 | SO60781 | 2024-02-22 | 2.80 | 13.09 | |
SO55689_1 | 100 | 11532 | 480 | 1 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 1 | SO55689 | 2023-12-04 | 0.18 | 0.86 | |
SO50362_1 | 100 | 27292 | 362 | 2 | 1 | 2023-07-06 | 51.23 | 2023-06-24 | 2049.10 | 1 | SO50362 | 2023-07-01 | 163.93 | 1105.81 |
SO57822_1 | 100 | 11206 | 528 | 1 | 2024-01-14 | 0.12 | 2024-01-02 | 4.99 | 1 | SO57822 | 2024-01-09 | 0.40 | 1.87 | |
SO56589_1 | 100 | 22874 | 605 | 1 | 2023-12-25 | 13.50 | 2023-12-13 | 539.99 | 1 | SO56589 | 2023-12-20 | 43.20 | 343.65 | |
SO74959_3 | 100 | 14869 | 477 | 1 | 2024-09-27 | 0.12 | 2024-09-15 | 4.99 | 3 | SO74959 | 2024-09-22 | 0.40 | 1.87 | |
SO66903_1 | 100 | 20539 | 477 | 1 | 2024-05-28 | 0.12 | 2024-05-16 | 4.99 | 1 | SO66903 | 2024-05-23 | 0.40 | 1.87 | |
SO60923_1 | 100 | 12759 | 485 | 1 | 2024-02-29 | 0.55 | 2024-02-17 | 21.98 | 1 | SO60923 | 2024-02-24 | 1.76 | 8.22 | |
SO53170_2 | 100 | 12059 | 485 | 1 | 2023-10-28 | 0.55 | 2023-10-16 | 21.98 | 2 | SO53170 | 2023-10-23 | 1.76 | 8.22 | |
SO71977_2 | 100 | 13441 | 467 | 1 | 2024-08-03 | 0.61 | 2024-07-22 | 24.49 | 2 | SO71977 | 2024-07-29 | 1.96 | 9.16 | |
SO68018_1 | 100 | 23733 | 606 | 1 | 2024-06-12 | 13.50 | 2024-05-31 | 539.99 | 1 | SO68018 | 2024-06-07 | 43.20 | 343.65 | |
SO56911_1 | 100 | 28599 | 484 | 1 | 2024-01-01 | 0.20 | 2023-12-20 | 7.95 | 1 | SO56911 | 2023-12-27 | 0.64 | 2.97 | |
SO67372_2 | 100 | 14509 | 486 | 1 | 2024-06-03 | 3.98 | 2024-05-22 | 159.00 | 2 | SO67372 | 2024-05-29 | 12.72 | 59.47 | |
SO60601_4 | 100 | 11829 | 478 | 1 | 2024-02-24 | 0.25 | 2024-02-12 | 9.99 | 4 | SO60601 | 2024-02-19 | 0.80 | 3.74 | |
SO67455_2 | 100 | 14003 | 535 | 1 | 2024-06-04 | 0.62 | 2024-05-23 | 24.99 | 2 | SO67455 | 2024-05-30 | 2.00 | 9.35 | |
SO67921_2 | 100 | 20342 | 476 | 1 | 2024-06-11 | 1.75 | 2024-05-30 | 69.99 | 2 | SO67921 | 2024-06-06 | 5.60 | 26.18 | |
SO73308_2 | 100 | 13712 | 480 | 1 | 2024-08-21 | 0.06 | 2024-08-09 | 2.29 | 2 | SO73308 | 2024-08-16 | 0.18 | 0.86 | |
SO67135_3 | 100 | 27017 | 530 | 1 | 2024-05-31 | 0.12 | 2024-05-19 | 4.99 | 3 | SO67135 | 2024-05-26 | 0.40 | 1.87 | |
SO74013_2 | 100 | 21436 | 479 | 1 | 2024-08-30 | 0.22 | 2024-08-18 | 8.99 | 2 | SO74013 | 2024-08-25 | 0.72 | 3.36 | |
SO56923_3 | 100 | 21782 | 217 | 1 | 2024-01-01 | 0.87 | 2023-12-20 | 34.99 | 3 | SO56923 | 2023-12-27 | 2.80 | 13.09 | |
SO69703_4 | 100 | 17604 | 217 | 1 | 2024-07-04 | 0.87 | 2024-06-22 | 34.99 | 4 | SO69703 | 2024-06-29 | 2.80 | 13.09 | |
SO55469_3 | 100 | 26259 | 222 | 1 | 2023-12-05 | 0.87 | 2023-11-23 | 34.99 | 3 | SO55469 | 2023-11-30 | 2.80 | 13.09 | |
SO47580_1 | 100 | 14080 | 389 | 1 | 2022-11-21 | 25.01 | 2022-11-09 | 1000.44 | 1 | SO47580 | 2022-11-16 | 80.04 | 605.65 | |
SO64261_1 | 100 | 25275 | 540 | 1 | 2024-04-19 | 0.82 | 2024-04-07 | 32.60 | 1 | SO64261 | 2024-04-14 | 2.61 | 12.19 | |
SO73436_4 | 100 | 26282 | 228 | 1 | 2024-08-23 | 1.25 | 2024-08-11 | 49.99 | 4 | SO73436 | 2024-08-18 | 4.00 | 38.49 | |
SO60679_1 | 100 | 19657 | 594 | 1 | 2024-02-25 | 14.12 | 2024-02-13 | 564.99 | 1 | SO60679 | 2024-02-20 | 45.20 | 308.22 | |
SO67388_2 | 100 | 16105 | 485 | 1 | 2024-06-03 | 0.55 | 2024-05-22 | 21.98 | 2 | SO67388 | 2024-05-29 | 1.76 | 8.22 | |
SO50474_1 | 100 | 27269 | 362 | 2 | 1 | 2023-07-16 | 51.23 | 2023-07-04 | 2049.10 | 1 | SO50474 | 2023-07-11 | 163.93 | 1105.81 |
SO71639_2 | 100 | 28056 | 225 | 1 | 2024-08-01 | 0.22 | 2024-07-20 | 8.99 | 2 | SO71639 | 2024-07-27 | 0.72 | 6.92 | |
SO52560_1 | 100 | 11231 | 528 | 1 | 2023-10-16 | 0.12 | 2023-10-04 | 4.99 | 1 | SO52560 | 2023-10-11 | 0.40 | 1.87 | |
SO48960_1 | 100 | 26726 | 354 | 1 | 2023-03-25 | 51.79 | 2023-03-13 | 2071.42 | 1 | SO48960 | 2023-03-20 | 165.71 | 1117.86 | |
SO56568_3 | 100 | 15173 | 477 | 1 | 2023-12-25 | 0.12 | 2023-12-13 | 4.99 | 3 | SO56568 | 2023-12-20 | 0.40 | 1.87 | |
SO68116_2 | 100 | 18861 | 471 | 1 | 2024-06-14 | 1.59 | 2024-06-02 | 63.50 | 2 | SO68116 | 2024-06-09 | 5.08 | 23.75 | |
SO52721_2 | 100 | 25097 | 488 | 1 | 2023-10-19 | 1.35 | 2023-10-07 | 53.99 | 2 | SO52721 | 2023-10-14 | 4.32 | 41.57 | |
SO48928_1 | 100 | 15502 | 333 | 1 | 2023-03-20 | 19.57 | 2023-03-08 | 782.99 | 1 | SO48928 | 2023-03-15 | 62.64 | 486.71 | |
SO56658_3 | 100 | 20489 | 222 | 1 | 2023-12-27 | 0.87 | 2023-12-15 | 34.99 | 3 | SO56658 | 2023-12-22 | 2.80 | 13.09 | |
SO57979_2 | 100 | 21784 | 477 | 1 | 2024-01-17 | 0.12 | 2024-01-05 | 4.99 | 2 | SO57979 | 2024-01-12 | 0.40 | 1.87 | |
SO65896_2 | 100 | 22056 | 528 | 1 | 2024-05-12 | 0.12 | 2024-04-30 | 4.99 | 2 | SO65896 | 2024-05-07 | 0.40 | 1.87 | |
SO58724_2 | 100 | 28256 | 467 | 1 | 2024-01-30 | 0.61 | 2024-01-18 | 24.49 | 2 | SO58724 | 2024-01-25 | 1.96 | 9.16 | |
SO70418_1 | 100 | 11972 | 528 | 1 | 2024-07-14 | 0.12 | 2024-07-02 | 4.99 | 1 | SO70418 | 2024-07-09 | 0.40 | 1.87 | |
SO66919_1 | 100 | 13718 | 591 | 1 | 2024-05-28 | 14.12 | 2024-05-16 | 564.99 | 1 | SO66919 | 2024-05-23 | 45.20 | 308.22 | |
SO47299_1 | 100 | 13425 | 369 | 2 | 1 | 2022-10-28 | 61.08 | 2022-10-16 | 2443.35 | 1 | SO47299 | 2022-10-23 | 195.47 | 1518.79 |
SO73308_1 | 100 | 13712 | 357 | 1 | 2024-08-21 | 58.00 | 2024-08-09 | 2319.99 | 1 | SO73308 | 2024-08-16 | 185.60 | 1265.62 | |
SO66722_1 | 100 | 19228 | 476 | 1 | 2024-05-25 | 1.75 | 2024-05-13 | 69.99 | 1 | SO66722 | 2024-05-20 | 5.60 | 26.18 | |
SO69053_2 | 100 | 12973 | 537 | 1 | 2024-06-28 | 0.88 | 2024-06-16 | 35.00 | 2 | SO69053 | 2024-06-23 | 2.80 | 13.09 | |
SO58122_2 | 100 | 22093 | 479 | 1 | 2024-01-19 | 0.22 | 2024-01-07 | 8.99 | 2 | SO58122 | 2024-01-14 | 0.72 | 3.36 | |
SO58725_1 | 100 | 27033 | 530 | 1 | 2024-01-30 | 0.12 | 2024-01-18 | 4.99 | 1 | SO58725 | 2024-01-25 | 0.40 | 1.87 | |
SO59801_1 | 100 | 14494 | 587 | 1 | 2024-02-12 | 19.24 | 2024-01-31 | 769.49 | 1 | SO59801 | 2024-02-07 | 61.56 | 419.78 | |
SO63966_1 | 100 | 18822 | 474 | 1 | 2024-04-14 | 1.75 | 2024-04-02 | 69.99 | 1 | SO63966 | 2024-04-09 | 5.60 | 26.18 | |
SO72923_1 | 100 | 25084 | 561 | 1 | 2024-08-16 | 59.60 | 2024-08-04 | 2384.07 | 1 | SO72923 | 2024-08-11 | 190.73 | 1481.94 | |
SO48414_1 | 100 | 13718 | 369 | 2 | 1 | 2023-02-03 | 61.08 | 2023-01-22 | 2443.35 | 1 | SO48414 | 2023-01-29 | 195.47 | 1518.79 |
SO62102_3 | 100 | 23734 | 214 | 1 | 2024-03-18 | 0.87 | 2024-03-06 | 34.99 | 3 | SO62102 | 2024-03-13 | 2.80 | 13.09 | |
SO63373_1 | 100 | 11621 | 480 | 1 | 2024-04-05 | 0.06 | 2024-03-24 | 2.29 | 1 | SO63373 | 2024-03-31 | 0.18 | 0.86 |
Generated 2024-09-20 06:37:14.897 UTC