Returns wrapping information for Orders.

Select

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

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

Insert

To insert order wrapping information for a specific order you need to specify OrderNo, WrappingKind, WrappingName, WrappingPrice, WrappingDelFlg and WrappingTaxKind of the wrapping option you want to insert (wrapping 1, wrapping 2 or both).

INSERT INTO OrderWrappings (WrappingKind, WrappingName, WrappingPrice, WrappingDelFlg, WrappingTaxKind, Orderno) VALUES (1, 'Ardit', 20, false, 1, '403593-201904191853-122817')

INSERT INTO OrderWrappings (WrappingKind2, WrappingName2, WrappingPrice2, WrappingDelFlg2, WrappingTaxKind2, Orderno) VALUES (1, 'Ardit', 20, false, 1, '403593-201904191853-122817')

Update

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

UPDATE OrderWrappings SET WrappingName2 = 'Package for customer 2' WHERE OrderNo = '403593-201903261426-121537'

Columns

Name	Type	ReadOnly	Description
OrderNo [KEY]	String	True
WrappingKind	String	False
WrappingName	String	False
WrappingPrice	Decimal	False
WrappingTaxKind	String	False
WrappingDelFlg	Boolean	False
WrappingKind2	String	False
WrappingName2	String	False
WrappingPrice2	Decimal	False
WrappingTaxKind2	String	False
WrappingDelFlg2	Boolean	False
OrderStatus	String	False
Date	Date	True
DateRangeSearchColumn	String	True