Chart_Of_Account table

Column Type

Account_Id

String

Account_Name

String

Account_Code

String

Account_Type

String

Account_Type_Formatted

String

Is_Active

Boolean

Currency_Id

String

Currency_Code

String

Description

String

Is_System_Account

Boolean

Is_Involved_In_Transaction

Boolean

Can_Show_In_Ze

Boolean

Include_In_Vat_Return

Boolean

Parent_Account_Id

String

Parent_Account_Name

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Closing_Balance

Number

Closing_Balance_Formatted

String

Isdebit

Boolean

Status

String

Is_User_Created

Boolean

Child_Count

String

Has_Attachment

Boolean

Depth

Number

Is_Child_Present

Boolean

Is_Standalone_Account

Boolean

Include_In_Bas

Boolean

Documents

Array

Transactions

Array

Examples

INSERT INTO
    Chart_Of_Account (Account_Name, Description, Account_Type)
values
    ('Test Account', 'Easysoft test COA', 'income')
DELETE FROM Chart_Of_Account
WHERE
    Account_Name = 'Test Account'