-- ABS-142182 Invoices will not settle if state is changed 

ALTER TABLE INVOICELINEVARIOUS
ADD (TAXAUTHORITYTYPE NUMBER DEFAULT 0 NOT NULL CONSTRAINT TAXAUTHORITYTYPE_VALID CHECK (TAXAUTHORITYTYPE IN (0, 1, 2, 3)));

COMMENT ON COLUMN INVOICELINEVARIOUS.TAXAUTHORITYTYPE IS 
'0 – NA
1 – State
2 – County
3 - City';
