BANK_CURR_AP_VW

(SQL View)
Index Back

Bank Account Currency AP Vw


SELECT SETID , BANK_CD , BANK_ACCT_KEY , CURRENCY_CD , CUR_RT_TYPE , DEFAULT_CURR_SW FROM PS_BANK_ACCT_CURR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

5 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
6 DEFAULT_CURR_SW Character(1) VARCHAR2(1) NOT NULL Default Currency

Y/N Table Edit