金蝶错误修复方法

演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！金蝶错误修复方法C:\Windows\System32\Netplwiz.exeC:\Windows\System32\netsh.exe金蝶错误解决1、----------------------------------------------------------------------------------------------------------------------------------错误代码:3639(E37H)Source:MicrosoftOLEDBProviderforSQLServerDetail:对象名't_FADeprPolicy'无效。或-----------------------------------------------------------------------------------------------------------------------------------打开科目时，只显示资产和负债两个类别，提示：类型不匹配错误代码:13(DH)Source:SystemDataLib成功的解决方法：IFNOTEXISTS(SELECT*FROMSYSOBJECTSWHEREID=OBJECT_ID(N'[t_FADeprPolicy]')andOBJECTPROPERTY(id,N'IsUserTable')演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！=1)BEGINCREATETABLE[t_FADeprPolicy]([FID][int]IDENTITY(1,1),[FNumber][nvarchar](80)NOTNULL,[FName][nvarchar](80)NOTNULL,[FLevel][int]NOTNULL,[FParentId][int]NOTNULL,[FDetail][smallint]NOTNULL,[FAddDeprPolicy][smallint]NOTNULLDEFAULT(0),[FAlterDeprPolicy][smallint]NOTNULLDEFAULT(0),[FClearDeprPolicy][smallint]NOTNULLDEFAULT(0),[FDefault][smallint]NOTNULLDEFAULT(0))ON[PRIMARY]ENDIFNOTEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_FaCard'andc.Name='FDeprPolicyID')AlterTABLE[t_FaCard]AddFDeprPolicyID[int]NOTNULLDEFAULT(1)IFNOTEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.id演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！ando.name='t_fabalcard'andc.Name='FCurrentEffect')altertablet_fabalcardaddFCurrentEffect[smallint]NOTNULLDEFAULT(0)IFEXISTS(SELECT*FROMSYSOBJECTSWHEREID=OBJECT_ID(N'[vw_fa_card]')andOBJECTPROPERTY(id,N'IsView')=1)BeginDropViewvw_fa_cardEndGOCREATEVIEWvw_fa_cardASselectal.FAlterID,al.FAssetID,al.FYear,al.FPeriod,al.FCleared,al.FNew,al.FAlterNum,al.FOtherAlter,al.FDate,al.FNeedVoucher,al.FExplanation,al.FPreparer,al.FChecker,card.FAssetNumber,card.FAssetName,card.FUnit,card.FModel,card.FManufacturer,card.FProductingArea,card.FVender,card.FBeginUseDate,card.FNum,card.FOrgVal,card.FAMiuValueRead,card.FOrgValBuy,card.FRe演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！sidueVal,card.FAccumDepr,card.FAccumDeprBuy,card.FLifePeriods,card.FPeriodsUsed,card.FJobUnit,card.FModule,card.FBuildVoucher,card.FAdjustOldDepr,card.FEconomyUseID,card.FLocationID,card.FGroupID,card.FAlterModeID,card.FStatusID,card.FDeprMethodID,card.FAssetAcctID,card.FDeprAcctID,policy.FIDasFDeprPolicyID,policy.FNameasFPolicyName,policy.FNumberasFPolicyNumber,eu.FNumberasFEconomyUseNumber,eu.FNameasFEconomyUseName,loc.FNumberasFLocationNumber,loc.FNameasFLocationName,grp.FNumberasFGroupNumber,grp.FNameasFGroupName,am.FNumberasFAlterModeNumber,am.FNameasFAlterModeName,sta.FNumberasFStatusNumber,sta.FNameasFStatusName,dm.FNameasFDeprMethodName,act1.FNumberasFAssetAcctNumber,act1.FNameasFAssetAcctName,act2.FNumberasFDeprAcctNumber,act2.FNameasFDeprAcctName,isnull(vg.FName,'')asFVchGroupName演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！fromt_FAAlteralleftjoint_FACardcardonal.FAlterID=card.FAlterIDleftjoint_FACardItemcional.FAlterID=ci.FAlterIDleftjoint_FAEconomyUseeuoncard.FEconomyUseID=eu.FIDleftjoint_FALocationloconcard.FLocationID=loc.FIDleftjoint_FAGroupgrponcard.FGroupID=grp.FIDleftjoint_FAAlterModeamoncard.FAlterModeID=am.FIDleftjoint_FAStatusstaoncard.FStatusID=sta.FIDleftjoint_FADeprMethoddmoncard.FDeprMethodID=dm.FIDleftjoint_Accountact1oncard.FAssetAcctID=act1.FAccountIDleftjoint_Accountact2oncard.FDeprAcctID=act2.FAccountIDleftjoint_VoucherGroupvgonam.FVchGroupID=vg.FGroupIDleftjoint_FADeprPolicypolicyoncard.FDeprPolicyID=policy.FIDwhereci.FAMulAlterClassID=0GOdeletefromt_DataFlowDetailFuncwhereFDetailFuncID=30106INSERTINTOt_DataFlowDetailFunc(FDetailFuncID,FFuncName,FFuncName_CHT,FFuncName_EN,FSubFuncID,FIndex,FClassName,FClassParam,FIsNormal,FHelpCode,FVisible,FAcctType,FFuncType,FEnable,FShowName,FShowName_CHT,FShowName_EN)演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！VALUES(30106,'折旧政策管理','折旧政策管理','折旧政策管理',301,6,'','',0,'CLFYHZB',1,'',-1,1,'','','')IFEXISTS(SELECT1FROMt_FADeprPolicyWHEREFNumber='01')DELETEFROMt_FADeprPolicyWHEREFNumber='01'INSERTINTOt_FADeprPolicy(FNumber,FName,FLevel,FParentId,FDetail,FAddDeprPolicy,FAlterDeprPolicy,FClearDeprPolicy,FDefault)SELECT'01','常用折旧政策',1,0,1,1,1,1,1IFEXISTS(SELECT1FROMsysobjectso,syscolumnscwhereo.id=c.idando.name='t_FaCard'andc.Name='FDeprPolicyID')UPDATE[t_FaCard]SETFDeprPolicyID=1WHEREFDeprPolicyIDISNullGODeletefromt_LogFunctionWHEREFFunctionID='C00208'InSertINTOt_LogFunction(FFunctionID,FSubSysID,FFunctionName,FFunctionName_CHT,FFunctionName_EN)Values('C00208',3,'固定资产基础资料--折旧政策管理','固定資產基礎資料—折舊政策管理','FixedAssetsMasterData-ChangeDepreciationPolicy')DELETEFROMt_SysFunctionWHEREFFuncID=2121ANDFSubSysID=3演讲稿工作总结调研报告讲话稿事迹材料心得体会策划方案精心收集精心编辑精致阅读如需请下载！INSERTINTOt_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES(2121,'FA118',3,'增加折旧政策方案','增加折舊政策方案','')DELETEFROMt_SysFunctionWHEREFFuncID=2122ANDFSubSysID=3INSERTINTOt_SysFunction(FFuncID,FNumber,FSubSysID,FDescription,FDescription_cht,FDescription_en)VALUES(2122,'FA119',3,'编辑折旧政策方案','編輯折舊政策方案','')DELETEFROMt_S