AP
APRegisterAccess
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ABN | nvarchar(15) | ABN | - | |
Description:No description available | ||||
AcctCD | nvarchar(30) | Vendor | BAccount | |
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) | Vendor 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:If set to true, indicates that the currency of business account documents (which is specified by BAccount.CuryID) can be overridden by a user during document entry. | ||||
AllowOverrideRate | bit | Enable Rate Override | - | |
Description:If set to true, 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 true). | ||||
AttributesNonexistent in DB | string | - | ||
Description:The attributes list available for the current business account. The field is preserved for internal use. | ||||
AutoGenerateTaxBill | bit | Automatically Generate Tax Bill | - | |
Description:No description available | ||||
BASInstalmentAmount | int | G21 - GST instalment amount | - | |
Description:No description available | ||||
BASOptions | nvarchar(1) | Options | - | |
Description:No description available | ||||
BAccountClassID | nvarchar(10) | Business Account Class | - | |
Description:The BAccount.classID field, which is used for internal purposes. | ||||
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:The base Currency of the Branch. This unbound field corresponds to the Organization.BaseCuryID. | ||||
BaseRemitContactID | int | Default Contact | Contact | |
Description:No description available | ||||
Box1099 | smallint | 1099 Box | AP1099Box | |
Description:No description available | ||||
COrgBAccountID | int | Customer Restriction Group | - | |
Description:No description available | ||||
CampaignSourceID | nvarchar(15) | Source Campaign | CRCampaign | |
Description:The identifier of the marketing or sales campaign that resulted in creation of the business account. Corresponds to the value of the CRCampaign.CampaignID field. | ||||
CasesCountNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
ClassIDObsolete | nvarchar(10) | Class ID | 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:The field is preserved for internal use. | ||||
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:The identifier of the Currency, which is applied to the documents of the business account. | ||||
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 true). | ||||
DefAddressID | int | Default Address | Address | |
Description:The identifier of the CR.Address record used to store address data of the business account. Corresponds to the value of the Address.AddressID field. Also, the Address.BAccountID value must be equal to the BAccount.BAccountID value of the current business account. | ||||
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:The identifier of the Location object linked with the business account and marked as default. The linked location is shown on the Shipping tab. Corresponds to the value of the Location.LocationID field. Also, the Location.BAccountID value must also equal to the BAccount.BAccountID value of the current business account. | ||||
DefPOAddressID | int | Address | ||
Description:No description available | ||||
DefaultUOM | nvarchar(10) | Default UOM | - | |
Description:No description available | ||||
DiscTakenAcctID | int | Cash Discount Account | Account | |
Description:No description available | ||||
DiscTakenSubID | int | Cash Discount Sub. | Sub | |
Description:No description available | ||||
DocType | char(3) | - | ||
Description:No description available | ||||
EmailRemittances | bit | Send Remittances by Email | - | |
Description:No description available | ||||
FATCA | bit | FATCA | - | |
Description:No description available | ||||
ForeignEntity | bit | Foreign Entity | - | |
Description:No description available | ||||
GroupMask | varbinary | - | ||
Description:The group mask that indicates which restriction groups the business account belongs to. | ||||
IgnoreConfiguredDiscounts | bit | Ignore Configured Discounts When Vendor Price Is Defined | - | |
Description:No description available | ||||
IncludedNonexistent in DB | bool? | Included | - | |
Description:No description available | ||||
IsBranch | bit | - | ||
Description:No description available | ||||
IsCustomerOrCombinedNonexistent in DB | bool? | - | ||
Description:A calculated field that indicates (if set to "true") that BAccount.Type is either BAccountType.CustomerType or BAccountType.CombinedType. | ||||
IsRelatedToProjectContactNonexistent in DB | bool? | Is Related To Project Contact | - | |
Description:No description available | ||||
JurisdictionCountryID | nvarchar(10) | Jurisdiction | - | |
Description:No description available | ||||
LandedCostVendor | bit | Landed Cost Vendor | - | |
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:The legal name of the company that is used by the 1099 Reporting feature only (see DAC.Organization). | ||||
LineDiscountTarget | char(1) | Apply Line Discounts to | - | |
Description:No description available | ||||
LocaleName | nvarchar(10) | Language/Locale | Locale | |
Description:The name of the business account locale. | ||||
NoteID | 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 | ||||
POAccrualAcctID | int | PO Accrual Account | Account | |
Description:No description available | ||||
POAccrualSubID | int | PO Accrual Sub. | Sub | |
Description:No description available | ||||
PTRS | bit | Small business, track for PTRS | - | |
Description:No description available | ||||
ParentBAccountID | int | Business Account | BAccountR | |
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. | ||||
PayToVendorID | int | Pay-to Vendor | Vendor | |
Description:A reference to the Vendor. An integer identifier of the vendor, whom the AP bill will belong to. | ||||
PaymentsByLinesAllowed | bit | Pay by Line | - | |
Description:No description available | ||||
PrebookAcctID | int | Reclassification Account | Account | |
Description:No description available | ||||
PrebookSubID | int | Reclassification Subaccount | Sub | |
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 | string | - | ||
Description:No description available | ||||
PriceListCuryID | nvarchar(5) | Currency ID | Currency | |
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. | ||||
PrintRemittances | bit | Print Remittances | - | |
Description:No description available | ||||
PseudonymizationStatus | int | Pseudonymized | - | |
Description:No description available | ||||
PurchTaxAcctID | int | Tax Claimable Account | Account | |
Description:No description available | ||||
PurchTaxSubID | int | Tax Claimable Sub. | Sub | |
Description:No description available | ||||
RefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
RegisteredEntityForReporting | bit | Registered Entity for Government Payroll Reporting | - | |
Description:The registered entity for government payroll reporting. | ||||
RetainageApply | bit | Apply Retainage | - | |
Description:No description available | ||||
RetainagePct | decimal | Retainage Percent | - | |
Description:No description available | ||||
SDEnabled | bit | - | ||
Description:No description available | ||||
SVATInputTaxEntryRefNbr | char(1) | Input Tax Entry Ref. Nbr. | - | |
Description:No description available | ||||
SVATOutputTaxEntryRefNbr | char(1) | Output Tax Entry Ref. Nbr. | - | |
Description:No description available | ||||
SVATReversalMethod | char(1) | VAT Recognition Method | - | |
Description:No description available | ||||
SVATTaxInvoiceNumberingID | nvarchar(10) | Tax Invoice Numbering | Numbering | |
Description:No description available | ||||
SalesTaxAcctID | int | Tax Payable Account | Account | |
Description:No description available | ||||
SalesTaxSubID | int | Tax Payable Sub. | Sub | |
Description:No description available | ||||
SalesTerritoryID | nvarchar(15) | Sales Territory | SalesTerritory | |
Description:The reference to SalesTerritory.salesTerritoryID. If overrideSalesTerritory is false then it's filled automatically based on Address.state and Address.countryID otherwise it's assigned by user. | ||||
ScheduleID | nvarchar(15) | - | ||
Description:No description available | ||||
Scheduled | bit | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ShouldGenerateLienWaivers | bit | Generate Lien Waivers Based on Project Settings | - | |
Description:No description available | ||||
Status | char(1) | Customer Status | - | |
Description:No description available | ||||
TPAR | bit | Track for TPAR | - | |
Description:No description available | ||||
TPARLocation | int | TPAR Location | LocationExtAddress | |
Description:No description available | ||||
TaxAgency | bit | Vendor Is Tax Agency | - | |
Description:No description available | ||||
TaxExpenseAcctID | int | Tax Expense Account | Account | |
Description:No description available | ||||
TaxExpenseSubID | int | Tax Expense Sub. | Sub | |
Description:No description available | ||||
TaxPeriodType | nvarchar(1) | Default Tax Period Type | - | |
Description:No description available | ||||
TaxRegistrationID | nvarchar(50) | Tax Registration ID | - | |
Description:The registration ID of the company in the state tax authority. | ||||
TaxReportFinPeriod | bit | Define Tax Period by End Date of Financial Period | - | |
Description:No description available | ||||
TaxReportPrecision | smallint | Tax Report Precision | - | |
Description:No description available | ||||
TaxReportRounding | nvarchar(1) | Tax Report Rounding | - | |
Description:No description available | ||||
TaxUseVendorCurPrecision | bit | Use Currency Precision | - | |
Description:No description available | ||||
TermsID | nvarchar(10) | Terms | Terms | |
Description:No description available | ||||
TinType | char(1) | Type of TIN | - | |
Description:No description available | ||||
Type | 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. | ||||
UpdClosedTaxPeriods | bit | Update Closed Tax Periods | - | |
Description:No description available | ||||
VOrgBAccountID | int | Restrict Visibility To | - | |
Description:No description available | ||||
VStatus | char(1) | Vendor Status | - | |
Description:No description available | ||||
Vendor1099 | bit | 1099 Vendor | - | |
Description:No description available | ||||
VendorClassID | nvarchar(10) | Vendor Class | VendorClass | |
Description:No description available | ||||
VendorDefaultCostCodeId | int | Cost Code | PMCostCode | |
Description:No description available | ||||
VendorDefaultInventoryId | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
ViewInCrmNonexistent in DB | bool? | View In CRM | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||