Earnings Summary Wage Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: ESWAGE.DAT
ESWAGE.DAT is the earnings summary wage file. It contains the hours and pay for a defined pay type for the 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 ESWAGE.DAT.
Indexes and their uses
The ESWAGE.DAT file has one key, as follows:
0 = ByEarnSummWage_EarnSummGUIDRateNum – Used to retrieve the quarterly pay type information for an employee sorted by rate 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 summary wage record is associated with |
|
|
RateNumber |
Integer |
Identifies the pay type |
|
|
Hours |
Decimal |
The quarterly summary hours for the pay type |
|
|
Pay |
Decimal |
The quarterly summary payfor the pay type |