PurchaseReceives

Read, Insert and Delete Purchase Receives.

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.

For example, the following queries are processed server side:

SELECT * FROM PurchaseReceives WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the ReceiveNumber,= and LineItems 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 PurchaseReceives (ReceiveNumber, LineItems) VALUES ('PR-00001', '[{\"line_item_id\":3285934000000138007 \"item_id\":3285934000000104036, \"name\": \"Website\",\"item_order\": 0}]' )

Delete

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

DELETE FROM PurchaseReceives WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Unique ID generated by the server for the Purchase Receive.
ContactPersons	Long	False		Array of contact person IDs.
CreatedTime	Datetime	True		Time at which the Purchase Receive was created.
Date	Date	False		Date of Purchase Order
LastModifiedTime	Datetime	True		Time at which the Purchase Order details were last modified.
Notes	String	False		Purchase Receive notes.
PurchaseorderId	String	False	PurchaseOrders.Id	Unique ID generated by the server for the Purchase Order.
PurchaseorderNumber	String	False		Purchase Order number.
ReceiveNumber	String	False		Number of the Purchase Receive.
VendorId	Long	False		Unique ID generated by the server for the vendor.
VendorName	String	False		Name of the vendor.
LineItems	String	False		Number of line items for purchase receive.
ShippingAddressAddress	String	False		Address of billing address.
ShippingAddressCity	String	False		City of billing address.
ShippingAddressCountry	String	False		Country of billing address.
ShippingAddressFax	String	False		Fax of billing address.
ShippingAddressState	String	False		State of billing address.
ShippingAddressZip	Integer	False		Zip of billing address.
BillingAddressaddress	String	False		Address of billing address.
BillingAddresscity	String	False		City of billing address.
BillingAddresscountry	String	False		Country of billing address.
BillingAddressfax	String	False		Fax of billing address.
BillingAddressstate	String	False		State of billing address.
BillingAddresszip	Integer	False		Zip of billing address.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.

Build 24.0.9062