| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 2 |
FILE_NAME_SHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
File Name
|
| 3 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 4 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 5 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 6 |
BANK_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Name
|
| 7 |
BANK_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Address1
|
| 8 |
BANK_ADDRESS2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Address2
|
| 9 |
BANK_ADDRESS3 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Address3
|
| 10 |
BANK_ADDRESS4 |
Character(35) |
VARCHAR2(35) NOT NULL |
Bank Address4
|
| 11 |
BANK_CITY_ST_POST |
Character(44) |
VARCHAR2(44) NOT NULL |
Bank City/State/Zip
|
| 12 |
COUNTRY_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Country
|
| 13 |
BUS_UNIT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Unit Name
|
| 14 |
BUS_UNIT_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Business Unit Adress 1
|
| 15 |
BUS_UNIT_ADDRESS2 |
Character(35) |
VARCHAR2(35) NOT NULL |
Business Unit Address2
|
| 16 |
BUS_UNIT_ADDRESS3 |
Character(35) |
VARCHAR2(35) NOT NULL |
Business Unit Address3
|
| 17 |
BUS_UNIT_ADDRESS4 |
Character(35) |
VARCHAR2(35) NOT NULL |
Business Unit Address4
|
| 18 |
BUS_UNIT_CITY_POST |
Character(44) |
VARCHAR2(44) NOT NULL |
Bus Unit City/State/Zip
|
| 19 |
COUNTRY_NAME1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Country
|
| 20 |
MEDIA_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Media
|
| 21 |
PYMNT_AMT_TTL |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Cumulative Payment Amount
|
| 22 |
PYMNT_REC_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of vchr_pymnt recs
|
| 23 |
BANK_ACCT_NUM_SUM |
Character(15) |
VARCHAR2(15) NOT NULL |
Total of Bank Account Numbers
|
| 24 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 25 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
The individual contact name associated with a given bank/counterparty.
|
| 26 |
FILE_CREATE_DT |
Date(10) |
DATE |
File Creation Date
|
| 27 |
CONTROL_TTL_CHAR |
Character(25) |
VARCHAR2(25) NOT NULL |
Control Total
|
| 28 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 29 |
PYMNT_REC_CNT_TTL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Cumulative Record Count
|
| 30 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 31 |
CONFIG_DTL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Detail Flag
|
| 32 |
BANK_CODE_SUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Total of Bank Code Numbers
|
| 33 |
IBAN_ID |
Character(34) |
VARCHAR2(34) NOT NULL |
IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
|