OrderPayments
Returns payment information for orders.
Select
To query from OrderPayments 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, CardBrand, CardPaymentMethod and CCPaymentStatus columns support = and IN operators.
- OrderStatus, PaymentMethodId, PaymentMethodName, CardSignature and DateRangeSearchColumn columns support the = operator.
- Date column supports the >=,<= and = operators.
SELECT * FROM OrderPayments WHERE OrderNo IN ('403593-201811261412-117905', '403595-20181156565-115656')
SELECT * FROM OrderPayments WHERE OrderStatus = 'status' AND Date = '2018-01-01' AND DateRangeSearchColumn = 2
SELECT * FROM OrderPayments WHERE CardSignature = 'TARO PONPARE'
SELECT * FROM OrderPayments WHERE CardPaymentMethod IN (1, 2, 3, 4)
Update
To update an OrderPayments item the OrderNo. Only PymntMethodId can be updated.
UPDATE OrderPayments SET PymntMethodId = 2 WHERE OrderNo = '403593-201904051859-122065'
Columns
Name | Type | ReadOnly | Description |
OrderNo [KEY] | String | True | |
OrderStatus | String | True | |
PymntMethodId | String | False | |
PymntMethodName | String | True | |
CardBrand | String | True | |
CardNo | String | True | |
CardSignature | String | True | |
CardExpire | String | True | |
CardPymntMethod | String | True | |
CCPaymentStatus | String | True | |
Date | Date | True | |
DateRangeSearchColumn | String | True |