Employee Custom Payroll Fields

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

Filename: EMPPRFLD.DAT

EMPPRFLD.DAT is the file that contains payroll fields that have been customized for an employee. This information comes from the grid on the EmployEE Fields tab and the Company Fields tab in Maintain Employees. These are fields that are different from the defaults.

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

Indexes and their uses

The EMPPRFLD.DAT file has four keys, as follows:

0 = ByEmpPRFld_RecordNumber – Unique and doesn’t change. Usually used to link to other tables.

1 = ByEmpPRFld_GUID

2 = ByEmpPRFld_EmpRecNum – Identifies the employee associated with this payroll field customization

3 = ByEmpPRFld_EmpRecNum_FldNum – Used to retrieve payroll field customizations for an employee sorted by field number

Field Name	Type	Size	Comment
RecordNumber	Integer		Used as a table-linking field.
GUID	Ubinary		GUID (Globally Unique Identifier) used for linking the Employee Payroll Fields table.
LastUpdateCounter	Integer		This is a counter that increases incrementally each time a record is modified.
EmployeeRecordNumber	Integer		Identifies the employee.
FieldNumber	Integer		Identifies the field 1-40 = Employee fields 41-80 = Company fields
UseCustom	Logical		Should always be 1
AccountRecordNumber	Integer		This is the withholding liability GL account.
Calculateable	Logical		True = field is calculated
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	UBinary		Fields that are included in the calculation of gross pay when this field is calculated
ContraAccountRecordNumber	Integer		This is the expense GL account if the field is a Company field (41-80).