The query should be executed only after day end of all modules or before day begin of all modules only.
- Change the date in query as the execution date.
- i.e replace 270115 with execution date.00
Click Here to download
|
RECEIPTS
|
PAYMENTS
|
||
|
HEAD
|
HEAD FOR MCCAMISH
|
HEAD
|
HEAD FOR MCCAMISH
|
|
PLI FIRST YEAR PREM
|
MCMPLI_FYPrem
|
PLI MATURITY PAYMENT
|
MCMPLI_Mtr_Pmt
|
|
PLI RENEWAL PREM
|
MCMPLI_RenwPrem
|
PLI SURRENDER PAYMENT
|
MCMPLI_Sur_Pmt
|
|
PLI OT PREM
|
MCMPLI_OT_Prem
|
PLI INTERIM (SURVIVAL) / AEA Payment
|
MCMPLI_INTM
|
|
PLI LOAN PRINCIPAL
|
MCMPLI_LoanPrin
|
PLI REBATE
|
MCMPLI_Rebate
|
|
PLI LOAN INTEREST
|
MCMPLI_LoanIntt
|
PLI LOAN payment
|
MCMPLI_Loan_Pmt
|
|
|
|
PLI MISC PAYMENT
|
MCMPLI_Misc_Pmt
|
|
|
|
PLI DEATH CLAIM PAYMENT
|
MCMPLI_Clam_Pmt
|
|
RECEIPTS
|
PAYMENTS
|
||
|
HEAD
|
HEAD FOR MCCAMISH
|
HEAD
|
HEAD FOR MCCAMISH
|
|
RPLI FIRST YEAR PREM
|
RMCMPLI_FYPrem
|
RPLI MATURITY
|
RMCMPLI_MTR_PMT
|
|
RPLI RENEWAL PREM
|
RMCMPLI_RenwPre
|
RPLI SURRENDER
|
RMCMPLI_SUR_PMT
|
|
RPLI OT PREMIUM
|
RMCMPLI_OT_Prem
|
RPLI INTERIM SURVIVAL / AEA Payment
|
RMCMPLI_INTM
|
|
RPLI LOAN PREM
|
RMCMPLI_LoanPrm
|
RPLI REBATE
|
RMCMPLI_REBATE
|
|
RPLI LOAN INTT
|
RMCMPLI_LoanIntt
|
RPLI LOAN Payment
|
RMCMPLI_LOAN
|
|
|
|
RPLI MISC PAYMENT
|
RMCMPLI_MIS_PMT
|
|
|
|
RPLI DEATH CLAIM PAYMENT
|
RMCMPLI_CLAIM
|