[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ ALL < SKIP 1574 > < TAKE 56 >
56 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO44895_1 | 100 | 25951 | 351 | 4 | 2022-02-14 | 84.37 | 2022-02-02 | 3374.99 | 1 | SO44895 | 2022-02-09 | 270.00 | 1898.09 | |
SO44896_1 | 100 | 25964 | 346 | 1 | 2022-02-14 | 85.00 | 2022-02-02 | 3399.99 | 1 | SO44896 | 2022-02-09 | 272.00 | 1912.15 | |
SO44897_1 | 6 | 18696 | 314 | 9 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44897 | 2022-02-09 | 286.26 | 2171.29 | |
SO44898_1 | 6 | 18307 | 310 | 9 | 2022-02-14 | 89.46 | 2022-02-02 | 3578.27 | 1 | SO44898 | 2022-02-09 | 286.26 | 2171.29 | |
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 | |
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 | |
SO44901_1 | 39 | 12332 | 313 | 7 | 2022-02-15 | 89.46 | 2022-02-03 | 3578.27 | 1 | SO44901 | 2022-02-10 | 286.26 | 2171.29 | |
SO44902_1 | 29 | 13829 | 314 | 8 | 2022-02-15 | 89.46 | 2022-02-03 | 3578.27 | 1 | SO44902 | 2022-02-10 | 286.26 | 2171.29 | |
SO44903_1 | 6 | 18284 | 313 | 9 | 2022-02-15 | 89.46 | 2022-02-03 | 3578.27 | 1 | SO44903 | 2022-02-10 | 286.26 | 2171.29 | |
SO44904_1 | 6 | 11359 | 350 | 9 | 2022-02-15 | 84.37 | 2022-02-03 | 3374.99 | 1 | SO44904 | 2022-02-10 | 270.00 | 1898.09 | |
SO44905_1 | 29 | 13822 | 312 | 8 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44905 | 2022-02-11 | 286.26 | 2171.29 | |
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 | |
SO44907_1 | 29 | 19415 | 324 | 8 | 2022-02-16 | 17.48 | 2022-02-04 | 699.10 | 1 | SO44907 | 2022-02-11 | 55.93 | 413.15 | |
SO44908_1 | 100 | 29032 | 314 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44908 | 2022-02-11 | 286.26 | 2171.29 | |
SO44909_1 | 100 | 28840 | 310 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44909 | 2022-02-11 | 286.26 | 2171.29 | |
SO44910_1 | 100 | 25969 | 344 | 4 | 2022-02-16 | 85.00 | 2022-02-04 | 3399.99 | 1 | SO44910 | 2022-02-11 | 272.00 | 1912.15 | |
SO44911_1 | 100 | 25976 | 349 | 4 | 2022-02-16 | 84.37 | 2022-02-04 | 3374.99 | 1 | SO44911 | 2022-02-11 | 270.00 | 1898.09 | |
SO44912_1 | 100 | 28966 | 310 | 4 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44912 | 2022-02-11 | 286.26 | 2171.29 | |
SO44913_1 | 6 | 18468 | 311 | 9 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44913 | 2022-02-11 | 286.26 | 2171.29 | |
SO44914_1 | 6 | 18491 | 311 | 9 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44914 | 2022-02-11 | 286.26 | 2171.29 | |
SO44915_1 | 6 | 18461 | 312 | 9 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44915 | 2022-02-11 | 286.26 | 2171.29 | |
SO55841_1 | 100 | 19152 | 474 | 1 | 2023-12-11 | 1.75 | 2023-11-29 | 69.99 | 1 | SO55841 | 2023-12-06 | 5.60 | 26.18 | |
SO44916_1 | 6 | 18463 | 311 | 9 | 2022-02-16 | 89.46 | 2022-02-04 | 3578.27 | 1 | SO44916 | 2022-02-11 | 286.26 | 2171.29 | |
SO55841_2 | 100 | 19152 | 225 | 1 | 2023-12-11 | 0.22 | 2023-11-29 | 8.99 | 2 | SO55841 | 2023-12-06 | 0.72 | 6.92 | |
SO44917_1 | 29 | 13842 | 310 | 8 | 2022-02-17 | 89.46 | 2022-02-05 | 3578.27 | 1 | SO44917 | 2022-02-12 | 286.26 | 2171.29 | |
SO55842_1 | 100 | 16382 | 477 | 1 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55842 | 2023-12-06 | 0.40 | 1.87 | |
SO44918_1 | 29 | 29466 | 350 | 8 | 2022-02-17 | 84.37 | 2022-02-05 | 3374.99 | 1 | SO44918 | 2022-02-12 | 270.00 | 1898.09 | |
SO55842_2 | 100 | 16382 | 487 | 1 | 2023-12-11 | 1.37 | 2023-11-29 | 54.99 | 2 | SO55842 | 2023-12-06 | 4.40 | 20.57 | |
SO44919_1 | 100 | 29017 | 310 | 1 | 2022-02-17 | 89.46 | 2022-02-05 | 3578.27 | 1 | SO44919 | 2022-02-12 | 286.26 | 2171.29 | |
SO55843_1 | 19 | 19873 | 528 | 6 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55843 | 2023-12-06 | 0.40 | 1.87 | |
SO44920_1 | 100 | 14648 | 338 | 4 | 2022-02-17 | 17.48 | 2022-02-05 | 699.10 | 1 | SO44920 | 2022-02-12 | 55.93 | 413.15 | |
SO55843_2 | 19 | 19873 | 480 | 2 | 6 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 2 | SO55843 | 2023-12-06 | 0.18 | 0.86 |
SO55844_1 | 100 | 14568 | 528 | 1 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55844 | 2023-12-06 | 0.40 | 1.87 | |
SO55844_2 | 100 | 14568 | 478 | 1 | 2023-12-11 | 0.25 | 2023-11-29 | 9.99 | 2 | SO55844 | 2023-12-06 | 0.80 | 3.74 | |
SO55844_3 | 100 | 14568 | 477 | 1 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 3 | SO55844 | 2023-12-06 | 0.40 | 1.87 | |
SO55844_4 | 100 | 14568 | 222 | 1 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 4 | SO55844 | 2023-12-06 | 2.80 | 13.09 | |
SO55845_1 | 98 | 14554 | 475 | 10 | 2023-12-11 | 1.75 | 2023-11-29 | 69.99 | 1 | SO55845 | 2023-12-06 | 5.60 | 26.18 | |
SO55846_1 | 98 | 15057 | 537 | 10 | 2023-12-11 | 0.88 | 2023-11-29 | 35.00 | 1 | SO55846 | 2023-12-06 | 2.80 | 13.09 | |
SO55846_2 | 98 | 15057 | 528 | 10 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 2 | SO55846 | 2023-12-06 | 0.40 | 1.87 | |
SO55846_3 | 98 | 15057 | 217 | 10 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 3 | SO55846 | 2023-12-06 | 2.80 | 13.09 | |
SO55847_1 | 100 | 14961 | 529 | 8 | 2023-12-11 | 0.10 | 2023-11-29 | 3.99 | 1 | SO55847 | 2023-12-06 | 0.32 | 1.49 | |
SO55847_2 | 100 | 14961 | 539 | 8 | 2023-12-11 | 0.62 | 2023-11-29 | 24.99 | 2 | SO55847 | 2023-12-06 | 2.00 | 9.35 | |
SO55847_3 | 100 | 14961 | 480 | 8 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 3 | SO55847 | 2023-12-06 | 0.18 | 0.86 | |
SO55847_4 | 100 | 14961 | 483 | 8 | 2023-12-11 | 3.00 | 2023-11-29 | 120.00 | 4 | SO55847 | 2023-12-06 | 9.60 | 44.88 | |
SO55848_1 | 100 | 12737 | 478 | 7 | 2023-12-11 | 0.25 | 2023-11-29 | 9.99 | 1 | SO55848 | 2023-12-06 | 0.80 | 3.74 | |
SO55848_2 | 100 | 12737 | 222 | 7 | 2023-12-11 | 0.87 | 2023-11-29 | 34.99 | 2 | SO55848 | 2023-12-06 | 2.80 | 13.09 | |
SO55849_1 | 100 | 23910 | 529 | 8 | 2023-12-11 | 0.10 | 2023-11-29 | 3.99 | 1 | SO55849 | 2023-12-06 | 0.32 | 1.49 | |
SO55849_2 | 100 | 23910 | 480 | 8 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 2 | SO55849 | 2023-12-06 | 0.18 | 0.86 | |
SO55850_1 | 98 | 27308 | 529 | 10 | 2023-12-11 | 0.10 | 2023-11-29 | 3.99 | 1 | SO55850 | 2023-12-06 | 0.32 | 1.49 | |
SO55850_2 | 98 | 27308 | 480 | 10 | 2023-12-11 | 0.06 | 2023-11-29 | 2.29 | 2 | SO55850 | 2023-12-06 | 0.18 | 0.86 | |
SO55851_1 | 100 | 22424 | 538 | 7 | 2023-12-11 | 0.54 | 2023-11-29 | 21.49 | 1 | SO55851 | 2023-12-06 | 1.72 | 8.04 | |
SO55851_2 | 100 | 22424 | 490 | 7 | 2023-12-11 | 1.35 | 2023-11-29 | 53.99 | 2 | SO55851 | 2023-12-06 | 4.32 | 41.57 | |
SO55852_1 | 100 | 12728 | 530 | 8 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55852 | 2023-12-06 | 0.40 | 1.87 | |
SO55852_2 | 100 | 12728 | 487 | 8 | 2023-12-11 | 1.37 | 2023-11-29 | 54.99 | 2 | SO55852 | 2023-12-06 | 4.40 | 20.57 | |
SO55853_1 | 100 | 23928 | 530 | 7 | 2023-12-11 | 0.12 | 2023-11-29 | 4.99 | 1 | SO55853 | 2023-12-06 | 0.40 | 1.87 | |
SO55853_2 | 100 | 23928 | 541 | 7 | 2023-12-11 | 0.72 | 2023-11-29 | 28.99 | 2 | SO55853 | 2023-12-06 | 2.32 | 10.84 |
Generated 2024-09-20 13:15:37.209 UTC