Returns data for coupons associated to an order.

Select

To query from OrderCoupons table you need to specify OrderNo filter or Date and DateRangeSearchColumn filters. By default, if no filters are specified, the driver will return OrderCoupons 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 OrderCoupons WHERE OrderNo IN ('403593-201811261412-117905', '403595-20181156565-115656')

SELECT * FROM OrderCoupons WHERE OrderStatus = 'status' AND Date >= '2018-01-01'

Update

To update a specific order coupon you need to specify the OrderNo and OrderItemSubNo. If you specify only OrderNo in the WHERE clause, all the OrderCoupons records belonging to that Order will be updated. Only CouponCnt field can be udated.

UPDATE OrderCoupons SET CouponCnt = 1 WHERE OrderNo = '403593-201904191854-122833' AND OrderItemSubNo = 1

Delete

To delete a specific order coupon you need to specify the OrderNo and OrderItemSubNo. If you specify only OrderNo in the WHERE clause, all the OrderCoupons records belonging to that Order will be deleted.

DELETE FROM OrderCoupons WHERE OrderNo = '403593-201904191854-122833' AND OrderItemSubNo = 1

Columns

Name	Type	ReadOnly	Description
OrderNo [KEY]	String	False
OrderStatus	String	True
CouponCode	String	False
OrderItemSubNo [KEY]	Integer	True
ItemManageId	String	True
CouponName	String	True
CouponCnt	Integer	False
CouponCapitalKind	Integer	True
DiscountType	Integer	True
ExpiryDate	Date	True
CouponAmount	Decimal	True
Date	Date	True
DateRangeSearchColumn	String	True