Data warehouse db

Completed Posted Jan 22, 2012 Paid on delivery
Completed Paid on delivery

Need a data warehouse db.

used by 4-5 users.

1. We need to record incoming/outbound item (3 dock doors).

what the driver gives to the dock will by verified by what was received.

The item number given must match the number keyed in by the dock

(the driver types the items in = 12345678

23456789

his user name TOM BURK from drop down

The dock employee then types the item received

12345678

23456789

his user name Jim Taylor from drop down

a field in case of comments needed (ex. box 123011 was wet)

and then hits the VERIFY button .

The verify checks to see what the driver (delivery) and the dock (received) are the same.

If the same print a report 2 times with the items, delivery name, receiver name and time and date and comments

2. Once received the inside warehouse will add more info to the items scanned in

1234567

2345678

they will add : from what [login to view URL], the value and a comment field

The inside warehouse will then forward the items to area 1 or area 2 (need to record this).

Also the inside ware. will create new orders, so the will need to :

type in the item 55556666

Company Richo

Value 200

only then the dock will be able to send out an item (must exist in the system prior).

any move. to the dock doors from area 1 and 2 will be done by the inside ware. fowarding the items to the dock.

We need to be able to print reports:

what was received by dock door 1, 2,3 and by all doors (also by date)

report of items sent to area 1 or 2 for inside ware.

a report from inside ware. on newly created items

and be able to track an item by its number.

In essence an items db tracking movement and creating reports.

This can be done in Access or ?

MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing Windows Desktop

Project ID: #2703469

About the project

9 proposals Remote project Active Jan 31, 2012

Awarded to:

customizedata

See private message.

$255 USD in 18 days
(218 Reviews)
7.3

9 freelancers are bidding on average $205 for this job

amcsummers

See private message.

$265.2 USD in 18 days
(57 Reviews)
5.5
lourdasv

See private message.

$246.5 USD in 18 days
(48 Reviews)
5.5
russel02cuet

See private message.

$175.1 USD in 18 days
(78 Reviews)
5.4
bdtechies

See private message.

$150.45 USD in 18 days
(42 Reviews)
4.3
pramodv

See private message.

$250.75 USD in 18 days
(16 Reviews)
3.7
nithyarajeshg

See private message.

$85 USD in 18 days
(30 Reviews)
3.3
Aliraza170

See private message.

$190.4 USD in 18 days
(3 Reviews)
1.5
sonugeevw

See private message.

$227.59 USD in 18 days
(0 Reviews)
0.0