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

Example

DELETE FROM Journal WHERE Journal_Id='579676000000130007'