-- 领料差异分摊增加库存日期字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_BACKDIFSHARE' AND KSQL_COL_NAME ='FINVTIME')
ALTER TABLE T_IM_MDC_BACKDIFSHARE ADD (FINVTIME DATETIME );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_BACKDIFSHARE' AND KSQL_COL_NAME ='FISINVTIME')
ALTER TABLE T_IM_MDC_BACKDIFSHARE ADD (FISINVTIME CHAR(1) DEFAULT '0' NOT NULL );

