Production management system, client in the production management system, production management method in the production management system, data retrieval method in the production management system, and computer product

A production management system which manages a) assembly data when components to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, said production management system comprising a host server, an input client, an output client, wherein

• A) said host server has at least (1) a master table of said product under assembly, (2) a quality contents master table, (3) a main data table, (4) a quality contents table, and (5) a check contents table,
• (1) said master table of said product under assembly stores data for group codes of said product under assembly obtained by dividing said product under assembly for each type,
• (2) said quality contents master table stores data about group codes of said product under assembly and quality items related to said product under assembly in correlation with each other,
• (3) said main data table stores data about management numbers with which respective said product under assembly can be identified and group codes of said product under assembly in correlation with line information, such as the data and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production and assembly line,
• (4) said quality contents table stores data about said management numbers and said group codes of said product under assembly, quality items in said quality contents master table, quality information based on said quality items, its entry date and time, assembly, checking and fixing steps whose data is entered in correlation with each other, and
• (5) said check contents table stores data about said management numbers and said group codes of said product under assembly in correlation with check items related to said product under assembly and the results of checking based on said check items,
• B) said input client displays and inputs previously specified table information from said master table of said product under assembly, said check contents data table, and said quality contents master table transferred from said host server, and transfers the information to said main data table, said quality contents data table, and said check contents data table according to the displayed and entered information,
• C) said output client displays a selecting/display control section for said product under assembly, an output type selecting/display control section, a date selecting/display control section, and a data output/display control section on its display section, a data transfer section transfers specified data from said host server, and a data processing section processes the data transferred by said transfer section,
• (C1) said selecting/display control section for said product under assembly can display and select any group code of said product under assembly based on the information in said master table of said product under assembly,
• (C2) said output type selecting/display control section can display and select items to be output based on the information in said quality contents master table,
• (C3) said date display control section can display a calendar and specify a date,
• (C4) said data transfer section transfer the data from said host server based on the conditions selected by said selecting/display control section for said product under assembly, said output type selecting/display control section, and said date selecting/display control section,
• (C5) said data processing section collects the data transferred by said data transfer section for each chronological base, and
• (C6) said data output/display control section displays the chronological data of said data processing section for each item.

A production and management method which manages a) assembly data when components to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly line, said method comprising the steps of:

• inputting a plurality of data for inputting and outputting said assembly data, said quality data, said check data, management numbers with which each of said product under assembly can be identified, and group codes of said product under assembly obtained by dividing said product under assembly according to their types in a step of assembling said product under assembly and a checking step of checking said product under assembly according to said check items,
• sequentially storing assembly data that correlates a date and time on which said product under assembly is started to be assembled and a date and time when said product under assembly is completed to said management number and said group code of said product under assembly that are input in the inputting step,
• the check data in a state of correlation with said management number and said group code of said product under assembly, and
• the quality data in a state of correlation with said management number and said group code of said product under assembly, to a host storage medium;
• selecting respective desired items from said group codes of said product under assembly, specified dates and times, and a plurality of output information correlated to extraction conditions in order to extract desired data from the plurality of quality data and check data stored in said storage medium;
• retrieving/extracting the data stored in said storage medium according to each item of the information for grouping said product under assembly, the specified date and time, and the output information selected in the selecting step;
• storing the data retrieved and extracted in the retrieving/extracting step in a client storage mediums
• chronologically processing the data stored in said client storage medium based on the items of said group code of said product under assembly, the specified date and time, and the output information selected in the selecting step;
• and
• displaying the chronological data processed in the data processing step for each item to be output based an the output information.

A production management method for managing a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly in checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, wherein

• A) a host server has (1) a master table of said product under assembly, (2) a quality contents master table, (3) a main data table, (4) a quality contents data table, and (5) a check contents data table, wherein
• (1) said master table of said product under assembly stores data for group codes of said product under assembly obtained by dividing said product under assembly for each type,
• (2) said quality contents master table stores data for group codes of said product under assembly and quality items related to said product under assembly,
• (3) said main data table stores data for management numbers with which respective said product under assembly can be identified and group codes of said product under assembly in correlation with line information, such as the data and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) said quality contents data table stores data for management numbers with which respective said product under assembly can be identified and said group codes of said product under assembly, quality items of said quality contents master tables, quality information based on said quality items, its entry date and time, assembly, checking and fixing steps whose data is entered in correlation with each other, and
• (5) said check contents data table stores data for management numbers with which respective said product under assembly can be identified and said group codes of said product under assembly in correlation with check items related to said product under assembly and the results of checking based on said check items,
• B) an input client displays and inputs previously specified table information from said master table of said product under assembly, said check contents data table, and said quality contents master table transferred from said host server, and transfers the information to said main data table, said quality contents data table, and said check contents data table according to the displayed and entered information,
• C) an output client displays areas as follows;
• (C1) a name of said product under assembly or a group code of said product under assembly is selected from a selection area of said product under assembly based on the information in said master table of said product under assembly,
• (C2) an item to be output is selected from a selection area of output types based on the information according to said quality contents master table, and
• (C3) a date to be output is selected from a date display area, and
• D) further, the specified data based on the selected information is transferred from said output client to said host server,
• E) the data is stored in said output client,
• F) the stored data is processed to chronological data for each item selected in said output selection area, and
• G) the chronological data is displayed for each item.

A production management client system which manages a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, said production management client system comprising:

• using an integrated storage medium which stores 1) management numbers with which each of said product under assembly can be identified and group codes of said product under assembly obtained by dividing said product under assembly according to their types, 2) quality data and check data correlating the quality information and the result of checking in a step of assembling parts to be attached to a product under assembly and a checking step of checking said product under assembly according to said check items on said production assembly line with said management number and said group code of said product under assembly as groups of tables, respectively,
• a first display/selecting section which allows display and selection of a group code of said product under assembly;
• a second display/selecting section which allows display and selection of a date and time;
• a third display/selecting section which allows display and selection of extraction conditions to extract desired data out of said check data and said quality data stored in said integrated storage medium and a plurality of output information related to said extraction conditions;
• a retrieving section which retrieves and extracts data stored in said integrated storage medium according to said group codes of said product under assembly, the specified date and time, and the output information selected by said first, second, third display/selecting sections;
• a storage section which stores the information retrieved and extracted by said retrieving section;
• a data processing section which chronologically processes the data stored in said storage section based on said group codes of said product under assembly, the specified date and time, and the output information selected by said first, second, third display/selecting sections;
• and
• a first display section which displays the data chronologically processed by said data processing section for each item to be output based on the output information.

A production management client system which manages a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and a) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, wherein

• using a host server having tables as follows;
• (1) a master table of said product under assembly stores data for group codes of said product under assembly obtained by dividing said product under assembly for each type,
• (2) a quality contents master table stores data about group codes of said product under assembly in correlation between quality items related to said product under assembly and quality contents in the production processes of said product under assembly,
• (3) a main data table stores data about management numbers with which respective said product under assembly can be identified and group codes of said product under assembly in correlation with line information, such as the date and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) a quality contents data table stores data about said management numbers and said group codes of said product under assembly, quality items in said quality contents master table, quality information based on said quality items, its entry date and time, assembly, checking and fixing steps whose data is entered in correlation with each other, and
• (5) a check contents data table stores data about said management numbers and said group codes of said product under assembly in correlation with check items related to said product under assembly and the results of checking based on said check items,
• an output client displays a selecting/display control section for said product under assembly, an output type selecting/display control section, a date selecting/display control section, and a data output/display control section on its display section, a data transfer section transfers specified data from said host server, and a data processing section processes the data transferred by said transfer section,
• (C1) said selecting/display control section for said product under assembly can display and select any group code of said product under assembly based on the information in said master table of said product under assembly,
• (C2) said output type selecting/display control section can display and select items to be output related to the information for said quality contents data table and said check contents data table,
• (C3) said date display control section can display a calendar and specify a date,
• (C4) said data transfer section transfers the data from said host server based on the conditions selected by said selecting/display control section for said product under assembly, said output type selecting/display control section, and said date selecting/display control section,
• (C5) said data processing section collects the data transferred by said data transfer section for each chronological base, and
• (C6) said data output/display control section displays the chronological data of said data processing section for each item.

A production management retrieval and display method for retrieving and displaying a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or sore of production assembly lines, said production management retrieval and display method comprising the steps of:

• using an integrated storage medium which stores 1) management numbers with which each of said product under assembly can be identified and group codes of said product under assembly obtained by dividing said product under assembly according to their types, 2) quality data and check data correlating the quality information and the result of checking in a step of assembling parts to be attached to a product under assembly and a checking step of checking said product under assembly according to said check items on said production assembly line with said management number and said group code of said product under assembly as groups of tables, respectively,
• displaying and selecting extraction conditions and a plurality of output information related to the extraction conditions to extract desired data out of 1) said group code of product under assembly, 2) a desired date and time, and 3) said quality data and said check data stored in said integrated storage medium;
• instructing said integrated storage medium to transfer so as to transfer the data stored in said integrated storage medium according to said group code of said product under assembly, the specified date and time, and the output information selected in the displaying/selecting step;
• storing the data transferred in the transfer instructing stop in said storage medium;
• chronologically processing the data stored in said storing step based on said group code of said product under assembly, the specified date and time, and the output information selected in the displaying/selecting step;
• and
• displaying the data chronologically processed in the data processing step for each item to be output based on the output information.

A production management retrieval and display method for retrieving and displaying a) assembly data when components to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly line, wherein

• using a host server having tables as follows:
• (1) a master table of said product under assembly stores data for management numbers with which each of said product under assembly can be identified and group codes of said product under assembly obtained by dividing said product under assembly for each type,
• (2) a quality content master table stores data about said group codes of said product under assembly in correlation with quality items related to said product under assembly,
• (3) a main data table stores data about said management numbers and said group codes of said product under assembly in correlation with line information, such as the date and time on which assembly of said product is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) a quality contents data table stores data about said management numbers and said group codes of said product under assembly, quality items in said quality content master table, quality information based on the quality items, its entry date and time, assembly, checking and fixing steps whose data is entered in correlation with each other, and
• (5) a check content data table stores data about said management numbers and said group codes of said product under assembly in correlation with check items related to said product under assembly and the results of checking based on said check items, an output client displays a selecting/display control section for said product under assembly, an output type selecting/display control section, a date selecting/display control section, and a data output/display control section on its display section, a data transfer section transfers specified data from said host server, and a data processing section processes the data transferred by said transfer section,
• (C1) said selecting/display control section for said product under assembly can display and select any group code of said product under assembly based on the information in said master table of said product under assembly,
• (C2) said output type selecting/display control section can display and select items to be output based on the information corresponding said quality content data table or said check content data table,
• (C3) said date display control section can display a calendar and specify a date,
• (C4) said data transfer section transfers the data from said host server based on the conditions selected by said selecting/display control section for said product under assembly, said output type selecting/display control section, and said date selecting/display control section,
• (C5) said data processing section collects the data transferred by said data transfer section for each chronological base, and
• (C6) said data output/display control section displays the chronological data of said data processing section for each item.

A recording medium which allows execute a program for retrieving and displaying a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, said program comprising the steps of:

• using an integrated storage medium which stores A) management numbers with which each of aid product under assembly can be identified and group codes of said product under assembly obtained by dividing said product under assembly according to their types, B) quality data and check data correlating the quality information and the result of checking in a step of assembling components and units or the like to a product under assembly and a checking step of checking said product under assembly according to the prespecified check items on said production assembly line with said management number and said group code of said product under assembly as groups of tables, respectively,
• displaying extraction conditions and a plurality of output information related to said extraction conditions to extract desired data out of 1) said management numbers with which each of said product under assembly can be identified and said group code of product under assembly obtained by dividing said product under assembly for each type, 2) a desired date and time, and 3) a plurality of said quality data and said check data stored in said integrated storage medium;
• enabling selection of the displayed extraction conditions;
• instructing said integrated storage medium so as to transfer the data stored in said integrated storage medium according to the information selected from the extraction conditions;
• storing the transferred extraction data that is retrieved by said integrated storage medium in said storage medium;
• chronologically processing the data stored in said storage medium based on said group code of said product under assembly, the specified date and time, and the output information selected in the displaying/selecting step;
• and
• displaying the chronologically processed data for each item to be output based on the output information.

A recording medium which contains a computer program which when executed causes a computer to execute the steps of retrieving and displaying a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, said program further causing the computer to execute the steps of:

• using a host server having tables as follows:
• (1) data about group codes of said product under assembly obtained by dividing said product under assembly for each type is stored in a master table of said product under assembly,
• (2) data about group codes of said product under assembly is stored in a quality contents master table in correlation with quality items related to said product under assembly,
• (3) data about management numbers and group codes of said product under assembly is stored in a main data table in correlation with line information, such as the date and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) data about said management numbers and said group codes of said product under assembly is stored in a quality contents data table in correlation with quality items in said quality contents master table, quality information based on said quality items, its entry date and time, assembly, checking and fixing steps whose data is entered, and
• (5) data about said management numbers and said group codes of said product under assembly is stored in a check contents data table in correlation with check items related to said product under assembly and the results of checking in a production process of said product under assembly,
• enabling display of a selection area of said product under assembly, an output type selection area, a date selection area, and a data output area;
• (C1) group codes of said product under assembly based on the information in said master table of said product under assembly can be displayed and selected in said selection area of said product under assembly,
• (C2) items to be output based on the information according to said quality contents master table can be displayed and selected in said output type selection area, and
• (C3) a calendar can be displayed and a date can be specified in said date display area,
• transferring the specified data in said areas from said host server;
• enabling selection of the items displayed in said areas;
• instructing so as to transfer the data from said host server based on the items in each selected area;
• storing the data transferred from said host servers collecting the stored transfer data on each chronological base;
• and
• chronologically displaying the data as the result of collection for each display item in correlation with the item to be output specified in said output type selection area.

A production management host server system which retrieves and displays a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, wherein

• (1) a master table of said product under assembly stores data for group codes of said product under assembly obtained by dividing said product under assembly for each type,
• (2) a quality contents master table stores data for group codes of said product under assembly in correlation with quality items related to said product under assembly,
• (3) a main data table stores data for management numbers with which respective said product under assembly can be identified and group codes of said product under assembly in correlation with line information, such as the date and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) a quality contents data table stores data for said management numbers and said group codes of said product under assembly, quality items in said quality contents master table, quality information based on said quality items, its entry date and time, assembly, checking and fixing steps whose data is entered in correlation with each other, and
• (5) a check contents data table stores data about said management numbers and said group codes of said product under assembly in correlation with check items related to said product under assembly and the results of checking based on said check items,
• wherein when the following operations are selected at an output client:
• (C1) a group code of said product under assembly is selected based on the information in said master table of said product under assembly,
• (C2) an output request based on the information according to said quality contents master table it selected,
• (C3) a specific date is selected, and
• (C4) an instruction of data transfer based on the selected condition received,
• the data based on the data for transfer instruction is retrieved and extracted from the group of tables, and the extracted data is transferred to said output client.

A production management data transfer method for retrieving and displaying a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, wherein data is stored in respective tables as followed:

• (1) data for group codes of said product under assembly obtained by dividing said product under assembly for each type is stored in a master table of said product under assembly,
• (2) data for group codes of said product under assembly is stored in a quality contents master table in correlation with quality items related to said product under assembly and quality contents in said production assembly process of said product under assembly,
• (3) data for management numbers with which respective said product under assembly can be identified and group codes of said product under assembly is stored in a main data table in correlation with line information, such as the date and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) data for said management numbers and said group codes of said product under assembly in stored in a quality contents data table in correlation with the information entered on said production assembly line, its entry date and time, assembly, checking and fixing steps whose data is entered out of said master table said product under assembly, and
• (5) data about said management numbers and said group codes of said product under assembly is stored in a check contents data table in correlation with check items related to said product under assembly and said quality contents in the production process of said product under assembly,
• wherein when the following operations are selected at an output client:
• (C1) a group code of said product under assembly based on the information in said master table of said product under assembly is selected,
• (C2) an output request based on the information according to said quality contents master table is selected,
• (C3) a specific date is selected, and
• (C4) an instruction on data transfer based on the selected condition is received,
• the data based on the data for transfer instruction is retrieved and extracted from the group of tables, and the data extracted in the extracting step is transferred to said output client.

A recording medium which contains a computer program which when executed causes a computer to execute the steps of retrieving and displaying a) assembly data when parts to be attached to a product under assembly are attached to said product under assembly, b) quality data regarding whether the quality of said product under assembly is good or bad, and c) check data obtained when said product under assembly is checked based on certain prespecified check items, when obtaining a finished product by attaching one or more components such as parts, units, or other finished products to said product under assembly on one or more of production assembly lines, wherein data is stored in respective tables as followed:

• (1) data for group codes of said product under assembly obtained by dividing said product under assembly for each type is stored in a master table of said product under assembly,
• (2) data for group codes of said product under assembly is stored in a quality contents master table in correlation with quality items related to said product under assembly and the quality contents in the production process of said product under assembly,
• (3) data about management numbers with which respective said product under assembly can be identified and group codes of said product under assembly is stored in a main data table in correlation with line information, such as the date and time on which assembly of said product under assembly is started, and the date and time on which the assembly of said product under assembly is completed on said production assembly line, obtainable by executing their assembly and checking on said production assembly line,
• (4) data about said management numbers and said group codes of said product under assembly is stored in a quality contents data table in correlation with the information entered on said production assembly line, its entry date and time, assembly, checking and fixing steps whose data is entered in said quality contents master table, and
• (5) data about said management numbers and said group codes of said product under assembly is stored in a check contents data table in correlation with check items related to said product under assembly and the result of checking in the production process of said product under assembly,
• wherein when the following operations are selected at an output client:
• (C1) a group code of said product under assembly based on the information in said master table of said product under assembly is selected,
• (C2) an output request based on the information according to said quality contents master table is selected,
• (C3) a specific date is selected, and
• (C4) data transfer based on the selected condition is instructed,
• operations are allowed to be executed so that the data based on the data for transfer instruction is retrieved and extracted from the group of tables, and
• the extracted data is transferred to said output client.