【問題現(xiàn)象】：

科目余額表查詢方案顯示不正常。

【問題分析】：

查看科目檔案和基礎(chǔ)檔案設(shè)置沒有問題。

【解決方案】：

賬套預(yù)置數(shù)據(jù)有問題了，執(zhí)行附件的腳本來修復(fù)，個(gè)人方案中的系統(tǒng)方案，要?jiǎng)h除重建

DELETE FROM EAP_SearchPlanItem_Ext WHERE PlanId =919 AND SearchItemId IN(20978,20979,20980,20981);

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 8,'','','','',0,0,0, null, null,GETDATE(),20978,919, null, null, NULL

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 7,'','','','',0,0,0, null, null,GETDATE(),20979,919, null, null, NULL

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 6,'','','','',0,0,0, null, null,GETDATE(),20980,919, null, null, NULL

INSERT INTO eap_searchplanitem_ext([OrderNum],[BeginValue],[EndValue],[BeginText],[EndText],[IsControlPermission],[IsControlFieldPermission],[Selected],[CompareSign],[ExpressionName],[CreatedTime],[SearchItemId],[planid],[ItemType],[MatchMode],[IsSimpleSearchItem])

SELECT 10,'','','','',0,0,0, null, null,GETDATE(),20981,919, null, null, null