PeopleSoft 9
Account Payables

Table Name EBK_BANK_BRANCH

Table Description
EBK_BANK_BRANCH
Columns
Name Datatype Is PK Is FK
BNK_ID_NBR VARCHAR(20) Yes Yes
BRANCH_ID VARCHAR(10) Yes No
BENEF_BRANCH VARCHAR(30) No No
BENEF_BRANCH_AC VARCHAR(30) No No
BRANCH_STATUS VARCHAR(1) No No
ADDRESS_CC VARCHAR(110) No No
POSTAL VARCHAR(12) No No
PHONE VARCHAR(24) No No
CLEARING_NUMBER VARCHAR(8) No No
ADDITIONAL VARCHAR(1) No No
Index
Name Type Unique Member
PS_EBK_BANK_BRANCH PK Yes
PS0EBK_BANK_BRANCH IE1 No
PS1EBK_BANK_BRANCH IE2 No
Member(s) of "PS_EBK_BANK_BRANCH" Index
BNK_ID_NBR
BRANCH_ID
Member(s) of "PS0EBK_BANK_BRANCH" Index
BENEF_BRANCH
BNK_ID_NBR
BRANCH_ID
Member(s) of "PS1EBK_BANK_BRANCH" Index
BENEF_BRANCH_AC
BNK_ID_NBR
BRANCH_ID

Published June 06, 2007