JP4501040B2 - Computer-readable recording medium recording customer master general-purpose data receiving program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
Used in a computer system that handles sales and purchase management of corporate operations, accepts a series of customer master general-purpose data text files created by an external application program and writes them to the database from that terminal. The present invention relates to a computer-readable recording medium that records a general-purpose data receiving program that records a batch processing program procedure.
[0002]
[Prior art]
Conventionally, a customer master data is input for each customer by a sales / purchase management program for performing business operations at a computer system terminal equipped with a database management system. Therefore, if the customer master data is entered by an external application program and is made into a general-purpose data text file for each customer, the work efficiency of the input work can be improved if the generic data can be accepted. Can be improved. However, if the input amount is large, a longer working time is consumed. In particular, when adding a column in the general-purpose data text file and attempting to customize it, it becomes difficult to accept and register it in the database table.
[0003]
[Problems to be solved by the invention]
The present invention has been made in view of the foregoing points, and an object of the present invention is to provide a database management system for managing and storing a database composed of a plurality of tables, and at least one or more terminals. Batch processing used in a computer system for processing sales / purchase management, sequentially accepting customer master general-purpose data text files created by an external application program and writing them to the database from the terminal It is an object of the present invention to provide a computer-readable recording medium in which a general-purpose data receiving program in which program procedures are recorded by function is recorded.
[0004]
In order to solve the above problems, a computer-readable recording medium on which a customer master general-purpose data acceptance program of the present invention is recorded includes a database management system for managing and storing a database composed of a plurality of tables associated with each other, and at least one or more And a customer master general-purpose data text file group created by an external application program, sequentially and continuously, for use in a computer system that processes a business business sales / purchase management program. record the batch processing program instructions for writing registered in the database, the a computer readable recording medium recording a client master universal data receiving program installed in the terminal, necessary for the sale and purchase management Customer master general data At least a customer master acceptance registration module for accepting processing for a customer file, and a screen display module for the customer master acceptance processing, wherein the customer master acceptance registration module is good at a customer master acceptance registration function. Included in the pre-master registration DLL (dynamic link library) file, the customer master acceptance registration function has two different types corresponding to two states when a column is added and when no column is added. When receiving a text file group with the extension TXT, which is a customer master general-purpose data text file, provided in the DLL file as a customer master acceptance registration function group, for each text file, In a customized state with column data added to the table And the application batch program consisting of a series of files that use the customer master acceptance registration function corresponding to the case where there is no addition of column data and there is no customization state, and the text files are sequentially continued. And writing and registering in the database.
[0005]
Further, in the customer master acceptance registration function group, different arguments are set corresponding to the above two states, and the basic argument when the column data is not added and customized is the write destination database name. , Full path (folder + file name) to the TXT file of general-purpose data, full path (folder + file name) of the log file creation destination, specification of the log file to be created, whether to check the contents of input unnecessary items, Whether or not to update the master of the same code, consists of 7 arguments for storing the number of accepted and unaccepted items set on the database management system side, and the argument when adding column data to customize is the above basic It is characterized by comprising 8 arguments obtained by adding an argument of additional column information having an additional format of a text file to the argument.
[0006]
Further, an additional column information storage structure used by setting an argument of additional column information having an additional format of the text file stores at least three items of an array name, a data type, and a data size. General-purpose data storage structure used after setting the arguments for storing the number of accepted and unaccepted cases set by the system stores two items, the number of accepted items and the number of unaccepted items And
[0007]
In addition, in the customer master general-purpose data text file, the item names of the original part contents of the customer master other than the additional column data are the master category, customer code, ledger index, customer name, customer name. Person in charge, address, TEL, FAX, selling price No. , Charge rate, billing code, user name at least, and column data is added to the text file. If customized, additional column data will be set at the end of the original data item for the required number. When not customized, a line feed code is added at the end of the original data, and when it is customized, a line feed code is added at the end of the additional column data. When the fixed length is used, each item is separated by a space, and the data is obtained as a character string group set in a format in which a character string is repeated for the number of customers.
[0008]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram of a sales / purchase management program processing apparatus 10 using a computer-readable recording medium in which a customer master general-purpose data acceptance program of the present invention is recorded . Here, reference numeral 10 denotes a company computer system, which shows an apparatus for processing the sales / purchase management program 12 using a computer-readable recording medium 20 on which the customer master general-purpose data acceptance program of the present invention is recorded . . 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 large number of tables (or files) 41. 5 is a local area network (LAN), 6 is a server, and 61 is a program for controlling the database management system. Each terminal group 1 is controlled by a commercially available operation system (OS) in a window format and is loaded with a sales / purchase management program 12 for performing business of a company. Further, the terminal group 1 is loaded with a computer-readable recording medium 20 in which a customer master general-purpose data receiving program is recorded . It includes at least a customer master acceptance registration module 20a and a simultaneous execution restriction module 20b. Details of the customer master general-purpose data acceptance registration module 20a are as follows. Module 20 a is provided with a customer master receiving registration function two to client master General data receiving DLL (dynamic link library) file in it.
[0009]
These customer master general-purpose data acceptance registration function groups are functions that are selected and used in correspondence with the state of customization of the general-purpose data text file, that is, the two states described below.
[0010]
If customization state (1) is that adding a column, the condition (2) does not add columns, i.e., there are two types of functions corresponding to two states when not customized.
[0011]
FIG. 2 shows an embodiment in which these function names are designated as MO4_ERP_HyWrt1 () and MO4_ERP_HyWrt2 (), respectively, and arguments are entered for use in an external application program. FIG. 3 shows the arguments of these functions.
[0012]
As shown in FIG. 3, when the general-purpose data text file is not customized (2) , the first argument “write destination database name”, the second argument “full path to the text file of general-purpose data”, the third argument "Log file creation destination full path", 4th argument "Specify log file to create", 5th argument "Whether or not to check the contents of input unnecessary items", 6th argument "Update master with same code" Whether or not ”and the eighth argument“ for storing the number of accepted and unaccepted cases set on the system side ”.
[0013]
When the general-purpose data text file is customized by adding columns, the argument of (1) adds the seventh argument “additional column information of additional format of text file” to the case (2) . The seventh argument indicates the format of the additional column.
[0014]
The additional column information storage structure used in the seventh argument “additional column information of the additional format of the text file” stores three items such as an array name, its data type, and data size.
[0015]
The structure for storing information after receiving general-purpose data used in the eighth argument “for storing the number of accepted and unaccepted cases set by the system” stores two items, the number of accepted items and the number of unaccepted items.
[0016]
FIG. 4 shows an example of this structure. In the figure, the structure names of COLLUM_FORM and RET_DATA are shown.
[0017]
Next, the contents of the text file of the customer master general-purpose data will be described. The item name of the text file should include at least master delimiter, customer code, ledger index, customer name, its person in charge, main person in charge code, address, TEL, FAX, selling price, charge rate, billing address code, user name, etc. I have. One example thereof is shown in FIGS.
[0018]
Depending on whether it is customized or not, at the end of each data item of the general-purpose data text file, if there is additional column data, it is continuously set for the necessary number. Next, a line feed code is added to the end of each data item. Separate each item with a comma to make it variable. FIG. 6 shows an example of the description. When a fixed length is used, each item is separated by a space, and a character string group in which the data is set in a format that repeats the character string for the number of lines of the customer.
[0019]
【The invention's effect】
The computer-readable recording medium on which the customer master general-purpose data receiving program of the present invention is recorded has the following effects. In a computer system equipped with a database management system, a customer master general-purpose data text file group created by an external application program when processing a business sales / purchase management program at a terminal is successively accepted. Batch processing for writing and registering in the database is now possible. Even if the general data text file of the writing customer master is customized by adding columns, etc., if the customer master acceptance registration relationship corresponding to it is selected and an application program is created, the same batch processing as described above is executed. Can do.
[Brief description of the drawings]
FIG. 1 is a block diagram of a sales / purchase management program processing apparatus using a computer-readable recording medium in which a customer master general-purpose data acceptance program of the present invention is recorded .
FIG. 2 is a diagram showing an embodiment in which arguments are entered in a customer master general-purpose data acceptance registration function (1), (2) corresponding to the customization 2 state.
FIG. 3 is a diagram showing arguments of a customer master general-purpose data acceptance registration function (1), (2) .
FIG. 4 is a diagram showing a structure for storing information of seventh and eighth arguments.
FIG. 5 is a diagram showing a data portion of a general-purpose data text file.
6 is a diagram showing a data portion of a general-purpose data text file following FIG. 5. FIG.
[Explanation of symbols]
1 Terminal 4 Database management system 5 LAN
6 Server computer 10 Sales / purchase management program processing device using computer-readable recording medium recording customer master general-purpose data acceptance program , company computer system 12 Sales / purchase management program 20 Customer master general-purpose data acceptance Computer-readable recording medium 20a on which the program is recorded Customer master acceptance registration module 20b Simultaneous execution restriction module 40 Database 41 Table, file 61 Database management system program

Claims (4)

A database management system for managing and storing a database comprising a plurality of tables associated with each other;
At least one terminal,
It is used for computer systems that handle sales and purchase management programs for corporate operations,
The client master general data text files created by the external application program sequentially and continuously receiving, recording a batch processing program instructions for writing registered in the database, client master universal data which is mounted on the terminal A computer-readable recording medium recording an acceptance program ,
A customer master acceptance registration module for accepting the customer master general-purpose data text file necessary for the sales / purchase management;
A screen display module for the customer master acceptance process,
The customer master acceptance registration module includes a customer master acceptance registration function in a customer master registration DLL (dynamic link library) file;
The customer master acceptance registration function is provided in the DLL file as two different types of customer master acceptance registration functions corresponding to two states when a column is added and when no column is added,
When receiving a text file group of extension TXT, which is the customer master general-purpose data text file, each text file is in a customized state in which column data is added to the table of the write destination database. Operate an application batch program that consists of a series of files that each use a customer master acceptance registration function corresponding to the case where there is no addition of column data and there is no customization state, and the text files are sequentially and sequentially A computer-readable recording medium on which a customer master general-purpose data receiving program is recorded . In the customer master acceptance registration function group, different arguments are set corresponding to the above two states, and the basic arguments when the column data is not added and customized are the write destination database name, general purpose Whether the full path to the TXT file (folder + file name) of the data, the full path of the log file creation destination (folder + file name), the log file to be created, whether to check the contents of input unnecessary items, the same code Whether or not to update the master of the database, consists of 7 arguments for storing the number of accepted and unaccepted cases set on the database management system side, and the argument when customized by adding column data is the basic argument 2. The customer cell according to claim 1, comprising 8 arguments including an additional column information argument having an additional format of a text file. Over generic data receiving program and computer readable recording medium. The additional column information storage structure used by setting an additional column information argument having an additional format of the text file stores at least three items of an array name, a data type, and a data size, and the database management system side A structure for storing information after receiving general-purpose data that is used by setting arguments for storing the number of accepted and unaccepted items to be set, stores two items, the number of accepted items and the number of unaccepted items. A computer-readable recording medium on which the customer master general-purpose data receiving program according to claim 2 is recorded . In the text file of the customer master general-purpose data, each item name of the contents of the original part of the customer master other than the additional column data is the master category, customer code, ledger index, customer name, customer person in charge , Address, TEL, FAX, selling price No. , Charge rate, billing code, user name at least, and column data is added to the text file. If customized, additional column data will be set at the end of the original data item for the required number. When not customized, a line feed code is added at the end of the original data, and when it is customized, a line feed code is added at the end of the additional column data. 4. When the fixed length is set, each item is separated by a space, and the data is obtained as a character string group set in a format in which a character string is repeated for the number of customers. A computer-readable recording medium on which the customer master general-purpose data receiving program according to claim 1 is recorded .

Images