hullstorage
Registered User.
- Local time
- Today, 03:15
- Joined
- Jul 18, 2007
- Messages
- 213
Hi all,
I am creating a simple database to keep records of stock movements.
We have parts that come in and out of our warehouse all which will be scanned at time of movement.
I am thing I will need a few tables and relationships for this and this is the main advise that I will be moving.
Here is how the system works note that there will be no product details and every thing will simply be numbers as follows:
THIS IS FOR ALL ITEMS COMING INTO
[GOODSINWARD]
DATEIN
TIMEIN
SCANNEDBYEMPLOYEE
PARTNOID
SERIALNOID
UNIQUENOID
TOLOCATIONID
ANYCOMMENTS
[GOODSOUT]
DATEOUT
TIMEOUT
SCANNEDBYEMPLOYEE
PARTNOID
SERIALNOID
UNIQUENOID
FROMLOCATIONID
ANYCOMMENTS
[STOCKLOCATIONS]
STOCKLOCATIONID EXAMPLE RACKING NO A001, C003 ETC
ALL THIS IS SIMPLY TO DO IS SO THAT ONCE PARCELS HAVE BEEN PICKED THEN DETAILS WILL BE PRODUCED ON A REPORT WHEN REQUIRED
EVERY PARCEL HAS 3 BARCODES AS ABOVE AND THE LOCATION WILL ALSO HAVE A BARCODE SO EVERYHTING WILL BE INPUTTED MAINLY BY SCANNER.
THANKS FOR ANY ADVISE YOU CAN GIVE
I am creating a simple database to keep records of stock movements.
We have parts that come in and out of our warehouse all which will be scanned at time of movement.
I am thing I will need a few tables and relationships for this and this is the main advise that I will be moving.
Here is how the system works note that there will be no product details and every thing will simply be numbers as follows:
THIS IS FOR ALL ITEMS COMING INTO
[GOODSINWARD]
DATEIN
TIMEIN
SCANNEDBYEMPLOYEE
PARTNOID
SERIALNOID
UNIQUENOID
TOLOCATIONID
ANYCOMMENTS
[GOODSOUT]
DATEOUT
TIMEOUT
SCANNEDBYEMPLOYEE
PARTNOID
SERIALNOID
UNIQUENOID
FROMLOCATIONID
ANYCOMMENTS
[STOCKLOCATIONS]
STOCKLOCATIONID EXAMPLE RACKING NO A001, C003 ETC
ALL THIS IS SIMPLY TO DO IS SO THAT ONCE PARCELS HAVE BEEN PICKED THEN DETAILS WILL BE PRODUCED ON A REPORT WHEN REQUIRED
EVERY PARCEL HAS 3 BARCODES AS ABOVE AND THE LOCATION WILL ALSO HAVE A BARCODE SO EVERYHTING WILL BE INPUTTED MAINLY BY SCANNER.
THANKS FOR ANY ADVISE YOU CAN GIVE