PR
PRPayment
Stores the information about the paycheck of a specific employee. The information will be displayed on the Paychecks and Adjustments (PR302000) form. It is the main document in the Payroll functional area.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ApplyOvertimeRules | bit | Apply Overtime Rules for the Document | - | |
Description:No description available | ||||
AverageRateNonexistent in DB | decimal? | Average Rate | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BenefitAmount | decimal | Total Benefits | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CATranID | bigint | - | ||
Description:No description available | ||||
Calculated | bit | Calculated | - | |
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
ChkCreateNew | bit | Create New Payment from Voided Payment | - | |
Description:No description available | ||||
ChkVoidType | char(3) | Void Reason | - | |
Description:No description available | ||||
Closed | bit | Closed | - | |
Description:No description available | ||||
CountryID | char(2) | Payment country | Country | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
DedAmount | decimal | Deductions | - | |
Description:No description available | ||||
DetailLinesCountObsolete | int | Nbr. of Detail Lines | - | |
Description:No description available | ||||
DocDesc | nvarchar(128) | Description | - | |
Description:No description available | ||||
DocType | char(3) | Type | - | |
Description:No description available | ||||
DrCrNonexistent in DB | string | - | ||
Description:Read-only field indicating whether the document is of debit or credit type. The value of this field is based solely on the DocType field. | ||||
EmpType | char(3) | Employee Type | - | |
Description:No description available | ||||
EmployeeID | int | Employee | PREmployee | |
Description:No description available | ||||
EmployerTaxAmount | decimal | Total Employer Tax | - | |
Description:No description available | ||||
EndDate | datetime | Period End | - | |
Description:No description available | ||||
ExemptFromOvertimeRulesNonexistent in DB | bool? | Exempt from Overtime Rules | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(40) | Payment Ref. | - | |
Description:No description available | ||||
FinPeriodID | string | Posting Period | PRPayGroupPeriod | |
Description:No description available | ||||
GrossAmount | decimal | Gross Pay | - | |
Description:No description available | ||||
HasUpdatedGL | bit | - | ||
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:When set to "true" indicates that the document is on hold and thus cannot be released. | ||||
IsPrintChecksPaymentMethodNonexistent in DB | bool? | Print Checks Payment Method | - | |
Description:No description available | ||||
IsRehirable | bit | Eligible for Rehire | - | |
Description:No description available | ||||
IsWeeklyOrBiWeeklyPeriodNonexistent in DB | bool? | Is Weekly or Biweekly Period | - | |
Description:No description available | ||||
LaborCostSplitType | char(3) | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LiabilityPartiallyPaid | bit | Liability Partially Paid | - | |
Description:No description available | ||||
ManualRegularAmount | bit | Manual Amount | - | |
Description:No description available | ||||
NetAmount | decimal | Net Pay | - | |
Description:No description available | ||||
NetAmountToWordsNonexistent in DB | string | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrganizationIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
OrigDocType | char(3) | Original Doc. Type | - | |
Description:Type of the original (source) document. | ||||
OrigRefNbr | nvarchar(15) | Original Document | - | |
Description:Reference number of the original (source) document. | ||||
PTOCostSplitType | char(1) | - | ||
Description:No description available | ||||
Paid | bit | Paid | - | |
Description:No description available | ||||
PayBatchNbr | nvarchar(15) | Pay Batch Nbr. | PRBatch | |
Description:No description available | ||||
PayGroupID | nvarchar(15) | Pay Group | PRPayGroup | |
Description:No description available | ||||
PayPeriodID | string | Pay Period | PRPayGroupPeriod | |
Description:No description available | ||||
PayableBenefitAmount | decimal | - | ||
Description:No description available | ||||
PaymentBatchNbrNonexistent in DB | string | Payment Batch Nbr. | - | |
Description:No description available | ||||
PaymentDocAndRefNonexistent in DB | string | Paycheck Ref | - | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:[key] Reference number of the document. | ||||
RegularAmount | decimal | Regular Amount to Be Paid | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReleasedToVerifyNonexistent in DB | bool? | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShowROETabNonexistent in DB | bool? | - | ||
Description:No description available | ||||
StartDate | datetime | Period Start | - | |
Description:No description available | ||||
Status | char(3) | Status | - | |
Description:No description available | ||||
TaxAmount | decimal | Taxes | - | |
Description:No description available | ||||
TerminationDate | datetime | Termination Date | - | |
Description:No description available | ||||
TerminationReason | char(3) | Termination Reason | - | |
Description:No description available | ||||
TotalEarnings | decimal | - | ||
Description:No description available | ||||
TotalHours | decimal | Total Hours | - | |
Description:No description available | ||||
TransactionDate | datetime | Transaction Date | - | |
Description:No description available | ||||
Voided | bit | Voided | - | |
Description:No description available | ||||