invantive documentation
Invantive Support ForumsLog In / Sign Up

CustomerGlAccountPrepaymentSubaccountSegments: Visma.net Financials Customer GL Account Prepayment Subaccount Segments

read only REST

  • Catalog: VismaNet
  • Schema: Customer
  • Label: Customer GL Account Prepayment Subaccount Segments

Get a range of customers - ScreenId=AR303000

Can only retrieve data.

API Source

  • Endpoint: /v1/customer
  • Operation: get /v1/customer

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
attributes `` Attributes (additional information) connected to the entity. Examples: {{base}}/customer?attributes={"AttributeID":"ValueID","AttributeID":"ValueID"} {{base}}/customer?attributes={"AttributeID":"ValueID1,ValueID2"}
corporateId `` Equals Corporate ID from Delivery settings tab.
createdDateTime `` This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
createdDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
email `` Equals Email for customer.
expandAccountInformation ``
expandDirectDebit `` Expand direct debit info
expandPaymentMethods ``
greaterThanValue `` This field does not work and has been deprecated. It will be removed in future versions.
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
name `` Contains Customer name.
phone `` Equals Phone 1 for customer.
status `` Drop down and select Status. (Values: Active, OnHold, CreditHold, Inactive, OneTime)
vatRegistrationId `` Equals VAT registration ID from Delivery settings tab.

Table Columns

The columns of the table CustomerGlAccountPrepaymentSubaccountSegments 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.::ancestor.::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.::ancestor.::ancestor.accountReference General information tab > Main contact section > Account ref. > Your company's account number in the customer's system.
active char Active writable, ::ancestor.active Active > The status of the identifier.
cashDiscountAccount_description varchar2 itgen_vnet_cashdiscountaccount_description writable, ::ancestor.::ancestor.cashDiscountAccount.description Name of item/description
cashDiscountAccount_number varchar2 itgen_vnet_cashdiscountaccount_number writable, ::ancestor.::ancestor.cashDiscountAccount.number Number of item
cashDiscountAccount_type varchar2 itgen_vnet_cashdiscountaccount_type writable, ::ancestor.::ancestor.cashDiscountAccount.type
cashDiscountSubaccount_active char itgen_vnet_cashdiscountsubaccount_active writable, ::ancestor.::ancestor.cashDiscountSubaccount.active Active > The status of the identifier.
cashDiscountSubaccount_description varchar2 itgen_vnet_cashdiscountsubaccount_description writable, ::ancestor.::ancestor.cashDiscountSubaccount.description Description > The description of the identifier.
cashDiscountSubaccount_errorInfo varchar2 itgen_vnet_cashdiscountsubaccount_errorinfo writable, ::ancestor.::ancestor.cashDiscountSubaccount.errorInfo
cashDiscountSubaccount_lastModifiedDateTime datetime itgen_vnet_cashdiscountsubaccount_lastmodifieddatetime writable, ::ancestor.::ancestor.cashDiscountSubaccount.lastModifiedDateTime System generated information.
cashDiscountSubaccount_metadata_maxPageSize int64 itgen_vnet_cashdiscountsubaccount_metadata_maxpagesize writable, ::ancestor.::ancestor.cashDiscountSubaccount.metadata.maxPageSize
cashDiscountSubaccount_metadata_totalCount int64 itgen_vnet_cashdiscountsubaccount_metadata_totalcount writable, ::ancestor.::ancestor.cashDiscountSubaccount.metadata.totalCount
cashDiscountSubaccount_segmentDescription varchar2 itgen_vnet_cashdiscountsubaccount_segmentdescription writable, ::ancestor.::ancestor.cashDiscountSubaccount.segments[*].segmentDescription The Segment values window > The Top part > The description of the segment.
cashDiscountSubaccount_segmentId int32 itgen_vnet_cashdiscountsubaccount_segmentid writable, ::ancestor.::ancestor.cashDiscountSubaccount.segments[*].segmentId The Segment values window > The Top part > The ID of the segment.
cashDiscountSubaccount_segmentValue varchar2 itgen_vnet_cashdiscountsubaccount_segmentvalue writable, ::ancestor.::ancestor.cashDiscountSubaccount.segments[*].segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
cashDiscountSubaccount_segmentValueDescription varchar2 itgen_vnet_cashdiscountsubaccount_segmentvaluedescription writable, ::ancestor.::ancestor.cashDiscountSubaccount.segments[*].segmentValueDescription The Segment values window > The table > The description of the segment value.
cashDiscountSubaccount_subaccountId int32 itgen_vnet_cashdiscountsubaccount_subaccountid writable, ::ancestor.::ancestor.cashDiscountSubaccount.subaccountId SubID > The identifier of the subaccount.
cashDiscountSubaccount_subaccountNumber varchar2 itgen_vnet_cashdiscountsubaccount_subaccountnumber writable, ::ancestor.::ancestor.cashDiscountSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
cashDiscountSubaccount_timeStamp blob itgen_vnet_cashdiscountsubaccount_timestamp writable, ::ancestor.::ancestor.cashDiscountSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
corporateId varchar2 Corporate ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.createdDateTime Information collected from the system. Not visible on the screen.
creditDaysPastDue int32 Credit Days Past Due filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.creditTerms.description Click on the magnifier. > The description.
creditTerms_id varchar2 Credit Terms ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.creditTerms.id Click on the magnifier. > The identifier.
creditVerification varchar2 Credit Verification filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.customerClass.description Click on the magnifier. > The description.
customerClass_id varchar2 Customer Class ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.customerClass.id Click on the magnifier. > The identifier.
customerLedgerAccount_description varchar2 itgen_vnet_customerledgeraccount_description writable, ::ancestor.::ancestor.customerLedgerAccount.description Name of item/description
customerLedgerAccount_number varchar2 itgen_vnet_customerledgeraccount_number writable, ::ancestor.::ancestor.customerLedgerAccount.number Number of item
customerLedgerAccount_type varchar2 itgen_vnet_customerledgeraccount_type writable, ::ancestor.::ancestor.customerLedgerAccount.type
customerLedgerSubaccount_active char itgen_vnet_customerledgersubaccount_active writable, ::ancestor.::ancestor.customerLedgerSubaccount.active Active > The status of the identifier.
customerLedgerSubaccount_description varchar2 itgen_vnet_customerledgersubaccount_description writable, ::ancestor.::ancestor.customerLedgerSubaccount.description Description > The description of the identifier.
customerLedgerSubaccount_errorInfo varchar2 itgen_vnet_customerledgersubaccount_errorinfo writable, ::ancestor.::ancestor.customerLedgerSubaccount.errorInfo
customerLedgerSubaccount_lastModifiedDateTime datetime itgen_vnet_customerledgersubaccount_lastmodifieddatetime writable, ::ancestor.::ancestor.customerLedgerSubaccount.lastModifiedDateTime System generated information.
customerLedgerSubaccount_metadata_maxPageSize int64 itgen_vnet_customerledgersubaccount_metadata_maxpagesize writable, ::ancestor.::ancestor.customerLedgerSubaccount.metadata.maxPageSize
customerLedgerSubaccount_metadata_totalCount int64 itgen_vnet_customerledgersubaccount_metadata_totalcount writable, ::ancestor.::ancestor.customerLedgerSubaccount.metadata.totalCount
customerLedgerSubaccount_segmentDescription varchar2 itgen_vnet_customerledgersubaccount_segmentdescription writable, ::ancestor.::ancestor.customerLedgerSubaccount.segments[*].segmentDescription The Segment values window > The Top part > The description of the segment.
customerLedgerSubaccount_segmentId int32 itgen_vnet_customerledgersubaccount_segmentid writable, ::ancestor.::ancestor.customerLedgerSubaccount.segments[*].segmentId The Segment values window > The Top part > The ID of the segment.
customerLedgerSubaccount_segmentValue varchar2 itgen_vnet_customerledgersubaccount_segmentvalue writable, ::ancestor.::ancestor.customerLedgerSubaccount.segments[*].segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
customerLedgerSubaccount_segmentValueDescription varchar2 itgen_vnet_customerledgersubaccount_segmentvaluedescription writable, ::ancestor.::ancestor.customerLedgerSubaccount.segments[*].segmentValueDescription The Segment values window > The table > The description of the segment value.
customerLedgerSubaccount_subaccountId int32 itgen_vnet_customerledgersubaccount_subaccountid writable, ::ancestor.::ancestor.customerLedgerSubaccount.subaccountId SubID > The identifier of the subaccount.
customerLedgerSubaccount_subaccountNumber varchar2 itgen_vnet_customerledgersubaccount_subaccountnumber writable, ::ancestor.::ancestor.customerLedgerSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
customerLedgerSubaccount_timeStamp blob itgen_vnet_customerledgersubaccount_timestamp writable, ::ancestor.::ancestor.customerLedgerSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
defaultPaymentMethodId varchar2 itgen_vnet_defaultpaymentmethodid filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryAddress.addressId
deliveryAddress_addressLine1 varchar2 Delivery Address Line 1 filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryAddress.addressLine2 Address 2 > The second line of the address.
deliveryAddress_addressLine3 varchar2 Delivery Address Line 3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryAddress.addressLine3 Address 3 > The third line of the address.
deliveryAddress_city varchar2 Delivery Address City filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryAddress.city City > The city.
deliveryAddress_country_errorInfo varchar2 itgen_vnet_deliveryaddress_country_errorinfo filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryAddress.country.errorInfo
deliveryAddress_country_id varchar2 Delivery Address Country ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryAddress.country.metadata.maxPageSize
deliveryAddress_country_metadata_totalCount int64 itgen_vnet_deliveryaddress_country_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryAddress.country.metadata.totalCount
deliveryAddress_country_name varchar2 Delivery Address Country Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryAddress.county.id Click the magnifier > The identifier
deliveryAddress_county_name varchar2 Delivery Address County Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryAddress.county.name Click the magnifier > The displayed name
deliveryAddress_postalCode varchar2 Delivery Address Postal Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryAddress.postalCode Postcode > The postcode.
deliveryContact_attention varchar2 Delivery Contact Attention filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryContact.contactId
deliveryContact_email varchar2 Delivery Contact Email Address filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryContact.fax Fax > The fax number.
deliveryContact_name varchar2 Delivery Contact Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.deliveryContact.phone1 Phone 1 > The default phone number.
deliveryContact_phone2 varchar2 Delivery Contact Phone 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryContact.phone2 Phone 2 > An additional phone number.
deliveryContact_web varchar2 Delivery Contact Website filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryContact.web Web > The website of the company, if one exists.
description varchar2 Description writable, ::ancestor.description Description > The description of the identifier.
discountAccount_description varchar2 itgen_vnet_discountaccount_description writable, ::ancestor.::ancestor.discountAccount.description Name of item/description
discountAccount_number varchar2 itgen_vnet_discountaccount_number writable, ::ancestor.::ancestor.discountAccount.number Number of item
discountAccount_type varchar2 itgen_vnet_discountaccount_type writable, ::ancestor.::ancestor.discountAccount.type
discountSubaccount_active char itgen_vnet_discountsubaccount_active writable, ::ancestor.::ancestor.discountSubaccount.active Active > The status of the identifier.
discountSubaccount_description varchar2 itgen_vnet_discountsubaccount_description writable, ::ancestor.::ancestor.discountSubaccount.description Description > The description of the identifier.
discountSubaccount_errorInfo varchar2 itgen_vnet_discountsubaccount_errorinfo writable, ::ancestor.::ancestor.discountSubaccount.errorInfo
discountSubaccount_lastModifiedDateTime datetime itgen_vnet_discountsubaccount_lastmodifieddatetime writable, ::ancestor.::ancestor.discountSubaccount.lastModifiedDateTime System generated information.
discountSubaccount_metadata_maxPageSize int64 itgen_vnet_discountsubaccount_metadata_maxpagesize writable, ::ancestor.::ancestor.discountSubaccount.metadata.maxPageSize
discountSubaccount_metadata_totalCount int64 itgen_vnet_discountsubaccount_metadata_totalcount writable, ::ancestor.::ancestor.discountSubaccount.metadata.totalCount
discountSubaccount_segmentDescription varchar2 itgen_vnet_discountsubaccount_segmentdescription writable, ::ancestor.::ancestor.discountSubaccount.segments[*].segmentDescription The Segment values window > The Top part > The description of the segment.
discountSubaccount_segmentId int32 itgen_vnet_discountsubaccount_segmentid writable, ::ancestor.::ancestor.discountSubaccount.segments[*].segmentId The Segment values window > The Top part > The ID of the segment.
discountSubaccount_segmentValue varchar2 itgen_vnet_discountsubaccount_segmentvalue writable, ::ancestor.::ancestor.discountSubaccount.segments[*].segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
discountSubaccount_segmentValueDescription varchar2 itgen_vnet_discountsubaccount_segmentvaluedescription writable, ::ancestor.::ancestor.discountSubaccount.segments[*].segmentValueDescription The Segment values window > The table > The description of the segment value.
discountSubaccount_subaccountId int32 itgen_vnet_discountsubaccount_subaccountid writable, ::ancestor.::ancestor.discountSubaccount.subaccountId SubID > The identifier of the subaccount.
discountSubaccount_subaccountNumber varchar2 itgen_vnet_discountsubaccount_subaccountnumber writable, ::ancestor.::ancestor.discountSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
discountSubaccount_timeStamp blob itgen_vnet_discountsubaccount_timestamp writable, ::ancestor.::ancestor.discountSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
eInvoiceContract_fInvoiceContractID varchar2 itgen_vnet_einvoicecontract_finvoicecontractid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.eInvoiceContract.fInvoiceContractID
eInvoiceContract_fInvoiceIntermediatorID varchar2 itgen_vnet_einvoicecontract_finvoiceintermediatorid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.eInvoiceContract.fInvoiceIntermediatorID
errorInfo varchar2 Error Message writable, ::ancestor.errorInfo
errorInfo_2 varchar2 Error Information 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.errorInfo
excludeDebtCollection char itgen_vnet_excludedebtcollection filters on the platform, writable, ::ancestor.::ancestor.::ancestor.excludeDebtCollection Exclude Debt Collection for Autocollect
freightAccount_description varchar2 itgen_vnet_freightaccount_description writable, ::ancestor.::ancestor.freightAccount.description Name of item/description
freightAccount_number varchar2 itgen_vnet_freightaccount_number writable, ::ancestor.::ancestor.freightAccount.number Number of item
freightAccount_type varchar2 itgen_vnet_freightaccount_type writable, ::ancestor.::ancestor.freightAccount.type
freightSubaccount_active char itgen_vnet_freightsubaccount_active writable, ::ancestor.::ancestor.freightSubaccount.active Active > The status of the identifier.
freightSubaccount_description varchar2 itgen_vnet_freightsubaccount_description writable, ::ancestor.::ancestor.freightSubaccount.description Description > The description of the identifier.
freightSubaccount_errorInfo varchar2 itgen_vnet_freightsubaccount_errorinfo writable, ::ancestor.::ancestor.freightSubaccount.errorInfo
freightSubaccount_lastModifiedDateTime datetime itgen_vnet_freightsubaccount_lastmodifieddatetime writable, ::ancestor.::ancestor.freightSubaccount.lastModifiedDateTime System generated information.
freightSubaccount_metadata_maxPageSize int64 itgen_vnet_freightsubaccount_metadata_maxpagesize writable, ::ancestor.::ancestor.freightSubaccount.metadata.maxPageSize
freightSubaccount_metadata_totalCount int64 itgen_vnet_freightsubaccount_metadata_totalcount writable, ::ancestor.::ancestor.freightSubaccount.metadata.totalCount
freightSubaccount_segmentDescription varchar2 itgen_vnet_freightsubaccount_segmentdescription writable, ::ancestor.::ancestor.freightSubaccount.segments[*].segmentDescription The Segment values window > The Top part > The description of the segment.
freightSubaccount_segmentId int32 itgen_vnet_freightsubaccount_segmentid writable, ::ancestor.::ancestor.freightSubaccount.segments[*].segmentId The Segment values window > The Top part > The ID of the segment.
freightSubaccount_segmentValue varchar2 itgen_vnet_freightsubaccount_segmentvalue writable, ::ancestor.::ancestor.freightSubaccount.segments[*].segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
freightSubaccount_segmentValueDescription varchar2 itgen_vnet_freightsubaccount_segmentvaluedescription writable, ::ancestor.::ancestor.freightSubaccount.segments[*].segmentValueDescription The Segment values window > The table > The description of the segment value.
freightSubaccount_subaccountId int32 itgen_vnet_freightsubaccount_subaccountid writable, ::ancestor.::ancestor.freightSubaccount.subaccountId SubID > The identifier of the subaccount.
freightSubaccount_subaccountNumber varchar2 itgen_vnet_freightsubaccount_subaccountnumber writable, ::ancestor.::ancestor.freightSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
freightSubaccount_timeStamp blob itgen_vnet_freightsubaccount_timestamp writable, ::ancestor.::ancestor.freightSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
gln varchar2 GLN filters on the platform, writable, ::ancestor.::ancestor.::ancestor.gln Delivery settings tab > Default location settings section > GLN > The Global Location Number, associated with the location.
internalId int32 Internal ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.internalId
invoiceAddress_addressId int32 Invoice Address ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.addressId
invoiceAddress_addressLine1 varchar2 Invoice Address Line 1 filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.invoiceAddress.addressLine2 Address 2 > The second line of the address.
invoiceAddress_addressLine3 varchar2 Invoice Address Line 3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.addressLine3 Address 3 > The third line of the address.
invoiceAddress_city varchar2 Invoice Address City filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.city City > The city.
invoiceAddress_country_errorInfo varchar2 Invoice Address Country Error Information filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.country.errorInfo
invoiceAddress_country_id varchar2 Invoice Address Country ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.invoiceAddress.country.metadata.maxPageSize
invoiceAddress_country_metadata_totalCount int64 itgen_vnet_invoiceaddress_country_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.country.metadata.totalCount
invoiceAddress_country_name varchar2 Invoice Address Country Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.invoiceAddress.county.id Click the magnifier > The identifier
invoiceAddress_county_name varchar2 Invoice Address County Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.county.name Click the magnifier > The displayed name
invoiceAddress_postalCode varchar2 Invoice Address Postal Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceAddress.postalCode Postcode > The postcode.
invoiceContact_attention varchar2 Invoice Contact Attention filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.invoiceContact.contactId
invoiceContact_email varchar2 Invoice Contact Email Address filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.invoiceContact.fax Fax > The fax number.
invoiceContact_name varchar2 Invoice Contact Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.invoiceContact.phone1 Phone 1 > The default phone number.
invoiceContact_phone2 varchar2 Invoice Contact Phone 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.phone2 Phone 2 > An additional phone number.
invoiceContact_web varchar2 Invoice Contact Website filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.web Web > The website of the company, if one exists.
invoiceOrdersSeparately char itgen_vnet_invoiceordersseparately filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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 writable, ::ancestor.lastModifiedDateTime System generated information.
lastModifiedDateTime_2 datetime Last Modified Date/Time 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.lastModifiedDateTime Information collected from the system. Not visible on the screen.
location_countryId varchar2 Location Country ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.location.countryId Location*.
location_id varchar2 Location ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.location.id Click the magnifier > The identifier
location_name varchar2 Location Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.location.name Click the magnifier > The displayed name
mainAddress_addressId int32 Main Address ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.addressId
mainAddress_addressLine1 varchar2 Main Address Line 1 filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.mainAddress.addressLine2 Address 2 > The second line of the address.
mainAddress_addressLine3 varchar2 Main Address Line 3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.addressLine3 Address 3 > The third line of the address.
mainAddress_city varchar2 Main Address City filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.city City > The city.
mainAddress_country_errorInfo varchar2 itgen_vnet_mainaddress_country_errorinfo filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.country.errorInfo
mainAddress_country_id varchar2 Main Address Country ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.mainAddress.country.metadata.maxPageSize
mainAddress_country_metadata_totalCount int64 itgen_vnet_mainaddress_country_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.country.metadata.totalCount
mainAddress_country_name varchar2 Main Address Country Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.mainAddress.county.id Click the magnifier > The identifier
mainAddress_county_name varchar2 Main Address County Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.county.name Click the magnifier > The displayed name
mainAddress_postalCode varchar2 Main Address Postal Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainAddress.postalCode Postcode > The postcode.
mainContact_attention varchar2 Main Contact Attention filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.mainContact.contactId
mainContact_email varchar2 Main Contact Email Address filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.mainContact.fax Fax > The fax number.
mainContact_name varchar2 Main Contact Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.mainContact.phone1 Phone 1 > The default phone number.
mainContact_phone2 varchar2 Main Contact Phone 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainContact.phone2 Phone 2 > An additional phone number.
mainContact_web varchar2 Main Contact Website filters on the platform, writable, ::ancestor.::ancestor.::ancestor.mainContact.web Web > The website of the company, if one exists.
metadata_maxPageSize int64 Metadata Max Pagesize writable, ::ancestor.metadata.maxPageSize
metadata_maxPageSize_2 int64 itgen_vnet_metadata_maxpagesize_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count writable, ::ancestor.metadata.totalCount
metadata_totalCount_2 int64 itgen_vnet_metadata_totalcount_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.metadata.totalCount
name varchar2 Name filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.parentRecord.name Click the magnifier. > The name.
parentRecord_number varchar2 Parent Record Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.parentRecord.number Click the magnifier. > The identifier.
prepaymentAccount_description varchar2 itgen_vnet_prepaymentaccount_description writable, ::ancestor.::ancestor.prepaymentAccount.description Name of item/description
prepaymentAccount_number varchar2 itgen_vnet_prepaymentaccount_number writable, ::ancestor.::ancestor.prepaymentAccount.number Number of item
prepaymentAccount_type varchar2 itgen_vnet_prepaymentaccount_type writable, ::ancestor.::ancestor.prepaymentAccount.type
priceClass_description varchar2 Price Class Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.priceClass.description Click on the magnifier. > The description.
priceClass_id varchar2 Price Class ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.priceClass.id Click on the magnifier. > The identifier.
printDunningLetters char Print Dunning Letters filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::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.::ancestor.::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.
salesAccount_description varchar2 Sales Account Description writable, ::ancestor.::ancestor.salesAccount.description Name of item/description
salesAccount_number varchar2 Sales Account Number writable, ::ancestor.::ancestor.salesAccount.number Number of item
salesAccount_type varchar2 Sales Account Type writable, ::ancestor.::ancestor.salesAccount.type
salesEuAccount_description varchar2 itgen_vnet_saleseuaccount_description writable, ::ancestor.::ancestor.salesEuAccount.description Name of item/description
salesEuAccount_number varchar2 itgen_vnet_saleseuaccount_number writable, ::ancestor.::ancestor.salesEuAccount.number Number of item
salesEuAccount_type varchar2 itgen_vnet_saleseuaccount_type writable, ::ancestor.::ancestor.salesEuAccount.type
salesExportAccount_description varchar2 itgen_vnet_salesexportaccount_description writable, ::ancestor.::ancestor.salesExportAccount.description Name of item/description
salesExportAccount_number varchar2 itgen_vnet_salesexportaccount_number writable, ::ancestor.::ancestor.salesExportAccount.number Number of item
salesExportAccount_type varchar2 itgen_vnet_salesexportaccount_type writable, ::ancestor.::ancestor.salesExportAccount.type
salesNonTaxableAccount_description varchar2 itgen_vnet_salesnontaxableaccount_description writable, ::ancestor.::ancestor.salesNonTaxableAccount.description Name of item/description
salesNonTaxableAccount_number varchar2 itgen_vnet_salesnontaxableaccount_number writable, ::ancestor.::ancestor.salesNonTaxableAccount.number Number of item
salesNonTaxableAccount_type varchar2 itgen_vnet_salesnontaxableaccount_type writable, ::ancestor.::ancestor.salesNonTaxableAccount.type
salesSubaccount_active char itgen_vnet_salessubaccount_active writable, ::ancestor.::ancestor.salesSubaccount.active Active > The status of the identifier.
salesSubaccount_description varchar2 itgen_vnet_salessubaccount_description writable, ::ancestor.::ancestor.salesSubaccount.description Description > The description of the identifier.
salesSubaccount_errorInfo varchar2 itgen_vnet_salessubaccount_errorinfo writable, ::ancestor.::ancestor.salesSubaccount.errorInfo
salesSubaccount_lastModifiedDateTime datetime itgen_vnet_salessubaccount_lastmodifieddatetime writable, ::ancestor.::ancestor.salesSubaccount.lastModifiedDateTime System generated information.
salesSubaccount_metadata_maxPageSize int64 itgen_vnet_salessubaccount_metadata_maxpagesize writable, ::ancestor.::ancestor.salesSubaccount.metadata.maxPageSize
salesSubaccount_metadata_totalCount int64 itgen_vnet_salessubaccount_metadata_totalcount writable, ::ancestor.::ancestor.salesSubaccount.metadata.totalCount
salesSubaccount_segmentDescription varchar2 itgen_vnet_salessubaccount_segmentdescription writable, ::ancestor.::ancestor.salesSubaccount.segments[*].segmentDescription The Segment values window > The Top part > The description of the segment.
salesSubaccount_segmentId int32 itgen_vnet_salessubaccount_segmentid writable, ::ancestor.::ancestor.salesSubaccount.segments[*].segmentId The Segment values window > The Top part > The ID of the segment.
salesSubaccount_segmentValue varchar2 itgen_vnet_salessubaccount_segmentvalue writable, ::ancestor.::ancestor.salesSubaccount.segments[*].segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
salesSubaccount_segmentValueDescription varchar2 itgen_vnet_salessubaccount_segmentvaluedescription writable, ::ancestor.::ancestor.salesSubaccount.segments[*].segmentValueDescription The Segment values window > The table > The description of the segment value.
salesSubaccount_subaccountId int32 itgen_vnet_salessubaccount_subaccountid writable, ::ancestor.::ancestor.salesSubaccount.subaccountId SubID > The identifier of the subaccount.
salesSubaccount_subaccountNumber varchar2 itgen_vnet_salessubaccount_subaccountnumber writable, ::ancestor.::ancestor.salesSubaccount.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
salesSubaccount_timeStamp blob itgen_vnet_salessubaccount_timestamp writable, ::ancestor.::ancestor.salesSubaccount.timeStamp The timestamp of the subaccount, used for concurrency control.
segmentDescription varchar2 itgen_vnet_segmentdescription writable, segmentDescription The Segment values window > The Top part > The description of the segment.
segmentId int32 Segment ID writable, segmentId The Segment values window > The Top part > The ID of the segment.
segmentValue varchar2 Segment Value writable, segmentValue The Segment values window > The table > The value of the segment, alphanumeric.
segmentValueDescription varchar2 Segment Value Description writable, segmentValueDescription The Segment values window > The table > The description of the segment value.
sendDunningLettersViaEMail char Send Dunning Letters via Email filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::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.::ancestor.::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.::ancestor.::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.
subaccountId int32 itgen_vnet_subaccountid writable, ::ancestor.subaccountId SubID > The identifier of the subaccount.
subaccountNumber varchar2 itgen_vnet_subaccountnumber writable, ::ancestor.subaccountNumber Mandatory field: Subaccount* > The subaccount number. Format 9-XX.
timeStamp blob Timestamp writable, ::ancestor.timeStamp The timestamp of the subaccount, used for concurrency control.
timeStamp_2 blob itgen_vnet_timestamp_2 filters on the platform, writable, ::ancestor.::ancestor.::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)
vatRegistrationId varchar2 VAT Registration ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.vatZone.defaultTaxCategory.description Name of item/description
vatZone_defaultTaxCategory_number varchar2 VAT Zone Default Tax Category Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.vatZone.defaultTaxCategory.number Number of item
vatZone_defaultVatCategory varchar2 VAT Zone Default VAT Category filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::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.::ancestor.::ancestor.vatZone.errorInfo
vatZone_id varchar2 VAT Zone ID filters on the platform, writable, ::ancestor.::ancestor.::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.::ancestor.::ancestor.vatZone.metadata.maxPageSize
vatZone_metadata_totalCount int64 itgen_vnet_vatzone_metadata_totalcount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.vatZone.metadata.totalCount

Release Notes

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