PD.BALANCES - What is rule of REPAY fields?
- Otono
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 25
- Thank you received: 1
14 years 6 months ago - 14 years 6 months ago #7605
by Otono
PD.BALANCES - What is rule of REPAY fields? was created by Otono
Hi,
I tested with some data and have this following example:
Customer paid IN PR PE PS by few times.
AMT.TYPE..........IN PR PE PS ;*(this order is not fixed)
REPAY.DATE.....DIN1 DIN2 DPR1 DPR2 DPE1 DPE2 DPE3 DPS1 DPS2 DPS3
REPAY.AMT..........AIN1 AIN2 APR1 APR2 APE1 _____ APE3 _____ APS2 APS3
ADJ.AMT........_________________________ APE2 _____ APS1
INT.REPAY.DATE... DPE3
INT.REPAY.AMT... APE3
INT2.REPAY.DATE... DPS2 DPS3
INT2.REPAY.AMT... APS2 APS3
*DIN1: date of paying IN is 'date 1'
*APE1: amount of paying PE on 'date 1'
I need get result: which date the customer pay for what (in/pr/pe/ps) and how much.
It is continuous string, so how to know APE3 doesn't not belong to DPS1 if read from right of REPAY.AMT
Please anyone can help me what is exactly rule of ADJ.AMT, REPAY.DATE and REPAY.AMT???
If you have any clue please share!
Thanks
I tested with some data and have this following example:
Customer paid IN PR PE PS by few times.
AMT.TYPE..........IN PR PE PS ;*(this order is not fixed)
REPAY.DATE.....DIN1 DIN2 DPR1 DPR2 DPE1 DPE2 DPE3 DPS1 DPS2 DPS3
REPAY.AMT..........AIN1 AIN2 APR1 APR2 APE1 _____ APE3 _____ APS2 APS3
ADJ.AMT........_________________________ APE2 _____ APS1
INT.REPAY.DATE... DPE3
INT.REPAY.AMT... APE3
INT2.REPAY.DATE... DPS2 DPS3
INT2.REPAY.AMT... APS2 APS3
*DIN1: date of paying IN is 'date 1'
*APE1: amount of paying PE on 'date 1'
I need get result: which date the customer pay for what (in/pr/pe/ps) and how much.
It is continuous string, so how to know APE3 doesn't not belong to DPS1 if read from right of REPAY.AMT
Please anyone can help me what is exactly rule of ADJ.AMT, REPAY.DATE and REPAY.AMT???
If you have any clue please share!
Thanks
Last edit: 14 years 6 months ago by Otono.
Please Log in or Create an account to join the conversation.
- Otono
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 25
- Thank you received: 1
14 years 6 months ago - 14 years 6 months ago #7636
by Otono
Replied by Otono on topic Re: PD.BALANCES - What is rule of REPAY fields?
After long time for complex assumption, I have found out the very simple rule of REPAY.
Values of IN OR PR... are spread by VM
Sub values of IN (example) are spread by SM
(yes and this basic rule is 'top' public)
The above example will be like this:
REPAY.DATE... DIN1 SM DIN2 VM DPR2 SM DPR2...
REPAY.AMOUT... ... APE1 SM 'NULL' SM APE3 SM 'NULL' VM APS2...
ADJ.AMT... NULL VM NULL VM NULL SM APE2 SM NULL VM APS1 SM NULL SM NULL
This rule may is too basic but I'm newbie so I did so need this answer 1 week ago!
Now I know who pay how many times in detail for each schedule item. And if you find out I'm wrong (possible) or have another better way to do please share here. I'm learning.
Values of IN OR PR... are spread by VM
Sub values of IN (example) are spread by SM
(yes and this basic rule is 'top' public)
The above example will be like this:
REPAY.DATE... DIN1 SM DIN2 VM DPR2 SM DPR2...
REPAY.AMOUT... ... APE1 SM 'NULL' SM APE3 SM 'NULL' VM APS2...
ADJ.AMT... NULL VM NULL VM NULL SM APE2 SM NULL VM APS1 SM NULL SM NULL
This rule may is too basic but I'm newbie so I did so need this answer 1 week ago!
Now I know who pay how many times in detail for each schedule item. And if you find out I'm wrong (possible) or have another better way to do please share here. I'm learning.
Last edit: 14 years 6 months ago by Otono.
Please Log in or Create an account to join the conversation.
Time to create page: 0.031 seconds