BANK_CD_INT_VW2

(SQL View)
 Index Back

Internal Banks/Counterparties

Prompting view that shows only those bank codes that have accounts defined. Used on records where bank code/account are entered in combination. RJB 10-27-2003 Selects only those internal banks that are defined as servicers for use as the Bank on Internal Transfers. Record Group FS_39

SELECT A.SETID ,A.BANK_CD ,B.BANK_CD_CPTY ,A.BUSINESS_UNIT_GL ,A.TREASURY_SW ,A.DESCR ,A.DESCRSHORT ,A.DESCR_AC FROM PS_BANK_CD_TBL A , PS_BANK_ACCT_CPTY B WHERE A.BANK_TYPE='I' AND A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT_GL AND BANK_ACCT_SVC_SW = 'Y'

  • Related Language Record: BANK_CD_LNG

    • # 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_CD_CPTY Character(5) VARCHAR2(5) NOT NULL An internal key field convention that facilitates the system distinction between banks and counterparties.
    4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    5 TREASURY_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank/counterparty also serves as the internal corporate t
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description