[freeside] Freeside draft checks scheme changes
ivan
ivan at 420.am
Tue Nov 6 08:36:38 PST 2001
Probably should move this to the -devel list.
Use the `payinfo' field for the routing number and account number, or
convince me why that's not appropriate.
I could maybe see adding the `checknum' field. Tell me more about how
it's supposed to work; does the customer give you a check number in some
starting range and you incremement it by one each time or what?
When you change the schema please patch the following files:
bin/fs-setup
httemplate/docs/upgrade8.html
README.1.4.0pre4-5
httemplate/docs/schema.html
as well as the FS/FS/tablename.pm file for the table you've changed.
On Tue, Nov 06, 2001 at 10:10:55AM -0600, Jeff Foster wrote:
>
> I've started work on support for draft checks againist
> user's bank accounts. I want to run this past you before
> I get too far into it. I would like to alter cust_main
> to add these columns -
>
> alter table cust_main add column routingnum varchar(12);
> alter table cust_main add column accountnum varchar(20);
> alter table cust_main add column checknum varchar(8);
>
> Where:
> routingnum - bank routing number
> accountnum - customer's account number
> checknum - next check number to use
>
> I could have re-used some of the credit card and invoice
> fields but didn't think that it was the best way to go.
>
> Comments/Questions please.
>
> Jeff Foster
> jfoste at woodward.com
>
> ***
> The information in this e-mail is confidential and intended solely for the
> individual or entity to whom it is addressed. If you have received this
> e-mail in error please notify the sender by return e-mail, delete this
> e-mail, and refrain from any disclosure or action based on the information.
> ****
--
_ivan
More information about the freeside-users
mailing list