# CON_PP: Contact person roles at companies
- Name: `CON_PP`
- Catalog: `AccountView`
- Label: Contact person roles at companies
- Partition-specific: true
- Select: true
- Insert: false
- Update: false
- Delete: false
## Table Columns
The columns of the table `CON_PP` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `CNG_DATE` | `datetime` | Date modified | ☐ | |
| `CNG_NR` | `int32` | Change number | ☐ | |
| `CNG_USR` | `string(20)` | Employee last modified | ☐ | |
| `CP_ADR` | `string(4)` | Address in country-dependent format (memo) | ☐ | |
| `INP_DATE` | `datetime` | Entry date | ☐ | |
| `INP_USR` | `string(20)` | Entered by employee | ☐ | |
| `INST_CODE` | `string(5)` | Installation | ☐ | |
| `LINK_TYPE` | `string(10)` | Relationship management role | ☐ | |
| `partition_code` | `string` | Partition code | ☑ | |
| `partition_name` | `string` | Partition name | ☑ | |
| `PP_CODE` | `string(10)` | Contact Person | ☐ | |
| `REC_ID` | `string(10)` | Unique code | ☐ | |
| `SUB_NR` | `string(10)` | Company | ☐ | |
| `VIS_ADDRES` | `string(4)` | Visiting address in country-dependent format (memo) | ☐ | |