BNK_CDCMPL_LVW3

(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 PS_BANK_CD_LNG.SETID ,PS_BANK_CD_LNG.BANK_CD ,PS_BANK_CD_LNG.LANGUAGE_CD ,PS_BANK_CD_LNG.DESCR ,PS_BANK_CD_LNG.DESCRSHORT FROM PS_BANK_CD_TBL ,PS_BANK_ACCT_DEFN ,PS_BANK_CD_LNG WHERE PS_BANK_CD_TBL.SETID = PS_BANK_ACCT_DEFN.SETID AND PS_BANK_CD_TBL.BANK_CD = PS_BANK_ACCT_DEFN.BANK_CD AND PS_BANK_CD_TBL.BANK_TYPE = 'E' AND PS_BANK_CD_TBL.BANK_STATUS = 'A' AND PS_BANK_ACCT_DEFN.AR = 'N' AND PS_BANK_ACCT_DEFN.AP = 'N' AND PS_BANK_ACCT_DEFN.TR = 'N' AND PS_BANK_ACCT_DEFN.BI = 'N' AND PS_BANK_CD_TBL.SETID = PS_BANK_CD_LNG.SETID AND PS_BANK_CD_TBL.BANK_CD = PS_BANK_CD_LNG.BANK_CD

  • Related Language Record for BNK_CD_CMPL_VW3

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