insert into invoiceappendixdefinition
      (invoiceappendixdefinition_id, invoiceappendixtype, description, reportname, customercode, module,
       MANUAL, DIRECTINVOICE, OTHERSERVICES, RESIDENTIALSERVICES, systemuser_id, timestamp)
    values
      (27, 27, 'Consignment Notes', 'InvoiceAppendixConsignmentNotes.rpt', 'WMA', null,
       'N', 'N', 'Y', 'N', getminsystemuser(), getcurrentdatetime());

