PeopleSoft 9
Account Payables

Table Name EFT_LAYOUT_TBL

Table Description
EFT_LAYOUT_TBL
Columns
Name Datatype Is PK Is FK
EFT_LAYOUT_CD VARCHAR(10) Yes No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
LAST_EFT_FILE_ID VARCHAR(4) No No
MAX_REMITTANCE_NBR SMALLINT No No
DD_FLG VARCHAR(1) No No
DRAFT_FLG VARCHAR(1) No No
PAY_FLG VARCHAR(1) No No
STD_ID_NUM_QUAL VARCHAR(3) No No
EFT_FILE_NBR VARCHAR(2) No No
INBOUND_EFT_FLG VARCHAR(1) No No
OUTBOUND_EFT_FLG VARCHAR(1) No No
OUTPUT_FILENAME VARCHAR(30) No No
FILE_EXTENSION VARCHAR(4) No No
FEDRL_EFT_ACH_IND VARCHAR(1) No No
Index
Name Type Unique Member
PS_EFT_LAYOUT_TBL PK Yes
PS0EFT_LAYOUT_TBL IE4 No
Member(s) of "PS_EFT_LAYOUT_TBL" Index
EFT_LAYOUT_CD
Member(s) of "PS0EFT_LAYOUT_TBL" Index
DESCR
EFT_LAYOUT_CD

Published June 06, 2007