-- ABS-46604/ ABS-67414
ALTER TABLE CLIENTINVOICECATEGORYCHARGE ADD (INVOICETO NUMBER DEFAULT 1 NOT NULL
                                             CONSTRAINT INVOICETO_VALID2_1 CHECK (INVOICETO IN (0, 1)));

COMMENT ON COLUMN CLIENTINVOICECATEGORYCHARGE.INVOICETO
  IS '0 = Customer
1 = Client.
Please note: the values 0 and 1 are the same as the InvoiceTo field in ClientInvoiceCategory. However in the old functionality special charges defined in the client invoice category were always charged to the client therefore default is client. Percentage special charges must always be invoiced to the client.
';