--ABS-100777 / ABS-101093
----PAYMENTTRANSACTION--------
ALTER TABLE PAYMENTTRANSACTION DROP CONSTRAINT PAYMENTTYPE_VALID1;

ALTER TABLE PAYMENTTRANSACTION ADD CONSTRAINT CHK_PAYTR_PAYMENTTYPE CHECK (PAYMENTTYPE BETWEEN 0 AND 13);

COMMENT ON COLUMN PAYMENTTRANSACTION.PAYMENTTYPE IS '0 = Cash
1 = Check
2 = Credit card
3 = EFT
4 = EDI
5 = Acceptgiro
6 = Automatic collection
7 = Pay-by customer
8 = Credit Card Portal
9 = Not applicable / unknown
10 = Credit Card Web Portal
11 = Scheduled Credit Card Payment
12 = Scheduled ACH Payment
13 = ACH Payment
';