invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerAttributesByCode: Visma.net Financials Customer Attributes by Code

read only REST

  • Catalog: VismaNet
  • Schema: Customer
  • Label: Customer Attributes by Code

Get a specific customer Data for the customer The response headers include an ETag after a successful GET operation.

Can only retrieve data.

Summary

Data for the customer

The response headers include an ETag after a successful GET operation.

API Source

  • Endpoint: /v1/customer/{customerCd}
  • Operation: get /v1/customer/{customerCd}

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
customerCd `` Identifies the customer

Table Columns

The columns of the table CustomerAttributesByCode are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
acceptAutoInvoices char Accept Auto-invoices filters on the platform, writable, ::ancestor.acceptAutoInvoices Invoicing settings > Print and email settings section > Send invoices to AutoInvoice > Select this check box if you are using AutoInvoice and want to send invoices directly to this service.
accountReference varchar2 Account Reference filters on the platform, writable, ::ancestor.accountReference General information tab > Main contact section > Account ref. > Your company's account number in the customer's system.
corporateId varchar2 Corporate ID filters on the platform, writable, ::ancestor.corporateId Delivery settings tab > Default location settings section > Corporate ID > The customers company ID, associated with the location.
createdDateTime datetime Created filters on the platform, writable, ::ancestor.createdDateTime Information collected from the system. Not visible on the screen.
creditDaysPastDue int32 Credit Days Past Due filters on the platform, writable, ::ancestor.creditDaysPastDue General information tab > Credit verification rules section > Credit days past due > The maximum number of days by which the customer payment may exceed the invoice date.
creditLimit double Credit Limit filters on the platform, writable, ::ancestor.creditLimit The General information tab > Credit verification rules section > Credit limit > The amount, if applicable, that serves as a credit limit for the customer.
creditTerms_description varchar2 Credit Terms Description filters on the platform, writable, ::ancestor.creditTerms.description Click on the magnifier. > The description.
creditTerms_id varchar2 Credit Terms ID filters on the platform, writable, ::ancestor.creditTerms.id Click on the magnifier. > The identifier.
creditVerification varchar2 Credit Verification filters on the platform, writable, ::ancestor.creditVerification The General information tab > Credit verification rules > Credit verification > The credit rule applied to this customer. The following options are available: Days past due, Credit limit, Limit and days past due, disabled.
currencyId varchar2 Currency ID filters on the platform, writable, ::ancestor.currencyId The General information tab > Financial settings section > Currency ID > The currency used in operations with the customer, which you can select from the list of currencies defined in the system.
customerClass_description varchar2 Customer Class Description filters on the platform, writable, ::ancestor.customerClass.description Click on the magnifier. > The description.
customerClass_id varchar2 Customer Class ID filters on the platform, writable, ::ancestor.customerClass.id Click on the magnifier. > The identifier.
defaultPaymentMethodId varchar2 itgen_vnet_defaultpaymentmethodid filters on the platform, writable, ::ancestor.defaultPaymentMethodId Invoicing settings tab > Default payment method section > The default payment method.
deliveryAddress_addressId int32 Delivery Address ID filters on the platform, writable, ::ancestor.deliveryAddress.addressId
deliveryAddress_addressLine1 varchar2 Delivery Address Line 1 filters on the platform, writable, ::ancestor.deliveryAddress.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
deliveryAddress_addressLine2 varchar2 Delivery Address Line 2 filters on the platform, writable, ::ancestor.deliveryAddress.addressLine2 Address 2 > The second line of the address.
deliveryAddress_addressLine3 varchar2 Delivery Address Line 3 filters on the platform, writable, ::ancestor.deliveryAddress.addressLine3 Address 3 > The third line of the address.
deliveryAddress_city varchar2 Delivery Address City filters on the platform, writable, ::ancestor.deliveryAddress.city City > The city.
deliveryAddress_country_errorInfo varchar2 itgen_vnet_deliveryaddress_country_errorinfo filters on the platform, writable, ::ancestor.deliveryAddress.country.errorInfo
deliveryAddress_country_id varchar2 Delivery Address Country ID filters on the platform, writable, ::ancestor.deliveryAddress.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
deliveryAddress_country_metadata_maxPageSize int64 itgen_vnet_deliveryaddress_country_metadata_maxpagesize filters on the platform, writable, ::ancestor.deliveryAddress.country.metadata.maxPageSize
deliveryAddress_country_metadata_totalCount int64 itgen_vnet_deliveryaddress_country_metadata_totalcount filters on the platform, writable, ::ancestor.deliveryAddress.country.metadata.totalCount
deliveryAddress_country_name varchar2 Delivery Address Country Name filters on the platform, writable, ::ancestor.deliveryAddress.country.name Mandatory field: Country name* > The complete name of the country.
deliveryAddress_county_id varchar2 Delivery Address County ID filters on the platform, writable, ::ancestor.deliveryAddress.county.id Click the magnifier > The identifier
deliveryAddress_county_name varchar2 Delivery Address County Name filters on the platform, writable, ::ancestor.deliveryAddress.county.name Click the magnifier > The displayed name
deliveryAddress_postalCode varchar2 Delivery Address Postal Code filters on the platform, writable, ::ancestor.deliveryAddress.postalCode Postcode > The postcode.
deliveryContact_attention varchar2 Delivery Contact Attention filters on the platform, writable, ::ancestor.deliveryContact.attention Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.
deliveryContact_contactId int32 Delivery Contact ID filters on the platform, writable, ::ancestor.deliveryContact.contactId
deliveryContact_email varchar2 Delivery Contact Email Address filters on the platform, writable, ::ancestor.deliveryContact.email Email > The email address of the customer/supplier/company as a business entity.
deliveryContact_fax varchar2 Delivery Contact Fax filters on the platform, writable, ::ancestor.deliveryContact.fax Fax > The fax number.
deliveryContact_name varchar2 Delivery Contact Name filters on the platform, writable, ::ancestor.deliveryContact.name Name > The legal name of to appear on the documents.
deliveryContact_phone1 varchar2 Delivery Contact Phone 1 filters on the platform, writable, ::ancestor.deliveryContact.phone1 Phone 1 > The default phone number.
deliveryContact_phone2 varchar2 Delivery Contact Phone 2 filters on the platform, writable, ::ancestor.deliveryContact.phone2 Phone 2 > An additional phone number.
deliveryContact_web varchar2 Delivery Contact Website filters on the platform, writable, ::ancestor.deliveryContact.web Web > The website of the company, if one exists.
description varchar2 Description writable, description Attribute > The description of the attribute.
eInvoiceContract_fInvoiceContractID varchar2 itgen_vnet_einvoicecontract_finvoicecontractid filters on the platform, writable, ::ancestor.eInvoiceContract.fInvoiceContractID
eInvoiceContract_fInvoiceIntermediatorID varchar2 itgen_vnet_einvoicecontract_finvoiceintermediatorid filters on the platform, writable, ::ancestor.eInvoiceContract.fInvoiceIntermediatorID
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.errorInfo
excludeDebtCollection char itgen_vnet_excludedebtcollection filters on the platform, writable, ::ancestor.excludeDebtCollection Exclude Debt Collection for Autocollect
glAccounts_cashDiscountAccount_description varchar2 itgen_vnet_glaccounts_cashdiscountaccount_description filters on the platform, writable, ::ancestor.glAccounts.cashDiscountAccount.description Name of item/description
glAccounts_cashDiscountAccount_number varchar2 itgen_vnet_glaccounts_cashdiscountaccount_number filters on the platform, writable, ::ancestor.glAccounts.cashDiscountAccount.number Number of item
glAccounts_cashDiscountAccount_type varchar2 itgen_vnet_glaccounts_cashdiscountaccount_type filters on the platform, writable, ::ancestor.glAccounts.cashDiscountAccount.type
glAccounts_cashDiscountSubaccount_active char itgen_vnet_glaccounts_cashdiscountsubaccount_active filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.active Active > The status of the identifier.
glAccounts_cashDiscountSubaccount_description varchar2 itgen_vnet_glaccounts_cashdiscountsubaccount_description filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.description Description > The description of the identifier.
glAccounts_cashDiscountSubaccount_errorInfo varchar2 itgen_vnet_glaccounts_cashdiscountsubaccount_errorinfo filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.errorInfo
glAccounts_cashDiscountSubaccount_lastModifiedDateTime datetime itgen_vnet_glaccounts_cashdiscountsubaccount_lastmodifieddatetime filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.lastModifiedDateTime System generated information.
glAccounts_cashDiscountSubaccount_metadata_maxPageSize int64 itgen_vnet_glaccounts_cashdiscountsubaccount_metadata_maxpagesize filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.metadata.maxPageSize
glAccounts_cashDiscountSubaccount_metadata_totalCount int64 itgen_vnet_glaccounts_cashdiscountsubaccount_metadata_totalcount filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.metadata.totalCount
glAccounts_cashDiscountSubaccount_subaccountId int32 itgen_vnet_glaccounts_cashdiscountsubaccount_subaccountid filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.subaccountId SubID > The identifier of the subaccount.
glAccounts_cashDiscountSubaccount_subaccountNumber varchar2 itgen_vnet_glaccounts_cashdiscountsubaccount_subaccountnumber filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
glAccounts_cashDiscountSubaccount_timeStamp blob itgen_vnet_glaccounts_cashdiscountsubaccount_timestamp filters on the platform, writable, ::ancestor.glAccounts.cashDiscountSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
glAccounts_customerLedgerAccount_description varchar2 itgen_vnet_glaccounts_customerledgeraccount_description filters on the platform, writable, ::ancestor.glAccounts.customerLedgerAccount.description Name of item/description
glAccounts_customerLedgerAccount_number varchar2 itgen_vnet_glaccounts_customerledgeraccount_number filters on the platform, writable, ::ancestor.glAccounts.customerLedgerAccount.number Number of item
glAccounts_customerLedgerAccount_type varchar2 itgen_vnet_glaccounts_customerledgeraccount_type filters on the platform, writable, ::ancestor.glAccounts.customerLedgerAccount.type
glAccounts_customerLedgerSubaccount_active char itgen_vnet_glaccounts_customerledgersubaccount_active filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.active Active > The status of the identifier.
glAccounts_customerLedgerSubaccount_description varchar2 itgen_vnet_glaccounts_customerledgersubaccount_description filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.description Description > The description of the identifier.
glAccounts_customerLedgerSubaccount_errorInfo varchar2 itgen_vnet_glaccounts_customerledgersubaccount_errorinfo filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.errorInfo
glAccounts_customerLedgerSubaccount_lastModifiedDateTime datetime itgen_vnet_glaccounts_customerledgersubaccount_lastmodifieddatetime filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.lastModifiedDateTime System generated information.
glAccounts_customerLedgerSubaccount_metadata_maxPageSize int64 itgen_vnet_glaccounts_customerledgersubaccount_metadata_maxpagesize filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.metadata.maxPageSize
glAccounts_customerLedgerSubaccount_metadata_totalCount int64 itgen_vnet_glaccounts_customerledgersubaccount_metadata_totalcount filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.metadata.totalCount
glAccounts_customerLedgerSubaccount_subaccountId int32 itgen_vnet_glaccounts_customerledgersubaccount_subaccountid filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.subaccountId SubID > The identifier of the subaccount.
glAccounts_customerLedgerSubaccount_subaccountNumber varchar2 itgen_vnet_glaccounts_customerledgersubaccount_subaccountnumber filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
glAccounts_customerLedgerSubaccount_timeStamp blob itgen_vnet_glaccounts_customerledgersubaccount_timestamp filters on the platform, writable, ::ancestor.glAccounts.customerLedgerSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
glAccounts_discountAccount_description varchar2 itgen_vnet_glaccounts_discountaccount_description filters on the platform, writable, ::ancestor.glAccounts.discountAccount.description Name of item/description
glAccounts_discountAccount_number varchar2 itgen_vnet_glaccounts_discountaccount_number filters on the platform, writable, ::ancestor.glAccounts.discountAccount.number Number of item
glAccounts_discountAccount_type varchar2 itgen_vnet_glaccounts_discountaccount_type filters on the platform, writable, ::ancestor.glAccounts.discountAccount.type
glAccounts_discountSubaccount_active char itgen_vnet_glaccounts_discountsubaccount_active filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.active Active > The status of the identifier.
glAccounts_discountSubaccount_description varchar2 itgen_vnet_glaccounts_discountsubaccount_description filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.description Description > The description of the identifier.
glAccounts_discountSubaccount_errorInfo varchar2 itgen_vnet_glaccounts_discountsubaccount_errorinfo filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.errorInfo
glAccounts_discountSubaccount_lastModifiedDateTime datetime itgen_vnet_glaccounts_discountsubaccount_lastmodifieddatetime filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.lastModifiedDateTime System generated information.
glAccounts_discountSubaccount_metadata_maxPageSize int64 itgen_vnet_glaccounts_discountsubaccount_metadata_maxpagesize filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.metadata.maxPageSize
glAccounts_discountSubaccount_metadata_totalCount int64 itgen_vnet_glaccounts_discountsubaccount_metadata_totalcount filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.metadata.totalCount
glAccounts_discountSubaccount_subaccountId int32 itgen_vnet_glaccounts_discountsubaccount_subaccountid filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.subaccountId SubID > The identifier of the subaccount.
glAccounts_discountSubaccount_subaccountNumber varchar2 itgen_vnet_glaccounts_discountsubaccount_subaccountnumber filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
glAccounts_discountSubaccount_timeStamp blob itgen_vnet_glaccounts_discountsubaccount_timestamp filters on the platform, writable, ::ancestor.glAccounts.discountSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
glAccounts_freightAccount_description varchar2 itgen_vnet_glaccounts_freightaccount_description filters on the platform, writable, ::ancestor.glAccounts.freightAccount.description Name of item/description
glAccounts_freightAccount_number varchar2 itgen_vnet_glaccounts_freightaccount_number filters on the platform, writable, ::ancestor.glAccounts.freightAccount.number Number of item
glAccounts_freightAccount_type varchar2 itgen_vnet_glaccounts_freightaccount_type filters on the platform, writable, ::ancestor.glAccounts.freightAccount.type
glAccounts_freightSubaccount_active char itgen_vnet_glaccounts_freightsubaccount_active filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.active Active > The status of the identifier.
glAccounts_freightSubaccount_description varchar2 itgen_vnet_glaccounts_freightsubaccount_description filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.description Description > The description of the identifier.
glAccounts_freightSubaccount_errorInfo varchar2 itgen_vnet_glaccounts_freightsubaccount_errorinfo filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.errorInfo
glAccounts_freightSubaccount_lastModifiedDateTime datetime itgen_vnet_glaccounts_freightsubaccount_lastmodifieddatetime filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.lastModifiedDateTime System generated information.
glAccounts_freightSubaccount_metadata_maxPageSize int64 itgen_vnet_glaccounts_freightsubaccount_metadata_maxpagesize filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.metadata.maxPageSize
glAccounts_freightSubaccount_metadata_totalCount int64 itgen_vnet_glaccounts_freightsubaccount_metadata_totalcount filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.metadata.totalCount
glAccounts_freightSubaccount_subaccountId int32 itgen_vnet_glaccounts_freightsubaccount_subaccountid filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.subaccountId SubID > The identifier of the subaccount.
glAccounts_freightSubaccount_subaccountNumber varchar2 itgen_vnet_glaccounts_freightsubaccount_subaccountnumber filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
glAccounts_freightSubaccount_timeStamp blob itgen_vnet_glaccounts_freightsubaccount_timestamp filters on the platform, writable, ::ancestor.glAccounts.freightSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
glAccounts_prepaymentAccount_description varchar2 itgen_vnet_glaccounts_prepaymentaccount_description filters on the platform, writable, ::ancestor.glAccounts.prepaymentAccount.description Name of item/description
glAccounts_prepaymentAccount_number varchar2 itgen_vnet_glaccounts_prepaymentaccount_number filters on the platform, writable, ::ancestor.glAccounts.prepaymentAccount.number Number of item
glAccounts_prepaymentAccount_type varchar2 itgen_vnet_glaccounts_prepaymentaccount_type filters on the platform, writable, ::ancestor.glAccounts.prepaymentAccount.type
glAccounts_prepaymentSubaccount_active char itgen_vnet_glaccounts_prepaymentsubaccount_active filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.active Active > The status of the identifier.
glAccounts_prepaymentSubaccount_description varchar2 itgen_vnet_glaccounts_prepaymentsubaccount_description filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.description Description > The description of the identifier.
glAccounts_prepaymentSubaccount_errorInfo varchar2 itgen_vnet_glaccounts_prepaymentsubaccount_errorinfo filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.errorInfo
glAccounts_prepaymentSubaccount_lastModifiedDateTime datetime itgen_vnet_glaccounts_prepaymentsubaccount_lastmodifieddatetime filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.lastModifiedDateTime System generated information.
glAccounts_prepaymentSubaccount_metadata_maxPageSize int64 itgen_vnet_glaccounts_prepaymentsubaccount_metadata_maxpagesize filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.metadata.maxPageSize
glAccounts_prepaymentSubaccount_metadata_totalCount int64 itgen_vnet_glaccounts_prepaymentsubaccount_metadata_totalcount filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.metadata.totalCount
glAccounts_prepaymentSubaccount_subaccountId int32 itgen_vnet_glaccounts_prepaymentsubaccount_subaccountid filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.subaccountId SubID > The identifier of the subaccount.
glAccounts_prepaymentSubaccount_subaccountNumber varchar2 itgen_vnet_glaccounts_prepaymentsubaccount_subaccountnumber filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
glAccounts_prepaymentSubaccount_timeStamp blob itgen_vnet_glaccounts_prepaymentsubaccount_timestamp filters on the platform, writable, ::ancestor.glAccounts.prepaymentSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
glAccounts_salesAccount_description varchar2 Sales Account Description filters on the platform, writable, ::ancestor.glAccounts.salesAccount.description Name of item/description
glAccounts_salesAccount_number varchar2 Sales Account Number filters on the platform, writable, ::ancestor.glAccounts.salesAccount.number Number of item
glAccounts_salesAccount_type varchar2 Sales Account Type filters on the platform, writable, ::ancestor.glAccounts.salesAccount.type
glAccounts_salesEuAccount_description varchar2 itgen_vnet_glaccounts_saleseuaccount_description filters on the platform, writable, ::ancestor.glAccounts.salesEuAccount.description Name of item/description
glAccounts_salesEuAccount_number varchar2 itgen_vnet_glaccounts_saleseuaccount_number filters on the platform, writable, ::ancestor.glAccounts.salesEuAccount.number Number of item
glAccounts_salesEuAccount_type varchar2 itgen_vnet_glaccounts_saleseuaccount_type filters on the platform, writable, ::ancestor.glAccounts.salesEuAccount.type
glAccounts_salesExportAccount_description varchar2 itgen_vnet_glaccounts_salesexportaccount_description filters on the platform, writable, ::ancestor.glAccounts.salesExportAccount.description Name of item/description
glAccounts_salesExportAccount_number varchar2 itgen_vnet_glaccounts_salesexportaccount_number filters on the platform, writable, ::ancestor.glAccounts.salesExportAccount.number Number of item
glAccounts_salesExportAccount_type varchar2 itgen_vnet_glaccounts_salesexportaccount_type filters on the platform, writable, ::ancestor.glAccounts.salesExportAccount.type
glAccounts_salesNonTaxableAccount_description varchar2 itgen_vnet_glaccounts_salesnontaxableaccount_description filters on the platform, writable, ::ancestor.glAccounts.salesNonTaxableAccount.description Name of item/description
glAccounts_salesNonTaxableAccount_number varchar2 itgen_vnet_glaccounts_salesnontaxableaccount_number filters on the platform, writable, ::ancestor.glAccounts.salesNonTaxableAccount.number Number of item
glAccounts_salesNonTaxableAccount_type varchar2 itgen_vnet_glaccounts_salesnontaxableaccount_type filters on the platform, writable, ::ancestor.glAccounts.salesNonTaxableAccount.type
glAccounts_salesSubaccount_active char itgen_vnet_glaccounts_salessubaccount_active filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.active Active > The status of the identifier.
glAccounts_salesSubaccount_description varchar2 itgen_vnet_glaccounts_salessubaccount_description filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.description Description > The description of the identifier.
glAccounts_salesSubaccount_errorInfo varchar2 itgen_vnet_glaccounts_salessubaccount_errorinfo filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.errorInfo
glAccounts_salesSubaccount_lastModifiedDateTime datetime itgen_vnet_glaccounts_salessubaccount_lastmodifieddatetime filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.lastModifiedDateTime System generated information.
glAccounts_salesSubaccount_metadata_maxPageSize int64 itgen_vnet_glaccounts_salessubaccount_metadata_maxpagesize filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.metadata.maxPageSize
glAccounts_salesSubaccount_metadata_totalCount int64 itgen_vnet_glaccounts_salessubaccount_metadata_totalcount filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.metadata.totalCount
glAccounts_salesSubaccount_subaccountId int32 itgen_vnet_glaccounts_salessubaccount_subaccountid filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.subaccountId SubID > The identifier of the subaccount.
glAccounts_salesSubaccount_subaccountNumber varchar2 itgen_vnet_glaccounts_salessubaccount_subaccountnumber filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
glAccounts_salesSubaccount_timeStamp blob itgen_vnet_glaccounts_salessubaccount_timestamp filters on the platform, writable, ::ancestor.glAccounts.salesSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
gln varchar2 GLN filters on the platform, writable, ::ancestor.gln Delivery settings tab > Default location settings section > GLN > The Global Location Number, associated with the location.
id varchar2 ID writable, id
internalId int32 Internal ID filters on the platform, writable, ::ancestor.internalId
invoiceAddress_addressId int32 Invoice Address ID filters on the platform, writable, ::ancestor.invoiceAddress.addressId
invoiceAddress_addressLine1 varchar2 Invoice Address Line 1 filters on the platform, writable, ::ancestor.invoiceAddress.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
invoiceAddress_addressLine2 varchar2 Invoice Address Line 2 filters on the platform, writable, ::ancestor.invoiceAddress.addressLine2 Address 2 > The second line of the address.
invoiceAddress_addressLine3 varchar2 Invoice Address Line 3 filters on the platform, writable, ::ancestor.invoiceAddress.addressLine3 Address 3 > The third line of the address.
invoiceAddress_city varchar2 Invoice Address City filters on the platform, writable, ::ancestor.invoiceAddress.city City > The city.
invoiceAddress_country_errorInfo varchar2 Invoice Address Country Error Information filters on the platform, writable, ::ancestor.invoiceAddress.country.errorInfo
invoiceAddress_country_id varchar2 Invoice Address Country ID filters on the platform, writable, ::ancestor.invoiceAddress.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
invoiceAddress_country_metadata_maxPageSize int64 itgen_vnet_invoiceaddress_country_metadata_maxpagesize filters on the platform, writable, ::ancestor.invoiceAddress.country.metadata.maxPageSize
invoiceAddress_country_metadata_totalCount int64 itgen_vnet_invoiceaddress_country_metadata_totalcount filters on the platform, writable, ::ancestor.invoiceAddress.country.metadata.totalCount
invoiceAddress_country_name varchar2 Invoice Address Country Name filters on the platform, writable, ::ancestor.invoiceAddress.country.name Mandatory field: Country name* > The complete name of the country.
invoiceAddress_county_id varchar2 Invoice Address County ID filters on the platform, writable, ::ancestor.invoiceAddress.county.id Click the magnifier > The identifier
invoiceAddress_county_name varchar2 Invoice Address County Name filters on the platform, writable, ::ancestor.invoiceAddress.county.name Click the magnifier > The displayed name
invoiceAddress_postalCode varchar2 Invoice Address Postal Code filters on the platform, writable, ::ancestor.invoiceAddress.postalCode Postcode > The postcode.
invoiceContact_attention varchar2 Invoice Contact Attention filters on the platform, writable, ::ancestor.invoiceContact.attention Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.
invoiceContact_contactId int32 Invoice Contact ID filters on the platform, writable, ::ancestor.invoiceContact.contactId
invoiceContact_email varchar2 Invoice Contact Email Address filters on the platform, writable, ::ancestor.invoiceContact.email Email > The email address of the customer/supplier/company as a business entity.
invoiceContact_fax varchar2 Invoice Contact Fax filters on the platform, writable, ::ancestor.invoiceContact.fax Fax > The fax number.
invoiceContact_name varchar2 Invoice Contact Name filters on the platform, writable, ::ancestor.invoiceContact.name Name > The legal name of to appear on the documents.
invoiceContact_phone1 varchar2 Invoice Contact Phone 1 filters on the platform, writable, ::ancestor.invoiceContact.phone1 Phone 1 > The default phone number.
invoiceContact_phone2 varchar2 Invoice Contact Phone 2 filters on the platform, writable, ::ancestor.invoiceContact.phone2 Phone 2 > An additional phone number.
invoiceContact_web varchar2 Invoice Contact Website filters on the platform, writable, ::ancestor.invoiceContact.web Web > The website of the company, if one exists.
invoiceOrdersSeparately char itgen_vnet_invoiceordersseparately filters on the platform, writable, ::ancestor.invoiceOrdersSeparately The Billing settings tab > Order consolidation section > Invoice orders separately > Indicates whether the customer should be invoiced separately.
invoiceToDefaultLocation char Invoice to Default Location filters on the platform, writable, ::ancestor.invoiceToDefaultLocation Delivery settings tab > Default location settings > Invoice to default location > A check box indicating that the default location is to be used.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.lastModifiedDateTime Information collected from the system. Not visible on the screen.
location_countryId varchar2 Location Country ID filters on the platform, writable, ::ancestor.location.countryId Location*.
location_id varchar2 Location ID filters on the platform, writable, ::ancestor.location.id Click the magnifier > The identifier
location_name varchar2 Location Name filters on the platform, writable, ::ancestor.location.name Click the magnifier > The displayed name
mainAddress_addressId int32 Main Address ID filters on the platform, writable, ::ancestor.mainAddress.addressId
mainAddress_addressLine1 varchar2 Main Address Line 1 filters on the platform, writable, ::ancestor.mainAddress.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
mainAddress_addressLine2 varchar2 Main Address Line 2 filters on the platform, writable, ::ancestor.mainAddress.addressLine2 Address 2 > The second line of the address.
mainAddress_addressLine3 varchar2 Main Address Line 3 filters on the platform, writable, ::ancestor.mainAddress.addressLine3 Address 3 > The third line of the address.
mainAddress_city varchar2 Main Address City filters on the platform, writable, ::ancestor.mainAddress.city City > The city.
mainAddress_country_errorInfo varchar2 itgen_vnet_mainaddress_country_errorinfo filters on the platform, writable, ::ancestor.mainAddress.country.errorInfo
mainAddress_country_id varchar2 Main Address Country ID filters on the platform, writable, ::ancestor.mainAddress.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
mainAddress_country_metadata_maxPageSize int64 itgen_vnet_mainaddress_country_metadata_maxpagesize filters on the platform, writable, ::ancestor.mainAddress.country.metadata.maxPageSize
mainAddress_country_metadata_totalCount int64 itgen_vnet_mainaddress_country_metadata_totalcount filters on the platform, writable, ::ancestor.mainAddress.country.metadata.totalCount
mainAddress_country_name varchar2 Main Address Country Name filters on the platform, writable, ::ancestor.mainAddress.country.name Mandatory field: Country name* > The complete name of the country.
mainAddress_county_id varchar2 Main Address County ID filters on the platform, writable, ::ancestor.mainAddress.county.id Click the magnifier > The identifier
mainAddress_county_name varchar2 Main Address County Name filters on the platform, writable, ::ancestor.mainAddress.county.name Click the magnifier > The displayed name
mainAddress_postalCode varchar2 Main Address Postal Code filters on the platform, writable, ::ancestor.mainAddress.postalCode Postcode > The postcode.
mainContact_attention varchar2 Main Contact Attention filters on the platform, writable, ::ancestor.mainContact.attention Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.
mainContact_contactId int32 Main Contact ID filters on the platform, writable, ::ancestor.mainContact.contactId
mainContact_email varchar2 Main Contact Email Address filters on the platform, writable, ::ancestor.mainContact.email Email > The email address of the customer/supplier/company as a business entity.
mainContact_fax varchar2 Fax filters on the platform, writable, ::ancestor.mainContact.fax Fax > The fax number.
mainContact_name varchar2 Main Contact Name filters on the platform, writable, ::ancestor.mainContact.name Name > The legal name of to appear on the documents.
mainContact_phone1 varchar2 Main Contact Phone 1 filters on the platform, writable, ::ancestor.mainContact.phone1 Phone 1 > The default phone number.
mainContact_phone2 varchar2 Main Contact Phone 2 filters on the platform, writable, ::ancestor.mainContact.phone2 Phone 2 > An additional phone number.
mainContact_web varchar2 Main Contact Website filters on the platform, writable, ::ancestor.mainContact.web Web > The website of the company, if one exists.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, ::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, ::ancestor.metadata.totalCount
name varchar2 Name filters on the platform, writable, ::ancestor.name Mandatory field: The top part > Customer name* > The name of the customer to appear in the system, which may be a trade name or a doing-business-as (DBA) name.
number varchar2 Number filters on the platform, writable, ::ancestor.number Mandatory field: The top part > Customer ID* > The ID of the customer account, which is defined by the BIZACCT segmented key or by the CUSTOMER segmented key. When you are creating a new customer, you must specify an ID.
numberOfEmployees int32 Number of Employees filters on the platform, writable, ::ancestor.numberOfEmployees Legal requirements that all companies with more than 250 employees keep track of their business accounts
parentRecord_name varchar2 Parent Record Name filters on the platform, writable, ::ancestor.parentRecord.name Click the magnifier. > The name.
parentRecord_number varchar2 Parent Record Number filters on the platform, writable, ::ancestor.parentRecord.number Click the magnifier. > The identifier.
priceClass_description varchar2 Price Class Description filters on the platform, writable, ::ancestor.priceClass.description Click on the magnifier. > The description.
priceClass_id varchar2 Price Class ID filters on the platform, writable, ::ancestor.priceClass.id Click on the magnifier. > The identifier.
printDunningLetters char Print Dunning Letters filters on the platform, writable, ::ancestor.printDunningLetters Invoicing settings > Email settings section > A check box that, if selected, indicates that statements can be send to email (AR503500) window.
printInvoices char Print Invoices filters on the platform, writable, ::ancestor.printInvoices Invoicing settings > Print and email settings section > Print invoices > A check box that, if selected, indicates that invoices can be printed in the Print invoice (AR508000) window.
printMultiCurrencyStatements char Print Multi-Currency Statements filters on the platform, writable, ::ancestor.printMultiCurrencyStatements Invoicing settings > Print and email settings section > Multi-currency statements > A check box that indicates (if selected) that this customer's statements must be printed in multi-currency format.
printStatements char Print Statements filters on the platform, writable, ::ancestor.printStatements Invoicing settings > Print settings section > A check box that, if selected, indicates that statements can be printed in the to email (AR503500) window.
sendDunningLettersViaEMail char Send Dunning Letters via Email filters on the platform, writable, ::ancestor.sendDunningLettersViaEMail Invoicing settings > Print and email settings section > Print statements > A check box that, if selected, indicates that statements can be printed in the Print statements (AR503500) window.
sendInvoicesByEmail char Send Invoices by Email filters on the platform, writable, ::ancestor.sendInvoicesByEmail Invoicing settings > Print and email settings section > Send invoices by email > A check box that, if selected, indicates that you can send invoices by email by using the Print invoices (AR508000) window.
sendStatementsByEmail char Send Statements by Email filters on the platform, writable, ::ancestor.sendStatementsByEmail Invoicing settings > Print and email settings section > Send statement by email > A check box that, if selected, indicates that statements can be sent by email to customers of the class in the Print statements (AR503500) window.
statementType varchar2 Statement Type filters on the platform, writable, ::ancestor.statementType Invoicing settings > Print and email settings section > Statement type > The statement type used by default in relations with the customer, which can be one of the following: Open item, Balance brought forward.
status varchar2 Status filters on the platform, writable, ::ancestor.status Mandatory field: The top part > Status* > The status of the customer account. You can select one of the following options: Active, On hold, Credit hold, Inactive, One time.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)
value varchar2 Value writable, value Value > The value of the attribute.
vatRegistrationId varchar2 VAT Registration ID filters on the platform, writable, ::ancestor.vatRegistrationId Deliver settings tab > Default location settings section > VAT registration ID > The customer's taxpayer ID associated with the location.
vatZone_defaultTaxCategory_description varchar2 VAT Zone Default Tax Category Description filters on the platform, writable, ::ancestor.vatZone.defaultTaxCategory.description Name of item/description
vatZone_defaultTaxCategory_number varchar2 VAT Zone Default Tax Category Number filters on the platform, writable, ::ancestor.vatZone.defaultTaxCategory.number Number of item
vatZone_defaultVatCategory varchar2 VAT Zone Default VAT Category filters on the platform, writable, ::ancestor.vatZone.defaultVatCategory Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_description varchar2 VAT Zone Description filters on the platform, writable, ::ancestor.vatZone.description Click the magnifier. The description for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_errorInfo varchar2 itgen_vnet_vatzone_errorinfo filters on the platform, writable, ::ancestor.vatZone.errorInfo
vatZone_id varchar2 VAT Zone ID filters on the platform, writable, ::ancestor.vatZone.id Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the AP303000 window.
vatZone_metadata_maxPageSize int64 itgen_vnet_vatzone_metadata_maxpagesize filters on the platform, writable, ::ancestor.vatZone.metadata.maxPageSize
vatZone_metadata_totalCount int64 itgen_vnet_vatzone_metadata_totalcount filters on the platform, writable, ::ancestor.vatZone.metadata.totalCount

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: