-- =============================================
-- Table: TransactionTypes
-- =============================================
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'TransactionTypes'
AND type = 'U')
DROP TABLE TransactionTypes
GO
create table TransactionTypes (
TransactionTypeID int Primary Key IDENTITY(1, 1) NOT NULL,
TransactionType varchar(50) NOT NULL,
Notes text)
GO
INSERT INTO TransactionTypes (TransactionType, Notes)
VALUES('Deposit', 'Used if a customer is depositing money, regardless of the type of account');
INSERT INTO TransactionTypes (TransactionType, Notes)
VALUES('Withdrawal', 'Specifies that a customer is receiving money. This also applies when a check is cashed from the customer account');
INSERT INTO TransactionTypes (TransactionType, Notes)
VALUES('Fund Transfer', 'This applies to an operation that consists of transferring money from one account to another');
INSERT INTO TransactionTypes (TransactionType, Notes)
VALUES('Money Order', 'This is selected if a person is purchasing a money order from this bank');
INSERT INTO TransactionTypes (TransactionType, Notes)
VALUES('Service Charge', 'There are various types of service charges. This category applies to all of them, regardless of the reason, as long as the Bank Management decides to withdraw money from the customer''s account as a fee or a penalty');
GO