 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BFTRANSFER' AND KSQL_COL_NAME ='FBITINDEX') 
 ALTER TABLE T_MRP_BFTRANSFER ADD (FBITINDEX INT DEFAULT 0 NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BFTRANSFER' AND KSQL_COL_NAME ='FSOURCEBITINDEX') 
 ALTER TABLE T_MRP_BFTRANSFER ADD (FSOURCEBITINDEX INT DEFAULT 0 NOT NULL);
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_MRP_BFTRANSFER' AND KSQL_COL_NAME ='FSOURCEDATAID') 
 ALTER TABLE T_MRP_BFTRANSFER ADD (FSOURCEDATAID BIGINT DEFAULT 0 NOT NULL);
