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