INVOICE OPEN INTERFACE (contorl & text_files)

      INVOICE HEADER DATA FILE

==========================

24266411,ERS-INV_I1312,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266422,ERS-INV_I1412,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266433,ERS-INV_I1512,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266444,ERS-INV_I1612,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266455,ERS-INV_I1712,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266466,ERS-INV_I1812,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266477,ERS-INV_I1912,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266488,ERS-INV_I2012,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266499,ERS-INV_I2112,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

24266587,ERS-INV_I2212,STANDARD,20-jul-2011,600,3M Health Care,5037,1414,500,USD,,USD,10002,ERS,204,20-jul-2011,20-jul-2011

      INVOICE HEADER CONTROL FILE

===========================

LOAD DATA

INFILE '/oracle2/VIS1211/apps/apps_st/appl/ap/12.0.0/bin/xx_ap_inv.txt'

INSERT INTO TABLE xx_ap_invoices

FIELDS TERMINATED BY ',' TRAILING NULLCOLS

(invoice_id,

invoice_num,

invoice_type_lookup_code,

invoice_date,

vendor_id,

VENDOR_NAME,

VENDOR_NUM,

vendor_site_id,

invoice_amount,

invoice_currency_code,

PAYMENT_METHOD_LOOKUP_CODE,

PAYMENT_CURRENCY_CODE,

terms_id,

source,

org_id,

gl_date,

TERMS_DATE)

      INVOICE HEADER LINE FILE

==========================

24266411,1,ITEM,Pendrives74,500,Each,50,10,,26801181,204

24266422,1,ITEM,Mobiles74,500,Each,50,10,,26801191,204

24266433,1,ITEM,Bags74,500,Each,50,10,,26801201,204

24266444,1,ITEM,Pens74,500,Each,50,10,,26801211,204

24266455,1,ITEM,Pencils74,500,Each,50,10,,26801221,204

24266466,1,ITEM,Torches74,500,Each,50,10,,26801231,204

24266477,1,ITEM,Phones74,500,Each,50,10,,26801241,204

24266488,1,ITEM,Notepads74,500,Each,50,10,,26801251,204

24266499,1,ITEM,Keyboards74,500,Each,50,10,,26801261,204

24266878,1,ITEM,Notebooks74,500,Each,50,10,,26801271,204

    INVOICE HEADER CONTROL FILE

===========================

LOAD DATA

INFILE '/oracle2/VIS1211/apps/apps_st/appl/ap/12.0.0/bin/xx_ap_inv_lines.txt'

INSERT INTO TABLE xx_ap_invoice_lines

FIELDS TERMINATED BY ',' TRAILING NULLCOLS

(invoice_id,

line_number,

line_type_lookup_code,

description,

amount,

unit_of_meas_lookup_code,

unit_price,

QUANTITY,

DIST_CODE_COMBINATION_ID,

invoice_line_id,

ORG_ID)