 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_OMOUTBILLENTRY_M_MEID') CREATE INDEX IDX_OMOUTBILLENTRY_M_MEID ON T_IM_MDC_OMOUTBILLENTRY_M ( FMANUENTRYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_OMCPBILLENTRY_R_MEID') CREATE INDEX IDX_OMCPBILLENTRY_R_MEID ON T_IM_MDC_OMCPBILLENTRY_R ( FMANUENTRYID );