Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)
e-mail address___________________________________________________
EXAM TO BE RETURNED BY 5:30 PM MON DEC 10 TO 280E MH
Major | Minor | Sub 1 | Sub 2 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
2500 | 1000 | 0000 | 0000 | |||
1800 | 3000 | 0000 | 0000 | |||
9000 | 1000 | 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 | IBM Stock | |||
9100 | 2000 | 0000 | 0000 | Toner Expense | |||
1000 | 5000 | 0000 | 0000 | Cash Aspen Ski and Security Bank | |||
4000 | 3000 | 4000 | 0000 | Capt. Webb T-shirt Sales | |||
4000 | 3000 | 5000 | 0000 | Capt Web Mobile Apps Store Sales | |||
5000 | 1000 | 4000 | 0000 | Direct Labor - Mobile Apps Store | |||
1000 | 4000 | 0000 | 0000 | Cash -- Teluride Bank Houston Office | |||
1100 | 0003 | 0000 | 0000 | CD 4532-7122-6 12-5-2012 | |||
1700 | 3000 | 0000 | 0000 | Capt. Web Art Collection | |||
4000 | 3000 | 5000 | 0000 | Capt. Web 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 | 4000 | 0000 | 0000 | Cash Petty Houston B & T Alvin Branch | |||
4000 | 3000 | 0000 | 0000 | Capt. Webb Duty Free Airport Sales | |||
9000 | 1000 | 0000 | 0000 | Capt. Webb Aspen Chalet Lease | |||
9999 | 9999 | 0000 | 0000 | Suspense Account | |||
4000 | 2000 | 0000 | 0000 | Litigation Proceeds | |||
1900 | 4000 | 0000 | 0000 | Prepaid Limo Rental | |||
9000 | 4000 | 0000 | 0000 | Executive Life Insurance Expenses | |||
4000 | 3000 | 5000 | 0000 | Capt. Webb Door-to-door Sales |
SRN: | 3411 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
7000 | 1000 | 3000 | 0000 | 9346.77 | Supervisory Catalog Direct Labor for December | |||
1000 | 5000 | 0000 | 0000 | -9346.77 | ||||
SRN: | 3412 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
8000 | 1000 | 3000 | 0000 | 34,550.21 | Part-Time Catalog Labor Dec 2012 | |||
1000 | 3000 | 0000 | 0000 | -34,550.21 | ||||
SRN: | 3413 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -187345.00 | Buy IBM Stock | |||
1100 | 0003 | 0000 | 0000 | 187345.00 | ||||
SRN: | 3414 | 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.99 | Clear Suspense Account | |||
9999 | 9999 | 0000 | 0000 | 975.99 | ||||
SRN: | 3415 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 54390.45 | Sales for Dec 2012 | |||
4000 | 3000 | 1000 | 0000 | -54000.00 | ||||
4000 | 3000 | 2000 | 0000 | -300.00 | ||||
4000 | 3000 | 3000 | 0000 | -90.00 | ||||
4000 | 3000 | 4000 | 0000 | -0.45 | ||||
SRN: | 3416 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 9000 | 0000 | 0000 | 14328.32 | Exxon Credit Card for Gasoline | |||
1000 | 4000 | 0000 | 0000 | -14328.32 | ||||
SRN: | 3461 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -34581.44 | FICA paid | |||
2400 | 4000 | 0000 | 0000 | 34581.44 | ||||
SRN: | 3417 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 5000 | 0000 | 0000 | -556.13 | Pay Internet Maintenance | |||
6000 | 1000 | 1000 | 0000 | -566.13 | ||||
SRN: | 3418 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1100 | 0004 | 0000 | 0000 | 240984.33 | Buy Apple Stock | |||
1000 | 2000 | 0000 | 0000 | -240984.33 | ||||
SRN: | 3419 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1700 | 3000 | 0000 | 0000 | 88.88 | Buy Foot Massage Device | |||
1000 | 3000 | 0000 | 0000 | -44.44 | ||||
1000 | 2000 | 0000 | 0000 | -44.44 | ||||
SRN: | 3420 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -303552.19 | Move Cash to Aspen | |||
1000 | 5000 | 0000 | 0000 | 303552.19 | ||||
SRN: | 3421 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 2000 | 0000 | 0000 | 8602.55 | Buy new Bilge Pump | |||
1000 | 1000 | 0000 | 0000 | -8602.55 | ||||
SRN: | 3422 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -600.00 | Seafarers Union Dues | |||
1000 | 2000 | 0000 | 0000 | -30.00 | ||||
1000 | 3000 | 0000 | 0000 | -8.00 | ||||
1000 | 4000 | 0000 | 0000 | -0.20 | ||||
1000 | 5000 | 0000 | 0000 | -0.01 | ||||
9000 | 3000 | 0000 | 0000 | 638.21 | ||||
SRN: | 3461 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 6000 | 0000 | 0000 | -8.11 | But New Name Tags | |||
9000 | 5000 | 0000 | 0000 | 8.11 | ||||
SRN: | 3423 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 5000 | 0000 | 0000 | -88.34 | Motorcycle Fuel | |||
9000 | 9900 | 0000 | 0000 | 88.34 |
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.