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