PR
PRBenefitDetailOrig
No summary is documented for this DAC in the release source.
| 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. | ||||
Amount | decimal | Amount | - | |
Description:The benefit 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 benefit. The field is included in FK.Branch. | ||||
CodeID | int | Code | PRDeductCode | |
Description:The benefit code. The field is included in FK.DeductionCode and FK.PaymentBenefit. | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:The unique identifier of the WCC code applied (if any). The field is included in FK.CostCode. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
EarningTypeCD | nvarchar(15) | Earning Type Code | EPEarningType | |
Description:The user-friendly unique identifier of the earning type. The field is included in FK.EarningType. | ||||
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. | ||||
ExpenseAccountID | int | Expense Account | Account | |
Description:The expense account associated with the benefit code. The field is included in FK.ExpenseAccount. | ||||
ExpenseSubID | int | Expense Sub. | Sub | |
Description:The corresponding subaccount used with the expense account. The field is included in FK.ExpenseSubaccount. | ||||
IsPayableBenefitNonexistent in DB | bool? | - | ||
Description:A boolean value that specifies (if set to true) that the benefit may contribute to gross calculation. | ||||
LabourItemID | int | Labor Item | InventoryItem | |
Description:The unique identifier of the labor item (if any). The field is included in FK.LaborItem. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LiabilityAccountID | int | Liability Account | Account | |
Description:The liability account associated with the benefit code. The field is included in FK.LiabilityAccount. | ||||
LiabilityPaid | bit | Liability Paid | - | |
Description:A boolean value that specifies (if set to true) that the benefit has been paid. | ||||
LiabilitySubID | int | Liability Sub. | Sub | |
Description:The corresponding subaccount used with the liability account. The field is included in FK.LiabilitySubaccount. | ||||
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.PaymentBenefit. 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.PaymentBenefit. | ||||
ProjectID | int | Project | PMProject | |
Description:The unique identifier of the associated project (if any). The field is included in FK.Project. | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:The unique identifier of the associated project task (if any). The field is included in FK.ProjectTask. | ||||
RecordID | int | - | ||
Description:The unique identifier of the benefit 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. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||