[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 99 > < TAKE 96 >
96 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO43746_1 | 6 | 16616 | 312 | 9 | 2021-11-04 | 89.46 | 2021-10-23 | 3578.27 | 1 | SO43746 | 2021-10-30 | 286.26 | 2171.29 | |
SO55581_3 | 100 | 13759 | 473 | 4 | 2024-01-27 | 1.59 | 2024-01-15 | 63.50 | 3 | SO55581 | 2024-01-22 | 5.08 | 23.75 | |
SO43747_1 | 100 | 27623 | 314 | 4 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43747 | 2021-10-31 | 286.26 | 2171.29 | |
SO55581_4 | 100 | 13759 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 4 | SO55581 | 2024-01-22 | 0.80 | 3.74 | |
SO43748_1 | 100 | 27625 | 313 | 1 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43748 | 2021-10-31 | 286.26 | 2171.29 | |
SO55582_1 | 98 | 15441 | 537 | 10 | 2024-01-27 | 0.88 | 2024-01-15 | 35.00 | 1 | SO55582 | 2024-01-22 | 2.80 | 13.09 | |
SO43749_1 | 100 | 27636 | 314 | 1 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43749 | 2021-10-31 | 286.26 | 2171.29 | |
SO55582_2 | 98 | 15441 | 480 | 10 | 2024-01-27 | 0.06 | 2024-01-15 | 2.29 | 2 | SO55582 | 2024-01-22 | 0.18 | 0.86 | |
SO43750_1 | 39 | 11591 | 311 | 7 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43750 | 2021-10-31 | 286.26 | 2171.29 | |
SO55583_1 | 100 | 22380 | 477 | 8 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55583 | 2024-01-22 | 0.40 | 1.87 | |
SO43751_1 | 39 | 11592 | 313 | 7 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43751 | 2021-10-31 | 286.26 | 2171.29 | |
SO55584_1 | 98 | 25628 | 529 | 10 | 2024-01-27 | 0.10 | 2024-01-15 | 3.99 | 1 | SO55584 | 2024-01-22 | 0.32 | 1.49 | |
SO43752_1 | 29 | 13265 | 311 | 8 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43752 | 2021-10-31 | 286.26 | 2171.29 | |
SO55584_2 | 98 | 25628 | 480 | 10 | 2024-01-27 | 0.06 | 2024-01-15 | 2.29 | 2 | SO55584 | 2024-01-22 | 0.18 | 0.86 | |
SO43753_1 | 6 | 16482 | 310 | 9 | 2021-11-05 | 89.46 | 2021-10-24 | 3578.27 | 1 | SO43753 | 2021-10-31 | 286.26 | 2171.29 | |
SO55585_1 | 100 | 29434 | 530 | 8 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55585 | 2024-01-22 | 0.40 | 1.87 | |
SO43754_1 | 100 | 27617 | 312 | 1 | 2021-11-06 | 89.46 | 2021-10-25 | 3578.27 | 1 | SO43754 | 2021-11-01 | 286.26 | 2171.29 | |
SO55585_2 | 100 | 29434 | 541 | 8 | 2024-01-27 | 0.72 | 2024-01-15 | 28.99 | 2 | SO55585 | 2024-01-22 | 2.32 | 10.84 | |
SO43755_1 | 100 | 27670 | 311 | 4 | 2021-11-06 | 89.46 | 2021-10-25 | 3578.27 | 1 | SO43755 | 2021-11-01 | 286.26 | 2171.29 | |
SO55585_3 | 100 | 29434 | 217 | 8 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 3 | SO55585 | 2024-01-22 | 2.80 | 13.09 | |
SO43756_1 | 98 | 19941 | 332 | 10 | 2021-11-06 | 17.48 | 2021-10-25 | 699.10 | 1 | SO43756 | 2021-11-01 | 55.93 | 413.15 | |
SO55585_4 | 100 | 29434 | 225 | 8 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 4 | SO55585 | 2024-01-22 | 0.72 | 6.92 | |
SO43757_1 | 6 | 11017 | 350 | 9 | 2021-11-06 | 84.37 | 2021-10-25 | 3374.99 | 1 | SO43757 | 2021-11-01 | 270.00 | 1898.09 | |
SO55586_1 | 100 | 24148 | 529 | 8 | 2024-01-27 | 0.10 | 2024-01-15 | 3.99 | 1 | SO55586 | 2024-01-22 | 0.32 | 1.49 | |
SO43758_1 | 100 | 27646 | 310 | 4 | 2021-11-07 | 89.46 | 2021-10-26 | 3578.27 | 1 | SO43758 | 2021-11-02 | 286.26 | 2171.29 | |
SO55586_2 | 100 | 24148 | 484 | 8 | 2024-01-27 | 0.20 | 2024-01-15 | 7.95 | 2 | SO55586 | 2024-01-22 | 0.64 | 2.97 | |
SO43759_1 | 29 | 13257 | 310 | 8 | 2021-11-07 | 89.46 | 2021-10-26 | 3578.27 | 1 | SO43759 | 2021-11-02 | 286.26 | 2171.29 | |
SO55587_1 | 100 | 11566 | 530 | 7 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55587 | 2024-01-22 | 0.40 | 1.87 | |
SO43760_1 | 6 | 16352 | 314 | 9 | 2021-11-07 | 89.46 | 2021-10-26 | 3578.27 | 1 | SO43760 | 2021-11-02 | 286.26 | 2171.29 | |
SO55587_2 | 100 | 11566 | 480 | 2 | 7 | 2024-01-27 | 0.06 | 2024-01-15 | 2.29 | 2 | SO55587 | 2024-01-22 | 0.18 | 0.86 |
SO43761_1 | 6 | 16493 | 310 | 9 | 2021-11-07 | 89.46 | 2021-10-26 | 3578.27 | 1 | SO43761 | 2021-11-02 | 286.26 | 2171.29 | |
SO55588_1 | 100 | 11566 | 530 | 7 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55588 | 2024-01-22 | 0.40 | 1.87 | |
SO43762_1 | 100 | 27578 | 314 | 4 | 2021-11-08 | 89.46 | 2021-10-27 | 3578.27 | 1 | SO43762 | 2021-11-03 | 286.26 | 2171.29 | |
SO55588_2 | 100 | 11566 | 214 | 7 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 2 | SO55588 | 2024-01-22 | 2.80 | 13.09 | |
SO43763_1 | 6 | 16525 | 313 | 9 | 2021-11-08 | 89.46 | 2021-10-27 | 3578.27 | 1 | SO43763 | 2021-11-03 | 286.26 | 2171.29 | |
SO55589_1 | 98 | 14982 | 541 | 10 | 2024-01-27 | 0.72 | 2024-01-15 | 28.99 | 1 | SO55589 | 2024-01-22 | 2.32 | 10.84 | |
SO43764_1 | 6 | 16612 | 310 | 9 | 2021-11-08 | 89.46 | 2021-10-27 | 3578.27 | 1 | SO43764 | 2021-11-03 | 286.26 | 2171.29 | |
SO55589_2 | 98 | 14982 | 530 | 10 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 2 | SO55589 | 2024-01-22 | 0.40 | 1.87 | |
SO43765_1 | 6 | 11010 | 346 | 9 | 2021-11-08 | 85.00 | 2021-10-27 | 3399.99 | 1 | SO43765 | 2021-11-03 | 272.00 | 1912.15 | |
SO55590_1 | 98 | 17702 | 530 | 10 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 1 | SO55590 | 2024-01-22 | 0.40 | 1.87 | |
SO43766_1 | 6 | 16518 | 313 | 9 | 2021-11-09 | 89.46 | 2021-10-28 | 3578.27 | 1 | SO43766 | 2021-11-04 | 286.26 | 2171.29 | |
SO55590_2 | 98 | 17702 | 467 | 10 | 2024-01-27 | 0.61 | 2024-01-15 | 24.49 | 2 | SO55590 | 2024-01-22 | 1.96 | 9.16 | |
SO43767_1 | 6 | 11001 | 350 | 9 | 2021-11-09 | 84.37 | 2021-10-28 | 3374.99 | 1 | SO43767 | 2021-11-04 | 270.00 | 1898.09 | |
SO55591_1 | 100 | 12757 | 485 | 1 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 1 | SO55591 | 2024-01-22 | 1.76 | 8.22 | |
SO43768_1 | 100 | 27649 | 312 | 1 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43768 | 2021-11-05 | 286.26 | 2171.29 | |
SO55591_2 | 100 | 12757 | 222 | 1 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 2 | SO55591 | 2024-01-22 | 2.80 | 13.09 | |
SO43769_1 | 19 | 21659 | 312 | 6 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43769 | 2021-11-05 | 286.26 | 2171.29 | |
SO55591_3 | 100 | 12757 | 234 | 1 | 2024-01-27 | 1.25 | 2024-01-15 | 49.99 | 3 | SO55591 | 2024-01-22 | 4.00 | 38.49 | |
SO43770_1 | 100 | 27614 | 312 | 1 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43770 | 2021-11-05 | 286.26 | 2171.29 | |
SO55592_1 | 19 | 23376 | 581 | 6 | 2024-01-27 | 42.52 | 2024-01-15 | 1700.99 | 1 | SO55592 | 2024-01-22 | 136.08 | 1082.51 | |
SO43771_1 | 100 | 14559 | 330 | 4 | 2021-11-10 | 17.48 | 2021-10-29 | 699.10 | 1 | SO43771 | 2021-11-05 | 55.93 | 413.15 | |
SO55592_2 | 19 | 23376 | 222 | 6 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 2 | SO55592 | 2024-01-22 | 2.80 | 13.09 | |
SO43772_1 | 6 | 16524 | 312 | 9 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43772 | 2021-11-05 | 286.26 | 2171.29 | |
SO55593_1 | 100 | 19129 | 593 | 4 | 2024-01-27 | 14.12 | 2024-01-15 | 564.99 | 1 | SO55593 | 2024-01-22 | 45.20 | 308.22 | |
SO43773_1 | 6 | 16526 | 314 | 9 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43773 | 2021-11-05 | 286.26 | 2171.29 | |
SO55593_2 | 100 | 19129 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 2 | SO55593 | 2024-01-22 | 0.80 | 3.74 | |
SO43774_1 | 6 | 16348 | 313 | 9 | 2021-11-10 | 89.46 | 2021-10-29 | 3578.27 | 1 | SO43774 | 2021-11-05 | 286.26 | 2171.29 | |
SO55593_3 | 100 | 19129 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 3 | SO55593 | 2024-01-22 | 0.40 | 1.87 | |
SO43775_1 | 6 | 11027 | 347 | 9 | 2021-11-10 | 85.00 | 2021-10-29 | 3399.99 | 1 | SO43775 | 2021-11-05 | 272.00 | 1912.15 | |
SO55593_4 | 100 | 19129 | 467 | 4 | 2024-01-27 | 0.61 | 2024-01-15 | 24.49 | 4 | SO55593 | 2024-01-22 | 1.96 | 9.16 | |
SO43776_1 | 29 | 13260 | 314 | 8 | 2021-11-11 | 89.46 | 2021-10-30 | 3578.27 | 1 | SO43776 | 2021-11-06 | 286.26 | 2171.29 | |
SO55593_5 | 100 | 19129 | 222 | 4 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 5 | SO55593 | 2024-01-22 | 2.80 | 13.09 | |
SO43777_1 | 6 | 16515 | 311 | 9 | 2021-11-11 | 89.46 | 2021-10-30 | 3578.27 | 1 | SO43777 | 2021-11-06 | 286.26 | 2171.29 | |
SO55594_1 | 100 | 16951 | 582 | 1 | 2024-01-27 | 42.52 | 2024-01-15 | 1700.99 | 1 | SO55594 | 2024-01-22 | 136.08 | 1082.51 | |
SO43778_1 | 6 | 11018 | 345 | 9 | 2021-11-11 | 85.00 | 2021-10-30 | 3399.99 | 1 | SO43778 | 2021-11-06 | 272.00 | 1912.15 | |
SO55594_2 | 100 | 16951 | 214 | 1 | 2024-01-27 | 0.87 | 2024-01-15 | 34.99 | 2 | SO55594 | 2024-01-22 | 2.80 | 13.09 | |
SO43779_1 | 6 | 25252 | 326 | 9 | 2021-11-11 | 17.48 | 2021-10-30 | 699.10 | 1 | SO43779 | 2021-11-06 | 55.93 | 413.15 | |
SO55595_1 | 100 | 19121 | 594 | 4 | 2024-01-27 | 14.12 | 2024-01-15 | 564.99 | 1 | SO55595 | 2024-01-22 | 45.20 | 308.22 | |
SO43780_1 | 39 | 11599 | 311 | 7 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO43780 | 2021-11-07 | 286.26 | 2171.29 | |
SO55595_2 | 100 | 19121 | 485 | 4 | 2024-01-27 | 0.55 | 2024-01-15 | 21.98 | 2 | SO55595 | 2024-01-22 | 1.76 | 8.22 | |
SO43781_1 | 6 | 16495 | 312 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO43781 | 2021-11-07 | 286.26 | 2171.29 | |
SO55595_3 | 100 | 19121 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 3 | SO55595 | 2024-01-22 | 0.80 | 3.74 | |
SO43782_1 | 6 | 16516 | 312 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO43782 | 2021-11-07 | 286.26 | 2171.29 | |
SO55595_4 | 100 | 19121 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 4 | SO55595 | 2024-01-22 | 0.40 | 1.87 | |
SO43783_1 | 6 | 16620 | 312 | 9 | 2021-11-12 | 89.46 | 2021-10-31 | 3578.27 | 1 | SO43783 | 2021-11-07 | 286.26 | 2171.29 | |
SO55595_5 | 100 | 19121 | 487 | 4 | 2024-01-27 | 1.37 | 2024-01-15 | 54.99 | 5 | SO55595 | 2024-01-22 | 4.40 | 20.57 | |
SO43784_1 | 100 | 27667 | 310 | 4 | 2021-11-13 | 89.46 | 2021-11-01 | 3578.27 | 1 | SO43784 | 2021-11-08 | 286.26 | 2171.29 | |
SO55596_1 | 100 | 19122 | 594 | 4 | 2024-01-27 | 14.12 | 2024-01-15 | 564.99 | 1 | SO55596 | 2024-01-22 | 45.20 | 308.22 | |
SO43785_1 | 39 | 11601 | 311 | 7 | 2021-11-13 | 89.46 | 2021-11-01 | 3578.27 | 1 | SO43785 | 2021-11-08 | 286.26 | 2171.29 | |
SO55596_2 | 100 | 19122 | 478 | 4 | 2024-01-27 | 0.25 | 2024-01-15 | 9.99 | 2 | SO55596 | 2024-01-22 | 0.80 | 3.74 | |
SO43786_1 | 39 | 11607 | 311 | 7 | 2021-11-13 | 89.46 | 2021-11-01 | 3578.27 | 1 | SO43786 | 2021-11-08 | 286.26 | 2171.29 | |
SO55596_3 | 100 | 19122 | 225 | 4 | 2024-01-27 | 0.22 | 2024-01-15 | 8.99 | 3 | SO55596 | 2024-01-22 | 0.72 | 6.92 | |
SO43787_1 | 29 | 29385 | 344 | 8 | 2021-11-13 | 85.00 | 2021-11-01 | 3399.99 | 1 | SO43787 | 2021-11-08 | 272.00 | 1912.15 | |
SO55596_4 | 100 | 19122 | 477 | 4 | 2024-01-27 | 0.12 | 2024-01-15 | 4.99 | 4 | SO55596 | 2024-01-22 | 0.40 | 1.87 | |
SO43788_1 | 98 | 11239 | 351 | 10 | 2021-11-13 | 84.37 | 2021-11-01 | 3374.99 | 1 | SO43788 | 2021-11-08 | 270.00 | 1898.09 | |
SO55597_1 | 19 | 13284 | 363 | 2 | 6 | 2024-01-27 | 57.37 | 2024-01-15 | 2294.99 | 1 | SO55597 | 2024-01-22 | 183.60 | 1251.98 |
SO43789_1 | 100 | 25865 | 351 | 1 | 2021-11-13 | 84.37 | 2021-11-01 | 3374.99 | 1 | SO43789 | 2021-11-08 | 270.00 | 1898.09 | |
SO55597_2 | 19 | 13284 | 487 | 6 | 2024-01-27 | 1.37 | 2024-01-15 | 54.99 | 2 | SO55597 | 2024-01-22 | 4.40 | 20.57 | |
SO43790_1 | 100 | 25857 | 344 | 1 | 2021-11-13 | 85.00 | 2021-11-01 | 3399.99 | 1 | SO43790 | 2021-11-08 | 272.00 | 1912.15 | |
SO55597_3 | 19 | 13284 | 463 | 6 | 2024-01-27 | 0.61 | 2024-01-15 | 24.49 | 3 | SO55597 | 2024-01-22 | 1.96 | 9.16 | |
SO43791_1 | 6 | 16484 | 314 | 9 | 2021-11-13 | 89.46 | 2021-11-01 | 3578.27 | 1 | SO43791 | 2021-11-08 | 286.26 | 2171.29 | |
SO55598_1 | 100 | 12941 | 353 | 2 | 1 | 2024-01-27 | 58.00 | 2024-01-15 | 2319.99 | 1 | SO55598 | 2024-01-22 | 185.60 | 1265.62 |
SO43792_1 | 6 | 16623 | 312 | 9 | 2021-11-13 | 89.46 | 2021-11-01 | 3578.27 | 1 | SO43792 | 2021-11-08 | 286.26 | 2171.29 | |
SO55598_2 | 100 | 12941 | 487 | 1 | 2024-01-27 | 1.37 | 2024-01-15 | 54.99 | 2 | SO55598 | 2024-01-22 | 4.40 | 20.57 | |
SO43793_1 | 6 | 11000 | 344 | 9 | 2021-11-13 | 85.00 | 2021-11-01 | 3399.99 | 1 | SO43793 | 2021-11-08 | 272.00 | 1912.15 | |
SO55599_1 | 100 | 11040 | 353 | 1 | 2024-01-27 | 58.00 | 2024-01-15 | 2319.99 | 1 | SO55599 | 2024-01-22 | 185.60 | 1265.62 |
Generated 2024-11-11 02:42:39.739 UTC