PeopleSoft 9.0
Cash Management

Table Name BANK_BRANCH_TBL

Table Description
BANK_BRANCH_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
BANK_CD CHAR(5) Yes Yes
BRANCH_NAME CHAR(10) Yes No
BRANCH_STATUS CHAR(1) No No
BRANCH_ID CHAR(10) No No
DESCR CHAR(30) No No
DESCR_AC CHAR(30) No No
DESCRSHORT CHAR(10) No No
BANK_ID_QUAL CHAR(3) No No
VAT_RGSTRD_FLG CHAR(1) No No
VAT_RGSTRN_ID CHAR(12) No No
VAT_SUSPENSION_FLG CHAR(1) 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
DESCRLONG TEXT No No
Index
Name Type Unique Member
PS_BANK_BRANCH_TBL PK Yes
PS0BANK_BRANCH_TBL IE1 No
Member(s) of "PS_BANK_BRANCH_TBL" Index
SETID
BANK_CD
BRANCH_NAME
Member(s) of "PS0BANK_BRANCH_TBL" Index
DESCR
SETID
BANK_CD
BRANCH_NAME

Published April 30, 2007