--ABS-95646 Do not charge patching for chargeble = N printqueuresidential records / ABS-99159
---------------PRINTQUEUERESIDENTIALITEM--------------


ALTER TABLE PRINTQUEUERESIDENTIALITEM ADD (PATCHINGINVOICELINE_ID NUMBER NULL);

CREATE INDEX XIF7PRINTQUEUERESIDENTIALITEM ON PRINTQUEUERESIDENTIALITEM(PATCHINGINVOICELINE_ID ASC);

ALTER TABLE PRINTQUEUERESIDENTIALITEM ADD CONSTRAINT FK_PRINTQRESIDITEM_INVLINE FOREIGN KEY (PATCHINGINVOICELINE_ID)
 REFERENCES INVOICELINE(INVOICELINE_ID) ON DELETE SET NULL;