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