invantive documentation
Invantive Support ForumsLog In / Sign Up

CERT_LST: AccountView Certificates

read only

  • Catalog: AccountView
  • Label: Certificates

Can only retrieve data.

Table Columns

The columns of the table CERT_LST 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 Marks Documentation
CER_SERV int32 Certificate provider
CERT_INFO varchar2(4) Certificate details
CERT_NAME varchar2(250) Name
CERT_OWN int32 Owner type
CERT_TYPE int32 Certificate type
CERT_VOWN varchar2(64) Owner
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COMP_CNTRY varchar2(20) Country
COMP_DPT varchar2(40) Department
COMP_FAX varchar2(25) Fax
COMP_KVK varchar2(8) Chamber of Commerce number
COMP_NADDR varchar2(80) Address
COMP_NAME varchar2(40) Company name
COMP_NCITY varchar2(35) City
COMP_NCODE varchar2(6) Postcode
COMP_PADDR varchar2(80) Postal address
COMP_PCITY varchar2(35) Postal address city
COMP_PCODE varchar2(6) Postal address postcode
COMP_PHONE varchar2(25) Company telephone
COMP_SCITY varchar2(35) Registered office city
COMP_SNAME varchar2(40) Registered company name
COMP_STORE int32 Establishment number
COMP_TYPE int32 Category
DOC_NR varchar2(10) File number
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
IS_ACTIVE char Active
KEY_FILE varchar2(4) Key pair
KEY_STAT int32 Request status
PAIR_ID varchar2(10) Certificate pair code
PWD_ASK char Ask for password when using certificate
PWD_HASH varchar2(59) User name password hash
REC_CUST char Customised
REC_ID varchar2(10) Unique code
REQ_BDATE datetime Applicant date of birth
REQ_EMAIL varchar2(50) Applicant email address
REQ_IDNR varchar2(20) Applicant identity document number
REQ_IDVAL datetime Identity document valid until
REQ_INFIX varchar2(10) Name prefix
REQ_INIT varchar2(10) Applicant initials
REQ_LNAME varchar2(35) Applicant last name
REQ_SEX int32 Applicant gender
REQ_TYPE int32 Request type
SUB_NR varchar2(8) Subscriber number
VAL_FROM datetime Valid from
VAL_TO datetime Valid until