PurchaseOrderDetails
To list, add, update and delete details of a purchase order.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: PurchaseorderId is required in order to query PurchaseOrderDetails.
- PurchaseorderId supports the '=' comparison.
SELECT * FROM PurchaseOrderDetails WHERE PurchaseorderId = '1894553000000087078'
Insert
Insert can be executed by specifying Vendorid,lineitems columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
Insert INTO PurchaseorderLineItems#TEMP(Name,itemid,rate,quantity,accountid) values('Cloth-Jeans','3285934000000104097','1700','1','3285934000000034001')
INSERT INTO PurchaseorderDetails (Vendorid,lineitems) VALUES ('3285934000000104023',PurchaseorderLineItems#Temp)
Update
Update can be executed by specifying the PurchaseorderId in the WHERE Clause. The columns that are not read-only can be Updated.
For example:
Insert INTO PurchaseorderLineItems#TEMP(Name,itemid,rate,quantity,accountid) values('Cloth-Jeans','3285934000000104097','1700','1','3285934000000034001')
UPDATE PurchaseOrderDetails SET Vendorid = '3285934000000104002',lineitems='PurchaseorderLineItems#Temp' WHERE PurchaseorderId = '3285934000000264005'
Delete
Delete can be executed by specifying the PurchaseorderId in the WHERE Clause
For example:
DELETE FROM PurchaseOrderDetails WHERE PurchaseOrderId = '3350895000000089001'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Description |
PurchaseorderId [KEY] | String | True |
PurchaseOrders.PurchaseorderId |
ID of a purchase order. | |
PurchaseorderNumber | String | False |
Number of purchase order. | ||
ReferenceNumber | String | False |
Reference number of purchase order. | ||
Adjustment | Decimal | True |
Adjustments made to the purchase order. | ||
AdjustmentDescription | String | True |
Description of adjustments made to the purchase order. | ||
ApproverId | String | True |
Users.UserId |
ID of an approver. | |
AttachmentName | String | True |
Name of the attachment. | ||
Attention | String | False |
Name of a person in purchase order. | ||
BilledStatus | String | True |
Status of bill. | ||
BillingAddressId | Long | False |
ID of the Billing Address. | ||
BillingAddress | String | True |
Billing address of a purchase order. | ||
BillingAddressAttention | String | True |
Name of the person of bill order. | ||
BillingAddressCity | String | True |
City of billing address. | ||
BillingAddressCountry | String | True |
Country of billing address. | ||
BillingAddressFax | String | True |
Fax number of billing address. | ||
BillingAddressPhone | String | True |
Phone number of billing address. | ||
BillingAddressState | String | True |
State of billing address. | ||
BillingAddressStreet2 | String | True |
Street two of billing address. | ||
BillingAddressZip | String | True |
Zip code of billing address. | ||
CanMarkAsBill | Boolean | True |
Check if purchase order can be mark as bill. | ||
CanMarkAsUnbill | Boolean | True |
Check if purhcase order can be mark as unbill. | ||
CanSendInMail | Boolean | True |
Check if purchase order can be sent in mail. | ||
ClientViewedTime | Datetime | True |
Last time when client viewed the purchase order. | ||
ColorCode | String | True |
Color code. | ||
ContactCategory | String | True |
Category of contacts. | ||
CreatedById | String | True |
Users.UserId |
Contact ID who have created this purchase order. | |
CreatedTime | Datetime | True |
Time at which the purchase order was created. | ||
CurrencyCode | String | True |
Currency code of the customer's currency. | ||
CurrencyId | String | True |
Currencies.CurrencyId |
Currency ID of the customer's currency. | |
CurrencySymbol | String | True |
Currency symbol of the customer's currency. | ||
CurrentSubStatus | String | True |
Current sub status of a purchase order. | ||
CurrentSubStatusId | String | True |
Current sub status ID of a purchase order. | ||
ContactPersons | String | False |
Contact persons of a contact. | ||
CustomFields | String | True |
Custom Fields defined for Journal | ||
Date | Date | False |
Purchase order date. | ||
Documents | String | False |
List of files to be attached to a particular transaction. | ||
DeliveryAddress | String | True |
Delivery address. | ||
DeliveryAddress1 | String | True |
Delivery address one. | ||
DeliveryAddress2 | String | True |
Delivery address two. | ||
DeliveryAddressCity | String | True |
City of delivery address. | ||
DeliveryAddressCountry | String | True |
Country of delivery address. | ||
DeliveryAddressOrganizationAddressId | String | True |
Id or organization address of delivery address. | ||
DeliveryAddressPhone | String | True |
Phone number of delivery address. | ||
DeliveryAddressState | String | True |
State of delivery address. | ||
DeliveryAddressZip | String | True |
Zip code of delivery address. | ||
DeliveryCustomerId | String | False |
Contacts.ContactId |
ID of a customer of delivery address. | |
DueDate | Date | False |
Delivery date of purchase order.. | ||
DeliveryDate | Date | False |
Date of delivery. | ||
DeliveryOrgAddressId | String | False |
Delivery address ID of an organization. | ||
Discount | String | False |
Discount given to specific item in purchase order. | ||
DiscountAccountId | String | False |
BankAccounts.AccountId |
Account ID of discount. | |
DiscountAmount | Decimal | True |
Amount of discount. | ||
DiscountAppliedOnAmount | Double | True |
Discount applied on amount. | ||
ExchangeRate | Decimal | False |
Exchange rate of the currency. | ||
ExpectedDeliveryDate | Date | True |
Expected delivery date of purchased product. | ||
HasQtyCancelled | Boolean | True |
Check if the quantity of a purchase order has been cancelled. | ||
IsDiscountBeforeTax | Boolean | False |
Check if purchase order applied discount before tax. | ||
IsDropShipment | Boolean | True |
Check if purchase order have drop shipment. | ||
IsEmailed | Boolean | True |
Check if purchase order is emailed or not. | ||
IsInclusiveTax | Boolean | False |
Check if the purchase order is inclusive tax. | ||
IsPreGst | Boolean | True |
Check if purchase order includes pre GST. | ||
IsViewedByClient | Boolean | True |
Check if purchase order is viewed by client. | ||
IsUpdateCustomer | Boolean | False |
Check if customer should be updated. | ||
LastModifiedTime | Datetime | True |
The time of last modification of the purchase order. | ||
Notes | String | False |
Notes for this purchase order. | ||
OrderStatus | String | True |
Status of order. | ||
Orientation | String | True |
Orientation of the page. | ||
PageHeight | String | True |
Height of the page. | ||
PageWidth | String | True |
Width of the page. | ||
PricePrecision | Integer | True |
The precision for the price | ||
PricebookId | String | False |
ID of the pricebook. | ||
SalesorderId | String | False |
SalesOrders.SalesorderId |
ID of the Sales Order. | |
ShipVia | String | False |
Mode of shipping the item. | ||
ShipViaId | String | True |
ID of mode through which shipping was done of items. | ||
Status | String | True |
Status of the purchase order | ||
SubTotal | Decimal | True |
Sub total of Purhcase order. | ||
SubTotalInclusiveOfTax | Decimal | True |
Subtotal amount which are inclusive of tax. | ||
SubmittedBy | String | True |
Detail of the user who has submitted the purchase order. | ||
SubmittedDate | Date | True |
Date of the submission. | ||
SubmitterId | String | True |
Users.UserId |
ID of the submitter. | |
TaxTotal | Decimal | True |
Total amount of tax. | ||
TemplateId | String | False |
ID of the template. | ||
TemplateName | String | True |
Name of the template | ||
TemplateType | String | True |
Type of template. | ||
Terms | String | False |
Terms and Conditions apply of a purchase order. | ||
Total | Decimal | True |
Total of purchase orders. | ||
VendorId | String | False |
ID of the vendor the purchase order has been made. | ||
VendorName | String | True |
Name of the vendor the purchase order has been made. | ||
GstTreatment | String | False |
Choose whether the vendor credit is GST registered/unregistered/consumer/overseas. | ||
VatTreatment | String | False |
VAT treatment for the vendor credit. | ||
TaxTreatment | String | False |
VAT treatment for the Vendor Credit. | ||
GstNo | String | False |
GST number. | ||
SourceOfSupply | String | False |
Source of supply. | ||
PlaceOfSupply | String | False |
The place of supply is where a transaction is considered to have occurred for VAT purposes. | ||
DestinationOfSupply | String | False |
Place where the goods/services are supplied to. | ||
LineItems | String | False |
Line items of an estimate. |