# CERT_LST: Certificates - Name: `CERT_LST` - Catalog: `AccountView` - Label: Certificates - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `CERT_LST` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CER_SERV` | `int32` | Certificate provider | ☐ | | | `CERT_INFO` | `string(4)` | Certificate details | ☐ | | | `CERT_NAME` | `string(250)` | Name | ☐ | | | `CERT_OWN` | `int32` | Owner type | ☐ | | | `CERT_TYPE` | `int32` | Certificate type | ☐ | | | `CERT_VOWN` | `string(64)` | Owner | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COMP_CNTRY` | `string(20)` | Country | ☐ | | | `COMP_DPT` | `string(40)` | Department | ☐ | | | `COMP_FAX` | `string(25)` | Fax | ☐ | | | `COMP_KVK` | `string(8)` | Chamber of Commerce number | ☐ | | | `COMP_NADDR` | `string(80)` | Address | ☐ | | | `COMP_NAME` | `string(40)` | Company name | ☐ | | | `COMP_NCITY` | `string(35)` | City | ☐ | | | `COMP_NCODE` | `string(6)` | Postcode | ☐ | | | `COMP_PADDR` | `string(80)` | Postal address | ☐ | | | `COMP_PCITY` | `string(35)` | Postal address city | ☐ | | | `COMP_PCODE` | `string(6)` | Postal address postcode | ☐ | | | `COMP_PHONE` | `string(25)` | Company telephone | ☐ | | | `COMP_SCITY` | `string(35)` | Registered office city | ☐ | | | `COMP_SNAME` | `string(40)` | Registered company name | ☐ | | | `COMP_STORE` | `int32` | Establishment number | ☐ | | | `COMP_TYPE` | `int32` | Category | ☐ | | | `DOC_NR` | `string(10)` | File number | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `IS_ACTIVE` | `boolean` | Active | ☐ | | | `KEY_FILE` | `string(4)` | Key pair | ☐ | | | `KEY_STAT` | `int32` | Request status | ☐ | | | `PAIR_ID` | `string(10)` | Certificate pair code | ☐ | | | `PWD_ASK` | `boolean` | Ask for password when using certificate | ☐ | | | `PWD_HASH` | `string(59)` | User name password hash | ☐ | | | `REC_CUST` | `boolean` | Customised | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REQ_BDATE` | `datetime` | Applicant date of birth | ☐ | | | `REQ_EMAIL` | `string(50)` | Applicant email address | ☐ | | | `REQ_IDNR` | `string(20)` | Applicant identity document number | ☐ | | | `REQ_IDVAL` | `datetime` | Identity document valid until | ☐ | | | `REQ_INFIX` | `string(10)` | Name prefix | ☐ | | | `REQ_INIT` | `string(10)` | Applicant initials | ☐ | | | `REQ_LNAME` | `string(35)` | Applicant last name | ☐ | | | `REQ_SEX` | `int32` | Applicant gender | ☐ | | | `REQ_TYPE` | `int32` | Request type | ☐ | | | `SUB_NR` | `string(8)` | Subscriber number | ☐ | | | `VAL_FROM` | `datetime` | Valid from | ☐ | | | `VAL_TO` | `datetime` | Valid until | ☐ | |