Returns information related to the Customer which placed the order.

Select

To query from OrderCustomers table you need to specify OrderNo filter or Date and DateRangeSearchColumn filters. By default, if no filters are specified, the driver will return OrderCustomer 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, CustomerEmail and DateRangeSearchColumn columns support the = operator.
• Date column supports the >=,<= and = operators.

For example, the following query is processed server side:

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

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

SELECT * FROM OrderCustomers WHERE CustomerEmail = 'test@mail.com'

Update

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

UPDATE OrderCustomers SET CustomerZip1 = 655, CustomerZip2 = 1001, CustomerAddress = 'updating address', CustomerFirstName = 'FirstName', CustomerLastName = 'LastName' WHERE OrderNo = '403593-201903261426-121537'

Columns

Name	Type	ReadOnly	Description
OrderNo [KEY]	String	True
OrderStatus	String	True
CustomerZip1	String	False
CustomerZip2	String	False
CustomerPref	String	False
CustomerAddress	String	False
CustomerLastName	String	False
CustomerFirstName	String	False
CustomerLastNameKana	String	False
CustomerFirstNameKana	String	False
CustomerTel	String	False
CustomerEmail	String	False
CustomerEmailKind	String	True
Date	Date	True
DateRangeSearchColumn	String	True	Period search target column which narrows the order list to the specified range by Date column