[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1275 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44597_1 | 39 | 12290 | 310 | 7 | 2022-09-05 | 89.46 | 2022-08-24 | 3578.27 | 1 | SO44597 | 2022-08-31 | 286.26 | 2171.29 |
SO44598_1 | 29 | 29400 | 348 | 8 | 2022-09-05 | 84.37 | 2022-08-24 | 3374.99 | 1 | SO44598 | 2022-08-31 | 270.00 | 1898.09 |
SO44599_1 | 100 | 28792 | 310 | 1 | 2022-09-05 | 89.46 | 2022-08-24 | 3578.27 | 1 | SO44599 | 2022-08-31 | 286.26 | 2171.29 |
SO44600_1 | 6 | 18243 | 314 | 9 | 2022-09-05 | 89.46 | 2022-08-24 | 3578.27 | 1 | SO44600 | 2022-08-31 | 286.26 | 2171.29 |
SO44601_1 | 6 | 11117 | 345 | 9 | 2022-09-05 | 85.00 | 2022-08-24 | 3399.99 | 1 | SO44601 | 2022-08-31 | 272.00 | 1912.15 |
SO55814_3 | 6 | 14064 | 489 | 9 | 2024-08-07 | 1.35 | 2024-07-26 | 53.99 | 3 | SO55814 | 2024-08-02 | 4.32 | 41.57 |
SO55815_1 | 19 | 11711 | 477 | 6 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 1 | SO55815 | 2024-08-02 | 0.40 | 1.87 |
SO55815_2 | 19 | 11711 | 479 | 6 | 2024-08-07 | 0.22 | 2024-07-26 | 8.99 | 2 | SO55815 | 2024-08-02 | 0.72 | 3.36 |
SO55816_1 | 6 | 11094 | 535 | 9 | 2024-08-07 | 0.62 | 2024-07-26 | 24.99 | 1 | SO55816 | 2024-08-02 | 2.00 | 9.35 |
SO55816_2 | 6 | 11094 | 528 | 9 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 2 | SO55816 | 2024-08-02 | 0.40 | 1.87 |
SO55817_1 | 6 | 14237 | 529 | 9 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 1 | SO55817 | 2024-08-02 | 0.32 | 1.49 |
SO55817_2 | 6 | 14237 | 539 | 9 | 2024-08-07 | 0.62 | 2024-07-26 | 24.99 | 2 | SO55817 | 2024-08-02 | 2.00 | 9.35 |
SO55817_3 | 6 | 14237 | 480 | 9 | 2024-08-07 | 0.06 | 2024-07-26 | 2.29 | 3 | SO55817 | 2024-08-02 | 0.18 | 0.86 |
SO55818_1 | 6 | 20419 | 477 | 9 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 1 | SO55818 | 2024-08-02 | 0.40 | 1.87 |
SO55819_1 | 6 | 15216 | 477 | 9 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 1 | SO55819 | 2024-08-02 | 0.40 | 1.87 |
SO55819_2 | 6 | 15216 | 478 | 9 | 2024-08-07 | 0.25 | 2024-07-26 | 9.99 | 2 | SO55819 | 2024-08-02 | 0.80 | 3.74 |
SO55819_3 | 6 | 15216 | 214 | 9 | 2024-08-07 | 0.87 | 2024-07-26 | 34.99 | 3 | SO55819 | 2024-08-02 | 2.80 | 13.09 |
SO55819_4 | 6 | 15216 | 465 | 9 | 2024-08-07 | 0.61 | 2024-07-26 | 24.49 | 4 | SO55819 | 2024-08-02 | 1.96 | 9.16 |
SO55820_1 | 6 | 15810 | 540 | 9 | 2024-08-07 | 0.82 | 2024-07-26 | 32.60 | 1 | SO55820 | 2024-08-02 | 2.61 | 12.19 |
SO55820_2 | 6 | 15810 | 480 | 9 | 2024-08-07 | 0.06 | 2024-07-26 | 2.29 | 2 | SO55820 | 2024-08-02 | 0.18 | 0.86 |
SO55821_1 | 6 | 13149 | 217 | 9 | 2024-08-07 | 0.87 | 2024-07-26 | 34.99 | 1 | SO55821 | 2024-08-02 | 2.80 | 13.09 |
SO55822_1 | 100 | 24718 | 580 | 8 | 2024-08-07 | 42.52 | 2024-07-26 | 1700.99 | 1 | SO55822 | 2024-08-02 | 136.08 | 1082.51 |
SO55822_2 | 100 | 24718 | 237 | 8 | 2024-08-07 | 1.25 | 2024-07-26 | 49.99 | 2 | SO55822 | 2024-08-02 | 4.00 | 38.49 |
SO55823_1 | 98 | 20150 | 374 | 10 | 2024-08-07 | 61.08 | 2024-07-26 | 2443.35 | 1 | SO55823 | 2024-08-02 | 195.47 | 1554.95 |
SO55823_2 | 98 | 20150 | 529 | 10 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 2 | SO55823 | 2024-08-02 | 0.32 | 1.49 |
SO55823_3 | 98 | 20150 | 540 | 10 | 2024-08-07 | 0.82 | 2024-07-26 | 32.60 | 3 | SO55823 | 2024-08-02 | 2.61 | 12.19 |
SO55823_4 | 98 | 20150 | 217 | 10 | 2024-08-07 | 0.87 | 2024-07-26 | 34.99 | 4 | SO55823 | 2024-08-02 | 2.80 | 13.09 |
SO55823_5 | 98 | 20150 | 228 | 10 | 2024-08-07 | 1.25 | 2024-07-26 | 49.99 | 5 | SO55823 | 2024-08-02 | 4.00 | 38.49 |
SO55824_1 | 100 | 13799 | 587 | 7 | 2024-08-07 | 19.24 | 2024-07-26 | 769.49 | 1 | SO55824 | 2024-08-02 | 61.56 | 419.78 |
SO55824_2 | 100 | 13799 | 231 | 7 | 2024-08-07 | 1.25 | 2024-07-26 | 49.99 | 2 | SO55824 | 2024-08-02 | 4.00 | 38.49 |
SO55824_3 | 100 | 13799 | 225 | 7 | 2024-08-07 | 0.22 | 2024-07-26 | 8.99 | 3 | SO55824 | 2024-08-02 | 0.72 | 6.92 |
SO55825_1 | 98 | 15653 | 587 | 10 | 2024-08-07 | 19.24 | 2024-07-26 | 769.49 | 1 | SO55825 | 2024-08-02 | 61.56 | 419.78 |
SO55825_2 | 98 | 15653 | 528 | 10 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 2 | SO55825 | 2024-08-02 | 0.40 | 1.87 |
SO55825_3 | 98 | 15653 | 536 | 10 | 2024-08-07 | 0.75 | 2024-07-26 | 29.99 | 3 | SO55825 | 2024-08-02 | 2.40 | 11.22 |
SO55825_4 | 98 | 15653 | 214 | 10 | 2024-08-07 | 0.87 | 2024-07-26 | 34.99 | 4 | SO55825 | 2024-08-02 | 2.80 | 13.09 |
SO44602_1 | 98 | 14702 | 314 | 10 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44602 | 2022-09-01 | 286.26 | 2171.29 |
SO55825_5 | 98 | 15653 | 225 | 10 | 2024-08-07 | 0.22 | 2024-07-26 | 8.99 | 5 | SO55825 | 2024-08-02 | 0.72 | 6.92 |
SO44603_1 | 98 | 20167 | 342 | 10 | 2022-09-06 | 17.48 | 2022-08-25 | 699.10 | 1 | SO44603 | 2022-09-01 | 55.93 | 413.15 |
SO55826_1 | 19 | 11223 | 490 | 6 | 2024-08-07 | 1.35 | 2024-07-26 | 53.99 | 1 | SO55826 | 2024-08-02 | 4.32 | 41.57 |
SO44604_1 | 29 | 19364 | 322 | 8 | 2022-09-06 | 17.48 | 2022-08-25 | 699.10 | 1 | SO44604 | 2022-09-01 | 55.93 | 413.15 |
SO55827_1 | 100 | 11221 | 529 | 4 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 1 | SO55827 | 2024-08-02 | 0.32 | 1.49 |
SO44605_1 | 100 | 28672 | 314 | 4 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44605 | 2022-09-01 | 286.26 | 2171.29 |
SO55828_1 | 100 | 28127 | 530 | 4 | 2024-08-07 | 0.12 | 2024-07-26 | 4.99 | 1 | SO55828 | 2024-08-02 | 0.40 | 1.87 |
SO44606_1 | 100 | 28772 | 313 | 1 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44606 | 2022-09-01 | 286.26 | 2171.29 |
SO55829_1 | 100 | 29089 | 529 | 4 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 1 | SO55829 | 2024-08-02 | 0.32 | 1.49 |
SO44607_1 | 100 | 28774 | 310 | 4 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44607 | 2022-09-01 | 286.26 | 2171.29 |
SO55829_2 | 100 | 29089 | 480 | 4 | 2024-08-07 | 0.06 | 2024-07-26 | 2.29 | 2 | SO55829 | 2024-08-02 | 0.18 | 0.86 |
SO44608_1 | 6 | 18200 | 313 | 9 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44608 | 2022-09-01 | 286.26 | 2171.29 |
SO55830_1 | 100 | 27680 | 529 | 4 | 2024-08-07 | 0.10 | 2024-07-26 | 3.99 | 1 | SO55830 | 2024-08-02 | 0.32 | 1.49 |
SO44609_1 | 6 | 18220 | 311 | 9 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44609 | 2022-09-01 | 286.26 | 2171.29 |
SO55830_2 | 100 | 27680 | 538 | 4 | 2024-08-07 | 0.54 | 2024-07-26 | 21.49 | 2 | SO55830 | 2024-08-02 | 1.72 | 8.04 |
SO44610_1 | 6 | 18241 | 313 | 9 | 2022-09-06 | 89.46 | 2022-08-25 | 3578.27 | 1 | SO44610 | 2022-09-01 | 286.26 | 2171.29 |
SO55830_3 | 100 | 27680 | 480 | 4 | 2024-08-07 | 0.06 | 2024-07-26 | 2.29 | 3 | SO55830 | 2024-08-02 | 0.18 | 0.86 |
SO44611_1 | 29 | 13778 | 314 | 8 | 2022-09-07 | 89.46 | 2022-08-26 | 3578.27 | 1 | SO44611 | 2022-09-02 | 286.26 | 2171.29 |
SO55830_4 | 100 | 27680 | 484 | 4 | 2024-08-07 | 0.20 | 2024-07-26 | 7.95 | 4 | SO55830 | 2024-08-02 | 0.64 | 2.97 |
SO44612_1 | 100 | 28675 | 311 | 4 | 2022-09-07 | 89.46 | 2022-08-26 | 3578.27 | 1 | SO44612 | 2022-09-02 | 286.26 | 2171.29 |
Generated 2025-05-18 15:39:14.897 UTC