EBICS_INFO

(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_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