/******************************************************************************
NAME: 单据界面字段显示、序时簿字段过滤显示调整
CREATED BY:    Suntime
DESCRIPTION:
  1、因金蝶K3、KISPRO是通用化商品软件，单据上、序时簿中很多字段设置是基于各个产品功能设置的；但在不同的企业，需求的功能点可能不同，不需要的功能点字段在单据上、序时簿中，对应用企业来说，就是多余。
  2、应要相应企业需求，隐藏单据上和序时簿中不必要的字段。
  3、适用于 K3 及 KisPro，但在应用时要，要根据企业具体情况，分析执行。
******************************************************************************/

 

/*===============单据界面显示调整===============*/
--屏蔽物料短代码的查询
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%物料短代码%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%产品短代码%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%加工材料短代码%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%产品短代码%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%费用短代码%'

--其他
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%辅助属性%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%仓位%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%税%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%折扣%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%合同%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%供货机构%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%订货机构%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%制单机构%'
UPDATE ICTemplateEntry SET FVisForBillType=0 WHERE FHeadCaption like '%分支机构%'
--屏蔽物料短代码的查询
UPDATE ICTemplate SET FVisForBillType=1 WHERE FCaption like '%物料短代码%'
UPDATE ICTemplate SET FVisForBillType=1 WHERE FCaption like '%产品短代码%'
UPDATE ICTemplate SET FVisForBillType=1 WHERE FCaption like '%加工材料短代码%'
UPDATE ICTemplate SET FVisForBillType=1 WHERE FCaption like '%产品短代码%'
UPDATE ICTemplate SET FVisForBillType=1 WHERE FCaption like '%费用短代码%'

--其他
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%辅助属性%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%仓位%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%税%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%折扣%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%合同%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%供货机构%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%订货机构%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%制单机构%'
UPDATE ICTemplate SET FVisForBillType=0 WHERE FCaption like '%分支机构%'

/*===============单据列表显示调整===============*/

--设置序时簿字段查询列宽
UPDATE ICChatBillTitle SET FColWidth=500  where FColCaption like '%标志%'
UPDATE ICChatBillTitle SET FColWidth=500  where FColCaption like '%单位'
UPDATE ICChatBillTitle SET FColWidth=2000  where FColCaption like '%长代码%'
UPDATE ICChatBillTitle SET FColWidth=2000  where FColCaption like '%名称%'
UPDATE ICChatBillTitle SET FColWidth=1500  where FColCaption like '%数量%'
UPDATE ICChatBillTitle SET FColWidth=1500  where FColCaption like '%金额%'
UPDATE ICChatBillTitle SET FColWidth=1100  where FColCaption like '%日期%'
UPDATE ICChatBillTitle SET FColWidth=1200  where FColCaption like '%单号%'

--屏蔽物料短代码的查询
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%物料代码%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%产品短代码%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%加工材料代码%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%产品代码%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%费用代码%'

--其他
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%辅助属性%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%仓位%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%税%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%折扣%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%合同%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%结算方式%'

UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%供货机构%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%订货机构%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%制单机构%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%分支机构%'

UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%主管%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%负责人%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%部门%'
UPDATE ICChatBillTitle SET Fvisible=0,FvisForQuest=0  where FColCaption like '%POS%'