AP TABLES FOR 11i

Account payables data model (Important tables) Ver 1.0

For preliminary understanding, we will break the Module functionality into following components:

1)      AP setups

2)      Invoice Workbench

3)      Payments workbench

4)      Invoice and Payments accounting

5)      Interfaces

We will take each component one by One:

1)      AP setups

Vendors

Vendors                                  :           PO_VENDORS

                                                           

Vendors Sites                          :           PO_VENDOR_SITES_ALL

Banks

Banks and bank branches       :           AP_BANK_BRANCHES

Bank accounts                         :           AP_BANK_ACCOUNTS_ALL

Payable Documents                :           AP_CHECK_STOCKS_ALL

Pay terms

Payment Terms                       :           AP_TERMS

Pay Term Lines                       :           AP_TERM_LINES

Payables options

            Payables options                     :           AP_SYSTEM_PARAMETERS

            Distribution sets

            Distribution sets                      :           AP_DISTRIBUTION_SETS_ALL

            Distribution set lines               :           AP_DISTRIBUTION_SET_LINES_ALL

     2)    Invoice Workbench     :

            Invoice Batch                          :           AP_BATCHES_ALL

            Invoice Headers                      :           AP_INVOICES_ALL

            Invoice Distributions              :           AP_INVOICE_DISTRIBUTIONS_ALL

            Invoice Scheduled Payments  :           AP_PAYMENT_SCHEDULES_ALL

            Invoice Holds                         :           AP_HOLDS_ALL

      3)   Payments Workbench :

            Payment Batch Sets                :           AP_PBATCH_SETS_ALL

                                                                        AP_PBATCH_SET_LINES_ALL

            Payments                                 :           AP_CHECKS_ALL

                                                                        AP_INVOICE_PAYMENTS_ALL

            Payment Distributions                        :           AP_PAYMENT_DISTRIBUTIONS_ALL

4)      Invoice and payments accounting :

Accounting Events                 :           AP_ACCOUNTING_EVENTS_ALL

Accounting Headers               :           AP_AE_HEADERS_ALL

Accounting Lines                    :           AP_AE_LINES_ALL

5)      Interfaces

Invoice interface                     :           AP_INVOICES_INTERFACE

                                                            AP_INVOICE_LINES_INTERFACE

      Supplier/Vendor interface       :           AP_SUPPLIERS_INT

AP_SUPPLIER_SITES_INT

AP_SUP_SITE_CONTACT_INT