CR
CREmployee
PX.Objects.CR52 of 52 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 | ||||
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 | - | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | - | |
Description:No description available | ||||
CasesCountNonexistent in DBObsolete | int | - | ||
Description:No description available | ||||
ClassID | nvarchar(10) | Business Account Class | - | |
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 | ||||
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 ID | - | |
Description:No description available | ||||
CuryRateTypeID | nvarchar(6) | Curr. Rate Type | - | |
Description:No description available | ||||
DefAddressID | int | Default Address | - | |
Description:No description available | ||||
DefContactID | int | Default Contact | - | |
Description:No description available | ||||
DefLocationID | int | Default Location | - | |
Description:No description available | ||||
DepartmentID | nvarchar(10) | Department | - | |
Description:No description available | ||||
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 | - | |
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 | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | - | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | - | |
Description:No description available | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PrimaryContactID | int | Primary 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 | - | |
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 | - | |
Description:No description available | ||||
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 | - | |
Description:No description available | ||||
ViewInCrmNonexistent in DB | bit | View In CRM | - | |
Description:No description available | ||||
VOrgBAccountID | int | Vendor Restriction Group | - | |
Description:No description available | ||||
VStatus | char(1) | Status | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | - | |
Description:No description available | ||||