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