IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_OMCPBILLENTRY' AND KSQL_COL_NAME ='FOUTWAREHOUSEID') 
ALTER TABLE T_IM_MDC_OMCPBILLENTRY ADD (FOUTWAREHOUSEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_OMCPBILLENTRY' AND KSQL_COL_NAME ='FOUTLOCATIONID') 
ALTER TABLE T_IM_MDC_OMCPBILLENTRY ADD (FOUTLOCATIONID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_OMINBILLENTRY' AND KSQL_COL_NAME ='FOUTWAREHOUSEID') 
ALTER TABLE T_IM_MDC_OMINBILLENTRY ADD (FOUTWAREHOUSEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_OMINBILLENTRY' AND KSQL_COL_NAME ='FOUTLOCATIONID') 
ALTER TABLE T_IM_MDC_OMINBILLENTRY ADD (FOUTLOCATIONID BIGINT DEFAULT 0 NOT NULL );