PeopleSoft 9.0
Cash Management

Table Name BANK_ACCT_CHRT

Table Description
BANK_ACCT_CHRT
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_ACCT_LED_TYPE CHAR(1) Yes No
ACCOUNT CHAR(10) No No
ALTACCT CHAR(10) No No
DEPTID CHAR(10) No No
OPERATING_UNIT CHAR(8) No No
PRODUCT CHAR(6) No No
FUND_CODE CHAR(5) No No
CLASS_FLD CHAR(5) No No
PROGRAM_CODE CHAR(5) No No
BUDGET_REF CHAR(8) No No
AFFILIATE CHAR(5) No No
AFFILIATE_INTRA1 CHAR(10) No No
AFFILIATE_INTRA2 CHAR(10) No No
CHARTFIELD1 CHAR(10) No No
CHARTFIELD2 CHAR(10) No No
CHARTFIELD3 CHAR(10) No No
PROJECT_ID CHAR(15) No No
Index
Name Type Unique Member
PS_BANK_ACCT_CHRT PK Yes
Member(s) of "PS_BANK_ACCT_CHRT" Index
SETID
BANK_CD
BANK_CD_CPTY
BANK_ACCT_KEY
COUNTERPARTY
BANK_ACCT_LED_TYPE

Published April 30, 2007