CData Python Connector for Zoho Inventory

Build 26.0.9770

VendorCredits

List, Insert, Update, delete VendorCredits

Table Specific Information

Select

The connector will use the Zoho Inventory 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.

  • Id supports the '=' comparison.
  • VendorId supports the '=' comparison.
  • Date supports the '>,<,>=,<=,=' comparisons.
  • LastModifiedTime supports the '>,<,>=,<=,=' comparisons.
  • ReferenceNumber supports the '=,LIKE' comparisons.
  • Status supports the '=' comparison.
  • Total supports the '=,>,<,>=,<=' comparisons.
  • VendorCreditNumber supports the '=,LIKE' comparisons.
  • Notes supports the '=,LIKE' comparisons.
  • VendorName supports the '=' comparison.
  • CustomerName supports the '=,LIKE' comparisons.
  • ItemName supports the '=,LIKE' comparisons.
  • ItemDescription supports the '=,LIKE' comparisons.
  • ItemId supports the '=' comparison.
  • LineItemId supports the '=' comparison.
  • VendorCreditsFilter supports the '=' comparison.

For example, the following queries are processed server side: 

SELECT * FROM VendorCredits WHERE Id = '3350895000000089001'

SELECT * FROM VendorCredits WHERE VendorCreditNumber = '983872973'

SELECT * FROM VendorCredits WHERE Date = '22-09-12'

SELECT * FROM VendorCredits WHERE Status = 'closed'

SELECT * FROM VendorCredits WHERE Total = '244'

SELECT * FROM VendorCredits WHERE ReferenceNumber = '2287678362612'

SELECT * FROM VendorCredits WHERE CustomerName = 'Ms. Name'

SELECT * FROM VendorCredits WHERE ItemName = 'item name'

SELECT * FROM VendorCredits WHERE ItemDescription = 'Item description'

SELECT * FROM VendorCredits WHERE Notes = 'my notes'

SELECT * FROM VendorCredits WHERE LastModifiedTime = '2014-08-28T22:53:31-0700'

SELECT * FROM VendorCredits WHERE LineItemId = '3359001'

Insert

Insert can be executed by specifying the VendorId column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table. 

INSERT INTO VendorCredits (VendorId) VALUES (324905600000085109)

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example: 

UPDATE VendorCredits SET Notes = 'test2' WHERE Id = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example: 

DELETE FROM VendorCredits WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

ID of the vendor the vendor credit associated with the Vendor Credit

VendorId Long False

ID of the Vendor Involved in the Vendor Credit

PriceBookId Long False

ID of the pricebook

Balance Integer True

Balance in the Vendor Credit

CreatedTime Datetime True

Time of Vendor Credit Creation

CurrencyCode String True

Code of the Currency Involved in the Vendor Credit

CurrencyId String True

ID of the Currency Involved in the Vendor Credit

SourceofSupply String True

Place from where the goods/services are supplied.

DestinationofSupply String True

Place where the goods/services are supplied to.

PlaceofSupply String True

The place of supply is where a transaction is considered to have occurred for VAT purposes.

GstNo String True

15 digit GST identification number of the customer/vendor..

GstTreatment String True

Choose whether the contact is GST registered/unregistered/consumer/overseas.

Date Date False

The date the vendor credit is created. [yyyy-mm-dd]

ExchangeRate Integer False

Exchange rate of the currency.

HasAttachment Boolean True

Boolean to check whether it has attachment or not

IsReverseChargeApplied Boolean True

Applicable for transactions where you pay reverse charge

IsUpdateCustomer Boolean False

Check if customer should be updated

IsInclusiveTax Boolean False

Check if tax is inclusive.

LastModifiedTime Datetime True

Search vendor credits by vendor credit last modfified time

ReferenceNumber String False

Search vendor credits by vendor credit reference number.

Status String True

Search vendor credits by vendor credit status.

The allowed values are open, closed, void.

SourceofSupply String True

Place from where the goods/services are supplied.

Total Integer True

Search vendor credits by total amount.

Tags String True

tags

Notes String False

notes

TaxTreatment String True

VAT treatment for the vendor credit.

VendorCreditNumber String False

Number of the Vendor Credit

VendorName String True

Name of the Vendor Associated with the Vendor Credit

LineItems String False

Line items of a vendor credit.

VendorCreditRefunds String True

Vendor Credit Refunds.

Documents String False

Documents.

Comments String True

Comments.

BillsCredited String True

Bills Credited.

CustomerName String True

Search vendor credits by vendor name.

ItemName String True

Name of an item.

ItemDescription String True

Description of an item.

ItemId Long True

Items.ItemId

Id of an item.

LineItemId Long True

Id of lineitem.

Adjustment Double True

Adjustment amount.

ApproverId Long True

ID of the approver.

BillingAddress String True

Billing address.

BranchId Long True

ID of the branch.

ComputationType String True

Computation type.

Discount Double True

Discount applied.

DiscountAccountId Long True

ID of the discount account.

LocationId Long False

ID of the location.

SubStatuses String True

Sub-statuses.

SubTotal Double True

Sub-total.

Taxes String True

Taxes.

TemplateId Long True

ID of the template.

TotalCreditsUsed Double True

Total credits used.

TotalRefundedAmount Double True

Total refunded amount.

AdjustmentDescription String True

Adjustment description.

ApproversList String True

Approvers list.

BillingAddressId Long True

ID of the billing address.

BranchName String True

Name of the branch.

ContactCategory String True

Contact category.

CreatedById Long True

ID of the creator.

CreatedByName String True

Name of the creator.

CurrencySymbol String True

Currency symbol.

DiscountAccountName String True

Name of the discount account.

DiscountAppliedOnAmount Double True

Discount applied on amount.

DiscountPercent Double True

Discount percentage.

DiscountSetting String True

Discount setting.

DiscountTotal Double True

Discount total.

DiscountType String True

Discount type.

EntityType String True

Entity type.

IsDiscountBeforeTax Boolean True

Whether discount is applied before tax.

LastModifiedById Long True

ID of the last modifier.

LastModifiedByName String True

Name of the last modifier.

LocationName String True

Name of the location.

Orientation String True

Orientation.

PageHeight String True

Page height.

PageWidth String True

Page width.

PricePrecision Integer True

Price precision.

PricebookName String True

Name of the price book.

SubTotalInclusiveOfTax Double True

Sub-total inclusive of tax.

SubjectContent String True

Subject content.

SubmittedBy String True

Submitted by.

SubmittedByEmail String True

Email of the submitter.

SubmittedByName String True

Name of the submitter.

SubmittedByPhotoUrl String True

Photo URL of the submitter.

SubmittedDate Date True

Submitted date.

SubmitterId Long True

ID of the submitter.

TaxOverridePreference String True

Tax override preference.

TaxRounding String True

Tax rounding.

TdsCalculationType String True

TDS calculation type.

TemplateName String True

Name of the template.

TemplateType String True

Type of the template.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
VendorCreditsFilter String

Filter invoices by any status or payment expected date.

The allowed values are Status.All, Status.Draft, Status.Void, Status.Open, Status.Closed.

SearchText String

Search vendor credits by vendor credit number or vendor name or vendor credit reference number.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770