Bill_Line_Item view

Column Type

Bill_Id

String

Purchaseorder_Ids

Array

Vendor_Id

String

Vendor_Name

String

Vat_Treatment

String

Vat_Reg_No

String

Source_Of_Supply

String

Destination_Of_Supply

String

Place_Of_Supply

String

Permit_Number

String

Gst_No

String

Gst_Treatment

String

Tax_Treatment

String

Is_Pre_Gst

Boolean

Pricebook_Id

String

Pricebook_Name

String

Is_Reverse_Charge_Applied

Boolean

Unused_Credits_Payable_Amount

Number

Status

String

Bill_Number

String

Date

String

Due_Date

String

Payment_Terms

Number

Payment_Terms_Label

String

Payment_Expected_Date

String

Reference_Number

String

Recurring_Bill_Id

String

Due_By_Days

String

Due_In_Days

Number

Currency_Id

String

Currency_Code

String

Currency_Symbol

String

Price_Precision

Number

Exchange_Rate

Number

Adjustment

Number

Adjustment_Description

String

Is_Tds_Applied

Boolean

Is_Item_Level_Tax_Calc

Boolean

Is_Inclusive_Tax

Boolean

Filed_In_Vat_Return_Id

String

Filed_In_Vat_Return_Name

String

Filed_In_Vat_Return_Type

String

Is_Abn_Quoted

String

Sub_Total

Number

Tax_Total

Number

Total

Number

Payment_Made

Number

Vendor_Credits_Applied

Number

Is_Line_Item_Invoiced

Boolean

Acquisition_Vat_Total

Number

Reverse_Charge_Vat_Total

Number

Balance

Number

Billing_Address_Id

String

Billing_Address_Address

String

Billing_Address_Street2

String

Billing_Address_City

String

Billing_Address_State

String

Billing_Address_Zip

String

Billing_Address_Country

String

Billing_Address_Fax

String

Billing_Address_Attention

String

Created_Time

Timestamp

Last_Modified_Time

Timestamp

Created_By_Id

String

Reference_Id

String

Notes

String

Terms

String

Attachment_Name

String

Open_Purchaseorders_Count

Number

Subject_Content

String

Tds_Calculation_Type

String

Billing_Address_Phone

String

Approver_Id

String

Current_Sub_Status

String

Template_Id

String

Contact_Category

String

Discount_Amount

Number

Is_Viewed_By_Client

Boolean

Tax_Override_Preference

String

Discount_Applied_On_Amount

Number

Source

String

Client_Viewed_Time

String

Submitted_Date

String

Orientation

String

Can_Send_In_Mail

Boolean

Submitter_Id

String

Current_Sub_Status_Id

String

Color_Code

String

Submitted_By_Name

String

Submitted_By_Photo_Url

String

Unprocessed_Payment_Amount

Number

Discount_Setting

String

Discount_Account_Name

String

Currency_Name_Formatted

String

Is_Tally_Bill

Boolean

Submitted_By_Email

String

Tax_Rounding

String

Is_Uber_Bill

Boolean

Track_Discount_In_Account

Boolean

Is_Bill_Reconciliation_Violated

Boolean

Submitted_By

String

Discount

Number

Is_Discount_Before_Tax

Boolean

Discount_Account_Id

String

Discount_Type

String

Sub_Total_Inclusive_Of_Tax

Number

Entity_Type

String

Last_Modified_Id

String

Page_Width

String

Template_Name

String

Page_Height

String

Template_Type

String

Is_Approval_Required

Boolean

Can_Create_Bill_Of_Entry

Boolean

Tds_Total

Number

Due_Days

String

Has_Attachment

Boolean

Reference_Invoice_Type

String

Gst_Return_Details_Return_Period

String

Gst_Return_Details_Status

String

Can_Amend_Transaction

Boolean

Bill_Order_Type

String

Invoice_Conversion_Type

String

Is_Tds_Amount_In_Percent

Boolean

Tax_Account_Id

String

Tds_Percent

String

Tds_Amount

Number

Tax_Override

Boolean

Tds_Override_Preference

String

Tax_On_Discount_Preference

String

Is_Discount_Tax_Inclusive

Boolean

Reference_Bill_Id

String

Abn

String

Tax_Reg_No

String

Line_Items_Purchaseorder_Item_Id

String

Line_Items_Line_Item_Id

String

Line_Items_Item_Id

String

Line_Items_Sku

String

Line_Items_Name

String

Line_Items_Account_Id

String

Line_Items_Account_Name

String

Line_Items_Image_Document_Id

String

Line_Items_Warehouse_Id

String

Line_Items_Warehouse_Name

String

Line_Items_Reverse_Charge_Tax_Id

String

Line_Items_Reverse_Charge_Tax_Name

String

Line_Items_Reverse_Charge_Tax_Percentage

Number

Line_Items_Reverse_Charge_Tax_Amount

Number

Line_Items_Description

String

Line_Items_Bcy_Rate

Number

Line_Items_Rate

Number

Line_Items_Quantity

Number

Line_Items_Tax_Id

String

Line_Items_Tds_Tax_Id

String

Line_Items_Tax_Treatment_Code

String

Line_Items_Tax_Exemption_Id

String

Line_Items_Tax_Exemption_Code

String

Line_Items_Tax_Name

String

Line_Items_Tax_Type

String

Line_Items_Tax_Percentage

Number

Line_Items_Item_Total

Number

Line_Items_Item_Total_Inclusive_Of_Tax

Number

Line_Items_Item_Order

Number

Line_Items_Unit

String

Line_Items_Product_Type

String

Line_Items_Hsn_Or_Sac

String

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_Is_Billable

Boolean

Line_Items_Customer_Id

String

Line_Items_Customer_Name

String

Line_Items_Project_Id

String

Line_Items_Project_Name

String

Line_Items_Invoice_Id

String

Line_Items_Invoice_Number

String

Line_Items_Discounts

Array

Line_Items_Line_Item_Taxes

Array

Line_Items_Itc_Eligibility

String

Line_Items_Sales_Rate

String

Line_Items_Discount_Account_Id

String

Line_Items_Discount_Account_Name

String

Line_Items_Item_Type

String

Line_Items_Header_Name

String

Line_Items_Discount

Number

Line_Items_Tags

Array

Line_Items_Pricebook_Id

String

Line_Items_Header_Id

String

Line_Items_Markup_Percent

Number

Line_Items_Image_Name

String

Line_Items_Image_Type

String

Line_Items_Purchase_Request_Items

Array

Line_Items_Purchaseorder_Id

String

Line_Items_Receive_Id

String

Line_Items_Receipt_Line_Item_Id

String

Line_Items_Item_Matching_Type

String