Journal_Line_Item view

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

String

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_Item_Id

String

Line_Items_Account_Id

String

Line_Items_Customer_Id

String

Line_Items_Customer_Name

String

Line_Items_Account_Name

String

Line_Items_Description

String

Line_Items_Debit_Or_Credit

String

Line_Items_Tax_Exemption_Id

String

Line_Items_Tax_Exemption_Type

String

Line_Items_Tax_Treatment_Code

String

Line_Items_Tax_Authority_Id

String

Line_Items_Tax_Authority_Name

String

Line_Items_Tax_Id

String

Line_Items_Tax_Name

String

Line_Items_Tax_Type

String

Line_Items_Tax_Percentage

String

Line_Items_Amount

Number

Line_Items_Bcy_Amount

Number

Line_Items_Acquisition_Vat_Id

String

Line_Items_Acquisition_Vat_Name

String

Line_Items_Acquisition_Vat_Percentage

String

Line_Items_Acquisition_Vat_Amount

String

Line_Items_Reverse_Charge_Vat_Id

String

Line_Items_Reverse_Charge_Vat_Name

String

Line_Items_Reverse_Charge_Vat_Percentage

String

Line_Items_Reverse_Charge_Vat_Amount

String

Line_Items_Project_Id

String

Line_Items_Project_Name

String

Line_Items_Line_Id

String

Line_Items_Item_Order

Number

Line_Items_Reverse_Charge_Tax_Percentage

Number

Line_Items_Line_Item_Taxes

Array

Line_Items_Acquisition_Tax_Name

String

Line_Items_Acquisition_Tax_Id

String

Line_Items_Acquisition_Tax_Percentage

Number

Line_Items_Reverse_Charge_Tax_Amount

Number

Line_Items_Acquisition_Tax_Amount

Number

Line_Items_Reverse_Charge_Tax_Id

String

Line_Items_Reverse_Charge_Tax_Name

String

Line_Items_Tags

Array