SSIS Components for Zoho Books

Build 24.0.9062

RecurringBillLineItems

Get the details of a line items of bills.

Columns

Name Type References SupportedOperators Description
LineItemId [KEY] String Id of line item.
RecurringBillId String

Bills.BillId

Id of a Bill.
AccountId String

BankAccounts.AccountId

Id of the Bank Account.
AccountName String Name of the account.
BcyRate Decimal Rate of Base Currency.
CustomFields String Custom fields.
CustomerId String

Contacts.ContactId

Id of the customer or vendor.
CustomerName String Name of the customer or vendor.
Description String Description of the bill line item.
Discount Double Discount to be applied on the bill line item.
HeaderId String Id of the Bank Account.
HeaderName String Id of the Bank Account.
ImageDocumentId String Id of the image document.
IsBillable Boolean Check if the bill line items is billable.
ItemId String

Items.ItemId

Id of an item.
ItemOrder Integer Order of an item.
ItemTotal Decimal Total items.
ItemType String Type of item.
Name String Name of the bill line item.
PricebookId String Id of pricebook.
ProjectId String

Projects.ProjectId

Id of project.
ProjectName String Name of the project.
Quantity Decimal Quantity of line item.
Rate Decimal Rate of the line item.
TaxId String

Taxes.TaxId

Id of tax.
TaxName String Name of tax.
TaxPercentage Integer Percentage applied for tax.
TaxType String Type of tax.
Unit String Number of quantity.
SKU String The SKU of the Line Item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062