Default Payroll Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: DEFPRFLD.DAT

DEFPRFLD.DAT is the default payroll field file. It contains the default payroll fields from the Employee Fields tab and the Company Fields tab in Maintain Employee Defaults.

To add Sage 50 employee fields to your Crystal reports, select DEFPRFLD.DAT.

Indexes and their uses

The DEFPRFLD.DAT file has two keys, as follows:

0 = ByPayrollField_FieldNumber – Unique primary key.

1 = ByPayrollField_GUID

Field Name	Type	Size	Comment
Module	Ubinary
FieldNumber	Integer		Identifies the field 1-40 = Employee fields 41-80 = Company fields
DefPayrollFieldGUID	Ubinary		GUID (Globally Unique Identifier) used for linking the Default Payroll Fields table.
LastUpdateCounter	Integer		This is a counter that increases incrementally each time a record is modified.
Description	Zstring		Name of the payroll field
Memo	Unsigned Integer		True if this field is a Memo field, 1=True
AccountRecordNumber	Integer		This is the withholding liability GL account.
Calculateable	Unsigned Integer		True if this field is calculated, 1=True
CalculationName	Zstring	30	Payroll tax calculation name that applies to this field if it is calculated.
DefaultAmount	Decimal		Default deduction amount if field is not calculated.
FieldsForGross	Binary		Fields that are included in the calculation of gross pay when this field is calculated
Employer	Unsigned Integer		True if this is a company field, 1=True
RunningBalance	Unsigned Integer		True if this field has a running balance, 1=True
ContraAccountRecordNumber	Integer		This is the expense GL account if the field is a Company field (41-80).
Category	Integer		Payroll field category used to identify the type of field
Subcategory	Integer		Payroll field subcategory used to identify the type of field
Sequence	Integer		Order this field appeared in the payroll wizard
Status	Integer		This is the status of the payroll field: Available - field is free to use Assigned - field has been assigned by the Payroll Wizard, but hasn't been used Used - field has been used
RelatedField	Integer		Field number of related payroll field if there is one