| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
GPMY_TT_CREDIT_CNT |
Character(8) |
VARCHAR2(8) NOT NULL |
Total number of records in EFT file
|
| 2 |
GPMY_TT_CREDIT_AMT |
Character(11) |
VARCHAR2(11) NOT NULL |
Total Credit amount in EFT file
|
| 3 |
GPMY_TT_DEBIT_CNT |
Character(8) |
VARCHAR2(8) NOT NULL |
Total Debit Count EFT file
|
| 4 |
GPMY_TT_DEBIT_AMT |
Character(11) |
VARCHAR2(11) NOT NULL |
Total Debit Amount in the EFT file
|
| 5 |
GPMY_BLANKS_26 |
Character(26) |
VARCHAR2(26) NOT NULL |
Filler of size 26.
|
| 6 |
GPMY_HASH_TOTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Hash Total
|
| 7 |
GPMY_BLANKS_33 |
Character(33) |
VARCHAR2(33) NOT NULL |
Filler of blanks 33.
|
| 8 |
GPMY_EFT_RECTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
EFT Record Type
|
| 9 |
GPMY_BAT_ENTRY_CNT |
Character(12) |
VARCHAR2(12) NOT NULL |
Batch Entry Count
|
| 10 |
GPMY_BAT_ENTRY_CR |
Character(15) |
VARCHAR2(15) NOT NULL |
Batch Entry Credit
|
| 11 |
GPMY_BLANKS_42 |
Character(42) |
VARCHAR2(42) NOT NULL |
Filler of size 42.
|
| 12 |
GPMY_BLANKS_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Filler of size 2.
|
| 13 |
GPMY_BLANKS_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Filler of size 2.
|
| 14 |
GPMY_BLANKS_24 |
Character(24) |
VARCHAR2(24) NOT NULL |
Filler of size 24.
|
| 15 |
GPMY_BLANKS_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Filler of size 2.
|
| 16 |
GPMY_BNK_USRNO |
Character(12) |
VARCHAR2(12) NOT NULL |
Bank User Number
|
| 17 |
GPMY_BNK_USR_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
This Name is used for creating EFT file.
|