银行、支行、银行账号

来源：互联网发布：单例设计模式 java 编辑：程序博客网时间：2024/04/25 23:59

SELECT ibybanks.bank_name,                 --银行
       ibybanks.bank_branch_name,          --分行
       ibybanks.bank_account_num_electronic--银行帐号
FROM iby_external_payers_all iepa,
       iby_pmt_instr_uses_all ipiua,
       iby_ext_bank_accounts_v ibybanks
WHERE iepa.payment_function    = 'CUSTOMER_PAYMENT'
    --AND iepa.cust_account_id     = p_customer_id--客户帐号ID
    AND ibybanks.bank_account_id = ipiua.instrument_id
    AND ipiua.instrument_type    = 'BANKACCOUNT'
    AND ipiua.ext_pmt_party_id   = iepa.EXT_PAYER_ID
    AND ipiua.payment_function   = 'CUSTOMER_PAYMENT'
    AND sysdate BETWEEN ibybanks.start_date AND nvl(ibybanks.end_date,sysdate+1)

----------------------------------------------------------------------------------------------
1 银行账户表：ap_bank_accounts_all
分行（支行）表：ap_bank_branches
在新增银行账户时要选择对应的支行
2 供应商地点和银行账户对应关系表是：
ap_bank_account_uses_all ap_bank_account_uses_all中的vendor_site_id和external_bank_account_id
分别对应供应商地点表po_vendor_sites_all中的vendor_site_id和ap_bank_accounts_all中bank_account_id
3 供应商的银行账户不要维护科目组合（应该是地点中存在的ccid关联到了科目组合）

0 0