PurchaseOrders

List, Insert, Update, delete purchase orders

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 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	True		Name of the vendor.
LineItems	String	False		Line Items of the Purchase Order.
Bills	String	True		Bills of purchase order.
Purchasereceives	String	True		Purchase Receives of the purchase order
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.
DeliveryAddressAddress	String	True		Address of address.
DeliveryAddressCity	String	True		City of address.
DeliveryAddressCountry	String	True		Country of address.
DeliveryAddressFax	String	True		Fax
DeliveryAddressState	String	True		State of address.
DeliveryAddressZip	Integer	True		Zip code of address.
Adjustment	Double	True		Adjustment amount.
ApproverId	Long	True		ID of the approver.
BillingAddressId	Long	True		ID of the billing address.
BranchId	Long	True		ID of the branch.
ContactPersons	Long	True		Contact persons.
CurrencySymbol	String	True		Currency symbol.
CustomFieldHash	String	True		Hash of custom fields.
Discount	String	True		Discount applied.
DiscountAccountId	Long	True		ID of the discount account.
LocationId	Long	True		ID of the location.
PaymentTerms	Integer	True		Payment terms in days.
Salesorders	String	True		Associated sales orders.
SubStatuses	String	True		Sub-statuses.
Tags	String	True		Tags.
TaxOverridePreference	String	True		Tax override preference.
Taxes	String	True		Taxes.
AdjustmentDescription	String	True		Adjustment description.
Advances	String	True		Advances.
AllowQuickReceive	Boolean	True		Allow quick receive.
ApproversList	String	True		Approvers list.
AttachmentName	String	True		Attachment name.
BranchName	String	True		Name of the branch.
CanMarkAsBill	Boolean	True		Whether it can be marked as bill.
CanMarkAsUnbill	Boolean	True		Whether it can be marked as unbill.
CanSendInMail	Boolean	True		Whether it can be sent in mail.
ComputationType	String	True		Computation type.
ContactCategory	String	True		Contact category.
ContactPersonsAssociated	String	True		Associated contact persons.
CreatedById	Long	True		ID of the creator.
DeliveryCustomerAddressId	Long	True		ID of the delivery customer address.
DiscountAccountName	String	True		Name of the discount account.
DiscountAmount	Double	True		Discount amount.
DiscountAppliedOnAmount	Double	True		Discount applied on amount.
DiscountPercent	Double	True		Discount percentage.
DiscountTotal	Double	True		Discount total.
DiscountType	String	True		Discount type.
HasQtyCancelled	Boolean	True		Whether quantity has been cancelled.
IsAdvTrackingInReceive	Boolean	True		Whether advance tracking in receive is enabled.
IsDiscountBeforeTax	Boolean	True		Whether discount is applied before tax.
IsEmailed	Boolean	True		Whether it has been emailed.
IsReceived	Boolean	True		Whether it has been received.
LocationName	String	True		Name of the location.
NonCatalogItemsCount	Integer	True		Count of non-catalog items.
Orientation	String	True		Orientation.
PageHeight	String	True		Page height.
PageWidth	String	True		Page width.
PaymentTermsLabel	String	True		Payment terms label.
SalesorderId	Long	True		ID of the sales order.
ShipViaId	Long	True		ID of the ship via method.
SubTotal	Double	True		Sub-total.
SubTotalInclusiveOfTax	Double	True		Sub-total inclusive of tax.
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.
TaxRounding	String	True		Tax rounding.
TaxTotal	Double	True		Tax total.
TdsCalculationType	String	True		TDS calculation type.
TemplateName	String	True		Name of the template.
TemplateType	String	True		Type of the template.
TotalQuantity	Double	True		Total quantity.