PeopleSoft 9
Account Payables

Table Name EFT_FILE_RPT

Table Description
EFT_FILE_RPT
Columns
Name Datatype Is PK Is FK
EFT_LAYOUT_CD VARCHAR(10) Yes Yes
FILE_NAME_SHORT VARCHAR(30) Yes No
PROCESS_INSTANCE decimal(10) Yes No
CURRENCY_CD VARCHAR(3) Yes No
BANK_ACCOUNT_NUM VARCHAR(17) Yes No
BANK_NAME VARCHAR(30) No No
BANK_ADDRESS1 VARCHAR(35) No No
BANK_ADDRESS2 VARCHAR(35) No No
BANK_ADDRESS3 VARCHAR(35) No No
BANK_ADDRESS4 VARCHAR(35) No No
BANK_CITY_ST_POST VARCHAR(44) No No
COUNTRY_NAME VARCHAR(30) No No
BUS_UNIT_NAME VARCHAR(30) No No
BUS_UNIT_ADDRESS1 VARCHAR(35) No No
BUS_UNIT_ADDRESS2 VARCHAR(35) No No
BUS_UNIT_ADDRESS3 VARCHAR(35) No No
BUS_UNIT_ADDRESS4 VARCHAR(35) No No
BUS_UNIT_CITY_POST VARCHAR(44) No No
COUNTRY_NAME1 VARCHAR(30) No No
MEDIA_DESCR VARCHAR(10) No No
PYMNT_AMT_TTL decimal(18,3) No No
PYMNT_REC_CNT decimal(10) No No
BANK_ACCT_NUM_SUM VARCHAR(15) No No
SEQ_NUM SMALLINT No No
CONTACT_NAME VARCHAR(50) No No
FILE_CREATE_DT PSDATE No No
CONTROL_TTL_CHAR VARCHAR(25) No No
BNK_ID_NBR VARCHAR(20) No No
PYMNT_REC_CNT_TTL decimal(10) No No
LANGUAGE_CD VARCHAR(3) No No
CONFIG_DTL_FLAG VARCHAR(1) No No
BANK_CODE_SUM VARCHAR(20) No No
IBAN_ID VARCHAR(34) No No
Index
Name Type Unique Member
PS_EFT_FILE_RPT PK Yes
Member(s) of "PS_EFT_FILE_RPT" Index
EFT_LAYOUT_CD
FILE_NAME_SHORT
PROCESS_INSTANCE
CURRENCY_CD
BANK_ACCOUNT_NUM

Published June 06, 2007