PR
PRPaymentEarning
Stores the information about the earnings related to a paycheck. The information will be displayed on the Paychecks and Adjustments (PR302000) form.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Amount | decimal | Ext Amount | - | |
Description:The rate for the current earning type code (TypeCD). | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DocType | char(3) | Payment Doc. Type | PRPayment | |
Description:The type of the payment. The field is included in FK.Payment. The value of this field corresponds to the value of the PRPayment.DocType field. | ||||
Hours | decimal | Hours | - | |
Description:The number of earned hours for the current earning type code (TypeCD). | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LocationID | int | Location | PRLocation | |
Description:The unique identifier of the work location. The field is included in FK.Location. The value of this field corresponds to the value of the PRLocation.LocationID field. | ||||
MTDAmount | decimal | MTD Amount | - | |
Description:The month-to-date amount earned for the current earning type code (TypeCD). | ||||
QTDAmount | decimal | QTD Amount | - | |
Description:The quarter-to-date amount earned for the current earning type code (TypeCD). | ||||
Rate | decimal | Rate | - | |
Description:The rate to be multiplied by the units (or pieces, depending on the selected unit type) and any additional factors to determine the gross pay. | ||||
RefNbr | nvarchar(15) | Payment Ref. Number | PRPayment | |
Description:The unique identifier of the payment. The field is included in FK.Payment. The value of this field corresponds to the value of the PRPayment.RefNbr field. | ||||
RoundedHoursNonexistent in DB | decimal? | Hours | - | |
Description:The number of earned hours for the current earning type code (TypeCD) rounded to two digits. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
TypeCD | nvarchar(15) | Code | EPEarningType | |
Description:The user-friendly unique identifier of the earning type code. The field is included in FK.EarningType. The value of this field corresponds to the value of the EPEarningType.TypeCD field. | ||||
YTDAmount | decimal | YTD Amount | - | |
Description:The year-to-date amount earned for the current earning type code (TypeCD). | ||||