Purchase Orders with Requisitions

The data model combines purchase order line unit cost, extended amount, sales tax amount per line, total transaction amount, and total transaction amount in the home currency for analysis and tracking of purchase orders, requisitions, open and closed orders, historical requisition data, individual purchase order items, requisition details, and vendor performance evaluation.

Benefits of This Data Model

• Improved Purchase Order Analysis: Gain deep insights into purchase orders and requisitions, allowing for detailed analysis and tracking of procurement activities.
• Enhanced Vendor Evaluation: Evaluate vendor performance effectively by leveraging purchase order data and delivery times for better decision-making.
• Historical Requisition Tracking: Track and analyze historical requisition data to identify trends and patterns in past requests.
• Detailed Purchase Order Item Breakdown: Break down purchase orders into individual items for a granular level of analysis and understanding of procurement transactions.
• Efficient Management of Open and Closed Orders: Efficiently manage open purchase orders and track all completed and closed purchase orders for better control over procurement processes.

Key Performance Indicators (KPIs)

• Purchase Order Line Unit Cost: The unit cost of items on each purchase order line.
• Purchase Order Line Ext Amt: The extended amount (quantity * unit cost) for each purchase order line.
• Purchase Order Line S Tax Amt: The sales tax amount for each purchase order line.
• Purchase Order Header TranAmt: The total transaction amount for the purchase order header.
• Purchase Order Header TranAmtHC: The total transaction amount in the home currency for the purchase order header.

Available Visualizations

View Name	Description
Purchase Orders with Requisitions	Combines purchase orders and requisitions data for analysis and tracking.
Open Purchase Orders	Lists all purchase orders that are currently open and pending.
Closed Purchase Orders	Provides a record of all completed and closed purchase orders.
Requisition History	Tracks historical data of requisitions, providing insights into past requests.
Purchase Order Items	Breaks down purchase orders into individual items for detailed analysis.
Requisition Details	Offers a detailed view of requisition requests, including quantity, cost, and status.
Vendor Performance	Evaluates vendor performance based on purchase order data and delivery times.