IC Historical Transactions
The data model includes views such as Quantity by Location, Stock Transfers by Product, Component Usage by Location, Transactions by Type, and Transactions by Location, presenting insights on inventory levels, stock movements, component usage trends, transaction types, and transaction locations. Measures like Home Currency Cost, Reporting Currency Cost, Source Currency Extended Cost, and Reporting Currency Extended Cost provide detailed transaction cost analysis in various currencies.
Benefits of This Data Model
- Improved Inventory Management: Gain insights into inventory levels at different locations for better stock control and optimization.
- Enhanced Cost Analysis: Detailed transaction cost analysis in various currencies enables better financial decision-making.
- Deeper Component Usage Insights: Analyze component usage trends across different locations for effective resource allocation.
- Transaction Type Breakdown: Understand the distribution of transactions based on their types for improved transaction analysis.
Key Performance Indicators (KPIs)
- Quantity: The number of units of a product that were transacted in a given historical transaction.
- Home Currency Cost: The total cost of the transaction in the home currency (local currency) at the time of the transaction.
- Reporting Currency Cost: The total cost of the transaction in the reporting currency (e.g., USD) based on the exchange rate at the time of the transaction.
- Source Currency Extended Cost: The extended cost in the source currency, which is the unit cost multiplied by the quantity of the product in the original currency.
- Reporting Currency Extended Cost: The extended cost in the reporting currency by converting the source currency extended cost using the exchange rate at the time of the transaction.
Available Visualizations
| View Name | Description |
|---|---|
| Quantity by Location | Provides insights on inventory levels across different locations. |
| Stock Tranfers by Product | Tracks movement of stock between different products. |
| Component Usage by Location | Analyzes component usage trends at various locations. |
| Transactions by Type | Breakdown of transactions based on their types. |
| Transactions by Location | Displays transactions categorized by their respective locations. |
| Transactions by Location Chart | Visual representation of transactions distributed by location. |
| Transactions by Location Radar | Offers a radar chart view of transactions across different locations. |