Re: [Emerald] Question on DB

Dale E. Reed Jr. ( (no email) )
Tue, 07 Dec 1999 11:21:52 -0800

Barry Kiesz wrote:
>
> We are setting up an online signup system and now at the payment process
> portion. When a user selects "Bank Transfer", what are the DB entries where
> the bank name, routing code, and account number stored.. We've combed the
> EmeraldDB and can't seem to find it..

There is a table called BankTrans:

CREATE TABLE BankTrans
(
CustomerID int CONSTRAINT pk_BankTrans PRIMARY KEY ,
AuthName varchar(32) NOT NULL ,
BankName varchar(16) NOT NULL ,
ABANumber varchar(16) NOT NULL ,
AccountNumber varchar(16) NOT NULL ,
Type varchar(16) NULL ,
LastModifyDate datetime NOT NULL DEFAULT (getdate()),
LastModifyUser varchar (15) NOT NULL DEFAULT SYSTEM_USER
)
GO

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart