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 |
10 comments:
Very good informative article. Thanks for sharing such nice article, keep on up dating such good articles.
NO.1 AQM Services | Application Quality Managment Services | Austere Technologies
wow...nice blog, very helpful information. Thanks for sharing.
NO.1 API DEVELOPMENT SERVICES | MASSIL TECHNOLOGIES
awsome blog.
seo service
Excellent informative blog, keep for sharing.
Best System Integration services | Massil Technologies
We find lots of learning after reading this very useful article .
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Those rules moreover attempted to wind up plainly a decent approach to perceive that other individuals online have the indistinguishable enthusiasm like mine to get a handle on incredible arrangement more around this condition
CRM with Invoicing
Wondering where to go in 2020? Things to do has ranked as the best include a remote, idyllic island and the design capital.
Post a Comment