Pay Types Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: PayTypes.DAT
The PayTypes.DAT file contains information related to the payroll pay types. This is a company-specific table.
- To add Sage 50 pay types fields to your Crystal reports, select PayTypes.DAT.
Indexes and Their Uses
The PayTypes.DAT file has the following indexes:
1 = By RecordNumber
2 = By WageType, then by RateNumber
3 = By WageType, then by RateOrderNumber
Fields
The following table shows the fields available in the PayTypes.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
RecordNumber |
Integer |
|
Primary key. |
|
Name |
ZString |
15 |
The name of the pay type (Ex: Hourly, Salary, Commission, Bonus, Overtime, etc.) |
|
AccountRecordNumber |
Integer |
|
The record number of the default GL account for this type |
|
WageType |
Integer |
|
Number representing the wage type for this pay type. 0 for Salary and 1 for Hourly. |
|
RateNumber |
Integer |
|
Identifier for the pay type (0 based). This should be unique for the WageType |
|
RateOrderNumber |
Integer |
|
Number to determine which order the pay type should display on a pay check (0 based). This should be unique for the WageType |