

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_ASSET_INVOICE_ITEM')
CREATE UNIQUE INDEX IDX_ER_ASSET_INVOICE_ITEM ON T_ER_ASSET_INVOICEITEM_RE ( FASSETDETAILID ,FINVOICEITEMENTRYID );
