# PEOPLE: Contacts - Name: `PEOPLE` - Catalog: `AccountView` - Label: Contacts - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `PEOPLE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AD_NAME` | `string(40)` | Addressee | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `DEAR` | `string(40)` | Salutation | ☐ | | | `DSP_NAME` | `string(30)` | Full name | ☐ | | | `FAX_BUS` | `string(20)` | Business fax | ☐ | | | `FAX_PRIV` | `string(20)` | Private fax | ☐ | | | `FST_NAME` | `string(20)` | First Name | ☐ | | | `IMG_FILE` | `string(4)` | Image | ☐ | | | `INITIALS` | `string(10)` | Initials | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LST_NAME` | `string(30)` | Last Name | ☐ | | | `MAIL_BUS` | `string(50)` | Business email | ☐ | | | `MAIL_OPT_B` | `int32` | Mailing (business email) | ☐ | | | `MAIL_OPT_P` | `int32` | Mailing (private email) | ☐ | | | `MAIL_PRIV` | `string(50)` | Private email | ☐ | | | `MSG_MAIL` | `boolean` | Email notification | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PE_CRIT_01` | `string(10)` | Contact list field 1 | ☐ | | | `PE_CRIT_02` | `string(10)` | Contact list field 2 | ☐ | | | `PE_CRIT_03` | `string(10)` | Contact list field 3 | ☐ | | | `PE_CRIT_04` | `string(10)` | Contact list field 4 | ☐ | | | `PE_CRIT_05` | `string(10)` | Contact list field 5 | ☐ | | | `PE_YN_01` | `boolean` | Contact checkbox field 1 | ☐ | | | `PE_YN_02` | `boolean` | Contact checkbox field 2 | ☐ | | | `PE_YN_03` | `boolean` | Contact checkbox field 3 | ☐ | | | `PE_YN_04` | `boolean` | Contact checkbox field 4 | ☐ | | | `PE_YN_05` | `boolean` | Contact checkbox field 5 | ☐ | | | `PP_CODE` | `string(10)` | Contact Person | ☐ | | | `PP_NOTE1` | `string(4)` | Remark | ☐ | | | `PW_HASH` | `string(16)` | Password hash | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `SEX` | `decimal` | Gender | ☐ | | | `TEL_BUS` | `string(20)` | Business telephone | ☐ | | | `TEL_MOB` | `string(20)` | Mobile telephone | ☐ | | | `TEL_PRIV` | `string(20)` | Private telephone | ☐ | | | `TITLE1` | `string(20)` | Contact title 1 | ☐ | | | `TITLE2` | `string(10)` | Contact title 2 | ☐ | |