How to Upload Sales Data with line Attachment JD Edwards

This is my process to upload the Data in F4211/F4201 with Attachment completeled tested:
1> inset data from excel to JD Edwards table :
--upload to temp order file
delete from proddta.f554084a
insert testdta.f554084a
SELECT [detail key] UKID,[client id] AN8,[line #]*1000 lineno1,
(datepart(yy,[order date]) - 1900) * 1000+ cast(datepart(dy,[order date])as int) orderdate,
'00870' company,[client id] AN8,[client id] Shan,
product,[Branch plant] bp,quantity,[Dollar Amount],
(datepart(yy,[order date]) - 1900) * 1000+ cast(datepart(dy,[order date])as int) Addj,
'USD' Curr,'' edsp,[customer po] ARGS, 'SQL' cUser ,'SQL-SERVER' Pid,
(datepart(yy,getdate()) - 1900) * 1000+ cast(datepart(dy,getdate())as int) cdate,'120000.0'ctime
FROM XLTEST_SP...upload1$ order by [client id]

2> Run R554784 to load data in F47012/F47011

3>Insert Data in Comment detail file F4715

insert testdta.F4715
select 8 szedty,1 szedsq,szkcoo,szedoc,szedct,szedln,'' szedsp,szedbt,'F47012' ZDFILE,szkcoo,szdoco,szdcto,szlnid,''PNTC,
f4*100 Lins,comment,'SQL','SQL',
'SQL','SQL','108177','120000'
from XLTEST_SP...upload2$
left outer join testdta.f47012 on szdmct=ukid
--where szdoco=410123.0 and szlnid=1000 and f4<10
order by szdoco,szlnid,f4
4>Run R47011 to load data in F4211/F4201 and also comment in item line level.

www.visli.com