invantive documentation
Invantive Support ForumsLog In / Sign Up

addressReeksAddressSearch: Company.info Address Range Search

read only XML

  • Catalog: CompanyInfo
  • Schema: CompanyInfo
  • Label: Address Range Search

Can only retrieve data.

API Source

  • XML topic: addressReeksAddressSearch

Parameters

Name Data Type Required Default Documentation
address ``
city ``
page ``
postcode ``

Table Columns

The columns of the table addressReeksAddressSearch 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
HUISNR number House Number
HUISNR_TOEVOEGING varchar2 itgen_cio_huisnr_toevoeging
REEKS_CEBUCOCODE number Sequence Cebuco Code
REEKS_GEMEENTECODE number Sequence Municipality Code
REEKS_GEMEENTEID number Sequence Municipality ID
REEKS_GEMEENTENAAM varchar2 Sequence Municipality Name
REEKS_HUISNR_TM number Sequence House Number upto
REEKS_HUISNR_VAN number Sequence House Number from
REEKS_LETTERCOMBINATIE varchar2 Sequence Character Combination
REEKS_PLAATSID number Sequence City ID
REEKS_PLAATSNAAM varchar2 Sequence City Name
REEKS_PLAATSNAAM_EXTRACT varchar2 Sequence Place Name Extract
REEKS_PLAATSNAAM_PTT varchar2 Sequence Place Name TPG
REEKS_PROVINCIECODE varchar2 Sequence State Code
REEKS_PROVINCIENAAM varchar2 Sequence State Name
REEKS_REEKSID number Sequence Sequence ID
REEKS_REEKSINDICATIE varchar2 Sequence Sequence Indicator
REEKS_STRAATID number Sequence Street ID
REEKS_STRAATNAAM varchar2 Sequence Street Name
REEKS_STRAATNAAM_EXTRACT varchar2 Sequence itgen_cio_straatnaam_extract
REEKS_STRAATNAAM_NEN varchar2 Sequence Street Name NEN
REEKS_STRAATNAAM_PTT varchar2 Sequence Street Name TPG
REEKS_WIJKCODE varchar2 Sequence itgen_cio_wijkcode

Release Notes

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