Power BI Connector for Zoho Inventory

Build 24.0.9062

PurchaseReceives

Read, Insert and Delete Purchase Receives.

Table Specific Information

Select

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

  • 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