Excel Add-In for Zoho Inventory

Build 26.0.9770

PurchaseReceives

List, Insert, Update, delete purchase receives

Table Specific Information

Select

The add-in 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 add-in.

  • 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 True

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 True

Purchase Order number.

ReceiveNumber String False

Number of the Purchase Receive.

VendorId Long True

Unique ID generated by the server for the vendor.

VendorName String True

Name of the vendor.

LineItems String False

Number of line items for purchase receive.

ShippingAddressAddress String True

Address of shipping address.

ShippingAddressCity String True

City of shipping address.

ShippingAddressCountry String True

Country of shipping address.

ShippingAddressFax String True

Fax of shipping address.

ShippingAddressState String True

State of shipping address.

ShippingAddressZip Integer True

Zip of shipping address.

BillingAddressaddress String True

Address of billing address.

BillingAddresscity String True

City of billing address.

BillingAddresscountry String True

Country of billing address.

BillingAddressfax String True

Fax of billing address.

BillingAddressstate String True

State of billing address.

BillingAddresszip Integer True

Zip of billing address.

ApprovalReason String True

Reason for approval.

ApproverId Long True

ID of the approver.

BillingAddressAttention String True

Billing address attention.

Bills String True

Associated bills.

BranchId Long True

ID of the branch.

Carrier String True

Carrier name.

Comments String True

Comments.

ContactCategory String True

Contact category.

CustomFieldHash String True

Hash of custom fields.

CustomFields String False

Custom fields.

Documents String True

Documents.

ExpectedDeliveryDate Date True

Expected delivery date.

IsBilled Boolean True

Whether it is billed.

LocationId Long True

ID of the location.

LocationName String True

Name of the location.

TrackingLink String True

Tracking link.

TrackingNumber String True

Tracking number.

ApproversList String True

Approvers list.

BillingAddressPhone String True

Billing address phone.

BillingAddressStreet2 String True

Billing address street 2.

BranchName String True

Name of the branch.

CreatedById Long True

ID of the creator.

CreatedDate Date True

Created date.

CurrencyCode String True

Currency code.

CurrencyId Long True

ID of the currency.

CurrencySymbol String True

Currency symbol.

DeliveryMethod String True

Delivery method.

DeliveryMethodId Long True

ID of the delivery method.

IsInclusiveTax Boolean True

Whether tax is inclusive.

IsPoMarkedAsReceived Boolean True

Whether PO is marked as received.

IsTrackingEnabled Boolean True

Whether tracking is enabled.

IsTrackingSupported Boolean True

Whether tracking is supported.

LastModifiedById Long True

ID of the last modifier.

PaymentTerms Integer True

Payment terms in days.

PaymentTermsLabel String True

Payment terms label.

ReceiveId Long True

ID of the receive.

ShipmentDeliveredDate Date True

Shipment delivered date.

ShippingAddressAttention String True

Shipping address attention.

ShippingAddressPhone String True

Shipping address phone.

ShippingAddressStreet2 String True

Shipping address street 2.

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.

TotalQuantityReceived Double True

Total quantity received.

TrackingStatuses String True

Tracking statuses.

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