/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\POM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_SPLITLOG' AND KSQL_COL_NAME ='FORDERSTATUS') 
 ALTER TABLE T_POM_SPLITLOG ADD (FORDERSTATUS NVARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_SPLITLOG' AND KSQL_COL_NAME ='FAUXPTYUNIT') 
 ALTER TABLE T_POM_SPLITLOG ADD (FAUXPTYUNIT BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_SPLITLOG' AND KSQL_COL_NAME ='FBEFAUXPTYQTY') 
 ALTER TABLE T_POM_SPLITLOG ADD (FBEFAUXPTYQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_SPLITLOG' AND KSQL_COL_NAME ='FAFTAUXPTYQTY') 
 ALTER TABLE T_POM_SPLITLOG ADD (FAFTAUXPTYQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_POM_SPLITENTRY' AND KSQL_COL_NAME ='FSPLITAUXPTYQTY') 
 ALTER TABLE T_POM_SPLITENTRY ADD (FSPLITAUXPTYQTY DECIMAL(23,10) DEFAULT 0 NOT NULL );

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