Payroll Special Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: PRSFLDS.DAT
The PRSFLDS.DAT file contains a record (row) for all special fields pointing to each employee record.
- To add Sage 50 payroll special fields to your Crystal reports, select PRSFLDS.DAT.
Indexes and their uses
The PRSFLDS.DAT file has the following indexes:
0 = ByRecordNumber
1 = ByEmpPRSpecFld
2 = ByEmployeeGUID
Fields
The following table shows the fields available in the PRSFLDS.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
| RecordNumber | Long | Used as a table linking field | |
| PRSpecialFieldNum | Integer | The number associated with the special field seen on the Withholding Info tab of the Maintain Employee window | |
| Allowances | Integer | The number of allowances: 99 Exempt 401k payroll | |
| AddlWithholding | Decimal | Extra money to withhold | |
| EmployeeGUID | GUID | GUID(Globally Unique Identifier) used for linking the Employee table | |
| LastUpdateCounter | Integer | This increases incrementally when the employee record is changed |