Flag a record

Given the following record set, how can I "Flag" the first payment record
(Typecode = 'P') so that it has satisfied the "Fire_Fee_Recvd"
In other words when a payment comes in, the billed fire fee amount is to be
applied first (first in,first out) and when subsequent payments come in, I d
o
not want to subtract the amount of the fire fee from the premium recvd
Policy BilledPrem BilledFireFee Pymt Typecode (PremRecvd)
(FFRecvd)
bp 001 2292 22.05 B
0 22.05
bp 001 500 P
477.95 22.05
bp 001 367.77 P
345.72 22.05
The last row needs to read Prem Recvd = 367.77 and FFRecvd = 0
My current logic is
PremRecvd = Pymt - FFRecvd
How can I flag that first pymt record as True for satisfying the fire fee so
that the next record will not subtract if from the pymt?
Thanks!Hi Patrice,
You table is little bit confusing for me ..if you want to flag a field (with
true or false)
you can try like this
-- create a new column 'flag filed'
-- write a trigger with your business requied logic[trigger can be insert or
update based on ur requirement] and to display true or false in newly
inserted Flag column based on the logic .
I dont know how far it is true ..iam also curious to know abt this.
hope this will help you
Kumar
So that ,it will check automatically when you insert or update new columns
"Patrice" wrote:

> Given the following record set, how can I "Flag" the first payment record
> (Typecode = 'P') so that it has satisfied the "Fire_Fee_Recvd"
> In other words when a payment comes in, the billed fire fee amount is to b
e
> applied first (first in,first out) and when subsequent payments come in, I
do
> not want to subtract the amount of the fire fee from the premium recvd
> Policy BilledPrem BilledFireFee Pymt Typecode (PremRecvd)
> (FFRecvd)
> bp 001 2292 22.05 B
> 0 22.05
> bp 001 500 P
> 477.95 22.05
> bp 001 367.77 P
> 345.72 22.05
> The last row needs to read Prem Recvd = 367.77 and FFRecvd = 0
> My current logic is
> PremRecvd = Pymt - FFRecvd
> How can I flag that first pymt record as True for satisfying the fire fee
so
> that the next record will not subtract if from the pymt?
>
> Thanks!