Tableau Connector for Zoho Inventory

Build 24.0.9062

PurchaseOrders

Read, Insert, Update and Delete Purchase Orders.

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 PurchaseOrders WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the PurchaseorderNumber, VendorId 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 Purchaseorders (PurchaseorderNumber, VendorId, LineItems) VALUES ('PO-00006', 3249056000000085109, '[{\"item_id\":3249056000000113080,\"account_id\":3249056000000034003, \"name\": \"Laptop-white/15inch/dell\", \"description\": \"Just a sample description.\",  \"item_order\": 1, \"bcy_rate\": 122,  \"purchase_rate\": 122,  \"quantity\": 2,  \"quantity_received\": 2,  \"unit\": \"qty\", \"item_total\": 244, \"warehouse_id\": 3249056000000138013, \"salesorder_item_id\": 3249056000000113014}]')

Update

Update can be executed by specifying the PurchaseorderNumber, VendorId and LineItems in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Purchaseorders SET PurchaseorderNumber = '90', VendorId = '876', LineItems = [{\"item_id\":3249056000000113080,\"account_id\":3249056000000034003, \"name\": \"Laptop-white/15inch/dell\", \"description\": \"Just a sample description.\",  \"item_order\": 1, \"bcy_rate\": 122,  \"purchase_rate\": 122,  \"quantity\": 2,  \"quantity_received\": 2,  \"unit\": \"qty\", \"item_total\": 244, \"warehouse_id\": 3249056000000138013, \"salesorder_item_id\": 3249056000000113014}]' WHERE Id = '99800006'

Delete

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

DELETE FROM PurchaseOrders WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique ID generated by the server for the Purchase Order.

CreatedTime Datetime True

Time at which the Purchase Order was created.

CurrencyCode String True

Currency code.

CurrencyId Long True

Unique ID generated by the server for the currency.

Date Date False

Date of Purchase Order

DeliveryDate Date False

Date of delivery of the product.

IsBackorder Boolean False

This indicates whether it is a Back order or not.

IsDropShipment Boolean False

Default is FALSE, in case of drop shipment value must be TRUE.

LastModifiedTime Datetime True

Time at which the Purchase Order details were last modified.

PricePrecision Integer True

The precision level for the price decimal point in a Purchase Order.

PurchaseorderNumber String False

Purchase Order number.

Receives String True

Receives

ReferenceNumber String False

Reference number of purchase order.

Status String True

Status of Purchase Order.

Total Integer True

Total amount of the Purchase Order.

VendorId Long False

Unique ID generated by the server for the vendor.

VendorName String False

Name of the vendor.

LineItems String False

Line Items of the Purchase Order.

Bills String False

Bills of purchase order.

Purchasereceives String False

Purchase Receives of the purchase order

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.

DeliveryAddressAddress String False

Address of address.

DeliveryAddressCity String False

City of address.

DeliveryAddressCountry String False

Country of address.

DeliveryAddressFax String False

Fax

DeliveryAddressState String False

State of address.

DeliveryAddressZip Integer False

Zip code of address.

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