JP2011242859A - Integrated order management system and order acceptance and placement data delivery linking method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an integrated order management system for achieving an integrated order management at a low cost without constraints, and an order acceptance and placement data delivery linking method.SOLUTION: Order acceptance information including merchandise identification information, department identification information for identifying a department that has accepted an order of a merchandise and merchandise department identification information for identifying a department that originally accepts the order of the merchandise is received S1105. Each department identification information and address information of a core server of each department are stored in association, each department identification information and a distribution rate for distributing profits generated by order acceptance between departments are stored in association, each department identification information and tag information for attaining a format that can be processed by each core server are stored in association, and when the department identification information and the merchandise department identification information do not match, the profits of the merchandise are distributed between the respective departments on the basis of the distribution rate S1106. An order acceptance file for performing an order acceptance processing by the core server of each department is generated on the basis of the distributed profits, the order acceptance information and the tag information, and is transmitted to each core server on the basis of the address information. In each department, the order acceptance processing is performed and the sales of the merchandise are added up.

Description

  The present invention relates to an integrated order management system for receiving and ordering products and the like between host computers, and an order data delivery linkage method.

  Conventionally, companies that have established a core system between other departments within the same company have been scattered in the management of merchandise inventory, and it has been necessary to process products between each department through in-house sales. Therefore, the products handled in other departments cannot be directly sold at the time of sale, making it difficult to promote sales. In addition, there is a method to integrate the core system, but it takes time and cost to prepare for dealing with the reform of mature business operation and the accompanying infrastructure development. It is difficult to promote sales promotion from the situation. For this reason, there has been a problem of realizing a system for performing an inexpensive integrated order management utilizing a mature business backbone system.

  In recent years, new technologies for exchanging data between systems have become widespread, and data delivery cooperation technology based on XML (Extensible Markup Language) communication has become widespread. For example, Patent Document 1 proposes a technique that represents such infrastructure equipment.

Japanese Patent Laid-Open No. 2002-083157

  Data delivery cooperation functions such as product information, order information, ordering information, and inventory correction information are often implemented after an operation agreement is made between host computers, and the order cooperation function that is unique to the core system is also fixed. Implemented on each host computer with restrictions. On the other hand, in recent data delivery collaboration technologies, delivery collaboration technologies using XML have become widespread, and the use of the Internet has produced a cost reduction effect on communication costs. However, inter-company EDI (Electronic Data Interchange) with certain standards Many are specialized in technology. Therefore, there is a problem that the cost of introduction becomes high with the restriction that it must be created independently when applied between host computers of the same company. However, no mention is made of the above problems and techniques for solving them.

  The present invention has been made in view of the above circumstances. For example, in communication between host computers in the same company, an integrated order management system that realizes integrated order management at a low cost without any constraints, and ordering / ordering An object is to provide a data delivery linkage method.

  In order to solve the above-described problems and achieve the object, the integrated order management system according to the present invention is an integrated order management system that manages products ordered by each department, and the integrated management server identifies the products. Input order information including product identification information for identifying, department identification information for identifying a department that has received an order for the product, and product department identification information for identifying a product department that originally received the product An input receiving unit for receiving, an address information storage unit for storing the department identification information or the product department identification information, and address information of the backbone server of the product that each of the department or the product department has, Department identification information or the product department identification information, and a distribution rate for distributing profits generated by the ordered product between the department and the product department A distribution information storage unit for storing the correspondence, a mapping storage unit for storing the department identification information or the product department identification information, and tag information for making a format that can be processed by each of the core servers in association with each other; When the input receiving unit receives the input of the order information, it is determined whether or not the department identification information and the product department identification information match, and the department identification information and the product department identification information are When it is determined that they do not match, the profit of the product is distributed between the department and the product department based on the distribution ratio, the profit of the department or the product department distributed, the order information, and the tag information The department order file for the core server of the department to process the order for the product, and the quotient for the core server of the product department to process the order for the product. Integrated control for generating a department order file, transmitting the generated department order file to the backbone server of the department based on the address information, and transmitting the generated product department order file to the backbone server of the product department The department order server receives the department order file, performs the order processing based on the order information included in the received department order file and the profits of the distributed department, A first product control unit that performs sales processing for recording the sales of the product, the core server of the product department receives the product department order file, and the order information included in the received product department order file And a second product control unit for performing a sales process for performing the order processing based on the distributed profit of the product department and recording the sales of the product. It is characterized by that.

  Moreover, this invention is the ordering / ordering data delivery cooperation method performed with the said integrated order management system.

  According to the present invention, it is possible to provide an integrated order management system that realizes integrated order management at a low cost without any constraints, and an ordering data delivery cooperation method.

It is a figure which shows the integrated order management server whole outline | summary. It is a figure which shows an integrated order management server summary. It is a figure which shows the basic system A outline | summary. 2 is a diagram showing an outline of a backbone system B. FIG. It is a figure which shows a user terminal outline | summary. It is a figure which shows the example of backbone connection TBL. It is a figure which shows the example of profit distribution rate TBL. It is a figure which shows the example of integrated order history TBL. It is a figure which shows the example of mapping management TBL. It is a figure which shows the example of dummy goods code management TBL. It is an integrated order management process sequence diagram (1). It is an integrated order management process sequence diagram (2). It is a flowchart which shows the process sequence of order reception process outline | summary (1). It is a flowchart which shows the process sequence of order reception process outline (2). It is a flowchart which shows the process sequence of order reception process outline | summary (3). It is a flowchart which shows the process sequence of order receipt process outline (4). It is a flowchart which shows the process sequence of a core system order taking-in process outline. It is a flowchart which shows the process sequence of the core system order confirmation process outline. It is a flowchart which shows the process sequence of a sales process outline | summary (1). It is a flowchart which shows the process sequence of a sales process outline | summary (2). It is a flowchart which shows the process sequence of core system sales taking-in process outline. It is a figure which shows the example of an order entry screen layout. It is a figure which shows the example of an order history reference screen layout.

Hereinafter, an embodiment of the present invention will be described in detail with reference to the drawings.
(Whole system configuration)
FIG. 1 is a diagram illustrating a network configuration example of the system 1. This system 1 is configured by connecting an integrated order management server 11, a user terminal 12, a backbone system A13, and a backbone system B14 to a network 15. The integrated order management server 11 creates an XML (Extensible Markup Language) file in a format defined for each core system from the order information input to the user terminal 12 and transmits the file to each core system to control the order information. System to control automatically. In the following description, it is assumed that various files are formatted using XML. However, the present invention is not limited to this.

  FIG. 2 is a diagram showing an overview (functional configuration) of the integrated order management server 11. As shown in FIG. 2, the integrated order management server 11 creates two types of data delivery linkage XML files for order information and sales information from the order information acquired from the user terminal 12 in the storage unit 201. It has a program of order processing function 210 to be transmitted to each backbone system. Further, as a table for executing the order processing function 210, a backbone connection TBL 211 for managing connection information to each backbone system, a profit sharing TBL 212 for managing a profit sharing ratio between departments when a product is ordered, and an integrated order management server 11 Manages the data placement position of the XML file when creating the data delivery linkage XML file from the integrated order history TBL 213 for managing the status of the order information processed in step 1 and storing the history, and the order information acquired from the user terminal 12 The mapping management TBL 214 has a dummy product code management TBL 215 for managing a dummy product code used to generate a sales profit in the own department backbone system when receiving an order for another department product. As hardware, a display unit 203, an input unit (keyboard, mouse) 202, a control unit (CPU: Central Processing Unit) 200, and a network interface 204 are provided.

  FIG. 3 is a diagram showing an outline of the basic system (server) A13. The core system A13 interprets the existing program for starting the order processing function, the existing program for starting the sales processing function, the order information XML file transmitted from the integrated order management server 11 in the storage unit 301, and the order processing function of the existing program. Information of the order receiving function 310 for notifying the integrated order management server of the confirmation of the order processing, and interpreting the sales information XML file transmitted from the integrated order management server 11 to inform the sales processing function of the existing program. A sales acquisition function 311 program for performing transmission is included. As hardware, a display unit (display) 303, an input unit (keyboard, mouse) 302, a control unit (CPU) 300, and a network interface 304 are provided.

  FIG. 4 is a diagram showing an outline of the basic system (server) B14. The backbone system B14 interprets the existing program that activates the order processing function, the existing program that activates the sales processing function, and the order information XML file transmitted from the integrated order management server 11 in the storage unit 401, and the order processing function of the existing program. The order receiving function 410 program that informs the integrated order management server of the confirmation of the order processing and the sales information XML file transmitted from the integrated order management server 11 are interpreted and the information is sent to the sales processing function of the existing program. It has a sales acquisition function 411 program for transmission. As hardware, a display unit (display) 403, an input unit (keyboard, mouse) 402, a control unit (CPU) 400, and a network interface 404 are provided.

FIG. 5 is a diagram showing an outline of the user terminal 12. The user terminal 12 in the storage unit 501 receives an order history reference that refers to a program of an order registration function 510 that registers order information in the integrated order management server 11 and the status and history of the order information processed by the integrated order management server 11. A program of function 511 is included. Further, as hardware, a display unit (display) 503, an input unit (keyboard, mouse touch) 502, a control unit (CPU) 500, and a network interface 504 are provided.
(Table structure)
FIG. 6 is a diagram illustrating a configuration of the backbone connection TBL 211. The backbone connection TBL 211 stores database connection information in association with the integrated order management server 11 when connecting to each backbone system. The department code 601 serves as the primary key to identify the record. The IP address 602 stores the IP address of the core system owned by each department. The DB connection information 603 stores unique information such as login information when connecting to the DB of the core system.

  FIG. 7 is a diagram showing a configuration of the profit sharing rate TBL212. The profit sharing rate TBL 212 stores the profit sharing rate between departments at the time of receiving an order in association with each other. The department code 701 and the merchandise department code 702 serve as primary keys to identify records. The department code 701 stores the department code of the department that received the order for the product. The product department code 702 stores a department code of a department (originally a department that receives an order for a product) having a basic system for receiving and ordering the ordered product. In the distribution ratio 703, a profit distribution ratio that is compromised between the sections of the section code and the commodity section code is stored as a numerical value between 0 and 1.

  FIG. 8 is a diagram showing a configuration of the integrated order history TBL 213. The integrated order history TBL 213 stores status information and history information of order information processed by the integrated order management server 11 in association with each other. The order number 801 serves as a primary key to identify the record.

  The order number 801 stores a number that is sequentially assigned when order information is acquired from the user terminal 12. The person-in-charge code 802 stores the person-in-charge code of the person in charge who has registered the order information. The person-in-charge department code 803 stores the department code of the department to which the person in charge who has registered the order information belongs. The customer code 804 stores the customer code of the customer who is the order source of the ordered product. The product code 805 stores the product code of the ordered product. The merchandise department code 806 stores the department code of the department that possesses the basic system for receiving and ordering the ordered goods.

  The product name 807 stores the product name of the ordered product. The order category 808 stores a category for identifying whether the ordered product is a product of its own department or a product of another department, that is, whether or not profit sharing is performed. The own department profit 809 stores the profit amount of the own department derived by calculation from the sales price, purchase price, and distribution rate 703 stored in the profit distribution TBL 212. The other department profit 810 stores the sales price, purchase price of the ordered product, and the profit amount of the other department derived from the distribution ratio 703 stored in the profit distribution TBL 212. The registration date 811 stores the date when the order information is registered in the integrated order history TBL 213. The order status 812 stores the progress status of the order processing (instructed or completed) in the order information. The quantity 813 stores the quantity of the ordered product.

  FIG. 9 is a diagram showing the configuration of the mapping management TBL 214. The mapping management TBL 214 stores the data arrangement position of the XML file in association with the creation of the data delivery cooperation XML file from the order information acquired from the user terminal 12. The department code 901, format code 902, and registration destination TBL name 903 serve as the primary key to identify the record. The department code 901 stores the department code of the department that holds the backbone system that is the object of transmitting the XML file from the integrated order management server 11. The format code 902 stores a code for determining whether the position information of the XML file represented by the record is the order information XML file or the sales information XML file. The registration destination TBL name 903 stores the table name of the table to be registered in the information included in the XML file. Tags 1_904 to 10_0913 include information on XML files to be transmitted to the core system (order number, person-in-charge code, product code, product name, quantity, customer code, sales price, purchase price, profit, sales date, etc.) Are stored in the order prescribed for each core system.

FIG. 10 is a diagram showing the configuration of the dummy product code management TBL 215. As shown in FIG. The dummy product code management TBL 215 stores a dummy product code used in order to generate a sales profit in the own department backbone system when receiving an order for another department product. The department code 1001 serves as the primary key to identify the record. The department code 1001 stores the department code of the department that has the basic system to which the sales information XML file is to be transmitted. The dummy product code 1002 stores a pseudo product code that does not exist in the backbone system after following the product code numbering rule of the backbone system held by the department of the division code 1001. The product code stored in the dummy product code 1002 is a product code that is used only when an order for a product of another department is received in the backbone system. The reason is to generate sales in a department that has not received an order for a product.
(Processing flow)
11 and 12 are processing sequence diagrams of the integrated order management server. (FIGS. 11 and 12 assume that the basic system A13 is the own department (department code “AAA”) and the basic system B14 is the other department (department code “BBB”), and is managed by the basic system B14 of the other department. It is a processing sequence diagram when a product order process is performed.)
The user first registers a product code to be searched for in the user terminal 12, and performs product information search S1101. The integrated order management server 11 receives the product code to be searched from the user terminal 12, and receives product information from the backbone system A13 or the backbone system B14 based on the information of the backbone connection TBL 211. (If the product code to be searched is a product managed by the basic system A13, the product information is received in the product information transmission S1102, and if the product code is managed by the basic system B14, the product information is transmitted. The product information is received in S1103.) Upon receiving the product information, the integrated order management server 11 performs product information display S1104 and displays the details of the product information on the user terminal 12.

  After confirming the details of the product information, the user registers the order information on the order screen of the user terminal 12 and performs order entry S1105. The integrated order management server 11 obtains input information on the order screen, and performs profit calculation S1106 based on the input information, backbone connection TBL 211, dummy product code management TBL 215, profit distribution rate TBL 212, and product master information existing in the backbone system. The profit amount of each of the department to which the user belongs and the department that manages the product is calculated. After calculating the profit amount, order file creation S1107 is performed based on the information of the mapping management TBL, and an order information XML file to be transmitted to the backbone system B14 of the department managing the product is created. After the order information XML file is created, an order file transmission S1108 is performed, and the order information XML file is transmitted to the backbone system B14.

  The backbone system B14 receives the order information XML file, performs order reception processing S1109 based on the information of the mapping management TBL, and registers the information of the order information XML file in the table of the backbone system B14. Thereafter, order processing and shipping processing, which are existing programs, are performed. In addition, in the order confirmation monitoring process S1111, the completion status of the order process and the shipping process is monitored. After the order confirmation is determined in the order confirmation monitoring process S <b> 1111, an order confirmation information XML file is created and transmitted to the integrated order management server 11 in the order confirmation notification S <b> 1112.

  After receiving the order confirmation information XML file, the integrated order management server 11 performs sales file creation S1201 based on the information of the mapping management TBL, and receives the order information XML file and the sales information XML file to be transmitted to the backbone system A13 of its own department. Create After creating the XML file, a sales file transmission S1202 is performed, and the XML file is transmitted to the backbone system A13.

  The core system A13 receives the order information XML file and the sales information XML file, performs the sales acquisition process S1203 based on the information of the mapping management TBL, and receives the information of the order information XML file and the sales information XML file as the core system A13. Register in the table. After that, sales processing that is an existing program is performed. At the same time, sales processing of the basic system B14 is performed.

  When referring to the status and history of the order information registered by the user, the order history search S1204 is performed from the user terminal 12. The integrated order management server 11 searches the integrated order history TBL 213 from the search conditions input to the user terminal 12 and displays the search result on the user terminal 12.

  13, 14, 15, and 16 are processes for acquiring information on an order screen input at the user terminal 12 and transmitting an XML file from the integrated order management server 11 to the backbone system B 14 (the order in FIG. 11). It is a flowchart diagram of input S1105, profit calculation S1106, order file creation S1107, order file transmission S1108).

  First, the control unit 200 of the integrated order management server 11 receives order information (department code (the department code of its own department in the present embodiment), person-in-charge code, customer code, product department code (this implementation) entered on the order reception screen. In this form, the department code of another department), the product code, and the quantity) are acquired (step S1301). After acquiring the order information, the control unit 200 searches the backbone connection TBL 211 on the condition that “the department code 601 and the product department code acquired in S1301 match”, and extracts the IP address 602 and the DB connection information 603 (step S1302), variable 1 and variable 2 are set (step S1303). Thereafter, the basic connection TBL 211 is searched under the condition that “the department code 601 and the department code acquired in S1301 match”, and the IP address 602 and the DB connection information 603 are extracted (step S1304), and set to variables 3 and 4 respectively. (Step S1305). Thereafter, the dummy product code management TBL 215 is searched on the condition that the “department code 1001 and the department code acquired in S1301 match”, and the dummy product code 1002 is extracted (step S1401), and is set in the variable 5 (step S1402).

  Next, the control unit 200 uses the variable 1 (IP address) and the variable 2 (DB connection information) to connect to the backbone system B14 of the department that manages the product. Then, using the product code acquired in S1301, the basic product master TBL is searched with a search key (product code), and the product name, purchase unit price, and sales unit price are extracted (step S1403).

  Next, the control unit 200 compares that the department code acquired in S1301 and the product department code acquired in S1301 are not the same value (step S1404). If the comparison result in S1404 is true (the department code and the product department code do not have the same value), the order classification is “1” (value that means profit distribution is performed), and the order status is “instructed” (step S1501). The profit distribution rate TBL212 is searched with a search key (department code, product division code), and the distribution rate 703 is acquired (step S1503). If the comparison result in S1404 is false (the department code and the product department code have the same value), the order classification is “0” (a value meaning that profit sharing is not performed), and the order status is “instructed” (step S1502). ), “1” is fixedly set in the distribution rate (step S1504). After the processing of S1503 or S1504, using the purchase unit price and sales unit price extracted in S1403 and the distribution rate acquired in S1503 or set in S1504, the profit of the own department is obtained by subtracting the purchase price from the sales price. Multiply the distribution rate to derive the profit, and derive other department profits by multiplying the value obtained by subtracting the purchase price from the sales price and the value obtained by subtracting the distribution rate from 1 (step S1505).

  Next, the control unit 200 registers a record in the integrated order history TBL 213. In the order number 801, a number that does not overlap with the order number already existing in the integrated order history TBL 213 is newly assigned and registered. In the person-in-charge code 802, the person-in-charge code acquired in S1301 is registered. The department code acquired in S1301 is registered in the person-in-charge department code 803. In the customer code 804, the customer code acquired in S1301 is registered. In the product code 805, the product code acquired in S1301 is registered. In the product department code 806, the product department code acquired in S1301 is registered. In the product name 807, the product name acquired in S1403 is registered. In the order category 808, the order category set in S1501 or S1502 is registered. The own department profit 809 is registered with the own department profit derived in S1505. In the other department profit 810, the other department profit derived in S1505 is registered. The registration date 811 registers the date when the record was registered. The order status set in S1501 or S1502 is registered in the order status 812. The quantity acquired in S1301 is registered in the quantity 813 (step S1506).

  Next, the control unit 200 searches the mapping management TBL 214 on condition that “the department code 901 and the product department code acquired in S1301 match” and “the format code matches“ J10 ”(order information XML file format code)”. Tag 1_904 to tag 10_913 are extracted (S1507). Thereafter, the information obtained from S1301, S1403, S1501 or S1502, S1505 is embedded in an XML file based on the position information extracted in S1507, and an order information XML file is created (S1601). Thereafter, the created order information XML file is transmitted to the variable 1 (IP address) set in S1304 as a transmission destination (S1602).

  FIG. 17 is a flowchart of the order taking-in process (corresponding to the order taking-in process S1109 in FIG. 11) performed by the backbone system B14 that has received the order information XML file.

  The control unit 400 receives the order information XML file transmitted from the integrated order management server 11 (S1701). Thereafter, the mapping management TBL 214 is searched on the condition that “the department code 901 and the own department code match” and “the format code matches“ J10 ”(order information XML file format code)”, and the registration destination TBL name 903 and the tag 1_904 ˜Tag 10_913 is extracted (S1702). In the present embodiment, since the system that receives the order information XML file is the basic system B possessed by another department, the control unit 400 matches the department code 901 and the department code “BBB” of the department having the basic system B. The search is performed on the condition that the format code corresponding to the department code matches "J10". Then, the control unit 400 accesses the registration destination TBL of the backbone system B14 based on the extracted registration destination TBL name (S1703), analyzes the information in the order information XML file based on the tag information, and stores the information in the registration destination TBL. Registration is performed (S1704).

  FIG. 18 shows that the basic system B 14 performs an order take-in process (order process, shipping process) for issuing a product shipping slip and shipping a product, and then stores the order confirmation information XML file in the integrated order management server 11. It is a flowchart figure of the process (equivalent to the order confirmation monitoring process S1111 of FIG. 11, order confirmation notification S1112).

  First, the control unit 400 sets, as the initial state of the process transition, no monitoring completion determination and no order confirmation determination in the order receiving process described above. At the beginning of the process transition, it is determined whether or not there is a monitoring end determination (S1801). If there is a monitoring end determination, the process ends. If there is no monitoring end determination, the presence / absence of the order confirmation determination is determined (S1802). If the order processing and shipping processing of the existing program are not completed, the order confirmation determination is not made and the process transitions to the monitoring end determination again. When the order processing and shipping processing of the existing program is completed and the order confirmation determination is made, the process proceeds to S1803 and subsequent processes.

  As in the case of step S1702, the control unit 400 first searches the mapping management TBL 214 on the condition that “the department code 901 and the own department code match” and “the format code matches“ J10 ””, and the registered TBL name In step 903, tags 1_904 to 10_913 are extracted (S1803). The registration destination TBL of the backbone system B14 is accessed based on the extracted registration destination TBL name (S1804), and an order confirmation information XML file is created based on the information stored in the registration destination TBL and the acquired tag information ( S1805). Thereafter, the control unit 400 transmits the created order confirmation information XML file to the integrated order management server 11 as a transmission destination. When the file transmission is completed, “Yes” is set in the monitoring end determination, and the process proceeds to the monitoring end determination in S1801 (S1806).

  19 and 20 show sales file creation (corresponding to sales file creation S1201 in FIG. 12) and sales file transmission (corresponding to sales file transmission S1202 in FIG. 12) performed by the integrated order management server 11 that has received the order confirmation information XML file. FIG.

  The control unit 200 receives the order confirmation information XML file transmitted from the backbone system B14 (S1901). After that, the mapping management TBL 214 is searched on the condition that “the department code 901 matches the product department code acquired in S1301” and “the format code matches“ J10 ”(order information XML file format code)”, and the registered TBL name 903 and tags 1_904 to 10913 are extracted (S1902). After analyzing the received order confirmation information XML file based on the extracted tag information, the control unit 200 determines that the integrated order history TBL 213 is “on the condition that the order number 801 and the order number extracted from the order confirmation information XML file match”. The person-in-charge department code 803 (in this embodiment, the person-in-charge department code “AAA”) and the order category 808 (in this embodiment, the order category “1”) are extracted by searching (S1903). Thereafter, the order status 812 of the record in the integrated order history TBL 213 where “the order number 801 matches the order number extracted from the order confirmation information XML file” is updated to “completed” (S 1904).

  Next, the control unit 200 determines whether or not the order classification 808 extracted in S1903 is “1” (S1905). If the order classification is not “1”, the process is terminated because the value means that profit sharing is not performed. When the order classification is “1”, the mapping management TBL 214 is set with the condition that the department code 901 and the department code in charge acquired in S1903 match and the format code matches “U10” (sales information XML file format code). The registered TBL name 903, tag 1904, tag 2905, tag 3906, tag 4907, tag 5908, tag 6909, tag 7910, tag 8911, tag 9912, and tag 10913 are extracted (S2001). After that, the product code (product code of tag 3 shown in FIG. 9) converted to the dummy product code extracted in S1401 is extracted in S2001 with respect to the self-sector profit derived in S1505 and the information obtained in S1902. The sales information XML file is created by embedding it in the XML file based on the position information obtained (S2002). Thereafter, the control unit 200 transmits the sales information XML file created in S2002 by using the variable 3 as a transmission destination (S2003).

  FIG. 21 is a flowchart of a sales capture process (corresponding to the sales capture process S1203 in FIG. 12) performed by the backbone system A13 that has received the sales information XML file.

  The control unit 300 receives the sales information XML file transmitted from the integrated order management server 11 (S2101). The mapping management TBL 214 is searched on condition that “department code 901 and own department code match” and “format code matches“ U10 ”(sales information XML file format code)”, and registered TBL name 903, tag 1_904 to tag 10_913 is extracted (S2102). In the present embodiment, since the system that receives the sales information XML file is the basic system A owned by the own department, the control unit 300 matches the department code “AAA” of the department code 901 and the department having the basic system A. The search is performed on the condition that the format code corresponding to the department code matches "U10". Thereafter, the control unit 300 accesses the registration destination TBL of the backbone system A14 based on the registration destination TBL name extracted in S2102 (S2103), analyzes the information in the sales information XML file based on the tag information, and registers the registration destination TBL. Register in the TBL (S2104). When the process of step S2104 ends, all the processes in the present embodiment end.

  FIG. 22 is a screen layout diagram for performing order registration 510 on the display unit 503 of the user terminal 12. First, the user inputs a department code and a person-in-charge code of the department to which the user belongs. Then, enter the department code and product code of the other department, which is the product department code of the ordered product, and press the search button to search the basic product master TBL of the department to which the product belongs and display the product name So enter the quantity of goods. Further, by inputting the customer code and pressing the search button, the basic customer master is searched and the customer name is displayed. When all the input items have been entered, the registration button is pressed, and the order entry is completed.

  FIG. 23 is a screen layout diagram for performing an order history inquiry 511 on the display unit 503 of the user terminal 12. When the user inputs the department code, person-in-charge code, order number, and presses the search button, the integrated order history TBL is searched using the entered department code, person-in-charge code, order number as a key, and the screen is displayed. indicate.

As described above, in the integrated order management server 11, the input unit 202 identifies the product code for identifying the product, the department code for identifying the department that has received the order for the product, and the product department for which the product is originally ordered. The order connection information including the product department code is received, and the backbone connection TBL 211 stores the department code or the product department code in association with the address information of the core system of the product that each of the department or the product department has. The profit distribution rate TBL 212 stores the department code or the product department code in association with the distribution rate for distributing the profit generated by the ordered product in the department and the product department, and the mapping management TBL 214 stores the department code or Store the product department code in association with tag information that can be processed by each core system. When the input unit 202 receives input of order information, it is determined whether or not the department code and the product department code match, and when it is determined that the department code and the product department code do not match, based on the distribution rate The profit of the product is distributed between the departments and the product department, and based on the profit of the distributed department or the product department, the order information, and the tag information, the core system of the department (own department) processes the order of the product Order information file for the product and an order information file for the product system (other departments) core system to process product orders, and based on the address information, the generated order information file is stored in the department core system. The received order information file is transmitted to the main server of the product department, and the main system of the department (own department) receives the order information file and stores it in the received order information file. Order processing based on the received order information and the profit of the distributed department, and the sales process to record the sales of the product, the core system of the product department (other department) receives the order information file, Based on the order information contained in the received order information file and the profit of the distributed product department, the order processing is performed and the sales processing is performed to record the sales of the product. Management can be realized.
(Other embodiments)
The functions of the programs of the integrated order management server 11, the user terminal 12, the backbone system A13, and the backbone system B14 described above may be realized by hardware. Further, the function of the user terminal 12 may be provided in the integrated order management server 11. Although the embodiment of the present invention has been described above, the present invention is not limited to this, and various modifications can be made without departing from the scope of the invention. In addition, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the above embodiments. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, constituent elements over different embodiments may be appropriately combined.

11 Integrated Order Management Server 12 User Terminal 13 Core System A
14 Core System B
15 network 200 control unit 201 storage unit 202 input unit 203 display unit 204 network interface unit 300 control unit 301 storage unit 302 input unit 303 display unit 304 network interface unit 400 control unit 401 storage unit 402 input unit 403 display unit 404 network interface unit 500 control unit 501 storage unit 502 input unit 503 display unit 504 network interface unit 211 backbone connection TBL
212 Profit sharing rate TBL
213 Integrated order history TBL
214 Mapping management TBL
215 Dummy product code management TBL.

Claims (10)

An integrated order management system that manages products ordered by each department,
Integrated management server
Order reception including product identification information for identifying the product, department identification information for identifying a department that has received an order for the product, and product department identification information for identifying a product department that originally received the product An input receiving unit for receiving information;
An address information storage unit that stores the department identification information or the product department identification information, and the address information of the basic server of the product that each of the department or the product department has,
A distribution information storage unit that stores the division identification information or the product division identification information and a distribution rate for distributing profits generated by the ordered product in the division and the product division in association with each other;
A mapping storage unit that stores the department identification information or the merchandise department identification information and tag information for making a format that can be processed by each of the core servers in association with each other;
When the input reception unit receives the input of the order information, it is determined whether or not the department identification information and the product department identification information match, and the department identification information and the product department identification information match. If it is determined not to, the profit of the product is distributed between the department and the product department based on the distribution ratio, and the profit of the distributed department or the product department, the order information, and the tag information are distributed. Based on the address, a department order file for the core server of the department to perform the order processing of the product and a product department order file for the core server of the product department to perform the order processing of the product are generated, and the address An integrated system for transmitting the generated department order file to the backbone server of the department based on the information and transmitting the generated product department order file to the backbone server of the product department. And parts,
The core server of the department is
The department order file is received, and the order processing is performed based on the order information included in the received department order file and the distributed profit of the department, and the sales process for recording the sales of the product is performed. A first product control unit,
The core server of the product department is
Sales that receive the product department order file, perform the order processing based on the order information included in the received product department order file and the profits of the distributed product department, and record sales of the product A second product control unit that performs processing;
An integrated order management system. The integrated management server
The mapping storage unit stores the tag information for each of the order processing and the sales processing performed by the department or the product department,
The integrated control unit, based on the distributed profit of the department or the product department, the order information, and the tag information, the department order file or the product department order file and the core server of the department process the sales process. The department sales file for performing the sales and the product department sales file for the product department core server to perform the sales processing are generated, and the generated department order file and the department sales file are generated based on the address information. To the backbone server of the department, and send the generated product department order file and the product department sales file to the backbone server of the product department,
The integrated order management system according to claim 1. When the second product control unit receives the product department order file from the integrated management server and performs the order processing, the product department core server determines the order of the product, Send to the integrated management server that the order has been confirmed,
The integrated management server transmits the department sales file to the core server of the department when the integrated control unit receives the confirmation that the order of the product has been confirmed from the basic server of the product department,
In the department core server, the first product control unit receives the department sales file from the integrated management server and performs the sales processing.
The integrated order management system according to claim 2. The core server of the department is
When the first product control unit receives the department order file or the department sales file from the integrated management server, the department identification information included in the department order file or the department sales file, and the core server Is registered in the storage unit of the backbone server of the department in association with the tag information necessary to make the format can be processed,
The product department server
When the second product control unit receives the product department order file or the product department sales file from the integrated management server, the product department identification information included in the product department order file or the product department sales file And the tag information necessary for making the format processable by the backbone server in association with each other and register it in the storage unit of the backbone server of the department,
The integrated order management system according to any one of claims 1 to 3. The integrated management server
When the integrated control unit determines that the department identification information and the product department identification information do not match, dummy information identifying information indicating that the department is not a product handled by the department is included in the tag information as the product identification information. Based on the profit of the department set and distributed, the order information and the set tag information, the department sales file is generated, and the generated sales department file is transmitted to the core server of the department.
The integrated order management system according to any one of claims 2 to 4. Department identification information for managing a product ordered by each department and identifying a department for which the product has been ordered, or product department identification information for identifying a product department that originally received the product, and the department or the product department Address information storage unit that stores the address information of the basic server of the product associated with each other, the department identification information or the product department identification information, and the profit generated by the ordered product for the department and the product A distribution information storage unit for storing a distribution rate for distribution in each department in association with each other, the department identification information or the product department identification information, and tag information for making a format that can be processed by each of the core servers; Ordering data delivery cooperation method performed in an integrated order management system having a mapping storage unit that stores the information in association with each other There,
Order reception including product identification information for identifying the product, department identification information for identifying a department that has received an order for the product, and product department identification information for identifying a product department that originally received the product An input reception step for receiving input of information;
When the input reception unit receives the input of the order information, it is determined whether or not the department identification information and the product department identification information match, and the department identification information and the product department identification information match. If it is determined not to, the profit of the product is distributed between the department and the product department based on the distribution ratio, and the profit of the distributed department or the product department, the order information, and the tag information are distributed. Based on the address, a department order file for the core server of the department to perform the order processing of the product and a product department order file for the core server of the product department to perform the order processing of the product are generated, and the address An integrated system for transmitting the generated department order file to the backbone server of the department based on the information and transmitting the generated product department order file to the backbone server of the product department. And the step,
The department order file is received, and the order processing is performed based on the order information included in the received department order file and the distributed profit of the department, and the sales process for recording the sales of the product is performed. A first product control step;
Sales that receive the product department order file, perform the order processing based on the order information included in the received product department order file and the profits of the distributed product department, and record sales of the product A second product control step for processing;
An order data delivery linkage method comprising: The mapping storage unit stores the tag information for each of the order processing and the sales processing performed by the department or the product department,
In the integrated control step, the department order file or the product department order file and the main server of the department process the sales processing based on the distributed profit of the department or the product department, the order information, and the tag information. The department sales file for performing the sales and the product department sales file for the product department core server to perform the sales processing are generated, and the generated department order file and the department sales file are generated based on the address information. To the backbone server of the department, and send the generated product department order file and the product department sales file to the backbone server of the product department,
The ordering / ordering data delivery linkage method according to claim 6. When the second product control step receives the product department order file from the integrated management server and performs the order processing, the order of the product is confirmed and the order of the product is confirmed. Sent to the Master Management Server,
When the integrated control step receives that the order of the product has been confirmed from the basic server of the product department, the department sales file is transmitted to the basic server of the department,
The first product control step receives the department sales file from the integrated management server and performs the sales processing.
8. The ordering / ordering data delivery cooperation method according to claim 7. When the first product control step receives the department order file or the department sales file from the integrated management server, the department identification information included in the department order file or the department sales file, and the core server Is registered in the storage unit of the backbone server of the department in association with the tag information necessary to make the format can be processed,
When the second product control step receives the product department order file or the product department sales file from the integrated management server, the product department identification information included in the product department order file or the product department sales file And the tag information necessary for making the format processable by the backbone server in association with each other and register it in the storage unit of the backbone server of the department,
9. The ordering / ordering data delivery cooperation method according to any one of claims 6 to 8. When the integrated control step determines that the department identification information and the product department identification information do not match, dummy product identification information indicating that the department does not handle the product is used as the product identification information in the tag information. Based on the profit of the department set and distributed, the order information and the set tag information, the department sales file is generated, and the generated sales department file is transmitted to the core server of the department.
The ordering / ordering data delivery cooperation method according to any one of claims 7 to 9, characterized in that:

Images