PeopleSoft 9
Account Payables

Table Name BANK_ACCT_MTHD

Table Description
BANK_ACCT_MTHD
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BANK_CD_CPTY VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
PYMNT_METHOD VARCHAR(3) Yes No
FORM_ID VARCHAR(6) No Yes
FORM_ID_MISC VARCHAR(6) No No
LAST_FORM_NBR_USED decimal(10) No No
EFT_HDR_COMMENT VARCHAR(10) No No
LAST_EFT_FILE_ID VARCHAR(4) No No
FORM_NBR_CONFIRM VARCHAR(1) No No
POSITIVE_PAY_FLG VARCHAR(1) No No
FORM_ID_POS VARCHAR(6) No No
FILE_COPY_FLG VARCHAR(1) No No
FILE_COPY_FORM VARCHAR(6) No No
EFT_LAYOUT_CD VARCHAR(10) No No
DOC_TYPE VARCHAR(8) No No
MAN_DOC_TYPE VARCHAR(8) No No
HOL_PROC_OPT VARCHAR(1) No No
HOL_PROC_DAYS SMALLINT No No
HOL_PROC_OVERFL VARCHAR(1) No No
COMPANY_ID VARCHAR(20) No No
ORIGINATING_DFI_ID VARCHAR(8) No No
PAY_SCHEDULE_FLG VARCHAR(1) No No
PRENOTE_DATE PSDATE No No
PRENOTE_REQD VARCHAR(1) No No
PRENOTE_STATUS VARCHAR(1) No No
VALUE_DT_SW VARCHAR(1) No No
VALUE_DT_DAYS SMALLINT No No
PAYMENT_TIME PSTIME No No
STL_THROUGH VARCHAR(2) No No
FORMAT_ID VARCHAR(10) No No
Index
Name Type Unique Member
PS_BANK_ACCT_MTHD PK Yes
Member(s) of "PS_BANK_ACCT_MTHD" Index
SETID
BANK_CD
BANK_CD_CPTY
BANK_ACCT_KEY
PYMNT_METHOD

Published June 06, 2007