Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A data model and establishment method of interval material information

A technology of data model and establishment method, which is applied in the field of data model and establishment of material information, which can solve problems such as balance, data model cannot be summarized, and material An cannot be calculated, so as to achieve the effect of improving efficiency

Active Publication Date: 2022-01-14
赖勇清
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Existing MRP is based on the data model established and calculated based on the information of the physical master part and physical sub-parts of material An in the interval, interval production, interval storage, and interval exit. However, this is only based on the physical master part of material An. The data model established by the information in the interval cannot truly and completely summarize and express the information of the material An in the interval
For example, the existing manufacturing ERP has been unable to calculate the balance of the import, output, output, and storage of materials An within the enterprise range. For example, for a mobile phone manufacturing enterprise, the master mobile phone can only be exported but not imported, and the sub-parts of the master mobile phone BOM Each component in the package (that is, the components and material components in the mobile phone) only enters but does not exit
Therefore, the existing underlying algorithm models of various ERPs can only calculate the material entry, exit, and storage balance of the warehouse in the enterprise interval, but cannot calculate the master part and the sub-package of the master part BOM in the interval. Import, output, output, and storage balance of components and material components within the enterprise range

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A data model and establishment method of interval material information
  • A data model and establishment method of interval material information
  • A data model and establishment method of interval material information

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] This embodiment introduces this model and its application in detail by taking the data model and its application of the material An (m=3) as an example;

[0035] A. Data model table:

[0036]

[0037] A1. Algorithm of column B in data model table entry area:

[0038]

[0039] A2. Algorithms of columns B and C of the production area of ​​the data model:

[0040]

[0041] A3. Algorithm of the data model out of the B column:

[0042]

[0043] A4. Algorithms for columns A and B in the data model storage area:

[0044]

[0045] B. Practical application:

[0046] Bom order proportional value: e11=1, e12=2, e13=2, e21=2, e22=1, e23=2, e31=1, e32=2;

[0047] B1. Inventory inventory: A1: k1 = 10, A2: k4 = 20, A3: k7 = 60 storage in column A of the area, calculation and storage of the quantity in column B, calculation of column A and B in the storage area:

[0048]

[0049]B2. The current purchase 10=90, 11=200, 20=340, 21=200, 30=300, 31=600 are stored in ...

Embodiment 2

[0056] This embodiment is a method for establishing a data model of interval material information, including the following steps:

[0057] Step 1: Create a data model table, set the entry area, production area, output area, and storage area in the column items of the data model table, set A and B columns in the entry area, set A, B, and C columns for the production area, and set the output area A, B columns are set in the area, and A, B columns are set in the storage area; the master part of the material An and each sub-piece in its sub-package are respectively set in the row item of the data model table;

[0058] Step 2: Data writing:

[0059] a. The incoming quantity of the physical master part of material An is written into the cell in column A corresponding to the incoming area; at the same time, according to the incoming quantity of the physical master part of material An, the corresponding quantity of each sub-piece in the sub-package is calculated and written in The ce...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present invention relates to a data processing method for material information, in particular to a data model and establishment method of interval material information. Area, out area, and storage area, the entry area is set in columns A and B, the production area is set in columns A, B, and C, the out area is set in columns A and B, the storage area is set in columns A and B, and the data model table Set the master part An in the bom of the material An and the sub-parts in its sub-part package Nnn respectively. The present invention provides a data model and establishment method of the material information in the interval, which can calculate the parent part of the material An in the interval. The balance of import, output, output and storage of parts and their components.

Description

technical field [0001] The invention relates to a material information data processing method, in particular to a data model and establishment method of interval material information. Background technique [0002] Materials are the general term for products, finished products, semi-finished products, components, parts, materials, and raw materials in each resource area in market circulation. Materials are carried out in different resource areas in the market according to instructions, area production, area output, and area storage. Materials The information on import, output, output, and storage in these resource intervals is collectively referred to as material information; the intervals can be classified into: shopping malls, warehouses, means of transportation, manufacturing plants, workshops, sections, processes and their supply chains. [0003] The BOM of the material An (A is the material code, n is a natural number of 1, 2...m, m is the BOM order of the material An) i...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06Q10/08G06Q10/10
CPCG06Q10/0875G06Q10/10
Inventor 赖勇清
Owner 赖勇清
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com