JP4776889B2 - Master registration system and method, and computer program - Google Patents

Description

  The present invention relates to a master registration system and method, and a computer program.

  Conventionally, a production management system that consistently manages from production to sales of a product has an item master including basic information of each product, and the production management application operates using this item master information. ing. Since the item master contains information related to product production, sales and accounting, it is usually registered by a dedicated person in charge.

On the other hand, Patent Document 1 describes a technique for centrally managing master data distributed among a plurality of systems. Specifically, master data registered and updated by a plurality of master registration computers is centrally managed, and the managed master data is selectively distributed to the master reflection destination system. As a result, the master data registered and updated by the master registration computer and centrally managed by the centralized master management system is automatically reflected in the master reflection destination system having different functions.
Patent Document 2 describes a configuration in which image data is registered in association with input data. Specifically, the card issuance request is received, and the card information read from the accepted card, the input / exit information, and the identification information of the held authentication image are registered in the master.
JP 2002-169717 A JP 20024662 A

In a product life cycle management system that performs product management from the design stage, which is the stage before product production, it is necessary to register an item master from the beginning of product design. Therefore, the engineer who designs the product must first register the item master. However, even for data that must be included in the item master, data related to production management, sales, accounting, etc. is often not finalized at the design stage. It was difficult to have registered in the item master.
However, the techniques described in Patent Documents 1 and 2 do not solve the problems described above.

  The present invention has been made in view of such circumstances, and provides a master registration system and method and a computer program that allow a user to register a plurality of new records in master data easily and quickly. Objective.

In order to solve the above-described problem, the invention described in claim 1 includes a server (3) holding master data composed of records having a plurality of data items, a portal server (2), and a client terminal (1). A portal registration system for registering a new record in the master data, wherein the portal server (2) includes an item code, an item text, an item type, and a representative data item among the plurality of data items. A registration screen transmitting means (22) for transmitting screen data of a master registration screen for displaying input fields for inputting a set value of a basic quantity unit for a plurality of records to the client terminal (1), and the client terminal ( 1) to a plurality of records entered in the input field of the master registration screen displayed by the client terminal (1). Master registration requesting means (23) for receiving a set value of a representative data item for a mode and sending it to the server (3), wherein the server (3) is a master storage means for storing the master data ( 31), input accepting means (35) for collectively receiving a set value of representative data items for a plurality of records from the portal server (2), and an item type that is a specific data item included in the representative data item At the time of inputting the set value of the representative data item including at least the product department and the purchase management department, which are data items other than the representative data item of the plurality of data items, the set value is not finalized. and dependent data storing means for storing in association with the initial setting value of the dependent data item (32), for each record received by the input receiving means (35), the Depending on the set value of a particular data item code, the initial setting value of the corresponding dependent data item read from the dependent data storing means (32), said dependent setting and the record of the representative data item of the record Data setting means (36) for outputting an initial setting value of the data item, and setting values of the representative data item and the initial setting of the subordinate data item for the plurality of records output from the data setting means (36) A master registration system comprising: a registration unit (37) that generates a plurality of new records using values and registers the new records in the master data in the master storage unit (31).

The invention according to claim 2 comprises a server (3) holding master data composed of records having a plurality of data items, a portal server (2), and a client terminal (1). A master registration method used in a master registration system for registering a record, wherein, in the portal server (2), a registration screen transmission means (22) includes an item code that is a representative data item among the plurality of data items, A registration screen transmission process for transmitting screen data of a master registration screen that displays an input field for inputting a set value of a plurality of records for the item text, the item type, and the setting value of the basic quantity unit to the client terminal (1); The master registration request means (23) displays the client terminal (1) from the client terminal (1). In the master registration request process for receiving the set values of representative data items for a plurality of records, which are input in the input field of the master registration screen, and transmitting them to the server, and in the server (3), the input receiving means (35) However, an input receiving process (step S110) for collectively receiving a set value of representative data items for the plurality of records from the portal server, and a data setting means (36) are specific data items included in the representative data items. At the time of inputting a set value of the representative data item including at least a product department and a purchase management department, which are data items other than the representative data item of the plurality of data items, from the dependent data storing means for storing in association with the initial setting value of the dependent data item not determined (32), said input receiving over For each record received in, according to the set value of the particular data item of the record, reads the initial setting value of the corresponding dependent data items, said dependent setting of the representative data item of the record and the record A data setting process (steps S125 and S130) for outputting an initial setting value of the data item, and a registration means (37), and the setting value of the representative data item for a plurality of records output in the data setting process, A registration process (steps S135 and S140) for generating a plurality of new records using the initial setting values of the subordinate data items and registering them in the master data stored in the master storage means (31). A master registration method characterized by the above.

The invention described in claim 3 comprises a server (3) that holds master data composed of records having a plurality of data items, a portal server (2), and a client terminal (1). A computer program used in a master registration system for registering a record, wherein a computer used as the portal server (2) is replaced with an item code, item text, item type, which is a representative data item of the plurality of data items, And a registration screen transmitting means (22) for transmitting screen data of a master registration screen for displaying input fields for inputting a set value of a basic quantity unit for a plurality of records to the client terminal (1), the client terminal ( 1) to enter the master registration screen displayed by the client terminal (1). A computer used as the server (3) is made to function as a master registration requesting means (23) that receives the set values of representative data items for a plurality of records input in the field and transmits them to the server (3). , Master storage means (31) for storing the master data, input receiving means (35) for collectively receiving a set value of representative data items for a plurality of records from the portal server, and specific data included in the representative data items Set at the time of inputting the setting value of the representative data item including at least the setting value of the item type that is an item and the product department and the purchasing management department that are data items other than the representative data item of the plurality of data items dependent data storing means for storing in association with the initial setting value of the dependent data item value has not been determined (32), wherein For each record received by the force receiving means (35), according to the set value of the particular data item of the record read from the corresponding said initial setting value of the dependent data items dependent data storing means (32), the Data setting means (36) for outputting a set value of the representative data item for the record and an initial setting value of the read subordinate data item, and for the plurality of records output from the data setting means (36) A registration unit (37) for generating a plurality of new records using the set value of the representative data item and the initial set value of the subordinate data item, and registering the new record in the master data in the master storage unit (31) It is a computer program characterized by making it function.
It should be noted that “(sign)” referred to in this column only exemplifies a corresponding configuration in a column (the best mode for carrying out the invention) to be described later, and does not indicate any claim in the claims. The interpretation is not limited.

  According to the above invention, when a new record is registered in the master data, the user does not need to be aware of the essential data items or to input many data items. In addition, the user is not burdened with having to input data items related to work outside the user's responsibility. Furthermore, a plurality of records can be registered in the master data at a time. Thereby, the user can register a plurality of new records in the master data easily and quickly.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 shows the configuration of a master registration system according to an embodiment of the present invention.
The master registration system is configured by connecting the client terminal 1, the portal server 2, and the application server 3 via a network such as a public network such as the Internet or a private network such as a LAN (Local Area Network). The application server 3 provides, for example, an application such as product life cycle management (hereinafter referred to as “PLM”) for managing products from the product design stage to production and sales, and indicates basic information of each product. Data (hereinafter referred to as item master) is retained.

  FIG. 2 is a block diagram showing the configuration of the application server 3, and only functional blocks related to the present invention are extracted and shown. The application server 3 can be composed of, for example, one or a plurality of servers, and includes an item master storage unit 31, a template storage unit 32, a communication unit 33, an item master management unit 34, and an application execution unit 38.

The item master storage unit 31 stores an item master. The item master is composed of a plurality of item master records. Each item master record includes an item code, item text, data items of various item data, and setting values thereof. The item code uniquely identifies the item. The item text indicates the name and description of the item. The item data is data related to design, manufacture, production, sales, accounting processing, or a part or all of these processing. Each item is classified into a product, a semi-finished product, a raw material, and the like.
The template storage means 32 stores a template in which data items of item data to be set in the item master record and their initial setting values are described.

  The communication unit 33 is connected to a network and transmits / receives data to / from the portal server 2. The application execution means 38 executes a PLM application. The PLM application operates using information on the item master registered in the item master storage unit 31.

The item master management means 34 performs registration, inquiry, update, and deletion of the item master. The item master management unit 34 includes an input receiving unit 35, a data setting unit 36, and a registration unit 37.
The input receiving means 35 receives item master registration request information. The item master registration request information includes a record including item code, item text, item type, and setting value information of the basic quantity unit of the item to be registered in the item master. The data setting means 36 refers to the template corresponding to the item type indicated by each record of the item master registration request information, and reads the item data item to be set in the item master record and its initial setting value. The registration unit 37 generates a new item master record based on the item master registration request information and the data item read by the data setting unit 36 and its initial setting value, and registers the new item master record in the item master in the item master storage unit 31. .

  The client terminal 1 is, for example, a computer terminal such as a personal computer, a PDA (Personal Digital Assistants: information portable terminal), or a cellular phone, and has a function of communicating with the portal server 2 via a network. A browser is provided for displaying the screen information received from the portal server 2 on a display, and for transmitting data input by a mouse, keyboard, buttons, or the like to the portal server 2.

FIG. 3 is a block diagram showing a configuration of the portal server 2, and only functional blocks related to the present invention are extracted and shown. The portal server 2 includes a communication unit 21, a registration screen transmission unit 22, an item master registration request unit 23, and a completion notification unit 24.
The communication unit 21 is connected to a network and transmits / receives data to / from the client terminal 1 and the application server 3. The registration screen transmission means 22 transmits item master registration screen information for inputting information necessary for registration of the item master record to the client terminal 1. The item master registration request means 23 receives item master registration request information from the client terminal 1 and passes it to the application server 3. The completion notifying means 24 notifies the client terminal 1 that registration of the item master record is completed to the item master.

  FIG. 4 is a configuration example of the item master held by the item master storage unit 31 of the application server 3. In the figure, each item master record constituting the item master holds a data item and a set value of an item code, item text, and various item data. Here, the item data includes basic data (basic data 1) commonly used for design, manufacturing, production, sales, accounting processing, etc. in the PLM application, purchasing management data used for sales, sales / accounting processing Has plant inventory data, used in ... Basic data includes general data composed of information such as basic quantity units, product divisions,..., Size data composed of information such as total weight, dimensions,. The purchase management data includes purchase management general data including a purchase management department, a sales price, and the like.

  FIG. 5 is a configuration example of a template held by the template storage unit 32 of the application server 3. The template holds item data items to be set and attribute values as initial setting values for each item type. The item data to be set includes essential data other than the item code, item text, and basic quantity unit, and may further include optional data. In the same figure, when the item type is “TFT product”, initial setting values such as product department of basic data, purchasing management department of purchasing management data, etc. are described as data to be set in the item master record. Yes.

  FIG. 6 is a diagram for explaining an outline procedure of item master registration. For each record of the item master registration request information, the application server 3 specifies a template corresponding to the set value of the item type indicated by the record. Then, copy the item data item and its initial setting value using the specified template as the copy source, and register it using the item code, item text, and basic quantity setting values in the item master registration request information record. Generate material master record. This generated item master record is registered in the item master.

FIG. 7 is an item master registration process flow in the application server 3.
First, the user accesses the portal server 2 from the client terminal 1. Then, the registration screen transmission means 22 of the portal server 2 returns the item master registration screen to the client terminal 1. The user inputs the setting value of the item code, item text, item type, and basic unit of measure for each item to be newly registered in the item master on the item master registration screen displayed by the client terminal 1, and the registration button Press. As a result, the client terminal 1 transmits to the portal server 2 item master registration request information composed of records including the item code, item text, item type, and information on the set value of the basic unit of measure of each input item. . The item master registration request unit 23 of the portal server 2 receives the item master registration request information from the client terminal 1 and transfers it to the application server 3. The input receiving means 35 of the application server 3 receives the item master registration request information (Step S110).

  Subsequently, the data setting unit 36 of the application server 3 pays attention to the first record included in the received item master registration request information (step S115). Then, it is determined whether or not the item code in the record of interest already exists in the item code that is uniquely managed in the item master (step S120). This is determined, for example, based on whether or not an item master record using the item code has already been registered in the item master stored in the item master storage unit 31. Alternatively, a list of item codes used in the item master record registered in the item master may be held inside and referred to.

  When the item code in the record of interest is an unused item code (step S120: No), the data setting unit 36 generates a new item master record using this item code. That is, the template corresponding to the item type in the record currently focused on is specified from the templates registered in the template storage means 32, and the data item is read (step S125). Further, an initial setting value (attribute value) corresponding to the read data item is acquired from the identified template (step S130). Then, the data setting means 36 receives the item code, item text, and basic quantity unit setting value in the record of interest and the initial setting value of the data item read in step S130 to the registration means 37. hand over. The registration unit 37 generates a new item master record using the item code, item text, the basic unit of measure setting value received from the data setting unit 36, and the initial setting values of various data items (step S135). ). The registration unit 37 newly registers the generated item master record in the item master in the item master storage unit 31 (step S140).

  On the other hand, when the item code in the record of interest already exists in the item code uniquely managed in the item master in step S120 (step S120: Yes), the registration unit 37 stores the item master record. The portal server 2 is instructed to make an inquiry as to whether or not to update (step S160). The item master registration request means 23 of the portal server 2 notifies a warning for inquiring whether or not to update the item master record such as “Do you want to update the attribute?” And a response whether to update or not. The inquiry screen information for displaying the response notification button is transmitted to the client terminal 1. The user presses a response notification button on the inquiry screen displayed by the client terminal 1 to notify the portal server 2 of a response as to whether or not to update. The application server 3 receives a response from the client terminal 1 via the portal server 2 (step S165).

  When the data setting unit 36 of the application server 3 determines that the received response is a response indicating that the item master record is to be updated (step S170: Yes), the record in the item master registration request information that is currently focused on Information of the item code and item text included in is transferred to the registration means 37. The registration unit 37 reads the item master record in the item master storage unit 31 corresponding to the item code, and rewrites the set value of the item text of the read item master record to the set value of the item text received from the data setting unit 36. Then, an item master record to be updated is created (step S175). The registration unit 37 updates the item master in the item master storage unit 31 with the generated item master record (step S140).

After the registration of the item master record in step S140 or when it is determined that the response received in step S170 is a response indicating that the item master record is not updated, the data setting unit 36 adds the following to the item master registration request information: It is determined whether there is a record (step S145). If it is determined that there is a next record, the record is noticed (step S150), and the processing from step S120 is repeated.
On the other hand, if the data setting unit 36 determines in step S145 that there is no next record, the portal server 2 is notified of the end of registration in the item master (step S180). When the completion notification means 24 of the portal server 2 receives the registration end notification from the application server 3, the completion notification means 24 transmits registration completion notification screen information indicating that the registration to the item master is completed to the client terminal 1. The user recognizes the completion of registration in the item master from the registration completion notification screen displayed on the client terminal 1.

  FIG. 8 is an example of an item master registration screen displayed by the client terminal 1. According to the figure, it is possible to input item codes, item texts, item types, and setting values of basic quantity units of a plurality of items to be registered in the item master. Here, as the item type, a setting value corresponding to the template registered in the template storage unit 32 of the application server 3 is selected from the pull-down menu.

  Instead of holding the setting value of the item data item in the template, information specifying the item master record from which the setting value is copied may be held. At this time, in step S135 of FIG. 7, the setting value corresponding to the data item is read from the designated item master record. In the above description, the template is uniquely determined from only one piece of information (item type) in the item master registration request information. However, the template may be determined from a combination of two or more pieces of information.

  As described above, according to the present embodiment, when a new item master record is registered in the item master, the user is aware of the essential data items or inputs many data items. There is no need to go or In addition, the user is not burdened with having to input data items related to work outside the user's responsibility. Furthermore, a plurality of item master records can be registered in the item master at a time. Therefore, the user can easily and quickly register a plurality of new records in the item master.

  The client terminal 1, portal server 2, and application server 3 described above have a computer system inside. The operation processes of the client terminal 1, the portal server 2, and the application server 3 described above are stored in a computer-readable recording medium in the form of a program, and the computer system reads and executes the program. Thus, the above processing is performed. The computer system here includes an OS and hardware such as peripheral devices.

  In addition to ROM, “computer-readable recording medium” refers to a portable medium such as a magnetic disk, a magneto-optical disk, a CD-ROM, a DVD-ROM, or a storage device such as a hard disk built in a computer system. That means. Furthermore, the “computer-readable recording medium” refers to a volatile memory (RAM) inside a computer system that becomes a client or a system when a program is transmitted via a network such as the Internet or a communication line such as a telephone line. In addition, those holding programs for a certain period of time are also included.

The program may be transmitted from a computer system storing the program in a storage device or the like to another computer system via a transmission medium or by a transmission wave in the transmission medium. Here, the “transmission medium” for transmitting the program refers to a medium having a function of transmitting information, such as a network (communication network) such as the Internet or a communication line (communication line) such as a telephone line.
The program may be for realizing a part of the functions described above. Furthermore, what can implement | achieve the function mentioned above in combination with the program already recorded on the computer system, and what is called a difference file (difference program) may be sufficient.

It is a block diagram of the master registration system by one embodiment of this invention. It is a block diagram which shows the structure of the application server by the embodiment. It is a block diagram which shows the structure of the portal server by the embodiment. It is a figure which shows the structural example of the item master by the embodiment. It is a figure which shows the structural example of the template by the embodiment. It is a figure explaining the outline | summary procedure of item master registration by the embodiment. It is an item master registration processing flow of the application server according to the embodiment. It is a figure which shows the screen image of the item master registration screen by the embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Client terminal 2 ... Portal server 3 ... Application server 21, 33 ... Communication means 22 ... Registration screen transmission means 23 ... Item master registration request means 24 ... Completion notification means 31 ... Item master storage means 32 ... Template storage means (subordinate data storage means)
34 ... Item master management means 35 ... Input reception means 36 ... Data setting means 37 ... Registration means 38 ... Application execution means

Claims (3)

A master registration system that consists of a server that holds master data consisting of records having a plurality of data items, a portal server, and a client terminal, and registers a new record in the master data,
The portal server
Screen data of the master registration screen that displays input fields for entering the set values of the item code, item text, item type, and basic unit of measure, which are representative data items of the plurality of data items, for a plurality of records Registration screen transmission means for transmitting to the client terminal;
Master registration request means for receiving, from the client terminal, setting values of representative data items for a plurality of records input in the input field of the master registration screen displayed by the client terminal, and transmitting to the server,
The server
Master storage means for storing the master data;
Input accepting means for collectively receiving a set value of representative data items for a plurality of records from the portal server;
And material type setting a specific data item included in the representative data item is a data item other than the representative data item of the plurality of data items includes at least a division and purchasing department, the representative Subordinate data storage means for holding in association with an initial setting value of a subordinate data item whose setting value is not fixed when inputting a setting value of the data item;
For each record received by the input receiving means, the initial set value of the corresponding dependent data item is read from the dependent data storage means according to the setting value of the specific data item of the record, and the representative data of the record Data setting means for outputting an item setting value and an initial setting value of the subordinate data item of the record;
A plurality of new records are generated using the setting values of the representative data items and the initial setting values of the subordinate data items for the plurality of records output from the data setting means, and the master in the master storage means A registration means for registering data,
A master registration system characterized by that. A master registration method used in a master registration system for registering a new record in the master data, comprising a server that holds master data composed of records having a plurality of data items, a portal server, and a client terminal,
In the portal server,
The registration screen transmission means displays an input field for inputting a set value of item code, item text, item type, and basic unit of measure, which is a representative data item among the plurality of data items, for a plurality of records. A registration screen transmission process of transmitting screen data of a master registration screen to the client terminal;
Master registration requesting means for receiving, from the client terminal, a set value of representative data items for a plurality of records inputted in the input field of the master registration screen displayed by the client terminal, and transmitting it to the server Request process,
In the server,
An input receiving process in which the input receiving means receives a set value of representative data items for a plurality of records from the portal server;
The data setting means includes a set value of an item type that is a specific data item included in the representative data item, and a product department and a purchase management department that are data items other than the representative data item of the plurality of data items. For each record received in the input reception process, from at least the subordinate data storage means that holds and associates the initial setting value of the subordinate data item whose setting value is not fixed when the setting value of the representative data item is input. The initial setting value of the corresponding subordinate data item is read according to the setting value of the specific data item of the record, and the setting value of the representative data item of the record and the initial setting value of the subordinate data item of the record Data setting process to output,
The registration unit generates a plurality of new records using the setting values of the representative data items and the initial setting values of the subordinate data items for the plurality of records output in the data setting process, and stores them in the master storage unit. A registration process for registering with the stored master data;
A master registration method characterized by comprising: A computer program used in a master registration system for registering a new record in the master data, comprising a server that holds master data composed of records having a plurality of data items, a portal server, and a client terminal,
A computer used as the portal server,
Screen data of the master registration screen that displays input fields for entering the set values of the item code, item text, item type, and basic unit of measure, which are representative data items of the plurality of data items, for a plurality of records Registration screen transmission means for transmitting to the client terminal,
Master registration requesting means for receiving, from the client terminal, set values of representative data items for a plurality of records, which are input in the input field of the master registration screen displayed by the client terminal, and transmitting to the server,
Function as
A computer used as the server;
Master storage means for storing the master data;
Input receiving means for receiving a set value of representative data items for a plurality of records from the portal server;
And material type setting a specific data item included in the representative data item is a data item other than the representative data item of the plurality of data items includes at least a division and purchasing department, the representative Subordinate data storage means for holding in association with an initial setting value of a subordinate data item for which a setting value is not fixed when inputting a setting value of the data item;
For each record received by the input receiving means, an initial set value of the corresponding dependent data item is read from the dependent data storage means according to the setting value of the specific data item of the record, and the representative for the record Data setting means for outputting a setting value of the data item and an initial setting value of the subordinate data item read out;
A plurality of new records are generated using the setting values of the representative data items and the initial setting values of the subordinate data items for the plurality of records output from the data setting means, and the master in the master storage means Registration means to register in the data,
Function as
A computer program characterized by the above.

Images