3 queries found for "Payment Event"
Get all from Payment Event
select *
from CI_PAY_EVENT
uploaded by Nuno Rodrigues
Get specific Payment Event
select *
from CI_PAY_EVENT
where
PAY_EVENT_ID = 'XXXX'
uploaded by Nuno Rodrigues
Retrieve Historical Payments for Account
SELECT
PEVT.PAY_DT,
SUM(PAY.PAY_AMT) as PAY_AMT,
'P' AS TYPE
FROM
CI_PAY PAY,
CI_PAY_EVENT PEVT
WHERE
PAY.ACCT_ID = 'INSERT_ACCOUNT_ID'
AND PAY.PAY_STATUS_FLG = '50'
AND PEVT.PAY_EVENT_ID = PAY.PAY_EVENT_ID
AND PEVT.PAY_DT > 'INSERT_INITIAL_SEARCH_DATE'
AND PEVT.PAY_DT <= 'INSERT_FINAL_SEARCH_DATE'
GROUP BY PEVT.PAY_DT
uploaded by Nuno Rodrigues