-- ABS-11219/ ABS-36283

ALTER TABLE CLIENTINVOICECATEGORY ADD (MARKCLIENTPAIDPRODUCTS VARCHAR2(1) DEFAULT 'N' NOT NULL
                                        CONSTRAINT YN_VALIDATIONFIELD308 CHECK (MARKCLIENTPAIDPRODUCTS IN ('Y', 'N')));
 
COMMENT ON COLUMN CLIENTINVOICECATEGORY.MARKCLIENTPAIDPRODUCTS
  IS 'Used in combination with InvoiceTo = 0 (All to customer). Everything is invoiced to the customer, but some products can be marked to appear on a separate list to be paid by the client.';
