[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > SHUFFLE SKIP 1500 < SKIP 1063 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO68642_1 | 100 | 25170 | 540 | 1 | 2024-08-11 | 0.82 | 2024-07-30 | 32.60 | 1 | SO68642 | 2024-08-06 | 2.61 | 12.19 | |
SO64436_1 | 100 | 26619 | 572 | 2 | 1 | 2024-06-10 | 18.56 | 2024-05-29 | 742.35 | 1 | SO64436 | 2024-06-05 | 59.39 | 461.44 |
SO62445_5 | 100 | 12084 | 234 | 1 | 2024-05-12 | 1.25 | 2024-04-30 | 49.99 | 5 | SO62445 | 2024-05-07 | 4.00 | 38.49 | |
SO72776_3 | 100 | 11263 | 463 | 1 | 2024-10-03 | 0.61 | 2024-09-21 | 24.49 | 3 | SO72776 | 2024-09-28 | 1.96 | 9.16 | |
SO59426_3 | 100 | 25870 | 484 | 1 | 2024-03-28 | 0.20 | 2024-03-16 | 7.95 | 3 | SO59426 | 2024-03-23 | 0.64 | 2.97 | |
SO68042_3 | 100 | 22763 | 217 | 1 | 2024-08-02 | 0.87 | 2024-07-21 | 34.99 | 3 | SO68042 | 2024-07-28 | 2.80 | 13.09 | |
SO52995_3 | 100 | 12938 | 463 | 1 | 2023-12-14 | 0.61 | 2023-12-02 | 24.49 | 3 | SO52995 | 2023-12-09 | 1.96 | 9.16 | |
SO60290_1 | 100 | 13894 | 359 | 1 | 2024-04-09 | 57.37 | 2024-03-28 | 2294.99 | 1 | SO60290 | 2024-04-04 | 183.60 | 1251.98 | |
SO62446_4 | 100 | 14439 | 480 | 1 | 2024-05-12 | 0.06 | 2024-04-30 | 2.29 | 4 | SO62446 | 2024-05-07 | 0.18 | 0.86 | |
SO61518_1 | 100 | 11235 | 537 | 1 | 2024-04-27 | 0.88 | 2024-04-15 | 35.00 | 1 | SO61518 | 2024-04-22 | 2.80 | 13.09 | |
SO58756_1 | 100 | 17144 | 583 | 1 | 2024-03-20 | 42.52 | 2024-03-08 | 1700.99 | 1 | SO58756 | 2024-03-15 | 136.08 | 1082.51 | |
SO54790_3 | 100 | 15759 | 234 | 1 | 2024-01-13 | 1.25 | 2024-01-01 | 49.99 | 3 | SO54790 | 2024-01-08 | 4.00 | 38.49 | |
SO60710_1 | 100 | 25843 | 535 | 1 | 2024-04-16 | 0.62 | 2024-04-04 | 24.99 | 1 | SO60710 | 2024-04-11 | 2.00 | 9.35 | |
SO69188_1 | 100 | 20383 | 476 | 1 | 2024-08-19 | 1.75 | 2024-08-07 | 69.99 | 1 | SO69188 | 2024-08-14 | 5.60 | 26.18 | |
SO62595_1 | 100 | 24821 | 540 | 1 | 2024-05-15 | 0.82 | 2024-05-03 | 32.60 | 1 | SO62595 | 2024-05-10 | 2.61 | 12.19 | |
SO49560_1 | 100 | 13892 | 375 | 1 | 2023-06-23 | 54.54 | 2023-06-11 | 2181.56 | 1 | SO49560 | 2023-06-18 | 174.53 | 1320.68 | |
SO66970_1 | 100 | 20272 | 475 | 1 | 2024-07-18 | 1.75 | 2024-07-06 | 69.99 | 1 | SO66970 | 2024-07-13 | 5.60 | 26.18 | |
SO60675_2 | 100 | 12204 | 528 | 1 | 2024-04-15 | 0.12 | 2024-04-03 | 4.99 | 2 | SO60675 | 2024-04-10 | 0.40 | 1.87 | |
SO68924_2 | 100 | 13087 | 537 | 1 | 2024-08-15 | 0.88 | 2024-08-03 | 35.00 | 2 | SO68924 | 2024-08-10 | 2.80 | 13.09 | |
SO50074_1 | 100 | 27117 | 356 | 1 | 2023-08-09 | 51.79 | 2023-07-28 | 2071.42 | 1 | SO50074 | 2023-08-04 | 165.71 | 1117.86 | |
SO69041_2 | 100 | 23303 | 528 | 1 | 2024-08-17 | 0.12 | 2024-08-05 | 4.99 | 2 | SO69041 | 2024-08-12 | 0.40 | 1.87 | |
SO72530_2 | 100 | 20521 | 477 | 1 | 2024-09-30 | 0.12 | 2024-09-18 | 4.99 | 2 | SO72530 | 2024-09-25 | 0.40 | 1.87 | |
SO74512_1 | 100 | 26597 | 541 | 1 | 2024-11-02 | 0.72 | 2024-10-21 | 28.99 | 1 | SO74512 | 2024-10-28 | 2.32 | 10.84 | |
SO65773_3 | 100 | 15851 | 485 | 1 | 2024-06-29 | 0.55 | 2024-06-17 | 21.98 | 3 | SO65773 | 2024-06-24 | 1.76 | 8.22 | |
SO58794_3 | 100 | 20457 | 234 | 1 | 2024-03-21 | 1.25 | 2024-03-09 | 49.99 | 3 | SO58794 | 2024-03-16 | 4.00 | 38.49 | |
SO59592_3 | 100 | 23200 | 485 | 1 | 2024-03-30 | 0.55 | 2024-03-18 | 21.98 | 3 | SO59592 | 2024-03-25 | 1.76 | 8.22 | |
SO71514_1 | 100 | 26006 | 535 | 1 | 2024-09-18 | 0.62 | 2024-09-06 | 24.99 | 1 | SO71514 | 2024-09-13 | 2.00 | 9.35 | |
SO67401_2 | 100 | 21482 | 479 | 1 | 2024-07-23 | 0.22 | 2024-07-11 | 8.99 | 2 | SO67401 | 2024-07-18 | 0.72 | 3.36 | |
SO70688_1 | 100 | 27048 | 541 | 1 | 2024-09-06 | 0.72 | 2024-08-25 | 28.99 | 1 | SO70688 | 2024-09-01 | 2.32 | 10.84 | |
SO61810_2 | 100 | 18753 | 491 | 1 | 2024-05-02 | 1.35 | 2024-04-20 | 53.99 | 2 | SO61810 | 2024-04-27 | 4.32 | 41.57 | |
SO57762_1 | 100 | 21241 | 225 | 1 | 2024-03-03 | 0.22 | 2024-02-20 | 8.99 | 1 | SO57762 | 2024-02-27 | 0.72 | 6.92 | |
SO72982_1 | 100 | 20285 | 474 | 1 | 2024-10-06 | 1.75 | 2024-09-24 | 69.99 | 1 | SO72982 | 2024-10-01 | 5.60 | 26.18 | |
SO70886_1 | 100 | 26323 | 535 | 1 | 2024-09-09 | 0.62 | 2024-08-28 | 24.99 | 1 | SO70886 | 2024-09-04 | 2.00 | 9.35 | |
SO58043_2 | 100 | 22211 | 536 | 1 | 2024-03-08 | 0.75 | 2024-02-25 | 29.99 | 2 | SO58043 | 2024-03-03 | 2.40 | 11.22 | |
SO61986_4 | 100 | 23333 | 237 | 1 | 2024-05-05 | 1.25 | 2024-04-23 | 49.99 | 4 | SO61986 | 2024-04-30 | 4.00 | 38.49 | |
SO72898_2 | 100 | 11684 | 537 | 1 | 2024-10-05 | 0.88 | 2024-09-23 | 35.00 | 2 | SO72898 | 2024-09-30 | 2.80 | 13.09 | |
SO52388_4 | 100 | 13458 | 484 | 1 | 2023-12-02 | 0.20 | 2023-11-20 | 7.95 | 4 | SO52388 | 2023-11-27 | 0.64 | 2.97 | |
SO64747_2 | 100 | 23090 | 536 | 1 | 2024-06-15 | 0.75 | 2024-06-03 | 29.99 | 2 | SO64747 | 2024-06-10 | 2.40 | 11.22 | |
SO46828_1 | 100 | 13990 | 385 | 1 | 2022-11-09 | 25.01 | 2022-10-28 | 1000.44 | 1 | SO46828 | 2022-11-04 | 80.04 | 605.65 | |
SO73447_1 | 100 | 17550 | 477 | 1 | 2024-10-12 | 0.12 | 2024-09-30 | 4.99 | 1 | SO73447 | 2024-10-07 | 0.40 | 1.87 | |
SO60949_1 | 100 | 22255 | 584 | 1 | 2024-04-19 | 13.50 | 2024-04-07 | 539.99 | 1 | SO60949 | 2024-04-14 | 43.20 | 343.65 | |
SO52502_2 | 100 | 13848 | 478 | 1 | 2023-12-04 | 0.25 | 2023-11-22 | 9.99 | 2 | SO52502 | 2023-11-29 | 0.80 | 3.74 | |
SO57393_1 | 100 | 20358 | 476 | 1 | 2024-02-25 | 1.75 | 2024-02-13 | 69.99 | 1 | SO57393 | 2024-02-20 | 5.60 | 26.18 | |
SO59430_2 | 100 | 22240 | 480 | 2 | 1 | 2024-03-28 | 0.06 | 2024-03-16 | 2.29 | 2 | SO59430 | 2024-03-23 | 0.18 | 0.86 |
SO64097_3 | 100 | 11128 | 478 | 1 | 2024-06-05 | 0.25 | 2024-05-24 | 9.99 | 3 | SO64097 | 2024-05-31 | 0.80 | 3.74 | |
SO54845_1 | 100 | 17158 | 477 | 1 | 2024-01-14 | 0.12 | 2024-01-02 | 4.99 | 1 | SO54845 | 2024-01-09 | 0.40 | 1.87 | |
SO71620_1 | 100 | 18639 | 581 | 1 | 2024-09-19 | 42.52 | 2024-09-07 | 1700.99 | 1 | SO71620 | 2024-09-14 | 136.08 | 1082.51 | |
SO74928_1 | 100 | 22263 | 536 | 1 | 2024-11-15 | 0.75 | 2024-11-03 | 29.99 | 1 | SO74928 | 2024-11-10 | 2.40 | 11.22 | |
SO61835_4 | 100 | 14577 | 480 | 1 | 2024-05-02 | 0.06 | 2024-04-20 | 2.29 | 4 | SO61835 | 2024-04-27 | 0.18 | 0.86 | |
SO60179_1 | 100 | 12954 | 225 | 1 | 2024-04-08 | 0.22 | 2024-03-27 | 8.99 | 1 | SO60179 | 2024-04-03 | 0.72 | 6.92 | |
SO53365_3 | 100 | 23188 | 222 | 1 | 2023-12-21 | 0.87 | 2023-12-09 | 34.99 | 3 | SO53365 | 2023-12-16 | 2.80 | 13.09 | |
SO57654_1 | 100 | 13652 | 485 | 1 | 2024-03-01 | 0.55 | 2024-02-18 | 21.98 | 1 | SO57654 | 2024-02-25 | 1.76 | 8.22 | |
SO70044_3 | 100 | 20389 | 484 | 1 | 2024-08-28 | 0.20 | 2024-08-16 | 7.95 | 3 | SO70044 | 2024-08-23 | 0.64 | 2.97 | |
SO67856_1 | 100 | 24758 | 540 | 1 | 2024-07-30 | 0.82 | 2024-07-18 | 32.60 | 1 | SO67856 | 2024-07-25 | 2.61 | 12.19 | |
SO46279_1 | 100 | 12155 | 312 | 1 | 2022-09-14 | 89.46 | 2022-09-02 | 3578.27 | 1 | SO46279 | 2022-09-09 | 286.26 | 2171.29 | |
SO63859_1 | 100 | 12445 | 485 | 1 | 2024-06-01 | 0.55 | 2024-05-20 | 21.98 | 1 | SO63859 | 2024-05-27 | 1.76 | 8.22 | |
SO62866_3 | 100 | 25863 | 479 | 1 | 2024-05-19 | 0.22 | 2024-05-07 | 8.99 | 3 | SO62866 | 2024-05-14 | 0.72 | 3.36 | |
SO60601_4 | 100 | 11829 | 478 | 1 | 2024-04-14 | 0.25 | 2024-04-02 | 9.99 | 4 | SO60601 | 2024-04-09 | 0.80 | 3.74 | |
SO45984_1 | 100 | 11690 | 313 | 1 | 2022-08-18 | 89.46 | 2022-08-06 | 3578.27 | 1 | SO45984 | 2022-08-13 | 286.26 | 2171.29 | |
SO64892_3 | 100 | 20646 | 479 | 1 | 2024-06-17 | 0.22 | 2024-06-05 | 8.99 | 3 | SO64892 | 2024-06-12 | 0.72 | 3.36 | |
SO61052_3 | 100 | 22098 | 214 | 1 | 2024-04-21 | 0.87 | 2024-04-09 | 34.99 | 3 | SO61052 | 2024-04-16 | 2.80 | 13.09 | |
SO62684_2 | 100 | 22864 | 538 | 1 | 2024-05-16 | 0.54 | 2024-05-04 | 21.49 | 2 | SO62684 | 2024-05-11 | 1.72 | 8.04 |
Generated 2024-11-10 03:33:36.865 UTC