Return data for Order delivey information

Select

To query from OrderDlvs table you need to specify OrderNo filter or Date and DateRangeSearchColumn filters. By default, if no filters are specified, the driver will return order delivery records for Orders with OrderDate within the last 730 days (the maximum range that it returns records for). The date range you specify can filter based on OrderDate, ShipmentDate or PaymentDate based on the value set for DateRangeSearchColumn filter (respectively 1,2,3). The 本製品 will use the Ponparemall API to process WHERE clause conditions built for this field. The rest of the filters is executed client side.

• OrderNo column supports = and IN operators.
• OrderStatus and DateRangeSearchColumn columns support the = operator.
• Date column supports the >=,<= and = operators.

For example, the following query is processed server side:

SELECT * FROM OrderDlvs WHERE OrderNo IN ('403593-201811261412-117905', '403595-20181156565-115656')

SELECT * FROM OrderDlvs WHERE OrderStatus = 'status' AND Date = '2018-01-01' AND DateRangeSearchColumn = 2

Update

To update order delivery information for a specific order you need to specify the OrderNo. All the fields that are not readonly can be updated.

UPDATE OrderDlvs SET DlvAddrZip1 = 123, DlvAddrZip2 = 0003, DlvAddrAddress = 'testing address', DlvAddrFirstName = 'Ana', DlvAddrLastName = 'Smith' WHERE OrderNo = '403593-201903261426-121537'

Columns

Name	Type	ReadOnly	Description
OrderNo [KEY]	String	True
DlvMethodId	String	False
DlvMethodName	String	True
DlvAddrZip1	String	False
DlvAddrZip2	String	False
DlvAddrPref	String	False
DlvAddrAddress	String	False
DlvAddrLastName	String	False
DlvAddrFirstName	String	False
DlvAddrLastNameKana	String	False
DlvAddrFirstNameKana	String	False
DlvAddrTel	String	False
SlipNo	String	False
OrderStatus	String	True
Date	Date	True
DateRangeSearchColumn	String	True