Re: [Emerald] rebatch behind the scenes .... ?

Alexander Blauvelt ( online@olg.com )
Wed, 9 Jun 1999 08:56:08 -0400 (EDT)

> > What exactly does emerald do database-wise when in the batch window i
> > click "re-batch" on an cc invoice that failed ? I'm working a script
> > and I need to know what this does so I can batch a group of cc invoices
> > again.
>
> It sets the corresponding entry's TransType to 7 in the ExternalTrans
> table. Emerald will change that to 8 after its created a new
> ExternalTrans
> entry for the invoice.

Hi Dale,

Thanks for the info, I needed that info for an script that will
automatically update credit cards that have expired. The idea is to bump
them up a year and try it again, and so forth. We used to do this by hand
when on the old system of typing CC's into the machine. This isn't as
clean as sending an invoice for each expired card, but imagine if you will
7000 CC customers, divide that by 12 months and the # of cards that expire
that year and suddenly you have a lot of invoices to send out every month
on expired credit cards. We'd like to see emerald have some way at
guessing what at an expired credit card's new expiration date would be.

Alex
Online Gateway