分享是一种财富!
  •  
  • 首页
  •  

 

2010
12-29
付款条件问题造成入库单参照记录重复问题
分类: | 查看: 1710 | 评论(0)

在 meta库执行
delete aa_columndic_base where ckey in( N'pu_cgrkdtocgfpB',N'pu_cgrkdtocgfpT') and cfld = N'cpaycode@@'
insert into aa_columndic_base(ckey,cfld,cqryfield,icolpos,ccaption,ccaptionpar,bfixed,bdisp,icolwidth,ialign,corder,block,imergecols,bmustsel,bneedsum,pubufts,localeid,isenum,enumtype,enumtypestring,bfilter,bmerge,canmodify,refertype,bhideincolset,csumtype,cprojectno,csubid,cpointbit,cformat)
values(N'pu_cgrkdtocgfpB',N'cpaycode@@',N'copyrdlist.cpaycode',100,N'付款条件编码',null,0,0,1200,1,null,0,null,0,0,null,N'zh-CN',null,null,null,null,null,null,null,null,null,N'U870',N'PU',null,null)
insert into aa_columndic_base(ckey,cfld,cqryfield,icolpos,ccaption,ccaptionpar,bfixed,bdisp,icolwidth,ialign,corder,block,imergecols,bmustsel,bneedsum,pubufts,localeid,isenum,enumtype,enumtypestring,bfilter,bmerge,canmodify,refertype,bhideincolset,csumtype,cprojectno,csubid,cpointbit,cformat)
values(N'pu_cgrkdtocgfpB',N'cpaycode@@',N'copyrdlist.cpaycode',100,N'付款條件編碼',null,0,0,1200,1,null,0,null,0,0,null,N'zh-TW',null,null,null,null,null,null,null,null,null,N'U870',N'PU',null,null)
insert into aa_columndic_base(ckey,cfld,cqryfield,icolpos,ccaption,ccaptionpar,bfixed,bdisp,icolwidth,ialign,corder,block,imergecols,bmustsel,bneedsum,pubufts,localeid,isenum,enumtype,enumtypestring,bfilter,bmerge,canmodify,refertype,bhideincolset,csumtype,cprojectno,csubid,cpointbit,cformat)
values(N'pu_cgrkdtocgfpB',N'cpaycode@@',N'copyrdlist.cpaycode',100,N'Payment term code',null,0,0,1200,1,null,0,null,0,0,null,N'en-US',null,null,null,null,null,null,null,null,null,N'U870',N'PU',null,null)
delete aa_columndic_base where ckey in( N'pu_cgrkdtocgfpB',N'pu_cgrkdtocgfpT') and cfld = N'cpayname@@'
insert into aa_columndic_base(ckey,cfld,cqryfield,icolpos,ccaption,ccaptionpar,bfixed,bdisp,icolwidth,ialign,corder,block,imergecols,bmustsel,bneedsum,pubufts,localeid,isenum,enumtype,enumtypestring,bfilter,bmerge,canmodify,refertype,bhideincolset,csumtype,cprojectno,csubid,cpointbit,cformat)
values(N'pu_cgrkdtocgfpB',N'cpayname@@',N'copyrdlist.cpayname',100,N'付款条件名称',null,0,0,1200,1,null,0,null,0,0,null,N'zh-CN',null,null,null,null,null,null,null,null,null,N'U870',N'PU',null,null)
insert into aa_columndic_base(ckey,cfld,cqryfield,icolpos,ccaption,ccaptionpar,bfixed,bdisp,icolwidth,ialign,corder,block,imergecols,bmustsel,bneedsum,pubufts,localeid,isenum,enumtype,enumtypestring,bfilter,bmerge,canmodify,refertype,bhideincolset,csumtype,cprojectno,csubid,cpointbit,cformat)
values(N'pu_cgrkdtocgfpB',N'cpayname@@',N'copyrdlist.cpayname',100,N'付款條件名稱',null,0,0,1200,1,null,0,null,0,0,null,N'zh-TW',null,null,null,null,null,null,null,null,null,N'U870',N'PU',null,null)
insert into aa_columndic_base(ckey,cfld,cqryfield,icolpos,ccaption,ccaptionpar,bfixed,bdisp,icolwidth,ialign,corder,block,imergecols,bmustsel,bneedsum,pubufts,localeid,isenum,enumtype,enumtypestring,bfilter,bmerge,canmodify,refertype,bhideincolset,csumtype,cprojectno,csubid,cpointbit,cformat)
values(N'pu_cgrkdtocgfpB',N'cpayname@@',N'copyrdlist.cpayname',100,N'Payment type name',null,0,0,1200,1,null,0,null,0,0,null,N'en-US',null,null,null,null,null,null,null,null,null,N'U870',N'PU',null,null)
GO

正在加载评论列表...
正在加载评论页面















































...