VendorCreditsBillCredited

Get bills credited to a vendor credit

Table-Specific Information

Select

The provider uses 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 provider.

BillId supports the '=' comparison.
VendorCreditId supports the '=' comparison.

For example, the following queries are processed server-side:

SELECT * FROM VendorCreditsBillCredited WHERE BillId = '3350895000000089001'

SELECT * FROM VendorCreditsBillCredited WHERE VendorCreditId = '983872973'

Insert

To insert into this table, specify the VendorCreditId and Bills columns. Non-read-only columns can be inserted optionally. For example:

INSERT INTO VendorCreditsBillCredited(VendorCreditId,Bills) VALUES ('3782369000000057091','[{"bill_id":"3782369000000067353","amount_applied":10}]');

Delete

To delete from this table, specify the VendorCreditId and VendorCreditBillId in the WHERE clause. For example:

DELETE FROM VendorCreditsBillCredited WHERE VendorCreditId = '3782369000000057091' AND VendorCreditBillId = '3782369000000099126';

Columns


Name	Type	ReadOnly	References	Description
VendorCreditId [KEY]	String	False	VendorCredits.Id	Vendor Credit Id
BillId	String	True		Bill Id
BillNumber	String	True		Bill Number
Date	Date	True		Date
VendorCreditBillId [KEY]	String	True		Vendor Credit Bill Id
Amount	Double	True		Amount.
VendorCreditNumber	String	True		Vendor credit number.

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
Bills	String	Amount applied from vendor credits to specified bills. This contains bill_id and amount_applied.