BNK_CD_CMPL_VW3

(SQL View)
 Index Back

Complex Routing Banks (GL BU)

Prompting view that shows only those Corporate bank codes that have accounts defined and which are not assigned for use by the products. Used on records where bank code/account are entered in combination. Set Control Field = BUSINESS_UNIT_GL

SELECT DISTINCT A.SETID , A.BANK_CD , A.DESCR , A.DESCRSHORT FROM PS_BANK_CD_TBL A , PS_BANK_ACCT_DEFN B WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_TYPE = 'E' AND A.BANK_STATUS = 'A' AND B.AR = 'N' AND B.AP = 'N' AND B.TR = 'N' AND B.BI = 'N'

  • Related Language Record: BNK_CDCMPL_LVW3

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description