[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '10' > < SKIP 476 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44730_1 | 98 | 14697 | 311 | 10 | 2022-01-31 | 89.46 | 2022-01-19 | 3578.27 | 1 | SO44730 | 2022-01-26 | 286.26 | 2171.29 | |
SO56792_2 | 98 | 23747 | 479 | 10 | 2023-12-29 | 0.22 | 2023-12-17 | 8.99 | 2 | SO56792 | 2023-12-24 | 0.72 | 3.36 | |
SO44809_1 | 98 | 20552 | 342 | 10 | 2022-02-03 | 17.48 | 2022-01-22 | 699.10 | 1 | SO44809 | 2022-01-29 | 55.93 | 413.15 | |
SO56792_3 | 98 | 23747 | 477 | 10 | 2023-12-29 | 0.12 | 2023-12-17 | 4.99 | 3 | SO56792 | 2023-12-24 | 0.40 | 1.87 | |
SO44817_1 | 98 | 14777 | 312 | 10 | 2022-02-04 | 89.46 | 2022-01-23 | 3578.27 | 1 | SO44817 | 2022-01-30 | 286.26 | 2171.29 | |
SO56792_4 | 98 | 23747 | 484 | 10 | 2023-12-29 | 0.20 | 2023-12-17 | 7.95 | 4 | SO56792 | 2023-12-24 | 0.64 | 2.97 | |
SO44867_1 | 98 | 14793 | 313 | 10 | 2022-02-10 | 89.46 | 2022-01-29 | 3578.27 | 1 | SO44867 | 2022-02-05 | 286.26 | 2171.29 | |
SO56797_1 | 98 | 12630 | 363 | 2 | 10 | 2023-12-30 | 57.37 | 2023-12-18 | 2294.99 | 1 | SO56797 | 2023-12-25 | 183.60 | 1251.98 |
SO44885_1 | 98 | 14833 | 310 | 10 | 2022-02-13 | 89.46 | 2022-02-01 | 3578.27 | 1 | SO44885 | 2022-02-08 | 286.26 | 2171.29 | |
SO56797_2 | 98 | 12630 | 537 | 10 | 2023-12-30 | 0.88 | 2023-12-18 | 35.00 | 2 | SO56797 | 2023-12-25 | 2.80 | 13.09 | |
SO44889_1 | 98 | 11351 | 348 | 10 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44889 | 2022-02-09 | 270.00 | 1898.09 | |
SO56797_3 | 98 | 12630 | 528 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56797 | 2023-12-25 | 0.40 | 1.87 | |
SO44890_1 | 98 | 11381 | 346 | 10 | 2022-02-14 | 85.00 | 2022-02-02 | 3399.99 | 1 | SO44890 | 2022-02-09 | 272.00 | 1912.15 | |
SO56806_1 | 98 | 20710 | 376 | 10 | 2023-12-30 | 61.08 | 2023-12-18 | 2443.35 | 1 | SO56806 | 2023-12-25 | 195.47 | 1554.95 | |
SO44899_1 | 98 | 11353 | 351 | 10 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44899 | 2022-02-09 | 270.00 | 1898.09 | |
SO56806_2 | 98 | 20710 | 479 | 10 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56806 | 2023-12-25 | 0.72 | 3.36 | |
SO44900_1 | 98 | 14778 | 314 | 10 | 2022-02-15 | 89.46 | 2022-02-03 | 3578.27 | 1 | SO44900 | 2022-02-10 | 286.26 | 2171.29 | |
SO56806_3 | 98 | 20710 | 477 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56806 | 2023-12-25 | 0.40 | 1.87 | |
SO44906_1 | 98 | 14832 | 311 | 10 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44906 | 2022-02-11 | 286.26 | 2171.29 | |
SO56822_1 | 98 | 16193 | 485 | 10 | 2023-12-30 | 0.55 | 2023-12-18 | 21.98 | 1 | SO56822 | 2023-12-25 | 1.76 | 8.22 | |
SO44928_1 | 98 | 14843 | 314 | 10 | 2022-02-19 | 89.46 | 2022-02-07 | 3578.27 | 1 | SO44928 | 2022-02-14 | 286.26 | 2171.29 | |
SO56822_2 | 98 | 16193 | 471 | 10 | 2023-12-30 | 1.59 | 2023-12-18 | 63.50 | 2 | SO56822 | 2023-12-25 | 5.08 | 23.75 | |
SO44934_1 | 98 | 14771 | 312 | 10 | 2022-02-20 | 89.46 | 2022-02-08 | 3578.27 | 1 | SO44934 | 2022-02-15 | 286.26 | 2171.29 | |
SO56826_1 | 98 | 27945 | 529 | 10 | 2023-12-30 | 0.10 | 2023-12-18 | 3.99 | 1 | SO56826 | 2023-12-25 | 0.32 | 1.49 | |
SO44958_1 | 98 | 20173 | 332 | 10 | 2022-02-22 | 17.48 | 2022-02-10 | 699.10 | 1 | SO44958 | 2022-02-17 | 55.93 | 413.15 | |
SO56826_2 | 98 | 27945 | 225 | 10 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56826 | 2023-12-25 | 0.72 | 6.92 | |
SO44967_1 | 98 | 14794 | 310 | 10 | 2022-02-23 | 89.46 | 2022-02-11 | 3578.27 | 1 | SO44967 | 2022-02-18 | 286.26 | 2171.29 | |
SO56828_1 | 98 | 14553 | 541 | 10 | 2023-12-30 | 0.72 | 2023-12-18 | 28.99 | 1 | SO56828 | 2023-12-25 | 2.32 | 10.84 | |
SO44974_1 | 98 | 14776 | 312 | 10 | 2022-02-24 | 89.46 | 2022-02-12 | 3578.27 | 1 | SO44974 | 2022-02-19 | 286.26 | 2171.29 | |
SO56828_2 | 98 | 14553 | 530 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 2 | SO56828 | 2023-12-25 | 0.40 | 1.87 | |
SO45008_1 | 98 | 14831 | 313 | 10 | 2022-03-01 | 89.46 | 2022-02-17 | 3578.27 | 1 | SO45008 | 2022-02-24 | 286.26 | 2171.29 | |
SO56828_3 | 98 | 14553 | 217 | 10 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 3 | SO56828 | 2023-12-25 | 2.80 | 13.09 | |
SO45016_1 | 98 | 14770 | 310 | 10 | 2022-03-02 | 89.46 | 2022-02-18 | 3578.27 | 1 | SO45016 | 2022-02-25 | 286.26 | 2171.29 | |
SO56829_1 | 98 | 15444 | 530 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 1 | SO56829 | 2023-12-25 | 0.40 | 1.87 | |
SO45031_1 | 98 | 14792 | 313 | 10 | 2022-03-04 | 89.46 | 2022-02-20 | 3578.27 | 1 | SO45031 | 2022-02-27 | 286.26 | 2171.29 | |
SO56829_2 | 98 | 15444 | 237 | 10 | 2023-12-30 | 1.25 | 2023-12-18 | 49.99 | 2 | SO56829 | 2023-12-25 | 4.00 | 38.49 | |
SO45083_1 | 98 | 14947 | 312 | 10 | 2022-03-06 | 89.46 | 2022-02-22 | 3578.27 | 1 | SO45083 | 2022-03-01 | 286.26 | 2171.29 | |
SO56837_1 | 98 | 11388 | 579 | 10 | 2023-12-30 | 30.37 | 2023-12-18 | 1214.85 | 1 | SO56837 | 2023-12-25 | 97.19 | 755.15 | |
SO45087_1 | 98 | 11388 | 350 | 10 | 2022-03-07 | 84.37 | 2022-02-23 | 3374.99 | 1 | SO45087 | 2022-03-02 | 270.00 | 1898.09 | |
SO56837_2 | 98 | 11388 | 491 | 10 | 2023-12-30 | 1.35 | 2023-12-18 | 53.99 | 2 | SO56837 | 2023-12-25 | 4.32 | 41.57 | |
SO45088_1 | 98 | 11398 | 345 | 10 | 2022-03-07 | 85.00 | 2022-02-23 | 3399.99 | 1 | SO45088 | 2022-03-02 | 272.00 | 1912.15 | |
SO56850_1 | 98 | 28365 | 574 | 10 | 2023-12-30 | 59.60 | 2023-12-18 | 2384.07 | 1 | SO56850 | 2023-12-25 | 190.73 | 1481.94 | |
SO45095_1 | 98 | 11394 | 344 | 10 | 2022-03-08 | 85.00 | 2022-02-24 | 3399.99 | 1 | SO45095 | 2022-03-03 | 272.00 | 1912.15 | |
SO56850_2 | 98 | 28365 | 479 | 10 | 2023-12-30 | 0.22 | 2023-12-18 | 8.99 | 2 | SO56850 | 2023-12-25 | 0.72 | 3.36 | |
SO45109_1 | 98 | 14937 | 311 | 10 | 2022-03-11 | 89.46 | 2022-02-27 | 3578.27 | 1 | SO45109 | 2022-03-06 | 286.26 | 2171.29 | |
SO56850_3 | 98 | 28365 | 477 | 10 | 2023-12-30 | 0.12 | 2023-12-18 | 4.99 | 3 | SO56850 | 2023-12-25 | 0.40 | 1.87 | |
SO45112_1 | 98 | 20558 | 324 | 10 | 2022-03-11 | 17.48 | 2022-02-27 | 699.10 | 1 | SO45112 | 2022-03-06 | 55.93 | 413.15 | |
SO56850_4 | 98 | 28365 | 214 | 10 | 2023-12-30 | 0.87 | 2023-12-18 | 34.99 | 4 | SO56850 | 2023-12-25 | 2.80 | 13.09 | |
SO45130_1 | 98 | 14975 | 313 | 10 | 2022-03-15 | 89.46 | 2022-03-03 | 3578.27 | 1 | SO45130 | 2022-03-10 | 286.26 | 2171.29 | |
SO56882_1 | 98 | 17886 | 535 | 10 | 2023-12-31 | 0.62 | 2023-12-19 | 24.99 | 1 | SO56882 | 2023-12-26 | 2.00 | 9.35 | |
SO45146_1 | 98 | 14950 | 310 | 10 | 2022-03-17 | 89.46 | 2022-03-05 | 3578.27 | 1 | SO45146 | 2022-03-12 | 286.26 | 2171.29 | |
SO56882_2 | 98 | 17886 | 477 | 10 | 2023-12-31 | 0.12 | 2023-12-19 | 4.99 | 2 | SO56882 | 2023-12-26 | 0.40 | 1.87 | |
SO45149_1 | 98 | 14941 | 314 | 10 | 2022-03-18 | 89.46 | 2022-03-06 | 3578.27 | 1 | SO45149 | 2022-03-13 | 286.26 | 2171.29 | |
SO56882_3 | 98 | 17886 | 225 | 10 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 3 | SO56882 | 2023-12-26 | 0.72 | 6.92 | |
SO45159_1 | 98 | 11400 | 349 | 10 | 2022-03-19 | 84.37 | 2022-03-07 | 3374.99 | 1 | SO45159 | 2022-03-14 | 270.00 | 1898.09 | |
SO56892_1 | 98 | 13586 | 225 | 10 | 2023-12-31 | 0.22 | 2023-12-19 | 8.99 | 1 | SO56892 | 2023-12-26 | 0.72 | 6.92 |
Generated 2024-09-20 08:58:32.641 UTC