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 本製品 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