Expense_Acquisition_Vat_Summary view

Column Type

Expense_Id

String

Transaction_Id

String

Transaction_Type

String

Gst_No

String

Gst_Treatment

String

Tax_Treatment

String

Destination_Of_Supply

String

Destination_Of_Supply_State

String

Place_Of_Supply

String

Hsn_Or_Sac

String

Source_Of_Supply

String

Paid_Through_Account_Name

String

Vat_Reg_No

String

Reverse_Charge_Tax_Id

String

Reverse_Charge_Tax_Name

String

Reverse_Charge_Tax_Percentage

Number

Reverse_Charge_Tax_Amount

Number

Tax_Amount

Number

Is_Itemized_Expense

Boolean

Is_Pre_Gst

String

Trip_Id

String

Trip_Number

String

Reverse_Charge_Vat_Total

Number

Acquisition_Vat_Total

Number

Expense_Item_Id

String

Account_Id

String

Account_Name

String

Date

String

Tax_Id

String

Tax_Name

String

Tax_Percentage

Number

Currency_Id

String

Currency_Code

String

Exchange_Rate

Number

Sub_Total

Number

Total

Number

Bcy_Total

Number

Amount

Number

Is_Inclusive_Tax

Boolean

Reference_Number

String

Description

String

Is_Billable

Boolean

Is_Personal

Boolean

Customer_Id

String

Customer_Name

String

Expense_Receipt_Name

String

Expense_Receipt_Type

String

Last_Modified_Time

String

Status

String

Invoice_Id

String

Invoice_Number

String

Project_Id

String

Project_Name

String

Mileage_Rate

Number

Mileage_Type

String

Expense_Type

String

Start_Reading

Number

End_Reading

Number

Vendor_Id

String

Vendor_Name

String

Vat_Treatment

String

Is_Recurring_Applicable

Boolean

Tax_Exemption_Id

String

Report_Name

String

Fuel_Type

String

Fcy_Surcharge_Amount

Number

Zcrm_Potential_Name

String

Created_By_Id

String

Vehicle_Name

String

Markup_Percent

Number

Transaction_Type_Formatted

String

User_Email

String

Paid_Through_Account_Id

String

Filed_In_Vat_Return_Type

String

Approver_Id

String

Product_Type

String

Filed_In_Vat_Return_Name

String

Mileage_Unit

String

Is_Reverse_Charge_Applied

Boolean

User_Name

String

Itc_Eligibility

String

Filed_In_Vat_Return_Id

String

Tax_Exemption_Code

String

Vehicle_Type

String

Last_Modified_By_Id

String

Employee_Name

String

Is_Surcharge_Applicable

Boolean

Created_Time

Timestamp

Employee_Id

String

Employee_Email

String

Report_Number

String

Vehicle_Id

String

Fuel_Rate

Number

Fuel_Element

Number

Engine_Capacity_Range

String

Report_Id

String

User_Id

String

Approver_Name

String

Approver_Email

String

Report_Status

String

Is_Reimbursable

Boolean

Location

String

Merchant_Id

String

Merchant_Name

String

Payment_Mode

String

Bcy_Surcharge_Amount

Number

Zcrm_Potential_Id

String

Total_Without_Tax

Number

Bcy_Total_Without_Tax

Number

Distance

Number

Has_Attachment

Boolean

Gst_Treatment_Code

String

Gst_Return_Details_Return_Period

String

Gst_Return_Details_Status

String

Invoice_Conversion_Type

String

Tax_Override

Boolean

Tax_Override_Preference

String

Tax_Reg_No

String

Custom_Fields_List

String

Acquisition_Vat_Summary_Tax_Name

String

Acquisition_Vat_Summary_Tax_Amount

Number