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.DAT	Address Fields
AUDITTR.DAT	Audit Trail Fields (Sage 50 Premium Accounting and higher)
BOMHIST.DAT BOMITEMS.DAT	Bill of Materials Fields (Sage 50 Quantum Accounting)
BDETAIL.DAT	Budget Detail Fields
BKACTMAP.DAT	Bank Account ID Fields
BUDGET.DAT	Budget Fields
CASHFLOWMANAGER.DAT	Cash Flow Manager Fields (Sage 50 Premium Accounting and higher)
CHART.DAT	Chart of Accounts Fields
CHGORDER.DAT	Change Order Fields (Sage 50 Premium Accounting and higher)
CODETAIL.DAT	Change Order Detail Fields (Sage 50 Premium Accounting and higher)
COMPANY.DAT	Company Fields
CONTACTS.DAT	Contact fields
COST.DAT	Cost Code Fields (Sage 50 Premium Accounting and higher)
CUSTOMER.DAT	Customer Fields
DEFPRFLD.DAT	Default Payroll Fields
EARNSUMM.DAT	Employee Earnings Summary Fields
EMPAYINF.DAT	Employee Pay Information Fields
EMPLOYEE.DAT	Employee Fields
EMPPRFLD.DAT	Employee Custom Payroll Fields
ESPRFLD.DAT	Earnings Summary Payroll Fields
ESWAGE.DAT	Earnings Summary Wage Fields
GENERAL.DAT_AP	Vendor and Accounts Payable Default Information Fields
GENERAL.DAT_AR	Customer and Accounts Receivable Default Information Fields
GENERAL.DAT_GL	General Ledger Default Information Fields
GENERAL.DAT_INV	Inventory Default Information Fields
GENERAL.DAT_JOBS	Job Default Information Fields
JRNLHDR.DAT	Journal Header Fields
JRNLROW.DAT	Journal Row Fields
JRNLSNO.DAT	Serial Number Fields (Sage 50 Premium Accounting and higher)
JOBEST.DAT	Job Estimates Fields
LINEITEM.DAT	Inventory Item Fields
NOTADMSG.DAT	Notification Additional Message Fields (Sage 50 Quantum Accounting)
NOTCDVAL.DAT	Notification Condition Fields (Sage 50 Quantum Accounting)
NOTIFICA.DAT	Notification Fields (Sage 50 Quantum Accounting)
NOTRECIP.DAT	Notification Recipient Fields (Sage 50 Quantum Accounting)
NOTMSG.DAT	Notification Message Fields (Sage 50 Quantum Accounting)
NOTRULES.DAT	Notification Rules Fields (Sage 50 Quantum Accounting)
OLTRANS.DAT	Online Banking Transactions Fields
PAYTYPES.DAT	Pay type fields
PHASE.DAT	Phase Fields (Sage 50 Premium Accounting and higher)
PROJECT.DAT	Job Fields
QTYDISC.DAT	Quantity Discount Fields (Sage 50 Quantum Accounting)
RAISEHST.DAT	Raise History Fields
REVIEW.DAT	Performance Review Fields (Sage 50 Premium Accounting and higher)
S1ActMap.DAT	Account Mapping Fields
S1TaxMap.DAT	Sales Tax Mapping Fields
STATCODE.DAT	Status Code Fields - Job Status fields and Tracking Status fields (Sage 50 Quantum Accounting)
STATHIST.DAT	Tracking Status History Fields (Sage 50 Quantum Accounting)
STATNOTE.DAT	Tracking Status Note Fields (Sage 50 Quantum Accounting)
TAXAUTH.DAT	Sales Tax Authority Fields
TAXCODE.DAT	Sales Tax Code Fields
TICKET.DAT	Time/Expense Ticket Fields (Sage 50 Premium Accounting and higher)
UNITMEAS.DAT	Unit/Measure Fields (Sage 50 Quantum Accounting)
VENDINS.DAT	Vendor Insurance Fields (Sage 50 Quantum Accounting)
VENDOR.DAT	Vendor Fields
WORKTKT.DAT	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.