Payments
Returns detailed payment information related to orders
Select
To query from Payments table you need to specify Date, PeriodSearchKind and PaymentStatus filters. By default the driver will return payments of any status for orders that have OrderDate within the last 730 days (tha maximum range that it returns values for). You can use the CardBrandList, CardPymntMethodList and PaymentStatus filters with = and IN operators;CardSignature, OrderNo with = operator; Date field supports >.< and = operators. The connector will use the Ponparemall API to process WHERE clause conditions built for these fields. The rest of the filter is executed client side.
- CardBrandList, CardPymntMethodList and PaymentStatus columns support = and IN operator.
- OrderNo column supports the = operator.
- Date column supports the >=,<= and = operators.
SELECT * FROM Payments WHERE PaymentStatus IN ('status1', 'status2')
SELECT * FROM Payments WHERE Date >= '2018/11/11' AND Date <= '2019/06/03' AND periodSearchKind = '1' AND PaymentStatus = 'status'
SELECT * FROM Payments WHERE OrderNo = '403593-201811261412-117905'
SELECT * FROM Payments WHERE CardBrand IN (1, 2)
Columns
Name | Type | Description |
AuthBillDate | Date | |
CardBrand | String | |
CardNo | String | |
CardPaymentMethod | String | |
CardSignature | String | |
ErrCode | String | |
ErrMessage | String | |
ExecPymntDateTime | Datetime | |
MerchantId | String | |
OrderDateTime | Datetime | |
OrderStatus | String | |
SendDate | Date | |
ServiceId | String | |
TotalPaymentAmount | Decimal | |
TrackingId | String | |
TransactionId | String | |
CardBrandList | String | 1:VISA.2:MASTER,3:AMEX,4:JCB,5:Diners
使用できる値は次のとおりです。1, 2, 3, 4, 5 |
CardPymntMethodList | String |
使用できる値は次のとおりです。1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 |
OrderNo [KEY] | String | |
PeriodSearchKind | String | Specifies which date the range is applied for. Possible values: 1:Order date, 2:Date of shipment, 3: Authorization approval date / billing date.
使用できる値は次のとおりです。1, 2, 3 |
PaymentStatus | String | |
Date | Date |