Vendor conversion/interface

Vendor conversion/interface

This interface is used to import suppliers, supplier sites and site contacts into Oracle applications.

Pre-requisites:

• Payment terms
• Pay Groups
• CCID
• Supplier classifications
• Bank Accounts
• Employees (if employees have to set up as vendors)

Interface tables:

• AP_SUPPLIERS_INT
• AP_SUPPLIER_SITES_INT
• AP_SUP_SITE_CONTACT_INT

Base Tables:

• PO_VENDORS
• PO_VENDOR_SITES_ALL
• PO_VENDOR_CONTACTS

Interface programs:

• Supplier Open Interface Import
• Supplier Sites Open Interface Import
• Supplier Site Contacts Open Interface Import

Validations:

• Check if vendor already exists
• Check if vendor site already exists
• Check if site contact already exists
• Check if term is defined.

Important Columns:

Some important columns that need to be populated in the interface tables:

AP_SUPPLIERS_INT:

• VENDOR_NUMBER
• VENDOR_NAME
• VENDOR_TYPE
• STATE_REPORTABLE
• FED_REPORTABLE
• NUM_1099,
• TYPE_1099
• PAY_GROUP_LOOKUP_CODE
• VENDOR_ID is auto generated.

AP_SUPPLIER_SITES_INT:

• VENDOR_SITE_ID
• ORG_ID
• VENDOR_SITE_CODE
• INACTIVE_DATE
• PAY_SITE
• PURCHASING_SITE
• SITE_PAYMENT_TERM
• ADDRESS1
• ADDRESS2
• ADDRESS3
• CITY
• STATE
• COUNTRY
• ZIP
• PH_NUM
• FAX_NUMBER
• TAX_REPORTING_SITE_FLAG

AP_SUP_SITE_CONTACTS_INT:

• VENDOR_ID
• VENDOR_SITE_ID
• FIRST_NAME
• LAST_NAME
• AREA_CODE
• PHONE
• EMAIL
• ORG_ID