PeopleSoft 9
Account Payables

Table Name VCHR_VNDR_BANK

Table Description
VCHR_VNDR_BANK
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
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
EFT_PYMNT_FMT_CD VARCHAR(3) No No
EFT_RTNG_FLG VARCHAR(1) No No
EFT_RTNG_STATUS VARCHAR(1) No No
EFT_TRANS_HANDLING VARCHAR(1) No No
EFT_DOM_COSTS_CD VARCHAR(1) No No
EFT_CORR_COSTS_CD VARCHAR(1) No No
EFT_CROSSED_CHECK VARCHAR(1) No No
EFT_CHECK_FWRD_CD VARCHAR(1) No No
EFT_CHECK_DRAW_CD VARCHAR(1) No No
EFT_PAY_INST_CD1 VARCHAR(3) No No
EFT_PAY_INST_CD2 VARCHAR(3) No No
EFT_PAY_INST_CD3 VARCHAR(3) No No
EFT_PAY_INST_CD4 VARCHAR(3) No No
EFT_PAY_INST_REF1 VARCHAR(40) No No
EFT_PAY_INST_REF2 VARCHAR(40) No No
Index
Name Type Unique Member
PS_VCHR_VNDR_BANK PK Yes
Member(s) of "PS_VCHR_VNDR_BANK" Index
BUSINESS_UNIT
VOUCHER_ID

Published June 06, 2007