EBICS_INFO(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(20) | VARCHAR2(20) NOT NULL | EBICS ID | |
2 | EBICS_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
Version
3=H003 4=H004 Default Value: 3 |
3 | EBICS_HOST | Character(30) | VARCHAR2(30) NOT NULL | Host Name |
4 | EBICS_PARTNER | Character(30) | VARCHAR2(30) NOT NULL | Partner ID |
5 | EBICS_USER | Character(30) | VARCHAR2(30) NOT NULL | User ID |
6 | EBICS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
H=Partly Initialised (HIA) I=Partly Initialised (INI) N=New R=Ready T=Initialised Default Value: N |
7 | EBICS_TGNODE | Character(30) | VARCHAR2(30) NOT NULL |
Target Node
Prompt Table: EBICS_TGNODE_VW |
8 | EBICS_ORDER_ID | Character(4) | VARCHAR2(4) NOT NULL | Order ID |
9 | EBICS_COUNTRY_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Country Code
DE=Germany EU=Europe FR=France Default Value: FR |
10 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
11 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |