/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BASE_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_CUSTOMERGROUPDETAIL' AND KSQL_COL_NAME ='FCREATEORGID') 
 ALTER TABLE T_BD_CUSTOMERGROUPDETAIL ADD (FCREATEORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_SUPPLIERGROUPDETAIL' AND KSQL_COL_NAME ='FCREATEORGID') 
 ALTER TABLE T_BD_SUPPLIERGROUPDETAIL ADD (FCREATEORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_MATERIALGROUPDETAIL' AND KSQL_COL_NAME ='FCREATEORGID') 
 ALTER TABLE T_BD_MATERIALGROUPDETAIL ADD (FCREATEORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_CUSTOMERGROUP' AND KSQL_COL_NAME ='FCREATEORGID') 
 ALTER TABLE T_BD_CUSTOMERGROUP ADD (FCREATEORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_SUPPLIERGROUP' AND KSQL_COL_NAME ='FCREATEORGID') 
 ALTER TABLE T_BD_SUPPLIERGROUP ADD (FCREATEORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_BD_MATERIALGROUP' AND KSQL_COL_NAME ='FCREATEORGID') 
 ALTER TABLE T_BD_MATERIALGROUP ADD (FCREATEORGID BIGINT DEFAULT 0 NOT NULL );

/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\BASE_table.sql **/
