Invoice_Tax view

Column Type

Invoice_Id

String

Ach_Payment_Initiated

Boolean

Invoice_Number

String

Is_Pre_Gst

Boolean

Place_Of_Supply

String

Gst_No

String

Gst_Treatment

String

Cfdi_Usage

String

Cfdi_Reference_Type

String

Reference_Invoice_Id

String

Vat_Treatment

String

Tax_Treatment

String

Vat_Reg_No

String

Date

String

Status

String

Payment_Terms

Number

Payment_Terms_Label

String

Due_Date

String

Payment_Expected_Date

String

Last_Payment_Date

String

Reference_Number

String

Customer_Id

String

Customer_Name

String

Currency_Id

String

Currency_Code

String

Exchange_Rate

Number

Discount

String

Is_Discount_Before_Tax

Boolean

Discount_Type

String

Is_Inclusive_Tax

Boolean

Recurring_Invoice_Id

String

Is_Viewed_By_Client

Boolean

Has_Attachment

Boolean

Client_Viewed_Time

String

Shipping_Charge

String

Adjustment

Number

Adjustment_Description

String

Sub_Total

Number

Tax_Total

Number

Total

Number

Payment_Reminder_Enabled

Boolean

Payment_Made

Number

Credits_Applied

Number

Tax_Amount_Withheld

Number

Balance

String

Write_Off_Amount

String

Allow_Partial_Payments

Boolean

Price_Precision

Number

Is_Emailed

Boolean

Reminders_Sent

Number

Last_Reminder_Sent_Date

String

Billing_Address_Address

String

Billing_Address_Street

String

Billing_Address_Street2

String

Billing_Address_City

String

Billing_Address_State

String

Billing_Address_Zip

String

Billing_Address_Country

String

Billing_Address_Phone

String

Billing_Address_Fax

String

Billing_Address_Attention

String

Billing_Address_Additional_Number

String

Billing_Address_District_Sec_Lang

String

Billing_Address_Attention_Sec_Lang

String

Billing_Address_Address_Sec_Lang

String

Billing_Address_District

String

Billing_Address_Phone_Sec_Lang

String

Billing_Address_Additional_Number_Sec_Lang

String

Billing_Address_City_Sec_Lang

String

Billing_Address_Street2_Sec_Lang

String

Billing_Address_Fax_Sec_Lang

String

Billing_Address_State_Sec_Lang

String

Billing_Address_Zip_Sec_Lang

String

Billing_Address_Country_Sec_Lang

String

Shipping_Address_Address

String

Shipping_Address_Street

String

Shipping_Address_Street2

String

Shipping_Address_State_Code

String

Shipping_Address_City

String

Shipping_Address_State

String

Shipping_Address_Zip

String

Shipping_Address_Country

String

Shipping_Address_Phone

String

Shipping_Address_Fax

String

Shipping_Address_Attention

String

Shipping_Address_Additional_Number

String

Shipping_Address_District_Sec_Lang

String

Shipping_Address_Attention_Sec_Lang

String

Shipping_Address_Address_Sec_Lang

String

Shipping_Address_District

String

Shipping_Address_Phone_Sec_Lang

String

Shipping_Address_Additional_Number_Sec_Lang

String

Shipping_Address_City_Sec_Lang

String

Shipping_Address_Street2_Sec_Lang

String

Shipping_Address_Fax_Sec_Lang

String

Shipping_Address_State_Sec_Lang

String

Shipping_Address_Zip_Sec_Lang

String

Shipping_Address_Country_Sec_Lang

String

Notes

String

Terms

String

Template_Id

String

Template_Name

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Attachment_Name

String

Can_Send_In_Mail

Boolean

Salesperson_Id

String

Salesperson_Name

String

Invoice_Url

String

Reason

String

Is_Autobill_Enabled

Boolean

Offline_Created_Date_With_Time

String

Shipping_Charge_Tax_Exemption_Id

String

Submitted_By_Photo_Url

String

Is_Reverse_Charge_Applied

Boolean

Invoice_Source

String

Email

String

Computation_Type

String

Shipping_Charge_Tax_Percentage

String

Transaction_Rounding_Type

String

Created_By_Name

String

Currency_Symbol

String

Currency_Name_Formatted

String

Discount_Total

Number

Is_Backorder

String

Shipping_Charge_Exclusive_Of_Tax

Number

Submitted_By_Email

String

Subject_Content

String

Shipping_Charge_Inclusive_Of_Tax_Formatted

String

Shipping_Charge_Tax_Name

String

Payment_Discount

Number

Zcrm_Potential_Id

String

Bcy_Discount_Total

Number

Zcrm_Potential_Name

String

Shipping_Charge_Tax_Id

String

Ecomm_Operator_Name

String

Inprocess_Transaction_Present

Boolean

Reader_Offline_Payment_Initiated

Boolean

Ach_Supported

Boolean

Shipping_Charge_Inclusive_Of_Tax

Number

Discount_Percent

Number

Bcy_Shipping_Charge_Tax

String

Bcy_Tax_Total

Number

Shipping_Charge_Tax_Type

String

Bcy_Shipping_Charge

Number

Discount_Applied_On_Amount

Number

Filed_In_Vat_Return_Id

String

Shipping_Charge_Tax_Exemption_Code

String

Contact_Category

String

Shipping_Charge_Tax

String

Shipping_Charge_Tax_Formatted

String

Shipping_Charge_Exclusive_Of_Tax_Formatted

String

Color_Code

String

Bcy_Adjustment

Number

Bcy_Sub_Total

Number

Qr_Code_Qr_Source

String

Qr_Code_Qr_Value

String

Qr_Code_Qr_Description

String

Qr_Code_Is_Qr_Enabled

Boolean

Bcy_Total

Number

Reverse_Charge_Tax_Total

Number

Roundoff_Value

Number

Sub_Total_Inclusive_Of_Tax

Number

Tax_Reg_No

String

Is_Taxable

Boolean

Tax_Rounding

String

Orientation

String

Filed_In_Vat_Return_Name

String

Salesorder_Number

String

Filed_In_Vat_Return_Type

String

Tds_Calculation_Type

String

Can_Send_Invoice_Sms

Boolean

Stop_Reminder_Until_Payment_Expected_Date

Boolean

Submitted_Date

String

Ecomm_Operator_Id

String

Schedule_Time

String

Created_By_Id

String

Txn_Posting_Date

String

Merchant_Id

String

Merchant_Name

String

Salesorder_Id

String

Includes_Package_Tracking_Info

Boolean

Next_Reminder_Date_Formatted

String

Submitter_Id

String

Approver_Id

String

Submitted_By

String

Submitted_By_Name

String

Template_Type

String

Unused_Retainer_Payments

Number

Created_Date

String

Last_Modified_By_Id

String

Page_Width

String

Page_Height

String

Sales_Channel

String

Current_Sub_Status_Id

String

Current_Sub_Status

String

Estimate_Id

String

Is_Client_Review_Settings_Enabled

Boolean

Contact_Credit_Limit

Number

Contact_Customer_Balance

Number

Contact_Unused_Customer_Credits

Number

Contact_Is_Credit_Limit_Migration_Completed

Boolean

Customer_Default_Billing_Address_Zip

String

Customer_Default_Billing_Address_Country

String

Customer_Default_Billing_Address_Phone

String

Customer_Default_Billing_Address_Street2

String

Customer_Default_Billing_Address_Address

String

Customer_Default_Billing_Address_Fax

String

Customer_Default_Billing_Address_City

String

Customer_Default_Billing_Address_State

String

Customer_Default_Billing_Address_State_Code

String

Billing_Address_Zipcode

String

Due_Days

String

Project_Name

String

Company_Name

String

Shipping_Address_Zipcode

String

Created_By

String

Country

String

Phone

String

UpStringd_Time

Timestamp

Transaction_Type

String

Is_Export_With_Payment

Boolean

Is_Eway_Bill_Required

Boolean

Reason_For_Debit_Note

String

Merchant_Gst_No

String

Can_Generate_Ewaybill_Using_Irn

Boolean

Tds_Override_Preference

String

Shipping_Charge_Sac_Code

String

Type

String

Reference_Invoice_Type

String

Tax_Specification

String

Tax_Override_Preference

String

Gst_Return_Details_Return_Period

String

Gst_Return_Details_Status

String

Ecomm_Operator_Gst_No

String

No_Of_Copies

Number

Show_No_Of_Copies

Boolean

Reference_Invoice_Reference_Invoice_Id

String

Discount_Account_Id

String

Discount_Account_Name

String

Discount_Amount

Number

Mail_First_Viewed_Time

String

Mail_Last_Viewed_Time

String

Is_Viewed_In_Mail

Boolean

Customer_Name_Sec_Lang

String

Special_Transaction_Type

String

Gcc_Vat_Treatment

String

Supply_Date

String

Is_Simplified_Invoice

Boolean

Hsn_Or_Sac

String

Contact_Number

String

Preceding_Invoice_Id

String

Is_Correction_Invoice

Boolean

Tax_Exemption_Code

String

Tax_Exemption_Id

String

Tax_Authority_Id

String

Tax_Authority_Name

String

Taxes_Tax_Id

String

Taxes_Tax_Name

String

Taxes_Tax_Amount

Number

Taxes_Tax_Amount_Formatted

String

Taxes_Debit_Or_Credit

String

Taxes_Tax_Account

Boolean