[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '4' > < SKIP 2103 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48477_1 | 100 | 26611 | 352 | 4 | 2023-04-05 | 51.79 | 2023-03-24 | 2071.42 | 1 | SO48477 | 2023-03-31 | 165.71 | 1117.86 | |
SO48495_1 | 100 | 26602 | 360 | 4 | 2023-04-07 | 51.23 | 2023-03-26 | 2049.10 | 1 | SO48495 | 2023-04-02 | 163.93 | 1105.81 | |
SO48496_1 | 100 | 26603 | 362 | 2 | 4 | 2023-04-07 | 51.23 | 2023-03-26 | 2049.10 | 1 | SO48496 | 2023-04-02 | 163.93 | 1105.81 |
SO48508_1 | 100 | 13736 | 377 | 4 | 2023-04-08 | 54.54 | 2023-03-27 | 2181.56 | 1 | SO48508 | 2023-04-03 | 174.53 | 1320.68 | |
SO48510_1 | 100 | 26631 | 354 | 4 | 2023-04-08 | 51.79 | 2023-03-27 | 2071.42 | 1 | SO48510 | 2023-04-03 | 165.71 | 1117.86 | |
SO48511_1 | 100 | 26635 | 362 | 2 | 4 | 2023-04-08 | 51.23 | 2023-03-27 | 2049.10 | 1 | SO48511 | 2023-04-03 | 163.93 | 1105.81 |
SO48513_1 | 100 | 15417 | 321 | 4 | 2023-04-08 | 19.57 | 2023-03-27 | 782.99 | 1 | SO48513 | 2023-04-03 | 62.64 | 486.71 | |
SO48514_1 | 100 | 15427 | 339 | 4 | 2023-04-08 | 19.57 | 2023-03-27 | 782.99 | 1 | SO48514 | 2023-04-03 | 62.64 | 486.71 | |
SO48526_1 | 100 | 13724 | 375 | 4 | 2023-04-09 | 54.54 | 2023-03-28 | 2181.56 | 1 | SO48526 | 2023-04-04 | 174.53 | 1320.68 | |
SO69190_1 | 100 | 18421 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 1 | SO69190 | 2024-08-19 | 0.40 | 1.87 | |
SO69210_1 | 100 | 12428 | 537 | 4 | 2024-08-24 | 0.88 | 2024-08-12 | 35.00 | 1 | SO69210 | 2024-08-19 | 2.80 | 13.09 | |
SO69210_2 | 100 | 12428 | 528 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 2 | SO69210 | 2024-08-19 | 0.40 | 1.87 | |
SO69210_3 | 100 | 12428 | 217 | 4 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 3 | SO69210 | 2024-08-19 | 2.80 | 13.09 | |
SO69211_1 | 100 | 12432 | 537 | 4 | 2024-08-24 | 0.88 | 2024-08-12 | 35.00 | 1 | SO69211 | 2024-08-19 | 2.80 | 13.09 | |
SO69211_2 | 100 | 12432 | 485 | 4 | 2024-08-24 | 0.55 | 2024-08-12 | 21.98 | 2 | SO69211 | 2024-08-19 | 1.76 | 8.22 | |
SO69211_3 | 100 | 12432 | 214 | 4 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 3 | SO69211 | 2024-08-19 | 2.80 | 13.09 | |
SO69216_1 | 100 | 16786 | 361 | 4 | 2024-08-24 | 57.37 | 2024-08-12 | 2294.99 | 1 | SO69216 | 2024-08-19 | 183.60 | 1251.98 | |
SO69217_1 | 100 | 16147 | 361 | 4 | 2024-08-24 | 57.37 | 2024-08-12 | 2294.99 | 1 | SO69217 | 2024-08-19 | 183.60 | 1251.98 | |
SO69217_2 | 100 | 16147 | 537 | 4 | 2024-08-24 | 0.88 | 2024-08-12 | 35.00 | 2 | SO69217 | 2024-08-19 | 2.80 | 13.09 | |
SO69217_3 | 100 | 16147 | 528 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 3 | SO69217 | 2024-08-19 | 0.40 | 1.87 | |
SO69217_4 | 100 | 16147 | 485 | 4 | 2024-08-24 | 0.55 | 2024-08-12 | 21.98 | 4 | SO69217 | 2024-08-19 | 1.76 | 8.22 | |
SO69217_5 | 100 | 16147 | 480 | 2 | 4 | 2024-08-24 | 0.06 | 2024-08-12 | 2.29 | 5 | SO69217 | 2024-08-19 | 0.18 | 0.86 |
SO69217_6 | 100 | 16147 | 484 | 4 | 2024-08-24 | 0.20 | 2024-08-12 | 7.95 | 6 | SO69217 | 2024-08-19 | 0.64 | 2.97 | |
SO69218_1 | 100 | 16641 | 359 | 4 | 2024-08-24 | 57.37 | 2024-08-12 | 2294.99 | 1 | SO69218 | 2024-08-19 | 183.60 | 1251.98 | |
SO69218_2 | 100 | 16641 | 485 | 4 | 2024-08-24 | 0.55 | 2024-08-12 | 21.98 | 2 | SO69218 | 2024-08-19 | 1.76 | 8.22 | |
SO69218_3 | 100 | 16641 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 3 | SO69218 | 2024-08-19 | 0.40 | 1.87 | |
SO69218_4 | 100 | 16641 | 478 | 4 | 2024-08-24 | 0.25 | 2024-08-12 | 9.99 | 4 | SO69218 | 2024-08-19 | 0.80 | 3.74 | |
SO69218_5 | 100 | 16641 | 214 | 4 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 5 | SO69218 | 2024-08-19 | 2.80 | 13.09 | |
SO69218_6 | 100 | 16641 | 463 | 4 | 2024-08-24 | 0.61 | 2024-08-12 | 24.49 | 6 | SO69218 | 2024-08-19 | 1.96 | 9.16 | |
SO69219_1 | 100 | 12947 | 359 | 4 | 2024-08-24 | 57.37 | 2024-08-12 | 2294.99 | 1 | SO69219 | 2024-08-19 | 183.60 | 1251.98 | |
SO69219_2 | 100 | 12947 | 225 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 2 | SO69219 | 2024-08-19 | 0.72 | 6.92 | |
SO69219_3 | 100 | 12947 | 485 | 4 | 2024-08-24 | 0.55 | 2024-08-12 | 21.98 | 3 | SO69219 | 2024-08-19 | 1.76 | 8.22 | |
SO69220_1 | 100 | 16081 | 353 | 2 | 4 | 2024-08-24 | 58.00 | 2024-08-12 | 2319.99 | 1 | SO69220 | 2024-08-19 | 185.60 | 1265.62 |
SO69227_1 | 100 | 26633 | 571 | 4 | 2024-08-24 | 18.56 | 2024-08-12 | 742.35 | 1 | SO69227 | 2024-08-19 | 59.39 | 461.44 | |
SO69227_2 | 100 | 26633 | 479 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 2 | SO69227 | 2024-08-19 | 0.72 | 3.36 | |
SO69227_3 | 100 | 26633 | 477 | 4 | 2024-08-24 | 0.12 | 2024-08-12 | 4.99 | 3 | SO69227 | 2024-08-19 | 0.40 | 1.87 | |
SO69227_4 | 100 | 26633 | 488 | 4 | 2024-08-24 | 1.35 | 2024-08-12 | 53.99 | 4 | SO69227 | 2024-08-19 | 4.32 | 41.57 | |
SO69227_5 | 100 | 26633 | 467 | 4 | 2024-08-24 | 0.61 | 2024-08-12 | 24.49 | 5 | SO69227 | 2024-08-19 | 1.96 | 9.16 | |
SO69228_1 | 100 | 24810 | 574 | 4 | 2024-08-24 | 59.60 | 2024-08-12 | 2384.07 | 1 | SO69228 | 2024-08-19 | 190.73 | 1481.94 | |
SO69228_2 | 100 | 24810 | 214 | 4 | 2024-08-24 | 0.87 | 2024-08-12 | 34.99 | 2 | SO69228 | 2024-08-19 | 2.80 | 13.09 | |
SO69230_1 | 100 | 27288 | 576 | 4 | 2024-08-24 | 59.60 | 2024-08-12 | 2384.07 | 1 | SO69230 | 2024-08-19 | 190.73 | 1481.94 | |
SO69230_2 | 100 | 27288 | 479 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 2 | SO69230 | 2024-08-19 | 0.72 | 3.36 | |
SO69231_1 | 100 | 25997 | 577 | 2 | 4 | 2024-08-24 | 30.37 | 2024-08-12 | 1214.85 | 1 | SO69231 | 2024-08-19 | 97.19 | 755.15 |
SO69231_2 | 100 | 25997 | 225 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 2 | SO69231 | 2024-08-19 | 0.72 | 6.92 | |
SO69232_1 | 100 | 23807 | 605 | 4 | 2024-08-24 | 13.50 | 2024-08-12 | 539.99 | 1 | SO69232 | 2024-08-19 | 43.20 | 343.65 | |
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 | |
SO69232_3 | 100 | 23807 | 479 | 4 | 2024-08-24 | 0.22 | 2024-08-12 | 8.99 | 3 | SO69232 | 2024-08-19 | 0.72 | 3.36 | |
SO69232_4 | 100 | 23807 | 491 | 4 | 2024-08-24 | 1.35 | 2024-08-12 | 53.99 | 4 | SO69232 | 2024-08-19 | 4.32 | 41.57 | |
SO69236_1 | 100 | 18229 | 583 | 4 | 2024-08-24 | 42.52 | 2024-08-12 | 1700.99 | 1 | SO69236 | 2024-08-19 | 136.08 | 1082.51 | |
SO69245_1 | 100 | 12932 | 225 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 1 | SO69245 | 2024-08-20 | 0.72 | 6.92 | |
SO69260_1 | 100 | 27510 | 538 | 4 | 2024-08-25 | 0.54 | 2024-08-13 | 21.49 | 1 | SO69260 | 2024-08-20 | 1.72 | 8.04 | |
SO69260_2 | 100 | 27510 | 480 | 4 | 2024-08-25 | 0.06 | 2024-08-13 | 2.29 | 2 | SO69260 | 2024-08-20 | 0.18 | 0.86 | |
SO69260_3 | 100 | 27510 | 484 | 4 | 2024-08-25 | 0.20 | 2024-08-13 | 7.95 | 3 | SO69260 | 2024-08-20 | 0.64 | 2.97 | |
SO69263_1 | 100 | 24620 | 540 | 4 | 2024-08-25 | 0.82 | 2024-08-13 | 32.60 | 1 | SO69263 | 2024-08-20 | 2.61 | 12.19 | |
SO69263_2 | 100 | 24620 | 529 | 4 | 2024-08-25 | 0.10 | 2024-08-13 | 3.99 | 2 | SO69263 | 2024-08-20 | 0.32 | 1.49 | |
SO69263_3 | 100 | 24620 | 486 | 4 | 2024-08-25 | 3.98 | 2024-08-13 | 159.00 | 3 | SO69263 | 2024-08-20 | 12.72 | 59.47 | |
SO69264_1 | 100 | 22296 | 536 | 4 | 2024-08-25 | 0.75 | 2024-08-13 | 29.99 | 1 | SO69264 | 2024-08-20 | 2.40 | 11.22 | |
SO69264_2 | 100 | 22296 | 528 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 2 | SO69264 | 2024-08-20 | 0.40 | 1.87 | |
SO69264_3 | 100 | 22296 | 214 | 4 | 2024-08-25 | 0.87 | 2024-08-13 | 34.99 | 3 | SO69264 | 2024-08-20 | 2.80 | 13.09 | |
SO69264_4 | 100 | 22296 | 225 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 4 | SO69264 | 2024-08-20 | 0.72 | 6.92 | |
SO69264_5 | 100 | 22296 | 488 | 4 | 2024-08-25 | 1.35 | 2024-08-13 | 53.99 | 5 | SO69264 | 2024-08-20 | 4.32 | 41.57 | |
SO69266_1 | 100 | 21351 | 478 | 4 | 2024-08-25 | 0.25 | 2024-08-13 | 9.99 | 1 | SO69266 | 2024-08-20 | 0.80 | 3.74 | |
SO69266_2 | 100 | 21351 | 477 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 2 | SO69266 | 2024-08-20 | 0.40 | 1.87 | |
SO69266_3 | 100 | 21351 | 480 | 4 | 2024-08-25 | 0.06 | 2024-08-13 | 2.29 | 3 | SO69266 | 2024-08-20 | 0.18 | 0.86 | |
SO69270_1 | 100 | 19868 | 475 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 1 | SO69270 | 2024-08-20 | 5.60 | 26.18 | |
SO69270_2 | 100 | 19868 | 237 | 4 | 2024-08-25 | 1.25 | 2024-08-13 | 49.99 | 2 | SO69270 | 2024-08-20 | 4.00 | 38.49 | |
SO69271_1 | 100 | 19734 | 476 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 1 | SO69271 | 2024-08-20 | 5.60 | 26.18 | |
SO69271_2 | 100 | 19734 | 231 | 4 | 2024-08-25 | 1.25 | 2024-08-13 | 49.99 | 2 | SO69271 | 2024-08-20 | 4.00 | 38.49 | |
SO69272_1 | 100 | 19229 | 475 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 1 | SO69272 | 2024-08-20 | 5.60 | 26.18 | |
SO69272_2 | 100 | 19229 | 489 | 4 | 2024-08-25 | 1.35 | 2024-08-13 | 53.99 | 2 | SO69272 | 2024-08-20 | 4.32 | 41.57 | |
SO69273_1 | 100 | 18585 | 475 | 4 | 2024-08-25 | 1.75 | 2024-08-13 | 69.99 | 1 | SO69273 | 2024-08-20 | 5.60 | 26.18 | |
SO69273_2 | 100 | 18585 | 482 | 4 | 2024-08-25 | 0.22 | 2024-08-13 | 8.99 | 2 | SO69273 | 2024-08-20 | 0.72 | 3.36 | |
SO69274_1 | 100 | 16843 | 477 | 4 | 2024-08-25 | 0.12 | 2024-08-13 | 4.99 | 1 | SO69274 | 2024-08-20 | 0.40 | 1.87 | |
SO63666_2 | 100 | 14653 | 474 | 4 | 2024-06-03 | 1.75 | 2024-05-22 | 69.99 | 2 | SO63666 | 2024-05-29 | 5.60 | 26.18 | |
SO63666_3 | 100 | 14653 | 225 | 4 | 2024-06-03 | 0.22 | 2024-05-22 | 8.99 | 3 | SO63666 | 2024-05-29 | 0.72 | 6.92 | |
SO63669_1 | 100 | 12756 | 361 | 4 | 2024-06-03 | 57.37 | 2024-05-22 | 2294.99 | 1 | SO63669 | 2024-05-29 | 183.60 | 1251.98 | |
SO63669_2 | 100 | 12756 | 222 | 4 | 2024-06-03 | 0.87 | 2024-05-22 | 34.99 | 2 | SO63669 | 2024-05-29 | 2.80 | 13.09 | |
SO63680_1 | 100 | 24738 | 573 | 4 | 2024-06-03 | 59.60 | 2024-05-22 | 2384.07 | 1 | SO63680 | 2024-05-29 | 190.73 | 1481.94 | |
SO63680_2 | 100 | 24738 | 479 | 4 | 2024-06-03 | 0.22 | 2024-05-22 | 8.99 | 2 | SO63680 | 2024-05-29 | 0.72 | 3.36 | |
SO63680_3 | 100 | 24738 | 477 | 4 | 2024-06-03 | 0.12 | 2024-05-22 | 4.99 | 3 | SO63680 | 2024-05-29 | 0.40 | 1.87 | |
SO63680_4 | 100 | 24738 | 214 | 4 | 2024-06-03 | 0.87 | 2024-05-22 | 34.99 | 4 | SO63680 | 2024-05-29 | 2.80 | 13.09 | |
SO63684_1 | 100 | 26328 | 563 | 4 | 2024-06-03 | 59.60 | 2024-05-22 | 2384.07 | 1 | SO63684 | 2024-05-29 | 190.73 | 1481.94 | |
SO63684_2 | 100 | 26328 | 214 | 4 | 2024-06-03 | 0.87 | 2024-05-22 | 34.99 | 2 | SO63684 | 2024-05-29 | 2.80 | 13.09 | |
SO63684_3 | 100 | 26328 | 234 | 4 | 2024-06-03 | 1.25 | 2024-05-22 | 49.99 | 3 | SO63684 | 2024-05-29 | 4.00 | 38.49 | |
SO63685_1 | 100 | 23016 | 604 | 4 | 2024-06-03 | 13.50 | 2024-05-22 | 539.99 | 1 | SO63685 | 2024-05-29 | 43.20 | 343.65 | |
SO63685_2 | 100 | 23016 | 538 | 4 | 2024-06-03 | 0.54 | 2024-05-22 | 21.49 | 2 | SO63685 | 2024-05-29 | 1.72 | 8.04 | |
SO63686_1 | 100 | 20650 | 382 | 4 | 2024-06-03 | 28.01 | 2024-05-22 | 1120.49 | 1 | SO63686 | 2024-05-29 | 89.64 | 713.08 | |
SO63686_2 | 100 | 20650 | 489 | 4 | 2024-06-03 | 1.35 | 2024-05-22 | 53.99 | 2 | SO63686 | 2024-05-29 | 4.32 | 41.57 | |
SO63687_1 | 100 | 20709 | 580 | 4 | 2024-06-03 | 42.52 | 2024-05-22 | 1700.99 | 1 | SO63687 | 2024-05-29 | 136.08 | 1082.51 | |
SO63687_2 | 100 | 20709 | 539 | 4 | 2024-06-03 | 0.62 | 2024-05-22 | 24.99 | 2 | SO63687 | 2024-05-29 | 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 | |
SO63708_1 | 100 | 22070 | 478 | 4 | 2024-06-04 | 0.25 | 2024-05-23 | 9.99 | 1 | SO63708 | 2024-05-30 | 0.80 | 3.74 | |
SO63708_2 | 100 | 22070 | 477 | 4 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63708 | 2024-05-30 | 0.40 | 1.87 | |
SO63710_1 | 100 | 21243 | 478 | 4 | 2024-06-04 | 0.25 | 2024-05-23 | 9.99 | 1 | SO63710 | 2024-05-30 | 0.80 | 3.74 | |
SO63710_2 | 100 | 21243 | 477 | 4 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 2 | SO63710 | 2024-05-30 | 0.40 | 1.87 | |
SO63711_1 | 100 | 18981 | 476 | 4 | 2024-06-04 | 1.75 | 2024-05-23 | 69.99 | 1 | SO63711 | 2024-05-30 | 5.60 | 26.18 | |
SO63711_2 | 100 | 18981 | 225 | 4 | 2024-06-04 | 0.22 | 2024-05-23 | 8.99 | 2 | SO63711 | 2024-05-30 | 0.72 | 6.92 | |
SO63712_1 | 100 | 18473 | 477 | 4 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 1 | SO63712 | 2024-05-30 | 0.40 | 1.87 | |
SO63712_2 | 100 | 18473 | 480 | 4 | 2024-06-04 | 0.06 | 2024-05-23 | 2.29 | 2 | SO63712 | 2024-05-30 | 0.18 | 0.86 | |
SO63712_3 | 100 | 18473 | 483 | 4 | 2024-06-04 | 3.00 | 2024-05-23 | 120.00 | 3 | SO63712 | 2024-05-30 | 9.60 | 44.88 | |
SO63730_1 | 100 | 15321 | 363 | 4 | 2024-06-04 | 57.37 | 2024-05-23 | 2294.99 | 1 | SO63730 | 2024-05-30 | 183.60 | 1251.98 | |
SO63730_2 | 100 | 15321 | 537 | 4 | 2024-06-04 | 0.88 | 2024-05-23 | 35.00 | 2 | SO63730 | 2024-05-30 | 2.80 | 13.09 | |
SO63741_1 | 100 | 26114 | 561 | 4 | 2024-06-04 | 59.60 | 2024-05-23 | 2384.07 | 1 | SO63741 | 2024-05-30 | 190.73 | 1481.94 | |
SO63741_2 | 100 | 26114 | 479 | 4 | 2024-06-04 | 0.22 | 2024-05-23 | 8.99 | 2 | SO63741 | 2024-05-30 | 0.72 | 3.36 | |
SO63741_3 | 100 | 26114 | 477 | 4 | 2024-06-04 | 0.12 | 2024-05-23 | 4.99 | 3 | SO63741 | 2024-05-30 | 0.40 | 1.87 | |
SO63741_4 | 100 | 26114 | 487 | 4 | 2024-06-04 | 1.37 | 2024-05-23 | 54.99 | 4 | SO63741 | 2024-05-30 | 4.40 | 20.57 | |
SO63742_1 | 100 | 20677 | 388 | 4 | 2024-06-04 | 28.01 | 2024-05-23 | 1120.49 | 1 | SO63742 | 2024-05-30 | 89.64 | 713.08 | |
SO63742_2 | 100 | 20677 | 529 | 4 | 2024-06-04 | 0.10 | 2024-05-23 | 3.99 | 2 | SO63742 | 2024-05-30 | 0.32 | 1.49 | |
SO63742_3 | 100 | 20677 | 539 | 4 | 2024-06-04 | 0.62 | 2024-05-23 | 24.99 | 3 | SO63742 | 2024-05-30 | 2.00 | 9.35 | |
SO63742_4 | 100 | 20677 | 214 | 4 | 2024-06-04 | 0.87 | 2024-05-23 | 34.99 | 4 | SO63742 | 2024-05-30 | 2.80 | 13.09 | |
SO63745_1 | 100 | 17661 | 583 | 4 | 2024-06-04 | 42.52 | 2024-05-23 | 1700.99 | 1 | SO63745 | 2024-05-30 | 136.08 | 1082.51 | |
SO63745_2 | 100 | 17661 | 225 | 4 | 2024-06-04 | 0.22 | 2024-05-23 | 8.99 | 2 | SO63745 | 2024-05-30 | 0.72 | 6.92 |
Generated 2024-11-14 18:22:52.595 UTC