-- ABS-129478 Server side: Route Assistant payment amount verification process

ALTER TABLE ROUTEEXTRAINFO
ADD (PAYMENTCOLLECTIONCONFIRM NUMBER DEFAULT 0 NOT NULL CONSTRAINT CHK_ROUTEEXTRAINFO_PAYMENT CHECK (PAYMENTCOLLECTIONCONFIRM IN (0, 1, 2)));

COMMENT ON COLUMN ROUTEEXTRAINFO.PAYMENTCOLLECTIONCONFIRM IS
'0   = Single Entry (default) 
1   = Confirmation of entry 
2   = Double Entry';
