/******************************************************************************
NAME: 单据界面显示字段调整
CREATED BY:    Suntime 
 DESCRIPTION:
  1、去掉单界面显示字段的空格，若为必录字段加缀“(*)”显示
  2、调整后，不影响查询及套打
  3、适用于 K3 及 KisPro
 ******************************************************************************/

--单据字段去空格
UPdate ICTemplate set FCaption=replace(FCaption,'  ',''),FCaption_Cht=replace(FCaption_CHT,'  ','')
UPdate ICTemplateEntry set FHeadCaption=replace(FHeadCaption,'  ',''),FHeadCaption_Cht=replace(FHeadCaption_CHT,'  ','')
--单据必录字段加缀(*)显示
UPdate ICTemplate set FCaption=replace(FCaption,'(*)',''),FCaption_Cht=replace(FCaption_CHT,'(*)',''),FCaption_EN=replace(FCaption_EN,'(*)','')
UPdate ICTemplate set FCaption=FCaption+'(*)',FCaption_CHT=FCaption_CHT+'(*)',FCaption_EN=FCaption_EN+'(*)' where FSysMustInputItem=1 OR FMustInput=1
UPdate ICTemplateEntry set FHeadCaption=replace(FHeadCaption,'(*)',''),FHeadCaption_Cht=replace(FHeadCaption_CHT,'(*)',''),FHeadCaption_EN=replace(FHeadCaption_EN,'(*)','')
UPdate ICTemplateEntry set FHeadCaption=FHeadCaption+'(*)',FHeadCaption_Cht=FHeadCaption_Cht+'(*)',FHeadCaption_EN=FHeadCaption_EN+'(*)' where FSysMustInputItem=1 or FMustInput=1