-- 平衡利库修改 单据体 需求单据类型字段类型，从bigint 改为 nvarchar
-- 先删除字段，再加上字段
EXEC p_AlterColumn 'T_IM_INVADVICEENTRY', 'FAPPLYBILLTYPE', 'NULL', 'NULL', '1001', 'NULL';
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_INVADVICEENTRY' AND KSQL_COL_NAME IN ('FAPPLYBILLTYPE'))
ALTER TABLE T_IM_INVADVICEENTRY ADD (FAPPLYBILLTYPE NVARCHAR(80) DEFAULT ' ' NOT NULL);


