U8普及降级T3主要表

jayge159357

--select * from DBVIP.ufdata_061_2007.dbo.Department --部门
--select * from DBVIP.ufdata_061_2007.dbo.fa_Departments
delete from DBVIP.ufdata_061_2007.dbo.Department
go
insert into DBVIP.ufdata_061_2007.dbo.Department(cdepcode,bdepend,cdepname,idepgrade,cdepperson,cdepprop,cdepphone,cdepaddress,cdepmemo)
select cdepcode,bdepend,cdepname,idepgrade,cdepperson,cdepprop,cdepphone,cdepaddress,cdepmemo from Department
delete from DBVIP.ufdata_061_2007.dbo.fa_Departments
insert into DBVIP.ufdata_061_2007.dbo.fa_Departments
select * from fa_Departments
go
--select * from DBVIP.ufdata_061_2007.dbo.fa_AssetTypes  --资产类别
delete from DBVIP.ufdata_061_2007.dbo.fa_AssetTypes
go
insert into DBVIP.ufdata_061_2007.dbo.fa_AssetTypes
select * from fa_AssetTypes
go
--select * from DBVIP.ufdata_061_2007.dbo.fa_Cards         --卡片主表
delete from DBVIP.ufdata_061_2007.dbo.fa_Cards
go
insert into DBVIP.ufdata_061_2007.dbo.fa_Cards
(sCardID,sCardNum,sAssetNum,sAssetName,lOptID,iOptType,iNewType,sZWVoucherType,sZWVoucherNum,sDeptNum,sTypeNum,sOrgID,sOrgAddID,sOrgDisposeID,sDisposeReason,sStatusID,sDeprMethodID,
sCurrency,sDeprSubjectNum,sDeprSubjectName,sProjectNum,sProjectName,sStyle,dblBuildArea,lBuildNum,lMachinNum,dblMachinW,sSite,lLife,dStartdate,dInputDate,dTransDate,dDisposeDate,
iInputPeriod,iTransPeriod,iDisposePeriod,dblFCValue,dblExchangeRate,sOperator,sDisposer,dblNetValueAct,lDeprMonthsAct,dblCanWorkAct,dblLegacy,sVoucherNum,sEvaluateNum,dblValue,
dblDecDeprT,dblDecDepr,dblDecDeprRate,lDecDeprMonths,dblDecWorkT,dblDecPerDepr,dblBV,dblBVRate,dblCanWork,dblPerDepr,lUsedMonths,sWorkUnit,dblTransInDeprTCard,dblTransOutDeprTCard,
iVouchsNextMonthAct,sTransTypeNum,sTransDepteNum,sLockedBy,dblDecPreValueT,dblRetDecPreValueT)
select
sCardID,sCardNum,sAssetNum,sAssetName,lOptID,iOptType,iNewType,sZWVoucherType,sZWVoucherNum,sDeptNum,sTypeNum,sOrgID,sOrgAddID,sOrgDisposeID,sDisposeReason,sStatusID,sDeprMethodID,
sCurrency,sDeprSubjectNum,sDeprSubjectName,sProjectNum,sProjectName,sStyle,dblBuildArea,lBuildNum,lMachinNum,dblMachinW,sSite,lLife,dStartdate,dInputDate,dTransDate,dDisposeDate,
iInputPeriod,iTransPeriod,iDisposePeriod,dblFCValue,dblExchangeRate,sOperator,sDisposer,dblNetValueAct,lDeprMonthsAct,dblCanWorkAct,dblLegacy,sVoucherNum,sEvaluateNum,dblValue,
dblDecDeprT,dblDecDepr,dblDecDeprRate,lDecDeprMonths,dblDecWorkT,dblDecPerDepr,dblBV,dblBVRate,dblCanWork,dblPerDepr,lUsedMonths,sWorkUnit,dblTransInDeprTCard,dblTransOutDeprTCard,
iVouchsNextMonthAct,sTransTypeNum,sTransDepteNum,sLockedBy,dblDecPreValueT,dblRetDecPreValueT from fa_Cards
go
--select * from DBVIP.ufdata_061_2007.dbo.fa_DeprTransactions--固定资产折旧数据表
delete from DBVIP.ufdata_061_2007.dbo.fa_DeprTransactions
go
insert into DBVIP.ufdata_061_2007.dbo.fa_DeprTransactions
select * from fa_DeprTransactions
go
--select * from DBVIP.ufdata_061_2007.dbo.fa_Total--固定资产汇总表
delete from DBVIP.ufdata_061_2007.dbo.fa_Total
go
insert into DBVIP.ufdata_061_2007.dbo.fa_Total
select * from fa_Total
go
--select * from DBVIP.ufdata_061_2007.dbo.fa_Objects --产生单据号等
delete from DBVIP.ufdata_061_2007.dbo.fa_Objects
insert into DBVIP.ufdata_061_2007.dbo.fa_Objects
select * from fa_Objects
go
delete from DBVIP.ufdata_061_2007.dbo.fa_AssetTypes
insert into DBVIP.ufdata_061_2007.dbo.fa_AssetTypes
select * from fa_AssetTypes
go
delete from DBVIP.ufdata_061_2007.dbo.fa_Origins
insert into DBVIP.ufdata_061_2007.dbo.fa_Origins
select * from fa_Origins
go
delete from DBVIP.ufdata_061_2007.dbo.fa_Status
insert into DBVIP.ufdata_061_2007.dbo.fa_Status
select * from fa_Status
go
delete from DBVIP.ufdata_061_2007.dbo.fa_ItemsManual
insert into DBVIP.ufdata_061_2007.dbo.fa_ItemsManual
select * from fa_ItemsManual
go
--select * from DBVIP.ufdata_061_2007.dbo.fa_Vouchers--变动单
delete from DBVIP.ufdata_061_2007.dbo.fa_Vouchers
insert into DBVIP.ufdata_061_2007.dbo.fa_Vouchers
select * from fa_Vouchers
go
---------------凭证相关-----------------------------------------
--select * from DBVIP.ufdata_061_2007.dbo.fa_DeprVoucherMain
delete from DBVIP.ufdata_061_2007.dbo.fa_DeprVoucherMain
insert into DBVIP.ufdata_061_2007.dbo.fa_DeprVoucherMain
select * from fa_DeprVoucherMain
--select * from DBVIP.ufdata_061_2007.dbo.fa_DeprVouchers
delete from DBVIP.ufdata_061_2007.dbo.fa_DeprVouchers
insert into DBVIP.ufdata_061_2007.dbo.fa_DeprVouchers
(lOptID,iPeriod,sDeptNum,sDeptName,sTypeNum,sTypeName,sProjectNum,sProjectName,sSubjectNum,sSubjectName,dblDebit,dblCredit,sLockedBy)
select lOptID,iPeriod,sDeptNum,sDeptName,sTypeNum,sTypeName,sProjectNum,sProjectName,sSubjectNum,sSubjectName,dblDebit,dblCredit,sLockedBy from fa_DeprVouchers
--select * from code
--select   * from DBVIP.ufdata_061_2007.dbo.code
go
delete from DBVIP.ufdata_061_2007.dbo.code
go
insert into DBVIP.ufdata_061_2007.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 code
--select * from gl_accsum
--select * from DBVIP.ufdata_061_2007.dbo.gl_accsum
delete from DBVIP.ufdata_061_2007.dbo.gl_accsum
go
insert into DBVIP.ufdata_061_2007.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 gl_accsum
go
--select * from gl_accvouch
--select * from DBVIP.ufdata_061_2007.dbo.gl_accvouch
delete from DBVIP.ufdata_061_2007.dbo.gl_accvouch
go
insert into DBVIP.ufdata_061_2007.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 gl_accvouch
go
------end---------凭证相关-----------------------------------------

--select * from DBVIP.ufdata_061_2007.dbo.GL_mend
update DBVIP.ufdata_061_2007.dbo.GL_mend set bflag=1 where iperiod>0 and iperiod<=12--自动结帐   2011帐套不能这么做



--注意：登录系统做完初始化再做
--select * from DBVIP.ufdata_061_2007.dbo.accInformation  where cSysID = 'FA' and cName ='dWritableDate'
update DBVIP.ufdata_061_2007.dbo.accInformation set cvalue=b.cvalue
from DBVIP.ufdata_061_2007.dbo.accInformation a,(select * from accInformation  where cSysID = 'FA' and cName ='dWritableDate') b
where a.cSysID=b.cSysID and a.cSysID = 'FA' and a.cName ='dWritableDate'

/*--相关表---------------------------------------------------------------------------------------------------------------------------
select * from fa_Cards         --卡片主表
select * from fa_cards_Detail  --卡片明细表
select * from fa_Departments  --固定资产部门属性表
select * from fa_AssetTypes  --资产类别

select * from fa_DeprList--固定资产折旧日志
select * from fa_DeprTransactions --固定资产折旧数据表
select * from fa_DeprTransactions_Detail --固定资产折旧数据明细表
select * from fa_DeprVoucherMain--固定资产折旧分配凭证主表
select * from fa_DeprVouchers--固定资产折旧分配凭证子表
select * from fa_DeptScale --固定资产部门比例构成表
select * from fa_Objects--固定资产对象表
fa_Vouchers--变动单
fa_Vouchers_Detail--变动单明细表
select * from fa_Total--固定资产汇总表
select * from fa_WorkLoad

nazi8888

好复杂啊，如果有进销存业务的可能无法转换的，如果只用了总账的话，那还是好转的！

sbaiyunjp

谢谢分享。有工具就好了

zapqo

谢谢楼主分享。

lihuaren007

不错，有人已经把它做成工具了，不过只限制于总账模块！

wonder886kj

偷瞄一眼

wan340280812

偷学回家~~~~~~~

t.ufida

lz，辛苦了！

yxljie

辛苦楼主了

摆渡人

谢谢楼主。。。。

ghostmen

谢谢楼主，应该很有用，我没看懂

sygzst

T3比U8普及版版本还低？？？？？？？？？？？？？？？？

jon_zu

其实只要把基础数据和总账的那几张表复制过来就好了，但是为啥要搞这种呢，不把他升级到U8，反而降级，赚不到钱呀

zhou_boy

工具在那里

ufida-uu

新手报到，，怎么用啊？求解

你太有才了

sygzst 发表于 2013-3-4 12:42

                               
登录/注册后可看大图

T3比U8普及版版本还低？？？？？？？？？？？？？？？？

不是低，是不在一产品线

你太有才了

jon_zu 发表于 2013-3-4 16:53

                               
登录/注册后可看大图

其实只要把基础数据和总账的那几张表复制过来就好了，但是为啥要搞这种呢，不把他升级到U8，反而降级，赚不 ...

一样的赚，把原来的狗收回来，T3也按新报价报

fuxuwen

谁有工具呢？求救，正有这方面需求。  这样看似乎有点复杂了。。。可否把工具共享下，或辛苦发QQ邮箱：54521494   向有的人购买也可以的！