AP invoice導入——擷取導入錯誤資訊

AP invoice接口導入的接口表包括：

• ap_invoices_interface
• ap_invoice_lines_interface

AP invoice接口導入的錯誤資訊表如下：

• ap_interface_rejections

擷取ap_invoices_interface表中字段invoice_id的值為1的錯誤資訊：

SELECT air.reject_lookup_code
  FROM ap_interface_rejections air, ap_invoices_interface aii
 WHERE air.parent_id = aii.invoice_id
   AND air.parent_table = 'AP_INVOICES_INTERFACE'
   AND aii.invoice_id = 1;
           

擷取ap_invoice_lines_interface表中字段invoice_line_id的值為1的錯誤資訊：

SELECT air.reject_lookup_code
  FROM ap_interface_rejections air, ap_invoice_lines_interface aili
 WHERE air.parent_id = aili.invoice_line_id
   AND air.parent_table = 'AP_INVOICE_LINES_INTERFACE'
   AND aili.invoice_line_id = 1;