[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > SHUFFLE < SKIP 1500 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO60301_1 | 100 | 29138 | 585 | 4 | 2024-04-14 | 18.56 | 2024-04-02 | 742.35 | 1 | SO60301 | 2024-04-09 | 59.39 | 461.44 | |
SO68593_2 | 100 | 13332 | 217 | 4 | 2024-08-15 | 0.87 | 2024-08-03 | 34.99 | 2 | SO68593 | 2024-08-10 | 2.80 | 13.09 | |
SO70262_2 | 100 | 29077 | 539 | 4 | 2024-09-05 | 0.62 | 2024-08-24 | 24.99 | 2 | SO70262 | 2024-08-31 | 2.00 | 9.35 | |
SO57977_1 | 100 | 25965 | 535 | 4 | 2024-03-12 | 0.62 | 2024-02-29 | 24.99 | 1 | SO57977 | 2024-03-07 | 2.00 | 9.35 | |
SO63687_3 | 100 | 20709 | 529 | 4 | 2024-06-03 | 0.10 | 2024-05-22 | 3.99 | 3 | SO63687 | 2024-05-29 | 0.32 | 1.49 | |
SO69232_2 | 100 | 23807 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 2 | SO69232 | 2024-08-19 | 0.40 | 1.87 | |
SO67192_1 | 100 | 29252 | 570 | 4 | 2024-07-26 | 18.56 | 2024-07-14 | 742.35 | 1 | SO67192 | 2024-07-21 | 59.39 | 461.44 | |
SO66905_1 | 100 | 20010 | 474 | 4 | 2024-07-22 | 1.75 | 2024-07-10 | 69.99 | 1 | SO66905 | 2024-07-17 | 5.60 | 26.18 | |
SO65763_1 | 100 | 20504 | 478 | 4 | 2024-07-04 | 0.25 | 2024-06-22 | 9.99 | 1 | SO65763 | 2024-06-29 | 0.80 | 3.74 | |
SO67754_1 | 100 | 23815 | 605 | 4 | 2024-08-02 | 13.50 | 2024-07-21 | 539.99 | 1 | SO67754 | 2024-07-28 | 43.20 | 343.65 | |
SO51187_1 | 100 | 22261 | 606 | 2 | 4 | 2023-10-27 | 13.50 | 2023-10-15 | 539.99 | 1 | SO51187 | 2023-10-22 | 43.20 | 343.65 |
SO63616_2 | 100 | 17662 | 488 | 4 | 2024-06-02 | 1.35 | 2024-05-21 | 53.99 | 2 | SO63616 | 2024-05-28 | 4.32 | 41.57 | |
SO72742_2 | 100 | 29050 | 217 | 4 | 2024-10-08 | 0.87 | 2024-09-26 | 34.99 | 2 | SO72742 | 2024-10-03 | 2.80 | 13.09 | |
SO67900_2 | 100 | 21269 | 217 | 4 | 2024-08-04 | 0.87 | 2024-07-23 | 34.99 | 2 | SO67900 | 2024-07-30 | 2.80 | 13.09 | |
SO46282_1 | 100 | 26058 | 345 | 4 | 2022-09-19 | 85.00 | 2022-09-07 | 3399.99 | 1 | SO46282 | 2022-09-14 | 272.00 | 1912.15 | |
SO70925_3 | 100 | 27663 | 231 | 4 | 2024-09-14 | 1.25 | 2024-09-02 | 49.99 | 3 | SO70925 | 2024-09-09 | 4.00 | 38.49 | |
SO65739_1 | 100 | 18080 | 580 | 4 | 2024-07-03 | 42.52 | 2024-06-21 | 1700.99 | 1 | SO65739 | 2024-06-28 | 136.08 | 1082.51 | |
SO66823_3 | 100 | 23391 | 479 | 4 | 2024-07-20 | 0.22 | 2024-07-08 | 8.99 | 3 | SO66823 | 2024-07-15 | 0.72 | 3.36 | |
SO51934_2 | 100 | 28237 | 538 | 4 | 2023-11-28 | 0.54 | 2023-11-16 | 21.49 | 2 | SO51934 | 2023-11-23 | 1.72 | 8.04 | |
SO65077_2 | 100 | 20685 | 214 | 4 | 2024-06-25 | 0.87 | 2024-06-13 | 34.99 | 2 | SO65077 | 2024-06-20 | 2.80 | 13.09 | |
SO61155_2 | 100 | 11797 | 537 | 4 | 2024-04-27 | 0.88 | 2024-04-15 | 35.00 | 2 | SO61155 | 2024-04-22 | 2.80 | 13.09 | |
SO71319_2 | 100 | 19992 | 485 | 4 | 2024-09-20 | 0.55 | 2024-09-08 | 21.98 | 2 | SO71319 | 2024-09-15 | 1.76 | 8.22 | |
SO66755_2 | 100 | 26695 | 530 | 4 | 2024-07-19 | 0.12 | 2024-07-07 | 4.99 | 2 | SO66755 | 2024-07-14 | 0.40 | 1.87 | |
SO59256_2 | 100 | 26601 | 479 | 4 | 2024-03-30 | 0.22 | 2024-03-18 | 8.99 | 2 | SO59256 | 2024-03-25 | 0.72 | 3.36 | |
SO67365_2 | 100 | 21744 | 477 | 4 | 2024-07-28 | 0.12 | 2024-07-16 | 4.99 | 2 | SO67365 | 2024-07-23 | 0.40 | 1.87 | |
SO51404_1 | 100 | 21469 | 584 | 4 | 2023-11-09 | 13.50 | 2023-10-28 | 539.99 | 1 | SO51404 | 2023-11-04 | 43.20 | 343.65 | |
SO66066_2 | 100 | 26718 | 479 | 4 | 2024-07-08 | 0.22 | 2024-06-26 | 8.99 | 2 | SO66066 | 2024-07-03 | 0.72 | 3.36 | |
SO62012_3 | 100 | 25943 | 479 | 4 | 2024-05-10 | 0.22 | 2024-04-28 | 8.99 | 3 | SO62012 | 2024-05-05 | 0.72 | 3.36 | |
SO66184_1 | 100 | 13365 | 485 | 4 | 2024-07-10 | 0.55 | 2024-06-28 | 21.98 | 1 | SO66184 | 2024-07-05 | 1.76 | 8.22 | |
SO61682_1 | 100 | 25966 | 535 | 4 | 2024-05-05 | 0.62 | 2024-04-23 | 24.99 | 1 | SO61682 | 2024-04-30 | 2.00 | 9.35 | |
SO62936_1 | 100 | 26070 | 564 | 4 | 2024-05-25 | 59.60 | 2024-05-13 | 2384.07 | 1 | SO62936 | 2024-05-20 | 190.73 | 1481.94 | |
SO71408_1 | 100 | 18351 | 357 | 2 | 4 | 2024-09-21 | 58.00 | 2024-09-09 | 2319.99 | 1 | SO71408 | 2024-09-16 | 185.60 | 1265.62 |
SO58883_3 | 100 | 17022 | 225 | 4 | 2024-03-27 | 0.22 | 2024-03-15 | 8.99 | 3 | SO58883 | 2024-03-22 | 0.72 | 6.92 | |
SO72406_2 | 100 | 18528 | 485 | 4 | 2024-10-03 | 0.55 | 2024-09-21 | 21.98 | 2 | SO72406 | 2024-09-28 | 1.76 | 8.22 | |
SO68377_1 | 100 | 14891 | 589 | 4 | 2024-08-12 | 19.24 | 2024-07-31 | 769.49 | 1 | SO68377 | 2024-08-07 | 61.56 | 419.78 | |
SO53992_1 | 100 | 28331 | 488 | 4 | 2024-01-04 | 1.35 | 2023-12-23 | 53.99 | 1 | SO53992 | 2023-12-30 | 4.32 | 41.57 | |
SO67593_1 | 100 | 25278 | 540 | 4 | 2024-07-31 | 0.82 | 2024-07-19 | 32.60 | 1 | SO67593 | 2024-07-26 | 2.61 | 12.19 | |
SO56681_1 | 100 | 11625 | 359 | 4 | 2024-02-20 | 57.37 | 2024-02-08 | 2294.99 | 1 | SO56681 | 2024-02-15 | 183.60 | 1251.98 | |
SO61952_3 | 100 | 14451 | 528 | 4 | 2024-05-09 | 0.12 | 2024-04-27 | 4.99 | 3 | SO61952 | 2024-05-04 | 0.40 | 1.87 | |
SO72909_2 | 100 | 18441 | 473 | 4 | 2024-10-10 | 1.59 | 2024-09-28 | 63.50 | 2 | SO72909 | 2024-10-05 | 5.08 | 23.75 | |
SO63808_1 | 100 | 23082 | 584 | 4 | 2024-06-05 | 13.50 | 2024-05-24 | 539.99 | 1 | SO63808 | 2024-05-31 | 43.20 | 343.65 | |
SO58410_2 | 100 | 20067 | 222 | 4 | 2024-03-19 | 0.87 | 2024-03-07 | 34.99 | 2 | SO58410 | 2024-03-14 | 2.80 | 13.09 | |
SO53940_1 | 100 | 20636 | 478 | 4 | 2024-01-03 | 0.25 | 2023-12-22 | 9.99 | 1 | SO53940 | 2023-12-29 | 0.80 | 3.74 | |
SO55640_4 | 100 | 15260 | 225 | 4 | 2024-02-01 | 0.22 | 2024-01-20 | 8.99 | 4 | SO55640 | 2024-01-27 | 0.72 | 6.92 | |
SO72907_3 | 100 | 15474 | 490 | 4 | 2024-10-10 | 1.35 | 2024-09-28 | 53.99 | 3 | SO72907 | 2024-10-05 | 4.32 | 41.57 | |
SO65421_1 | 100 | 14250 | 485 | 4 | 2024-06-28 | 0.55 | 2024-06-16 | 21.98 | 1 | SO65421 | 2024-06-23 | 1.76 | 8.22 | |
SO45761_1 | 100 | 11629 | 314 | 4 | 2022-07-24 | 89.46 | 2022-07-12 | 3578.27 | 1 | SO45761 | 2022-07-19 | 286.26 | 2171.29 | |
SO64750_1 | 100 | 20289 | 476 | 4 | 2024-06-20 | 1.75 | 2024-06-08 | 69.99 | 1 | SO64750 | 2024-06-15 | 5.60 | 26.18 | |
SO71206_1 | 100 | 23836 | 604 | 4 | 2024-09-18 | 13.50 | 2024-09-06 | 539.99 | 1 | SO71206 | 2024-09-13 | 43.20 | 343.65 | |
SO65516_3 | 100 | 21936 | 214 | 4 | 2024-06-30 | 0.87 | 2024-06-18 | 34.99 | 3 | SO65516 | 2024-06-25 | 2.80 | 13.09 | |
SO68168_1 | 100 | 26518 | 528 | 4 | 2024-08-09 | 0.12 | 2024-07-28 | 4.99 | 1 | SO68168 | 2024-08-04 | 0.40 | 1.87 | |
SO71201_1 | 100 | 26093 | 577 | 4 | 2024-09-18 | 30.37 | 2024-09-06 | 1214.85 | 1 | SO71201 | 2024-09-13 | 97.19 | 755.15 | |
SO72924_2 | 100 | 28296 | 222 | 4 | 2024-10-10 | 0.87 | 2024-09-28 | 34.99 | 2 | SO72924 | 2024-10-05 | 2.80 | 13.09 | |
SO61649_1 | 100 | 20400 | 382 | 4 | 2024-05-04 | 28.01 | 2024-04-22 | 1120.49 | 1 | SO61649 | 2024-04-29 | 89.64 | 713.08 | |
SO70562_2 | 100 | 12412 | 528 | 4 | 2024-09-09 | 0.12 | 2024-08-28 | 4.99 | 2 | SO70562 | 2024-09-04 | 0.40 | 1.87 | |
SO50122_1 | 100 | 15844 | 341 | 4 | 2023-08-20 | 19.57 | 2023-08-08 | 782.99 | 1 | SO50122 | 2023-08-15 | 62.64 | 486.71 | |
SO60340_1 | 100 | 26475 | 538 | 4 | 2024-04-15 | 0.54 | 2024-04-03 | 21.49 | 1 | SO60340 | 2024-04-10 | 1.72 | 8.04 | |
SO66009_4 | 100 | 27092 | 228 | 4 | 2024-07-07 | 1.25 | 2024-06-25 | 49.99 | 4 | SO66009 | 2024-07-02 | 4.00 | 38.49 | |
SO58792_4 | 100 | 23184 | 484 | 4 | 2024-03-26 | 0.20 | 2024-03-14 | 7.95 | 4 | SO58792 | 2024-03-21 | 0.64 | 2.97 | |
SO73859_1 | 100 | 19124 | 583 | 4 | 2024-10-22 | 42.52 | 2024-10-10 | 1700.99 | 1 | SO73859 | 2024-10-17 | 136.08 | 1082.51 | |
SO57748_1 | 100 | 11853 | 237 | 4 | 2024-03-08 | 1.25 | 2024-02-25 | 49.99 | 1 | SO57748 | 2024-03-03 | 4.00 | 38.49 | |
SO74538_2 | 100 | 11065 | 480 | 4 | 2024-11-08 | 0.06 | 2024-10-27 | 2.29 | 2 | SO74538 | 2024-11-03 | 0.18 | 0.86 |
Generated 2024-11-14 16:47:23.097 UTC