INSERT INTO `comp_sales_creditnote_detail` (`creditnoteID`, `createdBy`, `itemID`, `invoiceDetailID`, `lineNo`, `itemdescription`, `quantity`, `umID`, `unitPrice`, `amountExcludedTax`, `taxID`, `taxRate`, `taxAmount`, `amountIncludedTax`) VALUES (27, '33', '71', 0, '1', 'BLACK', '1', '1', '500', '500', '1560', '6', '30', '530')