标准版本更新记录1 (2).docx

文档介绍：标准版本更新记录目录首营审批增加营业执照年检日期............................................................................................ 1 KSOA 错误修复........................................................................................................................... 2 KSOA 日清错误修复................................................................................................................... 3 KSOA 日清错误修复................................................................................................................... 4 KSOA 商品滞销查询更新........................................................................................................... 6 KSOA 调价计划(总部) ........................................................................................................... 6 首营审批增加营业执照年检日期更新日期: 2013-09-24 更新人:张建申请日期: 2013-09-18 申请人:唐建平客户:泰州华为、无锡锡新申请原因:首营审批增加营业执照年检日期适用版本: CCERP 、 KSOA 确认日期: 确认人: 1. 增加字段 if not exists(select b.*,a.* from sysobjects a,syscolumns b where ='mchk' and = and ='ngsp_yyzznjrq') alter table mchk add ngsp_yyzznjrq char(10) null default ''; delete from tbstru where tbname='mchk' and fdname='ngsp_yyzznjrq'; insert into tbstru (tbname,xlh,fdname) values ('mchk',141,'ngsp_yyzznjrq'); if not exists(select * from fldlist where fdname='ngsp_yyzznjrq') insert into fldlist (fdname,chnname,fdtype,fdsize,fddec) values ('ngsp_yyzznjrq',' 营业执照年检日期',' 字符',10,0); if not exists