Account’s Payables Suppliers Loader Process Details

Account’s Payables Suppliers Loader Process Details

 

 Supplier Conversion :
    -------------------
    Pre-Requisites:
    --------------
      a) Set-up Operating unitsm responsibilities, system profile options.
      b) Setup GL Account codes, ap distribution sets and bank accounts
      c) Setup Financial options and payable options
      d) Setup Supplier Classification , supplier types
      e) setup payment terms, paygroups, freight terms shipping methods
      f) setup tax codes and supplier numbering financial option

  Interface Tables:
  ----------------
      AP_SUPPLIERS_INT
      AP_SUPPLIER_SITES_INT
      AP_SUP_SITE_CONTACT_INT

  Base Tables :
  -----------
      PO_VENDORS \ AP_SUPPLIERS
      PO_VENDOR_SITES_ALL\AP_SUPPLIER_SITES_ALL
      PO_VENDOR_CONTACTS\AP_SUPPLIERS_CONTACTS

  Interface Programs:
  ------------------
       Supplier Open Interface Import
       Supplier Sites Open Interface Import
       Supplier Site Contacts Open Interface Import
 
  Parameters To Be Passesd During the program:
  -------------------------------------------
       Import Options        = All  (all, new, rejected)
       Batch_size            = 1000
       Print exceptions only = No
       Debug Switch          = No
       Trace Switch          = No

  Main Colums in AP_SUPPLIERS_INT:
  -------------------------------
          vendor_interface_id      

vendor_name      

segment1
          pay_group_lookup_code    

set_of_books_id\ledger_id  

organization_type_lookup_code
          vendor_type_lookup_code  

enabled_flag    

biil_to_location_id
          terms_id                

terms_name ,

num_1099,

type_1099

  Main Colums in AP_SUPPLIER_SITES_INT:
  ------------------------------------
          vendor_interface_id        

vendor_site_code  

vendor_site_id
          pay_group_lookup_code      

terms_name        

payment_method_lookup_code
          prepay_code_combination_id

default_pay_site_id

   Main Colums in AP_SUPPLIER_SITE_CONTACTS_INT:
  ---------------------------------------------
          vendor_site_id,

vendor_site_name

  Validation Tables :
  -----------------
          PO_VENDORS   \ AP_SUPPLIERS

FND_LOOKUP_CODES  

HR_LOCATIONS_ALL
          AP_TERMS_ALL AP_TAX_CODES_ALL  

                    GL_CODE_COMBINATIONS