ShipmentOrders

Read, Insert, Update and Delete Shipment Orders.

Table Specific Information

Select

The driver 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 driver.

Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ShipmentOrders WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the ContactPersons,ShipmentNumber,DeliveryMethod and TrackingNumber 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 ShipmentOrders (ContactPersons,ShipmentNumber,DeliveryMethod,TrackingNumber) VALUES (3285934000000104004,'SH-00009','FedEx','TRK214124124')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE ShipmentOrders SET Name = 'test2' WHERE Id = '3285934000000136008'

Delete

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

DELETE FROM ShipmentOrders WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		Unique ID generated by the server for the shipment.
Carrier	String	True		Carrier used for shipment
ContactPersons	Long	False		contact persons.
CreatedTime	Datetime	True		Time at which the Shipment Details was created.
CurrencyCode	String	True		Currency code.
CurrencyId	Long	True		Unique ID generated by the server for the currency.
CurrencySymbol	String	True		The symbol for the selected currency.
CustomerId	Long	True		Unique ID generated by the for the customer.
CustomerName	String	False		Name of the customer
Date	String	False		Date on which package is prepared.
DeliveryDays	Integer	True		Number of days taken by the courier for delivering in package.
DeliveryGuarantee	Boolean	True		guarantee assured by the courier.
DeliveryMethod	String	False		Delivery method of the shipment.
DeliveryMethodId	Long	False		Delivery Id of the shipment.
DetailedStatus	String	False		Detailed shipment details received from the courier.
Discount	String	True		The percentage of Discount applied.
DiscountAmount	Integer	True		Discount to be applied on the Sales Order.
DiscountType	String	True		Type of discount.
EstimateId	Long	True		Estimate Id.
ExchangeRate	Integer	False		Exchange rate of the currency, with respect to the base currency.
IsDiscountBeforeTax	Boolean	True		Used to check whether the discount is applied before tax or after tax.
IsEmailed	Boolean	True		Checks whether the Package has been emailed to the customer or not.
LastModifiedTime	Datetime	True		Time at which the Shipment Details details were last modified.
LineItems	String	True		List of items in a package.
Notes	String	False		notes.
PricePrecision	Integer	True		The precision level for the price decimal point in a Shipment.
ReferenceNumber	String	False		Tracking number for the Shipment.
SalesorderId	Long	False		Unique ID generated by the server for the Sales Order.
SalesorderNumber	String	True		The Sales Order number.
Service	String	True		Type of service selected for shipment.
ShipmentNumber	String	False		Shipment number of the package.
ShippingCharge	Integer	False		Shipping charges that are applied to the Shipment.
Status	String	True		Status of the Shipment Order.
StatusMessage	String	True		Status message of the shipment.
SubTotal	Integer	True		Sub total of the Sales Order.
TaxTotal	Integer	True		Tax total of the Sales Order.
Taxes	String	True		Number of taxes applied on sales order..
TemplateId	Long	False		Unique ID generated by the server for the Template.
TemplateName	String	True		Name of the template used for the Shipment.
TemplateType	String	True		Type of the template.
Total	Integer	True		Total amount of the Sales Order.
TrackingNumber	String	False		Tracking number of shipment.
BillingAddressAddress	String	False		Name of the street of the customer billing address.
BillingAddressCity	String	False		Name of the city of the customer billing address.
BillingAddressCountry	String	False		Name of the country of the customer billing address.
BillingAddressFax	String	False		Fax number of the customer billing address.
BillingAddressState	String	False		Name of the state of the customer billing address.
BillingAddressZip	Integer	False		Zip code of the customer billing address.
ShippingAddressAddress	String	False		Name of the street of the customer billing address.
ShippingAddressCity	String	False		Name of the city of the customer billing address
ShippingAddressState	String	False		Name of the state of the customer billing address.
ShippingAddressZip	String	False		Zip code of the customer billing address.
ShippingAddressCountry	String	False		Name of the country of the customer billing address.
ShippingAddressFax	String	False		Fax number of the customer billing address.