---ABS-141489

---INVOICEHEADER TABLE

ALTER TABLE INVOICEHEADER DROP CONSTRAINT CHK_INVOICEHEADER_INVOICETYPE;

ALTER TABLE INVOICEHEADER ADD CONSTRAINT CHK_INVOICEHEADER_INVOICETYPE CHECK (INVOICETYPE IN (1, 2, 4, 5, 6, 7, 8, 9, 10)); 

COMMENT ON COLUMN INVOICEHEADER.INVOICETYPE 
IS '1 = Generated
2 = Manual
4 = Additional Generated
5 = Lost Customer
6 = Corrections Invoice
7 = Excess Amounts / insurance company invoice
8 = Down Payment Invoice
9 = Sample Invoice
10 = Untaxed manual invoice imported via ERP – only used for module UNTAXEDINVOICEIMPORT';


