用友U8財(cái)務(wù)數(shù)據(jù)降級(jí)到T3版本SQL腳本
/*手工設(shè)置內(nèi)容：權(quán)限以及打印信息，如果U8是賬套庫(kù)不是年度庫(kù)需要對(duì)導(dǎo)入的年度區(qū)分，如果在導(dǎo)入過(guò)程中期初余額可能對(duì)賬不平的話，直接做T3賬套的年結(jié)就可以，然后在導(dǎo)入憑證,這個(gè)沒(méi)有結(jié)算方式，要手工增加下，要不修改憑證就會(huì)報(bào)錯(cuò)*/
/*舊帳套006導(dǎo)入到新帳套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]
go
--插入憑證類(lèi)別
insert into [UFDATA_001_2013].[dbo].[dsign](csign,isignseq,ctext,itype,iotherused)
select csign,isignseq,ctext,itype,iotherused from [ufdata_006_2013].[dbo].[dsign]
go
--插入憑證類(lèi)別
--插入會(huì)計(jì)科目
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 年度庫(kù)時(shí)使用 */
go
--插入會(huì)計(jì)科目
--客戶(hù)分類(lèi)
INSERT INTO [UFDATA_001_2013].[dbo].[CustomerClass]([cCCCode], [cCCName], [iCCGrade], [bCCEnd])
SELECT [cCCCode], [cCCName], [iCCGrade], [bCCEnd] FROM [ufdata_006_2013].[dbo].[CustomerClass]
go
--客戶(hù)分類(lèi)
--客戶(hù)檔案
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]
go
--供應(yīng)商分類(lèi)
insert into [ufdata_001_2013].[dbo].[vendorclass](
cVCCode,cVCName,iVCGrade,bVCEnd)
select cVCCode,cVCName,iVCGrade,bVCEnd
from [ufdata_006_2013].[dbo].[vendorclass]
go
--供應(yīng)商分類(lèi)
--供應(yīng)商檔案
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]
go
--供應(yīng)商檔案
--部門(mén)檔案
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]
go
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]
go
--部門(mén)檔案
--職員檔案
INSERT INTO [UFDATA_001_2013].[dbo].[Person](
[cPersonCode], [cPersonName], [cDepCode], [cPersonProp])
SELECT
[cPersonCode], [cPersonName], [cDepCode], [cPersonProp]
FROM [ufdata_006_2013].[dbo].[Person]
go
--職員檔案
--項(xiàng)目大類(lèi)
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]
go
--項(xiàng)目大類(lèi)
--項(xiàng)目分類(lèi)
insert into [UFDATA_001_2013].[dbo].[fitemss97class](
cItemCcode,cItemCname,iItemCgrade,bItemCend)
select cItemCcode,cItemCname,iItemCgrade,bItemCend
from [ufdata_006_2013].[dbo].[fitemss97class]
go
--項(xiàng)目分類(lèi)
--項(xiàng)目檔案
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]
go
--項(xiàng)目檔案
--憑證
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 年度庫(kù)時(shí)使用 */
go
--憑證
--憑證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 年度庫(kù)時(shí)使用 */
go
--憑證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 年度庫(kù)時(shí)使用 */
go
--憑證2
---更新結(jié)帳標(biāo)記為記帳
UPDATE [UFDATA_001_2013].dbo.GL_mend SET bflag='True'
go
---更新結(jié)帳標(biāo)記為記帳
--現(xiàn)金流量
delete from [UFDATA_001_2013].[dbo].[GL_CashTable]
go
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
go
--現(xiàn)金流量
