PeopleSoft 9.0
Cash Management

Table Name BANK_CD_TBL

Table Description
BANK_CD_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
BANK_CD CHAR(5) Yes No
DESCR CHAR(30) No No
DESCRSHORT CHAR(10) No No
DESCR_AC CHAR(30) No No
BANK_TYPE CHAR(1) No No
BNK_ID_NBR CHAR(20) No No
HOLIDAY_LIST_ID CHAR(10) No Yes
CR_RATING_TYPE CHAR(8) No No
CR_RATING CHAR(5) No No
BANK_STATUS CHAR(1) No No
AR CHAR(1) No No
AP CHAR(1) No No
TR CHAR(1) No No
BI CHAR(1) No No
NETTING_STATUS CHAR(1) No No
LEGAL_NET CHAR(1) No No
DEALING_SW CHAR(1) No No
ISSUER_SW CHAR(1) No No
TREASURY_SW CHAR(1) No No
BROKER_SW CHAR(1) No No
TREASURY_CPTY_SW CHAR(1) No No
BANKING_SW CHAR(1) No No
BUSINESS_UNIT_GL CHAR(5) No No
BANK_ID_QUAL CHAR(3) No Yes
RECON_TRANS_CODE CHAR(3) No No
IMMEDIATE_DEST CHAR(10) No No
IMMEDIATE_ORIGIN CHAR(10) No No
COUNTRY CHAR(3) No No
ADDRESS1 CHAR(55) No No
ADDRESS2 CHAR(55) No No
ADDRESS3 CHAR(55) No No
ADDRESS4 CHAR(55) No No
CITY CHAR(30) No No
NUM1 CHAR(6) No No
NUM2 CHAR(4) No No
HOUSE_TYPE CHAR(2) No No
ADDR_FIELD1 CHAR(2) No No
ADDR_FIELD2 CHAR(4) No No
ADDR_FIELD3 CHAR(4) No No
COUNTY CHAR(30) No No
STATE CHAR(6) No No
POSTAL CHAR(12) No No
GEO_CODE CHAR(11) No No
IN_CITY_LIMIT CHAR(1) No No
COUNTRY_CODE CHAR(3) No No
PHONE CHAR(24) No No
EXTENSION CHAR(6) No No
FAX CHAR(24) No No
ALC CHAR(8) No No
PAYEE_VALIDATE_REQ CHAR(1) No No
DESCRLONG TEXT 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 April 30, 2007