CN116821121A - Material main data standard generation method and device, computer equipment and storage medium - Google Patents

Abstract

The application relates to a method, a device, computer equipment and a storage medium for generating a material main data standard, and belongs to the technical field of industrial informatization IT. A method for generating a material main data standard comprises the following steps: defining naming rules of materials; creating material main data and BOM sub-piece main data; creating BOM of the material main data according to the material main data and the BOM sub-piece main data; the BOM comprises at least one hierarchy; acquiring target content from the sub-piece main data of the BOM according to the naming rule; and generating a material main data standard according to the naming rule and the target content. According to the material main data standard generation method, the material main data standard is generated through the sub-piece main data information of the BOM, and the related attributes of the lower-order BOM material are conveniently represented.

Description

Material main data standard generation method and device, computer equipment and storage medium

Technical Field

The application relates to a method, a device, computer equipment and a storage medium for generating a material main data standard, and belongs to the technical field of industrial informatization IT.

Background

The informatization basis of the manufacturing industry is to construct a Bill of materials (BOM), and the basis of the Bill of materials is Material information. In increasingly huge material libraries in enterprises, how to construct scientific and reasonable material naming standards meets the internal management and external market development requirements of the enterprises, not only can the management level of the enterprises be embodied, but also the method is an effective method for reducing the cost and enhancing the efficiency.

The traditional ERP management system is mainly used for naming material information, and mainly shows aspects of material coding, material names, material specifications and the like, a direct manual input mode is provided, or a preset rule is provided, content is acquired from related fields of the material of the current order, and related information is automatically generated. Manual input has high dependence on personnel, and naming contents are not standard due to different personnel habits, different input errors and other reasons; the naming normalization of the materials plays a certain role, but in practical application, the naming of the materials of the present order needs to embody the related attributes of the lower-order BOM materials, the related attributes of the BOM materials are appointed at the present order, the biggest problem of the mode is that the attribute of the present order cannot be linked with the attribute of the BOM materials, if the BOM materials are changed, the naming information defined at the present order is easy to be inconsistent with the actual BOM materials (the related attributes of the BOM materials are appointed at the present order, the situation is different from the sub-piece main data content of the cross-level selection BOM, and the effect of the linkage is only achieved based on the expansion attribute. Such as: the specification of the swimming goggles of the present order is composed of lens color, lens circle color and headband color, and the three materials come from BOM, if the lens color in the BOM material is changed, the specification of the swimming goggles of the present order is also required to be changed, otherwise, the swimming goggles of the present order are not matched with each other, and the production workshop is plagued.

In addition, when a specific value of a certain type appears in the attribute participating in naming, the value needs to be converted correspondingly, for example: if the lens has myopia degree attribute, the character of 'myopia' needs to appear automatically in the name of the lens. The naming rule with certain value condition logical operation is also not supported by the current ERP system, and although the purpose can be achieved through manual input, the naming rule has very high dependence on personnel, and if the input is wrong and missed, the material information of the system is inaccurate and not standard.

The codes, names and specifications of the materials are key information in the production process and are also main bridges for communication between departments, and the accurate, concise and standard codes, names and specifications of the materials can greatly improve the communication efficiency, thereby improving the production efficiency. Based on the current situation, the existing ERP system lacks a method for naming the level by extracting related attributes from BOM materials, and cannot support value condition operation according to different attribute values.

Disclosure of Invention

In order to solve the technical problems, the application provides a method, a device, computer equipment and a storage medium for generating a material main data standard, which support naming contents of sub-piece main data referring to BOM, and achieve consistency of the material information of the first order and the BOM material information.

In one aspect, the application provides a method for generating a material main data standard, which comprises the following steps:

defining naming rules of materials;

creating material main data and BOM sub-piece main data;

creating BOM of the material main data according to the material main data and the BOM sub-piece main data; the BOM comprises at least one hierarchy;

acquiring target content from the sub-piece main data of the BOM according to the naming rule;

and generating a material main data standard according to the naming rule and the target content.

Specifically, the naming rule comprises rule items and ordering rules among the rule items;

the obtaining the target content from the sub-piece main data of the BOM according to the naming rule comprises the following steps:

acquiring target content from the sub-piece main data of the BOM according to the rule item;

the generating the material main data standard according to the naming rule and the target content comprises the following steps:

and generating a material main data standard according to the ordering rule and the content of each rule item.

Specifically, the rule item includes rule item settings; the rule item setting comprises a sub-piece condition and a content selection setting;

the obtaining the target content from the sub-component main data of the BOM according to the rule item comprises the following steps:

acquiring sub-part main data of the target level BOM according to the sub-part conditions;

and acquiring target content from the sub-piece main data of the target level BOM according to the content selection setting.

Further, in other embodiments, the sub-component master data of the BOM includes a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

the content selection setting comprises an extension metadata name and a reference type;

obtaining target content from the sub-piece main data of the target level BOM according to the content selection setting comprises the following steps:

acquiring target extension attributes from the sub-piece main data according to the extension metadata names;

judging whether the target extension attribute exists or not;

if not, taking the null value as the target content;

if yes, acquiring target content from the target extension attribute according to the reference type.

Further, in other embodiments, the content selection setting further includes a value condition and a corresponding value result;

after the target content is obtained from the target extension attribute according to the reference type, the method further comprises the following steps:

acquiring a corresponding value result according to the target content and the value condition;

judging whether the value result exists or not;

if yes, taking the value result as the final target content;

if not, the previous target content is taken as the final target content.

Further, in other embodiments, the generating the material master data rule according to the sorting rule and the content of each rule item includes:

optimizing the content of each rule item;

and generating a material main data standard according to the sorting rule and the optimized content of each rule item.

Further, in other embodiments, after the generating the material master data standard according to the sorting rule and the content of each rule item, the method further includes:

acquiring a sub-piece main data change event of the BOM;

judging whether a sub-part main data change event of the BOM has an influence on a material main data standard according to the sub-part condition;

if yes, regenerating the main data standard of the material.

On the other hand, the application also provides a device for generating the main data product rule of the material, which comprises the following steps:

the definition unit is used for defining naming rules of the materials;

the first creating unit is used for creating material main data and BOM sub-piece main data;

the second creating unit is used for creating BOM of the material main data according to the material main data and the BOM sub-piece main data; the BOM comprises at least one hierarchy;

the obtaining unit is used for obtaining target content from the sub-piece main data of the BOM according to the naming rule;

and the generating unit is used for generating a material main data standard according to the naming rule and the target content.

In another aspect, the application also provides a computer device, which comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the method for generating the material main data standard when executing the computer program.

In another aspect, the present application also provides a computer readable storage medium storing one or more computer programs executable by one or more processors to implement a method of generating a master data item as described above.

The method, the device, the computer equipment and the storage medium for generating the material main data standard have the following beneficial effects:

1. and the material main data standard is generated through the sub-piece main data information of the BOM, so that the related attribute of the lower-order BOM material is conveniently represented.

2. The sub-piece main data information of the BOM is characterized by a fixed field and an extension field; compared with the existing dynamic extension information technology, the template of the extension attribute is not required to be defined in advance, and only loose extension metadata definition is required to be defined. When the material main data item rule is generated, the set of the expansion attribute of the sub-piece main data of each BOM can be flexibly adjusted according to specific application scenes, so that the information elements contained in the sub-piece main data are more accurate and more suitable for service scenes, and the related attribute of the lower-order BOM material can be reflected more when the material main data item rule is generated.

3. The extension attribute stored in the extension field is generated through the extension metadata, and assignment is set according to the metadata type and metadata of the extension metadata, and the characteristic attribute of the sub-piece main data of the BOM can be changed only by changing the extension attribute without changing the fixed field through frequently modifying codes, so that the sub-piece main data information of the BOM can be rapidly and flexibly maintained to respond to service change. When the expansion attribute of the sub-piece main data of the BOM is changed, the standard information of the material main data referring to the sub-piece main data of the BOM can be synchronously updated, and the linkage property and consistency of the material information of the first order and the BOM material information are realized.

4. The target content obtained through the steps is subjected to conditional operation through the value condition in the rule item setting, and the value result is converted, so that various special naming requirements can be flexibly met, naming rules are widely applied, and full automation and standardization of material naming are realized.

5. And optimizing the content of each rule item so that the finally generated material main data standard accords with the service requirement.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a schematic flow chart of a method for generating a material main data standard according to an embodiment of the present application;

FIG. 2 is a sub-schematic flow chart of a method for generating a main data standard of a material according to an embodiment of the present application;

FIG. 3 is a sub-schematic flow chart of a method for generating a master data standard for a material according to another embodiment of the present application;

FIG. 4 is a sub-schematic flow chart of a method for generating a master data standard of a material according to another embodiment of the application

FIG. 5 is a schematic block diagram of a device for generating a master data standard of a material according to an embodiment of the present application;

fig. 6 is a schematic structural diagram of a computer device according to an embodiment of the present application.

Detailed Description

The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.

It is also to be understood that the terminology used in the description of the application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.

It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.

Examples

The embodiment of the application provides a method for generating main data of materials, which is used for managing information such as codes, names, specifications, album numbers and the like of materials in manufacturing industry, wherein a database for providing data storage can be a main flow OLTP relational database such as Oracle, sql Server, mysql, postgresSQL and the like; in addition, the execution subject of the method may be a computer, a server, or the like, and the embodiment is not limited in any way.

Referring to fig. 1, fig. 1 is a schematic flow chart of a method for generating a master data standard of a material according to an embodiment of the present application. As shown in FIG. 1, the method for generating the material main data standard comprises the following steps S1-S5:

s1, defining naming rules of materials.

Specifically, the naming rule comprises rule items and ordering rules among the rule items; the rule items comprise rule item types and rule item settings; the rule item setting comprises a sub-piece condition and a content selection setting; the content selection setting comprises an extension metadata name and a reference type; the sub-part condition comprises setting modes such as setting according to a sub-part category hierarchical path and designating a BOM hierarchical level.

The rule term settings for different rule term types are somewhat different, as specified in table 1 below ("NA" indicates that there is no such rule term setting):

TABLE 1

1) When the rule item type is text, the text content is necessary to be filled, and the prefix and the suffix are selected and filled. The type is mainly used for splicing certain fixed texts in names and specifications or scenes such as separators, and the like, such as: the factory name is fixedly noted in front of the material name, the contents of the two sections of rule items are separated by "/", and the like, and the method can be realized by text types.

2) When the rule item type is "running water", the number of running water bits must be filled out, and no other rule item is set. The type is mainly used for the scene that the material coding is finally needed to use the serial number, and a complete naming rule can only have a segment of rule items of the serial type at most and must be arranged at the end of the rule. When the rule items of the flow type appear in the naming rule, after all rule items in front of the flow rule items are generated into contents, the KEY serving as the flow counter is used for obtaining the current count value of the KEY, adding 1 to the count value, combining the flow digit, and converting the count value into an available flow number conforming to the format.

3) When the rule item type is 'material main data', prefix, suffix, and value condition and corresponding value result of content selection setting are selected and filled, and the extension metadata name and reference type of content selection setting are necessary and filled. Extension metadata contained in the level class may be selected and a reference type may be specified, and a reference number or value may be used to generate the rule item content.

4) When the rule item type is 'BOM main data', prefix, suffix, and value conditions and corresponding value results of content selection setting are selected and filled, and extension metadata names and reference types of the sub-component conditions and the content selection setting are necessary and filled.

The format of the sub-component condition is: category 1- > category 2, which means that the sub-piece main data attribute of the BOM to be acquired is a sub-piece 1 with the material sub-piece category of "category 1" in the first-stage BOM, and then searching in the expansion attribute of a sub-piece 2 with the material sub-piece category of "category 2" in the BOM of the sub-piece 1 according to the sub-piece 1. And so on, the sub-component condition supports multiple levels. And searching the extension attribute of the sub-part main data of the BOM of the corresponding level according to the sub-part condition, and generating the rule item content according to the reference type.

5) The value condition and the corresponding value result are set as follows in table 2 (NA' indicates that there is no set item) only when the rule item type is the material main data or the sub-piece main data of the BOM:

TABLE 2

In the value condition, the condition operation and the condition value are all necessary to be filled.

4.1 If the type of the value result is 'extension metadata', the option of text content is not available, and the name of the extension metadata and the second reference type are all necessary filling options.

4.2 If the type of the value result in the value result is text, a text content option exists, which can be a null string, and the extension metadata name and the second reference type are not referenced.

In the embodiment of the application, the rule item types comprise 'material main data' and 'BOM main data':

when the rule item type is 'material main data', the rule item setting comprises content selection setting, prefix and suffix. The extension metadata name and the reference type of the content selection setting are necessary padding, and the prefix, the suffix and the value condition of the content selection setting and the corresponding value result are optional padding.

When the rule item type is 'BOM main data', the rule item setting comprises a sub-piece condition, a content selection setting, a prefix and a suffix; the extension metadata names and the reference types of the sub-part conditions, the content selection settings are necessary padding, and the prefix, the suffix and the value conditions and the corresponding value results of the content selection settings are optional padding.

The embodiment of the application is illustrated by material specification rules; of course, the naming rule is not limited to the material specification rule, and in other embodiments, the naming rule may be a material coding rule, a material name rule, etc. only by defining a suitable naming rule according to an actual application scenario.

According to the naming convention model described above, material specification rules are defined for materials (the embodiments of the present application are illustrated by "swimming goggles"), as detailed in Table 3 below:

TABLE 3 Table 3

The swimming goggles material specification rule consists of five rule items:

1) The first section of the specification takes the value of the attribute of category in the main data of the material;

2) The second segment of the specification is the fixed text "specification:", with the suffix ":";

3) The third section of the specification takes the value of the attribute of the 'lens color' of the category= 'lens' in the BOM main data first stage BOM, and a separator 'v' is spliced behind the result;

4) The fourth section of the specification takes the value of the "ring color" attribute of the category= "ring" in the first level BOM of the BOM main data, and spells a separator "/";

5) The fifth section of the specification takes the value of the "headband color" attribute of category = "headband" in the first level BOM of BOM main data, and spells a separator "/", after the result.

S2, creating material main data and BOM sub-piece main data.

In the embodiment of the application, the material main data and the BOM sub-piece main data are in the same type of data format and both comprise a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; and the extended attribute carries out assignment according to the metadata type and metadata setting.

Of course, in other embodiments, the material main data and the BOM sub-component main data may also adopt other types of data formats, as long as the specific application scenario is satisfied.

Referring to Table 4, a fixed field (material category, material code) is first created for the material (the embodiment of the application is illustrated with "swimming goggles"); referring to table 5, 14 extension metadata are also created at the same time. Although the metadata types in table 5 are the option table and the association table, it is not limited thereto, but text, numerals, date, whether or not, and the like may be set accordingly as long as applicable.

It should be noted that the fixed field is a general field and is adapted according to the actual application scenario; the extension metadata is also defined according to the actual application scene, and when the metadata type and metadata setting are assigned, the corresponding extension attribute is generated and stored in the extension field.

For example, { "fieldName": "category", "fieldType": "options table", "extra": { "dataKey": "150", "dataValue": "swimming goggles" } }, which is an extended attribute of the first piece of main data in table 4.

The data type of the extended attribute is json type, and the data format of the storage content is json object array. It should be noted that the fixed fields and the extension attributes in table 4 are limited to the exemplary embodiments, and are not limited thereto, and the fixed fields and the extension attributes in table 4 may be added or deleted according to the requirements of the application scenario.

TABLE 4 Table 4

TABLE 5

/>

S3, creating BOM of the material main data according to the material main data and the BOM sub-piece main data; the BOM comprises sub-piece main data; the BOM includes at least one hierarchy.

Creating a BOM of the material main data in combination with the data of table 4 and table 5 in step S2, see table 6 below:

TABLE 6

/>

S4, acquiring target content from the sub-piece main data of the BOM according to the naming rule.

Referring to fig. 2, step S4 specifically includes the following steps S41 to S44:

s41, acquiring target extension attributes from the sub-piece main data according to the extension metadata names;

s42, judging whether the target extension attribute exists or not;

s43, if not, taking the null value as the target content;

s44, if yes, acquiring target content from the target extension attribute according to the reference type.

Step S4 is elaborated in conjunction with the material specification rules in table 3, the material master data and the sub-piece master data of the BOM in table 4, and the BOM in table 6.

The swimming goggles 1 in table 4 produce the material specifications.

As can be seen from table 3, the material specification rule has five total rule entries.

The acquisition process of the content of the first segment rule item (namely, the target content 1) is as follows:

because the rule item type is "material master data", the extension attribute { "fieldName": "category", "fieldType": "option list", "extra": { "dataKey": "150", "dataValue": "swimming goggles" } }, which is the extension metadata name "category", is found from "swimming goggles 1" of table 4; then the target content 1 swimming goggles are found out through the reference type value set by content selection.

The process of acquiring the content of the second segment rule item (i.e. the target content 2) is as follows: because the rule item type is "text", the text content "specification" is directly obtained from table 3, and the suffix ": ", i.e., the target content 2 is" specification: ".

The acquisition process of the content of the third segment of rule item (namely, the target content 3) is as follows:

because the rule item type is "BOM main data", find the sub-piece main data of the category "lens" in the first level BOM from table 6, its material code is JP01, find the corresponding sub-piece main data from table 4 according to JP01, and find the expansion attribute { "fieldName": "lens color", "fieldType": "option table", "extra": { "dataKey": "000", "dataValue": "transparent" } }; then find "transparent" through the reference type "value" set by content selection, and then add the suffix "/", i.e. the target content 3 is "transparent/".

The acquisition process of the content of the fourth segment of rule item (namely, the target content 4) is as follows:

because the rule item type is 'BOM main data', finding the sub-piece main data with the category of 'mirror circle' in the first-stage BOM from the table 6, wherein the material code is JQ01, finding the corresponding sub-piece main data from the table 4 according to the JQ01, and finding the extension attribute { 'fieldName' of the extension metadata named 'mirror circle color', 'fieldType' and 'option table', 'extra', 'dataKey', '128', 'dataValue', 'Shui Lan' }; then find "Shui Lan" by the reference type "value" set by content selection, and then add the suffix "/", i.e. the target content 4 is "Shui Lan/".

The acquisition process of the content of the fifth segment of rule item (namely, the target content 5) is as follows:

because the rule item type is "BOM main data", find the sub-piece main data with the category of "headband" in the first level BOM from the table 6, its material code is TD01, find the corresponding sub-piece main data from the table 4 according to TD01, and find the expansion attribute { "fieldName": "headband color", "fieldType": "option table", "extra": { "dataKey": "111", "dataValue": "black" } }, of the expansion metadata name "headband color"; then, the "black" is found through the reference type "value" set by content selection, and then the suffix "/", that is, the target content 5 is "black/".

Further, in other embodiments, the content selection setting further includes a value condition and a corresponding value result.

When the naming rule is a material specification rule, a rule item is added to the last rule item under the naming rule of table 3, and the added material specification rule is shown in the following table 7:

TABLE 7

/>

The swimming goggles material specification rule consists of six rule items:

the content acquisition of the first five rule items is just to refer to table 3.

Sixth rule term: taking the value of the process attribute of the main material data, and converting according to the value condition and the corresponding value result: when the process attribute value= "water transfer", extracting the extended attribute with metadata named "transfer content", and referring to the value of the extended attribute, otherwise, returning the blank text.

At this time, after step S44, a step of optimizing the target content acquired in step S44 is further included.

Referring to fig. 3, the step of optimizing the target content acquired in step S44 specifically includes the following steps S441 to S444:

s441, obtaining a corresponding value result according to the target content and the value condition;

s442, judging whether the value result exists;

s443, if yes, taking the value result as the final target content according to the first value result;

and S444, if not, taking the previous target content as the final target content.

The target content obtained in the step S44 is subjected to conditional operation through the value condition in the rule item setting, and the value result is converted, so that various special naming requirements can be flexibly met, naming rules are widely applied, and full automation and standardization of material naming are realized.

The above steps are described in detail in connection with Table 7 above.

If the "swimming goggles 1" in table 4 generate the material specification, the procedure of obtaining the content of the sixth rule item shown in table 7 is as follows:

because the rule item type is "material master data", the expansion attribute { "fieldName": "process", "fieldType": "option list", "extra": { "dataKey": "01", "dataValue": "water transfer" } }, which is the name of the expansion metadata, is found from "swimming goggles 1" of table 4; then, a reference type value is selected and set through the content, and a target content water transfer printing is found; judging whether the target content ' water transfer printing ' is equal to the ' condition value ' water transfer printing ' according to the value condition, if yes, finding out corresponding expansion attribute { "fieldName": transfer printing content "," fieldType ": option table", "extra": { "dataKey": 30"," dataValue ": transfer printing blue Bai Tiaowen" } according to the value result type which is expansion metadata by the expansion metadata named as ' transfer printing content '; and obtaining a target content 'transfer blue and white stripes' according to a second reference type 'value' in the value result.

Further, when there are multiple extension attributes with the same extension metadata name and assigned with different values in the material main data and/or the sub-piece main data of the BOM, the multiple extension attributes are acquired in step S41, so that the multiple target contents of the rule item acquired in steps S41-S44 are acquired, and at this time, the multiple target contents (i.e. the contents of the rule item) need to be optimized, and a suitable target content is selected.

And S5, generating a material main data standard according to the naming rule and the target content.

The detailed exemplary procedure of the above step S4 is described.

When the swimming goggles 1 in table 4 generate the material specification according to the material specification rule in table 3, the target content 1 (swimming goggles), the target content 2 (specification:), the target content 3 (transparent /), the target content 4 (Shui Lan /) and the target content 5 (black /) are sequentially sequenced according to the sequencing sequence number in table 3, so as to finally obtain the material specification of the swimming goggles 1: swimming goggles specification of transparent/Shui Lan/black/".

When the "swimming goggles 1" in table 4 generates the material specification according to the material specification rule in table 7, the target content 1 (swimming goggles), the target content 2 (specification:), the target content 3 (transparent /), the target content 4 (Shui Lan /), the target content 5 (black /) and the target content 6 (transfer blue-white stripes) are sequentially ordered according to the ordering sequence number in table 3, and finally the material specification of the "swimming goggles 1" is obtained: "swimming goggles Specification transparent/Shui Lan/black/transfer blue-white stripes".

Further, in other embodiments, after step S5, a material main data item rule changing step is further included.

Referring to fig. 4, the material main data item rule changing step includes the following steps S51 to S53.

S51, acquiring a sub-piece main data change event of the BOM;

s52, judging whether a sub-part main data change event of the BOM affects a material main data standard according to the sub-part condition;

and S53, if yes, regenerating the material main data standard.

The extension attribute stored in the extension field is generated through the extension metadata, and assignment is set according to the metadata type and metadata of the extension metadata, and the characteristic attribute of the sub-piece main data of the BOM can be changed only by changing the extension attribute without changing the fixed field through frequently modifying codes, so that the sub-piece main data information of the BOM can be rapidly and flexibly maintained to respond to service change. When the expansion attribute of the sub-piece main data of the BOM is changed, the standard information of the material main data referring to the sub-piece main data of the BOM can be synchronously updated, and the linkage property and consistency of the material information of the first order and the BOM material information are realized.

For example, when the expansion attribute { "fieldName": "headband color", "fieldType": "option table", "extra": { "dataKey": "111", "dataValue": "black" } "of" headband TD01 "in table 4 is changed to {" fieldName ":" headband color "," fieldType ":" option table "," extra ": {" dataKey ":"111"," dataValue ":" red "}; at this time, the server will push the sub-piece main data change event of the BOM, and after the material main data standard generation server captures the change event, it is determined that the sub-piece main data change event of the BOM affects the swimming goggles 1 in table 4 (taking the material standard rule shown in table 3 as an example), so as to regenerate the material standard for the swimming goggles 1, wherein the swimming goggles standard is transparent/Shui Lan/red/".

In other embodiments, rule items may be added, and the rule item types may be set to text or running water, and the corresponding rule item settings may be referred to table 1 above; and then combining rule items in the embodiment of the application, and constructing the material main data standard more accurately and more in accordance with the service scene together through the ordering rule.

Referring to fig. 5, in response to the above-mentioned method for generating the master data standard of a material, an embodiment of the present application further provides a device for generating the master data standard of a material, where the device 100 includes: a definition unit 110, a first creation unit 120, a second creation unit 130, an acquisition unit 140, and a generation unit 150.

The defining unit 110 is configured to define naming rules of the materials;

a first creating unit 120, configured to create material main data and BOM sub-component main data;

a second creating unit 130, configured to create a BOM of the material main data according to the material main data and the BOM sub-part main data; the BOM comprises at least one hierarchy;

an obtaining unit 140, configured to obtain target content from sub-piece main data of the BOM according to the naming rule;

and the generating unit 150 is used for generating a material main data standard according to the naming rule and the target content.

The material main data standard generating device and the material main data standard generating method are in one-to-one correspondence, and the specific principle and process are the same as those of the method in the embodiment, and are not repeated.

Fig. 6 is a schematic structural diagram of a computer device according to the present application. The device may be a terminal or a server, where the terminal may be a smart phone, a tablet computer, a notebook computer, or a desktop computer. The server may be an independent server or a server cluster formed by a plurality of servers.

With reference to FIG. 6, the computer device 300 includes a processor 302, a non-volatile storage medium 303, an internal memory 304, and a network interface 305 connected by a system bus 301. The nonvolatile storage medium 303 of the computer apparatus 300 may store an operating system 3031 and a computer program 3032, where the computer program 3032, when executed, may cause the processor 302 to perform a method for generating a master data standard. The processor 302 of the computer device 300 is used to provide computing and control capabilities to support the operation of the entire computer device 300. The internal memory 304 provides an environment for the execution of a computer program 3032 in the non-volatile storage medium 303, which when executed by the processor causes the processor 302 to perform a method for generating master data patterns for materials. The network interface 305 of the computer device 300 is for network communication. It will be appreciated by those skilled in the art that the structure shown in FIG. 6 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.

The processor 302 is configured to execute a computer program stored in the memory 304 to implement the above-mentioned method for generating the material master data standard.

It should be appreciated that in embodiments of the present application, the processor 302 may be a central processing unit (Central Processing Unit, CPU), which may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSPs), application specific integrated circuits (application lication Specific Integrated Circuit, ASICs), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGAs) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.

The application also provides a computer readable storage medium, which stores one or more computer programs, and the one or more computer programs can be executed by one or more processors to realize the method for generating the main data standard of the material.

The aforementioned storage medium of the present application includes: various media capable of storing program codes, such as magnetic disk, optical disk, read-Only Memory (ROM), etc.

The units in all embodiments of the application may be implemented by a general-purpose integrated circuit, such as a CPU (Central processing unit)

Processing Unit, central Processing Unit), or by an ASIC (Application Specific Integrated Circuit ).

While the application has been described with reference to certain preferred embodiments, it will be understood by those skilled in the art that various changes and substitutions of equivalents may be made and equivalents will be apparent to those skilled in the art without departing from the scope of the application. Therefore, the protection scope of the application is subject to the protection scope of the claims.

Claims (10)

1. The method for generating the material main data standard is characterized by comprising the following steps:

defining naming rules of materials;

creating material main data and BOM sub-piece main data;

creating BOM of the material main data according to the material main data and the BOM sub-piece main data; the BOM comprises at least one hierarchy;

acquiring target content from the sub-piece main data of the BOM according to the naming rule;

and generating a material main data standard according to the naming rule and the target content.

2. The method for generating the material master data standard according to claim 1, wherein the naming rule comprises rule items and ordering rules among the rule items;

the obtaining the target content from the sub-piece main data of the BOM according to the naming rule comprises the following steps:

acquiring target content from the sub-piece main data of the BOM according to the rule item;

the generating the material main data standard according to the naming rule and the target content comprises the following steps:

and generating a material main data standard according to the ordering rule and the content of each rule item.

3. The material master data item rule generation method according to claim 2, wherein the rule items include rule item settings; the rule item setting comprises a sub-piece condition and a content selection setting;

the obtaining the target content from the sub-component main data of the BOM according to the rule item comprises the following steps:

acquiring sub-part main data of the target level BOM according to the sub-part conditions;

and acquiring target content from the sub-piece main data of the target level BOM according to the content selection setting.

4. The method of claim 3, wherein the sub-piece master data of the BOM includes a fixed field and an extension field; the fixed field and the extension field are stored in the same database record; the extension field is used for storing extension attributes; the extension attribute is generated through extension metadata; the extension metadata comprises metadata names, metadata types and metadata settings; the extended attribute carries out assignment according to the metadata type and metadata setting;

the content selection setting comprises an extension metadata name and a reference type;

obtaining target content from the sub-piece main data of the target level BOM according to the content selection setting comprises the following steps:

acquiring target extension attributes from the sub-piece main data according to the extension metadata names;

judging whether the target extension attribute exists or not;

if not, taking the null value as the target content;

if yes, acquiring target content from the target extension attribute according to the reference type.

5. The method for generating a master batch of material data according to claim 4, wherein the content selection setting further comprises a value condition and a corresponding value result;

after the target content is obtained from the target extension attribute according to the reference type, the method further comprises the following steps:

acquiring a corresponding value result according to the target content and the value condition;

judging whether the value result exists or not;

if yes, taking the value result as the final target content;

if not, the previous target content is taken as the final target content.

6. The method for generating a master batch of material according to claim 2, wherein the generating a master batch of material according to the ordering rule and contents of each rule item comprises:

optimizing the content of each rule item;

and generating a material main data standard according to the sorting rule and the optimized content of each rule item.

7. The method for generating a master batch of material according to claim 4, further comprising, after said generating a master batch of material according to said ordering rule and contents of each rule item:

acquiring a sub-piece main data change event of the BOM;

judging whether a sub-part main data change event of the BOM has an influence on a material main data standard according to the sub-part condition;

if yes, regenerating the main data standard of the material.

8. A material main data standard generation device is characterized by comprising:

the definition unit is used for defining naming rules of the materials;

the first creating unit is used for creating material main data and BOM sub-piece main data;

the second creating unit is used for creating BOM of the material main data according to the material main data and the BOM sub-piece main data; the BOM comprises at least one hierarchy;

the obtaining unit is used for obtaining target content from the sub-piece main data of the BOM according to the naming rule;

and the generating unit is used for generating a material main data standard according to the naming rule and the target content.

9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of generating a master data item according to any one of claims 1 to 7 when the computer program is executed by the processor.

10. A computer readable storage medium storing one or more computer programs executable by one or more processors to implement the method of generating a master data item according to any one of claims 1 to 7.