Earnings Summary Payroll Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: ESPRFLD.DAT
ESPRFLD.DAT is the earnings summary payroll field file. It contains the earnings for a payroll field by quarter. This information is useful for generating W2s and quarterly payroll tax return information.
- To add Sage 50 employee fields to your Crystal reports, select ESPRFLD.DAT.
Indexes and their uses
The ESPRFLD.DAT file has one key, as follows:
0 = ByEarnSummGUIDFieldNumber – Used to retrieve the quarterly payroll field information for an employee sorted by field number
Field Name |
Type |
Size |
Comment |
---|---|---|---|
LastUpdateCounter |
Integer |
This is a counter that increases incrementally each time a record is modified. |
|
EarningSummaryGUID |
Ubinary |
The quarter this payroll field summary record is associated with |
|
FieldNumber |
Integer |
Identifies the payroll field |
|
Amount |
Decimal |
The quarterly summary amount for the payroll field |