[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '9' > < SKIP 1688 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO64051_1 | 6 | 29342 | 569 | 9 | 2024-06-05 | 18.56 | 2024-05-24 | 742.35 | 1 | SO64051 | 2024-05-31 | 59.39 | 461.44 | |
SO64051_2 | 6 | 29342 | 222 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64051 | 2024-05-31 | 2.80 | 13.09 | |
SO64051_3 | 6 | 29342 | 465 | 9 | 2024-06-05 | 0.61 | 2024-05-24 | 24.49 | 3 | SO64051 | 2024-05-31 | 1.96 | 9.16 | |
SO64052_1 | 6 | 27879 | 560 | 9 | 2024-06-05 | 30.37 | 2024-05-24 | 1214.85 | 1 | SO64052 | 2024-05-31 | 97.19 | 755.15 | |
SO64052_2 | 6 | 27879 | 217 | 9 | 2024-06-05 | 0.87 | 2024-05-24 | 34.99 | 2 | SO64052 | 2024-05-31 | 2.80 | 13.09 | |
SO64052_3 | 6 | 27879 | 472 | 9 | 2024-06-05 | 1.59 | 2024-05-24 | 63.50 | 3 | SO64052 | 2024-05-31 | 5.08 | 23.75 | |
SO64053_1 | 6 | 23996 | 605 | 9 | 2024-06-05 | 13.50 | 2024-05-24 | 539.99 | 1 | SO64053 | 2024-05-31 | 43.20 | 343.65 | |
SO64053_2 | 6 | 23996 | 479 | 9 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 2 | SO64053 | 2024-05-31 | 0.72 | 3.36 | |
SO64053_3 | 6 | 23996 | 477 | 9 | 2024-06-05 | 0.12 | 2024-05-24 | 4.99 | 3 | SO64053 | 2024-05-31 | 0.40 | 1.87 | |
SO64053_4 | 6 | 23996 | 225 | 9 | 2024-06-05 | 0.22 | 2024-05-24 | 8.99 | 4 | SO64053 | 2024-05-31 | 0.72 | 6.92 | |
SO64055_1 | 6 | 15242 | 539 | 9 | 2024-06-06 | 0.62 | 2024-05-25 | 24.99 | 1 | SO64055 | 2024-06-01 | 2.00 | 9.35 | |
SO64055_2 | 6 | 15242 | 480 | 9 | 2024-06-06 | 0.06 | 2024-05-25 | 2.29 | 2 | SO64055 | 2024-06-01 | 0.18 | 0.86 | |
SO64056_1 | 6 | 17058 | 536 | 9 | 2024-06-06 | 0.75 | 2024-05-25 | 29.99 | 1 | SO64056 | 2024-06-01 | 2.40 | 11.22 | |
SO64057_1 | 6 | 22206 | 528 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 1 | SO64057 | 2024-06-01 | 0.40 | 1.87 | |
SO64057_2 | 6 | 22206 | 537 | 9 | 2024-06-06 | 0.88 | 2024-05-25 | 35.00 | 2 | SO64057 | 2024-06-01 | 2.80 | 13.09 | |
SO64057_3 | 6 | 22206 | 480 | 9 | 2024-06-06 | 0.06 | 2024-05-25 | 2.29 | 3 | SO64057 | 2024-06-01 | 0.18 | 0.86 | |
SO64057_4 | 6 | 22206 | 486 | 9 | 2024-06-06 | 3.98 | 2024-05-25 | 159.00 | 4 | SO64057 | 2024-06-01 | 12.72 | 59.47 | |
SO64058_1 | 6 | 21178 | 537 | 9 | 2024-06-06 | 0.88 | 2024-05-25 | 35.00 | 1 | SO64058 | 2024-06-01 | 2.80 | 13.09 | |
SO64058_2 | 6 | 21178 | 528 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 2 | SO64058 | 2024-06-01 | 0.40 | 1.87 | |
SO64059_1 | 6 | 22919 | 477 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 1 | SO64059 | 2024-06-01 | 0.40 | 1.87 | |
SO64059_2 | 6 | 22919 | 490 | 9 | 2024-06-06 | 1.35 | 2024-05-25 | 53.99 | 2 | SO64059 | 2024-06-01 | 4.32 | 41.57 | |
SO64060_1 | 6 | 26741 | 474 | 9 | 2024-06-06 | 1.75 | 2024-05-25 | 69.99 | 1 | SO64060 | 2024-06-01 | 5.60 | 26.18 | |
SO64061_1 | 6 | 15577 | 222 | 9 | 2024-06-06 | 0.87 | 2024-05-25 | 34.99 | 1 | SO64061 | 2024-06-01 | 2.80 | 13.09 | |
SO64061_2 | 6 | 15577 | 463 | 9 | 2024-06-06 | 0.61 | 2024-05-25 | 24.49 | 2 | SO64061 | 2024-06-01 | 1.96 | 9.16 | |
SO64062_1 | 6 | 15142 | 214 | 9 | 2024-06-06 | 0.87 | 2024-05-25 | 34.99 | 1 | SO64062 | 2024-06-01 | 2.80 | 13.09 | |
SO64062_2 | 6 | 15142 | 463 | 9 | 2024-06-06 | 0.61 | 2024-05-25 | 24.49 | 2 | SO64062 | 2024-06-01 | 1.96 | 9.16 | |
SO64062_3 | 6 | 15142 | 490 | 9 | 2024-06-06 | 1.35 | 2024-05-25 | 53.99 | 3 | SO64062 | 2024-06-01 | 4.32 | 41.57 | |
SO64063_1 | 6 | 19585 | 541 | 9 | 2024-06-06 | 0.72 | 2024-05-25 | 28.99 | 1 | SO64063 | 2024-06-01 | 2.32 | 10.84 | |
SO64064_1 | 6 | 17317 | 225 | 9 | 2024-06-06 | 0.22 | 2024-05-25 | 8.99 | 1 | SO64064 | 2024-06-01 | 0.72 | 6.92 | |
SO64073_1 | 6 | 12012 | 535 | 9 | 2024-06-06 | 0.62 | 2024-05-25 | 24.99 | 1 | SO64073 | 2024-06-01 | 2.00 | 9.35 | |
SO64104_1 | 6 | 25823 | 382 | 9 | 2024-06-06 | 28.01 | 2024-05-25 | 1120.49 | 1 | SO64104 | 2024-06-01 | 89.64 | 713.08 | |
SO64104_2 | 6 | 25823 | 479 | 9 | 2024-06-06 | 0.22 | 2024-05-25 | 8.99 | 2 | SO64104 | 2024-06-01 | 0.72 | 3.36 | |
SO64104_3 | 6 | 25823 | 477 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 3 | SO64104 | 2024-06-01 | 0.40 | 1.87 | |
SO64104_4 | 6 | 25823 | 491 | 9 | 2024-06-06 | 1.35 | 2024-05-25 | 53.99 | 4 | SO64104 | 2024-06-01 | 4.32 | 41.57 | |
SO64105_1 | 6 | 12570 | 600 | 9 | 2024-06-06 | 13.50 | 2024-05-25 | 539.99 | 1 | SO64105 | 2024-06-01 | 43.20 | 294.58 | |
SO64105_2 | 6 | 12570 | 535 | 9 | 2024-06-06 | 0.62 | 2024-05-25 | 24.99 | 2 | SO64105 | 2024-06-01 | 2.00 | 9.35 | |
SO64105_3 | 6 | 12570 | 528 | 9 | 2024-06-06 | 0.12 | 2024-05-25 | 4.99 | 3 | SO64105 | 2024-06-01 | 0.40 | 1.87 | |
SO64105_4 | 6 | 12570 | 222 | 9 | 2024-06-06 | 0.87 | 2024-05-25 | 34.99 | 4 | SO64105 | 2024-06-01 | 2.80 | 13.09 | |
SO64106_1 | 6 | 14070 | 353 | 2 | 9 | 2024-06-06 | 58.00 | 2024-05-25 | 2319.99 | 1 | SO64106 | 2024-06-01 | 185.60 | 1265.62 |
SO64107_1 | 6 | 14051 | 355 | 9 | 2024-06-06 | 58.00 | 2024-05-25 | 2319.99 | 1 | SO64107 | 2024-06-01 | 185.60 | 1265.62 | |
SO55960_2 | 6 | 19095 | 214 | 9 | 2024-02-02 | 0.87 | 2024-01-21 | 34.99 | 2 | SO55960 | 2024-01-28 | 2.80 | 13.09 | |
SO45515_1 | 6 | 19557 | 310 | 9 | 2022-06-22 | 89.46 | 2022-06-10 | 3578.27 | 1 | SO45515 | 2022-06-17 | 286.26 | 2171.29 | |
SO55961_1 | 6 | 12000 | 363 | 9 | 2024-02-02 | 57.37 | 2024-01-21 | 2294.99 | 1 | SO55961 | 2024-01-28 | 183.60 | 1251.98 | |
SO45584_1 | 6 | 25828 | 336 | 9 | 2022-06-23 | 17.48 | 2022-06-11 | 699.10 | 1 | SO45584 | 2022-06-18 | 55.93 | 413.15 | |
SO55961_2 | 6 | 12000 | 478 | 9 | 2024-02-02 | 0.25 | 2024-01-21 | 9.99 | 2 | SO55961 | 2024-01-28 | 0.80 | 3.74 | |
SO45585_1 | 6 | 11905 | 351 | 9 | 2022-06-23 | 84.37 | 2022-06-11 | 3374.99 | 1 | SO45585 | 2022-06-18 | 270.00 | 1898.09 | |
SO55961_3 | 6 | 12000 | 477 | 9 | 2024-02-02 | 0.12 | 2024-01-21 | 4.99 | 3 | SO55961 | 2024-01-28 | 0.40 | 1.87 | |
SO45589_1 | 6 | 19784 | 314 | 9 | 2022-06-24 | 89.46 | 2022-06-12 | 3578.27 | 1 | SO45589 | 2022-06-19 | 286.26 | 2171.29 | |
SO55962_1 | 6 | 12002 | 353 | 9 | 2024-02-02 | 58.00 | 2024-01-21 | 2319.99 | 1 | SO55962 | 2024-01-28 | 185.60 | 1265.62 | |
SO45590_1 | 6 | 19763 | 311 | 9 | 2022-06-24 | 89.46 | 2022-06-12 | 3578.27 | 1 | SO45590 | 2022-06-19 | 286.26 | 2171.29 | |
SO55962_2 | 6 | 12002 | 537 | 9 | 2024-02-02 | 0.88 | 2024-01-21 | 35.00 | 2 | SO55962 | 2024-01-28 | 2.80 | 13.09 | |
SO45591_1 | 6 | 25831 | 326 | 9 | 2022-06-24 | 17.48 | 2022-06-12 | 699.10 | 1 | SO45591 | 2022-06-19 | 55.93 | 413.15 | |
SO55962_3 | 6 | 12002 | 480 | 9 | 2024-02-02 | 0.06 | 2024-01-21 | 2.29 | 3 | SO55962 | 2024-01-28 | 0.18 | 0.86 | |
SO45592_1 | 6 | 11897 | 345 | 9 | 2022-06-24 | 85.00 | 2022-06-12 | 3399.99 | 1 | SO45592 | 2022-06-19 | 272.00 | 1912.15 | |
SO55972_1 | 6 | 13639 | 528 | 9 | 2024-02-03 | 0.12 | 2024-01-22 | 4.99 | 1 | SO55972 | 2024-01-29 | 0.40 | 1.87 | |
SO45599_1 | 6 | 19794 | 312 | 9 | 2022-06-25 | 89.46 | 2022-06-13 | 3578.27 | 1 | SO45599 | 2022-06-20 | 286.26 | 2171.29 |
Generated 2024-11-11 02:34:35.252 UTC