`Chart_Of_Account_Transaction` table

Column Type

Account_Id

String

Payee

String

Categorized_Transaction_Id

String

Transaction_Type

String

Transaction_Id

String

Transaction_String

String

Offset_Account_Name

String

Customer_Id

String

Transaction_Type_Formatted

String

Description

String

Entry_Number

String

Currency_Id

String

Currency_Code

String

Reference_Number

String

Debit_Or_Credit

String

Debit_Amount

String

Fcy_Credit_Amount

Number

Credit_Amount

Number

Fcy_Debit_Amount

String

Examples

SELECT
    *
FROM
    Chart_Of_Account_Transaction
WHERE
    Account_Id = '579676000000000376'
    AND Transaction_Type = 'invoice'