Re: Inventory Database Design???

From: Todd Verstraten <tverstrat_at_tier3.com>
Date: 1996/12/05
Message-ID: <01bbe259$43f33680$347315ce@toddv.retailplanning.com>#1/1

set up your sequences with "CODE CONTROL". that causes it to use tables to hold the numbers.

Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com

Douglas Scott <dsscott_at_gte.net> wrote in article <32A4BC79.1B4A_at_gte.net>...
> I'm about to start designing an inventory database in Oracle's
> Designer/2000 and would like to know how other people handle serialized
> and lot numbered items. The design will need to keep track of inventory
> as it moves from place to place, is built up into an assembly and then
> disassembled etc. Also everything will be barcoded. Anybody have some
> suggestions or tips on how they're doing it?
>
> Thanks
> Douglas Scott
> dsscott_at_gte.net
>
Received on Thu Dec 05 1996 - 00:00:00 CST