BNK_A_ST_LNG_VW

(SQL View)
 Index Back

Bank Acct Settlement by Curr


SELECT A.SETID, A.CURRENCY_CD, B.BANK_CD, A.BANK_ACCT_KEY, C.LANGUAGE_CD, C.DESCR FROM PS_BANK_ACCT_DEFN A, PS_BANK_CD_TBL B, PS_BANK_ACCT_LNG C WHERE A.SETID = B.SETID AND A.SETID = C.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_CD = C.BANK_CD AND B.BANK_TYPE = 'E'

  • Related Language Record for BANK_ACT_STL_VW

  • Parent record: BANK_CD_TBL

    • # 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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    3 STL_THRU_BANK Character(5) VARCHAR2(5) NOT NULL The intermediary transit bank/counterparty utilized for settlement purposes.
    4 STL_THRU_ACCT Character(4) VARCHAR2(4) NOT NULL The intermediary transit bank account utilized for settlement purposes.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description