CERT_LST: AccountView Certificates
read only
- Katalog:
AccountView - Label: Certificates
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle CERT_LST sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CER_ |
int32 |
Certificate provider | |||
CERT_ |
varchar2 |
Certificate details | |||
CERT_ |
varchar2 |
Name | |||
CERT_ |
int32 |
Owner type | |||
CERT_ |
int32 |
Certificate type | |||
CERT_ |
varchar2 |
Owner | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COMP_ |
varchar2 |
Country | |||
COMP_ |
varchar2 |
Department | |||
COMP_ |
varchar2 |
Fax | |||
COMP_ |
varchar2 |
Handelsregisternummer | |||
COMP_ |
varchar2 |
Address | |||
COMP_ |
varchar2 |
Firmennamen | |||
COMP_ |
varchar2 |
City | |||
COMP_ |
varchar2 |
Postcode | |||
COMP_ |
varchar2 |
Postal address | |||
COMP_ |
varchar2 |
Postal address city | |||
COMP_ |
varchar2 |
Postal address postcode | |||
COMP_ |
varchar2 |
Company telephone | |||
COMP_ |
varchar2 |
Registered office city | |||
COMP_ |
varchar2 |
Registered company name | |||
COMP_ |
int32 |
Establishment number | |||
COMP_ |
int32 |
Category | |||
DOC_NR |
varchar2 |
File number | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
IS_ |
char |
Active | |||
KEY_ |
varchar2 |
Key pair | |||
KEY_ |
int32 |
Request status | |||
PAIR_ |
varchar2 |
Certificate pair code | |||
PWD_ |
char |
Ask for password when using certificate | |||
PWD_ |
varchar2 |
User name password hash | |||
REC_ |
char |
Customised | |||
REC_ID |
varchar2 |
Unique code | |||
REQ_ |
datetime |
Applicant date of birth | |||
REQ_ |
varchar2 |
Applicant email address | |||
REQ_ |
varchar2 |
Applicant identity document number | |||
REQ_ |
datetime |
Identity document valid until | |||
REQ_ |
varchar2 |
Name prefix | |||
REQ_ |
varchar2 |
Applicant initials | |||
REQ_ |
varchar2 |
Applicant last name | |||
REQ_ |
int32 |
Applicant gender | |||
REQ_ |
int32 |
Request type | |||
SUB_NR |
varchar2 |
Subscriber number | |||
VAL_ |
datetime |
Gültig von | |||
VAL_TO |
datetime |
Gültig bis |