EBICS_ID3=H003
4=H004
H=Partly Initialised (HIA)
I=Partly Initialised (INI)
N=New
R=Ready
T=Initialised
Prompt Table: EBICS_TGNODE_VW
DE=Germany
EU=Europe
FR=France
EBICS_ITEM_LIST(SQL View) |
Index Back |
|---|
| SELECT EBICS_ID , EBICS_VERSION , EBICS_HOST , EBICS_PARTNER , EBICS_USER , EBICS_STATUS , EBICS_TGNODE , EBICS_ORDER_ID , EBICS_COUNTRY_CODE FROM PS_EBICS_INFO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EBICS_ID |
Character(20) | VARCHAR2(20) NOT NULL | EBICS ID |
| 2 | EBICS_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
Version
3=H003 4=H004 |
| 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 |
| 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 |