A data model of interval material information and a method for establishing the same

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: 2019-01-08
赖勇清
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 of interval material information and a method for establishing the same
  • A data model of interval material information and a method for establishing the same
  • A data model of interval material information and a method for establishing the same

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 corresponding cell of column A in the incoming area; at the same time, the corresponding quantity of each sub-part in the sub-package is calculated according to the incoming quantity of the physical master part of material An and written in the The ...

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 invention relates to a material information data processing method, in particular to a data model of interval material information and a method for establishing the same. The data model comprisesa data model table of material information of an interval, columns of the data model table are arranged in zones, including an entrance area, a production area, an exit area and a storage area, the entrance area is provided with A, B columns, the production area is provided with A, B and C columns, the exit area is provided with A, B columns, and the storage area is provided with A, B columns, the columns of the data model table are provided with parent parts An in bom of the material An and child parts in a child part package Nnn. The invention provides the data model of the material information of an interval and a method for establishing the data model, which can calculate the balance of the input, output, output and storage of the mother part An and the child parts of the material Anin the interval.

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 Applications(China)
IPC IPC(8): G06Q10/08G06Q10/10
CPCG06Q10/0875G06Q10/10
Inventor 赖勇清
Owner 赖勇清
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap