List of Data (.DAT) Files Available in Sage 50 for Crystal Reports, OLEDB, and ODBC
The following is a list of data (.DAT) files that are included in Sage 50. This information is intended to assist those who design reports for Sage 50 using Crystal Reports.
- Click any of the links below to display field information included in each .DAT file.
Note that this field information includes references to "keys" among the listed fields. Key fields are referred to as "indexed fields" in Crystal Reports Online Help. For details about indexed fields and tables and how to use them, look up "indexed tables" in the Crystal Reports Online Help index.
Note: The list below does not constitute a list of each file in your Sage 50 company data directory. It contains the data tables that can be accessed via crystalreports.udl, which were specifically designed for using Crystal Reports with Sage 50.
Address Fields |
|
Audit Trail Fields (Sage 50 Premium Accounting and higher) |
|
Bill of Materials Fields (Sage 50 Quantum Accounting) |
|
Budget Detail Fields |
|
Bank Account ID Fields |
|
Budget Fields |
|
Cash Flow Manager Fields (Sage 50 Premium Accounting and higher) |
|
Chart of Accounts Fields |
|
Change Order Fields (Sage 50 Premium Accounting and higher) |
|
Change Order Detail Fields (Sage 50 Premium Accounting and higher) |
|
Company Fields |
|
Contact fields |
|
Cost Code Fields (Sage 50 Premium Accounting and higher) |
|
Customer Fields |
|
Default Payroll Fields |
|
Employee Earnings Summary Fields |
|
Employee Pay Information Fields |
|
Employee Fields |
|
Employee Custom Payroll Fields |
|
Earnings Summary Payroll Fields |
|
Earnings Summary Wage Fields |
|
Vendor and Accounts Payable Default Information Fields |
|
Customer and Accounts Receivable Default Information Fields |
|
General Ledger Default Information Fields |
|
Inventory Default Information Fields |
|
Job Default Information Fields |
|
Journal Header Fields |
|
Journal Row Fields |
|
Serial Number Fields (Sage 50 Premium Accounting and higher) |
|
Job Estimates Fields |
|
Inventory Item Fields |
|
Notification Additional Message Fields (Sage 50 Quantum Accounting) |
|
Notification Condition Fields (Sage 50 Quantum Accounting) |
|
Notification Fields (Sage 50 Quantum Accounting) |
|
Notification Recipient Fields (Sage 50 Quantum Accounting) |
|
Notification Message Fields (Sage 50 Quantum Accounting) |
|
Notification Rules Fields (Sage 50 Quantum Accounting) |
|
Online Banking Transactions Fields |
|
Phase Fields (Sage 50 Premium Accounting and higher) |
|
Job Fields |
|
Quantity Discount Fields (Sage 50 Quantum Accounting) |
|
Raise History Fields |
|
Performance Review Fields (Sage 50 Premium Accounting and higher) |
|
S1ActMap.DAT | Account Mapping Fields |
S1TaxMap.DAT | Sales Tax Mapping Fields |
Status Code Fields - Job Status fields and Tracking Status fields (Sage 50 Quantum Accounting) |
|
Tracking Status History Fields (Sage 50 Quantum Accounting) |
|
Tracking Status Note Fields (Sage 50 Quantum Accounting) |
|
Sales Tax Authority Fields |
|
Sales Tax Code Fields |
|
Time/Expense Ticket Fields (Sage 50 Premium Accounting and higher) |
|
Unit/Measure Fields (Sage 50 Quantum Accounting) |
|
Vendor Insurance Fields (Sage 50 Quantum Accounting) |
|
Vendor Fields |
|
Work Ticket Fields (Sage 50 Quantum Accounting) |
Note: Not all Sage 50
database information is available or presented in Sage 50 field tables. For example, action items and Sage 50 company user setup (user IDs and passwords) cannot be added to your Crystal reports. You may be able to access data fields that would not be pertinent for your reports (for example, fields used in internal
Sage 50 functions).
Also, some Sage 50 fields (which cannot be described in Sage 50 data [.DAT] files) require custom formulas to extract data for reports.