EM_SP_BKAC_BULG

(SQL View)
 Index Back

Bank Accounts by BU - Language

Related language view of EM_SP_BKAC_BUVW

SELECT DISTINCT sbk.business_unit , bk.setid , bk.bank_cd , bk.bank_acct_key , LANG.LANGUAGE_CD , bk.bank_account_num , LANG.descrshort , LANG.descr FROM ps_em_sec_bu_bank sbk , PS_BANK_ACCT_TBL bk , PS_BANK_ACCT_LG_VW 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 AND sbk.bank_acct_key = bk.bank_acct_key AND BK.BANK_ACCT_KEY = LANG.BANK_ACCT_KEY

  • Related Language Record for EM_SP_BKAC_BUVW

    • # 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 EM_BANK_CD Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents a bank or counterparty.
    4 EM_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description