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