PeopleSoft 9
Account Payables

Table Name VNDR_BANK_ACCT

Table Description
VNDR_BANK_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 No
DESCR VARCHAR(30) No No
DEFAULT_IND VARCHAR(1) No No
BANK_ID_QUAL VARCHAR(3) No No
BNK_ID_NBR VARCHAR(20) No No
BRANCH_ID VARCHAR(10) No No
BANK_ACCT_TYPE VARCHAR(2) No No
BANK_ACCOUNT_NUM VARCHAR(17) No No
CHECK_DIGIT VARCHAR(2) No No
DFI_ID_QUAL VARCHAR(2) No No
DFI_ID_NUM VARCHAR(12) No No
BENEFICIARY_BANK VARCHAR(30) No No
BENEFICIARY_BNK_AC VARCHAR(30) No No
BENEF_BRANCH VARCHAR(30) No No
BENEF_BRANCH_AC VARCHAR(30) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
COUNTRY_CODE VARCHAR(3) No No
PHONE VARCHAR(24) No No
EXTENSION VARCHAR(6) No No
FAX VARCHAR(24) No No
IBAN_CHECK_DIGIT VARCHAR(2) No No
IBAN_ID VARCHAR(34) No No
Index
Name Type Unique Member
PS_VNDR_BANK_ACCT PK Yes
Member(s) of "PS_VNDR_BANK_ACCT" Index
SETID
VENDOR_ID
VNDR_LOC
EFFDT
BANK_ACCT_SEQ_NBR

Published June 06, 2007