1、给标题牵涉到的数据表添加自定义项字段。以下举例:
ALTER TABLE ap_payitem ADD
def31 nvarchar(101),
def32 nvarchar(101),
def33 nvarchar(101),
def34 nvarchar(101),
def35 nvarchar(101),
def36 nvarchar(101),
def37 nvarchar(101),
def38 nvarchar(101),
def39 nvarchar(101),
def40 nvarchar(101),
def41 nvarchar(101),
def42 nvarchar(101),
def43 nvarchar(101),
def44 nvarchar(101),
def45 nvarchar(101),
def46 nvarchar(101),
def47 nvarchar(101),
def48 nvarchar(101),
def49 nvarchar(101),
def50 nvarchar(101)
ALTER TABLE ap_estipayableitem ADD
def31 nvarchar(101),
def32 nvarchar(101),
def33 nvarchar(101),
def34 nvarchar(101),
def35 nvarchar(101),
def36 nvarchar(101),
def37 nvarchar(101),
def38 nvarchar(101),
def39 nvarchar(101),
def40 nvarchar(101),
def41 nvarchar(101),
def42 nvarchar(101),
def43 nvarchar(101),
def44 nvarchar(101),
def45 nvarchar(101),
def46 nvarchar(101),
def47 nvarchar(101),
def48 nvarchar(101),
def49 nvarchar(101),
def50 nvarchar(101)
2、更新标题牵涉到的元数据添加自定义项
3、更新标题牵涉到的VO类添加自定义项
4、更新单据的模板,字段添加,sql如下:
--查找添加自定义项的模板
select pk_billtemplet_b from pub_billtemplet_b b
where b.pk_billtemplet = (select pk_billtemplet from pub_billtemplet where BILL_TEMPLETCAPTION='单据模板名称')
and b.itemkey in ('def31','def32','def33','def34','def35','def36','def37','def38','def39','def40'
,'def41','def42','def43','def44','def45','def46','def47','def48','def49','def50');
--将添加自定义项的模板把其中的自定义项转到之前没有添加自定义项的模板中去
update pub_billtemplet_b set PK_BILLTEMPLET = (select pk_billtemplet from pub_billtemplet where BILL_TEMPLETCAPTION='收款单默认模板' and bill_templetname <> 'SYSTEM')
where pk_billtemplet_b in (
select pk_billtemplet_b from pub_billtemplet_b b
where b.pk_billtemplet = (select pk_billtemplet from pub_billtemplet where BILL_TEMPLETCAPTION='收款单-tsw')
and b.itemkey in ('def31','def32','def33','def34','def35','def36','def37','def38','def39','def40'
,'def41','def42','def43','def44','def45','def46','def47','def48','def49','def50')
)
5、重启NC服务