[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 2597 > < TAKE 112 >
112 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO52580_1 | 6 | 15216 | 539 | 9 | 2023-12-07 | 0.62 | 2023-11-25 | 24.99 | 1 | SO52580 | 2023-12-02 | 2.00 | 9.35 | |
SO52580_2 | 6 | 15216 | 480 | 9 | 2023-12-07 | 0.06 | 2023-11-25 | 2.29 | 2 | SO52580 | 2023-12-02 | 0.18 | 0.86 | |
SO52581_1 | 6 | 19570 | 485 | 9 | 2023-12-07 | 0.55 | 2023-11-25 | 21.98 | 1 | SO52581 | 2023-12-02 | 1.76 | 8.22 | |
SO52581_2 | 6 | 19570 | 478 | 9 | 2023-12-07 | 0.25 | 2023-11-25 | 9.99 | 2 | SO52581 | 2023-12-02 | 0.80 | 3.74 | |
SO52581_3 | 6 | 19570 | 477 | 9 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 3 | SO52581 | 2023-12-02 | 0.40 | 1.87 | |
SO52581_4 | 6 | 19570 | 482 | 9 | 2023-12-07 | 0.22 | 2023-11-25 | 8.99 | 4 | SO52581 | 2023-12-02 | 0.72 | 3.36 | |
SO52582_1 | 6 | 22924 | 485 | 9 | 2023-12-07 | 0.55 | 2023-11-25 | 21.98 | 1 | SO52582 | 2023-12-02 | 1.76 | 8.22 | |
SO52582_2 | 6 | 22924 | 478 | 9 | 2023-12-07 | 0.25 | 2023-11-25 | 9.99 | 2 | SO52582 | 2023-12-02 | 0.80 | 3.74 | |
SO52582_3 | 6 | 22924 | 477 | 9 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 3 | SO52582 | 2023-12-02 | 0.40 | 1.87 | |
SO52582_4 | 6 | 22924 | 488 | 9 | 2023-12-07 | 1.35 | 2023-11-25 | 53.99 | 4 | SO52582 | 2023-12-02 | 4.32 | 41.57 | |
SO52583_1 | 6 | 21254 | 528 | 9 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 1 | SO52583 | 2023-12-02 | 0.40 | 1.87 | |
SO52583_2 | 6 | 21254 | 214 | 9 | 2023-12-07 | 0.87 | 2023-11-25 | 34.99 | 2 | SO52583 | 2023-12-02 | 2.80 | 13.09 | |
SO52583_3 | 6 | 21254 | 234 | 9 | 2023-12-07 | 1.25 | 2023-11-25 | 49.99 | 3 | SO52583 | 2023-12-02 | 4.00 | 38.49 | |
SO52584_1 | 6 | 25820 | 528 | 9 | 2023-12-07 | 0.12 | 2023-11-25 | 4.99 | 1 | SO52584 | 2023-12-02 | 0.40 | 1.87 | |
SO52584_2 | 6 | 25820 | 222 | 9 | 2023-12-07 | 0.87 | 2023-11-25 | 34.99 | 2 | SO52584 | 2023-12-02 | 2.80 | 13.09 | |
SO52584_3 | 6 | 25820 | 481 | 9 | 2023-12-07 | 0.22 | 2023-11-25 | 8.99 | 3 | SO52584 | 2023-12-02 | 0.72 | 3.36 | |
SO52585_1 | 6 | 15018 | 225 | 9 | 2023-12-07 | 0.22 | 2023-11-25 | 8.99 | 1 | SO52585 | 2023-12-02 | 0.72 | 6.92 | |
SO52586_1 | 6 | 16679 | 529 | 9 | 2023-12-07 | 0.10 | 2023-11-25 | 3.99 | 1 | SO52586 | 2023-12-02 | 0.32 | 1.49 | |
SO52586_2 | 6 | 16679 | 540 | 9 | 2023-12-07 | 0.82 | 2023-11-25 | 32.60 | 2 | SO52586 | 2023-12-02 | 2.61 | 12.19 | |
SO52586_3 | 6 | 16679 | 222 | 9 | 2023-12-07 | 0.87 | 2023-11-25 | 34.99 | 3 | SO52586 | 2023-12-02 | 2.80 | 13.09 | |
SO52618_1 | 6 | 16166 | 536 | 9 | 2023-12-08 | 0.75 | 2023-11-26 | 29.99 | 1 | SO52618 | 2023-12-03 | 2.40 | 11.22 | |
SO52618_2 | 6 | 16166 | 528 | 9 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 2 | SO52618 | 2023-12-03 | 0.40 | 1.87 | |
SO52618_3 | 6 | 16166 | 217 | 9 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 3 | SO52618 | 2023-12-03 | 2.80 | 13.09 | |
SO52619_1 | 6 | 15031 | 536 | 9 | 2023-12-08 | 0.75 | 2023-11-26 | 29.99 | 1 | SO52619 | 2023-12-03 | 2.40 | 11.22 | |
SO52619_2 | 6 | 15031 | 480 | 2 | 9 | 2023-12-08 | 0.06 | 2023-11-26 | 2.29 | 2 | SO52619 | 2023-12-03 | 0.18 | 0.86 |
SO52620_1 | 6 | 17381 | 485 | 9 | 2023-12-08 | 0.55 | 2023-11-26 | 21.98 | 1 | SO52620 | 2023-12-03 | 1.76 | 8.22 | |
SO52620_2 | 6 | 17381 | 484 | 9 | 2023-12-08 | 0.20 | 2023-11-26 | 7.95 | 2 | SO52620 | 2023-12-03 | 0.64 | 2.97 | |
SO52620_3 | 6 | 17381 | 486 | 9 | 2023-12-08 | 3.98 | 2023-11-26 | 159.00 | 3 | SO52620 | 2023-12-03 | 12.72 | 59.47 | |
SO52621_1 | 6 | 29290 | 477 | 9 | 2023-12-08 | 0.12 | 2023-11-26 | 4.99 | 1 | SO52621 | 2023-12-03 | 0.40 | 1.87 | |
SO52622_1 | 6 | 17070 | 490 | 9 | 2023-12-08 | 1.35 | 2023-11-26 | 53.99 | 1 | SO52622 | 2023-12-03 | 4.32 | 41.57 | |
SO52623_1 | 6 | 17238 | 490 | 9 | 2023-12-08 | 1.35 | 2023-11-26 | 53.99 | 1 | SO52623 | 2023-12-03 | 4.32 | 41.57 | |
SO52624_1 | 6 | 14008 | 222 | 9 | 2023-12-08 | 0.87 | 2023-11-26 | 34.99 | 1 | SO52624 | 2023-12-03 | 2.80 | 13.09 | |
SO52660_1 | 6 | 16663 | 590 | 9 | 2023-12-08 | 19.24 | 2023-11-26 | 769.49 | 1 | SO52660 | 2023-12-03 | 61.56 | 419.78 | |
SO52660_2 | 6 | 16663 | 475 | 9 | 2023-12-08 | 1.75 | 2023-11-26 | 69.99 | 2 | SO52660 | 2023-12-03 | 5.60 | 26.18 | |
SO52660_3 | 6 | 16663 | 491 | 9 | 2023-12-08 | 1.35 | 2023-11-26 | 53.99 | 3 | SO52660 | 2023-12-03 | 4.32 | 41.57 | |
SO52670_1 | 6 | 18483 | 376 | 9 | 2023-12-09 | 61.08 | 2023-11-27 | 2443.35 | 1 | SO52670 | 2023-12-04 | 195.47 | 1554.95 | |
SO52670_2 | 6 | 18483 | 217 | 9 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 2 | SO52670 | 2023-12-04 | 2.80 | 13.09 | |
SO52672_1 | 6 | 13613 | 535 | 9 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 1 | SO52672 | 2023-12-04 | 2.00 | 9.35 | |
SO52672_2 | 6 | 13613 | 480 | 9 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 2 | SO52672 | 2023-12-04 | 0.18 | 0.86 | |
SO52673_1 | 6 | 13120 | 535 | 9 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 1 | SO52673 | 2023-12-04 | 2.00 | 9.35 | |
SO52673_2 | 6 | 13120 | 463 | 9 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 2 | SO52673 | 2023-12-04 | 1.96 | 9.16 | |
SO52674_1 | 6 | 14859 | 529 | 9 | 2023-12-09 | 0.10 | 2023-11-27 | 3.99 | 1 | SO52674 | 2023-12-04 | 0.32 | 1.49 | |
SO52674_2 | 6 | 14859 | 539 | 9 | 2023-12-09 | 0.62 | 2023-11-27 | 24.99 | 2 | SO52674 | 2023-12-04 | 2.00 | 9.35 | |
SO52674_3 | 6 | 14859 | 480 | 9 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 3 | SO52674 | 2023-12-04 | 0.18 | 0.86 | |
SO52675_1 | 6 | 18282 | 485 | 9 | 2023-12-09 | 0.55 | 2023-11-27 | 21.98 | 1 | SO52675 | 2023-12-04 | 1.76 | 8.22 | |
SO52676_1 | 6 | 12012 | 225 | 9 | 2023-12-09 | 0.22 | 2023-11-27 | 8.99 | 1 | SO52676 | 2023-12-04 | 0.72 | 6.92 | |
SO52677_1 | 6 | 14073 | 540 | 9 | 2023-12-09 | 0.82 | 2023-11-27 | 32.60 | 1 | SO52677 | 2023-12-04 | 2.61 | 12.19 | |
SO52677_2 | 6 | 14073 | 529 | 9 | 2023-12-09 | 0.10 | 2023-11-27 | 3.99 | 2 | SO52677 | 2023-12-04 | 0.32 | 1.49 | |
SO52677_3 | 6 | 14073 | 480 | 9 | 2023-12-09 | 0.06 | 2023-11-27 | 2.29 | 3 | SO52677 | 2023-12-04 | 0.18 | 0.86 | |
SO52717_1 | 6 | 14011 | 582 | 9 | 2023-12-09 | 42.52 | 2023-11-27 | 1700.99 | 1 | SO52717 | 2023-12-04 | 136.08 | 1082.51 | |
SO52717_2 | 6 | 14011 | 467 | 9 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 2 | SO52717 | 2023-12-04 | 1.96 | 9.16 | |
SO52717_3 | 6 | 14011 | 214 | 9 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 3 | SO52717 | 2023-12-04 | 2.80 | 13.09 | |
SO52718_1 | 6 | 14125 | 581 | 9 | 2023-12-09 | 42.52 | 2023-11-27 | 1700.99 | 1 | SO52718 | 2023-12-04 | 136.08 | 1082.51 | |
SO52719_1 | 6 | 28326 | 575 | 9 | 2023-12-09 | 59.60 | 2023-11-27 | 2384.07 | 1 | SO52719 | 2023-12-04 | 190.73 | 1481.94 | |
SO52719_2 | 6 | 28326 | 541 | 9 | 2023-12-09 | 0.72 | 2023-11-27 | 28.99 | 2 | SO52719 | 2023-12-04 | 2.32 | 10.84 | |
SO52719_3 | 6 | 28326 | 465 | 9 | 2023-12-09 | 0.61 | 2023-11-27 | 24.49 | 3 | SO52719 | 2023-12-04 | 1.96 | 9.16 | |
SO52719_4 | 6 | 28326 | 530 | 9 | 2023-12-09 | 0.12 | 2023-11-27 | 4.99 | 4 | SO52719 | 2023-12-04 | 0.40 | 1.87 | |
SO52720_1 | 6 | 27910 | 605 | 9 | 2023-12-09 | 13.50 | 2023-11-27 | 539.99 | 1 | SO52720 | 2023-12-04 | 43.20 | 343.65 | |
SO52720_2 | 6 | 27910 | 222 | 9 | 2023-12-09 | 0.87 | 2023-11-27 | 34.99 | 2 | SO52720 | 2023-12-04 | 2.80 | 13.09 | |
SO52726_1 | 6 | 16740 | 374 | 9 | 2023-12-10 | 61.08 | 2023-11-28 | 2443.35 | 1 | SO52726 | 2023-12-05 | 195.47 | 1554.95 | |
SO52726_2 | 6 | 16740 | 479 | 9 | 2023-12-10 | 0.22 | 2023-11-28 | 8.99 | 2 | SO52726 | 2023-12-05 | 0.72 | 3.36 | |
SO52726_3 | 6 | 16740 | 472 | 9 | 2023-12-10 | 1.59 | 2023-11-28 | 63.50 | 3 | SO52726 | 2023-12-05 | 5.08 | 23.75 | |
SO52726_4 | 6 | 16740 | 477 | 9 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 4 | SO52726 | 2023-12-05 | 0.40 | 1.87 | |
SO52727_1 | 6 | 25815 | 528 | 9 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 1 | SO52727 | 2023-12-05 | 0.40 | 1.87 | |
SO52727_2 | 6 | 25815 | 214 | 9 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO52727 | 2023-12-05 | 2.80 | 13.09 | |
SO52728_1 | 6 | 13639 | 529 | 9 | 2023-12-10 | 0.10 | 2023-11-28 | 3.99 | 1 | SO52728 | 2023-12-05 | 0.32 | 1.49 | |
SO52763_1 | 6 | 20154 | 605 | 9 | 2023-12-10 | 13.50 | 2023-11-28 | 539.99 | 1 | SO52763 | 2023-12-05 | 43.20 | 343.65 | |
SO52763_2 | 6 | 20154 | 214 | 9 | 2023-12-10 | 0.87 | 2023-11-28 | 34.99 | 2 | SO52763 | 2023-12-05 | 2.80 | 13.09 | |
SO52764_1 | 6 | 28323 | 564 | 9 | 2023-12-10 | 59.60 | 2023-11-28 | 2384.07 | 1 | SO52764 | 2023-12-05 | 190.73 | 1481.94 | |
SO52776_1 | 6 | 18469 | 374 | 2 | 9 | 2023-12-10 | 61.08 | 2023-11-28 | 2443.35 | 1 | SO52776 | 2023-12-05 | 195.47 | 1554.95 |
SO52777_1 | 6 | 28107 | 571 | 9 | 2023-12-10 | 18.56 | 2023-11-28 | 742.35 | 1 | SO52777 | 2023-12-05 | 59.39 | 461.44 | |
SO52777_2 | 6 | 28107 | 479 | 9 | 2023-12-10 | 0.22 | 2023-11-28 | 8.99 | 2 | SO52777 | 2023-12-05 | 0.72 | 3.36 | |
SO52777_3 | 6 | 28107 | 477 | 9 | 2023-12-10 | 0.12 | 2023-11-28 | 4.99 | 3 | SO52777 | 2023-12-05 | 0.40 | 1.87 | |
SO52777_4 | 6 | 28107 | 491 | 9 | 2023-12-10 | 1.35 | 2023-11-28 | 53.99 | 4 | SO52777 | 2023-12-05 | 4.32 | 41.57 | |
SO52779_1 | 6 | 15125 | 529 | 9 | 2023-12-11 | 0.10 | 2023-11-29 | 3.99 | 1 | SO52779 | 2023-12-06 | 0.32 | 1.49 | |
SO52779_2 | 6 | 15125 | 539 | 9 | 2023-12-11 | 0.62 | 2023-11-29 | 24.99 | 2 | SO52779 | 2023-12-06 | 2.00 | 9.35 | |
SO52779_3 | 6 | 15125 | 480 | 9 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 3 | SO52779 | 2023-12-06 | 0.18 | 0.86 | |
SO52780_1 | 6 | 15217 | 539 | 9 | 2023-12-11 | 0.62 | 2023-11-29 | 24.99 | 1 | SO52780 | 2023-12-06 | 2.00 | 9.35 | |
SO52780_2 | 6 | 15217 | 529 | 9 | 2023-12-11 | 0.10 | 2023-11-29 | 3.99 | 2 | SO52780 | 2023-12-06 | 0.32 | 1.49 | |
SO52780_3 | 6 | 15217 | 480 | 9 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 3 | SO52780 | 2023-12-06 | 0.18 | 0.86 | |
SO52781_1 | 6 | 16627 | 536 | 9 | 2023-12-11 | 0.75 | 2023-11-29 | 29.99 | 1 | SO52781 | 2023-12-06 | 2.40 | 11.22 | |
SO52782_1 | 6 | 26543 | 529 | 9 | 2023-12-11 | 0.10 | 2023-11-29 | 3.99 | 1 | SO52782 | 2023-12-06 | 0.32 | 1.49 | |
SO52782_2 | 6 | 26543 | 480 | 2 | 9 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 2 | SO52782 | 2023-12-06 | 0.18 | 0.86 |
SO52782_3 | 6 | 26543 | 484 | 9 | 2023-12-11 | 0.20 | 2023-11-29 | 7.95 | 3 | SO52782 | 2023-12-06 | 0.64 | 2.97 | |
SO52783_1 | 6 | 15137 | 222 | 9 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 1 | SO52783 | 2023-12-06 | 2.80 | 13.09 | |
SO52783_2 | 6 | 15137 | 225 | 9 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 2 | SO52783 | 2023-12-06 | 0.72 | 6.92 | |
SO52783_3 | 6 | 15137 | 490 | 9 | 2023-12-11 | 1.35 | 2023-11-29 | 53.99 | 3 | SO52783 | 2023-12-06 | 4.32 | 41.57 | |
SO52830_1 | 6 | 28327 | 575 | 9 | 2023-12-11 | 59.60 | 2023-11-29 | 2384.07 | 1 | SO52830 | 2023-12-06 | 190.73 | 1481.94 | |
SO52830_2 | 6 | 28327 | 479 | 9 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 2 | SO52830 | 2023-12-06 | 0.72 | 3.36 | |
SO52830_3 | 6 | 28327 | 225 | 9 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 3 | SO52830 | 2023-12-06 | 0.72 | 6.92 | |
SO52830_4 | 6 | 28327 | 477 | 9 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 4 | SO52830 | 2023-12-06 | 0.40 | 1.87 | |
SO52831_1 | 6 | 26673 | 604 | 9 | 2023-12-11 | 13.50 | 2023-11-29 | 539.99 | 1 | SO52831 | 2023-12-06 | 43.20 | 343.65 | |
SO52831_2 | 6 | 26673 | 538 | 9 | 2023-12-11 | 0.54 | 2023-11-29 | 21.49 | 2 | SO52831 | 2023-12-06 | 1.72 | 8.04 | |
SO52831_3 | 6 | 26673 | 480 | 9 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 3 | SO52831 | 2023-12-06 | 0.18 | 0.86 | |
SO52831_4 | 6 | 26673 | 486 | 9 | 2023-12-11 | 3.98 | 2023-11-29 | 159.00 | 4 | SO52831 | 2023-12-06 | 12.72 | 59.47 | |
SO52841_1 | 6 | 18296 | 380 | 9 | 2023-12-12 | 61.08 | 2023-11-30 | 2443.35 | 1 | SO52841 | 2023-12-07 | 195.47 | 1554.95 | |
SO52841_2 | 6 | 18296 | 540 | 9 | 2023-12-12 | 0.82 | 2023-11-30 | 32.60 | 2 | SO52841 | 2023-12-07 | 2.61 | 12.19 | |
SO52841_3 | 6 | 18296 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 3 | SO52841 | 2023-12-07 | 0.32 | 1.49 | |
SO52841_4 | 6 | 18296 | 214 | 9 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 4 | SO52841 | 2023-12-07 | 2.80 | 13.09 | |
SO52841_5 | 6 | 18296 | 465 | 9 | 2023-12-12 | 0.61 | 2023-11-30 | 24.49 | 5 | SO52841 | 2023-12-07 | 1.96 | 9.16 | |
SO52842_1 | 6 | 24612 | 386 | 9 | 2023-12-12 | 28.01 | 2023-11-30 | 1120.49 | 1 | SO52842 | 2023-12-07 | 89.64 | 713.08 | |
SO52842_2 | 6 | 24612 | 539 | 9 | 2023-12-12 | 0.62 | 2023-11-30 | 24.99 | 2 | SO52842 | 2023-12-07 | 2.00 | 9.35 | |
SO52842_3 | 6 | 24612 | 529 | 9 | 2023-12-12 | 0.10 | 2023-11-30 | 3.99 | 3 | SO52842 | 2023-12-07 | 0.32 | 1.49 | |
SO52842_4 | 6 | 24612 | 480 | 9 | 2023-12-12 | 0.06 | 2023-11-30 | 2.29 | 4 | SO52842 | 2023-12-07 | 0.18 | 0.86 | |
SO52843_1 | 6 | 24614 | 382 | 9 | 2023-12-12 | 28.01 | 2023-11-30 | 1120.49 | 1 | SO52843 | 2023-12-07 | 89.64 | 713.08 | |
SO52844_1 | 6 | 11998 | 578 | 9 | 2023-12-12 | 30.37 | 2023-11-30 | 1214.85 | 1 | SO52844 | 2023-12-07 | 97.19 | 755.15 | |
SO52844_2 | 6 | 11998 | 214 | 9 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 2 | SO52844 | 2023-12-07 | 2.80 | 13.09 | |
SO52845_1 | 6 | 14058 | 560 | 9 | 2023-12-12 | 30.37 | 2023-11-30 | 1214.85 | 1 | SO52845 | 2023-12-07 | 97.19 | 755.15 | |
SO52845_2 | 6 | 14058 | 541 | 9 | 2023-12-12 | 0.72 | 2023-11-30 | 28.99 | 2 | SO52845 | 2023-12-07 | 2.32 | 10.84 | |
SO52845_3 | 6 | 14058 | 530 | 9 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 3 | SO52845 | 2023-12-07 | 0.40 | 1.87 | |
SO52845_4 | 6 | 14058 | 222 | 9 | 2023-12-12 | 0.87 | 2023-11-30 | 34.99 | 4 | SO52845 | 2023-12-07 | 2.80 | 13.09 | |
SO52847_1 | 6 | 24469 | 477 | 9 | 2023-12-12 | 0.12 | 2023-11-30 | 4.99 | 1 | SO52847 | 2023-12-07 | 0.40 | 1.87 |
Generated 2024-11-10 12:08:39.146 UTC