JP4655728B2 - Data processing apparatus and program - Google Patents

Description

The present invention relates to a data processing apparatus and a program .

  In order to manage customer data such as customer addresses and phone numbers, product data such as product names and unit prices, and delivery slips, sales order slips, and sales slip slips, this type of work should be performed. Application software (hereinafter referred to as “business application”) that is executed by a computer is widely used.

  This business application is a database (hereinafter referred to as “DB”) that stores data (hereinafter referred to as “business data”) of various items related to the user's business (for example, customer code and customer name) in a searchable manner. .). When a user registers or deletes business data related to a DB item on the business application screen, the DB is updated according to these operations.

  By the way, since the business application at the time of production / shipment at the manufacturer is set to a default state predetermined by the manufacturer, at the time of delivery to the customer, storage management of the DB is performed according to the business content and request of the customer. It is necessary to change (customize) the specifications of the items to be displayed and the layout of the screen display. For this reason, a business application dealer customizes each product when delivering it to a customer.

This customization method includes:
There are two methods: (1) a method for directly changing a business application using a programming language, and (2) a method for indirectly changing a business application using a unique customization device.

In particular, as a customizing apparatus used in the method (2), a customizing apparatus that manages the input order of business data by an input order table and customizes the input order of items by changing the input order table is known. (See Patent Document 1).
JP 2001-283139 A

However, the methods (1) and (2) have the following problems.
That is, in the method (1) for directly changing the business application, coding work and operation test must be performed for each change, and the man-hours are enormous. Specifically, when a new item (hereinafter referred to as “new item”) is added to the DB, a data area for storing the new item is added to the DB data structure, and the business data of the new item is added to the DB. The business data of the new item must be customized to a business application that can be updated, and the range of customization is diverse. Therefore, in the method (1), specialized knowledge and techniques relating to programming are required, and the cost of time and expense has become very high for the retailer who undertakes customization.

  Since the method (2) using the customization apparatus does not require specialized knowledge or technology relating to programming, customization can be performed without being aware of the source program. However, the range in which customization is possible is determined in advance, and is generally limited to changing the display layout, such as changing the order in which items are input by the customization apparatus of Patent Document 1. For this reason, unlike the method (1), it is not possible to customize a new item to be changed to the DB itself or to search / update a new item.

  An object of the present invention is to easily add an item to a database without being aware of a programming language.

According to the first aspect of the present invention, input means for inputting business data corresponding to each item name based on a slip consisting of a plurality of item names, each item name of the slip, and business data input from the input means are Database storage means for storing in association with each item name, item name adding means for inputting and setting a new item name of the slip, and the new item name added by the item name adding means is the database storage means and already judging means for judging whether it is set as the item names of the stored documents in the result of the determination in the determination unit, if the added item name is determined to be not set, the additional processing means for adding an item name of the item name of the database storage unit as a new item name of the document, wherein the input means includes a new item names are added by the processing means Is a data processing apparatus characterized by inputting the operational data corresponding to each item name based on votes.

According to the first aspect of the present invention, a data processing apparatus that performs processing by inputting business data corresponding to each item name based on a slip composed of a plurality of item names, and appropriately inputs a new item name of the slip This makes it possible to enter business data corresponding to each item name based on a slip containing a new item name, and easily add items to the database without being aware of the data structure of the database. In addition, the user does not need to change the program specification of the updating means, so it is possible to easily add items to the database without being aware of the programming language, and it is not necessary to acquire programming techniques and knowledge. May be.

According to the second aspect of the present invention, since a new item is added to the items searched by the search display means, the user does not need to change the program specification of the search display means.

According to the third aspect of the present invention, the items added by the adding unit are displayed in a list, and the user can select a desired item from the list display, and the user can select a new item as an item to be read by the reference display unit. Items can be added.

According to the invention described in claim 4 , since the button display means reads out the page names in the page order stored in the page information storage means and displays the buttons, the addition or deletion of the page name is performed on the page information storage means. There is no need to change the program specification of the button display means.

Embodiment
Hereinafter, an embodiment in which the data processing apparatus of the present invention is applied to the business data search processing apparatus 1 will be described in detail with reference to FIGS. The business data search processing apparatus 1 according to the present embodiment registers data for each item related to a user's sales business (hereinafter, this data is referred to as “business data”), and also provides a delivery slip, a sales slip, an order slip, etc. The business data that has already been registered is read and displayed on various slips.

  Items related to sales operations include items related to customers (customer items) such as customer codes, customer names, addresses, and telephone numbers, and items related to products (product items) such as product codes, product names, and unit prices. . The business data search processing device 1 supports the user business by registering and referring to data for each item, that is, business data.

  FIG. 1A is an example of a customer registration screen D1 for registering business data (customer data) for each customer item. According to FIG. 1A, the customer registration screen D1 is an input area for entering customer data for each customer item such as customer code, customer name, customer name reading, destination,... AR1 to AR8 are displayed.

  For example, when the user inputs the customer code “000001” in the input area AR1, the customer name “Arai Shokai” associated with the customer code “000001”, the customer reading “Araisho Kai”, and the destination “Arai” Customer data such as “Taro”,... Are read and displayed as shown in FIG. The user corrects and updates the displayed customer data, or registers new customer data.

  A tab TB1 is displayed on the customer registration screen D1. The tab is a display function for classifying and displaying business data, and classifies the data in units of pages called tab pages. In the tab page, a name (tab page name) assigned for each page is set. The user can switch and display the business data for each tab page by selecting a desired tab page name.

  For example, tab pages TP1 to TP6 in which tab page names such as “invoice”, “classification / abbreviation”, “unit price / amount”, “ledger”, and “collection site” are set on the customer registration screen D1. It is displayed. FIG. 1A shows a state in which a tab page TP2 with a tab page name of “classification / abbreviation” is selected, and “customer classification” and “customer abbreviation” are shown on the page. The destination data is sorted and displayed.

  A function button BT is displayed on the customer registration screen D1. The function button BT is a button for instructing start of execution of various functions of the business data search processing device 1, and the function changes depending on the business being executed, and corresponds to the function name of the function and the button. The key name of the function key K1 of the dedicated keyboard KB is displayed. When the function of the function key K1 is valid, the function button BT corresponding to the function key K1 is enabled / disabled by changing the display color of the button like the function button BT4 in FIG. Make it identifiable. The method for identifying the validity / invalidity may be, for example, identifying the function name and the key name as valid when they are black, and invalid when displaying in gray, and can be changed as appropriate.

  For example, function buttons BT4 and BT5 such as “invoice (next page)” and “unit price / amount (previous page)” are displayed on the customer registration screen D1. The function button BT4 is a button for switching from the display of the tab page TP2 to the display of the tab page TP1 “invoice” on the left side (next page). The function button BT5 is a button for switching the display from the tab page TP2 being displayed to the tab page TP3 “unit price / amount” on the right side (previous page).

  The user switches the display of the tab page by pressing the function key F4 corresponding to the function button BT4 and the function key F5 corresponding to the function button BT5. When the user switches the tab page, the tab page name of the next page is displayed on the function button BT4 and the tab page name of the previous page is displayed on the function button BT5.

  The user registers customer data from the customer registration screen D1, or updates customer data already registered. The customer data to be registered / updated is stored in a customer master table (hereinafter, the master table is abbreviated as “MT”) 55.

  The customer MT 55 is a database (hereinafter referred to as “DB”) in which business data for each of a plurality of items is stored so as to be searchable. For example, a customer name is included in a customer code. And business data such as customer name readings are stored in association with each other. Therefore, when the user inputs an arbitrary customer code from the customer registration screen D1, other business data associated with the customer code is read and displayed as shown in FIG. It will be.

  Further, the user registers / updates product data such as a product code, a product name, and a unit price on a product registration screen (not shown). The registered product data is associated with the product code and stored in the product MT so as to be searchable.

  FIG. 1B is an example of an order slip input screen D3 for issuing an order slip. Referring to FIG. 1B, the order entry input screen D3 includes input areas AR11 to AR18 for inputting customer data such as customer code, customer code, customer name, destination, postal code, address, and telephone number. And input areas AR20 to AR24 for inputting product data such as a product code, a product name, and a unit price.

  When the user inputs the customer code in the input area AR11 when inputting the order receipt, the customer name, the destination and the like associated with the input customer code are read from the customer MT55 and input area AR12. -Input on AR18. When the product code is input to the input area AR20, the product name and unit price associated with the product code are read from the product MT and input to the input areas AR21 and AR22, respectively.

  As described above, when the user inputs a customer code, a product code, or the like on the order entry input screen D3, business data of predetermined items among business data already registered in the customer MT55 and the product MT is obtained. It is read and displayed as a reference.

  FIG. 2 is a diagram illustrating an example of the key layout of the dedicated keyboard KB. Referring to FIG. 2, the dedicated keyboard KB includes a function key K1, a cursor key K2, a numeric key K3, a character key K4, and an enter key K5.

  Various functions of the business data search processing device 1 are associated with the function key K1, and when the user presses one of the function keys K1, the function associated with the key (for example, input contents) Cancel the input, end the input, print the display screen, etc.).

  The cursor key K2 is a key for scrolling the screen and performing a selection operation, and is configured to be able to detect four directions, up, down, left and right. The user selects an input area with the cursor key K2 on the customer registration screen D1 or the order entry input screen D3, and inputs business data using numeric keys or character keys K4 and numeric characters in the selected input area. . Then, for example, when the enter key K5 is pressed after inputting the customer code, the customer name, destination, etc. corresponding to the customer code are read from the customer MT55 and displayed.

[Configuration of data search processing device]
FIG. 3 is a block diagram illustrating an example of a functional configuration of the business data search processing device 1. As shown in FIG. 1, the business data search processing device 1 includes a CPU (Central Processing Unit) 3, a storage unit 5, an input unit 7, and a display unit 9.

  The input unit 7 is configured with the above-described pointing device such as the dedicated keyboard KB, the touch panel, and the mouse, and outputs a pressed key pressing signal, a touch panel or mouse position signal, and the like to the CPU 3. The display unit 9 is configured by a CRT (Cathode-ray Tube), an LCD (Liquid Crystal Display), or the like, and displays and outputs various screens based on display data input from the CPU 3.

  The CPU 3 executes processing based on a predetermined program in accordance with an input instruction, and inputs / outputs instructions to each functional unit and data. Specifically, the CPU 3 reads a program stored in the storage unit 5 in accordance with an operation signal input from the input unit 7, executes a process according to the program, and displays the processing result on the display unit 9. Display.

  According to FIG. 3, the CPU 3 includes an item addition management unit 30 having an item addition control unit 31 and a DB control unit 32, a specification management unit 33, a layout change control unit 35, an input order control unit 37, and a tab control unit 38. And a customization management unit 34 having

  When adding a new item (new item) to the master DB 54, the item addition control unit 31 enables registration and reference display of the new item on the customer registration screen D1 and the order entry input screen D3. The master DB 54 and the specification definition 56 are updated.

  The specification management unit 33 retrieves business data from the master DB 54, retrieves the business data from the master DB 54, updates a component CP3 that updates the master DB 54 with business data input by the user, and reads business data from the master DB 54 on the slip input screen. Manage the index expression.

  The customization management unit 34 performs overall control of the display screen layout. In particular, the layout change control unit 35 manages display coordinates and property values (setting values) of various controls such as the above-described input area, check boxes, radio buttons, and combo boxes, and the input order control unit 37 Manage the display order of areas. Further, the tab control unit 38 performs setting, addition, and deletion of tabs and tab pages, which will be described later, and updating the display of tab names displayed on the function buttons BT4 and BT5.

  The storage unit 5 is a functional unit that reads / writes data from / to a storage medium such as a CD-ROM, a memory card, or a hard disk. The storage medium is constituted by a magnetic or optical storage medium, a semiconductor memory, or the like, and stores data processed by an application program and various processing programs, a DB, and the like. The storage medium may be fixedly provided in the storage unit 5 or may be detachably mounted.

  According to FIG. 3, the storage unit 5 stores an additional item management table 50, a search condition table 52, a master DB 54, a specification definition 56, and a tab information table 58.

[Master database]
The master DB 54 is a data table that stores business data for each item so as to be searchable. In the present embodiment, the master DB 54 is configured to include a customer MT 55 and a product MT. FIG. 4A shows an example of the data configuration of the customer MT55.

  As shown in FIG. 4A, the customer MT55 stores business data in association with each item number. This item number is defined by the DB control unit 32 in association with the item name of the business data. The DB control unit 32 defines and manages the item name for each item number, the data type (type), and the number of digits for each master DB 54.

  FIG. 4B is a diagram showing an example of the definition contents of the customer MT55. For example, the item name of the business data with the item number “1” is “customer code”, and the business data is “6 digits”. "Character data".

[Additional item management table]
The added item management table 50 is a data table for managing items newly added to the master DB 54. As shown in FIG. 5A, the DB file name, the added item name, the data type, and the number of digits. Are stored as additional item data in association with item numbers.

  When adding a new item to the master DB 54, the user inputs the name of the item to be added (added item name), the data type, and the number of digits. The item addition control unit 31 determines whether or not the input additional item name is already set as the item name of the master DB 54 to be added, and if not set, the DB file name of the master DB 54 is set. The new item number is allocated to the additional item data including the additional item name, the data type, and the number of digits and stored in the additional item management table 50. In addition, the DB control unit 32 secures a memory area for storing the data of the input data type and the number of digits in the master DB 54 and associates it with the item number.

  For example, when the user adds “credit limit” of 10.0-digit numerical data as a new item to the customer MT55, whether or not “credit limit” is already set in the item name of the customer MT55. Determine whether. If “credit limit” is not set as the item name of the customer MT55 as shown in the file definition of FIG. 4B, the DB file name “customer MT” as shown in FIG. 5A. The additional item data including the additional item name “credit limit”, the data type “numerical value”, the number of digits “10.0”, and the item number “11” is stored in the additional item management table 50. Further, the customer MT 55 shown in FIG. 4A secures a memory area 550 capable of storing 10.0-digit numerical data.

[Search condition table]
The search condition table 52 is a data table for managing search conditions when searching the master DB 54, and stores a DB file name and search conditions in association with each other as shown in FIG. For example, the search condition “customer code = customer code” is stored in association with the DB file name “customer MT”.

  This search condition is described in, for example, a database operation language of SQL (Structured Query Language), and is preset by a manufacturer. The right side of the search condition shown in FIG. 5B represents the customer code input by the user, and the left side represents the customer code stored in the customer MT55. This represents that, among the business data already stored in the customer MT55, the business data associated with the customer code that matches the customer code input by the user is retrieved and displayed.

[Spec definition]
The specification definition 56 stores a program (search component CP1 and update component CP3) for registering business data in the master DB 54, and an index formula for reading and referring to business data from the master DB 54. Here, operations of the search component CP1 and the update component CP3 when registering customer data on the customer registration screen D1 will be described with reference to FIG.

  First, the layout change control unit 35 of the CPU 3 causes the display unit 9 to display a customer registration screen D1 (client screen) for requesting input of a customer code. When the enter key K5 is pressed after the customer code is input, the client screen outputs the customer code to the search component CP1.

  The search component CP1 is a program for managing items of business data to be read when business data satisfying the search conditions input on the client screen is retrieved from the master DB 54 and read. FIG. 7A is a diagram showing an example of the program configuration of the search component CP1, and when the customer code is input by the user, the business data of the item read from the customer MT55 is “customer code”. , “Customer name”, “customer reading”, “destination”, “zip code”,..., “Customer name abbreviation”.

  The business data read from the master DB 54 to be searched is output to the customer registration screen D1, which is a client screen, and displayed on each input area. When the user changes the business data and presses the enter key K5, the client screen outputs the changed business data to the update component CP3.

  The update component CP3 is a program for managing the business data items to be updated among the business data items stored in the master DB 54 that is the target of the update on the client screen. FIG. 7B is a diagram showing an example of the program configuration of the update component CP3. When the processing function of “correcting” the business data of the customer MT55 is designated by the user, “customer code”, Overwrite the business data of items such as “customer name”, “customer reading”, “destination”, “zip code”,..., “Customer name abbreviation” with the business data (input contents) entered by the user Correct and update customer MT55.

  Next, the operation of the business data search processing device 1 when reading business data from the master DB 54 using the index formula stored in the specification definition 56 for reference display when a slip is entered on the order slip input screen D3 will be described.

As shown in FIG. 1B, in the order entry input screen D3, when a customer code is input, business data of predetermined items such as a customer name and a destination is read from the customer MT55 and displayed as a reference. Is done. The DB file name of the master DB 54 that reads out the business data, the search condition when reading out, and the item name that is read out are as follows:
Index (file name, search condition, item name) (1)
And is stored in the specification definition 56.

For example,
Index (customer MT, customer code = customer code, credit limit)
The index expression “represents that the credit limit amount associated with the customer code (left side) in the customer MT55 that matches the customer code (right side) input by the user is read from the customer MT55”. ing. Such an index formula is managed and stored for each slip by the specification definition 56.

  When the spec management unit 33 reads from the master DB 54 the business data to be displayed on each slip input screen based on the index formula stored in the specification definition 56, the layout change control unit 35 reads the read business data. Is displayed at a predetermined position on the slip input screen.

[Tab information table]
The tab information table 58 is a data table for managing tabs and tab pages to be displayed on various screens. As shown in FIG. 5C, tab names, tab page names, and page numbers are associated with each other. Store as tab information.

  FIG. 5C is a diagram illustrating an example of a data configuration of a tab information table 58 that stores tab information of the tab TB1 on the customer registration screen D1 of FIG. That is, in the tab information DT1, “customer registration” represents the tab name of the tab TB1, “invoice” represents the tab page name of the tab page TP1, and “1” represents the page number of the tab page TP1. Based on the tab information stored in the tab information table 58, the tab control unit 38 controls tab page switching display to be described later.

[Specific operation when adding items]
Next, as a specific example of the operation of the business data search processing apparatus 1 for adding a new item to the master DB 54, a case where “credit limit” is added as a new item to the customer MT55 on the customer registration screen D1 is taken as an example. A description will be given with reference to FIGS.

  First, when an instruction to start customization of the customer registration screen D1 is input by the user, the DB file name of the master DB 54 to be searched and updated by the search component CP1 and the update component CP3 of the specification management unit 33, that is, “custom The “first MT” is acquired (step A1).

  At this time, the input area for character-type business data is filled with “XXXX” as in the customer registration screen D3 of FIG. 9A, and the input area for numeric-type business data is filled with “99999”. The function button BT displays the function name stamped on the function key K1.

  When the CPU 3 determines that the customization has not been completed (step A3; Yes), a new item input area is added on the customer registration screen D3 based on the user's item addition operation (step A5). ). The item addition operation is an operation for determining the position and size of the input area of a new item by operating the mouse, the cursor key K2, or the like.

  At this time, an item attribute input screen D5 as shown in FIG. The user inputs the item name, data type, and number of digits of the item to be added to the item attribute input screen D5 (step A7).

  The CPU 3 determines whether or not to add the input item to the customer MT55 (step A9). When the CPU 3 detects that the OK button BT10 on the item attribute input screen D5 is pressed, it determines that the input item is to be added to the customer MT55 (step A9; Yes), and the item name “credit limit” is determined. Is already set as an item of the customer MT55 (step A11).

  If the CPU 3 determines that the “credit limit” is not set (step A11; Yes), the additional item management table 50 includes the DB file name “customer MT”, the additional item name “credit limit”, the data type “ Additional item data of “numerical value”, number of digits “10.0”, and item number “11” are stored as shown in FIG. 5A (step A13).

  The specification management unit 33 of the CPU 3 adds “credit limit” to the item name of the search component CP1 (step A15), and adds “credit limit” to the item name and input content of the update component CP3 (step A15). A17).

  The CPU 3 performs steps A3 to A17 until a customization end operation (for example, an operation of pressing a “customization end” button on the menu screen) is performed. FIG. 10A shows the customer registration screen d1 when “credit limit” and “birthday of president” are added as new items. At this time, the additional item management table 50 stores additional item data including “credit limit” and “birthday of president” as additional item names as shown in FIG.

  Further, as shown in FIG. 11A, the item name of the search component CP1 is such that the items of business data searched and read from the customer MT55 include the business data of “credit limit” and “president's birthday”. "Credit limit" and "President's birthday" are added. In addition, when correcting the customer MT55, the item name and the input content are displayed in the update component CP3 as shown in FIG. 11B so that the business data of “credit limit” and “birthday of the president” are corrected and updated. Added.

  When the CPU 3 detects that the customization end operation has been performed (step A3; No), the CPU 3 updates the data structure of the customer MT55 based on the additional item data stored in the additional item management table 50. (Step A19), the item number is set to the customer MT55 (Step A21). As a result, the memory areas 550 and 552 (broken lines) of the customer MT55 shown in FIG. Thus, the customer MT55 after adding the credit limit and the president's birthday has a data structure as shown in FIG.

  FIG. 10B shows an example of the customer registration screen D1 after customization is completed. As shown in FIG. 10 (b), the customer registration screen D1 has the credit limit read according to the item name of the search component CP1 shown in FIG. 11 (a) as the input area AR30 and the president's birthday as the input area. Displayed in AR31.

  When the credit limit and the president's birthday displayed in these input areas are corrected, the corrected credit limit and the president's birthday are the item names of the update component CP3 shown in FIG. 11B. It is updated and stored in the memory areas of item numbers “11” and “12” of “credit limit” and “president's birthday”, respectively.

[Specific operation when entering a slip after adding items]
Next, a specific operation example of the business data search processing apparatus 1 that references a business data of the new item on the slip input screen after adding a new item to the master DB 54 will be described with reference to FIGS. An example will be described in which “business category” is added to the customer MT55 as a new item, and then the business data of the “business category” is displayed by referring to the customer MT55 on the order entry input screen D3. However, the items to be added and the slip input screen are not limited to this.

  First, in the additional item management table 50 after the “business division” is added to the customer MT 55, as shown in FIG. 14A, the DB file name “customer MT”, the additional item name “business division”, Additional item data DT3 including the data type “character”, the number of digits “2”, and the item number “13” is stored.

  When the customization start instruction is input by the user, the specification management unit 33 acquires the file name of the master DB 54 (step B1). Since the customer MT 55 and the product MT are referred to on the order entry input screen D3, the “customer MT” and the “product MT” are acquired as DB file names.

  If the CPU 3 determines that the customization has not been completed (step B3; Yes), an item input area AR40 is added to the order entry input screen D3 based on the user's item addition operation (step B5). .

  For example, when the CPU 3 detects that “input of index formula” is selected from the menu screen and an operation for setting the index formula in the input area AR 40 is performed (step B7; Yes), the search condition table 52 is displayed. (Step B9), an index formula wizard D7 as shown in FIG. 14B is displayed on the display unit 9 (Step B11).

  In this index formula wizard D7, a list L1 of DB file names stored in the additional item management table 50 is displayed. When the user selects a DB file name from the list L1 by the reverse display M shown in FIG. 14B, the CPU 3 reads additional item data including the selected DB file name from the additional item management table 50, A list L3 of additional item names included in the read additional item data is displayed as shown in FIG. 14B (step B13).

  When the user selects the item name of the business data to be read and displayed in the input area AR40 from the list L3 of additional item names, the CPU 3 displays the selected DB file name and the additional item name using the index formula ( 1) (step B15). At this time, the search condition corresponding to the selected DB file name is read from the search condition table 52 acquired in step B9 and set in the index formula.

In FIG. 14B, when the DB file name “customer MT” and the item “business category” are selected,
Index (customer MT, customer code = customer code, business category)
Is generated.

  When the CPU 3 detects that the customization end operation has been performed (step B3; No), the CPU 3 adds and updates the index formula generated in step B15 to the index formula stored in the specification definition 56 (step B17). . At this time, the index formula is stored in association with the slip screen for setting.

  FIG. 14C is a screen example of an order entry input screen D3 to which a business division input area AR40 is added. For example, when the user inputs a customer code in the input area AR11 and presses the enter key K5, the business category associated with the customer code that matches the input customer code is read from the customer MT55. The reference area is displayed in the input area AR40.

[Addition and deletion of tabs and tab pages]
Next, a specific operation example of the business data search processing apparatus 1 for adding / deleting tabs and tab pages will be described with reference to FIGS. In addition, although the case where a tab and a tab page are added to the customer registration screen D1 will be described as an example, the screen to be added / deleted may be an order entry input screen or another screen.

  First, the CPU 3 determines whether or not a tab addition operation has been performed during customization of the customer registration screen D1 (step C3). For example, when “add tab” is selected from the menu screen and a tab addition operation for designating a tab display area is performed on the customer registration screen D1 (step C3; addition), the tab information table is displayed. A new tab name is set at 58 (step C5).

  For example, when a tab TB10 is specified on the customer registration screen D1 shown in FIG. 16A and a tab is added, the CPU 3 assigns a tab name “customer registration” to the tab TB10. The tab name can be arbitrarily changed by the user.

  When the CPU 3 selects, for example, “add tab page” from the menu screen and determines that the tab page addition operation for inputting the tab page name has been performed (step C9; addition), the CPU 3 The page number is acquired as tab page information (step C11), and the tab page information is set for the tab name to be added in the tab information table 58 (step C13).

  At this time, when the user inputs “invoice” as the tab page name, a tab information table 58 having a table configuration as shown in FIG. 17A is generated, and customer registration is performed as shown in FIG. A tab page TP1 is created on the screen D1. By performing the processes of steps C11 and C13, the tab information table 58 having the data structure shown in FIG. 5C is generated, and the tab TB1 as shown in FIG. 1A is displayed.

  When a new tab page is added between the tab page TP3 and the tab page TP4, the page number “4” of the tab page is designated. At this time, the CPU 3 generates tab page information including the tab name “customer registration”, the tab page name “add”, and the page number “4”, and inserts it into the tab information table 58.

  At this time, 1 is added to the page number of the tab page information following the inserted tab page information, and the tab page TP3-4 is displayed on the customer registration screen D1 as shown in FIG. It is inserted and displayed between TP4. The tab page name “add” is a tab page name assigned by the CPU 3 in the initial state, and can be arbitrarily changed by the user.

  For example, when a tab deletion operation is performed by selecting “delete tab” from the menu screen and designating a tab name (step C3; delete), the CPU 3 displays tab page information including the tab name as tab information. Delete from the table 58 (step C7).

  For example, when a tab page deletion operation is performed by selecting “delete tab page” from the menu screen and designating a tab page name (step C9; delete), the tab page name and its page number (Step C15). Then, the tab page information including the tab page name and page number is deleted from the tab information table 58 (step C17). At this time, the page number is matched by subtracting 1 from the page number of the tab page information following the deleted tab page information.

[Switch function button display]
Next, a specific operation example of the business data search processing device 1 in switching display of tab page names displayed on the function buttons BT4 and BT5 when the tab page is switched will be described with reference to FIGS.

  First, the CPU 3 determines whether or not a tab exists on the customer registration screen D1 (step E1). If a tab exists (step E1; Yes), the tab information table 58 is read (step E3). ).

  Then, the maximum page number (maximum page number “N”) is acquired from the tab page information including the tab name of the tab being displayed (step E5). In the tab information table 58 of FIG. 5C, the maximum page number is “6”. Next, the page number (displayed page number) of the currently displayed tab page is acquired (step E7).

  When the page number of the currently displayed tab page is, for example, the tab page TP1 of “1” as shown in FIG. 19A (step E9; 1), the CPU 3 displays the tab button of the next page, that is, the function button. BT4 is set to be stiff (invalid) (step E11), then the tab page name “classification / abbreviation” of page number “2” obtained by adding 1 to the displayed page number “1” is read from the tab information table 58, The display is set on the tab button on the previous page, that is, the function button BT5 (step E13).

  Further, when the page number of the currently displayed tab page is a value between 2 and N−1, for example, the tab page TP2 with the page number “2” as shown in FIG. 19B (step E9). 2 to N-1), the CPU 3 reads the tab page name “invoice” of the page number “1” obtained by subtracting 1 from the displayed page number “2” from the tab information table 58 and displays it on the function button BT4. Set (step E15). Then, the tab page name “unit price / amount” of the page number “3” obtained by adding 1 to the displayed page number “2” is displayed and set on the function button BT5 (step E17).

  Further, when the page number of the currently displayed tab page is, for example, the tab page TP6 with the maximum page number N “6” as shown in FIG. 19C (step E9; N), the CPU 3 displays the displayed page number. The tab page name “consumption tax” of the page number “5” obtained by subtracting 1 from the number “6” is displayed and set on the function button BT4 (step E19), and the function button BT5 is set to be stable (invalid) (step E21). .

  As described above, according to the present embodiment, when business data is registered in the master DB 54, when a new item is added to the item to be registered, it is based on the item attributes such as the item name, data type, and number of digits input by the user. Thus, a memory area for storing new items is secured in the master DB 54, and the program configurations of the search component CP1 and the update component CP3 are updated. For this reason, when a new item is added to the master DB 54, it is not necessary to change the specifications of a program executed when registering customer data such as the search component CP1 and the update component CP3. Therefore, the user can add a new item by a simple operation such as inputting an item attribute without acquiring specialized knowledge and techniques such as a programming language.

  In addition, when the business data of the newly added new item is referred to and displayed in the slip input for reading and displaying the business data from the master DB 54, the item selected in the index formula wizard D7 and the item are stored. An index formula is generated from the search conditions of the master DB 54. For this reason, the user can perform, for example, an index expression for reading business data from the master DB 54 by a simple operation such as selecting an item without using a specialized language such as SQL.

  Further, when adding or deleting a tab page, the tab page information is added to or deleted from the tab information table 58, and the tab page name displayed on the function buttons BT4 and BT5 is switched. Based on. Therefore, there is no need to change the processing contents shown in FIG. 18 for controlling the tab page name switching display, that is, the program specification change.

(A) is an example of a customer registration screen, (b) is a diagram showing an example of an order entry input screen. The figure which shows the example of key arrangement | positioning of a dedicated keyboard. The block diagram which shows an example of a function structure of the business data search processing apparatus. (A) is a data structural example of a customer master table, (b) is a figure which shows an example of the file definition of a customer master table. (A) is a data structural example of an additional item management table, (b) is a data structural example of a search condition table, (c) is a figure which shows a data structural example of a tab information table. The figure for demonstrating the outline | summary of the business data search processing apparatus at the time of registration of business data. (A) is a figure which shows an example of a search component, (b) is an example of a program structure of an update component. The 1st flowchart for demonstrating the specific operation | movement of the business data search processing apparatus. (A) is an example of a customer registration screen at the start of customization, and (b) is a diagram illustrating an example of an item attribute input screen. (A) is an example of a customer registration screen when an item is added, and (b) is a diagram showing an example of a customer registration screen when customization is completed. (A) after an item addition is a figure which shows an example of a search component, (b) shows an example of a program structure of an update component. The figure which shows an example of the file definition of the customer master table after an item addition. The 2nd flowchart for demonstrating the specific operation | movement of the business data search processing apparatus. (A) is an example of a data structure of an additional item management table, (b) is a screen example of an index formula wizard, (c) is a figure which shows an example of an order receipt input screen with customization start. FIG. 13 is a third flowchart for explaining a specific operation of the business data search processing device. (A) is a figure which shows the example of a customer registration screen at the time of tab addition, (b) at the time of tab page addition. (A) is a data configuration example of a tab information table, (b) is a screen example of a customer registration screen when a tab page is inserted, and (c) is a diagram showing a data configuration example of a tab information table when a tab page is inserted. The 4th flowchart for demonstrating the specific operation | movement of the business data search processing apparatus. The figure which shows an example of the display switching of the tab button at the time of switching of a tab page.

Explanation of symbols

1 Business data search processing device 3 CPU
30 Item addition management unit 31 Item addition control unit (discriminating means, adding means, update item adding means, search item adding means, reference item adding means)
32 DB control unit 33 Specification management unit (search result update means)
34 Customization management unit (button display means, switching display means)
35 Layout Change Control Unit 37 Input Order Control Unit 38 Tab Control Unit (Classification Display Unit)
5 storage unit 50 additional item management table (item storage means)
52 Search condition table 54 Master database (database storage means)
56 Specification Definition CP1 Search Component (Search Display)
CP3 update component (update means)
58 Tab information table (page information storage means)
7 Input section (input means, data input means, selection means)
9 Display D1 Customer registration screen D2 Order slip input screen (reference display means)
D5 Item attribute input screen D7 Index formula wizard (list display means)
TB1-TB6 Tab page (classification display means)

Claims (5)

An input means for inputting business data corresponding to each item name based on a slip consisting of a plurality of item names ;
Database storage means for storing each item name of the slip and the business data input from the input means in association with each item name ;
Item name adding means for inputting and setting a new item name of the slip,
A discriminating unit for discriminating whether or not the new item name added by the item name adding unit is already set as the item name of the slip stored in the database storage unit;
Results of the determination of the determination means, if the added item name is determined to be not set, the process of adding the additional item name in the item name of the database storage unit as a new item name of the document Means,
And the input means inputs business data corresponding to each item name based on a slip added by the processing means and including a new item name . The processing means includes
Search display means for reading and displaying the business data satisfying the search condition input by the user for each item name ;
In business data for each item name input by said input means and the search results update means for updating the business data retrieved by the retrieval and display means for each said item name,
The search item name display means retrieves the data processing apparatus according to claim 1, characterized in that it has a search item addition means for adding the new item name. Item storage means for accumulating and storing new item names added by the processing means;
Reference display means for reading and displaying business data corresponding to a predetermined item name from business data stored by the database storage means;
List display means for displaying a list of new item names stored by the item storage means;
And selection means for selecting a new item name from among the new item name this that have been listed,
A reference item adding means for adding the new item name selected by the selecting means to the item name read by the reference display means;
Further comprising a data processing apparatus according to any one of claims 1-2, characterized in. Classifying display means for classifying the business data for each of a plurality of pages and displaying the business data classified for a specified page;
Page information storage means for storing page names in page order;
Button display means for reading out the page name of the page adjacent to the page being displayed from the page information storage means and displaying the page name as a button;
When the page name displayed by the button display means is designated, the switching display means for switching the displayed page to the display of the business data classified into the page of the designated page name,
The data processing apparatus according to any one of claim 1 to 3, further comprising a. Computer
An input means for inputting business data corresponding to each item name based on a slip consisting of a plurality of item names,
Database storage means for storing each item name of the slip and business data input from the input means in association with each item name,
Item name addition means for inputting and setting a new item name of the slip,
Discriminating means for discriminating whether or not the new item name added by the item name adding means is already set as the item name of the slip stored in the database storage means,
When it is determined that the added item name is not set as a result of the determination by the determination unit, a process of adding the added item name to the item name of the database storage unit as a new item name of the slip means,
Means for controlling the input means to input business data corresponding to each item name based on a slip including a new item name added by the processing means
Program to function as.

Images