JP3067815U - Customizable table data update processor - Google Patents

Abstract

(57) [Summary] [PROBLEMS] To provide an update processing apparatus that can access a database and update and register new, modified, and deleted data even if the data includes customized table data. SOLUTION: An update processing means is provided with a slip registration function group corresponding to customization.

Description

[Detailed description of the invention]

[0001]

[Technical field to which the invention belongs]

 The present invention is a processing device for a sales / purchase management program, which is a corporate business, with a database and a plurality of terminals linked to each other, and is a table data update processing device that can respond even if the database table is customized. About.

[0002]

[Prior art]

 Conventionally, a sales / purchase management program that performs corporate operations has been loaded onto a computer system terminal equipped with a database management system. If so, you cannot add a column for that. That is, it was impossible to customize. The biggest reason that columns cannot be added is that a database that stores many tables that are related to each other is used, so even if you write an item you want to add a column to one of those tables, a database management system And the other tables associated with it will not be changed and will be inconsistent.

[0003] Therefore, as described in Japanese Patent Application No. 11-008014, the applicant for utility model registration of the present invention can customize the business program so that the business program can operate normally even if a column of a database table is added. Provided a simple table creation method.

[0004] However, any data update operation to each table of the database that has not been customized, including the operation of updating data to each table of the customized database to which the column of the table has been added by the above method, may be performed. However, the longer the slip input amount, the longer the time is consumed. In addition, it will be a complex and various slip entry work to enter new slip data in the sales and purchase management program, or modify or delete it, or update customized additional column data. Therefore, there is a problem that a considerable amount of time is consumed.

[0005]

[Problems to be solved by the invention]

 The present invention has been made in view of the above-mentioned point, and a purpose thereof is a customization correspondence table data update processing device for processing a sales / purchase management program, and the update processing device is not customized. Or, it is possible to update each table data according to the customized state and write and register the data from the terminal to the database. It is an object of the present invention to provide an update processing means capable of performing the above or a module having a module in which a processing program procedure is classified and recorded according to functions.

[0006]

[Means for Solving the Problems]

 In order to solve the above-mentioned problems, the customization-compatible table data update processing device of the present invention provides a database management system that manages and stores a database composed of a plurality of tables provided with codes associated with each other, and a business operation including a plurality of terminals. A customizable table data update processing device that processes a sales / purchase management program, updates each table data according to a customized state, and writes and registers the table data from the terminal to the database. It has update processing means, and the update processing means consists of various slips consisting of a head section and a detail section related to sales, orders, payment, purchase, purchase, ordering, payment, production, transfer between warehouses, shipping required for sales and purchase management. A form writing processing means for each form for performing a writing process for the form, and a plurality of terminals simultaneously executing the form writing processing means. At least concurrent execution restricting means for performing exclusive control in each practical unit of the slip writing process in order to maintain data consistency in the slip writing process performed by the slip writing process. It has at least a slip registration DLL (Dynamic Linking Library) file, and each file has a slip registration function that is classified into three categories: new slip registration, slip correction registration, and slip deletion registration. The function also adds a column for both the head and detail section of the voucher, a column for the head section only, a column for the detail section only, and a A different group of slip registration functions corresponding to the four states of customization are provided. The necessary files are called up sequentially by means, and the form of the slip data update registration input screen for inputting data is displayed. Then, the corresponding function is called from the slip registration DLL file. When called from an application program, further, a declare declaration is made, the database is accessed, and an application program using a slip registration function corresponding to one of the three categories and four states is operated from the slip registration DLL file. It is characterized in that it is efficiently and quickly written and registered in the database.

[0007] In addition, when the various slips are sales slips, in addition to the normal slips, a relay input slip and a consumption tax collective registration slip, which are taken over from the sales order slip to the sales slip, are added, and the respective functions are different. It is characterized by.

In the case where the various slips are purchase slips, in addition to the normal slips, a relay input slip and a consumption tax lump-sum registration slip, which have been taken over from the order slip to the purchase slip, are added, and the respective functions are different. It is characterized by.

In addition, the slip registration function group has different arguments corresponding to the four states of the customization, and the basic argument when no customization is performed without adding a column is at least a write destination database name. , Slip head data, number of lines to be written, slip description data, serial number of registration slip, and slip number. And the argument of the slip description addition format format, and add the column of only the head part and customize the argument. For the argument, add the slip head additional data and the argument of the slip head addition format format to the above basic argument. If both are customized by adding a column, the arguments are the above-mentioned basic arguments, the slip head additional data, its format, and the description. It is characterized by adding the additional data and its format format argument, minimizing the work of writing and registering in the database, and shortening the required access time to achieve high-speed processing.

In addition, the form head data and the form detailed data of the various forms set as the arguments of the form registration function have the system number, the form number, and the serial number information at the beginning of the form when a new form is registered. Data related to system settings, and then set head data and detailed data.Each of these items is set with a fixed length, and the whole is one character string. Characteristically, data is set at the head, and then detailed data is set as a character string.

Further, the update processing means is a module in which the processing program procedure is classified and recorded according to function.

[0012]

[Embodiment of the invention]

 Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram of an embodiment of the customization correspondence table data update processing device of the present invention.

Here, reference numeral 10 denotes a company computer system, which is a table data update processing device that processes the sales / purchase management program 12 using the update processing means 20.

Reference numeral 1 denotes the terminal group. Reference numeral 4 denotes a database management system in which a plurality of databases 40 are created, and each database 40 has a number of tables (also referred to as files) 41. The database management system 4 uses, for example, SQL 7.0 (a trademark of Microsoft Corporation) or ORAC LE 8.0 (a trademark of Oracle Corporation).

Reference numeral 5 denotes a local area network (LAN), for example, a transmission cable such as 100BASE, 6 denotes a server computer, and 61 denotes a program for controlling a database management system.

The terminal group 1 is controlled by a window-type commercially available operation system (OS), and is loaded with a sales / purchase management program 12 which records a program procedure for executing business of a company.

Further, each of the terminal groups 1 is loaded with a customized correspondence table data update processing module 20 which records a program procedure of the update processing means. Each of the update processing modules 20 is provided with at least a slip writing module 20a which records a program procedure of the slip writing means and a simultaneous execution restriction module 20b which records a program procedure of the simultaneous execution limiting means.

The slip writing module 20a includes a head section and a detail section related to sales, orders, payment, purchase, ordering, payment, production, transfer between warehouses, and shipping required for the sales management and purchase management programs. This module records the program procedure of the writing process for each type of slip.

The concurrent execution restriction module 20b performs exclusive control in execution units of each slip writing module 20a in order to maintain data consistency in slip writing processing executed simultaneously from the plurality of terminals 1. Module to do.

The details of the slip writing module 20a are as follows. The module 20a includes at least a slip registration DLL file for slip writing processing for each of the nine types of slips, and each slip registration DLL file includes a slip new registration function group (a) and a slip correction registration function group. (B), a slip registration function (a), (b), and (c) classified into three groups of slip deletion registration functions (c).

In addition, the slip registration functions (a), (b), and (c) classified into the three categories include adding a column only to the head portion when a column is added to both the head portion and the detail of the slip (a). (B), adding columns only in the detail section (c), and not customizing without adding columns (d), different form registration functions (a) (b) corresponding to customization 4 states (B) (c) and (d).

In other words, the module 20a has three classifications (a), (b), and (c) and four states (a), (b), (c), and (d) for each of the nine types of slips. There are 12 slip registration functions for each.

[0023] Among the nine types of slips, in the case of a sales slip, in addition to the normal slip, a relay input slip taken over from the sales slip to the sales slip and a consumption tax collective registration slip are added. It has the same slip registration function.

As described above, depending on the usage of the user, the update processing module 20 creates an application program using a slip registration function that has a different receiving port and adapts it. Work can be performed, and as a result, various forms can be registered efficiently and quickly in the database.

Therefore, in order to make each of the slip registration functions perform the minimum necessary work, each function is provided with different arguments shown below, which are adapted to four states of customization.

In the case where the customization is not performed without adding a column, the basic arguments (d) include at least the name of the database to which the data is to be written, the head data of the slip, the number of lines to be written, the slip detail data, the serial number of the registered slip, and the slip number. .

In the case of customization by adding a column only to the description section, the argument in (c) adds the slip description additional data and the argument of the slip description addition format to the above basic arguments.

In the case of customization by adding a column only to the head part (b), the argument of the slip head addition data and the argument of the slip head addition format format are added to the basic arguments.

In the case of customization by adding a column to both the head and the description section, the argument of (a) is to add the slip head additional data, its format format, the detail additional data, and the argument of the format format to the basic arguments.

FIG. 2 shows an embodiment of the slip new registration function (a). Here, an embodiment of a sales slip among various slips is shown. For the four states (a), (b), (c), and (d) of each customization, it is shown that the functions are different for each of the normal slip, the relay slip, and the consumption tax collective registration slip.

Similarly, FIG. 3 shows an embodiment of the slip correction registration function (b) and the slip deletion registration function (c).

As shown in FIGS. 2 and 3, slip head data and slip description data of various slips are set in arguments of a slip registration function.

Necessary information is different depending on the type of the normal slip, the relay slip, and the consumption tax collective registration slip, so the setting method is different for each slip type. In, data A relating to the system setting is set at the head of the head data B. The system numbering, slip number, and serial number information are written and set. Necessary for linking tables.

Next, head data B and detailed data C are set, and each item thereof is set with a fixed length, so that the whole is one character string. The detail data C is set by repeating the character string for the number of detail lines.

In the case of correction registration, the data A relating to the system setting is not necessary, and the head data B is set at the head, and then the detailed data C is set to form a character string. One embodiment of them is shown in FIGS.

The customization correspondence table data update processing device 10 shown in FIG. 1 uses the update processing module 20 as described above. This update processing module 20 is not limited to the slip writing module 20a and the concurrent execution restriction module 20b. For example, there is a form for inputting a sales slip, that is, a startup module. In addition, there are a dialog for batch display of sales slip search, a dialog for setting slip numbers, and a dialog module for inputting information required for database connection.

There are also class modules for calling the functions of the sales slip registration DLL, and access class modules such as a sales slip head table, a sales slip detail table, a company information table, a product master table, and a customer master table.

Further, there are at least a standard module of a declare declaration for calling the relation of the sales slip registration DLL, a definition file for using the slip registration DLL, and a standard module of a procedure group used for general purposes.

The operation of the customization correspondence table data update processing device 10 of FIG. 1 will be described below.

In the table data update processing for writing a slip from the terminal 1 to the database 4, a required file is sequentially called from the update processing module 20, and a form of a slip data update registration input screen for inputting data is displayed. Therefore, the corresponding function is called from the slip registration DLL file. At this time, if the function is called from an external application program of the business program, a declare declaration is made there, the database is accessed, and the slip registration DLL is accessed. An application program using a slip registration function corresponding to one of the three classifications and four states is operated from a file to efficiently and quickly write and register the data in the database 4.

[0041]

[Effect of the invention]

 The customization table data update processing device of the present invention has the following effects.

A slip registration function group for updating the slip data of the sales / purchase management program is provided in the module recording the program procedure of the update processing means of the apparatus, and each of the slip registration functions is not customized. Alternatively, since the application program is prepared according to the customized state, the application program which selects and uses the above-mentioned function is operated, the database is accessed, and the customized table data is included. In addition, it is possible to minimize the time required for inputting a slip when registering data update, thereby shortening the time required for inputting a slip as compared with the related art, and as a result, there is an effect that high-speed processing can be performed.

[Brief description of the drawings]

FIG. 1 is a block diagram of an embodiment of a customization correspondence table data update processing device according to the present invention.

FIG. 2 is an embodiment of a slip new registration function of an update processing module used in the apparatus of FIG. 1;

FIG. 3 is an embodiment of a slip correction registration and slip deletion registration function of an update processing module used in the apparatus of FIG. 1;

FIG. 4 is an embodiment of the setting method and the contents of the data relating to the setting at the time of new / correction registration, which is set as an argument of the slip registration function used in the apparatus of FIG. 1, and the head data.

5 is an embodiment of a setting method and contents of detailed data at the time of new / correction registration set as an argument of a slip registration function used in the apparatus of FIG. 1;

[Description of Signs] 1 terminal device 4 database management system 5 LAN 6 server computer 10 customization-compatible table data update processing device, company computer system 12 sales / purchase management program, business program 20 update processing means, update processing module 20a slip Writing processing means, slip writing module 20b Simultaneous execution limiting means, Simultaneous execution limiting module 40 Database 41 Table, File 61 Database management system program

Continuing on the front page (72) Inventor Shigeru Nakayama 2-1-1, Nishi-Shinjuku, Shinjuku-ku, Tokyo Inside the Orbic Business Consultant Co., Ltd. (72) Inventor Kuruga Seiichi 2 Nishishinjuku, Shinjuku-ku, Tokyo No. 1-1, Obic Business Consultant Co., Ltd. (72) Inventor Tomohisa Takahashi 2-1-1, Nishi-Shinjuku, Shinjuku-ku, Tokyo Within Ovic Business Consultant Co., Ltd.

Claims (6)

[Utility model registration claims] 1. A database management system for managing and storing a database consisting of a plurality of tables provided with codes associated with each other, and a customization correspondence table data update for processing a sales / purchase management program for corporate business having a plurality of terminals. A processing device, comprising update processing means for updating each table data according to a customized state, and writing and registering the data from the terminal into the database, the update processing means comprising sales / purchase management Slip writing processing means for each slip which writes various slips including a head part and a detail part concerning sales, orders, payment, purchase, ordering, payment, production, transfer between warehouses, and shipping necessary for each slip. In order to maintain data consistency in the slip writing process executed simultaneously from the plurality of terminals, each slip writing process is practically used. Customization table data update processing apparatus characterized by at least and a concurrent restriction means for performing exclusive control in position. 2. A database management system for managing and storing a database consisting of a plurality of tables provided with codes associated with each other, and a customization correspondence table data update for processing a sales / purchase management program for corporate business having a plurality of terminals. A processing device, comprising update processing means for updating each table data according to a customized state, and writing and registering the data from the terminal into the database, the update processing means comprising sales / purchase management Slip writing processing means for each slip which writes various kinds of slips including a head part and a detail part relating to sales, orders, payment, purchase, ordering, payment, production, transfer between warehouses, and shipping required for each slip. In order to maintain data consistency in the slip writing process executed simultaneously from the plurality of terminals, each slip writing process is practically used. At least concurrent execution restricting means for performing exclusive control at each position, and the slip writing processing means includes at least a slip registration DLL (dynamic linking library) file for each of various slips. There are three types of slip registration functions, one for new registration of a slip, one for correction of a slip, and one for deletion of a slip. Each of the slip registration functions further includes a head when a column is added to both the head and detail part of the slip. In the case where a column is added only for departments, when a column is added only for details, and when a column is not added, a different form registration function group corresponding to the customization 4 state is provided. When performing each slip writing process, the necessary file is called up sequentially by the update processing means, and slip data update registration for inputting data is performed. Display the form of the input screen, and call the corresponding function from the slip registration DLL file. If the function is called from the external application program of the sales / purchase management program, further declare it and access the database. Customizing correspondence table data, wherein an application program using a slip registration function corresponding to one of the three classifications and four states is operated from the slip registration DLL file to efficiently and quickly write and register in the database. Update processing device. 3. In the case where the various slips are sales slips, in addition to the normal slips, a relay input slip and a consumption tax collective registration slip which have been taken over from the sales slip to the sales slip are added, and the respective functions are different. 3. The method according to claim 2, wherein when the voucher is a purchase voucher, a relay input voucher and a consumption tax collective registration voucher, which are inherited from the order voucher to the purchase voucher, are added in addition to the normal voucher, and the respective functions are different. Customizable table data update processing device. 4. The slip registration function group has different arguments corresponding to the four states of the customization, and the basic argument when no customization is performed without adding a column is at least a write destination database name. , Form head data, number of lines to be written, form details data, serial number and form number of the registered form. When adding the argument of the detail addition format format and adding the column only for the head part, the argument is customized by adding the slip head additional data and the argument of the slip head additional format format to the above basic argument, Arguments that are customized by adding are added to the above basic arguments, such as slip head additional data, its format format, and detail additional data. 4. The customization according to claim 2, wherein an operation of writing and registering the data in the database is minimized and the required access time is shortened for high-speed processing by adding an argument of the format. Correspondence table data update processing device. 5. The form head data and the form detailed data of the various forms set as the arguments of the form registration function, at the time of new registration, a system number, a form number, and a serial number information book at the beginning. Data related to the system settings, including the head data and detailed data, and each of those items is set with a fixed length, and the whole is one character string. 5. The customization correspondence table data update processing device according to claim 4, wherein the data is set at the head, and then the detailed data is set to be a character string. 6. The customization correspondence table data update processing apparatus according to claim 2, wherein said update processing means is a module in which a processing program procedure is classified and recorded according to a function.