/**Begin D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BDM_INV_MERGE_RULE' AND KSQL_COL_NAME ='FNUMZEROHANDLETYPE') 
 ALTER TABLE T_BDM_INV_MERGE_RULE ADD (FNUMZEROHANDLETYPE VARCHAR(10) DEFAULT '1' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BDM_INV_MERGE_RULE' AND KSQL_COL_NAME ='FNEGATIVENUMTYPE') 
 ALTER TABLE T_BDM_INV_MERGE_RULE ADD (FNEGATIVENUMTYPE VARCHAR(10) DEFAULT '1' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BDM_INV_MERGE_RULE' AND KSQL_COL_NAME ='FDEVIATIONLEFT') 
 ALTER TABLE T_BDM_INV_MERGE_RULE ADD (FDEVIATIONLEFT DECIMAL(15,2) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BDM_INV_MERGE_RULE' AND KSQL_COL_NAME ='FDEVIATIONRIGHT') 
 ALTER TABLE T_BDM_INV_MERGE_RULE ADD (FDEVIATIONRIGHT DECIMAL(15,2) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BDM_INV_MERGE_RULE' AND KSQL_COL_NAME ='FPRICEOFFSETTYPE')
 ALTER TABLE T_BDM_INV_MERGE_RULE ADD (FPRICEOFFSETTYPE VARCHAR(10) DEFAULT '1' NOT NULL );
/**End D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_table.sql **/
