/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\SM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SM_SOE_MATID') CREATE INDEX IDX_SM_SOE_MATID ON T_SM_SALORDERENTRY ( FMATERIALID ,FID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SM_SOE_MATMASTERID') CREATE INDEX IDX_SM_SOE_MATMASTERID ON T_SM_SALORDERENTRY ( FMATERIALMASTERID ,FID );


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