Journal table Column Type Journal_Id String Entry_Number String Reference_Number String Notes String Currency_Id String Currency_Code String Currency_Symbol String Exchange_Rate Number Journal_Date Date Journal_Type String Vat_Treatment String Product_Type String Include_In_Vat_Return Boolean Is_Bas_Adjustment Boolean Line_Item_Total Number Total Number Bcy_Total Number Price_Precision Number Created_Time Timestamp Last_Modified_Time Timestamp Status String Journal_Number_Suffix String Tax_Treatment String Journal_Template_Name String Journal_Number_Prefix String Journal_Transaction_Type String Available_Receivables_Credits Number Available_Payables_Credits Number Reverse_Charge_Vat_Total Number Is_Accrual_Journal Boolean Project_Id String Project_Name String Custom_Fields String Branch_Difference Array Created_By_Name String Entity_Type String Created_By_Id String Line_Items Array Taxes Array Bills_Credited Array Reverse_Charge_Vat_Summary JSONData Documents Array Comments Array Imported_Transactions Array Invoices_Credited Array Examples DELETE FROM Journal WHERE Journal_Id='579676000000130007'