CN108665352B - Customer order information emergency processing method and device - Google Patents
Customer order information emergency processing method and device Download PDFInfo
- Publication number
- CN108665352B CN108665352B CN201810443902.0A CN201810443902A CN108665352B CN 108665352 B CN108665352 B CN 108665352B CN 201810443902 A CN201810443902 A CN 201810443902A CN 108665352 B CN108665352 B CN 108665352B
- Authority
- CN
- China
- Prior art keywords
- customer
- customer order
- order
- unproductive
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0603—Catalogue ordering
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a device for emergency processing of customer order information, relates to the technical field of information, and mainly aims to improve the arranging efficiency and accuracy of an assembly visual list and a sequencing shipping list. The method comprises the following steps: creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, and automatically generating a sequencing invoice according to a sequencing order value corresponding to the unproductive customer order number and the unproductive customer order information in the customer order information table; creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period; combining the order number of the unproductive customer and the part number of the customer in the basic data of the factory into a composite main key to be matched with the main key of the detail information table so as to analyze the description of the assembly part corresponding to the unproductive customer order; and generating an assembly visual list according to the assembly part description and the customer order information. The invention is suitable for emergency treatment of customer order information.
Description
Technical Field
The invention relates to the technical field of information, in particular to a method and a device for emergency processing of customer order information.
Background
With the continuous development of information technology, Electronic Data Interchange (EDI) has emerged. The issuance and reception of customer order information between factories and customers in the automotive industry is typically performed through EDI.
At present, when the EDI, the order information receiving system of the factory and the order issuing system of the customer have faults, the factory cannot acquire the order information of the customer and cannot analyze the order information of the customer to guide the factory to sequence and produce. Therefore, a factory needs to analyze customer order information in a manual mode and compile an assembly visual order and a sequencing shipping order in a manual mode, namely the factory generally needs to check and download the customer order information on a website where a customer publishes the order information and simultaneously needs to download customer order part detail information within a preset time period, then manually screens unproductive customer order information in the customer order information and manually pastes the unproductive customer order information into a sequencing shipping order template to obtain the sequencing shipping order, screens out assembly part detail information corresponding to the unproductive customer order according to the customer order part detail information, and manually pastes the assembly part detail information into an assembly visual order template to obtain the assembly visual order; and finally, printing a sequencing shipping bill and an assembly visual bill, wherein the assembly visual bill is used for guiding assembly production on a production site, and the sequencing shipping bill is used for guiding the production site to sequentially load the products into a shipping bin and then paste the products onto a bin appliance for shipping to a client.
However, if the customer order information is manually analyzed and the assembly visual note and the sorting shipping note are manually compiled, the arrangement time of the assembly visual note and the sorting shipping note is long, the arrangement accuracy of the assembly visual note and the sorting shipping note is low, the arrangement accuracy of the assembly visual note and the sorting shipping note is gradually reduced along with the time lapse, the risk of line stop of the customer is increased, and a factory needs to invest in work of compiling documents by multiple persons to meet the supply demand of the customer, so that the arrangement efficiency and accuracy of the assembly visual note and the sorting shipping note are low.
Disclosure of Invention
In view of this, the present invention provides a method and an apparatus for emergency processing of customer order information, and mainly aims to achieve automatic analysis of customer order information, and automatic compilation of an assembly visual note and a sequencing invoice, save the compilation time of the assembly visual note and the sequencing invoice, and reduce the compilation error rate of the assembly visual note and the sequencing invoice, thereby improving the compilation efficiency and accuracy of the assembly visual note and the sequencing invoice.
According to a first aspect of the present invention, there is provided a method for emergency processing of customer order information, comprising:
creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number;
generating a sequencing shipping bill according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer;
creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order;
and generating an assembly visual list according to the assembly part description and the customer order information.
According to a second aspect of the present invention, there is provided a customer order information emergency processing apparatus comprising:
the creating unit is used for creating a customer order information table according to the downloaded customer order information and the filled customer order number, and the ordering sequence value corresponding to the customer order number marked as unproductive in the customer order information table is larger than the ordering sequence value corresponding to the filled customer order number;
the generating unit is used for generating a sequencing invoice according to the sequencing sequence value corresponding to the unproductive customer order number and the unproductive customer order information;
the creating unit is further configured to create a customer order part detail information table according to the downloaded customer order part detail information in the predetermined time period, and a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
the analysis unit is used for combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table so as to analyze the assembly part description corresponding to the unproductive customer order;
the generating unit is further used for generating an assembly visual list according to the assembly part description and the customer order information.
According to a third aspect of the present invention, there is provided a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number;
generating a sequencing shipping bill according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer;
creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order;
and generating an assembly visual list according to the assembly part description and the customer order information.
According to a fourth aspect of the present invention, there is provided a customer order information emergency processing device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the program:
creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number;
generating a sequencing shipping bill according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer;
creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order;
and generating an assembly visual list according to the assembly part description and the customer order information.
The invention provides a customer order information emergency processing method and a device, compared with the existing method that customer order information is analyzed manually and an assembly visual note and a sequencing shipping note are compiled manually, the method can create a customer order information table according to the downloaded customer order information and the filled customer order number, wherein the sequencing sequence value corresponding to the order mark in the customer order information table is larger than the sequencing sequence value corresponding to the filled customer order number; and automatically generating a sequencing invoice according to the sequencing order value corresponding to the order number of the unproductive customer and the order information of the unproductive customer. Meanwhile, a customer order part detail information table can be created according to the downloaded customer order part detail information in the preset time period, and the main key of the customer order part detail information table is generated according to the customer order number and the customer part number in the customer order part detail information; the method can combine a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and match the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order; therefore, an assembly visual list can be automatically generated according to the assembly part description and the customer order information. Therefore, the arranging time of the assembly visual list and the sequencing invoice can be saved, the arranging error rate of the assembly visual list and the sequencing invoice is reduced, and the arranging efficiency and the arranging accuracy rate of the assembly visual list and the sequencing invoice can be improved.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 is a flow chart of a method for emergency handling of customer order information according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a calloff information table provided by an embodiment of the invention;
FIG. 3 illustrates a schematic diagram of a sequenced invoice provided by an embodiment of the present invention;
fig. 4 is a schematic diagram illustrating a TOD information table provided in an embodiment of the present invention;
FIG. 5 is a diagram illustrating a calloff information table update provided by an embodiment of the invention;
FIG. 6 illustrates a schematic diagram of a sorted pre-assembly table provided by an embodiment of the invention;
FIG. 7 is a schematic diagram of a plant base configuration table provided by an embodiment of the present invention;
FIG. 8 is a schematic diagram illustrating an assembled visual sheet provided by an embodiment of the present invention;
FIG. 9 is a schematic structural diagram of a customer order information emergency processing device according to an embodiment of the present invention;
FIG. 10 is a schematic structural diagram of another customer order information emergency processing device according to an embodiment of the present invention;
fig. 11 is a schematic physical structure diagram of a customer order information emergency processing device according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
An embodiment of the present invention provides a method for emergency processing of customer order information, as shown in fig. 1, where the method includes:
101. and creating a customer order information table according to the downloaded customer order information and the filled-in customer order number.
The customer order information can be downloaded at a customer website by an operator after an EDI (electronic data interchange), a factory order information receiving system or a customer order issuing system fails, the customer order information can comprise a customer order number and a sorting sequence value corresponding to the customer order number, and the sorting sequence value corresponding to the customer order number marked as unproductive in the customer order information table is greater than the sorting sequence value corresponding to the filled customer order number; in addition, the ordering sequence value corresponding to the order number marked as the produced customer order number in the customer order information table is smaller than or equal to the ordering sequence value corresponding to the filled customer order number.
It should be noted that the customer order information table may be a calloff information table, and fig. 2 shows a schematic diagram of the calloff information table, where an order mark "C" is a produced identifier and an order mark "P" is an unproductive identifier. The customer order number in the calloff information table is the value corresponding to the "OrderNumber" field in the customer order information. In addition, the execution subject of the embodiment of the present invention may specifically be customer order information receiving emergency software.
102. And generating a sequencing shipping bill according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer.
It should be noted that the unproductive customer order information may be looked up from the customer order information table according to the unproductive customer order number, and fig. 3 provides a schematic diagram of a sorted invoice, and compared with the prior art that unproductive customer order information is manually screened and the sorted invoice is manually compiled, the embodiment of the present invention can automatically compile the sorted invoice.
103. And creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period.
The customer order part detail information may be downloaded at a customer website by an operator after a fault occurs in an EDI system, a factory received order information system, or a customer issuing order system, and the primary key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information. The customer order part detail information table may be a TOD information table, and fig. 4 shows a schematic diagram of the TOD information table.
104. And combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order.
For the embodiment of the present invention, the specific process of step 104 may be: and if the composite main key and the main key in the customer order part detail information table show, the part description in the plant basic data uniquely determined by the composite main key is shown, and is the assembly part description corresponding to the non-produced customer order. Compared with the prior art that the assembling part description corresponding to the unproductive customer order is analyzed in a manual mode, the assembling part description corresponding to the unproductive customer order can be automatically analyzed, and therefore the analyzing efficiency of the assembling part description corresponding to the unproductive customer order can be improved.
105. And generating an assembly visual list according to the assembly part description and the customer order information.
Compared with the conventional method for analyzing the customer order information in a manual mode and compiling an assembly visual note and a sequencing shipping note in a manual mode, the method for processing the customer order information in an emergency provided by the embodiment of the invention can create a customer order information table according to the downloaded customer order information and the filled customer order number, wherein the sequencing sequence value corresponding to the customer order number marked as unproductive in the customer order information table is larger than the sequencing sequence value corresponding to the filled customer order number; and automatically generating a sequencing invoice according to the sequencing order value corresponding to the order number of the unproductive customer and the order information of the unproductive customer. Meanwhile, a customer order part detail information table can be created according to the downloaded customer order part detail information in the preset time period, and the main key of the customer order part detail information table is generated according to the customer order number and the customer part number in the customer order part detail information; the method can combine a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and match the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order; therefore, an assembly visual list can be automatically generated according to the assembly part description and the customer order information. Therefore, the arranging time of the assembly visual list and the sequencing invoice can be saved, the arranging error rate of the assembly visual list and the sequencing invoice is reduced, and the arranging efficiency and the arranging accuracy rate of the assembly visual list and the sequencing invoice can be improved.
Further, in order to better illustrate the process of emergency processing of the customer order information, as a refinement and an extension to the above embodiment, the embodiment of the present invention provides several alternative embodiments, but is not limited to this, and specifically, the following embodiments are provided:
in one embodiment of the invention, a specific process for creating a customer order information table is provided: the client order numbers in the client order information and the corresponding sequencing order values are stored as the client order numbers in the newly-built client order information data table and the corresponding sequencing order values; and searching a first sequencing order value corresponding to the filled customer order number, determining that the order mark of the customer order number with the sequencing order value larger than the first sequencing order value in the customer order information data table is not produced, and determining that the order mark of the customer order number with the sequencing order value smaller than or equal to the first sequencing order value in the customer order information data table is produced.
For example, a work table may be created and named as "calloff information table", and at the same time, the table area header may be edited: finally, the order, the order mark, and the customer order number are printed in sequence, as shown in fig. 2, the value of the order Seq in the calloff information table may be obtained by querying the customer order information for the corresponding order Seq according to the last printed order and returning to the write cell, and specifically, may be returned to the write cell by the formula expression VLOOKUP (B1, $ C $4: $ J $2000,8, 0). The customer Order number in the calloff information table may be an Order field value in the customer Order information, and the formula expression is L4 (relative reference). The order identifier in the calloff information table can be determined by the following formula expression:
the formula expression is IF (OR (J4< $ B $2, J4 $ B $2), IF (C4 ═ 0, "C"), "P") (relative reference).
In addition, the embodiment of the present invention may further update the calloff information table, and specifically, the calloff table and the customer order information document workbook may be established with data continuity through a function of "connect under data" module in Microsoft Excel, and the connection attribute is set to allow background refresh, and the refresh frequency is 5min (as shown in fig. 5). The information in the original order information area in the Calloff information table establishes data flow connection with the downloaded customer order information, and the data is updated every 5 minutes.
In another embodiment of the invention, a specific process of the customer order part detail information table is provided: storing the downloaded customer order part detail information in the preset time period into a newly-built customer order part detail information table; and generating a main key of the customer order part detail information table according to the customer order number and the customer part number in the customer order part detail information. Specifically, as shown in fig. 4, the primary key formula expression ═ MID (M2,1,7) & P2& "-" & O2 (relative reference).
In another embodiment of the present invention, the step 102 may specifically include: selecting the order number of the unproductive customer according to the order number of the unproductive customer and the part boxing quantity specified by the customer, and adding the selected order number of the unproductive customer into a sorting preassembly table in a descending manner according to the corresponding sorting sequence value; searching unproductive customer order information from the customer order information table according to the sorting information corresponding to the serial number in the sorting preset table; and transmitting the unproductive customer order information to a printing template of the sequencing invoice drawn according to the requirements of the factory to generate the sequencing invoice.
It should be noted that the sorting pre-assembly table may be created in advance, and may be used to display a customer order, and the design style of the sorting pre-assembly table may be as shown in fig. 6, including: the emergency pre-ordering window comprises a cut-off ordering number, a single ordering number, a cut-off BIN number, a single ordering BIN number, a current BIN number, a serial number, an ordering single number, a part description, a customer order number and a Check Seq, and can also comprise refreshing and order printing buttons. Wherein, the current BIN number can be edited as follows: the current BIN number is the upper single BIN number + 1, the highest BIN number value is 99, and the current BIN number restarts from 1 when the upper single BIN number is 99. The formula expression is IF (F3 is 99,1, F3+ 1). In this example, a single box is called a BIN, and the unproductive customer orders in the Calloff information table are shown in the sort pre-assembly table in descending order of Check Seq value in the customer order information, according to the customer-specified part packing quantity, as shown in fig. 6, where:
formula expression ═ OFFSET (calloff information! L4, COUNTIF (calloff information! $ B $4: $ B $2000, "C") +3,0)
formula expression ═ OFFSET (calloff information! L4, COUNTIF (calloff information! $ B $4: $ B $2000, "C") +2,0)
formula expression ═ OFFSET (calloff information! L4, COUNTIF (calloff information! $ B $4: $ B $2000, "C") +1,0)
formula expression ═ OFFSET (calloff information! L4, COUNTIF (calloff information! $ B $4: $ B $2000, "C"),0)
The process of generating the sorted invoice may specifically be: the sequencing information value setting obtains sequencing information, namely, checkseq, order number ═ order number, "checkseq", color ═ color ", corresponding to the serial numbers 1, 2, 3 and 4 in the current sequencing preassembly table"
Formula expression sorting preassembly! L9 (other cell relative referencing formula), as shown in fig. 6.
sequence number and swet values are the EINSTEIN Seq, SWETTime and SWETDate values corresponding to the Order values in the Calloff information table and are returned to the write-in cell.
The sequence number formula expression OFFSET (calloff information! K4, COUNTIF (calloff information! $ B $4: $ B $2000, "C") +1,0)
The swet formula expression is OFFSET (calloff information! H4, COUNTIF (calloff information! $ B $4: $ B $2000, "C") +1,0)
The formula expression is OFFSET (calloff information! I4, COUNTIF (calloff information! $ B $4: $ B $2000, "C") +1,0) (other cells versus the reference formula).
In yet another embodiment of the present invention, before the step 104, the method further comprises: and maintaining the basic data of the factory to a basic data maintenance area of a compiled basic configuration table of the factory, and maintaining the unproductive customer order numbers in the sequencing preassembly table to a customer order analysis area of the basic configuration table of the factory according to the sequence of the corresponding serial numbers. Specifically, a new work table may be added, and the work table may be renamed as a factory basic configuration table, and the title name contents 1, 2, 3, 4, type, part number, unit, and part description are added, as shown in fig. 7, basic information corresponding to the type, part number, unit, and part description of the customer part number in the factory is maintained in the basic data maintenance area of the prepared factory basic configuration table. A, B, C, D above the customer order information analysis area, the corresponding filling numbers 1, 2, 3 and 4 below each column are used for representing the corresponding serial number in the sorting preassembly table, the numerical value below each row takes the order number of the row corresponding to the serial number of the sorting preassembly window, and the formula expression is sorting preassembly! $ F $8 (other relative references).
The corresponding step 104 may specifically include: combining the unproductive customer order number in each column in the customer order analysis area and the customer part number in the basic data area into a composite main key; matching the composite main key with the main key in the customer order part detail information table; and if so, returning a matching mark at the unique position corresponding to the composite main key on the customer order analysis area, and determining the part description of the row where the matching mark is positioned as the assembly part description corresponding to the unproductive customer order. For example, the order number of each column in the analysis area and the part number in the basic data are combined into a composite primary key and matched with the primary key value in the TOD information table, if the configuration is consistent, the value "11" is returned, and if the configuration is not consistent, the value is returned to be null. Specifically, the matching can be performed by the formula expression ═ IFERROR (VLOOKUP ($ D $2, F3), TOD info table! $ A $2: $ G $20000,7,0), "") (other relative references). And then, the mark of the specified area of the column where the corresponding serial numbers 1, 2, 3 and 4 of the customer order information analysis area in the factory basic configuration table are located is a value of '11', and a part description value of the row where the value of '11' is located is returned, so that a main part 'description' value is obtained. Other part descriptions corresponding to the customer order number are also queried and written into the cell by the same logic described above, hidden from display on the window interface, as described in the description of FIG. 6.
In yet another embodiment of the present invention, the step 105 may specifically include: adding the assembly part description to the sorting preassembly table according to the corresponding customer order number; and transmitting the assembly part description to an assembly visual form printing template drawn according to the factory requirement according to the sorting sequence corresponding to the serial number in the sorting preassembly table to generate an assembly visual form. As shown in fig. 8, a schematic diagram of an assembly visual is shown, in which the description of the assembly parts can be determined by sorting preassembly tables and formulation expression (OFFSET | $ M $6, sorting preassembly | L4-1, 0).
For the embodiment of the invention, the automatic printing of the sorted shipping orders and the assembly visual orders can also be realized, and the method further comprises the following steps: and when a group list printing instruction is received, printing the sequencing shipping bill and the assembly visual bill.
In the embodiment of the invention, firstly, the printing of the 'sorting shipping Order' is executed, then the 'printing sequence' value of the sorting preassembly table is modified, the 'assembly visual Order' is printed, the 'printing sequence' value and the 'assembly visual Order' are repeatedly modified, after the 'assembly visual Order' of all customer orders in the 'sorting shipping Order' is printed, the 'current BIN number' value is pasted to the 'upper Order BIN number' value, the 'sorting Order number' is copied and pasted to the 'upper Order serial number' value, the 'Order number' value corresponding to the 'serial number' 4 is copied and pasted to the 'last printed Order' value in the 'Calloff information table', the display window corresponding to the sorting preassembly is returned, the function is associated to the button 'group Order printing', the assembly visual Order and the sorting shipping Order are automatically printed after the 'group Order printing' button is clicked, and the customer orders printed by the group Order are marked, and updating new group list ordering information. Through sequencing the display windows corresponding to the preassembly, the client order information required to be produced at present can be visually displayed, and system operation and information checking of operators are facilitated. By compiling the automatic ordering list printing function, the automatic printing of the assembly visual list and the ordering invoice can be realized, the automatic number increase of the ordering invoice number and the BIN number can be realized, the customer orders of which are printed with the assembly visual list and the ordering invoice can be automatically marked, and the new customer order information can be displayed.
Further, as a specific implementation of fig. 1, an embodiment of the present invention provides a customer order information emergency processing apparatus, as shown in fig. 9, where the apparatus includes: a creation unit 21, a generation unit 22 and an analysis unit 23.
The creating unit 21 may be configured to create a customer order information table according to the downloaded customer order information and the filled-in customer order number, where a sorting order value corresponding to a customer order number marked as unproductive in the customer order information table is greater than a sorting order value corresponding to the filled-in customer order number. The creating unit 21 is a main function module in the present apparatus that creates a customer order information table based on the downloaded customer order information and the filled-in customer order number.
The generating unit 22 may be configured to generate a sort invoice according to the sort order value corresponding to the order number of the unproductive customer and the information of the unproductive customer order. The generating unit 22 is a main functional module in the present apparatus that generates a sorted invoice according to the sorting order value corresponding to the order number of the unproductive customer and the information of the unproductive customer order.
The creating unit 21 may be further configured to create a customer order part detail information table according to the downloaded customer order part detail information in the predetermined time period, where a primary key of the customer order part detail information table is generated according to the customer order number and the customer part number in the customer order part detail information. The creating unit 21 is a main function module of the apparatus according to the downloaded part detail information of the customer order in the predetermined time period.
The analyzing unit 23 may be configured to combine a composite main key according to the unproductive customer order number and the customer part number in the plant basic data, and match the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order. The analysis unit 23 is a main function module that combines the unproductive customer order number and the customer part number in the plant basic data into a composite main key in the present apparatus, and matches the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order.
The generating unit 22 may be further configured to generate an assembly visual list according to the assembly part description and the customer order information. The generating unit 22 is also a main function module of the present apparatus that generates an assembly visual list according to the assembly part description and the customer order information.
The generating unit 22 is specifically configured to select the order number of the unproductive customer according to the order number of the unproductive customer and the component packing number specified by the factory, and add the selected order number of the unproductive customer to the sorting preassembly table in a descending manner according to the corresponding sorting order value;
searching unproductive customer order information from the customer order information table according to the sorting information corresponding to the serial number in the sorting preset table;
and transmitting the unproductive customer order information to a printing template of the sequencing invoice drawn according to the requirements of the factory to generate the sequencing invoice.
For the embodiment of the present invention, the apparatus further includes: a maintenance unit 24, as shown in fig. 10.
The maintenance unit 24 is configured to maintain the plant basic data in a basic data maintenance area of a compiled plant basic configuration table, and maintain the unproductive customer order numbers in the sorted pre-assembly table in a customer order analysis area of the plant basic configuration table according to a sequence of corresponding serial numbers;
the analysis unit 23 is specifically configured to combine an unproductive customer order number in each column in the customer order analysis region and a customer part number in the basic data region into a composite main key;
matching the composite main key with the main key in the customer order part detail information table;
and if so, returning a matching mark at the unique position corresponding to the composite main key on the customer order analysis area, and determining the part description of the row where the matching mark is positioned as the assembly part description corresponding to the unproductive customer order.
The generating unit 22 may be specifically configured to add the assembled part description to the sorting pre-assembly table according to a corresponding customer order number; and transmitting the assembly part description to an assembly visual form printing template drawn according to the factory requirement according to the sorting sequence corresponding to the serial number in the sorting preassembly table to generate an assembly visual form.
In a specific application scenario, in order to create a customer order information table, the creating unit 21 may be specifically configured to store a customer order number and a corresponding sorting order value in the customer order information as a customer order number and a corresponding sorting order value in a newly-created customer order information data table; and searching a first sequencing order value corresponding to the filled customer order number, determining that the order mark of the customer order number with the sequencing order value larger than the first sequencing order value in the customer order information data table is not produced, and determining that the order mark of the customer order number with the sequencing order value smaller than or equal to the first sequencing order value in the customer order information data table is produced.
In a specific application scenario, for a customer order part detail information table, the creating unit 21 may be further configured to store the downloaded customer order part detail information within a predetermined time period into a newly-created customer order part detail information table; and generating a main key of the customer order part detail information table according to the customer order number and the customer part number in the customer order part detail information.
For the embodiment of the present invention, in order to realize automatic printing of the sorted shipping orders and the assembly visual orders, the apparatus further comprises: a printing unit 25.
And the printing unit 25 is used for printing the sequencing shipping bill and the assembly visual bill after receiving a group bill printing instruction.
It should be noted that other corresponding descriptions of the functional modules related to the customer order information emergency processing device provided in the embodiment of the present invention may refer to the corresponding description of the method shown in fig. 1, and are not described herein again.
Based on the method shown in fig. 1, correspondingly, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the following steps: creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number; generating a sequencing shipping bill according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer; creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information; combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order; and generating an assembly visual list according to the assembly part description and the customer order information.
Based on the above embodiments of the method shown in fig. 1 and the apparatus shown in fig. 9, an embodiment of the present invention further provides an entity structure diagram of a customer order information emergency processing apparatus, as shown in fig. 11, the apparatus includes: a processor 31, a memory 32, and a computer program stored on the memory 32 and executable on the processor, wherein the memory 32 and the processor 31 are both arranged on a bus 33 and the processor 31 implements the following steps when the processor 31 executes the program: creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number; generating a sequencing shipping bill according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer; creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information; combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order; and generating an assembly visual list according to the assembly part description and the customer order information. The device also includes: a bus 43 configured to couple the processor 41 and the memory 42.
According to the technical scheme, a customer order information table can be created according to downloaded customer order information and filled customer order numbers, and the ordering sequence value corresponding to the customer order number marked as unproductive in the customer order information table is larger than the ordering sequence value corresponding to the filled customer order number; and automatically generating a sequencing invoice according to the sequencing order value corresponding to the order number of the unproductive customer and the order information of the unproductive customer. Meanwhile, a customer order part detail information table can be created according to the downloaded customer order part detail information in the preset time period, and the main key of the customer order part detail information table is generated according to the customer order number and the customer part number in the customer order part detail information; the method can combine a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and match the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order; therefore, an assembly visual list can be automatically generated according to the assembly part description and the customer order information. Therefore, the arranging time of the assembly visual list and the sequencing invoice can be saved, the arranging error rate of the assembly visual list and the sequencing invoice is reduced, and the arranging efficiency and the arranging accuracy rate of the assembly visual list and the sequencing invoice can be improved.
In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
It will be appreciated that the relevant features of the method and apparatus described above are referred to one another. In addition, "first", "second", and the like in the above embodiments are for distinguishing the embodiments, and do not represent merits of the embodiments.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The algorithms and displays presented herein are not inherently related to any particular computer, virtual machine, or other apparatus. Various general purpose systems may also be used with the teachings herein. The required structure for constructing such a system will be apparent from the description above. Moreover, the present invention is not directed to any particular programming language. It is appreciated that a variety of programming languages may be used to implement the teachings of the present invention as described herein, and any descriptions of specific languages are provided above to disclose the best mode of the invention.
In the description provided herein, numerous specific details are set forth. It is understood, however, that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be interpreted as reflecting an intention that: that the invention as claimed requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules in the device in an embodiment may be adaptively changed and disposed in one or more devices different from the embodiment. The modules or units or components of the embodiments may be combined into one module or unit or component, and furthermore they may be divided into a plurality of sub-modules or sub-units or sub-components. All of the features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or elements of any method or apparatus so disclosed, may be combined in any combination, except combinations where at least some of such features and/or processes or elements are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings) may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments described herein include some features included in other embodiments, rather than other features, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments may be used in any combination.
The various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. It will be appreciated by those skilled in the art that a microprocessor or Digital Signal Processor (DSP) may be used in practice to implement some or all of the functions of some or all of the components in a customer order information emergency processing apparatus according to embodiments of the present invention. The present invention may also be embodied as apparatus or device programs (e.g., computer programs and computer program products) for performing a portion or all of the methods described herein. Such programs implementing the present invention may be stored on computer-readable media or may be in the form of one or more signals. Such a signal may be downloaded from an internet website or provided on a carrier signal or in any other form.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.
Claims (9)
1. A customer order information emergency processing method is characterized by comprising the following steps:
creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number;
generating a sequencing invoice according to the sequencing sequence value corresponding to the order number of the unproductive customer and the order information of the unproductive customer, wherein the sequencing invoice comprises the following steps: selecting the order number of the unproductive customer according to the order number of the unproductive customer and the part boxing quantity specified by the customer, and adding the selected order number of the unproductive customer into a sorting preassembly table in a descending manner according to the corresponding sorting sequence value; searching unproductive customer order information from the customer order information table according to the sorting information corresponding to the serial number in the sorting preset table; transmitting the unproductive customer order information to a sequencing invoice printing template drawn according to the requirements of a factory to generate a sequencing invoice;
creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order;
and generating an assembly visual list according to the assembly part description and the customer order information.
2. The method of claim 1, wherein prior to said combining into a composite primary key based on said unproductive customer order number and a customer part number in the plant base data, the method further comprises:
maintaining the basic data of the factory to a basic data maintenance area of a compiled basic configuration table of the factory, and maintaining the unproductive customer order numbers in the sequencing preassembly table to a customer order analysis area of the basic configuration table of the factory according to the sequence of corresponding serial numbers;
the step of combining the unproductive customer order number and the customer part number in the factory basic data into a composite main key and matching the composite main key with the main key in the customer order part detail information table comprises the following steps:
combining the unproductive customer order number in each column in the customer order analysis area and the customer part number in the basic data maintenance area into a composite main key;
matching the composite main key with the main key in the customer order part detail information table;
and if so, returning a matching mark at the unique position corresponding to the composite main key on the customer order analysis area, and determining the part description of the row where the matching mark is positioned as the assembly part description corresponding to the unproductive customer order.
3. The method of claim 2, wherein generating an assembly visual from the parsed assembly part description and the customer order information comprises:
adding the assembly part description to the sorting preassembly table according to the corresponding customer order number;
and transmitting the assembly part description to an assembly visual form printing template drawn according to the factory requirement according to the sorting sequence corresponding to the serial number in the sorting preassembly table to generate an assembly visual form.
4. The method of claim 1, wherein creating a customer order information table based on the downloaded customer order information and the filled-in customer order number comprises:
the client order numbers in the client order information and the corresponding sequencing order values are stored as the client order numbers in the newly-built client order information data table and the corresponding sequencing order values;
and searching a first sequencing order value corresponding to the filled customer order number, determining that the order mark of the customer order number with the sequencing order value larger than the first sequencing order value in the customer order information data table is not produced, and determining that the order mark of the customer order number with the sequencing order value smaller than or equal to the first sequencing order value in the customer order information data table is produced.
5. The method of claim 1, wherein creating a customer order part detail information table based on the downloaded customer order part detail information for the predetermined time period comprises:
storing the downloaded customer order part detail information in the preset time period into a newly-built customer order part detail information table;
and generating a main key of the customer order part detail information table according to the customer order number and the customer part number in the customer order part detail information.
6. The method according to any one of claims 1-5, further comprising:
and when a group list printing instruction is received, printing the sequencing shipping bill and the assembly visual bill.
7. A customer order information emergency processing apparatus, comprising:
the creating unit is used for creating a customer order information table according to the downloaded customer order information and the filled customer order number, and the ordering sequence value corresponding to the customer order number marked as unproductive in the customer order information table is larger than the ordering sequence value corresponding to the filled customer order number;
the generating unit is used for generating a sequencing invoice according to the sequencing order value corresponding to the unproductive customer order number and the unproductive customer order information, and comprises the following steps: selecting the order number of the unproductive customer according to the order number of the unproductive customer and the part boxing quantity specified by the customer, and adding the selected order number of the unproductive customer into a sorting preassembly table in a descending manner according to the corresponding sorting sequence value; searching unproductive customer order information from the customer order information table according to the sorting information corresponding to the serial number in the sorting preset table; transmitting the unproductive customer order information to a sequencing invoice printing template drawn according to the requirements of a factory to generate a sequencing invoice;
the creating unit is further configured to create a customer order part detail information table according to the downloaded customer order part detail information in the predetermined time period, and a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
the analysis unit is used for combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table so as to analyze the assembly part description corresponding to the unproductive customer order;
the generating unit is further used for generating an assembly visual list according to the assembly part description and the customer order information.
8. A computer-readable storage medium, on which a computer program is stored, which program, when executed by a processor, carries out the steps of:
creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number;
generating and printing a sequencing invoice according to the sequencing order value corresponding to the order number of the unproductive customer and the order information of the unproductive customer, comprising the following steps: selecting the order number of the unproductive customer according to the order number of the unproductive customer and the part boxing quantity specified by the customer, and adding the selected order number of the unproductive customer into a sorting preassembly table in a descending manner according to the corresponding sorting sequence value; searching unproductive customer order information from the customer order information table according to the sorting information corresponding to the serial number in the sorting preset table; transmitting the unproductive customer order information to a sequencing invoice printing template drawn according to the requirements of a factory to generate a sequencing invoice;
creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order;
and generating and printing an assembly visual list according to the assembly part description and the customer order information.
9. A customer order information emergency processing apparatus comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program implements the steps of:
creating a customer order information table according to the downloaded customer order information and the filled customer order numbers, wherein the order marks in the customer order information table are that the ordering sequence value corresponding to the unproductive customer order number is larger than the ordering sequence value corresponding to the filled customer order number;
generating and printing a sequencing invoice according to the sequencing order value corresponding to the order number of the unproductive customer and the order information of the unproductive customer, comprising the following steps: selecting the order number of the unproductive customer according to the order number of the unproductive customer and the part boxing quantity specified by the customer, and adding the selected order number of the unproductive customer into a sorting preassembly table in a descending manner according to the corresponding sorting sequence value; searching unproductive customer order information from the customer order information table according to the sorting information corresponding to the serial number in the sorting preset table; transmitting the unproductive customer order information to a sequencing invoice printing template drawn according to the requirements of a factory to generate a sequencing invoice;
creating a customer order part detail information table according to the downloaded customer order part detail information in the preset time period, wherein a main key of the customer order part detail information table is generated according to a customer order number and a customer part number in the customer order part detail information;
combining a composite main key according to the unproductive customer order number and the customer part number in the factory basic data, and matching the composite main key with the main key in the customer order part detail information table to analyze the assembly part description corresponding to the unproductive customer order;
and generating and printing an assembly visual list according to the assembly part description and the customer order information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810443902.0A CN108665352B (en) | 2018-05-10 | 2018-05-10 | Customer order information emergency processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810443902.0A CN108665352B (en) | 2018-05-10 | 2018-05-10 | Customer order information emergency processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108665352A CN108665352A (en) | 2018-10-16 |
| CN108665352B true CN108665352B (en) | 2022-04-05 |
Family
ID=63779009
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810443902.0A Active CN108665352B (en) | 2018-05-10 | 2018-05-10 | Customer order information emergency processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108665352B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101329746A (en) * | 2007-06-22 | 2008-12-24 | 鸿富锦精密工业（深圳）有限公司 | System and method for automatically arranging production plan |
| CN102034155A (en) * | 2010-12-17 | 2011-04-27 | 武汉钢铁(集团)公司 | Data processing method for automatic burdening of hot-rolling slab |
| CN102902812A (en) * | 2012-10-22 | 2013-01-30 | 飞天诚信科技股份有限公司 | Method for realizing remote synchronization of database |
| CN106094748A (en) * | 2016-06-08 | 2016-11-09 | 合肥工业大学 | Engineering goods assembly shop's material based on MES system calling and delivery management system and method |
| CN106372994A (en) * | 2016-08-31 | 2017-02-01 | 北京炎黄新星网络科技有限公司 | Method and system for processing orders |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102841916B (en) * | 2005-01-28 | 2016-12-14 | 美国联合包裹服务公司 | The registration of address date and the method and system of maintenance about each service point in area |
| EP2731040B1 (en) * | 2012-11-08 | 2017-04-19 | CompuGroup Medical SE | Computer system for storing and retrieval of encrypted data items, client computer, computer program product and computer-implemented method |
| CN103971187A (en) * | 2013-01-24 | 2014-08-06 | 苏州易瑞得电子科技有限公司 | Automatic production plan generation method and system based on RFID |
| CN106020146A (en) * | 2016-05-19 | 2016-10-12 | 中国重汽集团成都王牌商用车有限公司 | Method preventing assembling error in automobile manufacture process |
| CN106228458A (en) * | 2016-07-11 | 2016-12-14 | 武汉法利莱切焊系统工程有限公司 | A kind of method and apparatus using Excel form to import the processing of data genaration part |
-
2018
- 2018-05-10 CN CN201810443902.0A patent/CN108665352B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101329746A (en) * | 2007-06-22 | 2008-12-24 | 鸿富锦精密工业（深圳）有限公司 | System and method for automatically arranging production plan |
| CN102034155A (en) * | 2010-12-17 | 2011-04-27 | 武汉钢铁(集团)公司 | Data processing method for automatic burdening of hot-rolling slab |
| CN102902812A (en) * | 2012-10-22 | 2013-01-30 | 飞天诚信科技股份有限公司 | Method for realizing remote synchronization of database |
| CN106094748A (en) * | 2016-06-08 | 2016-11-09 | 合肥工业大学 | Engineering goods assembly shop's material based on MES system calling and delivery management system and method |
| CN106372994A (en) * | 2016-08-31 | 2017-02-01 | 北京炎黄新星网络科技有限公司 | Method and system for processing orders |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108665352A (en) | 2018-10-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6662237B1 (en) | System for documenting application interfaces and their mapping relationship | |
| US9311432B1 (en) | Automated design and manufacturing of complex layouts | |
| Lian et al. | Analysing the effects of Lean manufacturing using a value stream mapping-based simulation generator | |
| CN109857667A (en) | Automatic interface testing method, test device, test equipment and storage medium | |
| US7478352B2 (en) | Method for creating box level groupings of components and connections in a dynamic layout system | |
| CN109840732B (en) | Checking system for integrity of whole vehicle configurable bill of materials under free selection and matching condition | |
| EP1686466A1 (en) | Process automation | |
| US20050034058A1 (en) | Flexible multiple spreadsheet data consolidation system | |
| CN105808437A (en) | Automation testing method and system based on test case data table | |
| CN104657274B (en) | software interface test method and device | |
| US8521614B1 (en) | Metadata-driven merchant feed processing system | |
| EP2043013A1 (en) | Data mapping document design system | |
| JP2007304660A (en) | Command execution result recording system and command execution result recording method | |
| CN107464083B (en) | Method, device and equipment for generating bill of materials | |
| CN111311080A (en) | Order detection revision method and device, electronic equipment and computer readable medium | |
| US20110144786A1 (en) | Material management system and method for retooling and producing a manufacturing line | |
| CN108665352B (en) | Customer order information emergency processing method and device | |
| CN113077266A (en) | Traceable information boxing method and system | |
| TWI228228B (en) | An assisting system for locating problems existing in parts supply chains and methods and programs therefore | |
| CN106570004B (en) | Data management method and device | |
| CN108021367B (en) | UI development system and method based on metadata framework | |
| WO2009036398A2 (en) | System and method for a product definition | |
| Bryan et al. | The point of PDM | |
| KR20170055379A (en) | Purchase price forecasting methods for new developments utilizing the ERP database | |
| JP5706248B2 (en) | Product handling standard creation system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |