JP5057126B2 - Computer-readable recording medium on which journal entry voucher general-purpose data acceptance program is recorded - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
Is used in the computer system to handle the financial accounting of the enterprise business, accepted in succession the text file group of journal entry general-purpose data that has been created by the external application program, the application back Chipu program to write registered in the database from the terminal The present invention relates to a computer-readable recording medium on which a general-purpose data receiving program that describes the above procedure is recorded .
[0002]
[Prior art]
In the past, a computer system terminal equipped with a database management system has been used to input a large number of journal entry slip data by a financial accounting program for performing business operations. Therefore, in order to reflect the journal entry slip data entered by an external application program as journal entry slip data of another application program, a general-purpose data text file can be created for each slip, If other application programs can be accepted, the work efficiency of the input work can be improved. However, if the slip input amount is large, a longer work 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. It is used in a computer system for processing financial accounting, external application program receiving sequentially continuously journal entry general data text files created in the procedure of the application back Chipu program for writing registered in the database from the terminal The computer-readable recording medium which recorded the general-purpose data acceptance program which described this is provided.
[0004]
[Means for Solving the Problems]
To solve the above problems, the journal entry generic data receiving program computer-readable recording medium having recorded the present invention, a database management system for managing store the database comprising a plurality of tables that are associated with each other, at least one or more In a computer system having a terminal and processing a financial accounting program for corporate business, a journal slip general-purpose data text file group created by an external application program is successively received and written and registered in the database. a computer-readable recording medium recording a journal entry generic data receiving program containing instructions to application batch program, the recording medium, journal entry receiving registration module for receiving processing for financial accounting documents of the company business At least comprising a Le, the partition translated document receiving registration module, a journal entry registration function that is called the application batch program, DLL in (dynamic linking library) files, journal entries posted registration and journal entry acceptance registration function The journal voucher general-purpose data text file acceptance process operates the journalized voucher receipt registration function according to at least the customized data name and the additional column data name described in the journal voucher general-purpose data text file. The additional column data is read and written to the database, and the journal slip text file is read when only the detailed data is entered in the journal slip general data text file. 2 made from the condition of the high-speed document to be posted The number, in accordance with the column data additional formatting format argument, by operating the journal entry posted registration function, writes registration to the database, characterized in that.
[0005]
The journal entry acceptance registration function includes a write destination database name, a history writing user name, a general data acceptance condition, a slip write condition, a full path to a journal entry general data text file, a log file creation destination full path, and a log file. specified, characterized in that it have a 7 arguments for storing accepted pre specification number and non-acceptance specification number to set the system side.
[0006]
Further, the general-purpose data acceptance conditions of the general-purpose data acceptance condition storage structure used as an argument, the presence or absence of creation log files, display any error message dialog, the three items of the display whether the message of the non-acceptance data stored the voucher write condition document write condition storage structure used as an argument of the set presence or absence of high-speed slip, setting the document number, setting the presence or absence of document number duplicate check, the four items of numbering starting document No stored , information storage structure after generic data accepting said system is used as an argument for storing accepted pre specification number and non-acceptance specification number to set, two items of registered items count and unregistered item number is stored It is characterized by that.
[0007]
The journal slip general-purpose data text file is composed of an additional column information section and a detail data section. When the column information is added to both the detail data and the detail consumption tax data, the detail data only column Corresponding to the state of customization 3 when adding column data only for detailed consumption tax data when adding data, it has at least a customized data name and an additional column data name, and each item name in the detailed data section is Voucher separation, closing flag, voucher date, voucher department code, debit general account code, debit sub item code, debit amount, debit consumption tax amount, debit consumption tax calculation category, debit tax category, debit business category, credit Department code, credit general account code, credit sub-item code, credit amount, credit consumption tax amount, credit consumption tax calculation category, credit tax category, credit business category, selection If there is additional column data at the end of the detail data item corresponding to the customization state, it will be set as many times as necessary, and a line feed code will be added at the end of each data item. Separate between items by commas, information of the additional column is set as a character string from 0 line corresponding to the customized state 2 matrix, the bright fine data unit is set in a format that repeating number of string rows documents Character strings are used.
[0009]
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 financial accounting program processing apparatus 10 using a computer-readable recording medium on which a journal slip general-purpose data acceptance program of the present invention is recorded . Here, 10 is a corporate computer system, shows a device for processing a financial accounting program 12 using a journal entry generic data receiving program computer-readable recording medium 20 which records the present invention. 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 financial accounting program 12 for performing business of a company. Further, the terminal group 1 is loaded with a computer-readable recording medium 20 on which a journal entry general-purpose data receiving program is recorded . Among these, at least a journal entry acceptance registration module 20a, a simultaneous execution restriction module 20b, and the like are provided. In addition, there is a screen display module for 20a, for example. Details of the journal entry acceptance registration module 20a are as follows. Includes a journal entry receiving registration module 20 a is document creation DLL therein journal in (dynamic linking library) files Document accepted registration function (a), journal entries posted registration function for high-speed batch processing (b) Yes. Here, the journal entry posting registration function (b) is not the normal entry processing of the entry entry acceptance function (a), but only the entry entry operation of the entry is performed in advance, and the batch entry entry high-speed batch processing is performed. A function used to do.
[0010]
This journal entry acceptance function (a) is a function corresponding to the customized state of the journal entry general-purpose data text file, that is, the following four states.
[0011]
The customization status is as follows: (b) When column data is added to both the item data and item consumption tax data , ( b) When column data is added only to item data , ( c) Column data only to item consumption tax data is added If added, either (d) item data item consumption tax data does not add columns data, i.e., a function corresponding to customize 4 state when not customized.
[0012]
FIG. 2 shows an embodiment in which the function name is ERP_HnyWrt () and arguments are entered so that they can be used in an application batch program, and the arguments of these functions are shown.
[0013]
As shown in FIG. 2, the general-purpose data acceptance function includes a first argument “write destination database name”, a second argument “history write user name”, a third argument “general-purpose data acceptance condition”, and a fourth argument “slip”. Write condition ”, fifth argument“ full path to general-purpose data text file ”, sixth argument“ specification of full path and log file creation destination of log file ”, seventh argument“ number of received details set on system side and It consists of 7 arguments “for storing the number of unaccepted details”.
[0014]
The general-purpose data acceptance condition storage structure used in the third argument “general-purpose data acceptance condition” stores three items: whether or not a log file is created, whether or not an error message dialog is displayed, and whether or not an unaccepted data message is displayed. .
[0015]
The structure for storing the slip writing condition used in the fourth argument “slip writing condition” includes four items such as whether or not a high-speed slip is set, whether or not a slip number is set, whether or not a slip number overlap check is set, and numbering start slip No. Is stored.
[0016]
The general-purpose data post-acceptance information storage structure used in the seventh argument “for storing the number of accepted details and the number of unaccepted details set by the system” stores two items, the number of registered details and the number of unregistered details.
[0017]
Examples of this structure are shown in FIGS. In the figure, the structure names are HNY_JKN, DEN_JKN, and RET_DATA, respectively.
[0018]
Next, the contents of the journal entry general-purpose data text file will be described. The text file is divided into an information part and a detail data part of an additional column. The information part of the additional column corresponds to the customized 3 state when adding both column data and item data, item data only, or item consumption tax data. Each item name includes at least a customized data name, an additional column name, and the like. One example thereof is shown in FIG.
[0019]
Next, each item name in the detail data section is at least a document separator, settlement flag, document date, document number, debit department code, debit general account code, debit sub item code, debit amount, debit consumption tax amount, debit consumption Tax calculation category, debit tax category, debit business category, credit department code, credit general account code, credit sub-item code, credit amount, credit consumption tax amount, credit consumption tax calculation category, credit tax category, credit business category, description And at least a name. One embodiment is shown in FIGS.
[0020]
Corresponding to the customization 4 state, the additional column information and the detailed data item are respectively set at the end of the additional column data if necessary. Next, a line feed code is added to the end of each data item. Each item is separated by a comma. FIG. 6 shows an example of the description. The information part of the additional column is set as a character string of 0 to 2 lines corresponding to the state of customization, and subsequently, the detail part data is a character string that is set in a format that repeats the character string for one line for each number of slips. Become a group.
[0021]
Also, in order to make the journal entry posting registration function (b) perform the minimum necessary work, the following different arguments adapted to the two states of customization are provided.
[0022]
When the column data is customized by adding the column data to the detail data, the argument (b) becomes three arguments by adding the argument of the slip detail addition format to the basic argument.
[0023]
When the column data is not customized without addition of column data (b), the basic arguments are two arguments including at least the destination database name and the conditions of the high-speed slip to be transferred.
[0024]
Journal entry posting registration function (b) ERP. An example of DenReTenki 1 000 is shown in FIG. FIG. 10 shows an example of the structure for storing information of the second argument of the journal entry posting registration function.
【Effect of the invention】
[0025]
The computer-readable recording medium on which the journal slip 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, when a financial accounting program for corporate business operations is processed by a terminal, journal entry general-purpose data text files created by an external application program are successively received and stored in the database. Batch processing to register for writing has become possible. Even if the general-purpose data text file of the journal entry slip is customized by adding column data or the like, the batch processing similar to the above can be executed with the application batch program as it is.
[Brief description of the drawings]
[0026]
FIG. 1 is a block diagram of a financial accounting program processing apparatus using a computer-readable recording medium in which a journal entry general-purpose data acceptance program of the present invention is recorded .
FIG. 2 is a diagram showing a journal entry acceptance registration function and an embodiment in which arguments are entered in the function.
FIG. 3 is a diagram illustrating a structure for storing information of a third argument of a journal entry acceptance function.
FIG. 4 is a diagram illustrating an information storage structure of a fourth argument of a journal entry acceptance function.
FIG. 5 is a diagram showing an information storage structure of a seventh argument of a journal entry acceptance function.
FIG. 6 is a diagram showing an information part of an additional column of a general-purpose data text file.
FIG. 7 is a diagram showing a detailed data part of a general-purpose data text file.
FIG. 8 is a diagram showing a detailed data part of the general-purpose data text file continued from FIG. 7;
FIG. 9 is an example of a journal entry posting registration function according to the present invention.
FIG. 10 is a diagram illustrating a structure for storing information of a second argument of a journal entry posting registration function.
[Explanation of symbols]
1 Terminal 4 Database management system 5 LAN
6 Server computer 10 Computer system 12 for operating a financial accounting process by operating a computer-readable recording medium recording a journal entry general-purpose data receiving program 20 Financial accounting program 20 Computer-readable recording medium 20a recording a journal entry general-purpose data receiving program Journal entry 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;
In a computer system comprising at least one terminal and processing a financial accounting program for corporate business,
Computer readable recording journal voucher general-purpose data acceptance program that describes the procedure of the application batch program that sequentially accepts the journal voucher general-purpose data text file group created by the external application program and writes and registers it in the database. Recording medium,
The recording medium includes at least a journal entry acceptance registration module that accepts and processes a financial accounting process slip of the enterprise business ,
The journal voucher receipt registration module includes a journal voucher receipt registration function and a journal voucher posting registration function in a DLL (dynamic linking library) file as a journal voucher registration function called by the application batch program.
The journal voucher general data text file acceptance process is performed by operating the journal voucher receipt registration function in accordance with at least the customized data name and the additional column data name described in the journal voucher general data text file. Read and register to write to the database,
When only the detailed data is entered in the journal slip general data text file, the journal slip text file is read with two arguments consisting of the destination database name, the conditions of the high-speed slip to be transferred , and the column data additional format format argument. In accordance with the journal entry posting registration function to perform writing registration in the database,
The computer-readable recording medium which recorded the journal entry voucher general-purpose data acceptance program characterized by the above-mentioned.   The journal entry acceptance registration function is used to specify the destination database name, history writing user name, general data acceptance conditions, slip entry conditions, full path to journal entry general data text file, log file creation destination full path and log file. 7. A computer-readable recording medium recording a journal entry general-purpose data receiving program according to claim 1, wherein the recording slip has seven arguments for storing the number of accepted details and the number of unaccepted details set on the system side.   The general-purpose data acceptance condition storage structure used as an argument for the general-purpose data acceptance condition stores three items: whether or not a log file is created, whether or not an error message dialog is displayed, and whether or not an unaccepted data message is displayed. The slip writing condition storage structure used as an argument of the slip writing condition stores four items of whether or not a high-speed slip is set, a slip number setting, a slip number duplicate check setting and a numbering start slip No. The structure for storing information after receiving general-purpose data used as an argument for storing the number of accepted items and the number of unaccepted items set by the system contains two items: the number of registered items and the number of unregistered items The computer-readable recording medium which recorded the journal entry voucher general-purpose data acceptance program of Claim 2 characterized by these.   The journal voucher general data text file is composed of an additional column information section and a detailed data section. When the additional column information section adds column data to both the detailed data and the detailed consumption tax data, only the detailed data includes column data. If added, corresponding to the customization 3 state when only column consumption tax data column data is added, at least a customized data name and an additional column data name are provided. , Closing flag, slip date, slip number, debit department code, debit general account code, debit sub-item code, debit amount, debit consumption tax amount, debit consumption tax calculation category, debit tax category, debit business category, credit department code , Credit general account code, credit sub-item code, credit amount, credit consumption tax amount, credit consumption tax calculation classification, credit tax classification, credit business classification, description name and At least, if there is additional column data at the end of the detail data item corresponding to the customization state, it will be set as many times as necessary, and a line feed code will be added at the end of each data item, between each item Separated by commas, the information part of the additional column is set as a character string of 0 to 2 matrixes corresponding to the customization state, and the detailed data part is a character string group set in a format that repeats the character string for the number of lines of the slip. The computer-readable recording medium which recorded the journalizing slip general-purpose data reception program of Claim 2 characterized by the above-mentioned.

Images