/**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_CAS_APBE_FPAYEEID') CREATE INDEX IDX_CAS_APBE_FPAYEEID ON T_CAS_AGENTPAYBILLENTRY ( FPAYEEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_PBE_FSETTLEORGID') CREATE INDEX IDX_CAS_PBE_FSETTLEORGID ON T_CAS_PAYMENTBILLENTRY ( FSETTLEORGID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CAS_BJ_FSOURCEBILLNUMBER') CREATE INDEX IDX_CAS_BJ_FSOURCEBILLNUMBER ON T_CAS_BANKJOURNAL ( FSOURCEBILLNUMBER );


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