PeopleSoft 9
Account Payables

Table Name BANK_CD_TBL

Table Description
BANK_CD_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
DESCR_AC VARCHAR(30) No No
BANK_TYPE VARCHAR(1) No No
BNK_ID_NBR VARCHAR(20) No No
HOLIDAY_LIST_ID VARCHAR(10) No Yes
CR_RATING_TYPE VARCHAR(8) No No
CR_RATING VARCHAR(5) No No
BANK_STATUS VARCHAR(1) No No
AR VARCHAR(1) No No
AP VARCHAR(1) No No
TR VARCHAR(1) No No
BI VARCHAR(1) No No
NETTING_STATUS VARCHAR(1) No No
LEGAL_NET VARCHAR(1) No No
DEALING_SW VARCHAR(1) No No
ISSUER_SW VARCHAR(1) No No
TREASURY_SW VARCHAR(1) No No
BROKER_SW VARCHAR(1) No No
TREASURY_CPTY_SW VARCHAR(1) No No
BANKING_SW VARCHAR(1) No No
BUSINESS_UNIT_GL VARCHAR(5) No No
BANK_ID_QUAL VARCHAR(3) No No
RECON_TRANS_CODE VARCHAR(3) No No
IMMEDIATE_DEST VARCHAR(10) No No
IMMEDIATE_ORIGIN VARCHAR(10) 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
ALC VARCHAR(8) No Yes
PAYEE_VALIDATE_REQ VARCHAR(1) No No
DESCRLONG CLOB No No
Index
Name Type Unique Member
PS_BANK_CD_TBL PK Yes
PS0BANK_CD_TBL IE1 No
PS1BANK_CD_TBL IE2 No
PS2BANK_CD_TBL IE3 No
Member(s) of "PS_BANK_CD_TBL" Index
SETID
BANK_CD
Member(s) of "PS0BANK_CD_TBL" Index
DESCR
SETID
BANK_CD
Member(s) of "PS1BANK_CD_TBL" Index
DESCRSHORT
SETID
BANK_CD
Member(s) of "PS2BANK_CD_TBL" Index
BNK_ID_NBR
SETID
BANK_CD

Published June 06, 2007