PeopleSoft 9
Account Payables

Table Name BANK_ACCT_CURR

Table Description
BANK_ACCT_CURR
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BANK_CD_CPTY VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
CURRENCY_CD VARCHAR(3) Yes Yes
RATE_INDEX VARCHAR(10) No Yes
CUR_RT_TYPE VARCHAR(5) No Yes
DEFAULT_CURR_SW VARCHAR(1) No No
Index
Name Type Unique Member
PS_BANK_ACCT_CURR PK Yes
Member(s) of "PS_BANK_ACCT_CURR" Index
SETID
BANK_CD
BANK_CD_CPTY
BANK_ACCT_KEY
CURRENCY_CD

Published June 06, 2007