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
1-40 = Employee fields
41-80 = Company fields

Amount

Decimal

The quarterly summary amount for the payroll field