
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MSTOCKE_CHILDBOMID') CREATE INDEX IDX_POM_MSTOCKE_CHILDBOMID ON T_POM_MANUSTOCKENTRY ( FCHILDBOMID );
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_POM_MSTOCKE_BOMENTRYID') CREATE INDEX IDX_POM_MSTOCKE_BOMENTRYID ON T_POM_MANUSTOCKENTRY_A ( FBOMENTRYID );
 
 --委外om放到对应的应用中
 --IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_OM_MSTOCKE_CHILDBOMID') CREATE INDEX IDX_OM_MSTOCKE_CHILDBOMID ON T_OM_MFTSTOCKENTRY ( FCHILDBOMID );
   
	--IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_OM_MSTOCKE_BOMENTRYID') CREATE INDEX IDX_OM_MSTOCKE_BOMENTRYID ON T_OM_MFTSTOCKENTRY ( FBOMENTRYID );
	 
