[ROOT] dt FactInternetSale WHERE DimSalesTerritoryId EQ '1' > < SKIP 1170 > < TAKE 56 >
56 items
| FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO56835_1 | 100 | 11690 | 359 | 1 | 2024-02-23 | 57.37 | 2024-02-11 | 2294.99 | 1 | SO56835 | 2024-02-18 | 183.60 | 1251.98 | |
| SO62522_1 | 100 | 29202 | 566 | 1 | 2024-05-18 | 18.56 | 2024-05-06 | 742.35 | 1 | SO62522 | 2024-05-13 | 59.39 | 461.44 | |
| SO69146_1 | 100 | 27455 | 561 | 1 | 2024-08-23 | 59.60 | 2024-08-11 | 2384.07 | 1 | SO69146 | 2024-08-18 | 190.73 | 1481.94 | |
| SO47860_1 | 100 | 26339 | 352 | 1 | 2023-02-14 | 51.79 | 2023-02-02 | 2071.42 | 1 | SO47860 | 2023-02-09 | 165.71 | 1117.86 | |
| SO56835_2 | 100 | 11690 | 485 | 1 | 2024-02-23 | 0.55 | 2024-02-11 | 21.98 | 2 | SO56835 | 2024-02-18 | 1.76 | 8.22 | |
| SO62553_1 | 100 | 21273 | 478 | 1 | 2024-05-19 | 0.25 | 2024-05-07 | 9.99 | 1 | SO62553 | 2024-05-14 | 0.80 | 3.74 | |
| SO69146_2 | 100 | 27455 | 479 | 1 | 2024-08-23 | 0.22 | 2024-08-11 | 8.99 | 2 | SO69146 | 2024-08-18 | 0.72 | 3.36 | |
| SO47863_1 | 100 | 15351 | 323 | 1 | 2023-02-14 | 19.57 | 2023-02-02 | 782.99 | 1 | SO47863 | 2023-02-09 | 62.64 | 486.71 | |
| SO56835_3 | 100 | 11690 | 481 | 1 | 2024-02-23 | 0.22 | 2024-02-11 | 8.99 | 3 | SO56835 | 2024-02-18 | 0.72 | 3.36 | |
| SO62553_2 | 100 | 21273 | 477 | 1 | 2024-05-19 | 0.12 | 2024-05-07 | 4.99 | 2 | SO62553 | 2024-05-14 | 0.40 | 1.87 | |
| SO69146_3 | 100 | 27455 | 477 | 1 | 2024-08-23 | 0.12 | 2024-08-11 | 4.99 | 3 | SO69146 | 2024-08-18 | 0.40 | 1.87 | |
| SO47874_1 | 100 | 13462 | 373 | 1 | 2023-02-15 | 54.54 | 2023-02-03 | 2181.56 | 1 | SO47874 | 2023-02-10 | 174.53 | 1320.68 | |
| SO56845_1 | 100 | 24818 | 563 | 1 | 2024-02-23 | 59.60 | 2024-02-11 | 2384.07 | 1 | SO56845 | 2024-02-18 | 190.73 | 1481.94 | |
| SO62555_1 | 100 | 13483 | 485 | 1 | 2024-05-19 | 0.55 | 2024-05-07 | 21.98 | 1 | SO62555 | 2024-05-14 | 1.76 | 8.22 | |
| SO69146_4 | 100 | 27455 | 473 | 1 | 2024-08-23 | 1.59 | 2024-08-11 | 63.50 | 4 | SO69146 | 2024-08-18 | 5.08 | 23.75 | |
| SO47922_1 | 100 | 13468 | 379 | 1 | 2023-02-21 | 54.54 | 2023-02-09 | 2181.56 | 1 | SO47922 | 2023-02-16 | 174.53 | 1320.68 | |
| SO56845_2 | 100 | 24818 | 489 | 1 | 2024-02-23 | 1.35 | 2024-02-11 | 53.99 | 2 | SO56845 | 2024-02-18 | 4.32 | 41.57 | |
| SO62555_2 | 100 | 13483 | 222 | 1 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 2 | SO62555 | 2024-05-14 | 2.80 | 13.09 | |
| SO69147_1 | 100 | 27116 | 573 | 1 | 2024-08-23 | 59.60 | 2024-08-11 | 2384.07 | 1 | SO69147 | 2024-08-18 | 190.73 | 1481.94 | |
| SO47948_1 | 100 | 13450 | 369 | 2 | 1 | 2023-02-25 | 61.08 | 2023-02-13 | 2443.35 | 1 | SO47948 | 2023-02-20 | 195.47 | 1518.79 |
| SO56846_1 | 100 | 22888 | 605 | 1 | 2024-02-23 | 13.50 | 2024-02-11 | 539.99 | 1 | SO56846 | 2024-02-18 | 43.20 | 343.65 | |
| SO62569_1 | 100 | 25972 | 576 | 1 | 2024-05-19 | 59.60 | 2024-05-07 | 2384.07 | 1 | SO62569 | 2024-05-14 | 190.73 | 1481.94 | |
| SO69147_2 | 100 | 27116 | 225 | 1 | 2024-08-23 | 0.22 | 2024-08-11 | 8.99 | 2 | SO69147 | 2024-08-18 | 0.72 | 6.92 | |
| SO48094_1 | 100 | 13657 | 370 | 1 | 2023-02-27 | 61.08 | 2023-02-15 | 2443.35 | 1 | SO48094 | 2023-02-22 | 195.47 | 1518.79 | |
| SO56847_1 | 100 | 22067 | 604 | 1 | 2024-02-23 | 13.50 | 2024-02-11 | 539.99 | 1 | SO56847 | 2024-02-18 | 43.20 | 343.65 | |
| SO62569_2 | 100 | 25972 | 477 | 1 | 2024-05-19 | 0.12 | 2024-05-07 | 4.99 | 2 | SO62569 | 2024-05-14 | 0.40 | 1.87 | |
| SO69149_1 | 100 | 27201 | 574 | 1 | 2024-08-23 | 59.60 | 2024-08-11 | 2384.07 | 1 | SO69149 | 2024-08-18 | 190.73 | 1481.94 | |
| SO48105_1 | 100 | 26513 | 356 | 1 | 2023-03-01 | 51.79 | 2023-02-17 | 2071.42 | 1 | SO48105 | 2023-02-24 | 165.71 | 1117.86 | |
| SO56863_1 | 100 | 28803 | 539 | 1 | 2024-02-24 | 0.62 | 2024-02-12 | 24.99 | 1 | SO56863 | 2024-02-19 | 2.00 | 9.35 | |
| SO62569_3 | 100 | 25972 | 479 | 1 | 2024-05-19 | 0.22 | 2024-05-07 | 8.99 | 3 | SO62569 | 2024-05-14 | 0.72 | 3.36 | |
| SO69149_2 | 100 | 27201 | 214 | 1 | 2024-08-23 | 0.87 | 2024-08-11 | 34.99 | 2 | SO69149 | 2024-08-18 | 2.80 | 13.09 | |
| SO48109_1 | 100 | 13489 | 369 | 2 | 1 | 2023-03-02 | 61.08 | 2023-02-18 | 2443.35 | 1 | SO48109 | 2023-02-25 | 195.47 | 1518.79 |
| SO56863_2 | 100 | 28803 | 480 | 1 | 2024-02-24 | 0.06 | 2024-02-12 | 2.29 | 2 | SO56863 | 2024-02-19 | 0.18 | 0.86 | |
| SO62569_4 | 100 | 25972 | 484 | 1 | 2024-05-19 | 0.20 | 2024-05-07 | 7.95 | 4 | SO62569 | 2024-05-14 | 0.64 | 2.97 | |
| SO69149_3 | 100 | 27201 | 463 | 1 | 2024-08-23 | 0.61 | 2024-08-11 | 24.49 | 3 | SO69149 | 2024-08-18 | 1.96 | 9.16 | |
| SO48112_1 | 100 | 13712 | 371 | 1 | 2023-03-03 | 54.54 | 2023-02-19 | 2181.56 | 1 | SO48112 | 2023-02-26 | 174.53 | 1320.68 | |
| SO56865_1 | 100 | 29173 | 539 | 1 | 2024-02-24 | 0.62 | 2024-02-12 | 24.99 | 1 | SO56865 | 2024-02-19 | 2.00 | 9.35 | |
| SO62571_1 | 100 | 23264 | 606 | 1 | 2024-05-19 | 13.50 | 2024-05-07 | 539.99 | 1 | SO62571 | 2024-05-14 | 43.20 | 343.65 | |
| SO69150_1 | 100 | 27291 | 573 | 1 | 2024-08-23 | 59.60 | 2024-08-11 | 2384.07 | 1 | SO69150 | 2024-08-18 | 190.73 | 1481.94 | |
| SO48126_1 | 100 | 14115 | 387 | 1 | 2023-03-05 | 25.01 | 2023-02-21 | 1000.44 | 1 | SO48126 | 2023-02-28 | 80.04 | 605.65 | |
| SO56865_2 | 100 | 29173 | 480 | 1 | 2024-02-24 | 0.06 | 2024-02-12 | 2.29 | 2 | SO56865 | 2024-02-19 | 0.18 | 0.86 | |
| SO62575_1 | 100 | 20399 | 390 | 1 | 2024-05-19 | 28.01 | 2024-05-07 | 1120.49 | 1 | SO62575 | 2024-05-14 | 89.64 | 713.08 | |
| SO69152_1 | 100 | 23726 | 606 | 1 | 2024-08-23 | 13.50 | 2024-08-11 | 539.99 | 1 | SO69152 | 2024-08-18 | 43.20 | 343.65 | |
| SO48132_1 | 100 | 26521 | 352 | 1 | 2023-03-06 | 51.79 | 2023-02-22 | 2071.42 | 1 | SO48132 | 2023-03-01 | 165.71 | 1117.86 | |
| SO56866_1 | 100 | 28633 | 529 | 1 | 2024-02-24 | 0.10 | 2024-02-12 | 3.99 | 1 | SO56866 | 2024-02-19 | 0.32 | 1.49 | |
| SO62575_2 | 100 | 20399 | 529 | 1 | 2024-05-19 | 0.10 | 2024-05-07 | 3.99 | 2 | SO62575 | 2024-05-14 | 0.32 | 1.49 | |
| SO69152_2 | 100 | 23726 | 477 | 1 | 2024-08-23 | 0.12 | 2024-08-11 | 4.99 | 2 | SO69152 | 2024-08-18 | 0.40 | 1.87 | |
| SO48145_1 | 100 | 26491 | 362 | 2 | 1 | 2023-03-08 | 51.23 | 2023-02-24 | 2049.10 | 1 | SO48145 | 2023-03-03 | 163.93 | 1105.81 |
| SO56866_2 | 100 | 28633 | 539 | 1 | 2024-02-24 | 0.62 | 2024-02-12 | 24.99 | 2 | SO56866 | 2024-02-19 | 2.00 | 9.35 | |
| SO62575_3 | 100 | 20399 | 539 | 1 | 2024-05-19 | 0.62 | 2024-05-07 | 24.99 | 3 | SO62575 | 2024-05-14 | 2.00 | 9.35 | |
| SO69152_3 | 100 | 23726 | 479 | 1 | 2024-08-23 | 0.22 | 2024-08-11 | 8.99 | 3 | SO69152 | 2024-08-18 | 0.72 | 3.36 | |
| SO48162_1 | 100 | 13714 | 369 | 2 | 1 | 2023-03-10 | 61.08 | 2023-02-26 | 2443.35 | 1 | SO48162 | 2023-03-05 | 195.47 | 1518.79 |
| SO56866_3 | 100 | 28633 | 486 | 1 | 2024-02-24 | 3.98 | 2024-02-12 | 159.00 | 3 | SO56866 | 2024-02-19 | 12.72 | 59.47 | |
| SO62575_4 | 100 | 20399 | 222 | 1 | 2024-05-19 | 0.87 | 2024-05-07 | 34.99 | 4 | SO62575 | 2024-05-14 | 2.80 | 13.09 | |
| SO69152_4 | 100 | 23726 | 225 | 1 | 2024-08-23 | 0.22 | 2024-08-11 | 8.99 | 4 | SO69152 | 2024-08-18 | 0.72 | 6.92 | |
| SO48169_1 | 100 | 13653 | 377 | 1 | 2023-03-12 | 54.54 | 2023-02-28 | 2181.56 | 1 | SO48169 | 2023-03-07 | 174.53 | 1320.68 |
Generated 2024-11-14 17:20:28.549 UTC