[ROOT] dt FactInternetSale < WHERE DimSalesTerritoryId EQ '8' > < SKIP 2105 > < TAKE 28 >
28 items
FactInternetSaleId | DimCurrencyId | DimCustomerId | DimProductId | DimPromotionId | DimSalesTerritoryId | DueDate | Freight | OrderDate | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO59900_1 | 100 | 12806 | 606 | 8 | 2024-02-14 | 13.50 | 2024-02-02 | 539.99 | 1 | SO59900 | 2024-02-09 | 43.20 | 343.65 | |
SO59904_1 | 100 | 14425 | 355 | 8 | 2024-02-15 | 58.00 | 2024-02-03 | 2319.99 | 1 | SO59904 | 2024-02-10 | 185.60 | 1265.62 | |
SO59904_2 | 100 | 14425 | 477 | 8 | 2024-02-15 | 0.12 | 2024-02-03 | 4.99 | 2 | SO59904 | 2024-02-10 | 0.40 | 1.87 | |
SO59904_3 | 100 | 14425 | 478 | 8 | 2024-02-15 | 0.25 | 2024-02-03 | 9.99 | 3 | SO59904 | 2024-02-10 | 0.80 | 3.74 | |
SO59906_1 | 100 | 14162 | 359 | 8 | 2024-02-15 | 57.37 | 2024-02-03 | 2294.99 | 1 | SO59906 | 2024-02-10 | 183.60 | 1251.98 | |
SO59906_2 | 100 | 14162 | 467 | 8 | 2024-02-15 | 0.61 | 2024-02-03 | 24.49 | 2 | SO59906 | 2024-02-10 | 1.96 | 9.16 | |
SO59906_3 | 100 | 14162 | 485 | 8 | 2024-02-15 | 0.55 | 2024-02-03 | 21.98 | 3 | SO59906 | 2024-02-10 | 1.76 | 8.22 | |
SO54878_1 | 100 | 22473 | 604 | 8 | 2023-11-26 | 13.50 | 2023-11-14 | 539.99 | 1 | SO54878 | 2023-11-21 | 43.20 | 343.65 | |
SO54878_2 | 100 | 22473 | 477 | 8 | 2023-11-26 | 0.12 | 2023-11-14 | 4.99 | 2 | SO54878 | 2023-11-21 | 0.40 | 1.87 | |
SO54878_3 | 100 | 22473 | 479 | 8 | 2023-11-26 | 0.22 | 2023-11-14 | 8.99 | 3 | SO54878 | 2023-11-21 | 0.72 | 3.36 | |
SO54878_4 | 100 | 22473 | 491 | 8 | 2023-11-26 | 1.35 | 2023-11-14 | 53.99 | 4 | SO54878 | 2023-11-21 | 4.32 | 41.57 | |
SO54880_1 | 100 | 15080 | 564 | 14 | 8 | 2023-11-26 | 59.60 | 2023-11-14 | 2384.07 | 1 | SO54880 | 2023-11-21 | 190.73 | 1481.94 |
SO54880_2 | 100 | 15080 | 479 | 8 | 2023-11-26 | 0.22 | 2023-11-14 | 8.99 | 2 | SO54880 | 2023-11-21 | 0.72 | 3.36 | |
SO54880_3 | 100 | 15080 | 477 | 8 | 2023-11-26 | 0.12 | 2023-11-14 | 4.99 | 3 | SO54880 | 2023-11-21 | 0.40 | 1.87 | |
SO54880_4 | 100 | 15080 | 225 | 8 | 2023-11-26 | 0.22 | 2023-11-14 | 8.99 | 4 | SO54880 | 2023-11-21 | 0.72 | 6.92 | |
SO54910_1 | 100 | 15352 | 475 | 8 | 2023-11-27 | 1.75 | 2023-11-15 | 69.99 | 1 | SO54910 | 2023-11-22 | 5.60 | 26.18 | |
SO54917_1 | 100 | 12832 | 530 | 8 | 2023-11-27 | 0.12 | 2023-11-15 | 4.99 | 1 | SO54917 | 2023-11-22 | 0.40 | 1.87 | |
SO54917_2 | 100 | 12832 | 217 | 8 | 2023-11-27 | 0.87 | 2023-11-15 | 34.99 | 2 | SO54917 | 2023-11-22 | 2.80 | 13.09 | |
SO54919_1 | 100 | 12512 | 225 | 8 | 2023-11-27 | 0.22 | 2023-11-15 | 8.99 | 1 | SO54919 | 2023-11-22 | 0.72 | 6.92 | |
SO54940_1 | 100 | 23765 | 376 | 8 | 2023-11-28 | 61.08 | 2023-11-16 | 2443.35 | 1 | SO54940 | 2023-11-23 | 195.47 | 1554.95 | |
SO54940_2 | 100 | 23765 | 479 | 8 | 2023-11-28 | 0.22 | 2023-11-16 | 8.99 | 2 | SO54940 | 2023-11-23 | 0.72 | 3.36 | |
SO54940_3 | 100 | 23765 | 477 | 8 | 2023-11-28 | 0.12 | 2023-11-16 | 4.99 | 3 | SO54940 | 2023-11-23 | 0.40 | 1.87 | |
SO54940_4 | 100 | 23765 | 490 | 8 | 2023-11-28 | 1.35 | 2023-11-16 | 53.99 | 4 | SO54940 | 2023-11-23 | 4.32 | 41.57 | |
SO54940_5 | 100 | 23765 | 467 | 8 | 2023-11-28 | 0.61 | 2023-11-16 | 24.49 | 5 | SO54940 | 2023-11-23 | 1.96 | 9.16 | |
SO54941_1 | 100 | 11598 | 353 | 8 | 2023-11-28 | 58.00 | 2023-11-16 | 2319.99 | 1 | SO54941 | 2023-11-23 | 185.60 | 1265.62 | |
SO54941_2 | 100 | 11598 | 537 | 8 | 2023-11-28 | 0.88 | 2023-11-16 | 35.00 | 2 | SO54941 | 2023-11-23 | 2.80 | 13.09 | |
SO54941_3 | 100 | 11598 | 480 | 8 | 2023-11-28 | 0.06 | 2023-11-16 | 2.29 | 3 | SO54941 | 2023-11-23 | 0.18 | 0.86 | |
SO54941_4 | 100 | 11598 | 483 | 8 | 2023-11-28 | 3.00 | 2023-11-16 | 120.00 | 4 | SO54941 | 2023-11-23 | 9.60 | 44.88 |
Generated 2024-09-21 14:05:44.519 UTC