Yahoo Web Search

Search results

1. stackoverflow.com › questions › 4364976database design - Info needed for an inventory system - Stack ...

   stackoverflow.com › questions › 4364976

   • Cached

   Dec 6, 2010 · I'm building a point of sale for a meat market and need specific information as it relates to how inventory should be tracked. I want to design the database for this system but lack the knowledge needed. I already have a basic database that will handle products but need to implement something additional that will handle the weight of the meats.

2. stackoverflow.com › questions › 18719646Inventory management database: definition vs. instances

   stackoverflow.com › questions › 18719646

   • Cached

   Sep 10, 2013 · You are on the right track that you need to worry about definitions and instances. Generally, the definition/specification is called a Product (or a Good), and the instance is called an Asset. A Product is "composed" of other Products. There are a few kinds of Assets, Discrete Assets (like a car, with a serial number), Inventory Assets (like ...

3. stackoverflow.com › questions › 17350988How do I design a database to maintain history of inventory

   stackoverflow.com › questions › 17350988

   • Cached

   Jun 27, 2013 · I need help with designing database for following data. Time1 : x,y,z. Time2 : x,x,y,z. Time3 : x,y,W. I need to store the above in database. How should I design my table. the list of inventory (x,y,z..) can be in hundreds. mostly I will be using this to get quick history change between 2 time stamps. and inserting new inventory into table ...

4. stackoverflow.com › questions › 68872996How to design database for stock inventory transactions ...

   stackoverflow.com › questions › 68872996

   • Cached

   Aug 21, 2021 · I am designing a inventory stock-management system. My current understanding is that it should be similar to bank transactions, in which you take inventory from location A and put it at location B. In that case I would have a transaction table like so: id product_id amount_of_units from_location_id to_location_id

5. stackoverflow.com › questions › 14200330sql - Inventory Management Table Structure - Stack Overflow

   stackoverflow.com › questions › 14200330

   • Cached

   Jan 7, 2013 · 1. Our team needs to track inventory for essentially an in-house created ERP system. We will need to frequently access the amount of inventory in the system for a given item at a given warehouse and have the ability to track what changed the inventory and when. The initial thought was to just have the adjustments table and calculate the current ...

6. stackoverflow.com › questions › 2494343Database schema design for a double entry accounting system?

   stackoverflow.com › questions › 2494343

   • Cached

   For example to add a new transaction in the database, add a new record in the transaction table and fill in the fields, select a contact name, enter a date, etc. Then add new child records to the parent transaction record for each account affected. Each transaction record must have at least two child records (in a double-entry bookkeeping system).

7. stackoverflow.com › questions › 17651424Bill of materials database model - Stack Overflow

   stackoverflow.com › questions › 17651424

   • Cached

   Jul 15, 2013 · We're in the stage of modeling our database and one of the requirements is to generate a BOM (Bill of materials). I've read this thread and found an example data model for BOM: conceptual data model and physical data model. but i'm not sure I fully understand. Our final product consists of a couple of sub-assemblies, so each sub-assembly is a ...