[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > SHUFFLE SKIP 50 < SKIP 1000 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48973_1 | 6 | 26656 | 337 | 9 | 2023-05-16 | 19.57 | 2023-05-04 | 782.99 | 1 | SO48973 | 2023-05-11 | 62.64 | 486.71 | |
SO62693_1 | 6 | 11893 | 575 | 9 | 2024-05-17 | 59.60 | 2024-05-05 | 2384.07 | 1 | SO62693 | 2024-05-12 | 190.73 | 1481.94 | |
SO73620_2 | 6 | 27862 | 479 | 9 | 2024-10-15 | 0.22 | 2024-10-03 | 8.99 | 2 | SO73620 | 2024-10-10 | 0.72 | 3.36 | |
SO60435_1 | 6 | 16160 | 593 | 9 | 2024-04-12 | 14.12 | 2024-03-31 | 564.99 | 1 | SO60435 | 2024-04-07 | 45.20 | 308.22 | |
SO58643_2 | 6 | 26592 | 225 | 9 | 2024-03-20 | 0.22 | 2024-03-08 | 8.99 | 2 | SO58643 | 2024-03-15 | 0.72 | 6.92 | |
SO58838_4 | 6 | 28484 | 480 | 2 | 9 | 2024-03-22 | 0.06 | 2024-03-10 | 2.29 | 4 | SO58838 | 2024-03-17 | 0.18 | 0.86 |
SO53349_1 | 6 | 18297 | 380 | 9 | 2023-12-22 | 61.08 | 2023-12-10 | 2443.35 | 1 | SO53349 | 2023-12-17 | 195.47 | 1554.95 | |
SO68273_2 | 6 | 28137 | 480 | 2 | 9 | 2024-08-07 | 0.06 | 2024-07-26 | 2.29 | 2 | SO68273 | 2024-08-02 | 0.18 | 0.86 |
SO66890_2 | 6 | 12034 | 222 | 9 | 2024-07-18 | 0.87 | 2024-07-06 | 34.99 | 2 | SO66890 | 2024-07-13 | 2.80 | 13.09 | |
SO58135_2 | 6 | 26785 | 528 | 9 | 2024-03-11 | 0.12 | 2024-02-28 | 4.99 | 2 | SO58135 | 2024-03-06 | 0.40 | 1.87 | |
SO64535_1 | 6 | 13621 | 484 | 9 | 2024-06-13 | 0.20 | 2024-06-01 | 7.95 | 1 | SO64535 | 2024-06-08 | 0.64 | 2.97 | |
SO62234_2 | 6 | 15593 | 480 | 9 | 2024-05-10 | 0.06 | 2024-04-28 | 2.29 | 2 | SO62234 | 2024-05-05 | 0.18 | 0.86 | |
SO47744_1 | 6 | 12989 | 360 | 9 | 2023-01-24 | 51.23 | 2023-01-12 | 2049.10 | 1 | SO47744 | 2023-01-19 | 163.93 | 1105.81 | |
SO68627_3 | 6 | 25139 | 214 | 9 | 2024-08-12 | 0.87 | 2024-07-31 | 34.99 | 3 | SO68627 | 2024-08-07 | 2.80 | 13.09 | |
SO66436_2 | 6 | 27976 | 491 | 9 | 2024-07-11 | 1.35 | 2024-06-29 | 53.99 | 2 | SO66436 | 2024-07-06 | 4.32 | 41.57 | |
SO55559_1 | 6 | 18743 | 485 | 9 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 1 | SO55559 | 2024-01-22 | 1.76 | 8.22 | |
SO48918_1 | 6 | 13638 | 362 | 2 | 9 | 2023-05-09 | 51.23 | 2023-04-27 | 2049.10 | 1 | SO48918 | 2023-05-04 | 163.93 | 1105.81 |
SO62286_2 | 6 | 24280 | 529 | 9 | 2024-05-11 | 0.10 | 2024-04-29 | 3.99 | 2 | SO62286 | 2024-05-06 | 0.32 | 1.49 | |
SO64530_1 | 6 | 24230 | 225 | 9 | 2024-06-13 | 0.22 | 2024-06-01 | 8.99 | 1 | SO64530 | 2024-06-08 | 0.72 | 6.92 | |
SO51196_5 | 6 | 18906 | 234 | 9 | 2023-10-24 | 1.25 | 2023-10-12 | 49.99 | 5 | SO51196 | 2023-10-19 | 4.00 | 38.49 | |
SO70022_2 | 6 | 18717 | 487 | 9 | 2024-08-29 | 1.37 | 2024-08-17 | 54.99 | 2 | SO70022 | 2024-08-24 | 4.40 | 20.57 | |
SO51881_2 | 6 | 21407 | 537 | 9 | 2023-11-23 | 0.88 | 2023-11-11 | 35.00 | 2 | SO51881 | 2023-11-18 | 2.80 | 13.09 | |
SO72000_1 | 6 | 13636 | 561 | 9 | 2024-09-23 | 59.60 | 2024-09-11 | 2384.07 | 1 | SO72000 | 2024-09-18 | 190.73 | 1481.94 | |
SO72736_1 | 6 | 17058 | 488 | 9 | 2024-10-04 | 1.35 | 2024-09-22 | 53.99 | 1 | SO72736 | 2024-09-29 | 4.32 | 41.57 | |
SO72825_3 | 6 | 24597 | 539 | 9 | 2024-10-05 | 0.62 | 2024-09-23 | 24.99 | 3 | SO72825 | 2024-09-30 | 2.00 | 9.35 | |
SO54473_3 | 6 | 28949 | 489 | 9 | 2024-01-08 | 1.35 | 2023-12-27 | 53.99 | 3 | SO54473 | 2024-01-03 | 4.32 | 41.57 | |
SO62084_2 | 6 | 11903 | 489 | 9 | 2024-05-07 | 1.35 | 2024-04-25 | 53.99 | 2 | SO62084 | 2024-05-02 | 4.32 | 41.57 | |
SO66252_2 | 6 | 21555 | 540 | 9 | 2024-07-07 | 0.82 | 2024-06-25 | 32.60 | 2 | SO66252 | 2024-07-02 | 2.61 | 12.19 | |
SO64947_2 | 6 | 11976 | 225 | 9 | 2024-06-19 | 0.22 | 2024-06-07 | 8.99 | 2 | SO64947 | 2024-06-14 | 0.72 | 6.92 | |
SO43819_1 | 6 | 11006 | 346 | 9 | 2021-11-18 | 85.00 | 2021-11-06 | 3399.99 | 1 | SO43819 | 2021-11-13 | 272.00 | 1912.15 | |
SO60325_2 | 6 | 15721 | 539 | 9 | 2024-04-11 | 0.62 | 2024-03-30 | 24.99 | 2 | SO60325 | 2024-04-06 | 2.00 | 9.35 | |
SO47466_1 | 6 | 24887 | 381 | 9 | 2022-12-25 | 25.01 | 2022-12-13 | 1000.44 | 1 | SO47466 | 2022-12-20 | 80.04 | 605.65 | |
SO64658_4 | 6 | 15037 | 487 | 9 | 2024-06-14 | 1.37 | 2024-06-02 | 54.99 | 4 | SO64658 | 2024-06-09 | 4.40 | 20.57 | |
SO72267_4 | 6 | 15129 | 487 | 9 | 2024-09-27 | 1.37 | 2024-09-15 | 54.99 | 4 | SO72267 | 2024-09-22 | 4.40 | 20.57 | |
SO74974_1 | 100 | 15758 | 214 | 9 | 2024-11-18 | 0.87 | 2024-11-06 | 34.99 | 1 | SO74974 | 2024-11-13 | 2.80 | 13.09 | |
SO61444_3 | 6 | 11125 | 480 | 2 | 9 | 2024-04-27 | 0.06 | 2024-04-15 | 2.29 | 3 | SO61444 | 2024-04-22 | 0.18 | 0.86 |
SO45506_1 | 6 | 19615 | 311 | 9 | 2022-06-20 | 89.46 | 2022-06-08 | 3578.27 | 1 | SO45506 | 2022-06-15 | 286.26 | 2171.29 | |
SO55872_1 | 6 | 24375 | 538 | 9 | 2024-02-01 | 0.54 | 2024-01-20 | 21.49 | 1 | SO55872 | 2024-01-27 | 1.72 | 8.04 | |
SO67130_2 | 6 | 26023 | 479 | 9 | 2024-07-21 | 0.22 | 2024-07-09 | 8.99 | 2 | SO67130 | 2024-07-16 | 0.72 | 3.36 | |
SO59550_1 | 6 | 23343 | 580 | 9 | 2024-03-30 | 42.52 | 2024-03-18 | 1700.99 | 1 | SO59550 | 2024-03-25 | 136.08 | 1082.51 | |
SO53911_2 | 6 | 28927 | 222 | 9 | 2023-12-29 | 0.87 | 2023-12-17 | 34.99 | 2 | SO53911 | 2023-12-24 | 2.80 | 13.09 | |
SO71362_1 | 6 | 11921 | 225 | 9 | 2024-09-17 | 0.22 | 2024-09-05 | 8.99 | 1 | SO71362 | 2024-09-12 | 0.72 | 6.92 | |
SO72625_2 | 6 | 14048 | 478 | 9 | 2024-10-02 | 0.25 | 2024-09-20 | 9.99 | 2 | SO72625 | 2024-09-27 | 0.80 | 3.74 | |
SO51881_3 | 6 | 21407 | 480 | 9 | 2023-11-23 | 0.06 | 2023-11-11 | 2.29 | 3 | SO51881 | 2023-11-18 | 0.18 | 0.86 | |
SO61163_3 | 6 | 22572 | 479 | 9 | 2024-04-23 | 0.22 | 2024-04-11 | 8.99 | 3 | SO61163 | 2024-04-18 | 0.72 | 3.36 | |
SO55871_2 | 6 | 15261 | 539 | 9 | 2024-02-01 | 0.62 | 2024-01-20 | 24.99 | 2 | SO55871 | 2024-01-27 | 2.00 | 9.35 | |
SO43964_1 | 6 | 16745 | 312 | 9 | 2021-12-02 | 89.46 | 2021-11-20 | 3578.27 | 1 | SO43964 | 2021-11-27 | 286.26 | 2171.29 | |
SO60761_3 | 6 | 14218 | 530 | 9 | 2024-04-17 | 0.12 | 2024-04-05 | 4.99 | 3 | SO60761 | 2024-04-12 | 0.40 | 1.87 | |
SO73845_1 | 6 | 22921 | 380 | 9 | 2024-10-18 | 61.08 | 2024-10-06 | 2443.35 | 1 | SO73845 | 2024-10-13 | 195.47 | 1554.95 | |
SO53289_2 | 6 | 18248 | 477 | 9 | 2023-12-21 | 0.12 | 2023-12-09 | 4.99 | 2 | SO53289 | 2023-12-16 | 0.40 | 1.87 | |
SO59555_1 | 6 | 20213 | 374 | 9 | 2024-03-30 | 61.08 | 2024-03-18 | 2443.35 | 1 | SO59555 | 2024-03-25 | 195.47 | 1554.95 | |
SO57195_2 | 6 | 26762 | 471 | 9 | 2024-02-23 | 1.59 | 2024-02-11 | 63.50 | 2 | SO57195 | 2024-02-18 | 5.08 | 23.75 | |
SO64851_2 | 6 | 11963 | 477 | 9 | 2024-06-17 | 0.12 | 2024-06-05 | 4.99 | 2 | SO64851 | 2024-06-12 | 0.40 | 1.87 | |
SO62757_1 | 6 | 22856 | 477 | 9 | 2024-05-19 | 0.12 | 2024-05-07 | 4.99 | 1 | SO62757 | 2024-05-14 | 0.40 | 1.87 | |
SO60685_1 | 6 | 20227 | 376 | 9 | 2024-04-16 | 61.08 | 2024-04-04 | 2443.35 | 1 | SO60685 | 2024-04-11 | 195.47 | 1554.95 | |
SO60433_2 | 6 | 27348 | 217 | 9 | 2024-04-12 | 0.87 | 2024-03-31 | 34.99 | 2 | SO60433 | 2024-04-07 | 2.80 | 13.09 | |
SO69778_2 | 6 | 26444 | 539 | 9 | 2024-08-25 | 0.62 | 2024-08-13 | 24.99 | 2 | SO69778 | 2024-08-20 | 2.00 | 9.35 | |
SO57852_2 | 6 | 19106 | 530 | 9 | 2024-03-06 | 0.12 | 2024-02-23 | 4.99 | 2 | SO57852 | 2024-03-01 | 0.40 | 1.87 | |
SO55447_3 | 6 | 12355 | 481 | 9 | 2024-01-24 | 0.22 | 2024-01-12 | 8.99 | 3 | SO55447 | 2024-01-19 | 0.72 | 3.36 | |
SO60503_4 | 6 | 27365 | 222 | 9 | 2024-04-13 | 0.87 | 2024-04-01 | 34.99 | 4 | SO60503 | 2024-04-08 | 2.80 | 13.09 | |
SO55859_3 | 6 | 12342 | 477 | 9 | 2024-01-31 | 0.12 | 2024-01-19 | 4.99 | 3 | SO55859 | 2024-01-26 | 0.40 | 1.87 | |
SO69066_2 | 6 | 17923 | 490 | 9 | 2024-08-18 | 1.35 | 2024-08-06 | 53.99 | 2 | SO69066 | 2024-08-13 | 4.32 | 41.57 |
Generated 2024-11-11 00:00:30.431 UTC