PR
PREmployee
PX.Objects.PR173 of 173 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Employee ID | - | |
Description:No description available | ||||
AcctName | nvarchar(255) | Employee Name | - | |
Description:No description available | ||||
AcctReferenceNbr | nvarchar(50) | Employee Ref. No. | - | |
Description:No description available | ||||
ActiveInPayroll | bit | Active | - | |
Description:No description available | ||||
ActivePositionID | nvarchar(10) | Position | EPPosition | |
Description:No description available | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
AutoGenerateTaxBill | bit | Automatically Generate Tax Bill | - | |
Description:No description available | ||||
BAccountClassID | nvarchar(10) | Business Account Class | - | |
Description:No description available | ||||
BAccountID | int | Business Account ID | Vendor | |
Description:No description available | ||||
BaseCuryID | nvarchar(5) | Base Currency ID | - | |
Description:No description available | ||||
BaseRemitContactID | int | Default Contact | - | |
Description:No description available | ||||
BatchIDNonexistent in DB | nvarchar(MAX) | Batch ID | - | |
Description:No description available | ||||
BenefitExpenseAcctID | int | Benefit Expense Account | Account | |
Description:No description available | ||||
BenefitExpenseSubID | int | Benefit Expense Sub. | Sub | |
Description:No description available | ||||
BenefitLiabilityAcctID | int | Benefit Liability Account | Account | |
Description:No description available | ||||
BenefitLiabilitySubID | int | Benefit Liability Sub. | Sub | |
Description:No description available | ||||
Box1099 | smallint | 1099 Box | - | |
Description:No description available | ||||
CalendarID | nvarchar(10) | Calendar | - | |
Description:No description available | ||||
CalendarIDUseDflt | bit | Use Default | - | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | - | |
Description:No description available | ||||
CasesCountNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
CashAccountID | int | Cash Account | CashAccount | |
Description:No description available | ||||
ClassIDObsolete | nvarchar(10) | Class ID | - | |
Description:No description available | ||||
ConsolidateToParent | bit | Consolidate Balance | - | |
Description:No description available | ||||
ConsolidatingBAccountID | int | - | ||
Description:No description available | ||||
COrgBAccountID | int | Customer Restriction Group | - | |
Description:No description available | ||||
CountNonexistent in DBObsolete | int | Count | - | |
Description:No description available | ||||
CountryID | nchar(2) | PREmployeeClass | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | - | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | - | |
Description:No description available | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type | - | |
Description:No description available | ||||
DedLiabilityAcctID | int | Deduction Liability Account | Account | |
Description:No description available | ||||
DedLiabilitySubID | int | Deduction Liability Sub. | Sub | |
Description:No description available | ||||
DedSplitType | char(3) | Split Method | - | |
Description:No description available | ||||
DefAddressID | int | Default Address | - | |
Description:No description available | ||||
DefaultUOM | nvarchar(10) | Default UOM | - | |
Description:No description available | ||||
DefaultWorkgroupID | int | Default Workgroup | - | |
Description:No description available | ||||
DefContactID | int | Default Contact | - | |
Description:No description available | ||||
DefLocationID | int | Default Location | - | |
Description:No description available | ||||
DefPOAddressID | int | - | ||
Description:No description available | ||||
DepartmentID | nvarchar(10) | Department | - | |
Description:No description available | ||||
DiscTakenAcctID | int | Cash Discount Account | - | |
Description:No description available | ||||
DiscTakenSubID | int | Cash Discount Sub. | - | |
Description:No description available | ||||
DocTypeNonexistent in DB | nchar(1) | Document Type | - | |
Description:No description available | ||||
EarningsAcctID | int | Earnings Account | Account | |
Description:No description available | ||||
EarningsSubID | int | Earnings Sub. | Sub | |
Description:No description available | ||||
EmployeeClassID | nvarchar(10) | Class ID | PREmployeeClass | |
Description:No description available | ||||
EmpType | char(3) | Employee Type | - | |
Description:No description available | ||||
EmpTypeUseDflt | bit | Use Default | - | |
Description:No description available | ||||
ExemptFromCertifiedReporting | bit | Exempt from Certified Reporting | - | |
Description:No description available | ||||
ExemptFromCertifiedReportingUseDflt | bit | Use Default | - | |
Description:No description available | ||||
ExemptFromOvertimeRules | bit | Exempt from Overtime Rules | - | |
Description:No description available | ||||
ExemptFromOvertimeRulesUseDflt | bit | Use Default | - | |
Description:No description available | ||||
ExpenseAcctID | int | Expense Account | - | |
Description:No description available | ||||
ExpenseSubID | int | Expense Sub. | - | |
Description:No description available | ||||
FATCA | bit | FATCA | - | |
Description:No description available | ||||
ForeignEntity | bit | Foreign Entity | - | |
Description:No description available | ||||
GrnMaxPctNet | decimal(19, 6) | Maximum Percent of Net Pay for All Garnishments | - | |
Description:No description available | ||||
GrnMaxPctUseDflt | bit | Use Default | - | |
Description:No description available | ||||
GroupMask | varbinary(32) | - | ||
Description:No description available | ||||
HasDiscrepanciesNonexistent in DB | bit | Has Discrepancies | - | |
Description:No description available | ||||
HoursPerWeekNonexistent in DB | decimal | Working Hours per Week | - | |
Description:No description available | ||||
HoursPerYear | decimal(19, 6) | Working Hours per Year | - | |
Description:No description available | ||||
HoursPerYearForCertified | int | Certified Project Hours per Year | - | |
Description:No description available | ||||
HoursPerYearForCertifiedUseDflt | bit | Use Default | - | |
Description:No description available | ||||
HoursValidation | char(1) | Regular Hours Validation | - | |
Description:No description available | ||||
IgnoreConfiguredDiscounts | bit | Ignore Configured Discounts When Vendor Price Is Defined | - | |
Description:No description available | ||||
IncludedNonexistent in DB | bit | Included | - | |
Description:No description available | ||||
IsBranch | bit | - | ||
Description:No description available | ||||
IsCustomerOrCombined | bit | - | ||
Description:No description available | ||||
LabourItemID | int | Labor Item | - | |
Description:No description available | ||||
LandedCostVendor | bit | Landed Cost Vendor | - | |
Description:No description available | ||||
LastActivityNonexistent in DBObsolete | datetime | Last Activity | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LegalName | nvarchar(255) | Legal Name | - | |
Description:No description available | ||||
LineCntr | int | - | ||
Description:No description available | ||||
LineDiscountTarget | char(1) | Apply Line Discounts to | - | |
Description:No description available | ||||
LocaleName | nvarchar(10) | Language/Locale | - | |
Description:No description available | ||||
LocationUseDflt | bit | Use Class Default Work Locations | - | |
Description:No description available | ||||
NetPayMin | decimal(19, 6) | Net Pay Minimum | - | |
Description:No description available | ||||
NetPayMinUseDflt | bit | Use Default | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideHoursPerYearForCertified | bit | Override Hours per Year for Certified Project | - | |
Description:No description available | ||||
OverrideHoursPerYearForCertifiedUseDflt | bit | Use Default | - | |
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | - | |
Description:No description available | ||||
ParentBAccountID | int | Branch | - | |
Description:No description available | ||||
PayGroupID | nvarchar(15) | Pay Group | PRPayGroup | |
Description:No description available | ||||
PayGroupNameNonexistent in DB | nvarchar(MAX) | Pay Group | - | |
Description:No description available | ||||
PayGroupUseDflt | bit | Use Default | - | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | PaymentMethod | |
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PayrollTaxExpenseAcctID | int | Tax Expense Account | Account | |
Description:No description available | ||||
PayrollTaxExpenseSubID | int | Tax Expense Sub. | Sub | |
Description:No description available | ||||
PayrollTaxLiabilityAcctID | int | Tax Liability Account | Account | |
Description:No description available | ||||
PayrollTaxLiabilitySubID | int | Tax Liability Sub. | Sub | |
Description:No description available | ||||
PayToVendorID | int | Pay-to Vendor | - | |
Description:No description available | ||||
POAccrualAcctID | int | PO Accrual Account | - | |
Description:No description available | ||||
POAccrualSubID | int | PO Accrual Sub. | - | |
Description:No description available | ||||
PositionLineCntr | int | - | ||
Description:No description available | ||||
PrebookAcctID | int | Reclassification Account | - | |
Description:No description available | ||||
PrebookSubID | int | Reclassification Subaccount | - | |
Description:No description available | ||||
PrepaymentAcctID | int | Prepayment Account | - | |
Description:No description available | ||||
PrepaymentSubID | int | Prepayment Sub. | - | |
Description:No description available | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PriceListCuryID | nvarchar(5) | Currency ID | - | |
Description:No description available | ||||
PrimaryContactID | int | Primary Contact | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
PTOAssetAcctID | int | PTO Asset Account | Account | |
Description:No description available | ||||
PTOAssetSubID | int | PTO Asset Sub. | Sub | |
Description:No description available | ||||
PTOExpenseAcctID | int | PTO Expense Account | Account | |
Description:No description available | ||||
PTOExpenseSubID | int | PTO Expense Sub. | Sub | |
Description:No description available | ||||
PTOLiabilityAcctID | int | PTO Liability Account | Account | |
Description:No description available | ||||
PTOLiabilitySubID | int | PTO Liability Sub. | Sub | |
Description:No description available | ||||
PublishedFromNonexistent in DB | nvarchar | Published From | - | |
Description:No description available | ||||
PurchTaxAcctID | int | Tax Claimable Account | - | |
Description:No description available | ||||
PurchTaxSubID | int | Tax Claimable Sub. | - | |
Description:No description available | ||||
ReceiptAndClaimTaxZoneID | nvarchar(10) | - | ||
Description:No description available | ||||
RegisteredEntityForReporting | bit | Registered Entity for Government Payroll Reporting | - | |
Description:No description available | ||||
RetainageApply | bit | Apply Retainage | - | |
Description:No description available | ||||
RetainagePct | decimal(9, 6) | Retainage Percent | - | |
Description:No description available | ||||
RouteEmails | bit | Route Emails | - | |
Description:No description available | ||||
SalesAcctID | int | Sales Account | - | |
Description:No description available | ||||
SalesPersonID | int | Salesperson | - | |
Description:No description available | ||||
SalesSubID | int | Sales Sub. | - | |
Description:No description available | ||||
SalesTaxAcctID | int | Tax Payable Account | - | |
Description:No description available | ||||
SalesTaxSubID | int | Tax Payable Sub. | - | |
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | - | |
Description:No description available | ||||
Status | char(1) | Customer Status | - | |
Description:No description available | ||||
StdWeeksPerYear | tinyint | Working Weeks per Year | - | |
Description:No description available | ||||
StdWeeksPerYearUseDflt | bit | Use Default | - | |
Description:No description available | ||||
SupervisorID | int | Reports to | - | |
Description:No description available | ||||
SVATInputTaxEntryRefNbr | char(1) | Input Tax Entry Ref. Nbr. | - | |
Description:No description available | ||||
SVATOutputTaxEntryRefNbr | char(1) | Output Tax Entry Ref. Nbr. | - | |
Description:No description available | ||||
SVATReversalMethod | char(1) | VAT Recognition Method | - | |
Description:No description available | ||||
SVATTaxInvoiceNumberingID | nvarchar(10) | Tax Invoice Numbering | - | |
Description:No description available | ||||
TaxAgency | bit | Vendor Is Tax Agency | - | |
Description:No description available | ||||
TaxExpenseAcctID | int | Tax Expense Account | - | |
Description:No description available | ||||
TaxExpenseSubID | int | Tax Expense Sub. | - | |
Description:No description available | ||||
TaxPeriodType | char(1) | Default Tax Period Type | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TaxReportFinPeriod | bit | Define Tax Period by End Date of Financial Period | - | |
Description:No description available | ||||
TaxReportPrecision | smallint | Tax Report Precision | - | |
Description:No description available | ||||
TaxReportRounding | char(1) | Tax Report Rounding | - | |
Description:No description available | ||||
TaxUseVendorCurPrecision | bit | Use Currency Precision | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | - | |
Description:No description available | ||||
TimeCardRequired | bit | Time Card Is Required | - | |
Description:No description available | ||||
TinType | char(1) | Type of TIN | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:No description available | ||||
UnionID | nvarchar(15) | Default Union | - | |
Description:No description available | ||||
UnionUseDflt | bit | Use Default | - | |
Description:No description available | ||||
UpdClosedTaxPeriods | bit | Update Closed Tax Periods | - | |
Description:No description available | ||||
UseCustomSettings | bit | Use Custom Settings | - | |
Description:No description available | ||||
UsePayrollProjectWorkLocation | bit | Use Payroll Work Location from Project | - | |
Description:No description available | ||||
UsePayrollProjectWorkLocationUseDflt | bit | Use Class Default Value | - | |
Description:No description available | ||||
UserID | uniqueidentifier | Employee Login | - | |
Description:No description available | ||||
Vendor1099 | bit | 1099 Vendor | - | |
Description:No description available | ||||
VendorClassID | nvarchar(10) | Employee Class | - | |
Description:No description available | ||||
ViewInCrmNonexistent in DB | bit | View In CRM | - | |
Description:No description available | ||||
VOrgBAccountID | int | Restrict Visibility To | - | |
Description:No description available | ||||
VStatus | char(1) | Status | - | |
Description:No description available | ||||
WarningNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
WorkCodeID | nvarchar(15) | Default WCC Code | PMWorkCode | |
Description:No description available | ||||
WorkCodeUseDflt | bit | Use Default | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | - | |
Description:No description available | ||||