CA
CustomerRLS
PX.Objects.CA.Light100 of 100 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcctCD | nvarchar(30) | Customer ID | - | |
Description:No description available | ||||
AcctName | nvarchar(255) | Customer Name | - | |
Description:No description available | ||||
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:No description available | ||||
AutoApplyPayments | bit | Auto-Apply Payments | - | |
Description:No description available | ||||
BAccountClassID | nvarchar(10) | Business Account Class | - | |
Description:No description available | ||||
BAccountID | int | Contact | ||
Description:The identifier of the business account. | ||||
BaseBillContactIDObsolete | int | Default 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:No description available | ||||
ClassIDObsolete | nvarchar(10) | Class ID | - | |
Description:No description available | ||||
COGSAcctID | int | COGS Account | Account | |
Description:No description available | ||||
ConsolidateStatements | bit | Consolidate Statements | - | |
Description:No description available | ||||
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 | datetime | Created On | - | |
Description:No description available | ||||
CreditDaysPastDue | smallint | Credit Days Past Due | - | |
Description:No description available | ||||
CreditLimit | decimal | 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:No description available | ||||
CustomerCategory | char(1) | Customer Category | - | |
Description:No description available | ||||
CustomerClassID | nvarchar(10) | Customer Class | CustomerClass | |
Description:No description available | ||||
DefAddressID | int | Default Address | Address | |
Description:No description available | ||||
DefBillAddressID | int | Address | ||
Description:No description available | ||||
DefBillContactID | int | Default Contact | Contact | |
Description:No description available | ||||
DefContactID | int | Default Contact | Contact | |
Description:No description available | ||||
DefLocationID | int | Default Location | - | |
Description:No description available | ||||
DefPaymentMethodID | nvarchar(10) | Default Payment Method | PaymentMethod | |
Description:No description available | ||||
DefPMInstanceID | int | PMInstance | ||
Description:No description available | ||||
DefSOAddressIDObsolete | int | - | ||
Description:No description available | ||||
DiscTakenAcctID | int | Cash Discount Account | Account | |
Description:No description available | ||||
DiscTakenSubID | int | Cash Discount Sub. | Sub | |
Description:No description available | ||||
ECMCompanyCode | nvarchar(255) | Company Code | - | |
Description:No description available | ||||
FinChargeApply | bit | Apply Overdue Charges | - | |
Description:No description available | ||||
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:No description available | ||||
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:No description available | ||||
IsECMValid | bit | - | ||
Description:No description available | ||||
LanguageIDObsolete | char(4) | - | ||
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 | ||||
MailDunningLetters | bit | Send Dunning Letters by Email | - | |
Description:No description available | ||||
MailInvoices | bit | Send Invoices by Email | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OverrideBillAddressNonexistent in DB | bit | Override | - | |
Description:No description available | ||||
OverrideBillContactNonexistent in DB | bit | Override | - | |
Description:No description available | ||||
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:No description available | ||||
PrepaymentSubID | int | Prepayment Sub. | Sub | |
Description:No description available | ||||
PreviewHtmlNonexistent in DBObsolete | nvarchar(MAX) | - | ||
Description:No description available | ||||
PrimaryContactID | int | Primary Contact | Contact | |
Description:No description available | ||||
PrintCuryStatements | bit | Multi-Currency Statements | - | |
Description:No description available | ||||
PrintDunningLetters | bit | Print Dunning Letters | - | |
Description:No description available | ||||
PrintInvoices | bit | Print Invoices | - | |
Description:No description available | ||||
PrintStatements | bit | Print Statements | - | |
Description:No description available | ||||
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 | 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:No description available | ||||
SharedCreditPolicy | bit | Share Credit Policy | - | |
Description:No description available | ||||
SmallBalanceAllow | bit | Enable Write-Offs | - | |
Description:No description available | ||||
SmallBalanceLimit | decimal | Write-Off Limit | - | |
Description:No description available | ||||
StatementChildNonexistent in DB | bit | - | ||
Description:No description available | ||||
StatementCustomerID | int | Customer | ||
Description:No description available | ||||
StatementCycleId | nvarchar(10) | Statement Cycle ID | ARStatementCycle | |
Description:No description available | ||||
StatementLastDate | datetime2 | Statement Last Date | - | |
Description:No description available | ||||
StatementType | char(1) | Statement Type | - | |
Description:No description available | ||||
Status | char(1) | Customer Status | - | |
Description:No description available | ||||
SuggestRelatedItems | bit | Suggest Related Items | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(2) | Type | - | |
Description:No description available | ||||
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 | ||||