PeopleSoft 9.0
Cash Management

Table Name BANK_ACCT_CPTY

Table Description
BANK_ACCT_CPTY
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
BANK_CD CHAR(5) Yes Yes
BANK_CD_CPTY CHAR(5) Yes Yes
BANK_ACCT_KEY CHAR(4) Yes Yes
COUNTERPARTY CHAR(5) Yes Yes
BANK_CD_CUST CHAR(5) No No
BUSINESS_UNIT_GL CHAR(5) No No
BANK_ACCOUNT_NUM CHAR(17) No No
BANK_ACCT_SVC_SW CHAR(1) No No
Index
Name Type Unique Member
PS_BANK_ACCT_CPTY PK Yes
PSABANK_ACCT_CPTY IE1 No
Member(s) of "PS_BANK_ACCT_CPTY" Index
SETID
BANK_CD
BANK_CD_CPTY
BANK_ACCT_KEY
COUNTERPARTY
Member(s) of "PSABANK_ACCT_CPTY" Index
SETID
BANK_CD_CUST
COUNTERPARTY
BANK_ACCT_KEY

Published April 30, 2007