MuleSoft Connector for Zoho Books

Build 20.0.7654

VendorCreditDetails

Get details of a vendor credit.

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: VendorCreditId is required in order to query VendorCreditDetails.

  • VendorCreditId supports the '=' comparison.
For example:
    SELECT * FROM VendorCreditDetails WHERE VendorCreditId = '1894545000000083308'

Columns

Name Type References SupportedOperators Description
VendorCreditId [KEY] String

VendorCredits.VendorCreditId

Id of a vendor credit.
VendorCreditNumber String Number of vendor credit.
VendorId String ID of the vendor the vendor credit has been made.
VendorName String Name of the vendor the vendor credit has been made.
Adjustment Decimal Adjustments made to the vendor credit.
AdjustmentDescription String Description of adjustments made to the vendor credit.
ApproverId String

Users.UserId

ID of a approver.
Balance Decimal Total balance of vendor credit.
BillId String

Bills.BillId

ID of a Bill.
BillNumber String Number of a Bill.
ColorCode String Color code of vendor credit.
ContactCategory String Category of a contact.
CreatedTime Datetime Time at which the vendor credit was created.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CurrentSubStatus String Current sub status of a vendor credit.
CurrentSubStatusId String Current sub status ID of a vendor credit.
Date Date Vendor Credit date.
DestinationOfSupply String Place where the goods/services are supplied to.
Discount String Discount amount applied to vendor credit.
DiscountAccountId String

BankAccounts.AccountId

Account ID of the discount.
DiscountAmount Decimal Amount of the discount.
DiscountAppliedOnAmount Decimal Amount applied on discount.
DiscountSetting String Settings of discount.
ExchangeRate Decimal Exchange rate applied for vendor credits.
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 return details.
GstReturnDetailsStatus String Status of GST return details.
GstTreatment String Choose whether the vendor credit is GST registered/unregistered/consumer/overseas.
HasNextVendorcredit Boolean Check if there is nect vendor credit.
IsDiscountBeforeTax Boolean Check if discount is applicable before tax.
IsInclusiveTax Boolean Check if tax is inclusive.
IsPreGst Boolean Check if pre GST is applied.
IsReverseChargeApplied Boolean Check if the reverse charge is applied.
LastModifiedTime Datetime The time of last modification of the vendor credits.
Notes String Notes of vendor credit.
Orientation String Orientation of vendor credit.
PageHeight String Height of a page.
PageWidth String Width of a page.
PricePrecision Integer The precision for the price.
ReasonForDebitNote String Specified reason for debit note.
ReferenceNumber String Reference number of vendor credit.
SourceOfSupply String Source of supply.
Status String Status of the vendor credit.
SubTotal Decimal Sub total of vendor credits.
SubTotalInclusiveOfTax Decimal Amount if the subtotal is inclusive of tax.
SubmittedBy String Detail of the user who has submitted the vendor credit.
SubmittedDate Date Date when vendor credit was submitted.
SubmitterId String

Users.UserId

ID of vendor credit submitter.
TaxTreatment String VAT treatment for the Vendor Credit.
TemplateId String ID of a template.
TemplateName String Name of a template.
TemplateType String Type of a template.
Total Decimal Total of vendor credits.
TotalCreditsUsed Decimal Total credits used for this vendor credit.
TotalRefundedAmount Decimal Total amount refunded for a vendor credit.
VatTreatment String VAT treatment for the vendor credit.

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