Bank_Transaction_Line_Item view

Column Type

Transaction_Id

String

From_Account_Id

String

From_Account_Name

String

To_Account_Id

String

To_Account_Name

String

Transaction_Type

String

Currency_Id

String

Currency_Code

String

Payment_Mode

String

Exchange_Rate

Number

Date

String

Customer_Id

String

Customer_Name

String

Vendor_Id

String

Vendor_Name

String

Reference_Number

String

Description

String

Bank_Charges

Number

Tax_Id

String

Is_Inclusive_Tax

Boolean

Tax_Name

String

Tax_Percentage

Number

Tax_Amount

Number

Sub_Total

Number

Tax_Authority_Id

String

Tax_Authority_Name

String

Tax_Exemption_Id

String

Tax_Exemption_Code

String

Total

Number

Bcy_Total

Number

Amount

Number

Vat_Treatment

String

Product_Type

String

Acquisition_Vat_Id

String

Acquisition_Vat_Name

String

Acquisition_Vat_Percentage

String

Acquisition_Vat_Amount

String

Reverse_Charge_Vat_Id

String

Reverse_Charge_Vat_Name

String

Reverse_Charge_Vat_Percentage

String

Reverse_Charge_Vat_Amount

String

Filed_In_Vat_Return_Id

String

Filed_In_Vat_Return_Name

String

Filed_In_Vat_Return_Type

String

Payee

String

Account_Id

String

Account_Name

String

Running_Balance_Formatted

String

Is_Paid_Via_Print_Check

Boolean

Source

String

Rule_Name

String

Status

String

Is_Rule_Exist

Boolean

Rule_Id

String

Payroll_Tax_Group_Formatted

String

Account_Type

String

Is_Auto_Categorized

Boolean

Price_Precision

Number

Offset_Account_Code

String

Imported_Transaction_Id

String

Currency_Symbol

String

Debit_Or_Credit

String

Offset_Account_Name

String

Is_Offsetaccount_Matched

Boolean

Reconcile_Status

String

Exclude_Description

String

Is_Excluded_By_System

Boolean

Running_Balance

String

Line_Items_From_Account_Id

String

Line_Items_From_Account_Name

String

Line_Items_Payment_Mode

String

Line_Items_Customer_Id

String

Line_Items_Customer_Name

String

Line_Items_Vendor_Id

String

Line_Items_Vendor_Name

String

Line_Items_Sub_Total

Number

Line_Items_Total

Number

Line_Items_Bcy_Total

Number