-- 盘点记录和盘点方案新增状态字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_INVENTSCHEME' AND KSQL_COL_NAME ='FBILLSTATE')
 ALTER TABLE T_FA_INVENTSCHEME ADD (FBILLSTATE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_INVENTORY_RECORD' AND KSQL_COL_NAME ='FBILLSTATE')
 ALTER TABLE T_FA_INVENTORY_RECORD ADD (FBILLSTATE CHAR(1) DEFAULT '0' NOT NULL );