/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\AR_constraint.sql **/
EXEC p_DropIdx 'IDX_AR_SSL_FID', 'T_AR_SETTLESCHEME_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_SSL_FID') CREATE INDEX IDX_AR_SSL_FID ON T_AR_SETTLESCHEME_L ( FID ,FLOCALEID );

EXEC p_DropIdx 'IDX_AR_GLTT_FNAME', 'T_AR_GOODSLINKTAXTYPE_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_GLTT_FID') CREATE INDEX IDX_AR_GLTT_FID ON T_AR_GOODSLINKTAXTYPE_L ( FLOCALEID ,FID );

EXEC p_DropIdx 'IDX_AR_POLICY_L_NAME', 'T_AR_POLICY_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_POLICY_L_FID') CREATE INDEX IDX_AR_POLICY_L_FID ON T_AR_POLICY_L ( FID ,FLOCALEID );

EXEC p_DropIdx 'IDX_AR_STL_NAME', 'T_AR_SOURCETYPE_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_STL_FID') CREATE INDEX IDX_AR_STL_FID ON T_AR_SOURCETYPE_L ( FID ,FLOCALEID );

EXEC p_DropIdx 'IDX_AR_ASL_FNAME', 'T_AR_ACCRUALSCHEME_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_ASL_FID') CREATE INDEX IDX_AR_ASL_FID ON T_AR_ACCRUALSCHEME_L ( FID ,FLOCALEID );

EXEC p_DropIdx 'IDX_AR_PTL_NAME', 'T_AR_POLICYTYPE_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_PTL_FID') CREATE INDEX IDX_AR_PTL_FID ON T_AR_POLICYTYPE_L ( FID ,FLOCALEID );

EXEC p_DropIdx 'IDX_AR_PPL_FNAME', 'T_AR_PAYPROPERTY_L';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_AR_PPL_FID') CREATE INDEX IDX_AR_PPL_FID ON T_AR_PAYPROPERTY_L ( FLOCALEID ,FID );


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