| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPAU_EFT_USER_NO |
Character(6) |
VARCHAR2(6) NOT NULL |
EFT User Number used in the AE program GPAU_EFT_CMX.
|
| 2 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
|
| 3 |
GPAU_USER_NO |
Character(6) |
VARCHAR2(6) NOT NULL |
EFT User Number used in the AE program GPAU_EFT_CMX.
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
GPAU_CMX_SEQ_NO |
Character(2) |
VARCHAR2(2) NOT NULL |
This is the Cemtex Seq No.
|
| 6 |
BANK_CD |
Character(11) |
VARCHAR2(11) NOT NULL |
Bank ID
|
| 7 |
GPAU_EFT_USER_NAME |
Character(26) |
VARCHAR2(26) NOT NULL |
This is the User Name used for CEMTEX reporting.
|
| 8 |
GPAU_EFT_RECTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This is the record type that is used for CEMTEX reporting.
|
| 9 |
GPAU_ENTRY_DESCR |
Character(12) |
VARCHAR2(12) NOT NULL |
This is the entry description used for CEMTEX processing.
|
| 10 |
PAYMENT_DT |
Date(10) |
DATE |
Payment Date
|