CR
BAccount
PX.Objects.CRView API Entity: BusinessAccount
/entity/Default/24.200.001/BusinessAccount49 of 49 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Account ID | - | |
Description:The human-readable identifier of the business account that is specified by the user or defined by the auto-numbering sequence during the creation of the account. This field is a natural key, as opposed to the surrogate key BAccountID. | ||||
AcctName | nvarchar(255) | Account Name | - | |
Description:The full business account name (as opposed to the short identifier AcctCD). | ||||
AcctReferenceNbr | nvarchar(50) | Ext. Ref. Nbr. | - | |
Description:The external reference number of the business account. It can be an additional number of the business account used in external integration. | ||||
AllowOverrideCury | bit | Enable Currency Override | - | |
Description:No description available | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:If set to , indicates that the currency rate for customer documents (which is calculated by the system from the currency rate history) can be overridden by a user during document entry. The field is used only if the business account is a customer (that is, IsCustomerOrCombined is ). | ||||
BAccountID | int | Business Account ID | - | |
Description:The identifier of the business account. This field is auto-incremental. This field is a surrogate key, as opposed to the natural key AcctCD. | ||||
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 API | nvarchar(10) | Business Account Class | CRCustomerClass | |
Description:Identifier of the business acccount class to which the business account belongs. | ||||
ConsolidateToParent | bit | Consolidate Balance | - | |
Description:The total balance of the parent customer account including balances of its child accounts for which the value of this field is true on the Billing Info tab of this form. The amount includes the balances of all open documents and prepayments. This field is used in the Customer class and showed only on the Customers (AR303000) form. | ||||
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:The identifier of the currency rate type, which is applied to the documents of the customer. The field is used only if the business account is a customer (that is, IsCustomerOrCombined is ). | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefContactID | int | Default Contact | Contact | |
Description:The identifier of the CR.Contact object used to store additional contact data of the business account. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must be equal to the BAccount.BAccountID value of the current business account. | ||||
DefLocationID | int | Default Location | Location | |
Description:No description available | ||||
GroupMask | varbinary(32) | - | ||
Description:The group mask that indicates which restriction groups the business account belongs to. | ||||
IsBranch | bit | - | ||
Description:No description available | ||||
IsCustomerOrCombined | bit | - | ||
Description:A calculated field that indicates (if set to "true") that BAccount.Type is either BAccountType.CustomerType or BAccountType.CombinedType. | ||||
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 API | datetime | Last Modified On | - | |
Description:No description available | ||||
LegalName | nvarchar(255) | Legal Name | - | |
Description:The legal name of the company that is used by the 1099 Reporting feature only (see DAC.Organization). | ||||
LocaleName | nvarchar(10) | Language/Locale | Locale | |
Description:No description available | ||||
NoteID API | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:The flag identified that the salesTerritoryID is filled automatically based on Address.state and Address.countryID or can be assigned manually. | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | BAccount | |
Description:The identifier of the parent business account. Corresponds to the value of the BAccount.BAccountID field of the parent account. This field is used for consolidating customer account balances on the parent account from child accounts. | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PrimaryContactID | int | Primary Contact | Contact | |
Description:The identifier of the CR.Contact object linked with the business account and marked as primary. Corresponds to the value of the Contact.ContactID field. Also, the Contact.BAccountID value must equal to the BAccount.BAccountID value of the current business account. | ||||
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:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user. | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
Status API | char(1) | Customer Status | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:The registration ID of the company in the state tax authority. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type API | char(2) | Type | - | |
Description:Represents the type of the business account. The field can have one of the values listed in the BAccountType class. The default value is BAccountType.ProspectType for a prospect, BAccountType.CustomerType for a customer, and BAccountType.VendorType for a vendor. | ||||
ViewInCrmNonexistent in DB | bit | View In CRM | - | |
Description:No description available | ||||
VOrgBAccountID | int | Vendor Restriction Group | BAccount | |
Description:No description available | ||||
VStatus | char(1) | Vendor Status | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||