1) Payables Interface:
-----------------
Pre-requisites:
--------------
a) Vendors and their Sites Should Be Setup
b) Currency and exchange Rates Should Be setup
c) Source and invoice type lookup code must be defined
d) Account Payables Account and Distribution Account must be defined.
e) Payment Terms should be defines and GL Period must be in opened status.
Interface Tables:
----------------
AP_INVOICES_INTERFACE
AP_INVOCE_LINES_INTERFACE
BASE TABLES :
------------
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_PAYMENT_SCHEDULES
INTERFACE PROGRAM:
-----------------
Payables Open Interface Import
Parameters to be passed during the program:
-----------------------------------------
Source = External
group_id = As Specified in the data file
Batch Name = N/A
Hold Name = null
Hold Reason = null
gl date = null
Purge = No
Summarize = No
Error Tables:
------------
AP_INTERFACE_REJECTIONS
AP_INTERFACE_CONTROLS
Main Columns In AP_INVOICES_INTERFACE:
--------------------------------------
INVOICE_ID, INVOICE_NUM, INVOICE_DATE ,INVOICE_AMOUNT
VENDOR_ID , VENDOR_NUM, VENDOR_NAME ,VENDOR_SITE_CODE, VENDOR_SITE_ID
TERMS_NAME, TERM_ID, TERM_DATE, SOURCE, PAYMENT_METHOD_LOOKUP_CODE,
GL_DATE, PO_NUMBER, INVOICE_CURRENCE_CODE, EXCHANGE_RATE_TYPE
VOUCHER_NUMBER, PAYMENT_CURRENCY_CODE, DOC_CATEGPRY_CODE
Main Columns In AP_INVOICE_LINES_INTERFACE:
------------------------------------------
INVOICE_ID , INVOICE_LINE_ID , LINE_NUM, LINE_TYPE_LOOKUP_CODE
AMOUNR , DIST_CODE_COMBINATION_ID, DIST_CODE_CONCATENATED
PO_HEADER_ID, PO_LINE_ID, PO_LINE_NUMBER
Tables To Be Used For Validation:
--------------------------------
PO_VENDORS AP_TERMS ORG_ORGANIZATION_DEFINITIONS
FND_CURRNECIES AP_INVOICES_ALL GL_DAILY_CONVERSION_TYPES
GL_CODE_COMBINATIONS AP_LOOKUP_CODES GL_PERIOD_STATUSES
===============================================================
2) Journal Ledger Interface:
------------------------
Pre-Requisites:
--------------
a) set of books should be defined
b) Current Conversion rates and accounting periods need to be defines
c) Source and Category Name Should be defined
Interface Tables:
----------------
GL_INTERFACE
Base Tables:
-----------
GL_JE_HEADERS
GL_JE_LINES
GL_JE_BATCHES
Validation Columns:
------------------
Source period_name currency_code set_of_books_id
je_source je_catregory accounting_date entered_dr , entered_cr
accounted_cr accounted_dr encumberance_type_id
Source = 'NEW'
period need to be open status in gl_period_statuses
souce_name defined in gl_je_source table
category_name defines gl_je_Category
currency available in fnd_Currencies
accounted_cr and accounted_dr total should be same.
===================================================================================
3) 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
PO_VENDOR_SITES_ALL
PO_VENDOR_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 segmebnt1
pay_group_lookup_code set_of_books_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 vebdor_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 FND_LOOKUP_CODES HR_LOCATIONS_ALL
AP_TERMS_ALL AP_TAX_CODES_ALL GL_CODE_COMBINATIONS
================================================================================
4) Purchase Order Interface :-
------------------------
Pre-Requisites:
--------------
Suppliers,Sites and contact details should be defined.
Organization Structure Should Be defined.
Ship_to and bill_to locations should be defined.
set of books, items, item categories, UOM(Unit of measures) Defined.
Employee Creation and Buyer Setup should be done.
Interface Tables:
----------------
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
Base Tables:
-----------
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
Interface Program:
-----------------
Import Standard Interface Program
Parameters to be passed during the program:
--------------------------------------------
Default = NULL
Create or Updated Items = No
PO Status = Appproved(Approved/Incomplete/Initial Approved)
Batch_id = We can get from interface header table
Error Table:
-----------
PO_INTERFACE_ERRORS
Main Columns in PO_HEADERS_INTERFACE:
------------------------------------
VENDOR_ID VENDOR_SITE_ID VENDOR_CONTACT_ID
AGENT_NAME ORG_ID DOCUMENT_TYPE_CODE
CREATION_DATE CURRENCY_CODE SHIP_TO_LOCATION BILL_TO_LOCATION
Main Columns in PO_LINES_INTERFACE:
----------------------------------
LINE_NUM LINE_TYPE ITEM_ID ITEM
ITEM_DESCRIPTION CATEGORY_ID QUNATITY UNIT_OF_MEASURE
UNIT_PRICE NEED_BY_DATE PROMISE_DATE
SHIP_TO_ORGANIZATION_ID ORG_ID SHIP_TO_LOCATION_ID
Tables To Be Used For Validation:
--------------------------------
PO_VENDORS PO_VENDOR_SITES_ALL
PO_VENDOR_CONTACTS PER_ALL_PEOPLE_F
HR_OPERATING_UNITS FND_CURRENCIES HR_LOCATIONS
PO_LINE_TYPES MTL_SYSTEM_ITEMS_B MTL_CATEGORIES
MTL_UNITS_OF_MEASURE ORG_ORGANIZATION_DEFINITIONS
No comments:
Post a Comment