BAX_ACCT_VW1

(SQL View)
 Index Back

"From" Account Partner Prompt

Account partner Prompt from the FROM side of the transfer. Used to limit the Customer bank account to only valid partners

SELECT DISTINCT A.SETID ,A.COUNTERPARTY ,A.BANK_CD_CUST ,B.DESCR FROM PS_BANK_ACCT_CPTY A ,PS_BANK_CD_TBL B WHERE A.SETID = B.SETID AND A.BANK_CD_CUST = B.BANK_CD

  • Related Language Record: BAX_ACCT_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    3 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description