-- ABS-85345 / ABS-91111

-------------- ARTRANSACTION --------------
COMMENT ON COLUMN ARTRANSACTION.PAYMENTTYPE
  IS 'DebitCredit = C 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 11 = Scheduled Credit Card Payment 12 = Scheduled ACH  Payment 13 = ACH Payment DebitCredit = D 0 = COD 1 = Charge 9 = Not applicable';
  
-------------- REMITBATCH --------------
COMMENT ON COLUMN REMITBATCH.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 10 = Credit Card Web Portal 11 = Scheduled Credit Card Payment 12 = Scheduled ACH Payment 13 = ACH Payment';
 
ALTER TABLE REMITBATCH
  DROP CONSTRAINT CHK_REMITBATCH_PAYMENTTYPE;
ALTER TABLE REMITBATCH
  ADD CONSTRAINT CHK_REMITBATCH_PAYMENTTYPE
  CHECK (PAYMENTTYPE BETWEEN 0 AND 13);