PR
PRDeductionDetail
The child record belonging to a PRPayment and representing a deduction code applied to it.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
APInvoiceDocType | char(3) | Type | - | |
Description:The type of the parent invoice (if any). The field is included in FK.Invoice. The field can have one of the values described in APMigrationModeDependentActionRestrictionAttribute. | ||||
APInvoiceRefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:The reference number of the parent invoice (if any). The field is included in FK.Payment. | ||||
AccountID | int | Liability Account | Account | |
Description:The liability account associated with the deduction code. The field is included in FK.LiabilityAccount. | ||||
Amount | decimal | Amount | - | |
Description:The deduction amount. | ||||
BatchNbr | nvarchar(15) | Batch Number | PRBatch | |
Description:The number of the batch (if any) to which the detail's parent payment belongs. The field is included in FK.PayrollBatch. | ||||
BranchID | int | Branch | Branch | |
Description:The branch linked to the deduction. The field is included in FK.Branch. | ||||
CodeID | int | Code | PRDeductCode | |
Description:The deduction code. The field is included in FK.DeductionCode and FK.PaymentDeduction. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
EmployeeID | int | Employee | PREmployee | |
Description:The unique identifier of the employee to which the detail record is attached. The field is included in FK.Employee. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LiabilityPaid | bit | Liability Paid | - | |
Description:A boolean value that specifies (if set to true) that the deduction has been paid. | ||||
OriginalRecordID | int | - | ||
Description:No description available | ||||
PaymentCountryIDNonexistent in DB | string | - | ||
Description:No description available | ||||
PaymentDocType | char(3) | Payment Doc. Type | PRPayment | |
Description:The type of the parent paycheck. The field is included in FK.Payment and FK.PaymentDeduction. The field can have one of the values described in PayrollType.ListAttribute. | ||||
PaymentRefNbr | nvarchar(15) | Payment Ref. Number | PRPayment | |
Description:The reference number of the parent paycheck. The field is included in FK.Payment and FK.PaymentDeduction. | ||||
RecordID | int | - | ||
Description:The unique identifier of the deduction detail record. | ||||
Released | bit | Released | - | |
Description:A boolean value that specifies (if set to true) that the parent payment's status is set to PaymentStatus.Released. | ||||
SubID | int | Liability Sub. | Sub | |
Description:The corresponding subaccount used with the liability account. The field is included in FK.LiabilitySubaccount. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||