-- 领料差异分摊生产事务类型
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_MFTBACKDIFSHARE' AND KSQL_COL_NAME ='ftransactiontypeid') 
 ALTER TABLE T_IM_MDC_MFTBACKDIFSHARE ADD (ftransactiontypeid BIGINT DEFAULT 0 NOT NULL);
 
 
 
 -- 领料差异分摊明细生产事务类型
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_SHDIFSHAREDETAIL' AND KSQL_COL_NAME ='ftransactiontypeid') 
 ALTER TABLE T_IM_MDC_SHDIFSHAREDETAIL ADD (ftransactiontypeid BIGINT DEFAULT 0 NOT NULL);