--order 502497

insert into invoiceappendixdefinition
      (invoiceappendixdefinition_id,
       invoiceappendixtype,
       description,
       reportname,
       customercode,
       module,
       MANUAL,
       DIRECTINVOICE,
       OTHERSERVICES,
       RESIDENTIALSERVICES,
       systemuser_id,
       timestamp)
    values
      (28,
       28,
       'Garment charges per cost center',
       'GarmentChargesCostCenter.rpt',
       '',
       'BKLBASIS',
       'N',
       'Y',
       'Y',
       'N',
       getminsystemuser(),
       sysdate);

ALTER TABLE PRINTQUEUE ADD ( DISTRIBUTIONPOINT_LINK_ID NUMBER NULL );

CREATE INDEX XIF10PRINTQUEUE ON PRINTQUEUE
(
	DISTRIBUTIONPOINT_LINK_ID ASC
);

ALTER TABLE PRINTQUEUE ADD 
	( CONSTRAINT PRINTQUEUE_DISTRIBUTIONPOINT_L FOREIGN KEY (DISTRIBUTIONPOINT_LINK_ID)
		REFERENCES DISTRIBUTIONPOINT_LINK );