PR
PRPaymentEarningAggregatedByCode
Projection for PRPaymentEarning with a grouping by Earning Type Code regardless of LocationID. This DAC is needed for reports.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Amount | decimal | Ext Amount | - | |
Description:The rate for the current earning type code (TypeCD). | ||||
DocType | char(3) | Payment Doc. Type | - | |
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). | ||||
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). | ||||
RefNbr | nvarchar(15) | Payment Ref. Number | - | |
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. | ||||
RoundedHours | decimal | Hours | - | |
Description:The number of earned hours for the current earning type code (TypeCD) rounded to two digits. | ||||
TypeCD | nvarchar(15) | Code | - | |
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). | ||||