发票、付款

/*发票*/
SELECT *
  FROM ap_batches_all apa; --发票批次表

SELECT *
  FROM ap_invoices_all aia; --发票表

SELECT *
  FROM gl_sets_of_books;

SELECT *
  FROM ap_invoice_distributions_all aid; --发票分配表   发票行明细表

SELECT *
  FROM ap_invoices_interface; --发票接口表

--表之间的关联
AP_BATCHES_ALL. BATCH_ID = AP_INVOICES_ALL. BATCH_ID
AP_INVOICES_ALL. INVOICE_ID = AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_ID


/*付款 */
SELECT * FROM AP_CHECKS_ALL ; --付款表

SELECT * FROM AP_INVOICE_PAYMENTS_ALL ; --发票付款表

--表之间的关联
AP_CHECKS_ALL. CHECK_ID = AP_INVOICE_PAYMENTS_ALL. CHECK_ID
AP_INVOICE_PAYMENTS_ALL. INVOICE_ID = AP_INVOICES_ALL. INVOICE_ID

/*其他*/
SELECT * FROM  AP_ACCOUNTING_EVENTS_ALL;--应付事件表
SELECT * FROM AP_AE_HEADERS_ALL;--应付会计分录头信息表
SELECT * FROM AP_AE_LINES_ALL ;--应付会计分录行信息表