CSH_CLRBKACVWLG

(SQL View)
 Index Back

AP Cash Clrg Bank Acct View


SELECT a.setid , a.bank_cd , a.bank_acct_key , g.language_cd , a.bank_account_num , g.descr , a.draft_cntl_use_flg , a.cash_cntl_use_flg FROM PS_BANK_ACCT_TBL a , ps_bank_acct_lg_vw g WHERE EXISTS ( SELECT 'x' FROM ps_bank_acct_chrt b WHERE b.setid = a.setid AND b.bank_cd = a.bank_cd AND b.bank_acct_key = a.bank_acct_key AND b.bank_acct_led_type = 'C') AND ((a.cash_cntl_use_flg = 'Y' AND EXISTS ( SELECT 'x' FROM ps_bank_acct_chrt c WHERE c.setid = a.setid AND c.bank_cd = a.bank_cd AND c.bank_acct_key = a.bank_acct_key AND c.bank_acct_led_type = 'L')) OR (a.draft_cntl_use_flg = 'Y' AND EXISTS ( SELECT 'x' FROM ps_bank_acct_chrt d WHERE d.setid = a.setid AND d.bank_cd = a.bank_cd AND d.bank_acct_key = a.bank_acct_key AND d.bank_acct_led_type = 'D'))) AND a.setid = g.setid AND a.bank_cd = g.bank_cd AND a.bank_acct_key = g.bank_acct_key

  • Related Language Record for CSH_CLR_BKAC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
    3 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
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DRAFT_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Drafts Payable
    8 CASH_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Cash Clearing