EBS AP、AR所有含CCID的业务表.docx

/benio/archive/2010/11/28/1890187.htmlEBS AP、AR所有含CCID的业务表AP、AR所有含有CCID的业务表.要求字段：单据号、日期、客户或供应商、账户、DR、CR。?一个AP的发票和付款的----应付模块对帐语句? ? ? ? ? ? ? ? ? ? ? ? ??----将指定日期范围内的所有的应付发票和付款分录全部按供应商地点取出? ? ? ? ? ? ? ? ? ? ? ? ? ?----可按科目或其他方式对帐? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?----本月发票? ? ? ? ? ? ? ??select pv.vendor_name, pv.segment1, pvs.vendor_site_code, ai.invoice_num, ai.gl_date, ai.invoice_currency_code, ai.invoice_type_lookup_code, aae.event_type_code, aae.source_table, aal.ae_line_type_code, gcc.concatenated_segments, gcc.segment2, gcc.segment3, aal.entered_dr, aal.entered_cr, aal.accounted_dr, aal.accounted_cr, abs(nvl(aal.accounted_dr,0)- nvl(aal.accounted_cr,0))?from ap_invoices_all ai,?ap_accounting_events_all aae,?ap_ae_headers_all aah,?ap_ae_lines_all aal,?po_vendors pv,?po_vendor_sites_all pvs,?gl_code_combinations_kfv gccwhere ai.INVOICE_ID = aae.SOURCE_IDand? ?aae.SOURCE_TABLE = AP_INVOICES? ?? ?--AP_CHECKSand? ?aae.accounting_event_id = aah.accounting_event_idand? ?aah.ae_header_id = aal.ae_header_idand? ?ai.vendor_id = pv.vendor_idand? ?ai.vendor_site_id = pvs.vendor_site_idand? ?aal.code_combination_id = gcc.code_combination_idand? ?ai.gl_date = to_date(2007-08-01,yyyy-mm-dd)and? ?_id = 102union all----本月付款? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?select pv.vendor_name,? ? ? ?? pv.segment1, pvs.vendor_site_code, to_char(ac.check_number), ac.check_date, ac.currency_code, ac.bank_account_name,? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?? ???--ai.invoice_type_lookup_code, aae.event_type_code, aae.source_table, aal.ae_line_type_code, gcc.concatenated_segments, gcc.segment2, gcc.segment3, aal.entered_dr, aal.entered_cr, aal.accounted_dr, aal.accounted_cr, abs(nvl(aal.accounted_dr,0)- nvl(aal.accounted_cr,0))from ap_checks_all ac,?ap_accounting_events_all aae,?ap_ae_headers_all aah,?ap_ae_lines_all aal,?po_vendors pv,?po_vendor_sites_all pvs,?gl_code_combinations_kfv gccwhere ac.check_id = aae.SOURCE_IDand? ?aae.SOURCE_TABLE = AP