Useful DB2 queries agaiinst the Sterling Order Management database

Just some useful DB2 SQL queries done directly against the Sterling Order Management database:

List of orders in a particular payment state (AUTHORIZED, INVOICED, PAID):

select ORDER_NO,ORDER_DATE from YFS_ORDER_HEADER where PAYMENT_STATUS='INVOICED'

List of orders and their payment status made after a certain date:

select T1.ORDER_NO,T2.PAYMENT_TYPE,T1.ORDER_DATE,T1.PAYMENT_STATUS from YFS_ORDER_HEADER T1,YFS_PAYMENT T2 where T1.ORDER_DATE > '2015-05-28' and T1.ORDER_HEADER_KEY=T2.ORDER_HEADER_KEY order by T1.ORDER_DATE

List of payment transactions for an order if you know the order number:

select * from YFS_CHARGE_TRANSACTION where ORDER_HEADER_KEY in (select ORDER_HEADER_KEY from YFS_ORDER_HEADER where ORDER_NO='WC_999999') order by EXECUTION_DATE