inetserver asp db: I'm developing an online Payroll/Cash Advance application for a client. =
So far, I have a table with the fee structures for both the check cashing =
and cash advance. Now I need a "cash register" type table for keeping =
track of the transactions going in and out for the cashier. My idea so =
far is :

Debit_Credit
Amount
Type - (Check cashing/Cash Advance/Deposit)
Reference (CheckCashing ID or CashAdvanceID)
DateTime
CashierID=20

How does that sound? Basically I need to handle all the transactions that =
come to the window to know how much cash is on hand anytime of the day for =
that cashier and be able to tie it to a transaction. =20

Any ideas, suggestions, or recommendations? Thanks In Advance!!!

Looking at it quickly what you wrote looks pretty good. Don't know if
you'd need to store a few more bits of info about the person involved,
check received, and name/ID of the teller...

<<
I'm developing an online Payroll/Cash Advance application for a client.
So far, I have a table with the fee structures for both the check
cashing and cash advance. Now I need a "cash register" type table for
keeping track of the transactions going in and out for the cashier. My
idea so far is :

Debit_Credit
Amount
Type - (Check cashing/Cash Advance/Deposit)
Reference (CheckCashing ID or CashAdvanceID)
DateTime
CashierID

How does that sound? Basically I need to handle all the transactions
that come to the window to know how much cash is on hand anytime of the
day for that cashier and be able to tie it to a transaction.

Any ideas, suggestions, or recommendations? Thanks In Advance!!!

Shawn
[quoted text, click to view]

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

Hi Shawn,

Our company offers a cash advance system in that uses ASP as a programming language.

Maybe we can discuss.

Regards,
Nick

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/