VendorCreditDetails

Get details of a vendor credit.

Table Specific Information

Select

The 本製品 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 本製品.
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.

CData Python Connector for Zoho Books

VendorCreditDetails

Table Specific Information

Select

Columns