[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2359 > < TAKE 62 >
62 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO62993_1 | 100 | 22862 | 606 | 4 | 2024-04-02 | 13.50 | 2024-03-21 | 539.99 | 1 | SO62993 | 2024-03-28 | 43.20 | 343.65 | |
SO69382_2 | 100 | 21281 | 479 | 4 | 2024-07-03 | 0.22 | 2024-06-21 | 8.99 | 2 | SO69382 | 2024-06-28 | 0.72 | 3.36 | |
SO48925_1 | 100 | 15480 | 325 | 4 | 2023-03-21 | 19.57 | 2023-03-09 | 782.99 | 1 | SO48925 | 2023-03-16 | 62.64 | 486.71 | |
SO57237_3 | 100 | 22899 | 529 | 4 | 2024-01-04 | 0.10 | 2023-12-23 | 3.99 | 3 | SO57237 | 2023-12-30 | 0.32 | 1.49 | |
SO62994_1 | 100 | 23216 | 606 | 4 | 2024-04-02 | 13.50 | 2024-03-21 | 539.99 | 1 | SO62994 | 2024-03-28 | 43.20 | 343.65 | |
SO69383_1 | 100 | 21475 | 384 | 2 | 4 | 2024-07-03 | 28.01 | 2024-06-21 | 1120.49 | 1 | SO69383 | 2024-06-28 | 89.64 | 713.08 |
SO48932_1 | 100 | 14297 | 385 | 4 | 2023-03-22 | 25.01 | 2023-03-10 | 1000.44 | 1 | SO48932 | 2023-03-17 | 80.04 | 605.65 | |
SO57237_4 | 100 | 22899 | 214 | 4 | 2024-01-04 | 0.87 | 2023-12-23 | 34.99 | 4 | SO57237 | 2023-12-30 | 2.80 | 13.09 | |
SO62994_2 | 100 | 23216 | 477 | 4 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 2 | SO62994 | 2024-03-28 | 0.40 | 1.87 | |
SO69383_2 | 100 | 21475 | 539 | 4 | 2024-07-03 | 0.62 | 2024-06-21 | 24.99 | 2 | SO69383 | 2024-06-28 | 2.00 | 9.35 | |
SO48934_1 | 100 | 26710 | 354 | 4 | 2023-03-22 | 51.79 | 2023-03-10 | 2071.42 | 1 | SO48934 | 2023-03-17 | 165.71 | 1117.86 | |
SO57238_1 | 100 | 20024 | 388 | 4 | 2024-01-04 | 28.01 | 2023-12-23 | 1120.49 | 1 | SO57238 | 2023-12-30 | 89.64 | 713.08 | |
SO62994_3 | 100 | 23216 | 479 | 4 | 2024-04-02 | 0.22 | 2024-03-21 | 8.99 | 3 | SO62994 | 2024-03-28 | 0.72 | 3.36 | |
SO69383_3 | 100 | 21475 | 480 | 2 | 4 | 2024-07-03 | 0.06 | 2024-06-21 | 2.29 | 3 | SO69383 | 2024-06-28 | 0.18 | 0.86 |
SO48935_1 | 100 | 15518 | 331 | 4 | 2023-03-22 | 19.57 | 2023-03-10 | 782.99 | 1 | SO48935 | 2023-03-17 | 62.64 | 486.71 | |
SO57238_2 | 100 | 20024 | 222 | 4 | 2024-01-04 | 0.87 | 2023-12-23 | 34.99 | 2 | SO57238 | 2023-12-30 | 2.80 | 13.09 | |
SO62994_4 | 100 | 23216 | 217 | 4 | 2024-04-02 | 0.87 | 2024-03-21 | 34.99 | 4 | SO62994 | 2024-03-28 | 2.80 | 13.09 | |
SO69384_1 | 100 | 18556 | 581 | 4 | 2024-07-03 | 42.52 | 2024-06-21 | 1700.99 | 1 | SO69384 | 2024-06-28 | 136.08 | 1082.51 | |
SO48942_1 | 100 | 26728 | 362 | 2 | 4 | 2023-03-23 | 51.23 | 2023-03-11 | 2049.10 | 1 | SO48942 | 2023-03-18 | 163.93 | 1105.81 |
SO57254_1 | 100 | 11504 | 480 | 4 | 2024-01-05 | 0.06 | 2023-12-24 | 2.29 | 1 | SO57254 | 2023-12-31 | 0.18 | 0.86 | |
SO62994_5 | 100 | 23216 | 465 | 4 | 2024-04-02 | 0.61 | 2024-03-21 | 24.49 | 5 | SO62994 | 2024-03-28 | 1.96 | 9.16 | |
SO69566_1 | 100 | 12708 | 479 | 4 | 2024-07-04 | 0.22 | 2024-06-22 | 8.99 | 1 | SO69566 | 2024-06-29 | 0.72 | 3.36 | |
SO48967_1 | 100 | 14292 | 387 | 4 | 2023-03-27 | 25.01 | 2023-03-15 | 1000.44 | 1 | SO48967 | 2023-03-22 | 80.04 | 605.65 | |
SO57255_1 | 100 | 11163 | 529 | 4 | 2024-01-05 | 0.10 | 2023-12-24 | 3.99 | 1 | SO57255 | 2023-12-31 | 0.32 | 1.49 | |
SO62995_1 | 100 | 22718 | 584 | 4 | 2024-04-02 | 13.50 | 2024-03-21 | 539.99 | 1 | SO62995 | 2024-03-28 | 43.20 | 343.65 | |
SO69583_1 | 100 | 11049 | 529 | 4 | 2024-07-04 | 0.10 | 2024-06-22 | 3.99 | 1 | SO69583 | 2024-06-29 | 0.32 | 1.49 | |
SO48979_1 | 100 | 13855 | 375 | 4 | 2023-03-28 | 54.54 | 2023-03-16 | 2181.56 | 1 | SO48979 | 2023-03-23 | 174.53 | 1320.68 | |
SO57256_1 | 100 | 29109 | 529 | 4 | 2024-01-05 | 0.10 | 2023-12-24 | 3.99 | 1 | SO57256 | 2023-12-31 | 0.32 | 1.49 | |
SO62995_2 | 100 | 22718 | 538 | 4 | 2024-04-02 | 0.54 | 2024-03-21 | 21.49 | 2 | SO62995 | 2024-03-28 | 1.72 | 8.04 | |
SO69583_2 | 100 | 11049 | 480 | 4 | 2024-07-04 | 0.06 | 2024-06-22 | 2.29 | 2 | SO69583 | 2024-06-29 | 0.18 | 0.86 | |
SO48982_1 | 100 | 15484 | 323 | 4 | 2023-03-28 | 19.57 | 2023-03-16 | 782.99 | 1 | SO48982 | 2023-03-23 | 62.64 | 486.71 | |
SO57256_2 | 100 | 29109 | 480 | 4 | 2024-01-05 | 0.06 | 2023-12-24 | 2.29 | 2 | SO57256 | 2023-12-31 | 0.18 | 0.86 | |
SO62995_3 | 100 | 22718 | 529 | 4 | 2024-04-02 | 0.10 | 2024-03-21 | 3.99 | 3 | SO62995 | 2024-03-28 | 0.32 | 1.49 | |
SO69584_1 | 100 | 29161 | 529 | 4 | 2024-07-04 | 0.10 | 2024-06-22 | 3.99 | 1 | SO69584 | 2024-06-29 | 0.32 | 1.49 | |
SO48983_1 | 100 | 15500 | 333 | 4 | 2023-03-28 | 19.57 | 2023-03-16 | 782.99 | 1 | SO48983 | 2023-03-23 | 62.64 | 486.71 | |
SO57257_1 | 100 | 27214 | 539 | 4 | 2024-01-05 | 0.62 | 2023-12-24 | 24.99 | 1 | SO57257 | 2023-12-31 | 2.00 | 9.35 | |
SO62995_4 | 100 | 22718 | 214 | 4 | 2024-04-02 | 0.87 | 2024-03-21 | 34.99 | 4 | SO62995 | 2024-03-28 | 2.80 | 13.09 | |
SO69584_2 | 100 | 29161 | 217 | 4 | 2024-07-04 | 0.87 | 2024-06-22 | 34.99 | 2 | SO69584 | 2024-06-29 | 2.80 | 13.09 | |
SO48992_1 | 100 | 13862 | 379 | 4 | 2023-03-29 | 54.54 | 2023-03-17 | 2181.56 | 1 | SO48992 | 2023-03-24 | 174.53 | 1320.68 | |
SO57257_2 | 100 | 27214 | 529 | 4 | 2024-01-05 | 0.10 | 2023-12-24 | 3.99 | 2 | SO57257 | 2023-12-31 | 0.32 | 1.49 | |
SO62996_1 | 100 | 17497 | 581 | 4 | 2024-04-02 | 42.52 | 2024-03-21 | 1700.99 | 1 | SO62996 | 2024-03-28 | 136.08 | 1082.51 | |
SO69598_1 | 100 | 21399 | 478 | 4 | 2024-07-04 | 0.25 | 2024-06-22 | 9.99 | 1 | SO69598 | 2024-06-29 | 0.80 | 3.74 | |
SO48994_1 | 100 | 15506 | 325 | 4 | 2023-03-29 | 19.57 | 2023-03-17 | 782.99 | 1 | SO48994 | 2023-03-24 | 62.64 | 486.71 | |
SO57257_3 | 100 | 27214 | 486 | 4 | 2024-01-05 | 3.98 | 2023-12-24 | 159.00 | 3 | SO57257 | 2023-12-31 | 12.72 | 59.47 | |
SO62996_2 | 100 | 17497 | 479 | 4 | 2024-04-02 | 0.22 | 2024-03-21 | 8.99 | 2 | SO62996 | 2024-03-28 | 0.72 | 3.36 | |
SO69600_1 | 100 | 21454 | 478 | 4 | 2024-07-04 | 0.25 | 2024-06-22 | 9.99 | 1 | SO69600 | 2024-06-29 | 0.80 | 3.74 | |
SO48997_1 | 100 | 13854 | 369 | 2 | 4 | 2023-03-30 | 61.08 | 2023-03-18 | 2443.35 | 1 | SO48997 | 2023-03-25 | 195.47 | 1518.79 |
SO57261_1 | 100 | 25842 | 535 | 4 | 2024-01-05 | 0.62 | 2023-12-24 | 24.99 | 1 | SO57261 | 2023-12-31 | 2.00 | 9.35 | |
SO62996_3 | 100 | 17497 | 477 | 4 | 2024-04-02 | 0.12 | 2024-03-21 | 4.99 | 3 | SO62996 | 2024-03-28 | 0.40 | 1.87 | |
SO69601_1 | 100 | 18076 | 477 | 4 | 2024-07-04 | 0.12 | 2024-06-22 | 4.99 | 1 | SO69601 | 2024-06-29 | 0.40 | 1.87 | |
SO49005_1 | 100 | 26723 | 362 | 2 | 4 | 2023-03-31 | 51.23 | 2023-03-19 | 2049.10 | 1 | SO49005 | 2023-03-26 | 163.93 | 1105.81 |
SO57261_2 | 100 | 25842 | 480 | 4 | 2024-01-05 | 0.06 | 2023-12-24 | 2.29 | 2 | SO57261 | 2023-12-31 | 0.18 | 0.86 | |
SO62996_4 | 100 | 17497 | 480 | 4 | 2024-04-02 | 0.06 | 2024-03-21 | 2.29 | 4 | SO62996 | 2024-03-28 | 0.18 | 0.86 | |
SO69601_2 | 100 | 18076 | 487 | 4 | 2024-07-04 | 1.37 | 2024-06-22 | 54.99 | 2 | SO69601 | 2024-06-29 | 4.40 | 20.57 | |
SO49011_1 | 100 | 26698 | 358 | 4 | 2023-04-01 | 51.23 | 2023-03-20 | 2049.10 | 1 | SO49011 | 2023-03-27 | 163.93 | 1105.81 | |
SO57263_1 | 100 | 22756 | 536 | 4 | 2024-01-05 | 0.75 | 2023-12-24 | 29.99 | 1 | SO57263 | 2023-12-31 | 2.40 | 11.22 | |
SO63021_1 | 100 | 23864 | 536 | 4 | 2024-04-03 | 0.75 | 2024-03-22 | 29.99 | 1 | SO63021 | 2024-03-29 | 2.40 | 11.22 | |
SO69601_3 | 100 | 18076 | 484 | 4 | 2024-07-04 | 0.20 | 2024-06-22 | 7.95 | 3 | SO69601 | 2024-06-29 | 0.64 | 2.97 | |
SO49027_1 | 100 | 15501 | 325 | 4 | 2023-04-04 | 19.57 | 2023-03-23 | 782.99 | 1 | SO49027 | 2023-03-30 | 62.64 | 486.71 | |
SO57263_2 | 100 | 22756 | 528 | 4 | 2024-01-05 | 0.12 | 2023-12-24 | 4.99 | 2 | SO57263 | 2023-12-31 | 0.40 | 1.87 | |
SO63021_2 | 100 | 23864 | 528 | 4 | 2024-04-03 | 0.12 | 2024-03-22 | 4.99 | 2 | SO63021 | 2024-03-29 | 0.40 | 1.87 | |
SO69616_1 | 100 | 20644 | 376 | 4 | 2024-07-04 | 61.08 | 2024-06-22 | 2443.35 | 1 | SO69616 | 2024-06-29 | 195.47 | 1554.95 |
Generated 2024-09-21 14:22:27.774 UTC