Payables Interface Tables

By | April 7, 2016
Paybles Interface Table Purpose of Table
AP_INVOICES_INTERFACE AP_INVOICES_INTERFACE stores header information about invoices that you create or load for import. Invoice data comes from sources including: EDI invoices from your suppliers that you load through Oracle e-Commerce Gateway, supplier invoices that you transfer through the Oracle XML Gateway, invoices that you load using Oracle SQL*Loader, lease invoices from Oracle Property Manager, lease payments from Oracle Assets, credit card transaction data that you load using the Credit Card Invoice Interface Summary, and invoices that you enter through the Invoice Gateway. There is one row for each invoice you import. Your Oracle Payables application uses this information to create invoice header information when you submit the Payables Open Interface program.
Base Table: AP_INVOICES_ALL
AP_INVOICE_LINES_INTERFACE AP_INVOICE_LINES_INTERFACE stores information used to create one or more invoice distributions. Note that one row in this table may create, during the import process, more than one invoice distribution. For example, if you enter a Tax line in this table and prorate it across multiple Item lines, during Open Interface Import the system may create multiple Tax invoice distributions based on the single Tax line in this table.
Base Tables:
  1. AP_INVOICE_LINES_ALL
  2. AP_INVOICE_DISTRIBUTIONS_ALL
AP_INTERFACE_REJECTIONS AP_INTERFACE_REJECTIONS stores information about invoice data from the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables which could not be processed by Payables Open Interface Import. If you use Oracle e-Commerce Gateway, you can pass information from this table to your suppliers by submitting the Payables Open Interface Outbound Advice for rejected data. You can purge data in this table by using the Payables Open Interface Purge.
AP_SUPPLIERS_INT AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The Oracle Payables application uses this information to create a new Supplier record when the Supplier Open Interface Import program is submitted.
Base Table: AP_SUPPLIERS
AP_SUPPLIER_SITES_INT This is the open interface table for importing supplier sites from external sources and it should be used in conjunction with AP_SUPPLIERS_INT table. AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information, which is loaded by the user for import. The Oracle Payables application uses this information to create a new Supplier Site record when the Supplier Sites Open Interface Import program is submitted.
Base Tables:
  1. HZ_LOCATIONS
  2. HZ_PARTY_SITES
  3. AP_SUPPLIER_SITES_ALL
AP_SUP_SITE_CONTACT_INT This is the open interface table for importing supplier site contacts from external sources. It can be used in conjuction with AP_SUPPLIERS_INT & AP_SUPPLIER_SITES_INT or separately to import supplier site contacts. The Oracle Payables application uses this information to create a new Supplier Contact record when the Supplier Sites Open Interface Import program is submitted.
Base Table: AP_SUPPLIER_CONTACTS
AP_SUPPLIER_INT_REJECTIONS Contains suppliers, sites, contacts rejections information which can be corectted from corrections window
WOW! Did you like this post? We'll send more interesting posts like Payables Interface Tables to you!
Enter your Email Address: