-- ABS-93483 New payment term option - Running Quarter + x daysABS-99249

---------- PAYMENTTERMS--------

ALTER TABLE PAYMENTTERMS DROP CONSTRAINT PAYMENTTERMTYPE_VALID1;
ALTER TABLE PAYMENTTERMS ADD CONSTRAINT PAYMENTTERMTYPE_VALID1 CHECK (PAYMENTTERMTYPE IN (0, 1, 2, 3, 4, 5, 6));

COMMENT ON COLUMN PAYMENTTERMS.PAYMENTTERMTYPE
IS '0 = Net Cash
1 = Net Payment + Days
2 = Running month + Days
3 = Net Payment + Months
4 = Running month + Months
5 = Net Payment + days +running month (end of the month after the invoice date plus x days)
6 = Running quarter + Days
';