The Sage 50 U.S. Edition database schema is a proprietary, flat-file relational model optimized for legacy compatibility and small business operations. It is accessible through DataSoft’s suite of tools, including the Sage 50 REST Server, and other DataSoft Utilities, or via direct ODBC integration. Designed to support accounting, inventory, and operational workflows, the schema favors denormalized structures for performance and simplicity. DataSoft’s solutions abstract the quirks of this schema, offering developers and integrators a modern, schema-adaptive interface for querying, documentation, and automation, without sacrificing control or transparency.
Database Engine
Sage 50 U.S. Edition (formerly Peachtree) uses a Pervasive PSQL (Actian Zen) engine under the hood. It’s a file-based, embedded RDBMS optimized for small workloads.
Schema Characteristics:
- Flat and denormalized: Many tables contain redundant data for performance and legacy compatibility.
- No enforced foreign keys: Relationships are implied via fields like
PostOrder, CustomerRecordNumber, ItemRecordNumber. Most Keys contain RecordNumber - No enforced constraints or triggers
- Schema may vary slightly between versions and installations
Articles
- Address Table
- Alarms Table
- Alerts Table
- ArchivedBudgetSumm Table
- ArchivedChartSumm Table
- ArchivedPeriodInfo Table
- Audit_Trail Table
- AutoFillLocation Table
- BOMHist Table
- BOMItems Table
- Budgets Table
- ChangeOrder Table
- ChangeOrderDetail Table
- Chart Table
- Company Table
- CompanySession Table
- Contacts Table
- CostCode Table
- Customers Table