Wednesday, 16 October 2013

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

1 comment:

  1. Slot Machine Casino Resort, St. Croix | JTM Hub
    Get ready 이천 출장마사지 for 춘천 출장안마 the hottest 공주 출장마사지 games and excitement - Slot Machine Casino Resort at JTM Hub! Featuring live games, 양산 출장샵 interactive food and beverage 평택 출장안마 choices,

    ReplyDelete