Flag a record

10 Nov 2005 9:02 PM

Patrice

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 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!

10 Nov 2005 9:32 PM

Kumar

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

Show quote

"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 be
> 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!