AR
Customer
PX.Objects.ARView API Entity: Customer
/entity/Default/24.200.001/Customer100 of 100 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Customer ID | - | |
Description:The human-readable identifier of the customer account, which is specified by the user or defined by the auto-numbering sequence during creation of the customer. This field is a natural key, as opposed to the surrogate key BAccount.BAccountID. | ||||
AcctName | nvarchar(255) | Customer Name | - | |
Description:The full business account name (as opposed to the short identifier provided by Customer.AcctCD). | ||||
AcctReferenceNbr | nvarchar(50) | Ext. Ref. Nbr. | - | |
Description:No description available | ||||
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. | ||||
AutoApplyPayments API | bit | Auto-Apply Payments | - | |
Description:If set to "true", indicates that the payments of the customer should be automatically applied to the open invoices upon release. | ||||
BAccountClassID | nvarchar(10) | Business Account Class | - | |
Description:The BAccount.classID field, which is used for internal purposes. | ||||
BAccountID API | int | Business Account ID | - | |
Description:No description available | ||||
BaseBillContactIDObsolete | int | Default Contact | Contact | |
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 | ||||
CCProcessingIDObsolete | nvarchar(1024) | - | ||
Description:An obsolete field. | ||||
ClassIDObsolete | nvarchar(10) | Class ID | - | |
Description:A read-only equivalent of the Customer.CustomerClassID field, which is used for internal purposes. | ||||
COGSAcctID | int | COGS Account | Account | |
Description:No description available | ||||
ConsolidateStatements | bit | Consolidate Statements | - | |
Description:When set to true indicates that consolidated statements are prepared for the customer and its parent and siblings. Otherwise, individual statements are prepared. | ||||
ConsolidateToParent | bit | Consolidate Balance | - | |
Description:No description available | ||||
ConsolidatingBAccountID | int | - | ||
Description:No description available | ||||
COrgBAccountID | int | Restrict Visibility To | 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 API | datetime | Created On | - | |
Description:No description available | ||||
CreditDaysPastDue | smallint | Credit Days Past Due | - | |
Description:No description available | ||||
CreditLimit API | decimal(19, 4) | Credit Limit | - | |
Description:No description available | ||||
CreditRule | char(1) | Credit Verification | - | |
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. | ||||
CustomerCategory API | char(1) | Customer Category | - | |
Description:The customer kind, indicating whether the customer is an individual (I) or an organization (O). | ||||
CustomerClassID | nvarchar(10) | Customer Class | CustomerClass | |
Description:No description available | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefBillAddressID | int | Address | ||
Description:The billing Address associated with the customer. | ||||
DefBillContactID | int | Default Contact | Contact | |
Description:The billing Contact associated with the customer. | ||||
DefContactID | int | Default Contact | Contact | |
Description:No description available | ||||
DefLocationID | int | Default Location | Location | |
Description:No description available | ||||
DefPaymentMethodID | nvarchar(10) | Default Payment Method | PaymentMethod | |
Description:No description available | ||||
DefPMInstanceID | int | PMInstance | ||
Description:The unique identifier of the PMInstance object associated with the customer's default payment method. | ||||
DefSOAddressIDObsolete | int | - | ||
Description:An obsolete field. | ||||
DiscTakenAcctID | int | Cash Discount Account | Account | |
Description:The account that is used to process the amounts of cash discount taken by the customer. | ||||
DiscTakenSubID | int | Cash Discount Sub. | Sub | |
Description:The subaccount that is used to process the amounts of cash discount taken by the customer. | ||||
ECMCompanyCode | nvarchar(255) | Company Code | - | |
Description:The company codes for which the customer is created in the external exemption certificate management system. | ||||
FinChargeApply | bit | Apply Overdue Charges | - | |
Description:If set to "true", indicates that financial charges can be calculated for the customer. | ||||
GroupMask | varbinary(32) | - | ||
Description:The group mask of the customer. The value of the field is used for the purposes of access control. | ||||
IncludedNonexistent in DB | bit | Included | - | |
Description:An unbound Boolean field that is provided for implementation of the IIncludable interface, which is a part of the row-level security mechanism of Acumatica. | ||||
IsBillContSameAsMainNonexistent in DBObsolete | bit | Same as Main | - | |
Description:No description available | ||||
IsBillSameAsMainNonexistent in DBObsolete | bit | Same as Main | - | |
Description:No description available | ||||
IsBranch | bit | - | ||
Description:No description available | ||||
IsCustomerOrCombined | bit | - | ||
Description:A calculated field that indicates (if set to "true") that Customer.Type is either BAccountType.CustomerType or BAccountType.CombinedType. The field is inherited from the BAccount class and must always return "true" for a customer account. | ||||
IsECMValid | bit | - | ||
Description:A Boolean value that indicates (if set to ) that the customer record in the external exemption certificate management (ECM) system is up-to-date. If the value is "false", the customer record has been updated in Acumatica ERP since this record was created with the ECM system. The record should be updated in the external ECM system. | ||||
LanguageIDObsolete | char(4) | - | ||
Description:An obsolete field. | ||||
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:No description available | ||||
LocaleName | nvarchar(10) | Language/Locale | Locale | |
Description:No description available | ||||
MailDunningLetters | bit | Send Dunning Letters by Email | - | |
Description:If set to "true", indicates that dunning letters should be sent to the customer by email. | ||||
MailInvoices | bit | Send Invoices by Email | - | |
Description:If set to "true", indicates that invoices should be sent to the customer by email. | ||||
NoteID API | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideBillAddressNonexistent in DB | bit | Override | - | |
Description:A calculated field. If set to "false", indicates that the customer's billing address is the same as the customer's default address. The field is populated by a formula, working only in the scope of the Customers (AR303000) form. See CustomerMaint.CustomerBillSharedAddressOverrideGraphExt" | ||||
OverrideBillContactNonexistent in DB | bit | Override | - | |
Description:A calculated field. If set to "false", indicates that the customer's billing contact is the same as the customer's default contact. The field is populated by a formula, working only in the scope of the Customers (AR303000) form. See CustomerMaint.CustomerBillSharedContactOverrideGraphExt" | ||||
OverrideSalesTerritory | bit | Override Territory | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentBAccountID | int | Parent Account | BAccount | |
Description:No description available | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PrepaymentAcctID | int | Prepayment Account | Account | |
Description:The identifier of the account that serves as the default value of the ARRegister.ARAccountID field for the prepayment documents. | ||||
PrepaymentSubID | int | Prepayment Sub. | Sub | |
Description:The identifier of the subaccount that serves as the default value of the ARRegister.ARSubID field for the prepayment documents. | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PrimaryContactID API | int | Primary Contact | Contact | |
Description:No description available | ||||
PrintCuryStatements | bit | Multi-Currency Statements | - | |
Description:If set to "true", indicates that customer statements should be generated for the customer in multi-currency format. | ||||
PrintDunningLetters API | bit | Print Dunning Letters | - | |
Description:If set to "true", indicates that dunning letters should be printed for the customer. | ||||
PrintInvoices API | bit | Print Invoices | - | |
Description:If set to "true", indicates that invoices should be printed for the customer. | ||||
PrintStatements API | bit | Print Statements | - | |
Description:If set to "true", indicates that customer statements should be printed for the customer. | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
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 | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | SalesTerritory | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SendStatementByEmail | bit | Send Statements by Email | - | |
Description:No description available | ||||
SharedCreditChildNonexistent in DB | bit | - | ||
Description:No description available | ||||
SharedCreditCustomerID | int | Customer | ||
Description:Identifier of the customer, through which the credit control is set up and maintained for this customer. When Customer.SharedCreditPolicy is true, this field holds the ID of the parent customer (if present). When Customer.SharedCreditPolicy is false, credit control is executed individually for this customer and this field is equal to its ID. Corresponds to the BAccount.BAccountID field. The field is populated by a formula, working only in the scope of the Customers (AR303000) form. See CustomerMaint.Customer_SharedCreditCustomerID_CacheAttached" | ||||
SharedCreditPolicy | bit | Share Credit Policy | - | |
Description:If set to "true", indicates that: - Credit control is enabled at the parent level; that is, the group credit verification settings are specified for the parent account. - Dunning letters are consolidated to the parent account. | ||||
SmallBalanceAllow | bit | Enable Write-Offs | - | |
Description:If set to "true", indicates that small balance write-offs are allowed for the customer. | ||||
SmallBalanceLimit | decimal(19, 4) | Write-Off Limit | - | |
Description:If SmallBalanceAllow is set to "true", the field determines the maximum small balance write-off limit for customer documents. | ||||
StatementChildNonexistent in DB | bit | - | ||
Description:No description available | ||||
StatementCustomerID | int | Customer | ||
Description:Identifier of the customer, whose statements include data for this customer. When Customer.ConsolidateStatements is true, this field holds the ID of the parent customer (if present). When Customer.ConsolidateStatements is false, individual statements are prepared and this field is equal to the ID of this customer. Corresponds to the BAccount.BAccountID field. The field is populated by a formula, working only in the scope of the Customers (AR303000) form. See CustomerMaint.Customer_StatementCustomerID_CacheAttached" | ||||
StatementCycleId API | nvarchar(10) | Statement Cycle ID | ARStatementCycle | |
Description:The identifier of the statement cycle to which the customer is assigned. | ||||
StatementLastDate | datetime2 | Statement Last Date | - | |
Description:The date when the statements were last generated for the customer. | ||||
StatementType API | char(1) | Statement Type | - | |
Description:The type of customer statements generated for the customer. The list of possible values of the field is determined by StatementTypeAttribute. | ||||
Status API | char(1) | Customer Status | - | |
Description:No description available | ||||
SuggestRelatedItems | bit | Suggest Related Items | - | |
Description:No description available | ||||
TaxRegistrationID API | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:The identifier of the default terms, which are applied to the documents of the customer. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:Represents the type of the business account of the customer. The field defaults to BAccountType.CustomerType; however, the field can have a value of BAccountType.CombinedType if the customer account has been extended to this type. | ||||
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 | ||||