invantive documentation
Invantive Support ForumsLog In / Sign Up

CompanyCurrentBankAccounts: Nmbrs Company Current Bank Accounts

read only per partition XML

  • Catalog: Nmbrs
  • Schema: Company
  • Label: Company Current Bank Accounts

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: CompanyService.asmx
  • XML topic: BankAccount_GetCurrent
  • XML path: /ncs:BankAccount_GetCurrentResult

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table CompanyCurrentBankAccounts 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
BIC varchar2 BIC /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:BIC
CITY varchar2 City /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:City
COMPANY_CODE int64 Company ID
DESCRIPTION varchar2 Description /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:Description
IBAN varchar2 IBAN /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:IBAN
ID int32 ID /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:Id
NAME varchar2 Name /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:Name
NUMBER varchar2 Number /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:Number
TYPE varchar2 Type /soap:Envelope/soap:Body/ncs:BankAccount_GetCurrentResponse/ncs:BankAccount_GetCurrentResult/ncs:Type One of 'None', 'Bankrekening1', 'Spaarloon', 'Bankrekening2', 'Bankrekening3', 'Bankrekening4', 'Bankrekening5', 'Standaard', 'Levensloop'.

Release Notes

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