/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\CAS_constraint.sql **/
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RBELK_FSEQ') CREATE INDEX IDX_RBELK_FSEQ ON T_CAS_RECEIVINGBILLENTRY_LK ( FSEQ );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_RBELK_FENTRYID') CREATE INDEX IDX_RBELK_FENTRYID ON T_CAS_RECEIVINGBILLENTRY_LK ( FENTRYID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_RECE_FSOURCEBILLID') CREATE INDEX IDX_CAS_RECE_FSOURCEBILLID ON T_CAS_RECEIVINGBILL ( FSOURCEBILLID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_PB_FCURRENCYID') CREATE INDEX IDX_CAS_PB_FCURRENCYID ON T_CAS_PAYMENTBILL ( FCURRENCYID );


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