金算盤轉(zhuǎn)換用友腳本1-

1、use abc select c.* into pingzheng2010 from (select a.lngvoucherdetailid,a.lngvoucherid,a.lngrowid,a.strremark,a.lngaccountid,direction, a.dblamount,a.lngcustomerid,voucherno,year,b.bytperiod,b.strdate,number,b.lngoperatorid from voucherdetail1 a left join voucher1 b on a.lngvouch

2、erid=b.lngvoucherid where year='2010' c select * into pingzheng2010bf from pingzheng2010 alter table pingzheng2010bf add code varchar(50,renyuan varchar(50, mc float(8,md float(8,customer varchar(50,personid varchar(50, csupid varchar(50,pingdate datetime,remark varchar(50 -alter table

3、pingzheng2010bf add remark varchar(50 select * from pingzheng2010bf -修改借貸方金額字段 update pingzheng2010bf set mc=dblamount where intdirection='-1' update pingzheng2010bf set mc=0 where intdirection='1' update pingzheng2010bf set md=dblamount where intdirection='1' update pingzhen

4、g2010bf set md=0 where intdirection='-1' -修改科目 update a set a.code=b.bianma from pingzheng2010bf a left join account1 b on a.lngaccountid=b.lngaccountid update pingzheng2010bf set code='101' where lngaccountid=1 -修改人員 update a set a.personid=b.renyuan from pingzheng2010bf a left join

5、 operator b on a.lngoperatorid=b.lngoperatorid update a set a.renyuan=b.stroperatorname from pingzheng2010bf a left join operator b on a.lngoperatorid=b.lngoperatorid -修改客戶 update a set a.customer=b.bianma from pingzheng2010bf a left join customer9 b on a.lngcustomerid=b.lngcustomerid -修改缺少單位的客戶 -up

6、date a set a.customer=b.bianma from pingzheng2010bf a left join danwei b on a.lngcustomerid=b.lngcustomerid -where a.customer is null and a.lngcustomerid is not null and a.lngcustomerid <>'0' -修改REMARK -update a set a.remark=b.customer from pingzheng2010bf a left join remark b on a.lng

7、customerid=b.lngremarkid -開始導(dǎo)入數(shù)據(jù) insert into ufdata_001_2010.GL_accvouch( iperiod,csign,isignseq,ino_id,inid,dbill_date,idoc,cbill,ccheck,cbook,ibook,ccashier,iflag,ctext1,ctext2,cdigest,ccode,cexch_name, md,mc,md_f,mc_f,nfrat,nd_s,nc_s,csettle,cn_id,dt_date,cdept_id,cperson_id,ccus_id,csup_id,citem

8、_id,citem_class,cname,ccode_equal, iflagbank,iflagPerson,bdelete,coutaccset,ioutyear,coutsysname,coutsysver,doutbilldate,ioutperiod,coutsign,coutno_id, doutdate,coutbillsign,coutid,bvouchedit,bvouchAddordele,bvouchmoneyhold,bvalueedit,bcodeedit,ccodecontrol,bPCSedit,bDeptedit, bItemedit,bCusSupInput

9、,cDefine1,cDefine2,cDefine3,cDefine4,cDefine5,cDefine6,cDefine7,cDefine8,cDefine9,cDefine10,cDefine11, cDefine12,cDefine13,cDefine14,cDefine15,cDefine16,dReceive,cWLDZFlag,dWLDZTime,bFlagOut,iBG_OverFlag,cBG_Auditor,dBG_AuditTime, cBG_AuditOpinion,bWH_BgFlag,ssxznum,CErrReason,BG_AuditRemark,cBudget

10、Buffer,iBG_ControlResult,NCVouchID,daudit_date,RowGuid, cBankReconNo select bytperiod as iperiod,'記' as csign,'1'as isignseq,intvoucherno as ino_id,lngrowid as inid,strdate as dbill _date,intnumber as idoc,renyuan as cbill,null as ccheck,null as cbook,'0'as ibook,null as ccas

11、hier,null as iflag,null as ctext1,null as ctext2,strremark as cdigest,code as ccode,null as cexch_name, round(md,2 as md,round(mc,2 as mc,0 as md_f,0 as mc_f,0 as nfrat,0 as nd_s,0 as nc_s,null as csettle,null as cn_id,strdate as dt_date,csupid as cdept_id,csupid as cperson_id,customer as ccus_id,cs

12、upid as csup_id,null as citem_id,null as citem_class,null as cname,'' as ccode_equal, null as iflagbank,null as iflagPerson,'0' as bdelete,null as coutaccset,null as ioutyear,null as coutsysname,null as coutsysver,strdate as doutbilldate,null as ioutperiod,'' as coutsign,'

13、;' as coutno_id, pingdate as doutdate,null as coutbillsign,null as coutid,'1' as bvouchedit,'0' as bvouchAddordele,'0'as bvouchmoneyhold,'1' as bvalueedit,'1' as bcodeedit,null as ccodecontrol,'1' as bPCSedit,'1'as bDeptedit, '1' as

14、 bItemedit,'0'as bCusSupInput,null as cDefine1,null as cDefine2,null as cDefine3,pingdate as cDefine4,null as cDefine5,pingdate as cDefine6,null as cDefine7,null as cDefine8,null as cDefine9,null as cDefine10,null as cDefine11, null as cDefine12,null as cDefine13,null as cDefine14,null as cDefine15,null as cDefine16,pingdate as dReceive,null as cWLDZFlag,pingdate as dWLDZTime,'0'as bFlagOut,null as iBG_OverFlag,null as cBG_Auditor,pingdate as dBG_AuditTime, null as cBG_AuditOpinion,