The function get_customer_trans_details now includes itemPrice ex tax in SQL.