GPES_BANK_FILE(SQL Table) |
Index Back |
---|---|
Bank File DefinitionBank File Definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPES_FILE_ID | Character(5) | VARCHAR2(5) NOT NULL | Bank file definition ID |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | GPES_FILETYPE_ID | Character(1) | VARCHAR2(1) NOT NULL |
File type ID for Spain
C=CSB34-14 I=CSB34-1 (IBAN) S=SEPA |
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 | SEPA Version |
17 | GPES_OPER_CODE_3 | Character(3) | VARCHAR2(3) NOT NULL |
Special operation Code for EFT File
Default Value: 61 |