EM_SP_BKCD_BUL2

(SQL View)
Index Back

Marketpay-Bank code sec2 -Lang

Related language view of EM_SP_BKCD_BUV2

SELECT DISTINCT sbk.business_unit , bk.setid , bk.bank_cd , LANG.LANGUAGE_CD , LANG.descr , LANG.descrshort , LANG.descr_ac FROM ps_em_sec_bu_bank sbk , PS_BANK_CD_TBL bk , PS_BANK_CD_LNG LANG WHERE sbk.setid = bk.setid AND BK.SETID = LANG.SETID AND sbk.bank_cd = bk.bank_cd AND BK.BANK_CD = LANG.BANK_CD

  • Related Language Record for EM_SP_BKCD_BUV2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Prompt Table: SETID_TBL

    3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Description