用友U8财务数据降级到T3版本SQL脚本

分享到:

2021-05-26 10:42:03

U8 style=text-decoration:underline;font-size:14px;color:#F70968; target=_blank>用友U8财务数据降级到T3版本SQL脚本

/*手工设置内容：权限以及打印信息，如果U8是账套库不是年度库需要对导入的年度区分，如果在导入过程中期初余额可能对账不平的话，直接做T3账套的年结就可以，然后在导入凭证,这个没有结算方式，要手工增加下，要不修改凭证就会报错*/

/*旧帐套006导入到新帐套001中*/

delete from [UFDATA_001_2013].[dbo].[dsign]

delete from [UFDATA_001_2013].[dbo].[code]

delete from [UFDATA_001_2013].[dbo].[Customer]

delete from [UFDATA_001_2013].[dbo].[CustomerClass]

delete from [UFDATA_001_2013].[dbo].[Department]

delete from [UFDATA_001_2013].[dbo].[Person]

delete from [UFDATA_001_2013].[dbo].[fitem]

delete from [UFDATA_001_2013].[dbo].[fitemss97class]

delete from [UFDATA_001_2013].[dbo].[fitemss97]

delete from [UFDATA_001_2013].[dbo].[GL_accvouch]

delete from [UFDATA_001_2013].[dbo].[GL_accsum]

delete from [UFDATA_001_2013].[dbo].[GL_accass]

delete from [UFDATA_001_2013].[dbo].[vendorClass]

delete from [UFDATA_001_2013].[dbo].[vendor]

delete from [UFDATA_001_2013].[dbo].[hr_hi_person]

--插入凭证类别

insert into [UFDATA_001_2013].[dbo].[dsign](csign,isignseq,ctext,itype,iotherused)

select csign,isignseq,ctext,itype,iotherused from [ufdata_006_2013].[dbo].[dsign]

--插入凭证类别

--插入会计科目

INSERT INTO [UFDATA_001_2013].[dbo].[code]([cclass], [cclass_engl], [cclassany], [cclassany_engl], [ccode], [ccode_name],

[ccode_engl], [igrade], [bproperty], [cbook_type], [cbook_type_engl], [chelp], [cexch_name], [cmeasure], [bperson], [bcus], [bsup],

[bdept], [bitem], [cass_item], [br], [be], [cgather], [bend], [bexchange], [bcash], [bbank], [bused], [bd_c], [dbegin], [dend],

[itrans], [bclose], [cother], [iotherused], [bcDefine1], [bcDefine2], [bcDefine3], [bcDefine4], [bcDefine5], [bcDefine6],

[bcDefine7], [bcDefine8], [bcDefine9], [bcDefine10], [iViewItem], [bGCJS], [bCashItem])

SELECT [cclass], [cclass_engl], [cclassany], [cclassany_engl], [ccode], [ccode_name], [ccode_engl], [igrade], [bproperty],

[cbook_type], [cbook_type_engl], [chelp], [cexch_name], [cmeasure], [bperson], [bcus], [bsup], [bdept], [bitem], [cass_item], [br],

[be], [cgather], [bend], [bexchange], [bcash], [bbank], [bused], [bd_c], [dbegin], [dend], [itrans], [bclose], [cother],

[iotherused], [bcDefine1], [bcDefine2], [bcDefine3], [bcDefine4], [bcDefine5], [bcDefine6], [bcDefine7], [bcDefine8], [bcDefine9],

[bcDefine10], [iViewItem], [bGCJS], [bCashItem]

FROM [ufdata_006_2013].[dbo].[code]

/*where iyear=2015 年度库时使用 */

--插入会计科目

--客户分类

INSERT INTO [UFDATA_001_2013].[dbo].[CustomerClass]([cCCCode], [cCCName], [iCCGrade], [bCCEnd])

SELECT [cCCCode], [cCCName], [iCCGrade], [bCCEnd] FROM [ufdata_006_2013].[dbo].[CustomerClass]

--客户分类

--客户档案

INSERT INTO [UFDATA_001_2013].[dbo].[Customer]

([cCusCode],[cCusName],[cCusAbbName],[cCCCode],[cDCCode],[cTrade],[cCusAddress],[cCusPostCode],[cCusRegCode],

[cCusBank],[cCusAccount],[dCusDevDate],[cCusLPerson],[cCusEmail],[cCusPerson],[cCusPhone],[cCusFax],[cCusBP],

[cCusHand],[cCusPPerson],[iCusDisRate],[cCusCreGrade],[iCusCreLine],[iCusCreDate],[cCusPayCond],[cCusOAddress],

[cCusOType],[cCusHeadCode],[cCusWhCode],[cCusDepart],[iARMoney],[dLastDate],[iLastMoney],[dLRDate],[iLRMoney],

[dEndDate],[iFrequency],[cCusDefine1],[cCusDefine2],[cCusDefine3],[iCostGrade])

SELECT

[cCusCode],[cCusName],[cCusAbbName],[cCCCode],[cDCCode],[cTrade],[cCusAddress],[cCusPostCode],[cCusRegCode],

[cCusBank],[cCusAccount],[dCusDevDate],[cCusLPerson],[cCusEmail],[cCusPerson],[cCusPhone],[cCusFax],[cCusBP],

[cCusHand],[cCusPPerson],[iCusDisRate],[cCusCreGrade],[iCusCreLine],[iCusCreDate],[cCusPayCond],[cCusOAddress],

[cCusOType],[cCusHeadCode],[cCusWhCode],[cCusDepart],[iARMoney],[dLastDate],[iLastMoney],[dLRDate],[iLRMoney],

[dEndDate],[iFrequency],[cCusDefine1],[cCusDefine2],[cCusDefine3],[iCostGrade]

FROM [ufdata_006_2013].[dbo].[Customer]

--客户档案

--供应商分类

insert into [ufdata_001_2013].[dbo].[vendorclass](

cVCCode,cVCName,iVCGrade,bVCEnd)

select cVCCode,cVCName,iVCGrade,bVCEnd

from [ufdata_006_2013].[dbo].[vendorclass]

--供应商分类

--供应商档案

INSERT INTO [UFDATA_001_2013].[dbo].[Vendor](

[cVenCode],[cVenName],[cVenAbbName],[cVCCode],[cDCCode],[cTrade],[cVenAddress],[cVenPostCode],[cVenRegCode],[cVenBank],

[cVenAccount],[dVenDevDate],[cVenLPerson],[cVenPhone],[cVenFax],[cVenEmail],[cVenPerson],[cVenBP],[cVenHand],[cVenPPerson],

[iVenDisRate],[iVenCreGrade],[iVenCreLine],[iVenCreDate],[cVenPayCond],[cVenIAddress],[cVenIType],[cVenHeadCode],[cVenWhCode],

[cVenDepart],[iAPMoney],[dLastDate],[iLastMoney],[dLRDate],[iLRMoney],[dEndDate],[iFrequency],[bVenTax],[cVenDefine1],

[cVenDefine2],[cVenDefine3])

SELECT

[cVenCode],[cVenName],[cVenAbbName],[cVCCode],[cDCCode],[cTrade],[cVenAddress],[cVenPostCode],[cVenRegCode],[cVenBank],

[cVenAccount],[dVenDevDate],[cVenLPerson],[cVenPhone],[cVenFax],[cVenEmail],[cVenPerson],[cVenBP],[cVenHand],[cVenPPerson],

[iVenDisRate],[iVenCreGrade],[iVenCreLine],[iVenCreDate],[cVenPayCond],[cVenIAddress],[cVenIType],[cVenHeadCode],[cVenWhCode],

[cVenDepart],[iAPMoney],[dLastDate],[iLastMoney],[dLRDate],[iLRMoney],[dEndDate],[iFrequency],[bVenTax],[cVenDefine1],

[cVenDefine2],[cVenDefine3]

FROM [ufdata_006_2013].[dbo].[Vendor]

--供应商档案

--部门档案

INSERT INTO [UFDATA_001_2013].[dbo].[Department]

([cDepCode], [bDepEnd], [cDepName], [iDepGrade], [cDepPerson], [cDepProp], [cDepPhone], [cDepAddress],

[cDepMemo])

SELECT

[cDepCode], [bDepEnd], [cDepName], [iDepGrade], [cDepPerson], [cDepProp], [cDepPhone], [cDepAddress],

[cDepMemo]

FROM [ufdata_006_2013].[dbo].[Department]

INSERT INTO [UFDATA_001_2013].[dbo].[fa_Departments]

(sNum,sName,sParentNum,sNum1,bSumDepr,iLevel,iDefinetype)

select cdepcode,cdepname,'',cdepcode,1,1,1

from [UFDATA_001_2013].[dbo].[department]

--部门档案

--职员档案

INSERT INTO [UFDATA_001_2013].[dbo].[Person](

[cPersonCode], [cPersonName], [cDepCode], [cPersonProp])

SELECT

[cPersonCode], [cPersonName], [cDepCode], [cPersonProp]

FROM [ufdata_006_2013].[dbo].[Person]

--职员档案

--项目大类

insert into [UFDATA_001_2013].[dbo].[fitem](citem_class,citem_name,citem_text,crule,ctable,cclasstable)

select citem_class,citem_name,citem_text,crule,ctable,cclasstable

from [ufdata_006_2013].[dbo].[fitem]

--项目大类

--项目分类

insert into [UFDATA_001_2013].[dbo].[fitemss97class](

cItemCcode,cItemCname,iItemCgrade,bItemCend)

select cItemCcode,cItemCname,iItemCgrade,bItemCend

from [ufdata_006_2013].[dbo].[fitemss97class]

--项目分类

--项目档案

insert into [UFDATA_001_2013].[dbo].[fitemss97](

citemcode,citemname,bclose,citemccode,iotherused,dEndDate)

select citemcode,citemname,bclose,citemccode,iotherused,dEndDate

from [ufdata_006_2013].[dbo].[fitemss97]

--项目档案

--凭证

INSERT INTO [UFDATA_001_2013].[dbo].[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_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], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8],

[cDefine9], [cDefine10])

SELECT

[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_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], [cDefine1], [cDefine2], [cDefine3], [cDefine4], [cDefine5], [cDefine6], [cDefine7], [cDefine8],

[cDefine9], [cDefine10]

FROM [ufdata_006_2013].[dbo].[GL_accvouch]

/*where iyear=2015 年度库时使用 */

--凭证

--凭证1

INSERT INTO [UFDATA_001_2013].[dbo].[GL_accsum](

[ccode], [cexch_name], [iperiod], [cbegind_c], [cbegind_c_engl], [mb], [md], [mc], [cendd_c], [cendd_c_engl], [me], [mb_f],

[md_f], [mc_f], [me_f], [nb_s], [nd_s], [nc_s], [ne_s])

SELECT

[ccode], [cexch_name], [iperiod], [cbegind_c], [cbegind_c_engl], [mb], [md], [mc], [cendd_c], [cendd_c_engl], [me], [mb_f],

[md_f], [mc_f], [me_f], [nb_s], [nd_s], [nc_s], [ne_s]

FROM [ufdata_006_2013].[dbo].[GL_accsum]

/*where iyear=2015 年度库时使用 */

--凭证1

--凭证2

INSERT INTO [UFDATA_001_2013].[dbo].[GL_accass](

[ccode], [cexch_name], [cdept_id], [cperson_id], [ccus_id], [csup_id], [citem_class], [citem_id], [iperiod], [cbegind_c],

[cbegind_c_engl], [mb], [md], [mc], [cendd_c], [cendd_c_engl], [me], [mb_f], [md_f], [mc_f], [me_f], [nb_s], [nd_s], [nc_s], [ne_s])

SELECT

[ccode], [cexch_name], [cdept_id], [cperson_id], [ccus_id], [csup_id], [citem_class], [citem_id], [iperiod], [cbegind_c],

[cbegind_c_engl], [mb], [md], [mc], [cendd_c], [cendd_c_engl], [me], [mb_f], [md_f], [mc_f], [me_f], [nb_s], [nd_s], [nc_s], [ne_s]

FROM [ufdata_006_2013].[dbo].[GL_accass]

/*where iyear=2015 年度库时使用 */

--凭证2

---更新结帐标记为记帐

UPDATE [UFDATA_001_2013].dbo.GL_mend SET bflag='True'

---更新结帐标记为记帐

--现金流量

delete from [UFDATA_001_2013].[dbo].[GL_CashTable]

INSERT INTO [UFDATA_001_2013].[dbo].[GL_CashTable](

[iPeriod], [iSignSeq], [iNo_id], [inid], [cCashItem], [md], [mc])

select a.iperiod,a.isignseq,a.ino_id,a.inid,b.cCashItem,b.md,b.mc

from [ufdata_006_2013].[dbo].[GL_accvouch] a,[ufdata_006_2013].[dbo].[GL_CashTable] b

where a.iperiod=b.iperiod and a.isignseq=b.isignseq and a.iNo_id=b.iNo_id and a.inid=b.inid

--现金流量

声明：此篇为用友服务中心文章，转载请标明出处链接：

上一篇：用友U8 10.1软件如何填制凭证下一篇:虚拟机软加密申请

相关文章
热门下载
数据修复
热门标签

用友好会计财务软件费用多少(用 2021年结抢先做：用友T6软件202 用友T+2020年最新报价用友T3的价格是多少用友T+cloud报价用友U8+V15.0产品报价用友u8软件多少钱用友T3标准版多少钱一套-T3标准用友t3普及版V11.2最新的价格是用友U8+V13.0标准套件产品用友T3财务通普及版11.0财务软用友t+最新报价-T+标准版 V12.1 用友软件t6 6.3最新版本报价用友ERP-U8+ V13.0全产品报价单用友T3标准版V11.0、普及版报价北京用友远程维护收费标准

用友U8财务数据降级到T3版本SQL脚本

最新图文推荐

相关栏目

最新文章

推荐产品

热门模板推荐

相关文章推荐