Trigger using mysql

[David Walsh]

Hi, Im having difficulty writing a trigger in mysql. I have listed the trigger details and My code. Could you please help me out?

"1.Check Approving User Trigger
This trigger fires before updating the approving user number ApprUserNo in the ExpenseReport table. The trigger body compares the organization number of the approving user to the organization number of the submitted user. The organization number of the approving user must be the same as the organization number of the submitting user or the organization number of the parent organization of the submitting user. If the organization number of the approving user does not match either, raise an application error"



SHOW DATABASES;

CREATE DATABASE BEEP;

USE BEEP;


DROP TABLE ExpenseItem;
DROP TABLE ExpenseReport;
DROP TABLE BudgetItem;
DROP TABLE Asset;
DROP TABLE ExpCat;
DROP TABLE Users;
DROP TABLE OrgUnit;


CREATE TABLE OrgUnit
(
OrgNo INTEGER(9) UNSIGNED NOT NULL AUTO_INCREMENT,
OrgName VARCHAR(50) NOT NULL,
OrgParentNo INTEGER(9) NULL,
CONSTRAINT OrgUnit_PK1 PRIMARY KEY(OrgNo)
) Engine = InnoDB;



CREATE TABLE Users
(
UserNo INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
UserFirstName VARCHAR(50) NOT NULL,
UserLastName VARCHAR(50) NOT NULL,
UserPhone VARCHAR(20) NULL,
UserEmail VARCHAR(50) NOT NULL,
UserOrgNo INTEGER(10) UNSIGNED NOT NULL,
CONSTRAINT Users_CK1 CHECK(UserEmail LIKE '%@%'),
CONSTRAINT Users_PK1 PRIMARY KEY(UserNo),
CONSTRAINT Users_AK1 UNIQUE(UserEmail),
CONSTRAINT Users_FK1 FOREIGN KEY(UserOrgNo) REFERENCES OrgUnit(OrgNo)

ON DELETE NO ACTION
ON UPDATE NO ACTION

) Engine = InnoDB;


CREATE TABLE ExpCat
(
ECNo INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
ECName VARCHAR(255) NOT NULL,
ECLimit DECIMAL(10,2) NOT NULL DEFAULT 0,
CONSTRAINT ExpCat_PK1 PRIMARY KEY(ECNo)
) Engine = InnoDB;



CREATE TABLE Asset
(
AssetNo INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
AssetDesc VARCHAR(255) NOT NULL,
CONSTRAINT Asset_PK1 PRIMARY KEY(AssetNo)
) Engine = InnoDB;



CREATE TABLE BudgetItem
(
BINo INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
BIYear INT(4) NOT NULL DEFAULT 2005,
BIAmt DECIMAL(10,2) NOT NULL DEFAULT 0,
BIActual DECIMAL(10,2) NOT NULL DEFAULT 0,
OrgNo INTEGER(9) UNSIGNED NOT NULL,
ECNo INTEGER(10) UNSIGNED NOT NULL,
CONSTRAINT BudgetItem_CK1 CHECK (BIYear >= 1900),
CONSTRAINT BudgetItem_AK1 UNIQUE (BIYear,OrgNo,ECNo),
CONSTRAINT BudgetItem_PK PRIMARY KEY(BINo),
CONSTRAINT BudgetItem_FK1 FOREIGN KEY(OrgNo) REFERENCES OrgUnit(OrgNo)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT BudgetItem_FK2 FOREIGN KEY(ECNo) REFERENCES ExpCat(ECNo)
ON DELETE NO ACTION
ON UPDATE NO ACTION

) Engine = InnoDB;


CREATE TABLE ExpenseReport
(
ERNo INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
ERDesc VARCHAR(255) NOT NULL,
ERSubmitDate DATETIME NOT NULL,
ERStatusDate DATETIME NOT NULL,
ERStatus VARCHAR(8) NOT NULL DEFAULT 'PENDING',
SubmitUserNo INTEGER(10) UNSIGNED NOT NULL,
ApprUserNo INTEGER(10) UNSIGNED NOT NULL,
CONSTRAINT ExpenseReport_CK1 CHECK ERStatusDate >= ERSubmitDate,
CONSTRAINT ExpenseReport_CK1 CHECK ERStatus = 'PENDING'/'APPROVED'/'DENIED',
CONSTRAINT ExpenseReport_PK1 PRIMARY KEY(ERNo),
CONSTRAINT ExpenseReport_FK1 FOREIGN KEY(SubmitUserNo) REFERENCES Users(UserNo),
CONSTRAINT ExpenseReport_FK2 FOREIGN KEY(ApprUserNo) REFERENCES Users(USerNo)
) Engine = InnoDB;



CREATE TABLE ExpenseItem
(
EINo INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
ExpDesc VARCHAR(255) NOT NULL,
ExpenseDate DATETIME NOT NULL,
ExpAmt DECIMAL(10,2) NOT NULL DEFAULT 0,
ExpApprAmt DECIMAL(10,2) DEFAULT 0,
ERNo INTEGER(10) UNSIGNED NOT NULL,
ECNo INTEGER(10) UNSIGNED NOT NULL,
AssetNo INTEGER(10) UNSIGNED NULL,
CONSTRAINT ExpenseItem_PK1 PRIMARY KEY(EINo),
CONSTRAINT ExpenseItem_CK1 CHECK (ExpApprAmt<=ExpAmt),
CONSTRAINT ExpenseItem_FK1 FOREIGN KEY(ERNo) REFERENCES ExpenseReport(ERNo)
ON UPDATE CASCADE
ON DELETE CASCADE,
CONSTRAINT ExpenseItem_FK2 FOREIGN KEY(ECNo) REFERENCES ExpCat(ECNo)
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT ExpenseItem_FK3 FOREIGN KEY(AssetNo) REFERENCES Asset(AssetNo)
ON UPDATE SET NULL
ON DELETE SET NULL
) Engine = InnoDB;




INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (1,'Company Car');

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (2,'Company Jet');

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (3,'Company Van');

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (4,'Company Truck');

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (1,'Accounting', NULL );

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (2,'Sales', NULL);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (3,'IT', NULL);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (4,'IT Development',3);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (5,'Accounts Receivable',1);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (6,'IT Support',3);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (7,'Accounts Payable',1);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (1,'Dinner',50.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (2,'Car Rental',100.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (3,'Breakfast',25.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (4,'Local Transportation',100.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (5,'Airfare',5000.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (6,'Lunch',25.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (7,'Lodging',300.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (8,'Admission Fee',2000.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (9,'Gas',35.00);


INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'Sue','Herdon','[phone]','[e-mail]',3);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'Bill','Jones','[phone]','[e-mail]',6);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'Joe','Smith','[phone]','[e-mail]',4);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'William','Freed','[phone]','[e-mail]',1);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'Sara','Jonson','[phone]','[e-mail]',7);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'Tom','Sanchez','[phone]','[e-mail]',5);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (\N,'Marry','Blake','[phone]','[e-mail]',2);




INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (1,'Sales Presentation','2002-08-10','2002-08-26','APPROVED',3,4);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (2,'Conference','2002-08-16','2002-08-17','APPROVED',4,4);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (3,'Training Course','2002-09-23','2002-09-25','APPROVED',2,1);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (4,'IT Group Lunch','2002-09-29','2002-09-29' ,'APPROVED',1,4);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (5,'Sales Presentation','2002-09-30',''2002-01-01','APPROVED',7,4);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES (2,'Hilton','2002-08-09',99.00,99.00,1,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(3,'Gas','2002-08-09',35.00,20.00,1,9,1);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(4,'Breakfast','2002-08-10',10.00,10.00,1,3,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(5,'Comfort Inn','2002-08-16',225.00,225.00,2,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(6,'Airfare','2002-08-13',325.00,325.00,2,5,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(7,'Dinner','2002-08-15',23.94,23.94,2,1,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(8,'Dinner','2002-08-14',32.50,32.50,2,1,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(9,'Dinner','2002-08-13',19.64,19.64,2,1,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(10,'Lunch','2002-08-15',25.00,25.00,2,6,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(11,'Breakfast','2002-08-15',10.32,10.32,2,3,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(12,'Motel 6','2002-09-23',57.95,57.95,3,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(13,'Gas','2002-09-23',15.94,15.94,3,9,3);

INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (1,2002,1,1,4000.00,76.08);

INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (2,2002,1,2,3000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (3,2002,1,3,2000.00,10.32);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (4,2002,1,4,500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (5,2002,1,5,10000.00,325.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (6,2002,1,6,2000.00,25.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (7,2002,1,7,10000.00,225.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (8,2002,1,8,6000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (9,2002,1,9,5000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (10,2002,2,1,10000.00,167.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (11,2002,2,2,7500.00,98.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (12,2002,2,3,4000.00,10.75);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (13,2002,2,4,1500.00,5.50);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (14,2002,2,5,15000.00,650.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (15,2002,2,6,5000.00,6.79);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (16,2002,2,7,12000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (17,2002,2,8,7500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (18,2002,2,9,7500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (19,2002,3,1,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (20,2002,3,2,3000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (21,2002,3,3,2000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (22,2002,3,4,500.00,24.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (23,2002,3,5,10000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (24,2002,3,6,2000.00,75.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (25,2002,3,7,10000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (26,2002,3,8,10000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (27,2002,3,9,5000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (28,2002,4,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (29,2002,4,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (30,2002,4,3,1000.00,10.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (31,2002,4,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (32,2002,4,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (33,2002,4,6,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (34,2002,4,7,2000.00,99.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (35,2002,4,8,8000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (36,2002,4,9,650.00,35.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (37,2002,5,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (38,2002,5,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (39,2002,5,3,1000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (40,2002,5,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (41,2002,5,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (42,2002,5,6,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (43,2002,5,7,2000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (44,2002,5,8,5500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (45,2002,5,9,350.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (46,2002,6,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (47,2002,6,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (48,2002,6,3,1000.00,2.99);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (49,2002,6,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (50,2002,6,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (51,2002,6,6,1500.00,5.95);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (52,2002,6,7,2000.00,57.95);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (53,2002,6,8,5500.00,1000.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (54,2002,6,9,350.00,15.94);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (55,2002,7,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (56,2002,7,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (57,2002,7,3,1000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (58,2002,7,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (59,2002,7,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (60,2002,7,6,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (61,2002,7,7,2000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (62,2002,7,8,8000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (63,2002,7,9,650.00,0.00);