/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\IM_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_IM_OTHERINBILLENTRY_R' AND KSQL_INDNAME = 'IDX_IM_OTHERINENTRY_R_SRCEID') CREATE INDEX IDX_IM_OTHERINENTRY_R_SRCEID ON T_IM_OTHERINBILLENTRY_R ( FSRCBILLENTRYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_IM_OTHERINBILLENTRY_R' AND KSQL_INDNAME = 'IDX_IM_OTHERINENTRY_R_SRCID') CREATE INDEX IDX_IM_OTHERINENTRY_R_SRCID ON T_IM_OTHERINBILLENTRY_R ( FSRCBILLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_IM_OTHEROUTBILLENTRY_R' AND KSQL_INDNAME = 'IDX_IM_OTHEROUTENTRY_R_SRCEID') CREATE INDEX IDX_IM_OTHEROUTENTRY_R_SRCEID ON T_IM_OTHEROUTBILLENTRY_R ( FSRCBILLENTRYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_IM_OTHEROUTBILLENTRY_R' AND KSQL_INDNAME = 'IDX_IM_OTHEROUTENTRY_R_SRCID') CREATE INDEX IDX_IM_OTHEROUTENTRY_R_SRCID ON T_IM_OTHEROUTBILLENTRY_R ( FSRCBILLID );


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