CSH_CLR_BKAC_VW

(SQL View)
 Index Back

AP Cash Clrg Bank Acct View


SELECT a.setid , a.bank_cd , a.bank_acct_key , a.bank_account_num , a.descr , a.draft_cntl_use_flg , a.cash_cntl_use_flg FROM PS_BANK_ACCT_TBL a 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')))

  • Related Language Record: CSH_CLRBKACVWLG

    • # 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 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DRAFT_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Drafts Payable
    7 CASH_CNTL_USE_FLG Character(1) VARCHAR2(1) NOT NULL Cash Clearing