FS_MAP_BNK_VW

(SQL View)
 Index Back

Bnk Acct View with ID_NBR

Bank Account View with bank ID Number

SELECT cd.setid , cd.bank_cd , acct.bank_acct_key , cd.bnk_id_nbr , acct.bank_account_num , acct.currency_cd , acct.deposit_bu FROM PS_BANK_CD_TBL cd , ps_bank_acct_tbl acct WHERE cd.setid = acct.setid AND cd.bank_cd = acct.bank_cd

# 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

Prompt Table: BANK_CD_TBL

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 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: USD

Prompt Table: CURRENCY_CD_TBL

7 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

Prompt Table: BU_AR_ALT