--Order 20010835.90


ALTER TABLE PAYMENTTERMS
	ADD CONSTRAINT PaymentTermType_valid1  CHECK (PAYMENTTERMTYPE IN (0, 1, 2, 3, 4));


COMMENT ON COLUMN PAYMENTTERMS.NETPAYMENTDAYS IS 'For PaymentTermsType 1 and 2 this is filled with number of days. For PaymentTermsType 3 and 4 this is the number of months.';


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';


ALTER TABLE CUSTOMERBILLINGINFO
	ADD (STATEMENTCUTOFFDATE DATE NULL);


COMMENT ON COLUMN CUSTOMERBILLINGINFO.STATEMENTCUTOFFDATE IS 'Last cut-off date for statement generation';