1, "commodity catalog table" or commodity code table: including commodity ID, commodity name, specification, measurement unit ... description of other features ... the most important commodity code. ...
2. The goods warehousing list includes warehousing identification, warehousing number, warehousing date, warehousing nature, remarks, warehousing inspection person in charge and other information.
3. Commodity warehousing table includes warehousing identification, commodity identification, warehousing quantity, amount, remarks, etc.
4. Commodity outbound order includes outbound order number, outbound order number, outbound date, outbound department, remarks, outbound person in charge and other related information. ...
5. Commodity delivery table includes delivery document identification, commodity identification, delivery quantity, amount, remarks, etc.
This relationship is:
1, the commodity ID in the commodity catalog table contains all the records of the commodity ID in the commodity warehousing table and the commodity outbound table. ...
2. The receiving identification in the goods receipt document contains all the records of the receiving identification in the goods receipt document. ...
3. The outbound order ID in the commodity outbound order contains all records of the outbound order ID in the commodity outbound order table. ...
Your inventory table is obtained by querying commodity catalog table, commodity receipt table, commodity delivery table, etc ... If it is an installment report, you can complete the corresponding query by setting the conditions of the receipt date and commodity delivery date. ...
I don't know if it can help you ... it looks a little more complicated than yours, but it will be recorded in more detail, combined with the effective methods of recording information in general databases. ...