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].[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].[hr_hi_person]
delete from [ufdata_001_2013].[dbo].[Person]
delete from [ufdata_001_2013].[dbo].[Department]
delete from [ufdata_001_2013].[dbo].[vendor]
delete from [ufdata_001_2013].[dbo].[vendorClass]

 

go

--凭证类别
insert into [ufdata_001_2013].[dbo].[dsign](csign,isignseq,ctext,itype,iotherused)
select csign,isignseq,ctext,itype,iotherused from [ufdata_001_2013T3].[dbo].[dsign]

go

--凭证类别

 

 

 

--插入会计科目     *修改CHELP字段长度改成6（T3)
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_001_2013t3].[dbo].[code]

go
--插入会计科目

 

 

 

 

--客户分类
INSERT INTO [ufdata_001_2013].[dbo].[CustomerClass]([cCCCode], [cCCName], [iCCGrade], [bCCEnd])
SELECT [cCCCode], [cCCName], [iCCGrade], [bCCEnd] FROM [ufdata_001_2013T3].[dbo].[CustomerClass]

go
--客户分类

 

--客户档案
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_001_2013T3].[dbo].[Customer]

go
--客户档案

 

 

--供应商分类
insert into [ufdata_001_2013].[dbo].[vendorclass](
cVCCode,cVCName,iVCGrade,bVCEnd)
select cVCCode,cVCName,iVCGrade,bVCEnd
FROM [ufdata_001_2013t3].[dbo].[vendorclass]

go
--供应商分类

 

--供应商档案
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_001_2013t3].[dbo].[Vendor]

go
--供应商档案

 

 

--部门档案
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_001_2013t3].[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_2013t3].[dbo].[department]

go
--部门档案

 

 

--职员档案
INSERT INTO [ufdata_001_2013].[dbo].[Person](
[cPersonCode], [cPersonName], [cDepCode], [cPersonProp])
SELECT
[cPersonCode], [cPersonName], [cDepCode], [cPersonProp]
FROM [ufdata_001_2013t3].[dbo].[Person]

go

INSERT INTO  [ufdata_001_2013].[dbo].[hr_hi_person] (cPsn_Num,cPsn_Name,cDept_num,rSex,bPsnPerson,rIDType,bpsnshop,rpersontype)
select cPersonCode,cPersonName,cDepCode,'9',1,0,1,'10'
from [ufdata_001_2013t3].[dbo].[person]

go
--职员档案

 

--修复进入总账提示科目类型与行业性质不符
update [ufdata_001_2013].[dbo].[accinformation] set cvalue=1   where cname='bNewCodeFlag'

--凭证
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_001_2013T3].[dbo].[GL_accvouch]

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_001_2013T3].[dbo].[GL_accsum]

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_001_2013t3].[dbo].[GL_accass]

go
--凭证2

 

 

--现金流量

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], [ccode], [md_f], [mc_f], [nd_s], [nc_s],[dbill_date], [csign])
select a.iperiod,a.isignseq,a.ino_id,a.inid,b.cCashItem,b.md,b.mc,a.ccode,0,0,0,0,a.dbill_date,a.csign
from  [ufdata_001_2013T3].[dbo].[GL_accvouch] a,[ufdata_001_2013T3].[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

--现金流量

 

 

 

 

--修改记账人，软件结账完毕用
 
update [ufdata_001_2013].[dbo].[GL_accvouch]  
set cbook=
(select top 1 cbook from [ufdata_001_2013T3].[dbo].[GL_accvouch] 
  where [ufdata_001_2013T3].[dbo].[GL_accvouch].iperiod=[ufdata_001_2013].[dbo].[GL_accvouch].iperiod
    and [ufdata_001_2013T3].[dbo].[GL_accvouch].isignseq=[ufdata_001_2013].[dbo].[GL_accvouch].isignseq
    and [ufdata_001_2013T3].[dbo].[GL_accvouch].ino_id=[ufdata_001_2013].[dbo].[GL_accvouch].ino_id
    and ([ufdata_001_2013T3].[dbo].[GL_accvouch].inid=[ufdata_001_2013].[dbo].[GL_accvouch].inid))
go

--修改记账人，软件结账完毕用