# ptproject_knbasicaddressadr Project: KnBasicAddressAdr - Catalog: `AfasOnline` - Schema: `UpdateConnector` - Retrieve: False - Insert: True - Update: False - Delete: False ## Table Columns The columns of the table `ptproject_knbasicaddressadr` 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ad` | `varchar2(60)` | Straat | | | | `adad` | `varchar2(255)` | Adres toevoeging | | | | `coid` | `varchar2(3)` | Land | | | | `hmad` | `varchar2(30)` | Toev. aan huisnr. | | | | `hmnr` | `int32` | Huisnummer | | | | `pbad` | `char` | Postbusadres | | | | `rs` | `varchar2(50)` | Woonplaats | | | | `stad` | `varchar2(255)` | Toev. voor straat | | | | `zpcd` | `varchar2(15)` | Postcode | | |