Monday, January 30, 2017

Oracle Apps: Payables Table structure


Oracle Apps Payable Table Structure:
Supplier Tables
AP_SUPPLIERS
This table replaces the old PO_VENDORS table.
It stores information about your supplier level attributes.
AP_SUPPLIER_SITES_ALL
It stores information about your supplier site level attributes.
IBY_EXTERNAL_PAYEES_ALL 
 stores Payee(supplier) information.
HZ_PARTIES
 Party data for the suppliers.
HZ_PARTY_SITES 
Party site data for the supplier sites.B4
Supplier Interface tables
ap_suppliers_int
Supplier Interface. Execute Supplier Open Interface Import Program
ap_supplier_sites_int
Supplier site interface. Execute "Supplier Sites Open Interface Import" Program
Invoice 
AP_INVOICES_ALL
It contains records for invoices you enter
AP_INVOICE_LINES_ALL
It contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
AP_INVOICE_DISTRIBUTIONS_ALL
It holds the distribution information that is manually entered or system-generated
Invoice Interface
AP_INVOICES_INTERFACE
Invoice Header Information. Run Payables Open Interface Import concurrent program
AP_INVOICE_LINES_INTERFACE
Invoice Lines and Distributions Information
Payments:
AP_CHECKS_ALL 
Check Header Information
AP_INVOICE_PAYMENTS_ALL
Details of Invoice paid by a Check/Payment
AP_PAYMENT_HISTORY_ALL 
AP_INV_SELECTION_CRITERIA_ALL
AP_SELECTED_INVOICES_ALL
AP_PAYMENT_DISTRIBUTIONS_ALL
CE_PAYMENT_DOCUMENTS 
AP_CHECK_STOCKS_ALL
IBY_PAY_SERVICE_REQUESTS  
Payment Process Request information  (11i Terminology is  Payment Batch)
IBY_PAY_INSTRUCTIONS_ALL 
Payment Instruction information
IBY_DOC_PAYABLES_ALL 
Invoice information stored by IBY for generating payment
IBY_PAYMENTS_ALL 
Payment Information
Accounting
XLA_EVENTS 
replaces AP_ACOCUNTING_EVENTS_ALL  
XLA_AE_HEADERS 
replaces AP_AE_HEADERS_ALL
XLA_AE_LINES
replaces AP_AE_LINES_ALL
Bank Accounts
CE_BANK_ACCOUNTS 
 AP_BANK_ACCOUNTS_ALL
CE_BANK_ACCT_USES_ALL  
replaces AP_BANK_ACCOUNT_USES_ALL
Credit Card Transactions Table
AP_EXPENSE_FEED_LINES
Use the Credit Card Transaction Interface Table to load transaction datafrom your credit card issuers into your Payables system. When younsubmit the Credit Card Transaction Validation and Exception Report, for records where the CREATE_DISTRIBUTION_FLAG is Y, Payables
uses the data in the AP_EXPENSE_FEED_LINES table to create distributions with proper accounts in the AP_EXPENSE_FEED_DISTS
table


No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...