CR
EPEmployee
PX.Objects.CR.Standalone52 of 52 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Employee ID | - | |
Description:The human-readable identifier of the employee that is specified by the user or defined by the EMPLOYEE auto-numbering sequence during the creation of the employee. This field is a natural key, as opposed to the surrogate key BAccountID. | ||||
AcctName | nvarchar(255) | Employee Name | - | |
Description:The employee name, which is usually a concatenation of the first and last name of the appropriate contact. | ||||
AcctReferenceNbr | nvarchar(50) | Employee Ref. No. | - | |
Description:The external reference number of the employee. It can be an additional number of the employee used in external integration. | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:No description available | ||||
BAccountID | int | Business Account ID | - | |
Description:No description available | ||||
BaseCuryID | nvarchar(5) | Base Currency ID | CurrencyList | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | CRCampaign | |
Description:No description available | ||||
CasesCountNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
ClassID | nvarchar(10) | Business Account Class | CRCustomerClass | |
Description:No description available | ||||
ConsolidateToParent | bit | Consolidate Balance | - | |
Description:No description available | ||||
ConsolidatingBAccountID | int | - | ||
Description:No description available | ||||
COrgBAccountID | int | Customer Restriction Group | BAccount | |
Description:No description available | ||||
CountNonexistent in DBObsolete | int | Count | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency ID | Currency | |
Description:No description available | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type | CurrencyRateType | |
Description:No description available | ||||
DefAddressID | int | Default Address | Address | |
Description:The identifier of the CR.Address object linked with the current employee as Address Info. Corresponds to the value of the Address.AddressID field. | ||||
DefContactID | int | Default Contact | Contact | |
Description:The identifier of the CR.Contact object linked with the current employee as Contact Info. Corresponds to the value of the Contact.ContactID field. | ||||
DefLocationID | int | Default Location | Location | |
Description:The identifier of the Location object linked with the employee and marked as default. The fields from the linked location are shown on the Financial Settings tab. Corresponds to the value of the Location.LocationID field. Also, the Location.BAccountID value must also be equal to the BAccount.BAccountID value of the current employee. | ||||
DepartmentID | nvarchar(10) | Department | EPDepartment | |
Description:Identifier of the employee department that the employee belongs to. | ||||
GroupMask | varbinary(32) | - | ||
Description:No description available | ||||
IsBranch | bit | - | ||
Description:No description available | ||||
IsCustomerOrCombined | bit | - | ||
Description:No description available | ||||
LastActivityNonexistent in DBObsolete | datetime | Last Activity | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
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 | ||||
LocaleName | nvarchar(10) | Language/Locale | Locale | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | Branch | |
Description:No description available | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PrimaryContactID | int | Primary Contact | Contact | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
RegisteredEntityForReporting | bit | Registered Entity for Government Payroll Reporting | - | |
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | SalesTerritory | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
Status | char(1) | Customer Status | - | |
Description:No description available | ||||
SupervisorID | int | Reports to | EPEmployee | |
Description:The identifier of the EPEmployee that the current employee sends reports to. Corresponds to the value of the BAccount.BAccountID field. | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:No description available | ||||
UserID | uniqueidentifier | Employee Login | Users | |
Description:The identifier of the Users to be used for the employee to sign into the system. Corresponds to the value of the Users.PKID field. | ||||
ViewInCrmNonexistent in DB | bit | View In CRM | - | |
Description:No description available | ||||
VOrgBAccountID | int | Vendor Restriction Group | BAccount | |
Description:No description available | ||||
VStatus | char(1) | Status | - | |
Description:The status of the employee. The possible values of the field are listed in the VendorStatus class. These values can be changed and extended by using the workflow engine. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||