EBICS_IDEBICS_CERT_TYPEB=Bank
C=Client
EBICS_ALIASA=Authentication Key
D=Encryption Key
E=Encryption Key
S=Signature Key
X=Authentication Key
EFFDTDefault Value: %date
A=Active
I=Inactive
EBICS_CERT_LIST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EBICS_ID |
Character(20) | VARCHAR2(20) NOT NULL | EBICS ID |
| 2 | EBICS_CERT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Certificate Type
B=Bank C=Client |
| 3 | EBICS_ALIAS |
Character(1) | VARCHAR2(1) NOT NULL |
Certificate Alias
A=Authentication Key D=Encryption Key E=Encryption Key S=Signature Key X=Authentication Key |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | CERTVALIDFROM | DateTime(26) | TIMESTAMP | Valid from |
| 7 | CERTVALIDTO | DateTime(26) | TIMESTAMP | Valid to |
| 8 | EBICS_PUBLIC_KEY | Long Character(32767) | CLOB | Public Key |
| 9 | EBICS_PRIVATE_KEY | Long Character(32767) | CLOB | Private Key |
| 10 | EBICS_KEY_DIGEST | Long Character(256) | VARCHAR2(256) | Public key Digest |
| 11 | CERTLINK1 | Character(1) | VARCHAR2(1) NOT NULL | Internal Link |