JP2016219066A - Commodity information management apparatus, commodity information management method, and commodity information management program - Google Patents

Abstract

An object of the present invention is to provide a product information management device, a product information management method, and a product information management program, which can easily set a product characteristic and a characteristic value arbitrarily.
In this embodiment, a characteristic (for example, color or size) relating to a product of clothing and a characteristic value that is a value of the characteristic (for example, white, black, blue, etc., when the characteristic is color) In this case, S, M, L, etc.) are acquired, and the acquired characteristic is set as the product fluctuation characteristic, and the acquired characteristic value is set in association with the acquired characteristic.
[Selection] Figure 8

Description

  The present invention relates to a product information management device, a product information management method, and a product information management program.

  Conventionally, when adding a characteristic relating to a product, the characteristic is added by changing a database for managing information related to the product.

  Here, patent document 1 is mentioned as a prior art document. Patent Document 1 discloses a technique for storing an arbitrary article in an article data file in the form of article data composed of the article code and attribute data.

Japanese Patent No. 2839773

  However, in order to add a characteristic, it is necessary to change the database, and the work is very troublesome.

  The present invention has been made in view of the above, and provides a merchandise information management device, a merchandise information management method, and a merchandise information management program that can easily set the characteristics and characteristic values of the merchandise easily. The purpose is to do.

  In order to solve the above-described problems and achieve the object, a product information management device according to the present invention includes a control unit and a storage unit, and is a product information management device that manages information related to a product, the control unit Is an acquisition means for acquiring a product characteristic that is a characteristic relating to a product and a product characteristic value that is a value of the product characteristic, and the product characteristic acquired by the acquisition means is a characteristic used in the configuration of the product in the product. And setting means for setting the product characteristic value acquired by the acquisition unit in the storage unit in association with the acquired product characteristic and setting the product characteristic value as a product variation characteristic that is a variable characteristic It is characterized by.

  Further, the product information management apparatus according to the present invention is the product information management apparatus, wherein the control unit is configured to obtain information on the product based on a product characteristic and / or a product characteristic value set in the storage unit. A creation means for creating is provided.

  The product information management device according to the present invention is the product information management device, wherein the storage unit includes a product number indicating a group obtained by grouping products according to a predetermined rule and a value of the product number. The product number value is set in association with each other, and the creation means uses the product number and / or product number value set in the storage unit and the product characteristic set in the storage unit and / or the information related to the product. It creates based on goods characteristic value.

  Further, the product information management device according to the present invention is the product information management device, wherein the acquisition means is a product number characteristic that is a property related to a product number indicating a group obtained by grouping products according to a predetermined rule, and The product number characteristic value which is the value of the product number characteristic is acquired, and the setting means uses the product number characteristic acquired by the acquisition means as a product number fixed characteristic which is a characteristic used for the structure of the product number and is a fixed characteristic in the product number. In addition to being set in the storage unit, the product number characteristic value acquired by the acquiring unit is set in the storage unit in association with the acquired product number characteristic.

  Further, the product information management device according to the present invention is the product information management device, wherein the acquisition means is a product category characteristic that is a property related to product category indicating a major product category and a product type that is a value of the product category characteristic. The classification characteristic value is acquired, and the setting unit stores the type classification characteristic acquired by the acquisition unit as a type classification fixed characteristic that is a characteristic used for the configuration of the type classification and is a fixed characteristic in the type classification. And setting the product category characteristic value acquired by the acquisition means in the storage unit in association with the acquired product category characteristic.

  A merchandise information management method according to the present invention is a merchandise information management method for managing information related to merchandise, which is executed by an information processing apparatus including a control unit and a storage unit, and is executed by the control unit. An acquisition step of acquiring a product characteristic that is a characteristic related to the product and a product characteristic value that is a value of the product characteristic, and the product characteristic acquired in the acquisition step is a characteristic used in the configuration of the product and varies in the product And setting the product characteristic value acquired in the acquisition step in the storage unit in association with the acquired product characteristic, and setting the product characteristic value acquired in the storage unit as the product variation characteristic Features.

  A product information management program according to the present invention is a product information management program for managing information related to a product to be executed by an information processing apparatus including a control unit and a storage unit, and is executed by the control unit. For obtaining a product characteristic that is a characteristic related to the product and a product characteristic value that is a value of the product characteristic, and the product characteristic obtained in the obtaining step is a characteristic used in the composition of the product And setting the product characteristic value acquired in the acquisition step in the storage unit in association with the acquired product characteristic, and setting the product characteristic value acquired in the acquisition step It is characterized by that.

  According to the present invention, a product characteristic that is a characteristic related to a product and a product characteristic value that is a value of the product characteristic are acquired, and the acquired product characteristic is a characteristic that is used in the configuration of the product and varies in the product. Is set in the storage unit as the product variation characteristic, and the acquired product characteristic value is set in the storage unit in association with the acquired product characteristic, so it is easy to arbitrarily set the product characteristic and the characteristic value There is an effect that it becomes feasible. Specifically, there is an effect that it is possible to set a plurality of characteristics and characteristic values of the product infinitely or with a predetermined upper limit.

  In addition, according to the present invention, the information about the product is created based on the product characteristics and / or the product characteristic values set in the storage unit, so the information about the products (for example, the product code and the product name) is automatically generated. There is an effect that it can be created.

  Further, according to the present invention, in the storage unit, a product number indicating a group obtained by grouping products according to a predetermined rule is set in association with a product number value that is a value of the product number. Since the information is created based on the product number and / or product number value set in the storage unit and the product characteristic and / or product characteristic value set in the storage unit, information about the product can be automatically created There is an effect that can be done.

  Further, according to the present invention, a product number characteristic that is a property related to a product number indicating a group obtained by grouping products according to a predetermined rule and a product number characteristic value that is a value of the product number characteristic are acquired, and the acquired product number The characteristic is set in the storage unit as a fixed product number characteristic that is a characteristic used in the configuration of the product number and is fixed in the product number, and the acquired product number characteristic value is associated with the acquired product number characteristic in the storage unit. Since the setting is performed, the characteristic and characteristic value of the product number can be arbitrarily set.

  In addition, according to the present invention, a variety classification characteristic that is a characteristic relating to a variety classification indicating a large classification of products and a variety classification characteristic value that is a value of the variety classification characteristic are acquired, and the acquired variety classification characteristic is represented as a variety classification. Is set in the storage unit as a type classification fixed characteristic that is a characteristic used in the configuration of the product type and is fixed in the type classification, and the acquired type classification characteristic value is associated with the acquired type classification characteristic in the storage unit. Since the setting is performed, there is an effect that the characteristics and characteristic values of the product classification can be arbitrarily set.

FIG. 1 is a block diagram illustrating an example of the configuration of the business management apparatus 100. FIG. 2 is a diagram illustrating an example of a product type master maintenance screen. FIG. 3 is a diagram illustrating an example of a product type master maintenance screen. FIG. 4 is a diagram illustrating an example of a product number master maintenance screen. FIG. 5 is a diagram illustrating an example of a product development screen. FIG. 6 is a diagram illustrating an example of the characteristic master maintenance screen. FIG. 7 is a diagram illustrating an example of a characteristic value master maintenance screen. FIG. 8 is a diagram illustrating an example of a characteristic definition master maintenance screen for each product category. FIG. 9 is a block diagram illustrating an example of the configuration of the business management apparatus 100. FIG. 10 is a diagram illustrating an example of the product type master maintenance screen. FIG. 11 is a diagram illustrating an example of a product number master maintenance screen. FIG. 12 is a diagram illustrating an example of the characteristic master maintenance screen. FIG. 13 is a diagram illustrating an example of a characteristic value master maintenance screen. FIG. 14 is a diagram illustrating an example of a product-specific characteristic definition master maintenance screen. FIG. 15 is a diagram illustrating an example of the sales details input screen.

  Embodiments of a product information management device, a product information management method, and a product information management program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[First embodiment]
A business management apparatus 100 according to a first embodiment including the present invention will be described with reference to FIGS.

[1. Overall Configuration of Business Management Device 100]
FIG. 1 is a block diagram illustrating an example of the configuration of the business management apparatus 100. The business management apparatus 100 is a stationary or portable information processing apparatus (for example, a desktop personal computer, etc.) in which an application (for example, a Web application) that supports business management (for example, sales management or inventory management) is installed. A laptop personal computer, a PDA (Personal Digital Assistant), a smartphone, a tablet personal computer, and the like.

  The business management apparatus 100 is communicably connected to an external server 200 (for example, a Web server) via a network 300 (for example, the Internet, an intranet, a LAN (Local Area Network), or the like).

  The business management apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the business management apparatus 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the business management apparatus 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, a memory device such as a random access memory (RAM) / read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

  The storage unit 106 includes a product type master 106a, a product master 106b, a product number master 106c, a product master 106d, a characteristic master 106e, a characteristic value master 106f, a characteristic definition master 106g, and a characteristic setting master 106h. Including. A specific example of information stored in each master will be described later.

  The control unit 102 is a CPU or the like that comprehensively controls the business management apparatus 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Run.

  The control unit 102 acquires a product characteristic that is a characteristic related to a product (a minimum unit of inventory management that can be mastered) and a product characteristic value that is a value of the product characteristic, and uses the acquired product characteristic for the configuration of the product. It is set in the storage unit 106 as a product variation characteristic that is a characteristic that changes in the product, and the acquired product characteristic value is set in the storage unit 106 in association with the acquired product characteristic.

  The control unit 102 acquires a product number characteristic that is a property related to a product number indicating a group obtained by grouping products according to a predetermined rule such as the same shape and the same design, and a product number characteristic value that is a value of the product number characteristic. The acquired product number characteristic is set in the storage unit 106 as a product number fixed characteristic that is a characteristic used in the configuration of the product number and is a fixed characteristic in the product number, and the acquired product number characteristic value is set to the acquired product number characteristic. May be set in the storage unit 106 in association with each other.

  In addition, the control unit 102 acquires a variety classification characteristic that is a characteristic related to a variety classification indicating a large classification of a product and a variety classification characteristic value that is a value of the variety classification characteristic, and the acquired variety classification characteristic is used as the classification classification. The characteristics used in the configuration and set in the storage unit 106 as a fixed product category characteristic that is a fixed property in the product category, and the storage unit 106 associates the acquired product category characteristic value with the acquired product category characteristic. May be set.

  Further, the control unit 102 is configured to store information on the product (for example, a product code (SKU (Stock Keeping Unit): minimum unit of product identification)) based on the product characteristic and / or the product characteristic value set in association with the storage unit 106. And product names). In addition, the control unit 102 converts the product number set in association with the storage unit 106 and / or the product number value that is the value of the product number and the product characteristic and / or product characteristic value set in association with the storage unit 106. Based on this, information regarding the product may be created.

  In terms of functional concept, the control unit 102 has a product type master management unit 102a, a product type master management unit 102b, a product number master management unit 102c, a product master management unit 102d, a characteristic master management unit 102e, and a characteristic value master management. Part 102f, characteristic definition master management part 102g, and characteristic setting master management part 102h. A specific example of processing performed in each unit will be described later.

[2. Specific example of information stored in each master of storage unit 106]
A specific example of information stored in each master in the storage unit 106 will be described in detail.

[2-1. Product classification master 106a]
The type classification master 106a is a master for setting the type classification. The content of the product code is determined in the category of product type classification. The product category master 106a is a master for holding, for example, that furniture and clothes are defined as product product category, and that N01 and N02 are defined as product category codes for each product category. .

  The product category master 106a includes, as items, “product category code”, “product category name”, “product category kana name”, “product number code automatic generation flag”, “product number code automatic generation category”, and “product specific category code”. , “Product identification category”, “Product code number of digits” and “Product code number of digits” are included, and the data storage column is provided for each item.

  In the data storage column of the item “product classification code”, a code value (for example, a number or a combination of letters and numbers) assigned to a character string (for example, clothing or furniture) defined as a product type classification is stored. Stored. In the data storage field of the item “product category name”, a character string defined as the product category is stored. In the data storage field of the item “Kate Category Kana Name”, a katakana character string defined as the category classification (for example, Fuku which is the Katakana name of the category “Clothing” or Kag which is the Katakana name of the category “Furniture”). Is stored.

  In the data storage field of the item “product number code automatic generation flag”, 0 assigned as the flag value of the predefined category “manual input” or 1 assigned as the flag value of the predefined category “automatic generation” Is stored. In the data storage column of the item “product number code automatic generation classification”, one of the character strings of the predefined classification “manual input” and “automatic generation” is stored.

  In the data storage column of the item “product specific category code”, 0 assigned as the code value of the predefined category “product number unit management” or assigned as the code value of the predefined category “product unit management” 1 is stored. In the data storage field of the item “product specific category”, a character string of any of the predefined categories “product number unit management” and “product unit management” is stored.

  The number of digits of the code value assigned to the product number is stored in the data storage column of the item “number of product code”. In the data storage column of the item “product code digit number”, the number of digits of the code value assigned to the product is stored.

[2-2. Product type master 106b]
The product type master 106b is a master for setting a product type indicating the middle classification of products. Variety is a further refinement of the variety classification. The product master 106b, for example, defines the kitchen, living room, and bedroom as the product category “furniture”, defines the T-shirt and cut-and-sew as the product category “clothes”, It is a master for holding that the product type code has been defined.

  The product master 106b includes, as items, “product code”, “product name”, “product name”, “product category code”, “product category name”, “inventory evaluation aggregation classification code”, “inventory evaluation aggregation classification”. , “Inventory valuation standard code”, “Individual inventory valuation unit price calculation classification code”, “Sales cost calculation classification code”, “Standard unit price” and “Part number classification code” are included, and the data storage column for each item Is a master.

  In the data storage column of the item “product code”, a character string defined as a product type (for example, a T-shirt or a cut-and-saw product defined as a product type of the product category “clothes” is defined as a product type of the product category “furniture”. Code values assigned to the kitchen, living room, bedroom, etc.) are stored. A character string defined as a product type is stored in the data storage field of the item “product name”. In the data storage column for the item “Kana Kana”, a Katakana character string defined as a Kana (for example, a T-shirt that is a Katakana Kana for the “T-shirt” or a Shinshitsu Kakana Kana for the “Bedroom”) is stored. Is done.

  The code value assigned to the character string defined as the product type classification is stored in the data storage column of the item “product type code”. In the data storage field of the item “product category name”, a character string defined as the product category is stored.

  In the data storage column of the item “inventory evaluation aggregation classification code”, 0 or the like assigned as the code value of the predefined classification “product evaluation” is stored. In the data storage column of the item “inventory evaluation aggregation category”, a predefined character string of the category “evaluation by product” is stored.

  In the data storage column of the item “inventory evaluation reference code”, a code value assigned to a predetermined reference category is stored. In the data storage field of the item “individual inventory evaluation unit price calculation classification code”, a code value assigned to a predefined calculation classification is stored. In the data storage column of the item “sales cost calculation category code”, a code value assigned to a predefined calculation category is stored. The standard unit price is stored in the data storage column of the item “standard unit price”. In the data storage column of the item “product number classification code”, a code value assigned to a predefined product number classification is stored.

[2-3. Part number master 106c]
The product number master 106c is a master for setting the product number. For example, the product number master 106c defines that the dining table and sofa are defined as the product number of the product category “furniture”, H01 and H02 are defined as the product code for each product number, and the product number of the product category “clothes”. As a master for holding that a T-shirt border has been defined and that H03 has been defined as a part number code for the part number. The information stored in the product number master 106c may be automatically created from the product type master 106a or the product master 106b. For example, the part number code may be numbered by a kind classification code or a combination of a kind code and a characteristic value code.

  The item number master 106c includes, as items, “item number code”, “item number name”, “item number kana name”, “product type classification code”, “product type name”, “characteristic code”, “characteristic name”, and “characteristic value”. And “characteristic value name”, and a data storage column is provided for each item.

  In the data storage field of the item “product number code”, a character string defined as the product number (for example, a dining table or sofa defined as the product number of the product category “furniture” is defined as the product number of the product category “clothes”). A code value assigned to a T-shirt border or the like is stored. A character string defined as a product number is stored in the data storage field of the item “product number name”. In the data storage column of the item “product number kana name”, a katakana character string defined as the product number (for example, a t-shirt border which is a katakana name of the product number “T-shirt border”) is stored.

  The code value assigned to the character string defined as the product type classification is stored in the data storage column of the item “product type code”. In the data storage field of the item “product category name”, a character string defined as the product category is stored.

  In the data storage column of the item “characteristic code”, a code value (for example, the characteristic “manufacturer” is assigned to a character string defined as the characteristic (for example, manufacturer, item, serial number, year, season, color, or size)). , Assigned to characteristic “item”, RENBAN assigned to characteristic “serial number”, YEAR assigned to characteristic “year”, SEASON assigned to characteristic “season”, characteristic “ COLOR assigned to “color” or SIZE assigned to characteristic “size”, etc.). In the data storage column of the item “characteristic name”, a character string defined as a characteristic is stored.

  In the data storage column of the item “characteristic value”, a numerical value or a code value assigned to the character string defined as the characteristic value is stored. A character string defined as a characteristic value is stored in the data storage column of the item “characteristic value name”. Here, the character string defined as the characteristic value is, for example, a XX company and a XX company defined as the characteristic value of the characteristic “manufacturer”, a dining table or tableware defined as the characteristic value of the characteristic “item” Shelf and living board, 2011 defined as characteristic value of characteristic “year”, spring and summer and winter defined as characteristic value of characteristic “season”, white, black and defined as characteristic value of characteristic “color” Blue, S, M and L, etc., defined as characteristic values of characteristic “size”. The numerical value or code value assigned to the character string defined as the characteristic value is, for example, 01 assigned to the characteristic value “XX company”, 02 assigned to the characteristic value “XX company”, characteristic 00 assigned to the value “dining table”, 01 assigned to the characteristic value “cupboard”, 02 assigned to the characteristic value “living board”, 11 assigned to the characteristic value “2011”, and the characteristic value “ 00 assigned to “spring and summer”, 01 assigned to characteristic value “autumn / winter”, 00 or WH assigned to characteristic value “white”, 01 or BL assigned to characteristic value “black”, characteristic value “blue” 02 assigned to "", 00 assigned to the characteristic value "S", 01 assigned to the characteristic value "M", 02 assigned to the characteristic value "L", and so on.

[2-4. Product master 106d]
The product master 106d is a master for setting a product code (SKU) of a product. The merchandise master 106d, for example, defines that the dining table white and the dining table black are defined as the products of the product category “furniture”, H01100 and H01101 are defined as the product code for each product, and the product category “clothes” "T-shirt border white L, T-shirt border white M, and T-shirt border blue M are defined as products", and H030000, H030001, and H030201 are defined as product codes for the respective products. Master for. Information stored in the product master 106d is automatically created from the product number master 106c. For example, the product code is numbered by a combination of a product number code and a characteristic value code.

  The product master 106d includes “product code”, “product name”, “color”, “size”, “JANCD”, and “standard unit price” as items, and a data storage column is provided for each item. Master.

  In the data storage column of the item “product code”, a character string defined as a product (for example, a combination of a product number and a characteristic value (for example, a dining table white or a dining table black defined as a product of the product category “furniture”) , Or T-shirt border white L, T-shirt border white M, or T-shirt border blue M defined as a product of the category “clothes”, etc.) A combination of codes and / or characteristic values, etc.) is stored. A character string defined as a product is stored in the data storage column of the item “product name”. In the data storage column of the item “color”, the characteristic value of the characteristic “color” (set as the commodity variation characteristic) used for the composition of the commodity is stored. In the data storage column of the item “size”, the characteristic value of the characteristic “size” (set as the commodity variation characteristic) used for the composition of the commodity is stored.

  In the data storage column of the item “JANCD”, a JANCD (Japan Article Number Code) of the product is stored. In the data storage column of the item “standard unit price”, the standard unit price of the product is stored.

[2-5. Characteristics master 106e]
The characteristic master 106e is a master for setting a characteristic that is a component of a category (product type classification, product number, and product). Each characteristic is divided into a component that is a component of a product type classification, a component that is a component of a product number, a component that is a component of a product, and the like.

  The characteristic master 106e includes, for example, that a manufacturer is defined as a characteristic used for the configuration of the product type classification, a code value is defined as the type of the characteristic value code for the characteristic, and a characteristic used for the configuration of the product number. The item, serial number, year and season have been defined, the code value has been defined as the type of characteristic value code for those characteristics, and the color and size have been defined as characteristics used in the composition of the product And a master for holding that a code value is defined as a type of characteristic value code for these characteristics.

  The characteristic master 106e includes, as items, “characteristic code”, “characteristic name”, “characteristic abbreviation name”, “English character name”, “part number fixed use disabled flag”, “part number fixed use disabled classification”, “product variable use” "Unusable flag", "Product variable unusable category", "Product category fixed fixed unavailable flag", "Product category fixed unusable category", "Characteristic value code digits", "Serial number flag", "Serial number category" and A “display order” is included, and the data storage column is provided for each item.

  In the data storage column of the item “characteristic code”, a code value assigned to a character string defined as a characteristic is stored. In the data storage column of the item “characteristic name”, a character string defined as a characteristic is stored. An abbreviation of a character string defined as a characteristic is stored in the data storage column of the item “characteristic abbreviation”. In the data storage column of the item “English character name”, an alphabetic character corresponding to the character string defined as the characteristic (for example, Maker corresponding to the characteristic “manufacturer”, Item corresponding to the characteristic “item”, characteristic “serial number”) , Corresponding to the characteristic “year”, Season corresponding to the characteristic “season”, Color corresponding to the characteristic “color”, or Size corresponding to the characteristic “size”, and the like.

  In the data storage field of the item “Part number fixed use disabled flag”, a code value of the category “Useable” defined in advance to hold whether or not the character string defined as the characteristic is set as the part number fixed characteristic 0 or 1 assigned as a code value of the predefined category “unusable” is stored. In the data storage field of the item “Part No. Fixed Use Unusable”, in order to retain whether or not the character string defined as the characteristic is set as the Part No. fixed characteristic, the pre-defined categories “Use Available” and “Use” One of the character strings “impossible” is stored.

  In the data storage field of the item “product fluctuation unavailable flag”, it is assigned as the code value of the category “usable” in order to hold whether or not the character string defined as the characteristic is set as the product fluctuation characteristic 0 or 1 assigned as the code value of the category “unusable” is stored. In the data storage field of the item "Product fluctuation unavailable category", either the category "Usable" or "Unusable" is used to hold whether or not the character string defined as the characteristic is set as the product fluctuation characteristic. Is stored.

  In the data storage field of the item “Product category fixed use disabled flag”, it is assigned as a code value for the category “Available” in order to retain whether or not the character string defined as the property is set as the product type fixed property 0 assigned or 1 assigned as the code value of the section “unusable” is stored. In the data storage column of the item “Product type fixed use disabled category”, the categories “available” and “unavailable” are used to hold whether or not the character string defined as the characteristic is set as the product type fixed characteristic. One of the character strings is stored.

  The number of digits of the characteristic value code is stored in the data storage column of the item “characteristic value code digit”. In the data storage column of the item “serial number flag”, 0 or the like assigned as a flag value of the predefined category “normal” is stored. In the data storage column of the item “serial number classification”, a character string of the classification “normal” is stored. A numerical value indicating the display order is stored in the data storage column of the item “display order”.

[2-6. Characteristic value master 106f]
The characteristic value master 106f is a master for setting a characteristic value (numerical value or code value) and its name, which are set in the characteristic master 106e and are components of the category. There are two types of characteristic value codes: code values and numerical values. When the type of the characteristic value code is a code value, it is necessary to register the code value in the characteristic value master 106f. When the characteristic value code type is a numerical value, it is not necessary to register the numerical value in the characteristic value master 106f, and the numerical value can be freely set by user input.

  In the characteristic value master 106f, for example, a dining table, a cupboard, and a living board are defined as characteristic values of the characteristic “item”, 00, 01, and 02 are defined as their characteristic value codes, XX company and XX company are defined as the characteristic values of “Manufacturer”, 01 and 02 are defined as their characteristic value codes, and white, black and blue as characteristic values of characteristic “Color” Is defined, 00, 01 and 02 are defined as their characteristic value codes, L, M and S are defined as characteristic values of the characteristic “size”, and their characteristic value codes As a master for holding 00, 01 and 02 defined as

  The characteristic value master 106f includes, as items, "characteristic code", "characteristic name", "characteristic value", "characteristic value name", "characteristic value abbreviation name", "alphabetic characteristic value name", and "display order". The master is provided with a data storage column for each item.

  In the data storage column of the item “characteristic code”, a code value assigned to a character string defined as a characteristic is stored. In the data storage column of the item “characteristic name”, a character string defined as a characteristic is stored. In the data storage column of the item “characteristic value”, a numerical value or a code value assigned to the character string defined as the characteristic value is stored. A character string defined as a characteristic value is stored in the data storage column of the item “characteristic value name”.

  In the data storage column of the item “characteristic value abbreviation name”, an abbreviation of a character string defined as a characteristic value is stored. In the data storage column of the item “English character characteristic value name”, an English character corresponding to the character string defined as the characteristic value (for example, WHITE corresponding to the characteristic value “white”, Black corresponding to the characteristic value “black”, or the characteristic Blue corresponding to the value “blue”, etc.) is stored. A numerical value indicating the display order is stored in the data storage column of the item “display order”.

[2-7. Property definition master 106g]
The characteristic definition master 106g is a characteristic definition master for each product category for defining which characteristic is held for each category. The characteristics can be set indefinitely. It should be noted that it is possible for the user to freely set which category (product, product number or product type) the characteristic is applied to.

  In the property definition master 106g, for example, in the product category “furniture”, a manufacturer is defined as a property used for the configuration of the product category (product category fixed property: a fixed property in the product category), and a property ( Item number fixed characteristics (characteristics fixed in the part number) and items and serial numbers are defined. Colors are defined as characteristics used in the composition of the product (product variation characteristics: characteristics that vary in the product) The manufacturer was defined as the characteristics used for the composition of the product category, the year, season and serial number were defined as the characteristics used for the composition of the product number, and the color and size were defined as the characteristics used for the composition of the product It is a master for holding things. In addition, by setting a serial number as a characteristic used for the configuration of the product number, it is possible to automatically assign a product number code for each manufacturer and item, or for each manufacturer, year and season.

  The characteristic definition master 106g includes, as items, “product category code”, “product category name”, “product code number of digits”, “product code digit number”, “category category”, “row”, “characteristic”, “product number”. This is a master that includes a “code configuration characteristic”, “code configuration digit number”, and “product type classification characteristic value”, and is provided with a data storage column for each item.

  The code value assigned to the character string defined as the product type classification is stored in the data storage column of the item “product type code”. In the data storage field of the item “product category name”, a character string defined as the product category is stored. The number of digits of the product number code is stored in the data storage column of the item “number of product number code”. In the data storage column of the item “product code digit number”, the number of digits of the product code is stored.

  In the data storage column of the item “category category”, a character string of any of the predefined categories “product type fixed property”, “product number fixed property”, and “product variation property” is stored. In the data storage column of the item “line”, a numerical value indicating the line number is stored. A character string defined as a characteristic is stored in the data storage field of the item “characteristic”. Whether these predefined characteristics are set as the product type fixed property, the product number fixed property, or the product variation property is managed in these fields.

  In the data storage column of the item “product number code configuration characteristic”, a character string of one of the predefined categories “normal characteristic” and “product number code configuration characteristic” is stored. A numerical value indicating the number of digits is stored in the data storage column of the item “number of digits of code configuration”.

  In the data storage column of the item “product classification characteristic value”, the character string defined as the characteristic value of the characteristic used for the structure of the product classification (for example, the characteristic of the manufacturer “manufacturer” used for the structure of the product classification “clothes”) Value brand A, etc.) is stored.

[2-8. Characteristic setting master 106h]
The characteristic setting master 106h is a characteristic setting master for each category for defining which characteristic value is held for each category and for each characteristic.

  For example, in the property setting master 106h, in the product category “furniture”, the properties used for the product category configuration and the property values thereof are defined by the manufacturer and XX company, or in the product “dining table”, the product configuration The color and white are defined as the characteristics used for the product and the characteristic values, and the manufacturer and XX company are defined as the characteristics used for the composition of the product classification and the property values in the product classification “clothes”. In the product number “T-shirt”, the characteristics used for the composition of the product number and the characteristic values are defined as the year and 2012, season and spring / summer, and the product “T-shirt” is used for the composition of the product. It is a master for holding a characteristic and that color and red are defined as the characteristic value.

  The characteristic setting master 106h includes “category classification”, “category code”, “characteristic code”, “characteristic value”, and “characteristic numerical value” as items, and a data storage column is provided for each item. Is a master.

  In the data storage column of the item “category category”, a character string of any of the categories “product variation characteristics”, “product number fixed characteristics”, or “product type fixed characteristics” is stored. In the data storage column of the item “category code”, the code value assigned to the category “product fluctuation characteristic”, the code value assigned to “part number fixed characteristic” (for example, part number code), or “product type fixed characteristic” is displayed. Stores the assigned code value.

  In the data storage column of the item “characteristic code”, a code value assigned to a character string defined as a characteristic is stored. In the data storage column of the item “characteristic value”, a numerical value or a code value assigned to the character string defined as the characteristic value is stored. In the data storage column of the item “characteristic value”, a numerical value assigned to the character string defined as the characteristic value is stored.

[3. Specific Example of Processing Performed by Each Processing Unit of Control Unit 102]
A specific example of processing performed by each processing unit of the control unit 102 will be described in detail.

[3-1. Product type master management unit 102a]
The product classification master management unit 102a displays a screen for managing the product classification master 106a on the monitor 114, and manages information in the product classification master 106a based on an instruction from the user made through the screen. . Here, an example of a screen for managing the product type classification master 106a will be described with reference to FIG.

  FIG. 2 is a diagram showing an example of the product category master maintenance screen MA. The product category master maintenance screen MA includes an area MA1, a new button, a delete button, an edit button, and a registration button. The area MA1 is an area for displaying information in the product category master 106a. The region MA1 includes information on the product category code, product category name, product category name, product number code automatic generation category, and product specification category. Are displayed in matrix form.

  The new button is a button for selecting new registration of information in the product type classification master 106a. The delete button is a button for selecting deletion of information in the product category master 106a. The edit button is a button for selecting editing of information in the product category master 106a (information included in the row selected in the area MA1). The registration button is a button for selecting registration of information displayed in the area MA1 to the product type classification master 106a.

  When the user operates the input device 112 to edit (correct or change) the information displayed in the area MA1 and selects the registration button, the product type classification master management unit 102a displays the information in the area MA1. The stored information is stored (overwritten) in the product type classification master 106a.

[3-2. Product master management unit 102b]
The product master management unit 102b displays a screen for managing the product master 106b on the monitor 114, and manages information in the product master 106b based on an instruction from the user through the screen. Here, an example of a screen for managing the product type master 106b will be described with reference to FIG.

  FIG. 3 is a diagram showing an example of the product type master maintenance screen MB. The product master maintenance screen MB includes an area MB1, an area MB2, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button. The area MB1 is an area for inputting a product type code and a product type classification code. The area MB2 is an area for displaying information in the product master 106b, and in the region MB2, information on the product code, product name, product kana name, product classification code, product category name, and inventory evaluation aggregation category is stored. Displayed in matrix form.

  The new button is a button for selecting new registration of information in the product type master 106b. The delete button is a button for selecting deletion of information in the product type master 106b. The search button is a button for selecting a search for information in the product master 106b based on the product code and product classification code input in the area MB1. The cancel button is a button for canceling the search for information in the product master 106b. The edit button is a button for selecting editing of information in the product type master 106b (information included in the row selected in the area MB2). The registration button is a button for selecting registration of information displayed in the area MB2 to the product type master 106b.

  When the user operates the input device 112 to edit the information displayed in the area MB2 to a desired one and selects a registration button, the product master management unit 102b converts the information displayed in the region MB2 into the product type. Store in the master 106b.

[3-3. Part number master management unit 102c]
The product number master management unit 102c displays a screen for managing the product number master 106c on the monitor 114, and manages information in the product number master 106c based on an instruction from the user through the screen. Here, an example of a screen for managing the product number master 106c will be described with reference to FIG.

  FIG. 4 is a diagram showing an example of the product number master maintenance screen MC. The product number master maintenance screen MC includes an area MC1, an area MC2, a product expansion button, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button.

  The area MC1 is an area for inputting a product type classification code and a product number code and displaying a product type classification name. The area MC2 is a first area for inputting a product number, a second area for inputting information on characteristics used for the configuration of the product type, and a third area for inputting information on characteristics used for the configuration of the product number. Area.

  The second area includes a line number, a characteristic code (for example, MAKER assigned to the characteristic “manufacturer”), a characteristic (for example, the characteristic “manufacturer”), and a characteristic value code (for example, the characteristic value “brand A”). Assigned 1) and a characteristic value (for example, a characteristic value “Brand A” etc.) are displayed.

  The third area includes a line number and a characteristic code (eg, YEAR assigned to the characteristic “year”, SEASON assigned to the characteristic “season”, RENBAN assigned to the characteristic “serial number”) and a characteristic (eg, , Characteristics “year”, “season”, “serial number”, etc.) and characteristic value code (for example, 32 assigned to characteristic value “2032”, 42 assigned to characteristic value “spring / summer”, etc.) and characteristic A value (for example, characteristic value “2032”, “spring / summer”, etc.) is displayed.

  The product development button is a button for selecting automatic creation of information stored in the product master 106d. The new button is a button for selecting new registration of information in the product number master 106c. The delete button is a button for selecting deletion of information in the product number master 106c. The search button is a button for selecting a search for information in the product number master 106c based on the product type classification code and the product number code input in the area MC1. The cancel button is a button for canceling the search for information in the product number master 106c. The edit button is a button for selecting editing of information in the product number master 106c. The registration button is a button for selecting registration of information displayed in the area MC1 and the area MC2 in the product number master 106c.

  When the user operates the input device 112 and selects the registration button, the product number master management unit 102c creates a code value defined as the product number code by combining the product code, the characteristic value code, and / or the characteristic value, The created code value may be registered in the product number master 106c. The product number master management unit 102c may create a character string defined as the product number by combining the product type and the characteristic value, and register the created product number (character string) in the product number master 106c.

[3-4. Product master management unit 102d]
The product master management unit 102d is included in the creation unit of the present invention, displays a screen for managing the product master 106d on the monitor 114, and receives an instruction from the user through the screen. The information stored in the product master 106d is automatically created based on the information stored in the product number master 106c and the characteristic value master 106f, thereby managing the information in the product master 106d. Here, an example of a screen for managing the product master 106d will be described with reference to FIG.

  FIG. 5 is a diagram illustrating an example of the product development screen MD. When the user operates the input device 112 to select the product development button on the product number master maintenance screen MC described above, the product master management unit 102d displays the product development screen MD on the monitor 114. The merchandise expansion screen MD includes an area MD1, a new line button, a delete line button, a cancel button, a line edit button, an automatic expansion button, and a registration button.

  In the area MD1, information on a product code, a product name, a color and size defined as a characteristic used for the composition of the product (specifically, a product variation characteristic), JANCD, and a standard unit price are displayed in a matrix format. Displayed as editable. Each row in the area MD1 is provided with a check box for selecting deletion of information included in the row.

  The new line button is a button for selecting addition of a line to the area MD1. The row deletion button is a button for selecting deletion of information displayed in a row whose check box is checked. The cancel button is a button for selecting cancellation (cancellation) of the check attached to the check box. The row edit button is a button for selecting editing of information displayed in a row in which a check box is checked. The automatic expansion button is a button for selecting execution of automatic creation of information stored in the product master 106d. The registration button is a button for selecting registration of information displayed in the area MD1 to the product master 106d.

  When the user operates the input device 112 and selects the automatic expansion button, the product master management unit 102d creates a code value defined as the product code by combining the product number code and the characteristic value code and / or the characteristic value. The created product code is displayed in the area MD1. The product master management unit 102d creates a character string defined as a product by combining the product number and the characteristic value, and displays the created product (character string) in the area MD1. The product master management unit 102d extracts the characteristic value code and the characteristic value from the characteristic value master 106f based on the characteristic “color” and “size” characteristic codes defined as the product variation characteristic, and extracts the extracted characteristic value in the region MD1. To display.

  For example, 324200 is input as the product number code, and BP, GP, RE, SG, SL, SW, WH, WR, and YE are extracted as the characteristic value code of the characteristic “color” defined as the product fluctuation characteristic. When S, M, and L are extracted as the characteristic values of the characteristic “size” defined as “product size”, the product master management unit 102d transmits the product number code “324200” and the respective characteristic value codes “BP” to “YE”. The code values from 324200BPS to 324200YEL are automatically created as product codes by sequentially combining the characteristic values “S” to “L”.

  Also, for example, “T-shirt” is input as the product number, and the characteristic value of the characteristic “color” defined as the product variation characteristic is BP pink, GP gold, RE red, SG gold, SL silver, SW white, WH white, When WR red and YE yellow are extracted, and S, M, and L are extracted as characteristic values of the characteristic “size” defined as the commodity variation characteristic, the commodity master management unit 102d determines the product number “T-shirt” and each Character strings “Pink” to “Yellow” included in the characteristic value and each characteristic value “S” to “L” are combined in order, and the character string from T-shirt pink S to T-shirt yellow L is automatically used as a product. create.

  When the user operates the input device 112 and selects the registration button, the product master management unit 102d registers the information displayed in the area MD1 of the product development screen MD and the information extracted from the characteristic value master 106f in the product master 106d. To do.

[3-5. Characteristics master management unit 102e]
The characteristic master management unit 102e is included in the acquisition unit and the setting unit of the present invention, and displays a screen for managing the characteristic master 106e on the monitor 114, and from the user performed through the screen. Information in the characteristic master 106e is managed based on the instruction. Here, an example of a screen for managing the characteristic master 106e will be described with reference to FIG.

  FIG. 6 is a diagram illustrating an example of the characteristic master maintenance screen ME. The characteristic master maintenance screen ME includes an area ME1, an area ME2, a search button, a cancel button, and a registration button.

  The area ME1 is an area for inputting and displaying the characteristic code. In the area ME2, the characteristic name, characteristic abbreviation name, alphabetic characteristic name, part number fixed use disable flag, product variable use disable flag, product type fixed use disable flag, characteristic value code digit number, serial number flag, and display order are input. Or a product number fixed use disabled category, a product variable fixed use disabled category, a product category fixed use disabled category, and a serial number category.

  The search button is a button for selecting search of information in the characteristic master 106e based on the characteristic code input in the area ME1. The cancel button is a button for canceling the search for information in the characteristic master 106e. The registration button is a button for selecting registration of information displayed in the area ME1 and the area ME2 in the characteristic master 106e.

  When the user operates the input device 112 to input desired information in the area ME1 and the area ME2 and selects a registration button, the characteristic master management unit 102e sets the information displayed in the area ME1 and the area ME2 as characteristics. Register with the master 106e.

[3-6. Characteristic value master management unit 102f]
The characteristic value master management unit 102f is included in the acquisition unit and the setting unit of the present invention, and displays a screen for managing the characteristic value master 106f on the monitor 114, and a user performed via the screen The information in the characteristic value master 106f is managed based on the instruction from. Here, an example of a screen for managing the characteristic value master 106f will be described with reference to FIG.

  FIG. 7 is a diagram illustrating an example of the characteristic value master maintenance screen MF. The characteristic value master maintenance screen MF includes an area MF1, an area MF2, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button.

  The area MF1 is an area for inputting a characteristic code and displaying a characteristic corresponding to the input characteristic code. The area MF2 is an area for inputting and displaying a characteristic value, a characteristic value name, a characteristic value abbreviation name, an alphabetic characteristic value name, and a display order.

  The new button is a button for selecting new registration of information in the characteristic value master 106f. The delete button is a button for selecting deletion of information in the characteristic value master 106f. The search button is a button for selecting a search for information in the characteristic value master 106f based on the characteristic code input to the area MF1. The cancel button is a button for canceling the search for information in the characteristic value master 106f. The edit button is a button for selecting editing of information in the characteristic value master 106f (information included in the row selected in the region MF2). The registration button is a button for selecting registration of information displayed in the area MF1 and the area MF2 in the characteristic value master 106f.

  When the user operates the input device 112 to input desired information in the areas MF1 and MF2 and selects a registration button, the characteristic value master management unit 102f displays the information displayed in the areas MF1 and MF2. It is registered in the characteristic value master 106f.

[3-7. Property definition master management unit 102g]
The property definition master management unit 102g is included in the acquisition unit and the setting unit of the present invention, and displays a screen for managing the property definition master 106g on the monitor 114, and a user performed via the screen. The information in the property definition master 106g is managed based on the instruction from. Here, an example of a screen for managing the characteristic definition master 106g will be described with reference to FIG.

  FIG. 8 is a diagram illustrating an example of the characteristic definition master maintenance screen MG. The characteristic definition master maintenance screen MG includes an area MG1, an area MG2, an area MG3, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button.

  The area MG1 is an area for inputting a product type classification code and displaying a product type classification, a product number code digit number, and a product code digit number corresponding to the inputted product type classification code. The area MG2 is an area for inputting and displaying the category classification, the line, the characteristic, the product number code configuration characteristic, the code configuration digit number, and the product classification characteristic value. The area MG3 is an area for displaying the number of used digits and the number of usable digits for the product number code and the product code.

  In the category classification of the region MG2, a character string of any of the predefined classifications “product type fixed characteristics”, “part number fixed characteristics”, and “product variation characteristics” is displayed. A character string defined as a characteristic is displayed as the characteristic of the region MG2. In the product number code configuration characteristic of the area MG2, a character string of any of the predefined categories “normal characteristic” and “product number code configuration characteristic” is displayed. In the category classification characteristic value of the area MG2, the characteristic value of the characteristic used for the configuration of the category classification is displayed.

  The new button is a button for selecting new registration of information in the characteristic definition master 106g. The delete button is a button for selecting deletion of information in the characteristic definition master 106g. The search button is a button for selecting a search for information in the characteristic definition master 106g based on the product type classification code input in the region MG1. The cancel button is a button for canceling the search for information in the characteristic definition master 106g. The edit button is a button for selecting editing of information in the property definition master 106g (information included in the row selected in the region MG2). The registration button is a button for selecting registration of information displayed in the area MG1 and the area MG2 in the characteristic definition master 106g.

  When the user operates the input device 112 to input desired information in the areas MG1 and MG2 and selects a registration button, the property definition master management unit 102g displays the information displayed in the areas MG1 and MG2. Register in the property definition master 106g.

[3-8. Characteristic setting master management unit 102h]
The characteristic setting master management unit 102h automatically creates the information stored in the characteristic setting master 106h based on the information stored in the product number master 106c, the commodity master 106d, and the characteristic definition master 106g. Information in 106h is managed. Specifically, the characteristic setting master management unit 102h sets the characteristic code and characteristic value (characteristic value) when the type classification fixed characteristic is selected as the category classification on the characteristic definition master maintenance screen MG shown in FIG. Set (register). Further, the characteristic setting master management unit 102h registers the characteristic value information of the fixed part number characteristic included in the part number master maintenance screen MC shown in FIG. 4 in the characteristic setting master 106h. Further, the characteristic setting master management unit 102h registers the characteristic value information of the commodity variation characteristic included in the commodity development screen MD shown in FIG. 5 in the characteristic setting master 106h.

[Second Embodiment]
A business management apparatus 100 according to a second embodiment including the present invention will be described with reference to FIGS. In the second embodiment, descriptions overlapping with the first embodiment may be omitted.

[1. Overall Configuration of Business Management Device 100]
FIG. 9 is a block diagram illustrating an example of the configuration of the business management apparatus 100. The storage unit 106 includes a product type master 106b, a product number master 106c, a product master 106d, a characteristic master 106e, a characteristic value master 106f, a characteristic definition master 106g, a characteristic setting master 106h, and sales input data 106i. Including. An example of information stored in each master will be described later.

  The control unit 102 acquires a product characteristic that is a characteristic related to a product (a minimum unit of inventory management that can be mastered) and a product characteristic value that is a value of the product characteristic, and uses the acquired product characteristic for the configuration of the product. It is set in the storage unit 106 as a product variation characteristic that is a characteristic that changes in the product, and the acquired product characteristic value is set in the storage unit 106 in association with the acquired product characteristic.

  The control unit 102 acquires a product number characteristic that is a property related to a product number indicating a group obtained by grouping products according to a predetermined rule such as the same shape and the same design, and a product number characteristic value that is a value of the product number characteristic. The acquired product number characteristic is set in the storage unit 106 as a product number fixed characteristic that is a characteristic used in the configuration of the product number and is a fixed characteristic in the product number, and the acquired product number characteristic value is set to the acquired product number characteristic. May be set in the storage unit 106 in association with each other.

  Further, the control unit 102 is configured to store information on the product (for example, a product code (SKU (Stock Keeping Unit): minimum unit of product identification)) based on the product characteristic and / or the product characteristic value set in association with the storage unit 106. And product names). In addition, the control unit 102 converts the product number set in association with the storage unit 106 and / or the product number value that is the value of the product number and the product characteristic and / or product characteristic value set in association with the storage unit 106. Based on this, information regarding the product may be created.

  In terms of functional concept, the control unit 102 has a product type master management unit 102b, a product number master management unit 102c, a product master management unit 102d, a characteristic master management unit 102e, a characteristic value master management unit 102f, and a characteristic definition master management. A section 102g, a characteristic setting master management section 102h, and a sales input execution section 102i. An example of processing performed in each unit will be described later.

[2. Specific example of information stored in each master of storage unit 106]
A specific example of information stored in each master in the storage unit 106 will be described in detail.

[2-1. Product type master 106b]
The type master 106b is a master for setting a type indicating the classification of the product number. The product master 106b is a master for holding that, for example, H steel is defined as the product type, N01 is defined as the product code for the product type, and the like.

  The product master 106b includes, as items, “product code”, “product name”, “product name”, “inventory management unit value”, “inventory management unit”, “inventory evaluation aggregation classification code”, “inventory evaluation aggregation classification category”. ”,“ Inventory evaluation standard code ”,“ Individual inventory evaluation unit price calculation classification code ”,“ Sales cost calculation classification code ”and“ Standard unit price ”are included, and a data storage column is provided for each item. Master.

  In the data storage column of the item “product code”, a code value assigned to a character string defined as a product type (for example, a steel plate defined as a product type) is stored. A character string defined as a product type is stored in the data storage field of the item “product name”. In the data storage column of the item “product type name”, a katakana character string defined as the product type (for example, Itako, which is a katakana name of the product type “plate steel”) is stored.

  In the data storage column of the item “inventory management unit value”, a numerical value (number of sheets) relating to a predefined inventory management unit “sheet” is stored. In the data storage column of the item “inventory management unit”, a character of a predefined inventory management unit “sheet” is stored.

[2-2. Part number master 106c]
The product number master 106c is a master for setting the product number. The product number master 106c is a master for holding, for example, that H steel 60 × 60 is defined as the product number of the product type “H steel”, and that H01 is defined as the product number code for the product number. The information stored in the product number master 106c may be automatically created from the product type master 106b. For example, the product number code may be numbered by a combination of a product type code and a characteristic value code.

  The product number master 106c includes, as items, “product number code”, “product number name”, “product number kana name”, “product code”, “product name”, “characteristic code”, “characteristic name”, “characteristic value”, and “characteristic value”. “Numerical value” is included, and the data storage column is provided for each item.

  In the data storage field of the item “product number code”, a code assigned to a character string defined as the product number (for example, SPHC plate steel 2.0 × 914 × 1829 defined as the product number of the type “sheet steel”). Stores the value. A character string defined as a product number is stored in the data storage field of the item “product number name”. In the data storage column of the item “product number kana name”, a katakana character string defined as the product number (for example, Itako, which is a katakana name of the product number “SPHC plate steel 2.0 × 914 × 1829”) is stored.

  In the data storage column of the item “product code”, code values assigned to character strings defined as product types are stored. A character string defined as a product type is stored in the data storage field of the item “product name”.

  In the data storage field of the item “characteristic code”, a code assigned to a character string (for example, manufacturer, thickness, width, length, etc.) defined as a characteristic used for the configuration of the category (product type, product number, and product) The values (for example, Maker assigned to the characteristic “manufacturer”, Thickness assigned to the characteristic “thickness”, Width assigned to the characteristic “width”, Length assigned to the characteristic “length”, etc.) are stored. The In the data storage column of the item “characteristic name”, a character string defined as a characteristic is stored.

  In the data storage column of the item “characteristic value”, the character string defined as the characteristic value of the characteristic used for the configuration of the category (product type, product number and product) (for example, the characteristic of the “steel type” used for the configuration of the product type) (For example, iron defined as a value). In the data storage column of the item “characteristic numerical value”, a numerical value assigned to the character string defined as the characteristic value (for example, a characteristic value (characteristic numerical value) 914 of the characteristic “width” used in the configuration of the product number) is set. .00 etc.) are stored.

[2-3. Product master 106d]
The product master 106d stores the same information stored in the product number master 106c.

[2-4. Characteristics master 106e]
The characteristic master 106e is a master for setting a characteristic that is a component of a category (product type, product number, and product). Each characteristic is classified into a product component, a product number component, a product component, and the like.

  In the characteristic master 106e, for example, the manufacturer is defined as the characteristic used for the configuration of the product type, the code value is defined as the type of the characteristic value code for the characteristic, and the thickness used as the characteristic used for the configuration of the product number. And widths are defined, numbers and units are defined as types of characteristic value codes for those characteristics, lengths are defined as characteristics used in the composition of products, and characteristics for these characteristics It is a master to hold that numeric values and units are defined as value code types.

  The characteristic master 106e includes, as items, “characteristic code”, “characteristic name”, “characteristic abbreviation name”, “English character name”, “part number fixed use disabled flag”, “part number fixed use disabled classification”, “product variable use” "Unusable flag", "Product variable unusable category", "Product type fixed unusable flag", "Product type unusable category", "Characteristic value type category code", "Characteristic value type category", "Characteristic value code digit" , "Characteristic unit classification code", "Characteristic unit classification", "Characteristic numerical value", "Characteristic numerical value unit", "Characteristic integer digit number", "Characteristic fraction part digit number" and "Display order" are included, The master is provided with a data storage column for each item.

  In the data storage column of the item “characteristic code”, a code value assigned to a character string defined as a characteristic is stored. In the data storage column of the item “characteristic name”, a character string defined as a characteristic is stored. An abbreviation of a character string defined as a characteristic is stored in the data storage column of the item “characteristic abbreviation”. In the data storage column of the item “English character name”, an alphabetic character corresponding to the character string defined as the characteristic (for example, Width corresponding to the characteristic “width”, etc.) is stored.

  In the data storage field of the item “Product type fixed use disable flag”, whether or not the character string defined as the characteristic is set as the product fixed property (the property used for the product configuration and fixed in the product type) is set. In order to hold, “0” assigned as the code value of the section “available” or “1” assigned as the code value of the section “unavailable” is stored. In the data storage field of the item "Product type fixed / unusable category", in order to hold whether or not the character string defined as a property is set as the product type fixed property, either of the categories "usable" or "unusable" Is stored.

  In the data storage column of the item “characteristic value type classification code”, 1 assigned as the code value of the predefined classification “numerical value” or 0 assigned as the code value of the predefined classification “code value” is stored. Stored. The number of digits of the characteristic value code is stored in the data storage column of the item “characteristic value code digit”. In the data storage column of the item “characteristic unit category code”, 2 assigned as the code value of the predefined category “dimension” is stored. In the data storage column of the item “characteristic unit category”, a character string of a predefined category “dimension” is stored.

  In the data storage column of the item “characteristic numerical value”, a numerical value (for example, 21) of a predefined unit (for example, millimeter) is stored. In the data storage column of the item “characteristic numerical unit”, a character string of a predefined unit is stored. The number of digits in the integer part of the characteristic numerical value is stored in the data storage column of the item “characteristic integer number of digits”. The number of digits of the decimal part of the characteristic numerical value is stored in the data storage column of the item “characteristic decimal part number of digits”.

[2-5. Characteristic value master 106f]
The characteristic value master 106f is a master for setting a characteristic value (numerical value or code value) and its name, which are set in the characteristic master 106e and are components of the category. There are two types of characteristic value codes: code values and numerical values. When the type of the characteristic value code is a code value, it is necessary to register the code value in the characteristic value master 106f. When the characteristic value code type is a numerical value, it is not necessary to register the numerical value in the characteristic value master 106f, and the numerical value can be freely set by user input.

  The characteristic value master 106f holds, for example, that XX company and XX company are defined as characteristic values of the characteristic “manufacturer”, and that 01 and 02 are defined as their characteristic value codes. The master of

  The characteristic value master 106f includes, as items, "characteristic code", "characteristic name", "characteristic value", "characteristic value name", "characteristic value abbreviation name", "alphabetic characteristic value name", and "display order". The master is provided with a data storage column for each item.

  In the data storage column of the item “characteristic code”, a code value assigned to a character string defined as a characteristic is stored. In the data storage column of the item “characteristic name”, a character string defined as a characteristic is stored. In the data storage column of the item “characteristic value”, it is assigned to a character string defined as a characteristic value (for example, XX steel, XX steel making, or △ Δ iron defined as the characteristic value of the characteristic “manufacturer”). Numerical value or code value (for example, JFE assigned to the characteristic value “XX Steel”, KOBE assigned to the characteristic value “XX Steel Making”, or SNT assigned to the characteristic value “ΔΔ Iron”). Is done. A character string defined as a characteristic value is stored in the data storage column of the item “characteristic value name”.

[2-6. Property definition master 106g]
The characteristic definition master 106g is a type-specific characteristic definition master for defining which characteristic is held for each category. The characteristics can be set indefinitely. Which category (product, product number, or product type) the characteristics are applied to can be freely set by the user.

  In the property definition master 106g, for example, in the product type “H steel”, a manufacturer is defined as a property used for the configuration of the product (product fixed property: a property fixed in the product), and a property used for the product number configuration (product number fixed property) : A master that holds the thickness and width defined as the fixed characteristics in the product number) and the length defined as the characteristics used in the composition of the product (product variation characteristics: characteristics that vary in the product) is there.

  The property definition master 106g includes items of “product code”, “product name”, “category category”, “row”, “characteristic”, “product number property value”, “product property value”, and “product property unit”. It is a master in which a data storage column is provided for each item.

  In the data storage column of the item “product code”, code values assigned to character strings defined as product types are stored. A character string defined as a product type is stored in the data storage field of the item “product name”.

  In the data storage column of the item “category category”, a character string of any one of the predefined categories “product type fixed property”, “product number fixed property”, and “product variation property” is stored. A character string defined as a characteristic is stored in the data storage field of the item “characteristic”. Whether these pre-defined characteristics are set as a product type fixed characteristic, a product number fixed characteristic or a product variation characteristic is managed in these fields.

  In the data storage column of the item “product characteristic value”, the character string defined as the characteristic value of the characteristic used for the composition of the product type (for example, the characteristic value of the characteristic “steel type” used for the composition of the product “sheet steel”) is displayed. Some iron, etc.) is stored. In the data storage column of the item “product characteristic value”, a value related to the characteristic value of the characteristic used for the configuration of the product is stored. In the data storage column of the item “product characteristic unit”, a character string indicating a unit of a numerical value related to the characteristic value is stored.

[2-7. Characteristic setting master 106h]
The characteristic setting master 106h is a characteristic setting master for each category for defining which characteristic value is held for each category and for each characteristic.

  For example, in the property setting master 106h, in the product type “H steel”, the properties used for the composition of the product type and the characteristic values thereof are defined by the manufacturer and XX company, or the product number “H steel 60 × 60” This is a master for holding the characteristics used in the configuration of the above and that the width and 60 mm are defined as the characteristic values.

  The characteristic setting master 106h includes “category classification”, “category code”, “characteristic code”, “characteristic value”, and “characteristic numerical value” as items, and a data storage column is provided for each item. Is a master.

  In the data storage column of the item “category category”, a character string of any of the categories “product variation characteristics”, “part number fixed characteristics”, or “product type fixed characteristics” is stored. In the data storage field of the item “Category code”, assign the code value assigned to the category “product fluctuation characteristics”, the code value assigned to “part number fixed characteristics” (for example, part number code), or “product type fixed characteristics”. Stored code value is stored.

  In the data storage column of the item “characteristic code”, a code value assigned to a character string defined as a characteristic is stored. In the data storage column of the item “characteristic value”, a numerical value or a code value assigned to the character string defined as the characteristic value is stored. In the data storage column of the item “characteristic value”, a numerical value assigned to the character string defined as the characteristic value is stored.

[3. Specific Example of Processing Performed by Each Processing Unit of Control Unit 102]
A specific example of processing performed by each processing unit of the control unit 102 will be described in detail.

[3-1. Product master management unit 102b]
The product master management unit 102b displays a screen for managing the product master 106b on the monitor 114, and manages information in the product master 106b based on an instruction from the user through the screen. Here, an example of a screen for managing the product master 106b will be described with reference to FIG.

  FIG. 10 is a diagram illustrating an example of the product type master maintenance screen MH. The product master maintenance screen MH includes an area MH1, an area MH2, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button. The area MH1 is an area for inputting a product type code. The area MH2 is an area for displaying information in the product master 106b. In the region MH2, information on the product code, product name, product kana name, inventory management unit, and inventory evaluation aggregation classification is displayed in a matrix format. Is done.

  The new button is a button for selecting new registration of information in the product type master 106b. The delete button is a button for selecting deletion of information in the product type master 106b. The search button is a button for selecting a search for information in the product master 106b based on the product code input in the area MH1. The cancel button is a button for canceling the search for information in the product master 106b. The edit button is a button for selecting editing of information in the product type master 106b (information included in the row selected in the area MH2). The registration button is a button for selecting registration of information displayed in the area MH2 to the product type master 106b.

  When the user operates the input device 112 to edit the information displayed in the area MH2 to a desired one and selects the registration button, the product master management unit 102b converts the information displayed in the region MH2 into the product type. Store in the master 106b.

[3-2. Part number master management unit 102c]
The product number master management unit 102c displays a screen for managing the product number master 106c on the monitor 114, and manages information in the product number master 106c based on an instruction from the user through the screen. Here, an example of a screen for managing the product number master 106c will be described with reference to FIG.

  FIG. 11 is a diagram illustrating an example of the product number master maintenance screen MI. The product number master maintenance screen MI includes an area MI1, an area MI2, a search button, a cancel button, and a registration button.

  The area MI1 is an area for inputting a product type code and a product number code and displaying a product type name. The area MI2 includes a first area for inputting a product number, a second area for inputting information on characteristics used for the configuration of the product type, and a third area for inputting information on characteristics used for the configuration of the product number. Area.

  In the second area, the line number and the characteristic code (for example, MaterialIR assigned to the characteristic “steel type”), the characteristic (for example, the characteristic “steel type”, etc.) and the characteristic value code (for example, the characteristic value “iron”) are assigned. Fe, etc.), characteristic values (for example, characteristic value “iron”, etc.), characteristic numerical values and units are displayed.

  The third area includes a line number and a characteristic code (for example, Width assigned to the characteristic “width”, Thickness assigned to the characteristic “thickness”) and characteristics (for example, the characteristics “width”, “thickness”, etc.) The characteristic value code, the characteristic value, the characteristic numerical value (for example, 914.00, 2.000, etc.) and the unit (for example, millimeter) are displayed.

  The search button is a button for selecting a search for information in the product number master 106c based on the product type code and the product number code input in the region MI1. The cancel button is a button for canceling the search for information in the product number master 106c. The registration button is a button for selecting registration of information displayed in the area MI1 and the area MI2 in the product number master 106c.

  When the user operates the input device 112 and selects the registration button, the product number master management unit 102c creates a code value defined as the product number code by combining the product code, the characteristic value code, and / or the characteristic value, The created code value may be registered in the product number master 106c. The product number master management unit 102c may create a character string defined as the product number by combining the product type and the characteristic value, and register the created product number (character string) in the product number master 106c.

[3-3. Product master management unit 102d]
The product master management unit 102d is included in the creation unit of the present invention, and automatically creates information stored in the product master 106d based on information stored in the product number master 106c and the characteristic value master 106f. By doing so, information in the product master 106d is managed. The product master management unit 102d copies the information stored in the product number master 106c to the product master 106d.

[3-4. Characteristics master management unit 102e]
The characteristic master management unit 102e is included in the acquisition unit and the setting unit of the present invention, and displays a screen for managing the characteristic master 106e on the monitor 114, and from the user performed through the screen. Information in the characteristic master 106e is managed based on the instruction. Here, an example of a screen for managing the characteristic master 106e will be described with reference to FIG.

  FIG. 12 is a diagram illustrating an example of the characteristic master maintenance screen MJ. The characteristic master maintenance screen MJ includes an area MJ1, an area MJ2, a search button, a cancel button, and a registration button.

  The area MJ1 is an area for inputting and displaying the characteristic code. The area MJ2 includes a characteristic name, characteristic abbreviation name, alphabetic characteristic name, part number fixed use disabled flag, product variable use disabled flag, model fixed use disabled flag, characteristic value type classification code, characteristic value code digit number, characteristic unit classification code, Enter the characteristic numerical unit value, characteristic integer number of digits, characteristic decimal part number of digits, display order, part number fixed unavailable category, product variable unavailable category, product fixed unavailable category, characteristic value type category, and characteristic unit category. And a characteristic numerical unit.

  The search button is a button for selecting a search for information in the characteristic master 106e based on the characteristic code input in the area MJ1. The cancel button is a button for canceling the search for information in the characteristic master 106e. The registration button is a button for selecting registration of information displayed in the area MJ1 and the area MJ2 in the characteristic master 106e.

  When the user operates the input device 112 to input desired information in the areas MJ1 and MJ2 and selects a registration button, the characteristic master management unit 102e sets the information displayed in the areas MJ1 and MJ2 as characteristics. Register with the master 106e.

[3-5. Characteristic value master management unit 102f]
The characteristic value master management unit 102f is included in the acquisition unit and the setting unit of the present invention, and displays a screen for managing the characteristic value master 106f on the monitor 114, and a user performed via the screen The information in the characteristic value master 106f is managed based on the instruction from. Here, an example of a screen for managing the characteristic value master 106f will be described with reference to FIG.

  FIG. 13 is a diagram illustrating an example of the characteristic value master maintenance screen MK. The characteristic value master maintenance screen MK includes an area MK1, an area MK2, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button.

  The area MK1 is an area for inputting a characteristic code or displaying a characteristic corresponding to the input characteristic code. The area MK2 is an area for inputting and displaying the characteristic value, characteristic value name, characteristic value abbreviation name, alphabetic characteristic value name, and display order.

  The new button is a button for selecting new registration of information in the characteristic value master 106f. The delete button is a button for selecting deletion of information in the characteristic value master 106f. The search button is a button for selecting a search for information in the characteristic value master 106f based on the characteristic code input to the area MK1. The cancel button is a button for canceling the search for information in the characteristic value master 106f. The edit button is a button for selecting editing of information in the characteristic value master 106f (information included in the row selected in the region MK2). The registration button is a button for selecting registration of information displayed in the area MK1 and the area MK2 in the characteristic value master 106f.

  When the user operates the input device 112 to input desired information in the areas MK1 and MK2 and selects the registration button, the characteristic value master management unit 102f displays the information displayed in the areas MK1 and MK2. It is registered in the characteristic value master 106f.

[3-6. Property definition master management unit 102g]
The property definition master management unit 102g is included in the acquisition unit and the setting unit of the present invention, and displays a screen for managing the property definition master 106g on the monitor 114, and a user performed via the screen. The information in the property definition master 106g is managed based on the instruction from. Here, an example of a screen for managing the characteristic definition master 106g will be described with reference to FIG.

  FIG. 14 is a diagram illustrating an example of the characteristic definition master maintenance screen ML. The characteristic definition master maintenance screen ML includes an area ML1, an area ML2, a new button, a delete button, a search button, a cancel button, an edit button, and a registration button.

  The area ML1 is an area for inputting a product type code or displaying a product type corresponding to the input product type code. The area ML2 is an area for inputting or displaying the category classification, the row, the characteristic, the product characteristic value, the product characteristic value, and the product characteristic unit name.

  In the category classification of the region ML2, a character string of any one of the predefined categories “product fixed characteristics”, “product number fixed characteristics”, and “product variation characteristics” is displayed. A character string defined as a characteristic is displayed as the characteristic of the region ML2. In the product number characteristic value of the area ML2, a character string defined as the characteristic value of the characteristic used for the configuration of the product type is displayed. A numerical value (characteristic numerical value) related to the characteristic value of the characteristic used for the structure of the product type is displayed in the product characteristic value of the region ML2. The name of the unit of the characteristic numerical value is displayed in the product characteristic numerical value unit name of the area ML2.

  The new button is a button for selecting new registration of information in the characteristic definition master 106g. The delete button is a button for selecting deletion of information in the characteristic definition master 106g. The search button is a button for selecting a search for information in the characteristic definition master 106g based on the product type classification code input in the area ML1. The cancel button is a button for canceling the search for information in the characteristic definition master 106g. The edit button is a button for selecting editing of information in the property definition master 106g (information included in the row selected in the area ML2). The registration button is a button for selecting registration of information displayed in the area ML1 and the area ML2 in the characteristic definition master 106g.

  When the user operates the input device 112 to input desired information in the areas ML1 and ML2 and selects a registration button, the property definition master management unit 102g displays the information displayed in the areas ML1 and ML2. Register in the property definition master 106g.

[3-7. Characteristic setting master management unit 102h]
The characteristic setting master management unit 102h automatically creates the information stored in the characteristic setting master 106h based on the information stored in the product number master 106c, the commodity master 106d, and the characteristic definition master 106g. Information in 106h is managed. Specifically, the characteristic setting master management unit 102h stores in the characteristic setting master 106h the characteristic code and characteristic value (characteristic value) when the product type fixed characteristic is selected as the category classification in the characteristic definition master maintenance screen ML shown in FIG. sign up. Further, the characteristic setting master management unit 102h registers the characteristic value information of the fixed part number characteristic included in the article number master maintenance screen MI shown in FIG. 11 in the characteristic setting master 106h. Further, the characteristic setting master management unit 102h displays the characteristic value information (for example, the characteristic “length”) of the product variation characteristic input on the sales specification input screen MM shown in FIG. Is registered in the characteristic setting master 106h.

[3-8. Sales input execution unit 102i]
The sales input execution unit 102i displays a screen for managing the sales input data 106i on the monitor 114, and manages information in the sales input data 106i based on an instruction from the user made via the screen. Here, an example of a screen for managing the sales input data 106i will be described with reference to FIG.

  FIG. 15 is a diagram illustrating an example of the sales details input screen MM. The sales details input screen MM includes an area MM1 for inputting and displaying a product type code, a product name, a product code, and a product name, and a characteristic defined as a product variation characteristic (for example, a characteristic “length”, etc.) Area MM2 for inputting or displaying a characteristic value or characteristic numerical value (for example, 60.000) and a character string (for example, cm) indicating a unit, and a character string (for indicating the quantity and unit of a product) For example, an area MM3 for inputting or displaying a book or the like.

  When the user operates the input device 112 to input desired information in the sales details input screen MM and selects a confirmation button provided on the sales details input screen MM, the sales input execution unit 102i displays the sales details. The information displayed on the input screen MM is registered in the sales input data 106i.

For example, when the product type master 106b, the product number master 106c, and the sales input data 106i satisfy the following (Condition 1) to (Condition 3), the user operates the input device 112 as the product variation characteristics. A desired characteristic numerical value (for example, 5 m, 7 m, or 10 m) related to the defined characteristic “length” is input to the area MM2, and the product quantity (for example, 3, 1, or 6) is input to the area MM3. When inputting and selecting the confirm button, the sales input execution unit 102i registers the characteristic numerical value displayed in the area MM2 in the sales input data 106i in association with the product code and the product name displayed in the area MM1, Rewrite (update) the quantity stored in sales input data 106i based on the quantity displayed in area MM3 , To perform the information processing (management of inventory data that was in conjunction with the quality number of changes in characteristics) of updating the sales input data 106i. That is, in the present embodiment, the master does not have a characteristic value. For example, when the inventory increases due to purchase input or the inventory decreases due to sales input or the like, By determining the quantity, the sales input data 106i is updated. According to the present embodiment, it is possible to manage inventory information separately for products with the same product code, based on the product variation characteristics. In addition, the master does not have the characteristic defined as the product fluctuation characteristic, for example, the characteristic defined as the product fluctuation characteristic is determined in advance, and only the characteristic numerical value is input, The above-described “management of inventory data linked with characteristic values related to fluctuation characteristics” may be realized.
(Condition 1): The type master 106b is a master for collecting types, and is a master for defining the number of characteristics, the type of characteristics, and which category determines the characteristics. The type master 106b includes (1) H01 as the type code, (2) H type steel as the type name, and (3) material and shape defined as the type fixed characteristic, and thickness and width defined as the type number fixed characteristic. (Characteristics set for each product number) and length defined as product fluctuation characteristics (characteristics that differ for each stock) are included as characteristics. It is included as a characteristic value related to “material” and characteristic “shape”.
(Condition 2): The product number master 106c is a master for registering information items equivalent to the product master 106d, and is a master for registering fixed characteristic values for each product number. The product number master 106c includes (1) 13050 (for example, a code created based on a product type code and a characteristic value) as a product number code, and (2) H-shaped steel (300 * 500) (for example, defined as a product number fixed characteristic) (Character string etc. created based on the characteristic value regarding the characteristic “thickness” and the characteristic “width” and the product name) and the like, and (3) 300 mm and 500 mm are defined as the part number fixed characteristics, respectively. The characteristic value relating to the characteristic “thickness” and the characteristic value relating to the characteristic “width” are included.
(Condition 3): The sales input data 106i is an inventory table (inventory management table) that stores data relating to a product code, a product name, a characteristic numerical value related to a characteristic “length” defined as a product variation characteristic, and a quantity. 13050 is included as a product code, H-shaped steel (300 * 500) is included as a product name, and a value indicating the number of products in stock is included as a quantity.

[Summary of Embodiments and Other Embodiments]
As described above, according to the present embodiment, for example, when managing items such as shoes, clothes, and furniture as a product, the user defines, for example, color, size, width, and the like as characteristics that vary in the item, and For example, when a season, year, manufacturer, etc. are defined as fixed characteristics in an object, (1) the user can define, for example, the defined variation characteristics such as color, size, width, etc. and their characteristic values (code values or numerical values) A fixed characteristic such as season / year / manufacturer and its characteristic value are input via a predetermined screen. (2) The control unit 102 stores the input fluctuation characteristic as a commodity fluctuation characteristic in the storage unit 106 (characteristic master 106e and And the characteristic value of the variation characteristic is registered in the storage unit 106 in association with the variation characteristic, and (3) the control unit 10 Registers the input fixed characteristic in the storage unit 106 as any of the product type fixed characteristic, product type fixed characteristic, or product number fixed characteristic, and registers the characteristic value of the fixed characteristic in the storage unit 106 in association with the fixed characteristic. .

  Further, according to the present embodiment, for example, when managing an object such as H steel as a product, the user defines, for example, a length or the like as a characteristic that varies in the object, and as a fixed characteristic in the object For example, when the material, shape, thickness, width, specific gravity, etc. are defined, (1) the user can define the fluctuation characteristics such as length and the characteristic values and the fixed characteristics such as material, shape, thickness, width, specific gravity, etc. And the characteristic value thereof are input via a predetermined screen. (2) The control unit 102 registers the input variation characteristic as a commodity variation characteristic in the storage unit 106 (such as the characteristic master 106e and the characteristic definition master 106g). At the same time, the characteristic value of the variation characteristic is registered in the storage unit 106 in association with the variation characteristic, and (3) the control unit 102 determines the input fixed characteristic as the product type fixed characteristic or the product number fixed characteristic. The characteristic values of the fixed characteristics registered in the storage unit 106 in association with the fixed characteristics with Zureka and to be registered in the storage unit 106.

  Further, according to the present embodiment, for example, when managing clothes as commodities, for example, when a T-shirt border is defined as a product number and the product number code is also defined, the control unit 102 defines the defined product number. A product code and a product name are created on the basis of the product number and product number code, the registered variation characteristic and its characteristic value. In addition, according to the present embodiment, for example, when managing H steel as a product, for example, when width and thickness are defined as product numbers and numerical values related thereto are also defined, the control unit 102 is defined. The product code and the product name are created based on the product number and the numerical value thereof, the registered variation characteristic and the characteristic value.

  Further, according to the present embodiment, it is possible to arbitrarily set the characteristic type / characteristic value of the product in the business application. In addition, inventory information can be managed separately even for the same product code for fluctuation characteristics. Further, a plurality of variation characteristic information and fixed characteristic information for each product can be registered without adding a column to the database. Further, business applications can handle products having different characteristics. Further, according to the present embodiment, a product is expressed by a combination of attributes such as product number and characteristics (multiple settings are possible), and the plurality of attributes can be freely set according to the characteristics and business requirements of the product to be registered. It is possible.

  In the past, it was impossible to add product characteristics without changing the database. In other words, conventionally, since the characteristic is embedded in the database in a fixed column, it is necessary to add the characteristic to the database when adding the characteristic. However, according to the present embodiment, characteristics can be set infinitely (the upper limit may be given) without changing the database. Thereby, when it is desired to manage a plurality of pieces of product-specific information, the management can be realized without changing the database.

  Further, although the embodiments of the present invention have been described so far, the present invention can be implemented in various different embodiments within the scope of the technical idea described in the claims other than the above-described embodiments. It ’s good.

  For example, among the processes described in the above-described embodiments, all or a part of the processes described as being automatically performed can be manually performed, or the processes described as being manually performed All or a part of the above can be automatically performed by a known method.

  In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including registration data for each processing, parameters such as search conditions, screen examples, and database configurations shown in the above documents and drawings Can be changed arbitrarily.

  Further, regarding the business management apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the business management apparatus 100, particularly the processing functions performed by the control unit 102, are realized by a CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the product information management method according to the present invention. It is mechanically read by the device 100. That is, in the storage unit 106 such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  The computer program may be stored in an application program server connected to the business management apparatus 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. is there.

  In addition, the product information management program according to the present invention may be stored in a computer-readable recording medium that is not temporary, and may be configured as a program product. Here, the “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (Electric Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), etc. Including "transportable physical media" To.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  Further, the task management apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus to which an arbitrary peripheral device is connected. Further, the business management apparatus 100 may be realized by installing software (including a program or data) that enables the product information management method of the present invention to be implemented in the information processing apparatus.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  As described above, the product information management apparatus, the product information management method, and the product information management program according to the present invention are particularly useful for managing product-specific information in business management (for example, sales management, inventory management, etc.). .

DESCRIPTION OF SYMBOLS 100 Business management apparatus 102 Control part 102a Type classification master management part 102b Type master management part 102c Product number master management part 102d Goods master management part 102e Characteristic master management part 102f Characteristic value master management part 102g Characteristic definition master management part 102h Characteristic setting master management Unit 102i sales input execution unit 104 communication interface unit 106 storage unit 106a product type master 106b product type master 106c product number master 106d product master 106e property master 106f property value master 106g property definition master 106h property setting master 106i sales input data 108 input / output interface unit 112 Input device 114 Output device 200 External server 300 Network

Claims (1)

A product information management device that includes a control unit and a storage unit and manages information about products,
The controller is
An acquisition means for acquiring a characteristic that is a constituent element of a product and a higher-level classification for the product, and a characteristic value that is a value of the characteristic;
Setting means for setting the characteristic acquired by the acquisition unit in the storage unit in association with a classification fixed flag, and setting the characteristic value acquired by the acquisition unit in the storage unit in association with the acquired characteristic When,
With
The classification fixed flag means that the acquired characteristic is a numerical value that means setting as a fixed characteristic that is a fixed characteristic in the higher-level classification and that the acquired characteristic is not set as the fixed classification characteristic. Hold one of the numbers
Product information management device characterized by

Images