MuleSoft Connector for Zoho Books

Build 20.0.7654

BillDetails

Get the details of a bill.

Table Specific Information

Select

The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
Note: BillId is required in order to query BillDetails.

  • BillId supports the '=' comparison.
For example:
    SELECT * FROM BillDetails WHERE BillId = '1894553000000085259'

Columns

Name Type References SupportedOperators Description
BillId [KEY] String

Bills.BillId

ID of a Bill.
BillNumber String Number of a Bill.
Adjustment Decimal Adjustments made to the bill.
AdjustmentDescription String Description of adjustments made to the bill.
AllocatedLandedCosts String Allocated landed costs of bill.
ApproverId String

Users.UserId

ID of an approver.
AttachmentName String Name of an attachment.
Balance Decimal Balance of bill.
BillingAddress String Billing address of a bill.
BillingAddressAttention String Name of a person in billing address.
BillingAddressCity String City of a billing address.
BillingAddressCountry String Country of a billing address.
BillingAddressFax String Fax of a billing address.
BillingAddressPhone String Phone of a billing address.
BillingAddressState String State of a billing address.
BillingAddressStreet2 String Street two of a billing address.
BillingAddressZip String Zip of a billing address.
ClientViewedTime String Time when client viewed.
ColorCode String Color code.
ContactCategory String Category if contact.
CreatedById String

Users.UserId

Id of a user who has created bill.
CreatedTime Datetime Time at which the bill was created.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CurrencySymbol String Symbol of the currency.
CurrentSubStatus String Current sub status of a bill.
CurrentSubStatusId String Current sub status ID of a bill.
Date Date Bill date.
DestinationOfSupply String Place where the goods/services are supplied to.
Discount String Discount of bills.
DiscountAccountId String

BankAccounts.AccountId

Account ID of discount.
DiscountAmount Decimal Amount of discount.
DiscountAppliedOnAmount Decimal Discount applied on amount.
DiscountSetting String Setting of discount.
DueByDays Integer Number of days the bill is due by.
DueDate Date Delivery date of the bill.
DueInDays String Number of days the bill is due in.
EntityType String Entity type of the bill.
ExchangeRate Decimal Exchange rate of the currency.
FiledInVatReturnId String VAT return ID of bill which was filed.
FiledInVatReturnName String VAT return name of bill which was filed.
FiledInVatReturnType String VAT return type of bill which was filed.
GstNo String GST number.
GstReturnDetailsReturnPeriod String Return period of GST.
GstReturnDetailsStatus String Status of GST return details.
GstTreatment String Choose whether the bill is GST registered/unregistered/consumer/overseas.
HasNextBill Boolean Check if it has next bill.
InvoiceConversionType String Type of invoice conversion.
IsApprovalRequired Boolean Check of the approval required.
IsDiscountBeforeTax Boolean Check if discount should be applied before tax.
IsInclusiveTax Boolean Check if the tax is inclusive in the bill.
IsItemLevelTaxCalc Boolean Check if the item leven tax is calculated.
IsLineItemInvoiced Boolean Check if the line item is invoiced in the bill.
IsPreGst Boolean Check if pre GST is applied.
IsReverseChargeApplied Boolean Check if reverse charge is applied.
IsTdsAmountInPercent Boolean Check if the TDS amount in percent.
IsTdsApplied Boolean Check if TDS is applied.
IsViewedByClient Boolean Check if bill is viewed by client.
LastModifiedId String ID when bill was last modified.
LastModifiedTime Datetime The time of last modification of the bill.
Notes String Notes of the bill.
OpenPurchaseordersCount Integer Count of open purchase order.
Orientation String Orientation of the bill.
PageHeight String Height of the page.
PageWidth String Width o the page.
PaymentExpectedDate Date Date when the payment is expected.
PaymentMade Decimal Amount paid of this bill.
PaymentTerms Integer Net payment term for the customer.
PaymentTermsLabel String Label for the paymet due details.
PricePrecision Integer The precision for the price.
RecurringBillId String ID of a recurring bill.
ReferenceBillId String ID of a reference bill.
ReferenceId String Id of a reference.
ReferenceNumber String Number of a reference.
SourceOfSupply String Source of supply of bill.
Status String Status of the bill.
SubTotal Decimal Sub total of bills.
SubTotalInclusiveOfTax Decimal Subtotal amount which are inclusive of tax.
SubmittedBy String Detail of the user who has submitted the bill.
SubmittedDate Date Bill submitted date.
SubmitterId String

Users.UserId

Id of a submitter.
TaxAccountId String

BankAccounts.AccountId

Account ID of tax.
TaxTotal Decimal Total amount of tax.
TaxTreatment String VAT treatment for the Bill.
TdsAmount Decimal Amount of TDS.
TdsPercent String Percent of TDS.
TdsSection String Section of TDS.
TdsTaxId String Tax ID of TDS.
TdsTaxName String Tax name of TDS.
TemplateId String ID of a template.
TemplateName String Name of a template.
TemplateType String Type of a template.
Terms String Terms and Conditions apply of a bill.
Total Decimal Total of bills.
UnallocatedLandedCosts String Costs of unlocated land.
UnusedCreditsPayableAmount Decimal Payable amount of unused credits.
VatTreatment String VAT treatment for the bills.
VendorCreditsApplied Decimal Amount of applied vendor credits.
VendorId String ID of the vendor the bill has been made.
VendorName String Name of the vendor the bill has been made.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654