-- ABS-85223 / ABS-100735
ALTER TABLE VERTEXTRANSACTIONLOG DROP CONSTRAINT CHK_VERTEXLOG_BATCHTYPE;

COMMENT ON COLUMN VERTEXTRANSACTIONLOG.BATCHTYPE IS '0 = BCI (default)
1 = WebService
2 = BCI (Immediate Credit tax distribution)';

ALTER TABLE VERTEXTRANSACTIONLOG ADD CONSTRAINT CHK_VERTEXLOG_BATCHTYPE CHECK (BATCHTYPE IN (0,1,2));