/**Begin D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_CHECKRPTLOT' AND KSQL_COL_NAME ='FDIFFSETTING') 
 ALTER TABLE T_BCM_CHECKRPTLOT ADD (FDIFFSETTING VARCHAR(200) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_CHECKRECORDENTRY' AND KSQL_COL_NAME ='FENTRYDIFFMETHOD') 
 ALTER TABLE T_BCM_CHECKRECORDENTRY ADD (FENTRYDIFFMETHOD VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_CHECKRECORD' AND KSQL_COL_NAME ='FDIFFMETHOD') 
 ALTER TABLE T_BCM_CHECKRECORD ADD (FDIFFMETHOD VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BCM_CHECKTMPL' AND KSQL_COL_NAME ='FDIFFMETHOD') 
 ALTER TABLE T_BCM_CHECKTMPL ADD (FDIFFMETHOD VARCHAR(2) DEFAULT ' ' NOT NULL );



/**End D:\DBA\1.4\PDM_UPGRADE\PDM1\BCM_table.sql **/
