EnclosableOrders
Returns data for enclosable order.
Select
To query from EnclosableOrders table you need to specify OrderNo filter. 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 the = operator.
SELECT * FROM EnclosableOrders WHERE OrderNo = '403593-201811261412-117905'
Columns
Name | Type | Description |
OrderNo [KEY] | String | |
OrderStatus | String | |
OrderDateTime | Datetime | |
PaymentStatus | String | |
SendDate | Date | |
DlvKind | String | |
EnclosableFlg | Boolean | |
DlvDesiredDate | Date | |
CustomerLastName | String | |
CustomerFirstName | String | |
CustomerEmail | String | |
PaymentMethodName | String | |
CardNo | String | |
DlvAddrZip1 | String | |
DlvAddrZip2 | String | |
DlvAddrPref | String | |
DlvAddrAddress | String | |
DlvAddrLastName | String | |
DlvAddrFirstName | String | |
DlvAddrTel | String | |
EncloseKind | String | |
EncloseParentOrderNo | String | |
EncloseChildOrderLists | String |