AP 付款凭证

模块：AP

相关表：AP.AP_CHECKS_ALL  ACA   AP付款头信息表

            AP.AP_INVOICE_PAYMENTS_ALL  AIP  AP发票-付款关联信息表

            CE_BANK_ACCOUNTS  CBA  银行帐户信息表
            CE_BANK_ACCT_USES_ALL  CBAU  付款银行关系表

            CE_BANK_BRANCHES_V   CBB

            ce_payment_documents    付款单据

其他：（ACA.CE_BANK_ACCT_USE_ID = CBAU.bank_acct_use_id(+)
           AND CBAU.bank_account_id = CBA.bank_account_id(+)  AND CBA.BANK_BRANCH_ID = CBB.bank_party_id(+)）

 

SQL：

SELECT ACA.CHECK_NUMBER,
       PV.SEGMENT1 VENDOR_CODE,
       PV.VENDOR_NAME,
       ACA.CHECK_DATE,
       ACA.CURRENCY_CODE,
       ACA.EXCHANGE_RATE,
       ACA.PAYMENT_DOCUMENT_ID,
       PD.PAYMENT_DOCUMENT_NAME,     --付款单据
       AIA.INVOICE_NUM,
       AIA.INVOICE_AMOUNT,
       AIP.AMOUNT
FROM AP.AP_CHECKS_ALL ACA,
     AP.AP_INVOICE_PAYMENTS_ALL AIP,
     CE.CE_BANK_ACCOUNTS        CBA,
     CE.CE_BANK_ACCT_USES_ALL   CBAU,
     CE_BANK_BRANCHES_V         CBB,
     AP.AP_INVOICES_ALL         AIA,
     APPS.PO_VENDORS            PV,
     ce_payment_documents        PD
WHERE ACA.CHECK_ID = AIP.CHECK_ID
  AND ACA.CE_BANK_ACCT_USE_ID = CBAU.BANK_ACCT_USE_ID(+)
  AND CBAU.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID(+)
  AND CBAU.ORG_ID = AIP.Org_Id(+)
  AND CBA.BANK_BRANCH_ID = CBB.bank_party_id(+)
  AND AIP.Invoice_Id = AIA.INVOICE_ID
  AND AIA.VENDOR_ID = PV.VENDOR_ID
  AND ACA.PAYMENT_DOCUMENT_ID = PD.payment_document_id(+)
  AND ACA.CHECK_NUMBER = '9'