PeopleSoft 9
Account Payables

Table Name BANK_BRANCH_TBL

Table Description
BANK_BRANCH_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BRANCH_NAME VARCHAR(10) Yes No
BRANCH_STATUS VARCHAR(1) No No
BRANCH_ID VARCHAR(10) No No
DESCR VARCHAR(30) No No
DESCR_AC VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
BANK_ID_QUAL VARCHAR(3) No No
VAT_RGSTRD_FLG VARCHAR(1) No No
VAT_RGSTRN_ID VARCHAR(12) No No
VAT_SUSPENSION_FLG VARCHAR(1) 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
DESCRLONG CLOB No No
Index
Name Type Unique Member
PS_BANK_BRANCH_TBL PK Yes
PS0BANK_BRANCH_TBL IE4 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 June 06, 2007