# knaddress Adres - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `knaddress` 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 | Documentation | |---|:---:|---|:---:|---| | `ad` | `varchar2(60)` | Straat | | | | `adad` | `varchar2(255)` | Adres toevoeging | | | | `addrtype` | `int32` | Adres type | | | | `coid` | `varchar2(3)` | Land | | | | `hmad` | `varchar2(30)` | Toev. aan huisnr. | | | | `hmnr` | `int32` | Huisnummer | | | | `kncdtcdid` | `int32` | Contact data | | | | `pbad` | `char` | Postbusadres | | | | `rs` | `varchar2(50)` | Woonplaats | | | | `zpcd` | `varchar2(15)` | Postcode | | |