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).