Employee Pay Information Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: EMPAYINF.DAT
EMPAYINF.DAT is the employee pay information file. It contains the pay rates for an employee. This information comes from the grid on the Pay Info tab in Maintain Employees.
- To add Sage 50 employee fields to your Crystal reports, select EMPAYINF.DAT.
Indexes and their uses
The EMPAYINF.DAT file has four keys, as follows:
0 = ByEmpPayInfo_RecordNumber – Unique and doesn’t change. Usually used to link to other tables.
1 = ByEmpPayInfo_GUID
2 = ByEmpPayInfo_EmpRecNum – Identifies the employee associated with this pay rate
3 = ByEmpPayInfo_EmpRecNum_RateNum – Used to retrieve pay rates for an employee sorted by rate 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 Pay Info table. |
|
|
LastUpdateCounter |
Integer |
This is a counter that increases incrementally each time a record is modified. |
|
|
EmployeeRecordNumber |
Integer |
Identifies the employee. |
|
|
RateNumber |
Integer |
Identifies the pay type |
|
|
UseDefault |
Logical |
1 = checkbox is checked |
|
|
AccountRecordNumber |
Integer |
If UseDefault = 1, this is the GL account to use to record the employee's gross pay for this pay type (RateNumber). |
|
|
PayRate |
Decimal |
This is the pay rate for this employee for this pay type (RateNumber). |