| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
PMT_MSG_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identification for the instance of a PAYMENT_REQUEST message
(SEPA/Financial Gateway)
|
| 4 |
PMT_SEQ_NUM |
Number(7,0) |
INTEGER NOT NULL |
Sequence number which must be unique for the PMT_MSG_ID
(SEPA/Financial Gateway)
|
| 5 |
KEY_CHAR_40_01 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/01
|
| 6 |
KEY_CHAR_40_02 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/02
|
| 7 |
KEY_CHAR_40_03 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/03
|
| 8 |
KEY_CHAR_40_04 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/04
|
| 9 |
KEY_CHAR_40_05 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/05
|
| 10 |
KEY_CHAR_40_06 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key_Char 40/06
|
| 11 |
KEY_CHAR_40_07 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/07
|
| 12 |
KEY_CHAR_40_08 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/08
|
| 13 |
KEY_CHAR_40_09 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/09
|
| 14 |
KEY_CHAR_40_10 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/10
|
| 15 |
KEY_CHAR_40_11 |
Character(40) |
VARCHAR2(40) NOT NULL |
This is used as a flexible / configurable character field
(SEPA/Financial Gateway)
|
| 16 |
KEY_CHAR_40_12 |
Character(40) |
VARCHAR2(40) NOT NULL |
This is used as a flexible / configurable character field
(SEPA/Financial Gateway)
|
| 17 |
KEY_CHAR_40_13 |
Character(40) |
VARCHAR2(40) NOT NULL |
This is used as a flexible / configurable character field
(SEPA/Financial Gateway)
|
| 18 |
KEY_CHAR_40_14 |
Character(40) |
VARCHAR2(40) NOT NULL |
This is used as a flexible / configurable character field
(SEPA/Financial Gateway)
|
| 19 |
KEY_CHAR_40_15 |
Character(40) |
VARCHAR2(40) NOT NULL |
This is used as a flexible / configurable character field
(SEPA/Financial Gateway)
|
| 20 |
KEY_DATE_01 |
Date(10) |
DATE |
This is used as a flexible / configurable date field
(SEPA/Financial Gateway)
|
| 21 |
KEY_DATE_02 |
Date(10) |
DATE |
This is used as a flexible / configurable date field
(SEPA/Financial Gateway)
|
| 22 |
KEY_DATE_03 |
Date(10) |
DATE |
This is used as a flexible / configurable date field
(SEPA/Financial Gateway)
|
| 23 |
KEY_DATE_04 |
Date(10) |
DATE |
This is used as a flexible / configurable date field
(SEPA/Financial Gateway)
|
| 24 |
KEY_DATE_05 |
Date(10) |
DATE |
This is used as a flexible / configurable date field
(SEPA/Financial Gateway)
|
| 25 |
KEY_DTTM_01 |
DateTime(26) |
TIMESTAMP |
This is used as a flexible / configurable datetime field
(SEPA/Financial Gateway)
|
| 26 |
KEY_DTTM_02 |
DateTime(26) |
TIMESTAMP |
This is used as a flexible / configurable datetime field
(SEPA/Financial Gateway)
|
| 27 |
KEY_DTTM_03 |
DateTime(26) |
TIMESTAMP |
This is used as a flexible / configurable datetime field
(SEPA/Financial Gateway)
|
| 28 |
KEY_DTTM_04 |
DateTime(26) |
TIMESTAMP |
This is used as a flexible / configurable datetime field
(SEPA/Financial Gateway)
|
| 29 |
KEY_DTTM_05 |
DateTime(26) |
TIMESTAMP |
This is used as a flexible / configurable datetime field
(SEPA/Financial Gateway)
|
| 30 |
KEY_SIGN_NUM_01 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is used as a flexible / configurable signed number field
(SEPA/Financial Gateway)
|
| 31 |
KEY_SIGN_NUM_02 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is used as a flexible / configurable signed number field
(SEPA/Financial Gateway)
|
| 32 |
KEY_SIGN_NUM_03 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is used as a flexible / configurable signed number field
(SEPA/Financial Gateway)
|
| 33 |
KEY_SIGN_NUM_04 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is used as a flexible / configurable signed number field
(SEPA/Financial Gateway)
|
| 34 |
KEY_SIGN_NUM_05 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This is used as a flexible / configurable signed number field
(SEPA/Financial Gateway)
|