Skip to main content

Acumatica Data Models

When you install the Acumatica template, a set of predefined data models is included to help you start analyzing your data immediately. Each data model contains ready-to-use views that present information in specific business areas such as finance, sales orders, projects, and inventory. Use these models and views as they are, or customize them to match your organization’s reporting needs.

Data ModelView
Finance- Transaction journal
- Financial statements
Sales Orders- Sales Invoices
- Sales Orders
- Shipments
Project- Project Transactions
- Project Budget
- Employee Hours
- Project Tasks
- Project Budget Unpivoted
Account Receivable- Account Receivable Registry
- AR Aging Historical
Account Payable- Account Payable Registry
- AP Aging Historical
Fixed Asset- Fixed Asset Transactions
Purchases- Requests
- Requisitions
- Purchase Order
- Purchase Receipts
Inventory- Inventory Registry
- Inventory Balance
- Inventory Valuation
Marketing- Leads and Contacts
- Opportunities
- Opportunity Tasks
Services- Service Orders
- Appointment
Time and Expenses- Tasks, Email and Activity
Configuration- Info Page to Refresh Attribute Views
OLAP Cubes- CUBE Sale Analysis