GP_BNK_CUR_VL

(SQL View)
 Index Back

Prompt VW Currency code

Used for Add Mode search record for Bank File Entry Component

SELECT DISTINCT A.SRC_BANK_ID , D.LANGUAGE_CD , D.DESCRSHORT FROM PS_SRC_BANK A , PS_BANK_EC_TBL B , PS_CURRCD_TBL_LANG D WHERE D.CURRENCY_CD = A.CURRENCY_CD AND A.BANK_CD = B.BANK_CD

  • Related Language Record for GP_BNK_CUR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description