Account Payable - Creating AP Invoice , CM - Credit Memo , DM

Account Payable - AP Invoice , CM - Credit Memo , DM - Debit Memo .
A very common requirement is creating AP INV, CM, DM using interface. lets have a look.

Scenario - Data for Invoices , CM ,DM from legacy system to Oracle Application.In common case companies multiple ERP's but want to maintain GL in Oracle.

Step 1 - Lets create a temp table in which we will dump data from legacy system.table contains all required columns for interface.

Considering Vendor and site is already created in Oracle.

CREATE TABLE APPS.KER_AP_INVOICES_NOV10_3
(
INVOICE_ID NUMBER(15) NOT NULL,
INVOICE_NUM VARCHAR2(50 BYTE) NOT NULL,
INVOICE_DATE DATE,
TERMS_DATE DATE,
INVOICE_TYPE VARCHAR2(25 BYTE),
VENDOR_ID NUMBER(15) NOT NULL,
VENDOR_SITE_ID NUMBER(15),
INVOICE_CURRENCY_CODE VARCHAR2(15 BYTE) NOT NULL,
INVOICE_AMOUNT NUMBER,
BALANCE_AMOUNT NUMBER,
EXCHANGE_RATE NUMBER,
EXCHANGE_RATE_TYPE VARCHAR2(30 BYTE),
EXCHANGE_DATE DATE,
BALANCE_AMOUNT_BD NUMBER,
DIVISION CHAR(3 BYTE),
REFERENCE VARCHAR2(240 BYTE),
VOUCHER_NUMBER NUMBER,
GL_DATE DATE NOT NULL,
VENDOR_NUMBER VARCHAR2(30 BYTE),
VENDOR_NAME VARCHAR2(240 BYTE)
) ;

Sample Data -
INVOICE_ID = 252665
INVOICE_NUM = A0012107.47
INVOICE_DATE = 10/12/2010
TERMS_DATE = 11/11/2010
INVOICE_TYPE = STANDARD
VENDOR_ID = 777
VENDOR_SITE_ID = 974
INVOICE_CURRENCY_CODE = EUR
INVOICE_AMOUNT = 1195.58
BALANCE_AMOUNT = 1195.58
EXCHANGE_RATE = 0.51
EXCHANGE_RATE_TYPE = User
EXCHANGE_DATE = 10/24/2010
BALANCE_AMOUNT_BD = 609.7458
DIVISION = 104 (DFF)
REFERENCE = DR.201002341
VOUCHER_NUMBER = 92009193
GL_DATE = 10/24/2010
VENDOR_NUMBER = 100777
VENDOR_NAME = IVECO S.P.A