PeopleSoft 9
Account Payables

Table Name VNDR_IBANK_ACCT

Table Description
VNDR_IBANK_ACCT
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
VNDR_LOC VARCHAR(10) Yes Yes
EFFDT PSDATE Yes Yes
BANK_ACCT_SEQ_NBR SMALLINT Yes Yes
INTRMED_SEQ_NO SMALLINT Yes No
INTRMED_BANK_CD VARCHAR(5) No No
INTRMED_ACCT_KEY VARCHAR(4) No No
INTRMED_DFI_ID VARCHAR(15) No No
INTRMED_PYMNT_MSG VARCHAR(30) No No
STL_ROUTING_METHOD VARCHAR(2) No No
Index
Name Type Unique Member
PS_VNDR_IBANK_ACCT PK Yes
Member(s) of "PS_VNDR_IBANK_ACCT" Index
SETID
VENDOR_ID
VNDR_LOC
EFFDT
BANK_ACCT_SEQ_NBR
INTRMED_SEQ_NO

Published June 06, 2007