[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1417 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO56530_1 | 6 | 12675 | 355 | 9 | 2024-08-06 | 58.00 | 2024-07-25 | 2319.99 | 1 | SO56530 | 2024-08-01 | 185.60 | 1265.62 | |
SO45591_1 | 6 | 25831 | 326 | 9 | 2022-12-16 | 17.48 | 2022-12-04 | 699.10 | 1 | SO45591 | 2022-12-11 | 55.93 | 413.15 | |
SO56530_2 | 6 | 12675 | 537 | 9 | 2024-08-06 | 0.88 | 2024-07-25 | 35.00 | 2 | SO56530 | 2024-08-01 | 2.80 | 13.09 | |
SO45592_1 | 6 | 11897 | 345 | 9 | 2022-12-16 | 85.00 | 2022-12-04 | 3399.99 | 1 | SO45592 | 2022-12-11 | 272.00 | 1912.15 | |
SO56530_3 | 6 | 12675 | 480 | 9 | 2024-08-06 | 0.06 | 2024-07-25 | 2.29 | 3 | SO56530 | 2024-08-01 | 0.18 | 0.86 | |
SO45599_1 | 6 | 19794 | 312 | 9 | 2022-12-17 | 89.46 | 2022-12-05 | 3578.27 | 1 | SO45599 | 2022-12-12 | 286.26 | 2171.29 | |
SO56532_1 | 6 | 11443 | 363 | 9 | 2024-08-06 | 57.37 | 2024-07-25 | 2294.99 | 1 | SO56532 | 2024-08-01 | 183.60 | 1251.98 | |
SO45600_1 | 6 | 19628 | 313 | 9 | 2022-12-17 | 89.46 | 2022-12-05 | 3578.27 | 1 | SO45600 | 2022-12-12 | 286.26 | 2171.29 | |
SO56532_2 | 6 | 11443 | 537 | 9 | 2024-08-06 | 0.88 | 2024-07-25 | 35.00 | 2 | SO56532 | 2024-08-01 | 2.80 | 13.09 | |
SO45601_1 | 6 | 11893 | 348 | 9 | 2022-12-17 | 84.37 | 2022-12-05 | 3374.99 | 1 | SO45601 | 2022-12-12 | 270.00 | 1898.09 | |
SO56532_3 | 6 | 11443 | 485 | 9 | 2024-08-06 | 0.55 | 2024-07-25 | 21.98 | 3 | SO56532 | 2024-08-01 | 1.76 | 8.22 | |
SO45606_1 | 6 | 19967 | 312 | 9 | 2022-12-18 | 89.46 | 2022-12-06 | 3578.27 | 1 | SO45606 | 2022-12-13 | 286.26 | 2171.29 | |
SO56532_4 | 6 | 11443 | 217 | 9 | 2024-08-06 | 0.87 | 2024-07-25 | 34.99 | 4 | SO56532 | 2024-08-01 | 2.80 | 13.09 | |
SO45607_1 | 6 | 25830 | 330 | 9 | 2022-12-18 | 17.48 | 2022-12-06 | 699.10 | 1 | SO45607 | 2022-12-13 | 55.93 | 413.15 | |
SO56532_5 | 6 | 11443 | 490 | 9 | 2024-08-06 | 1.35 | 2024-07-25 | 53.99 | 5 | SO56532 | 2024-08-01 | 4.32 | 41.57 | |
SO45608_1 | 6 | 11896 | 349 | 9 | 2022-12-18 | 84.37 | 2022-12-06 | 3374.99 | 1 | SO45608 | 2022-12-13 | 270.00 | 1898.09 | |
SO56533_1 | 6 | 11986 | 353 | 9 | 2024-08-06 | 58.00 | 2024-07-25 | 2319.99 | 1 | SO56533 | 2024-08-01 | 185.60 | 1265.62 | |
SO45619_1 | 6 | 19787 | 311 | 9 | 2022-12-20 | 89.46 | 2022-12-08 | 3578.27 | 1 | SO45619 | 2022-12-15 | 286.26 | 2171.29 | |
SO56533_2 | 6 | 11986 | 528 | 9 | 2024-08-06 | 0.12 | 2024-07-25 | 4.99 | 2 | SO56533 | 2024-08-01 | 0.40 | 1.87 | |
SO45620_1 | 6 | 19951 | 314 | 9 | 2022-12-20 | 89.46 | 2022-12-08 | 3578.27 | 1 | SO45620 | 2022-12-15 | 286.26 | 2171.29 | |
SO56533_3 | 6 | 11986 | 537 | 9 | 2024-08-06 | 0.88 | 2024-07-25 | 35.00 | 3 | SO56533 | 2024-08-01 | 2.80 | 13.09 | |
SO45621_1 | 6 | 11768 | 346 | 9 | 2022-12-20 | 85.00 | 2022-12-08 | 3399.99 | 1 | SO45621 | 2022-12-15 | 272.00 | 1912.15 | |
SO56533_4 | 6 | 11986 | 485 | 9 | 2024-08-06 | 0.55 | 2024-07-25 | 21.98 | 4 | SO56533 | 2024-08-01 | 1.76 | 8.22 | |
SO45628_1 | 6 | 19795 | 314 | 9 | 2022-12-21 | 89.46 | 2022-12-09 | 3578.27 | 1 | SO45628 | 2022-12-16 | 286.26 | 2171.29 | |
SO56533_5 | 6 | 11986 | 480 | 9 | 2024-08-06 | 0.06 | 2024-07-25 | 2.29 | 5 | SO56533 | 2024-08-01 | 0.18 | 0.86 | |
SO45629_1 | 6 | 11892 | 347 | 9 | 2022-12-21 | 85.00 | 2022-12-09 | 3399.99 | 1 | SO45629 | 2022-12-16 | 272.00 | 1912.15 | |
SO56533_6 | 6 | 11986 | 484 | 9 | 2024-08-06 | 0.20 | 2024-07-25 | 7.95 | 6 | SO56533 | 2024-08-01 | 0.64 | 2.97 | |
SO45630_1 | 6 | 11899 | 351 | 9 | 2022-12-21 | 84.37 | 2022-12-09 | 3374.99 | 1 | SO45630 | 2022-12-16 | 270.00 | 1898.09 | |
SO56541_1 | 6 | 14071 | 577 | 2 | 9 | 2024-08-07 | 30.37 | 2024-07-26 | 1214.85 | 1 | SO56541 | 2024-08-02 | 97.19 | 755.15 |
SO45634_1 | 6 | 19766 | 314 | 9 | 2022-12-22 | 89.46 | 2022-12-10 | 3578.27 | 1 | SO45634 | 2022-12-17 | 286.26 | 2171.29 | |
SO56541_2 | 6 | 14071 | 541 | 9 | 2024-08-07 | 0.72 | 2024-07-26 | 28.99 | 2 | SO56541 | 2024-08-02 | 2.32 | 10.84 | |
SO45639_1 | 6 | 19782 | 311 | 9 | 2022-12-23 | 89.46 | 2022-12-11 | 3578.27 | 1 | SO45639 | 2022-12-18 | 286.26 | 2171.29 | |
SO56541_3 | 6 | 14071 | 530 | 9 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 3 | SO56541 | 2024-08-02 | 0.40 | 1.87 | |
SO45640_1 | 6 | 19964 | 311 | 9 | 2022-12-23 | 89.46 | 2022-12-11 | 3578.27 | 1 | SO45640 | 2022-12-18 | 286.26 | 2171.29 | |
SO56544_1 | 6 | 18295 | 485 | 9 | 2024-08-07 | 0.55 | 2024-07-26 | 21.98 | 1 | SO56544 | 2024-08-02 | 1.76 | 8.22 | |
SO45648_1 | 6 | 19791 | 312 | 9 | 2022-12-25 | 89.46 | 2022-12-13 | 3578.27 | 1 | SO45648 | 2022-12-20 | 286.26 | 2171.29 | |
SO56544_2 | 6 | 18295 | 483 | 9 | 2024-08-07 | 3.00 | 2024-07-26 | 120.00 | 2 | SO56544 | 2024-08-02 | 9.60 | 44.88 | |
SO45651_1 | 6 | 19771 | 311 | 9 | 2022-12-26 | 89.46 | 2022-12-14 | 3578.27 | 1 | SO45651 | 2022-12-21 | 286.26 | 2171.29 | |
SO56545_1 | 6 | 21953 | 537 | 9 | 2024-08-07 | 0.88 | 2024-07-26 | 35.00 | 1 | SO56545 | 2024-08-02 | 2.80 | 13.09 | |
SO45652_1 | 6 | 25826 | 334 | 9 | 2022-12-26 | 17.48 | 2022-12-14 | 699.10 | 1 | SO45652 | 2022-12-21 | 55.93 | 413.15 | |
SO56546_1 | 6 | 17244 | 491 | 9 | 2024-08-07 | 1.35 | 2024-07-26 | 53.99 | 1 | SO56546 | 2024-08-02 | 4.32 | 41.57 | |
SO45653_1 | 6 | 11764 | 347 | 9 | 2022-12-26 | 85.00 | 2022-12-14 | 3399.99 | 1 | SO45653 | 2022-12-21 | 272.00 | 1912.15 | |
SO56547_1 | 6 | 11113 | 484 | 9 | 2024-08-07 | 0.20 | 2024-07-26 | 7.95 | 1 | SO56547 | 2024-08-02 | 0.64 | 2.97 | |
SO45660_1 | 6 | 19797 | 312 | 9 | 2022-12-27 | 89.46 | 2022-12-15 | 3578.27 | 1 | SO45660 | 2022-12-22 | 286.26 | 2171.29 | |
SO56548_1 | 6 | 18195 | 225 | 9 | 2024-08-07 | 0.22 | 2024-07-26 | 8.99 | 1 | SO56548 | 2024-08-02 | 0.72 | 6.92 | |
SO45661_1 | 6 | 25827 | 342 | 9 | 2022-12-27 | 17.48 | 2022-12-15 | 699.10 | 1 | SO45661 | 2022-12-22 | 55.93 | 413.15 | |
SO56549_1 | 6 | 18304 | 480 | 9 | 2024-08-07 | 0.06 | 2024-07-26 | 2.29 | 1 | SO56549 | 2024-08-02 | 0.18 | 0.86 | |
SO45662_1 | 6 | 11906 | 350 | 9 | 2022-12-27 | 84.37 | 2022-12-15 | 3374.99 | 1 | SO45662 | 2022-12-22 | 270.00 | 1898.09 | |
SO56550_1 | 6 | 17484 | 487 | 9 | 2024-08-07 | 1.37 | 2024-07-26 | 54.99 | 1 | SO56550 | 2024-08-02 | 4.40 | 20.57 | |
SO45663_1 | 6 | 11901 | 347 | 9 | 2022-12-27 | 85.00 | 2022-12-15 | 3399.99 | 1 | SO45663 | 2022-12-22 | 272.00 | 1912.15 | |
SO56550_2 | 6 | 17484 | 234 | 9 | 2024-08-07 | 1.25 | 2024-07-26 | 49.99 | 2 | SO56550 | 2024-08-02 | 4.00 | 38.49 | |
SO45667_1 | 6 | 19957 | 314 | 9 | 2022-12-28 | 89.46 | 2022-12-16 | 3578.27 | 1 | SO45667 | 2022-12-23 | 286.26 | 2171.29 | |
SO56551_1 | 6 | 16625 | 540 | 9 | 2024-08-07 | 0.82 | 2024-07-26 | 32.60 | 1 | SO56551 | 2024-08-02 | 2.61 | 12.19 | |
SO45673_1 | 6 | 19790 | 312 | 9 | 2022-12-29 | 89.46 | 2022-12-17 | 3578.27 | 1 | SO45673 | 2022-12-24 | 286.26 | 2171.29 | |
SO56551_2 | 6 | 16625 | 529 | 9 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 2 | SO56551 | 2024-08-02 | 0.32 | 1.49 | |
SO45674_1 | 6 | 19948 | 314 | 9 | 2022-12-29 | 89.46 | 2022-12-17 | 3578.27 | 1 | SO45674 | 2022-12-24 | 286.26 | 2171.29 |
Generated 2025-05-04 12:00:43.214 UTC