GPES_BANK_FILE(SQL Table) |
Index Back |
|---|---|
Bank File DefinitionBank File Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Bank file definition ID | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | GPES_SEPA_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
SEPA
Y/N Table Edit Default Value: N |
| 4 | GPES_GROUP_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Group Payments in EFT File?
Y/N Table Edit Default Value: N |
| 5 | GPES_MAX_AMOUNT | Number(17,2) | DECIMAL(16,2) NOT NULL | Maximum amount by EFT for bank file |
| 6 | GPES_OPER_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Header operation Code for EFT File
Default Value: 62 |
| 7 | GPES_MAX_AMT_NAT | Number(17,2) | DECIMAL(16,2) NOT NULL | Max Amount for National Transfers in EFT file |
| 8 | GPES_OPER_CODE_1 | Character(3) | VARCHAR2(3) NOT NULL |
National operation Code for EFT File
Default Value: 56 |
| 9 | GPES_MAX_AMT_TRANS | Number(17,2) | DECIMAL(16,2) NOT NULL | Max Amount for International Transfers in EFT file |
| 10 | GPES_ACTION_1 | Character(1) | VARCHAR2(1) NOT NULL |
Action to split or exclude national transfers in EFT File when bigger than GPES_MAX_AMT_NAT
E=Exclude S=Split Default Value: E |
| 11 | GPES_OPER_CODE_2 | Character(3) | VARCHAR2(3) NOT NULL |
International operation Code for EFT File
Default Value: 60 |
| 12 | GPES_MAX_AMT_SP | Number(17,2) | DECIMAL(16,2) NOT NULL | Max Amount for Special Transfers in EFT file |
| 13 | GPES_INCLUDE_SP | Character(1) | VARCHAR2(1) NOT NULL |
Include or Exclude Special Payments in EFT File
E=Exclude I=Include Default Value: I |
| 14 | GPES_ACTION_2 | Character(1) | VARCHAR2(1) NOT NULL |
Action to split or exclude international transfers in EFT File when bigger than GPES_MAX_AMT_TRANS
E=Exclude S=Split Default Value: E |
| 15 | GPES_SUFFIX | Character(3) | VARCHAR2(3) NOT NULL |
Suffix code for EFT file
Default Value: 999 |
| 16 | GPES_SEPA_VERSION | Character(5) | VARCHAR2(5) NOT NULL | Booklet Version |
| 17 | GPES_OPER_CODE_3 | Character(3) | VARCHAR2(3) NOT NULL |
Special operation Code for EFT File
Default Value: 61 |