Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Information of db design for stock traceability...
Message
From
09/02/2004 10:07:40
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00873938
Message ID:
00875461
Views:
17
>
>Added complications involve lots of QC testing and needing to know stock at locations, there is one physical warehouse but many quarantine and approved materials areas etc...

check out the KanBan model. Designed for precisely that kind of monitoring.
>
>I think that once on the premises each material delivered can be given a unique batch or lot number that stays with it during it's lifecycle as you mentioned which will give traceability.

are they sufficiently important to their suppliers to be able to insist on the unique id for each incoming component? Thats by far the easiest...

>
>My thinking is not fully formed as yet and it has gaping wholes in it! But I am modeling it out and working through it...!
>
good luck
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform