Power BI Connector for Zoho Inventory

Build 24.0.9062

ShipmentOrders

Read, Insert, Update and Delete Shipment Orders.

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 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')

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.

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