Freeside draft checks scheme changes

Jeff Foster jfoste at
Tue Nov 6 08:13:51 PST 2001

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);

	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

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.

More information about the freeside-users mailing list