Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Information of db design for stock traceability...
Message
De
09/02/2004 10:07:40
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00873938
Message ID:
00875461
Vues:
16
>
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform