Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)
e-mail address___________________________________________________
EXAM TO BE RETURNED BY 5:30 PM FRI AUG 10 TO 280E MH
Major | Minor | Sub 1 | Sub 2 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
2400 | 1000 | 0000 | 0000 | |||
1800 | 2000 | 0000 | 0000 | |||
9000 | 9000 | 0000 | 0000 | |||
4000 | 3000 | 4000 | 0000 | |||
9999 | 9999 | 0000 | 0000 |
Major | Minor | Sub 1 | Sub 2 | Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
2400 | 1000 | 0000 | 0000 | Federal Income Tax Due | |||
1100 | 0003 | 0000 | 0000 | Facebook Stock | |||
9100 | 2000 | 0000 | 0000 | Health Insurance | |||
1000 | 5000 | 0000 | 0000 | Cash San Jacinto Branch Bank | |||
4000 | 3000 | 4000 | 0000 | Capt. Webb Franchises | |||
4000 | 3000 | 5000 | 0000 | Capt. Webb Transaction Systems Sales | |||
5000 | 1000 | 2000 | 0000 | Contract Programming | |||
1000 | 4000 | 0000 | 0000 | Cash -- San Jacinto Main Bank | |||
1100 | 0002 | 0000 | 0000 | Sell CD | |||
1700 | 4000 | 0000 | 0000 | Firewall Bricks | |||
4000 | 3000 | 5000 | 0000 | Door-to-door Sales |
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
3000 | 6000 | 0000 | 0000 | Retained Earnings | |||
1000 | 5000 | 0000 | 0000 | Cash San Jac Bank | |||
4000 | 4000 | 0000 | 0000 | Capt. Webb Door-to-door Sales | |||
9000 | 1000 | 0000 | 0000 | Condo for the Captain Lease | |||
9999 | 9999 | 0000 | 0000 | SUSPENSE ACCOUNT | |||
4000 | 2000 | 0000 | 0000 | Patent Law Suits Proceeds | |||
1900 | 1000 | 0000 | 0000 | Prepaid Jet Rental | |||
9000 | 4000 | 0000 | 0000 | Insurance Expenses | |||
4000 | 3000 | 5000 | 0000 | Door-to-Door Sales |
SRN: | 7211 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 1000 | 0000 | 0000 | 5341.24 | Condo Maintenance | |||
1000 | 4000 | 0000 | 0000 | -5341.24 | ||||
SRN: | 7212 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
2600 | 2000 | 0000 | 0000 | 327.11 | Matching Contributions | |||
1000 | 3000 | 0000 | 0000 | -327.11 | ||||
SRN: | 7213 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -43818.12 | Buy Facebook Stock | |||
1100 | 0001 | 0000 | 0000 | 43818.12 | ||||
SRN: | 7214 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
3000 | 6000 | 0000 | 0000 | -975.01 | Clear Suspense Account | |||
9999 | 9999 | 0000 | 0000 | 975.01 | ||||
SRN: | 7215 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 3812.44 | Sales for March 2012 | |||
4000 | 3000 | 4000 | 0000 | -3002.11 | ||||
4000 | 3000 | 3000 | 0000 | -800.11 | ||||
4000 | 3000 | 2000 | 0000 | -10.11 | ||||
4000 | 3000 | 1000 | 0000 | -2.11 | ||||
SRN: | 7216 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 9000 | 0000 | 0000 | 222.42 | Shell Credit Card for Gasoline | |||
1000 | 4000 | 0000 | 0000 | -222.42 | ||||
SRN: | 7261 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -778.13 | Verizon Mobile Phone Bill | |||
9000 | 6000 | 0000 | 0000 | 718.13 | ||||
SRN: | 7217 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -556.13 | Pay FICA | |||
2400 | 4000 | 0000 | 0000 | -556.13 | ||||
SRN: | 7218 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1100 | 0004 | 0000 | 0000 | 606.12 | Buy Apple Stock | |||
1000 | 5000 | 0000 | 0000 | -606.12 | ||||
SRN: | 7219 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1700 | 2000 | 0000 | 0000 | 468.24 | Buy New Vacuum Cleaner | |||
1000 | 6000 | 0000 | 0000 | -234.12 | ||||
1000 | 2000 | 0000 | 0000 | -234.12 | ||||
SRN: | 7220 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -90100.00 | Move Cash to San Jac | |||
1000 | 5000 | 0000 | 0000 | 90100.00 | ||||
SRN: | 7221 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 2000 | 0000 | 0000 | 776.71 | Buy new Ship Anchor | |||
1000 | 1000 | 0000 | 0000 | -776.71 | ||||
SRN: | 7222 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -500.00 | Yacht Club Dues | |||
1000 | 2000 | 0000 | 0000 | -80.00 | ||||
1000 | 3000 | 0000 | 0000 | -5.00 | ||||
1000 | 4000 | 0000 | 0000 | -0.80 | ||||
1000 | 5000 | 0000 | 0000 | -0.05 | ||||
9000 | 3000 | 0000 | 0000 | 585.85 | ||||
SRN: | 7261 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 7000 | 0000 | 0000 | 371.41 | Paper Clips | |||
9000 | 5000 | 0000 | 0000 | -371.41 | ||||
SRN: | 7223 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 6000 | 0000 | 0000 | -3229.13 | Yacht Fuel | |||
9000 | 9000 | 0000 | 0000 | 3229.13 |
Using SRCGL | Using SRCGLV | Using SRCGLC | |
The glmaster balance is | $______________ | $______________ | $______________ |
The number of accounts in the glmaster table | _______________ | _______________ | _______________ |
The number of rows in the je table is: (see 9 below) | _______________ | _______________ | _______________ |
Are any Cash accounts overdrawn? If so, which ones: | _______________ | _______________ | _______________ |
BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
BE SURE TO: SHOW THE OVERALL glmaster BALANCE.
BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster TABLE.
BE SURE TO: SHOW THE REPORT TIME AND DATE.
Make sure your index.htm file has working links to each assignment component
Put your name, Student Number, Database Acct # on each page.
Make sure your index.htm file has working links to each assignment component
Bind the pages so that they DO NOT fall apart.
email me at parks@uh.edu if you have issues.