JP7122866B2 - Business support device, divided amount output method and divided amount output program - Google Patents

Description

The present invention relates to a business support device, a divided amount output method, and a divided amount output program.

In the construction industry for detached houses, the seller (detached house developer) submits a purchase order, an acknowledgment, and an invoice based on the payment details determined at the time of placing the order with the construction company. often handed over to The invoice will be sent from the construction company to the seller at a later date.

For example, Japanese Patent Application Laid-Open No. 2002-300003 is cited as a prior art document related to the preparation and exchange of orders, contracts, and invoices related to construction. In Patent Document 1, "For the construction determined by the match system 3, construction approval documents (profit plans) and construction order sheets are automatically created within the main contractor company. It is mailed from the contractor company to the subcontractor company, and the written confirmation of the subcontractor company is also sent to the main contractor company." (see paragraph 0028, etc.). In addition, in Patent Document 1, ``The subcontractor confirms its own performance on the construction management system 7 and automatically issues an invoice to the main contractor. The invoice can be sent to the prime contractor only by stamping on ." (see paragraph 0038, etc.).

JP 2010-267219 A

Here, for example, when the construction company corresponds to a so-called micro enterprise, the seller may divide the bill to be given to the construction company into a plurality of invoices in consideration of the construction company's cash flow. Then, in dealing with this, it is decided between the seller and the construction company how to divide the amount of the invoice.

However, the method of division varies from construction company to construction company, such as dividing by a fixed amount or dividing by a proportional division ratio. I had to manually divide the sum of money. This dividing work is complicated and thus a heavy burden.

SUMMARY OF THE INVENTION The present invention has been made in view of the above problems, and is a business support device, a divided amount output method, and a divided amount output that can greatly reduce the burden required for dividing the amount of an invoice. The purpose is to provide a program.

In order to solve the above-described problems and achieve the object, a business support device according to the present invention is a business support device comprising a control unit, wherein the control unit divides the principal amount that is the basis of the division divided amount output means for outputting a plurality of divided amounts, wherein the divided amount output means includes initial value setting means for substituting the principal amount into a principal amount variable and a balance amount variable; and a division rule set including a plurality of division rules. a rule acquisition means for acquiring the split rule from the rule acquisition means; a value acquisition means for acquiring the value of the principal amount variable or the value of the balance amount variable at the time of execution of this processing according to one of the balance amount categories meaning acquisition, and the value acquisition means determining means for determining whether the acquired value satisfies an amount condition included in the division rule acquired by the rule acquiring means; A combination of the predetermined amount output category and the predetermined amount, which are included in the division rule obtained by the rule obtaining means, indicating that the predetermined amount is to be output as the divided amount, and the value obtained by the value obtaining means and the predetermined ratio. Of the combination of the ratio reference amount output category meaning that the product is output as the divided amount and the predetermined ratio, and the full amount output category meaning that the value obtained by the value obtaining means is output as the divided amount calculation means for calculating, according to the output classification included in any of the information, the divided amount corresponding to the output classification based on the information or the value obtained by the value obtaining means; and main processing of the balance amount variable updating means for substituting a value obtained by subtracting the divided amount calculated by the calculating means from the value at execution into the balance amount variable, wherein the rule acquiring means, the value acquiring means, the determining means, and the calculating means and operating the updating means a plurality of times.

In addition, in the business support device according to the present invention, the principal amount may be an order amount relating to construction work of a detached house ordered by a developer to a construction company, and the divided amount may be determined by the construction company from the developer. The amount to be billed for the construction work to be billed to the developer may be described in an invoice sent by the developer to the construction company at the time of placing the order.

Further, the business support device according to the present invention may comprise a display section, and the divided amount output means displays the principal amount on a predetermined screen for confirming the content of the order displayed on the display section. It may start working after it is set.

Further, a divided monetary amount output method according to the present invention is a divided monetary amount output method executed by a business support device having a control unit, wherein the principal amount to be divided is divided and a division amount output step of outputting a plurality of division amounts, wherein the division amount output step includes an initial value setting step of substituting the principal amount into a principal amount variable and a balance amount variable; and a division rule set including a plurality of division rules. a rule acquisition step of acquiring the split rule from the rule acquisition step; a value acquisition step of acquiring the value of the principal amount variable or the value of the balance amount variable at the time of execution of this process according to one of the balance amount categories meaning acquisition; a judgment step of judging whether the acquired value satisfies an amount condition included in the division rule acquired in the rule acquisition step; A combination of the predetermined amount output category and the predetermined amount, which are included in the division rule obtained in the rule obtaining step, indicating that the predetermined amount is to be output as the divided amount, and the value obtained in the value obtaining step and the predetermined ratio. Of the combination of the ratio base amount output category meaning that the product is output as the divided amount and the predetermined ratio, and the full output category meaning that the value obtained in the value obtaining step is output as the divided amount a calculating step of calculating the split amount corresponding to the output category according to the output category included in any of the information based on the information or the value obtained in the value obtaining step; and main processing of the balance amount variable an update step of substituting a value obtained by subtracting the split amount calculated in the calculation step from a run-time value into the balance amount variable, wherein the rule acquisition step, the value acquisition step, the determination step, and the calculation step and the updating step is performed multiple times.

Further, a divided amount output program according to the present invention is a divided amount output program to be executed by a business support device having a control unit, wherein the control unit divides a principal amount that is a basis for division. and outputting a plurality of split amounts, wherein the split amount output step includes an initial value setting step of substituting the principal amount into a principal amount variable and a balance amount variable; a rule acquisition step of acquiring the split rule from a rule set; a value acquisition step of acquiring the value of the principal amount variable or the value of the balance amount variable at the time of execution of this process according to one of the balance amount categories that means acquiring a value; a judgment step of judging whether the value acquired in the step satisfies an amount condition included in the division rule acquired in the rule acquisition step; and a case where it is judged in the judgment step that the amount condition is satisfied. , a combination of the predetermined amount output category and the predetermined amount included in the division rule obtained in the rule obtaining step, which means that the predetermined amount is to be output as the divided amount, and the value obtained in the value obtaining step and the predetermined amount A combination of the ratio base amount output category, which means that the product of the ratio is output as the divided amount, and the predetermined ratio, and the full output category, which means that the value obtained in the value obtaining step is output as the divided amount. a calculation step of calculating the divided amount corresponding to the output classification based on the output classification included in any of the information or the value obtained in the value obtaining step; an update step of substituting a value obtained by subtracting the divided amount calculated in the calculation step from the value at the time of execution of this process into the balance amount variable, wherein the rule acquisition step, the value acquisition step, the determination step, and the It is characterized in that the calculating step and the updating step are executed multiple times.

ADVANTAGE OF THE INVENTION This invention is effective in the ability to reduce the burden required for the division|segmentation work of the amount of a bill significantly.

FIG. 1 is a diagram showing an outline of a business flow. FIG. 2 is a block diagram showing an example of the configuration of the business support device. FIG. 3 is a diagram showing an example of a supplier master. FIG. 4 is a diagram showing an example of an order request input screen. FIG. 5 is a diagram showing an example of an order confirmation processing screen. FIG. 6 is a diagram showing an example of an assessment division input screen. FIG. 7 is a diagram showing an example of an order form, an invoice, and an invoice. FIG. 8 is a diagram showing an example of a purchase input screen. FIG. 9 is a diagram showing an example of the division mechanism when there is no setting of the division method master for assessment when placing an order with a customer. FIG. 10 is a diagram showing an example of a division mechanism when the assessment division conditions are not met. FIG. 11 is a diagram showing an example of a division mechanism based on the total amount. FIG. 12 is a diagram showing an example of a division scheme based on the fixed amount and the total balance. FIG. 13 is a diagram showing an example of a division scheme based on the proportional division ratio and the total balance. FIG. 14 is a diagram showing an example of a somewhat complicated division scheme based on the proportional division ratio and the total balance. FIG. 15 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 16 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 17 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 18 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 19 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 20 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 21 is a diagram showing an example of a flowchart of processing according to the present embodiment. FIG. 22 is a diagram showing an example of order specification work and assessment division work. FIG. 23 is a diagram showing an example of an assessment division method master when placing an order with a customer. FIG. 24 is a diagram showing an example of a checked order request specification, order specification work and an order request cursor. FIG. 25 is a diagram showing an example of the first line of the order request cursor. FIG. 26 is a diagram showing an example of an assessment divided work updated based on the first line of the order request cursor. FIG. 27 is a diagram showing an example of the second line of the order request cursor. FIG. 28 is a diagram showing an example of an assessment divided work updated based on the second line of the order request cursor. FIG. 29 is a diagram showing an example of an assessment division method master when placing an order with a customer. FIG. 30 is a diagram showing an example of a checked order request specification, order specification work and an order request cursor. FIG. 31 is a diagram showing an example of the first line of the order request cursor. FIG. 32 is a diagram showing an example of an assessment dividing cursor at the time of placing an order with a supplier. FIG. 33 is a diagram showing an example of the first line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 34 is a diagram showing an example of an assessment division method master when placing an order with a customer. FIG. 35 is a diagram showing an example of a checked order request specification, order specification work and an order request cursor. FIG. 36 is a diagram showing an example of the first line of the order request cursor. FIG. 37 is a diagram showing an example of an assessment dividing cursor at the time of placing an order with a customer. FIG. 38 is a diagram showing an example of the first line of the assessment division cursor when placing an order with the customer and the assessment division work updated based on this. FIG. 39 is a diagram showing an example of an assessment division method master when placing an order with a customer. FIG. 40 is a diagram showing an example of a checked order request specification, order specification work and an order request cursor. FIG. 41 is a diagram showing an example of the first line of the order request cursor. FIG. 42 is a diagram showing an example of an assessment dividing cursor at the time of placing an order with a customer. FIG. 43 is a diagram showing an example of the first line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 44 is a diagram showing an example of the second line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 45 is a diagram showing an example of an assessment division method master when placing an order with a customer. FIG. 46 is a diagram showing an example of a checked order request specification, order specification work and an order request cursor. FIG. 47 is a diagram showing an example of the first line of the order request cursor. FIG. 48 is a diagram showing an example of an assessment dividing cursor at the time of placing an order with a supplier. FIG. 49 is a diagram showing an example of the first line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 50 is a diagram showing an example of the second line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 51 is a diagram showing an example of the third line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 52 is a diagram showing an example of an assessment division method master when placing an order with a customer. FIG. 53 is a diagram showing an example of a checked order request specification, order specification work and an order request cursor. FIG. 54 is a diagram showing an example of the first line of the order request cursor. FIG. 55 is a diagram showing an example of an assessment dividing cursor at the time of placing an order with a supplier. FIG. 56 is a diagram showing an example of the first line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 57 is a diagram showing an example of the second line of the assessment division cursor at the time of placing an order with a customer. FIG. 58 is a diagram showing an example of the third line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 59 is a diagram showing an example of the fourth line of the assessment division cursor when placing an order with the supplier and the assessment division work updated based on this. FIG. 60 is a diagram showing an example of the fifth line of the assessment division cursor at the time of placing an order with the supplier and the assessment division work updated based on this.

Embodiments of a business support device, a divided monetary amount output method, and a divided monetary amount output program according to the present invention will be described below in detail based on the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. Overview]
In the construction business, real estate business, construction business, etc., the details of payment, etc. are determined at the time of ordering. In the detached house industry, etc., as shown in Fig. 1, "Outline of work flow for detached house developer" and "Work flow for ordering", "order form, confirmation and invoice (the invoice will be sent at a later date) at the time of placing an order. It is often handed over to the contractor's construction company. At that time, there are many requests in the detached house construction industry to issue an invoice with the contents of the amount of the invoice divided. The method of payment at the time of division is often decided for each construction company that is a business partner, for example, two payments for the first payment, especially for the completion of construction, and the like. The amount of money for division is, for example, a fixed amount or an amount calculated based on a proportional division ratio.

Here, in the past, order forms and the like were often created using Excel, and the person in charge divided the amount of the invoice manually, which posed a problem of cumbersome work.

Therefore, in this embodiment, for example, by setting the division definition by the system, the initial division can be automatically performed, and the user's workload can be reduced. Further, in this embodiment, for example, the amount to be paid to the supplier can be automatically divided proportionally and printed on the bill. Specific configurations and operations will be described below.

[2. Constitution]
An example of the configuration of the business support device according to this embodiment will be described with reference to FIG. 2 and the like. FIG. 2 is a block diagram showing an example of the configuration of the business support device.

The business support device 100 is a commercially available desktop personal computer. Note that the work support device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable type such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, or a tablet personal computer. It may be an information processing device.

The business support device 100 includes a control unit 102 , a communication interface unit 104 , a storage unit 106 and an input/output interface unit 108 . Each unit included in the business support device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the business support device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the business support device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. In the following description, the output device 114 may be referred to as the monitor 114 as a display unit, and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 stores, for example, order request data 106a, an order detail work 106b, an order request cursor 106c, and an assessment split method master 106d (hereinafter simply referred to as "assessment split master 106d") as a set of split rules. ), an assessment division cursor 106e at the time of placing an order with a supplier (hereinafter sometimes simply referred to as an "assessment division cursor 106e"), an assessment division work 106f, invoice data 106g, and document data 106h. , etc., are stored.

Here, according to the business support device 100 according to the present embodiment, it is possible to divide the principal amount that is the basis of division and output a plurality of divided amounts.

The principal amount is, for example, an order amount relating to construction work of a detached house ordered by a developer to a construction company. The order amount may be, for example, either an order tax-included amount or an order tax-excluded amount.

The divided amount is, for example, the amount billed by the construction company to the developer for the construction work, and is described in the bill sent by the developer to the construction company when placing the order. The billed amount may be, for example, either the billed tax-included amount or the billed tax-excluded amount.

The order request data 106a is, for example, data including order request details for construction work. As part of the order request details are shown in FIGS. Construction project name, construction project serial number, construction number, construction classification, construction detail code, construction detail name, tax-included classification, consumption tax rate classification, quantity of construction, unit price of construction, amount of construction including tax, amount of construction excluding tax , the amount of consumption tax for construction work, the scheduled completion date of construction work, remarks on details, the code of the person in charge of transactions, the name of the person in charge of transactions, etc.

The order details work 106b is, for example, data including order confirmation details, which are details of the order confirmation processing, among the order request details. As shown in part in FIG. 22, the order confirmation details include, for example, a division code, an order request Guid, an order request specification Guid, the order number, the supplier code, the order date, the project code of the construction, the Project branch number of construction work, construction number, construction classification, construction detail code, construction detail name, tax-included classification, consumption tax rate classification, quantity of construction work, unit price of construction work, tax-included amount of construction work, It includes the tax-excluded amount of construction work, the consumption tax amount of the construction work, the scheduled completion date of the construction work, the remarks of the details, the code of the person in charge of transaction, and the like.

The order request cursor 106c, for example, has the same combination of the division code, the supplier code, the order date, the project code, the project branch number, the construction work number, and the work classification in the order confirmation details. It is data containing aggregated details that aggregate things. The aggregated details include the sum of the tax-included amount of the construction work, the tax-excluded amount of the construction work, and the consumption tax amount of the construction work included in the consolidated order confirmation details. For example, of the three confirmed order details included in the order detail work 106b in FIG. 24, the confirmed order details on the first and second lines have the same combination. Aggregated to the aggregated detail shown. As shown in the aggregated details on the first line of the order request cursor 106c in FIG. 194,400 yen (total amount including tax), which is the sum of the tax-included amount of 54,000 yen included in the above, and the tax-excluded amount of 130,000 yen included in the confirmed order details on the first line above and the confirmed order on the second line. The order tax-excluded amount (total tax-excluded amount) of 180,000 yen, which is the sum of the tax-excluded amount of 50,000 yen included in the details, and the consumption tax amount of 10,400 yen included in the confirmed order details on the first line above and the second line. The order consumption tax amount (total consumption tax amount) of 14,400 yen, which is the total amount of the consumption tax amount of 4,000 yen included in the order confirmation details. As shown in the order request cursor 106c in FIG. 24, the aggregated details include, for example, the division code, the vendor code, the order date, the project code, the project branch number, the construction number, the construction division, and the Including the order tax included amount, the order tax excluded amount, and the order consumption tax amount.

The assessment division master 106d as a division rule set is a master for defining the conditions for determining whether or not the amount can be divided, how to divide the amount, and the like. Assessment split master 106d includes multiple split rules. As shown in FIG. 3, the division rule includes, for example, the order of accrual, which is the order of acquisition of the division rule, the balance classification (corresponding to the "amount classification" of the present invention), the combination of the amount condition and the amount condition classification (this combination corresponds to the "amount condition" of the present invention), generated amount classification (corresponds to the "output classification" of the present invention), fractional amount unit and fractional division, and the like.

As the balance classification, as shown in FIG. 3, for example, "0: whole" (corresponding to the "principal amount classification" of the present invention) and "1: balance" (corresponding to the "balance amount classification" of the present invention) etc. exist. The balance category of "0: whole" is a category that means to acquire the value of the principal amount variable. The balance category of "1: balance" is a category that means to acquire the value of the balance amount variable.

The money amount condition is, for example, a division reference amount (that is, an amount that serves as a criterion for determining whether or not to divide). As the amount condition classification, as shown in part in FIG. exist. A combination of the amount condition and the amount condition category is the split condition.

Here, a method for determining whether or not the amount can be divided by referring to the balance category, the amount condition, and the amount condition category will be described in detail with reference to FIG. In the records on the first and second lines of the assessment division master 106d of FIG. 3, the balance category is "0: whole", the amount condition is "100,000", and the amount condition category is "less than 0". be. In this case, when the value of the acquired principal amount variable is less than 100,000 yen, it is determined that the acquired value of the principal amount variable may be divided. In the third row record of the assessment division master 106d in FIG. 3, the balance classification is "1: balance", the amount condition is "100,000", and the amount condition classification is "9: none". In this case, regardless of the value of the acquired balance amount variable, it is determined that the acquired value of the balance amount variable may be divided.

As the accrual amount category, as shown in part in FIG. (equivalent to fixed amount output category) and “2:%” (equivalent to “ratio standard amount output category” of the present invention). The accrued amount category of "0: full amount" is a category that means that the acquired value of the principal amount variable or the acquired value of the balance amount variable is output as the divided amount. The accrued amount category of "1: fixed amount" is a category that means that the accrued amount (corresponding to the "predetermined amount" of the present invention) is output as the divided amount. "2:%" means that the product of the acquired value of the principal amount variable or the acquired value of the balance amount variable and the proportional division ratio (corresponding to the "predetermined ratio" of the present invention) is output as the divided amount. It is a division to do.

When the accrued amount category is "1: fixed amount", the accrued amount can be set as the division rule. It should be noted that the value below the decimal point cannot be set as the generated amount. When the accrued amount category is "2:%", the proportional division rate can be set as the division rule. As the proportional division rate, values up to four decimal places are valid.

Here, the method of dividing the amount by referring to the balance category and the accrued amount category will be described in detail with reference to FIG. 3, assuming that the value of the principal amount variable is 194,400 yen. In the first row record of the assessment division master 106d of FIG. 3, the balance classification is "0: whole", the accrual amount classification is "2: %", and the proportional division rate is 30%. In this case, the divided amount is the value of the principal amount variable 194,400 yen×30/100=58,320 yen. Also, in the second row record of the assessment division master 106d in FIG. 3, the balance classification is "0: whole", the accrued amount classification is "2: %", and the proportional division rate is 40%. In this case, the divided amount is the value of the principal amount variable 194,400 yen×40/100=77,760 yen. In the third row record of the assessment division master 106d of FIG. 3, the balance classification is "1: balance", and the generated amount classification is "0: full amount". In this case, the split amount is 58,320 yen, which is the total amount of "the value of the principal amount variable of 194,400 yen - the split amount of 58,320 yen - the split amount of 77,760 yen = the value of the balance amount variable of 58,320 yen".

The amount fractional unit is an item that can be set when the accrued amount classification is "2:%", and is a unit for rounding the proportional division result. For example, if the fractional amount unit is registered as "500", the payment amount can be divided in units of 500 yen.

The fraction classification is an item that can be set when the accrual amount classification is "2:%", and is the rounding of the proportional division result. For example, "0: rounding down", "1: rounding off", and "2: rounding up" exist as the fraction division.

Assessment split master 106d may, for example, further include payment methods, not shown in FIG. A payment method code can be set as the payment method. It is not possible to set a payment method code whose system payment category in the payment method master is "99: transfer payment".

The assessment split cursor 106e is a storage destination of information included in the assessment split master 106d. Assessment split cursor 106e includes, for example, the split rule.

The assessment division work 106f is, for example, a storage destination of the division amount (or the division amount if the division is not possible) which is the result of dividing the division amount. As shown in FIG. 22, the assessment divided work 106f includes, for example, the division code, the invoice number, the order number, the supplier code, the order date, the project code, the project branch number, the construction work number, the construction work Including classification, invoice division number, invoiced tax included amount, invoiced tax excluded amount, invoiced consumption tax amount, etc. The bill division number is a key item for assigning bill numbers later, and a bill number is assigned for each bill division number.

The invoice data 106g, as shown in FIGS. 9 to 14, includes, for example, the invoice number, the invoiced tax-inclusive amount, the consumption tax amount, and the like.

The document data 106h, as shown in FIG. 7, is, for example, the document data of the purchase order, the request, and the invoice.

The control unit 102 is a CPU or the like that comprehensively controls the business support device 100 . The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 is functionally conceptually composed of an order request input unit 102a as an order request input means for accepting an input of an order request, an order confirmation processing unit 102b as an order confirmation processing means for confirming an order, A divided amount output unit 102c as divided amount output means for dividing the original principal amount and outputting a plurality of divided amounts; and a purchase input unit 102e as purchase input means for receiving input of purchase details. Details of the processing executed by each unit are described in [3. Overview of processing] and [4. processing details].

The division amount output unit 102c acquires the division rule from an initial value setting unit 102c1 as initial value setting means for substituting the principal amount into the principal amount variable and the balance amount variable, and from a division rule set including a plurality of division rules. A rule acquisition unit 102c2 as rule acquisition means, and acquisition of the principal amount classification and the value of the balance amount variable included in the division rule acquired by the rule acquisition means, which means acquiring the value of the principal amount variable. a value acquiring unit 102c3 as a value acquiring unit that acquires the value of the principal amount variable or the value of the balance amount variable at the time of execution of this process according to one of the balance amount categories that means to a judging unit 102c4 as judging means for judging whether the value acquired by the value acquiring means satisfies an amount condition included in the division rule acquired by the rule acquiring means; if it is determined that the division rule obtained by the rule obtaining means includes a predetermined amount output category meaning that a predetermined amount is to be output as the divided amount, and the combination of the predetermined amount, and the value acquisition. A combination of the ratio reference amount output category and the predetermined ratio, which means that the product of the value obtained by means and a predetermined ratio is output as the divided amount, and the value obtained by the value obtaining means is output as the divided amount. Calculation of calculating the divided amount corresponding to the output classification based on the information or the value obtained by the value obtaining means, according to the output classification included in any information of the full output classification that means a calculating unit 102c5 as means; an updating unit 102c6 as updating means for substituting a value obtained by subtracting the divided amount calculated by the calculating means from the value of the balance amount variable at the time of execution of this process into the balance amount variable; It has Details of the processing executed by each unit are described in [3. Overview of processing] and [4. processing details].

[3. Outline of processing]
In this section, an overview of the processing executed by the business support device 100 will be described with reference to the flow charts of FIGS. 15 to 21. FIG.

[3-1. Order request input processing]
First, the order request input unit 102a receives input of an order request on the order request input screen shown in FIG. As a result, order request details are created.

[3-2. Order confirmation process]
Next, on the order confirmation screen shown in FIG. 5, the created order request details are called and displayed. Then, the order confirmation processing unit 102b performs an order confirmation process for the items that are checked among the displayed order request details. The order request details for which the order has been confirmed are added to the order details work 106b as confirmed order details (S1 in FIG. 15).

[3-3. Divided amount output process]
Next, the divided amount output unit 102c divides the principal amount and outputs the plurality of divided amounts. Note that the divided amount output unit 102c displays a predetermined screen (for example, the order confirmation screen shown in FIG. 5) displayed on the monitor 114 for confirming the content of the order, as described in [3-2]. The operation may be started after the principal amount is set.

First, from the order details work 106b, in the confirmed order details having the same combination of the division code, the supplier code, the order date, the project code, the project branch number, the construction work number, and the work classification, The order tax-included amount, the order tax-excluded amount, and the order consumption tax amount are aggregated. Then, the aggregated details including the combination and the aggregated amount are stored in the order request cursor 106c (S2 in FIG. 15).

Next, it is called from the consolidated details on the first line of the order request cursor 106c (S3 in FIG. 15).

[3-3-1. Initial value setting process]
Next, the initial value setting unit 102c1 stores (substitutes) the order price and the like in the called aggregated details in variables. Specifically, the initial value setting unit 102c1 converts the order tax-included amount (corresponding to the "principal amount" of the present invention) in the called aggregated specification to the divided principal amount (corresponding to the "principal amount variable" of the present invention). , assigns the order consumption tax amount in the called aggregated details to the split source consumption tax amount, assigns the split original amount to the split balance amount (equivalent to the "balance amount variable" of the present invention), and assigns the split The original consumption tax amount is substituted for the divided remaining consumption tax amount, and "1" is set in the invoice division number (S4 in FIG. 15).

[3-3-2. Rule Acquisition Processing]
Next, the rule acquisition unit 102c2 acquires an assessment splitting condition (corresponding to a "split rule" of the present invention) from the assessment split master 106d (corresponding to a "set of splitting rules including a plurality of splitting rules" of the present invention) ( S5 in FIG. 15).

If the number of acquisitions for the assessment division condition is 0 (S6: Yes in FIG. 15), one line of information is added to the assessment division work 106f (S7 in FIG. 15). Concretely, a statement is created with the split principal amount as one invoice (S7 in FIG. 15).

As a result, the processing of the details on the first line of the order request cursor 106c is completed. Then, returning to S3 in FIG. 15, the same processing as described above is performed for the second and subsequent lines of the order request cursor 106c. S3: end of processing).

On the other hand, if the number of acquisitions of the assessment splitting condition is not 0 (S6: No in FIG. 15), the record in the assessment splitting master 106d including the acquired assessment splitting condition is stored in the assessment splitting cursor 106e (see FIG. 15). 15 S8).

Next, it is called from the first row record of the assessment division cursor 106e (S9 in FIG. 15).

When the number of acquisitions of the record of the assessment division cursor 106e is 1 (S10 in FIG. 15: number of acquisitions = 1), the division remaining amount of S4 is substituted for the division amount, and the division remaining consumption tax amount of S4 is substituted for the division consumption tax amount. is substituted, 0 is substituted for the remaining divided amount, and 0 is substituted for the division pattern flag (S11 in FIG. 15). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, if the division pattern flag is other than -1, one line of invoice details is added to the assessment division work 106f (S12 in FIG. 16). That is, the appraisal divided work 106f is created with the divided amount in S11 as one claim (S12 in FIG. 16). Then, return to FIG.

[3-3-3. Value Acquisition Processing and Judgment Processing]
On the other hand, returning to S10 of FIG. 15, if the acquired number of records of the assessment split cursor 106e is greater than 1 (S10 of FIG. 15: acquired number > 1), the balance classification in the first row record of the assessment split cursor 106e is "0: Whole" (S13 in FIG. 15). If the balance classification is 0 (S13: Yes in FIG. 15), proceed to FIG. 17A. If the balance classification is not 0 (S13 in FIG. 15: No), proceed to FIG. move on.

[3-3-3A. If the balance category is 0]
Proceeding to FIG. 17A, it is checked whether or not the amount condition classification in the record on the first line of the assessment division cursor 106e is "less than 0" (S14 in FIG. 17).

If the amount condition category is 0 (S14: Yes in FIG. 17), whether or not the condition "the amount of the original split described in S4<the amount condition in the first row record of the assessment split cursor 106e" is satisfied is checked as follows (S15 in FIG. 17). First, the value acquiring unit 102c3 acquires the amount of balance category 0 (corresponding to the “principal amount category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value of the split principal amount explained in S4 (corresponding to the "principal amount variable value" of the present invention) is obtained. Then, the determination unit 102c4 determines that the value of the split principal amount acquired by the value acquisition unit 102c3 (corresponding to the "said value" of the present invention) is the assessed split condition (the "split rule" of the present invention) acquired by the rule acquisition unit 102c2. ”) and the combination of the money condition category (corresponding to the “money condition” of the present invention) is satisfied.

If the determining unit 102c4 determines that the condition is satisfied (S15 in FIG. 17: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S16 in FIG. 17). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 21(A).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S15 in FIG. 17: No), the process proceeds to FIG. 16(A).

Returning to S14 of FIG. 17, if the amount condition classification is not 0 (S14 of FIG. 17: No), whether or not the amount condition classification in the first row record of the assessment division cursor 106e is "1: or less" is checked (S17 in FIG. 17).

If the amount condition category is 1 (S17 in FIG. 17: Yes), whether or not the condition of "said split principal amount explained in S4≦amount condition in the first row record of the assessment split cursor 106e" is satisfied is checked as follows (S18 in FIG. 17). First, the value acquiring unit 102c3 acquires the amount of balance category 0 (corresponding to the “principal amount category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value of the split principal amount explained in S4 (corresponding to the "principal amount variable value" of the present invention) is obtained. Then, the determination unit 102c4 determines that the value of the split principal amount acquired by the value acquisition unit 102c3 (corresponding to the "said value" of the present invention) is the assessed split condition (the "split rule" of the present invention) acquired by the rule acquisition unit 102c2. ”) and the combination of the money condition category (corresponding to the “money condition” of the present invention) is satisfied.

If the determining unit 102c4 determines that the conditions are satisfied (S18 in FIG. 17: Yes), the split pattern flag is determined as follows according to the accrual amount category in the record on the first line of the assessment split cursor 106e. (S19 in FIG. 17). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 21(A).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S18 in FIG. 17: No), the process proceeds to FIG. 16(A).

Returning to S17 of FIG. 17, if the amount condition classification is not 1 (S17 of FIG. 17: No), whether or not the amount condition classification in the first row record of the assessment division cursor 106e is "2: or more" is checked (S20 in FIG. 17).

If the amount condition category is 2 (S20: Yes in FIG. 17), whether or not the condition "said divided principal amount explained in S4≧amount condition in the first row record of the assessment division cursor 106e" is satisfied is checked as follows (S21 in FIG. 17). First, the value acquiring unit 102c3 acquires the amount of balance category 0 (corresponding to the “principal amount category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value of the split principal amount explained in S4 (corresponding to the "principal amount variable value" of the present invention) is obtained. Then, the determination unit 102c4 determines that the value of the split principal amount acquired by the value acquisition unit 102c3 (corresponding to the "said value" of the present invention) is the assessed split condition (the "split rule" of the present invention) acquired by the rule acquisition unit 102c2. ”) and the combination of the money condition category (corresponding to the “money condition” of the present invention) is satisfied.

If the determining unit 102c4 determines that the condition is satisfied (S21 in FIG. 17: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S22 in FIG. 17). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 21(A).

On the other hand, if the determination unit 102c4 determines that the condition is not satisfied (S21 in FIG. 17: No), the process proceeds to FIG. 16A.

Returning to S20 of FIG. 17, if the amount condition category is not 2 (S20 of FIG. 17: No), proceed to FIG. 18(A).

Proceeding to FIG. 18A, it is checked whether or not the amount condition classification in the record on the first line of the assessment division cursor 106e is "3: over" (S23 in FIG. 18).

If the amount condition category is 3 (S23: Yes in FIG. 18), whether or not the condition "the amount of the split principal described in S4>the amount condition in the first row record of the assessment split cursor 106e" is satisfied is checked as follows (S24 in FIG. 18). First, the value acquiring unit 102c3 acquires the amount of balance category 0 (corresponding to the “principal amount category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value of the split principal amount explained in S4 (corresponding to the "principal amount variable value" of the present invention) is obtained. Then, the determination unit 102c4 determines that the value of the split principal amount acquired by the value acquisition unit 102c3 (corresponding to the "said value" of the present invention) is the assessed split condition (the "split rule" of the present invention) acquired by the rule acquisition unit 102c2. ”) and the combination of the money condition category (corresponding to the “money condition” of the present invention) is satisfied.

If the determination unit 102c4 determines that the conditions are satisfied (S24 in FIG. 18: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S25 in FIG. 18). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 17(B).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S24 in FIG. 18: No), the process proceeds to FIG. 17(C).

Returning to S23 of FIG. 18, if the amount condition classification is not 3 (S23 of FIG. 18: No), whether or not the amount condition classification in the first row record of the assessment division cursor 106e is "9: none". is checked (S26 in FIG. 18).

If the amount condition class is 9 (S26 in FIG. 18: Yes), the split pattern flag is determined as follows according to the accrued amount class in the record on the first line of the assessment split cursor 106e (see FIG. 18). S27). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 17(D).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S26 in FIG. 18: No), the process proceeds to FIG. 17(E).

[3-3-3B. If the balance category is not 0]
Returning to S13 of FIG. 15, if the balance category is not 0 (S13 of FIG. 15: No), proceed to FIG. 19(A).

Proceeding to FIG. 19A, it is checked whether or not the amount condition classification in the record on the first line of the assessment division cursor 106e is "less than 0" (S28 in FIG. 19).

If the amount condition category is 0 (S28: Yes in FIG. 19), it is determined whether or not the condition "divided balance amount explained in S4<amount condition in the first row record of the assessment division cursor 106e" is satisfied. , are checked as follows (S29 in FIG. 19). First, the value acquiring unit 102c3 acquires the amount of the balance category 1 (corresponding to the “balance category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value (corresponding to the "value of the balance amount variable at the time of execution of this process" of the present invention) obtained when executing the process for obtaining the value of the divided balance amount described in S4 is obtained. Then, the determination unit 102c4 determines that the value of the divided balance amount obtained by the value obtaining unit 102c3 at the time of execution of the value obtaining process (corresponding to the "value" of the present invention) is the assessment division condition ( It is determined whether the combination of the money amount condition and the money amount condition category (corresponding to the "money amount condition" of the present invention) included in the "division rule" of the present invention is satisfied.

If the determining unit 102c4 determines that the condition is satisfied (S29 in FIG. 19: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S30 in FIG. 19). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 21(A).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S29 in FIG. 19: No), the process proceeds to FIG. 16A.

Returning to S28 of FIG. 19, if the amount condition classification is not 0 (S28 of FIG. 19: No), it is checked whether or not the amount condition classification in the record of the assessment division cursor 106e is "1: or less". (S31 in FIG. 19).

If the amount condition category is 1 (S31: Yes in FIG. 19), whether or not the condition "the divided balance amount explained in S4≦the amount condition in the first row record of the assessment division cursor 106e" is satisfied is checked as follows (S32 in FIG. 19). First, the value acquiring unit 102c3 acquires the amount of the balance category 1 (corresponding to the “balance category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value (corresponding to the "value of the balance amount variable at the time of execution of this process" of the present invention) obtained when executing the process for obtaining the value of the divided balance amount described in S4 is obtained. Then, the determination unit 102c4 determines that the value of the divided balance amount obtained by the value obtaining unit 102c3 at the time of execution of the value obtaining process (corresponding to the "value" of the present invention) is the assessment division condition ( It is determined whether the combination of the money amount condition and the money amount condition category (corresponding to the "money amount condition" of the present invention) included in the "division rule" of the present invention is satisfied.

If the determining unit 102c4 determines that the condition is satisfied (S32 in FIG. 19: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S33 in FIG. 19). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 21(A).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S32 in FIG. 19: No), the process proceeds to FIG. 16A.

Returning to S31 of FIG. 19, if the amount condition classification is not 1 (S31 of FIG. 19: No), it is checked (S34 in FIG. 19).

If the amount condition category is 2 (S34: Yes in FIG. 19), the following is determined whether the condition "the divided balance amount described in S4≧the amount condition in the record of the assessment division cursor 106e" is satisfied. It is checked in this way (S35 in FIG. 19). First, the value acquiring unit 102c3 acquires the amount of the balance category 1 (corresponding to the “balance category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value (corresponding to the "value of the balance amount variable at the time of execution of this process" of the present invention) obtained when executing the process for obtaining the value of the divided balance amount described in S4 is obtained. Then, the determination unit 102c4 determines that the value of the divided balance amount obtained by the value obtaining unit 102c3 at the time of execution of the value obtaining process (corresponding to the "value" of the present invention) is the assessment division condition ( It is determined whether the combination of the money amount condition and the money amount condition category (corresponding to the "money amount condition" of the present invention) included in the "division rule" of the present invention is satisfied.

If the determining unit 102c4 determines that the conditions are satisfied (S35 in FIG. 19: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S36 in FIG. 19). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 21(A).

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S35 in FIG. 19: No), the process proceeds to FIG. 16(A).

Returning to S34 of FIG. 19, if the amount condition category is not 2 (S34 of FIG. 19: No), proceed to FIG. 20(A).

Proceeding to FIG. 20A, it is checked whether or not the amount condition classification in the record on the first line of the assessment division cursor 106e is "3: over" (S37 in FIG. 20).

If the amount condition category is 3 (S37: Yes in FIG. 20), whether or not the condition "the divided balance explained in S4>the amount condition in the first row record of the assessment division cursor 106e" is satisfied is checked as follows (S38 in FIG. 20). First, the value acquiring unit 102c3 acquires the amount of the balance category 1 (corresponding to the “balance category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. According to the classification, the value (corresponding to the "value of the balance amount variable at the time of execution of this process" of the present invention) obtained when executing the process for obtaining the value of the divided balance amount described in S4 is obtained. Then, the determination unit 102c4 determines that the value of the divided balance amount obtained by the value obtaining unit 102c3 at the time of execution of the value obtaining process (corresponding to the "value" of the present invention) is the assessment division condition ( It is determined whether the combination of the money amount condition and the money amount condition category (corresponding to the "money amount condition" of the present invention) included in the "division rule" of the present invention is satisfied.

If the determination unit 102c4 determines that the conditions are satisfied (S38 in FIG. 20: Yes), the split pattern flag is determined as follows according to the accrued amount category in the record on the first line of the assessment split cursor 106e. (S39 in FIG. 20). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 19B.

On the other hand, if the determining unit 102c4 determines that the condition is not satisfied (S38 in FIG. 20: No), the process proceeds to FIG. 19(C).

Returning to S37 of FIG. 20, if the amount condition class is not 3 (S37 of FIG. 20: No), it is checked whether or not the amount condition class in the record of the assessment division cursor 106e is "9: None". (S40 in FIG. 20).

If the amount condition class is 9 (S40 in FIG. 20: Yes), the split pattern flag is determined as follows according to the accrued amount class in the record on the first line of the assessment split cursor 106e (see FIG. 20 S41). That is, when the accrual amount category is 0, the split pattern flag is 1, when the accrual amount category is 1, the split pattern flag is 2, and when the accrual amount category is 2, the split pattern flag is 3. . Then, the process proceeds to FIG. 19(D).

On the other hand, if the amount condition class is not 9 (S40 in FIG. 20: No), the process proceeds to FIG. 19(E).

[3-3-4. Calculation processing and update processing]
Proceeding to FIG. 21A, it is checked whether the division pattern flag is 1 (S42 in FIG. 21).

[3-3-4A. When the split pattern flag is 1 (the accrued amount category is 0)]
When the division pattern flag is 1 (S42 in FIG. 21: Yes), values are set (substituted) in the division amount and the division remaining amount as follows. First, the calculation unit 102c5 acquires the accrued amount category 0 (corresponding to the “full amount output category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquisition unit 102c2. According to the output classification included in the information, the divided amount corresponding to the output classification is calculated based on the information or the value obtained by the value obtaining unit 102c3. Specifically, the calculation unit 102c5 substitutes the value of the divided balance amount into the divided amount (S43 in FIG. 21). Next, the updating unit 102c6 subtracts the divided amount calculated by the calculating unit 102c5 from the value of the divided balance amount (corresponding to the "balance amount variable" of the present invention) at the time of execution of the update process, (corresponding to the "remaining amount variable" of the present invention), the divided remaining amount is updated. Specifically, the split balance amount is updated by substituting the value obtained by subtracting the split amount calculated by the calculation unit 102c5 from the split balance amount (S43 in FIG. 21). .

On the other hand, if the division pattern flag is not 1 (S42 in FIG. 21: No), it is checked whether the division pattern flag is 2 (S44 in FIG. 21).

[3-3-4B. When the split pattern flag is 2 (the accrued amount category is 1)]
If the split pattern flag is 2 (S44: Yes in FIG. 21), whether or not the condition "the split balance amount explained in S4≧the accrued amount in the first row record of the assessment split cursor 106e" is satisfied is checked (S45 in FIG. 21).

If the above conditions are satisfied (S45 in FIG. 21: Yes), values are set (assigned) to the divided amount and the remaining divided amount as follows. First, the calculating unit 102c5 obtains the accrued amount category 1 (corresponding to the “predetermined amount output category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. and the accrued amount of money (equivalent to the "predetermined amount" of the present invention), according to the output classification included in the combination information, the divided amount corresponding to the output classification is determined based on the information or the value obtained by the value obtaining unit 102c3. Calculate to Specifically, the calculation unit 102c5 substitutes the accrued amount in the record on the first line of the assessment division cursor 106e into the division amount (S46 in FIG. 21). Next, the updating unit 102c6 subtracts the divided amount calculated by the calculating unit 102c5 from the value of the divided balance amount (corresponding to the "balance amount variable" of the present invention) at the time of execution of the update process, (corresponding to the "remaining amount variable" of the present invention), the divided remaining amount is updated. Specifically, the split balance amount is updated by substituting a value obtained by subtracting the split amount calculated by the calculation unit 102c5 from the split balance amount (S48 in FIG. 21). Then, the process proceeds to FIG. 16(A).

On the other hand, if the above condition is not satisfied (S45 in FIG. 21: No), values are set (assigned) to the divided amount and the remaining divided amount as follows. First, the calculating unit 102c5 obtains the accrued amount category 1 (corresponding to the “predetermined amount output category” of the present invention) included in the assessment split condition (corresponding to the “split rule” of the present invention) acquired by the rule acquiring unit 102c2. and the accrued amount of money (equivalent to the "predetermined amount" of the present invention), according to the output classification included in the combination information, the divided amount corresponding to the output classification is determined based on the information or the value obtained by the value obtaining unit 102c3. Calculate to Specifically, the calculation unit 102c5 substitutes a value obtained by subtracting the split amount from the value of the split balance amount for the split amount (S47 in FIG. 21). Next, the updating unit 102c6 subtracts the divided amount calculated by the calculating unit 102c5 from the value of the divided balance amount (corresponding to the "balance amount variable" of the present invention) at the time of execution of the update process, (corresponding to the "remaining amount variable" of the present invention), the divided remaining amount is updated. Specifically, the split balance amount is updated by substituting the value obtained by subtracting the split amount calculated by the calculation unit 102c5 from the split balance amount (S48 in FIG. 21). . Then, the process proceeds to FIG. 16(A).

[3-3-4C. When the split pattern flag is 3 (the accrued amount category is 2)]
Returning to S44 of FIG. 21, if the division pattern flag is not 2 (S44 of FIG. 21: No), it is checked whether the division pattern flag is 3 (S49 of FIG. 21).

If the split pattern flag is 3 (S49 of FIG. 21: Yes), it is checked whether the balance classification in the record on the first line of the assessment split cursor 106e is "0: whole" (see FIG. 21). S50).

When the balance classification is 0 (S50 in FIG. 21: Yes), a value is set (assigned) to the judgment amount as follows. That is, the calculation unit 102c5 substitutes the split principal amount described in S4×(the accrued amount in the first row record of the assessment split cursor 106e/100) into the judgment amount (S51 in FIG. 21).

On the other hand, if the balance classification is not 0 (S50 in FIG. 21: No), a value is set (assigned) to the judgment amount as follows. That is, the calculation unit 102c5 substitutes the value of the divided balance amount described in S4×(the accrued amount in the first row record of the assessment division cursor 106e/100) into the judgment amount (S52 in FIG. 21).

Next, it is checked whether the fraction is 0 (S53 in FIG. 21). Incidentally, when the fractional amount unit in the record of the assessment division cursor 106e is 0, the fractional number is 1. On the other hand, in other cases (when the monetary amount fractional unit in the record of the assessment division cursor 106e is not 0), the fraction becomes the monetary amount fractional unit.

When the fraction is 0 (S53 in FIG. 21: Yes), the calculation unit 102c5 sets (substitutes) 1 for the judgment multiple (S54 in FIG. 21).

On the other hand, if the fraction is not 0 (S53 in FIG. 21: No), a value is set (assigned) as follows. That is, the calculation unit 102c5 substitutes the value of FLOOR ((said judgment amount/said fraction) x 10)/10 for the judgment multiple, and furthermore, substitutes the judgment multiple for the judgment multiple according to the fraction classification in the record of the assessment division cursor 106e. By processing, the judgment multiple is calculated (S55 in FIG. 21).

Next, the calculation result is set (assigned) to the split amount as follows. That is, the calculation unit 102c5 obtains the accrued amount category 2 (corresponding to the "ratio reference amount output category" of the present invention) included in the assessment split condition (corresponding to the "split rule" of the present invention) ) and the proportional division ratio (corresponding to the “predetermined ratio” of the present invention), the divided amount corresponding to the output classification is obtained by the information or the value obtained by the value obtaining unit 102c3 calculated based on Specifically, the calculation unit 102c5 substitutes the calculation result of the fraction×the determination multiple into the divided amount (S56 in FIG. 21).

Next, it is checked whether or not the condition "the split amount described in S4<the split amount described in S56" is satisfied (S57 in FIG. 21). It should be noted that this check is to check whether or not an illegal setting such as an apportionment rate registered in the assessment division master 106d exceeding 100% has been made.

If the above condition is satisfied and an illegal setting is made (S57 in FIG. 21: Yes), the calculation result is set (assigned) to the split amount in the following manner. That is, the calculation unit 102c5 substitutes the calculation result of the fraction×(the determination multiple−1) into the divided amount (S58 in FIG. 21).

If the condition is not satisfied and no illegal setting is made (S57 of FIG. 21: No), or after completion of S58 of FIG. is checked (S59 in FIG. 21). It should be noted that this check is to check whether or not an illegal setting such as an apportionment rate registered in the assessment division master 106d exceeding 100% has been made.

If the above condition is satisfied and an illegal setting is made (S59 in FIG. 21: Yes), the calculation result is set (assigned) to the split amount in the following manner. That is, the calculation unit 102c5 substitutes the divided balance amount into the divided amount (S60 in FIG. 21).

If the condition is not satisfied and the illegal setting is not made (S59 of FIG. 21: No), or after completion of S60 of FIG. The calculation result is set (assigned) to the remaining consumption tax amount. That is, the update unit 102c6 subtracts the divided balance amount calculated by the calculation unit 102c5 from the value of the divided balance amount (corresponding to the "balance amount variable" of the present invention) at the time of execution of the update process, and subtracts the divided balance amount ( (corresponding to the "remaining amount variable" of the present invention) to update the divided remaining amount. Specifically, the calculation unit 102c5 updates the split balance amount by substituting the calculation result of subtracting the split amount from the split balance amount for the split balance amount (S61 in FIG. 21). Further, the update unit 102c6 substitutes the calculation result of the split source consumption tax amount x (the split amount/the split source amount) for the split consumption tax amount, and subtracts the split consumption tax amount from the remaining split consumption tax amount. By substituting the result into the divided remaining consumption tax amount, the divided consumption tax amount and the divided remaining consumption tax amount are updated (S61 in FIG. 21). Then, the process proceeds to FIG. 16(A).

[3-3-5. End of divided amount output processing]
Proceeding to FIG. 16A, if the division pattern flag is other than -1, one line of invoice details is added to the assessment division work 106f (S12 in FIG. 16). That is, the appraisal divided work 106f is created with the divided amount in S11 as one claim (S12 in FIG. 16). Then, return to FIG.

Returning to FIG. 15A, the same processing as described above is performed for the records on the second and subsequent rows of the assessment division cursor 106e, and when all records have been called, the processing of the assessment division cursor 106e is terminated. (S9 in FIG. 15: end of processing, start processing of the next statement). Then, the process returns to S3 in FIG.

Returning to S3 in FIG. 15, the same processing as described above is performed for the second and subsequent lines of the order request cursor 106c. :Processing Exit).

As described above, the split amount output unit 102c operates the rule acquisition unit 102c2, the value acquisition unit 102c3, the determination unit 102c4, the calculation unit 102c5, and the update unit 102c6 a plurality of times, thereby outputting a plurality of split amounts. can be done. The split amount output process can be performed through the assessment split input screen shown in FIG.

Then, the assessment divided work 106f that includes the plurality of divided amounts as billing tax-included amounts is updated, and billing data 106g is created based on the updated assessment divided work 106f.

[3-4. Document data creation process]
Next, the document data creation unit 102d creates document data of the purchase order, the confirmation, and the invoice. An example of the document data is shown in FIG. As for the document data of the invoice, only the division of assessment can be created. Further, the document data of the invoice includes the divided amount calculated by the calculation unit 102c5 in [3-3] as the billed amount, as shown in (1) to (3) of FIG.

[3-5. Purchase input processing]
At the time of inputting the purchase, the billing data 106g created in [3-3] is called up from the purchase input screen shown in FIG. The purchase input unit 102e receives input of the purchase details.

[4. Processing details]
In this section, the details of the processing executed by the business support device 100 will be described.

[4-1. When the assessment division master 106d is not set]
If there is no setting in the appraisal split master 106d, a full invoice will be created for one item. As an overview, if the appraisal division master 106d is not set, as shown in FIG. 9, the billing data 106g including the billing details with the total billing amount including the billing amount of 194,400 yen including the total purchase amount including tax is created. . Detailed processing is described below.

First, the order request input unit 102a receives input of an order request. Next, the order confirmation processing unit 102b performs order confirmation processing for the three checked details of the order request details shown in (screen items) in FIG. As a result, the three details are added to the order details work 106b as the confirmed order details, and the order details work 106b is updated (S1 in FIG. 15). The updated order details work 106b is shown in FIG.

Next, from the updated order detail work 106b, 1 to 2 with the same combination of the division code, supplier code, order date, project code, project branch number, construction number and construction division The confirmed order details of the row are aggregated and stored in the first row of the order request cursor 106c in FIG. 24 (S2 in FIG. 15). Also, since there is no other confirmed order details with the same combination, the confirmed order details on the third line in the updated order details work 106b are stored in the second line of the order request cursor 106c in FIG. (S2 in FIG. 15).

Next, as shown in FIG. 25, the consolidated details on the first line of the order request cursor 106c are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 194,400 yen in the summed up details on the first line that has been called up for the divided principal amount, and the order consumption tax amount of 14,400 yen in the summed up details on the first line that has been called up. to the split amount of consumption tax, assign the above split amount of 194,400 yen to the split remaining amount, assign the above split amount of 14,400 yen to the split remaining consumption tax amount, and set "1" to the invoice split number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-1], as shown in FIG. 23, the content of the assessment split master 106d for the supplier code 0000000001 is not set, so the rule acquisition unit 102c2 sets the assessment split condition. cannot be obtained. That is, the number of acquisitions of the assessment division condition is 0 (S6: Yes in FIG. 15).

In this case, as shown in FIG. 26, the appraisal division work 106f including billing details is updated with the division principal amount of 194,400 yen as one bill (that is, the division principal amount is not divided) (FIG. 15). S7). Based on the assessment division work 106f shown in FIG. 26, billing data 106g shown in FIG. 9 is created.

Subsequently, returning to S3 of FIG. 15, similar processing is performed for the aggregated details on the second line of the order request cursor 106c shown in FIG.

That is, first, as shown in FIG. 27, the consolidated details on the second line of the order request cursor 106c are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 200,000 yen in the summed up details on the second line, into the division principal amount, and the order consumption tax amount of 0 yen in the summed up details on the second line. to the split amount of consumption tax, assign the above split amount of 200,000 yen to the split remaining amount, assign the above split amount of 0 yen to the split remaining consumption tax amount, and set "1" to the invoice division number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-1], as shown in FIG. 23, the content of the assessment split master 106d for the supplier code 0000000002 is not set, so the rule acquisition unit 102c2 sets the assessment split condition. cannot be obtained. That is, the number of acquisitions of the assessment division condition is 0 (S6: Yes in FIG. 15).

In this case, as shown in FIG. 28, the appraisal division work 106f including the billing statement with the division principal amount of 200,000 yen as one bill is updated (S7 in FIG. 15).

As a result of the above processing, there is no remaining data in the order request cursor 106c (since all the details in the order request cursor 106c have been called), and the processing ends (S3 in FIG. 15: end of processing).

[4-2. If the assessment split conditions are not met]
If the assessment split conditions are not met, a full invoice will be created. As an overview, if the assessment division condition is not met, as shown in FIG. 10, the billing data 106g including the billing details of the total amount including the order tax of 194,400 yen including the billing tax is created. Detailed processing is described below.

First, the order request input unit 102a receives input of an order request. Next, the order confirmation processing unit 102b performs order confirmation processing for the two checked details of the order request details shown in (screen item) in FIG. As a result, the two details are added to the order details work 106b as order confirmation details, and the order details work 106b is updated (S1 in FIG. 15). The updated order details work 106b is shown in FIG.

Next, from the updated order detail work 106b, 1 to 2 with the same combination of the division code, supplier code, order date, project code, project branch number, construction number and construction division The confirmed order details of the row are aggregated and stored in the first row of the order request cursor 106c in FIG. 30 (S2 in FIG. 15).

Next, as shown in FIG. 31, the consolidated details on the first line of the order request cursor 106c are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 194,400 yen in the summed up details on the first line that has been called up for the divided principal amount, and the order consumption tax amount of 14,400 yen in the summed up details on the first line that has been called up. to the split amount of consumption tax, assign the above split amount of 194,400 yen to the split remaining amount, assign the above split amount of 14,400 yen to the split remaining consumption tax amount, and set "1" to the invoice split number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-2], as shown in FIG. 29, one assessment split condition is set in the assessment split master 106d, so the rule acquisition unit 102c2 acquires the assessment split condition. be able to. That is, the number of acquisitions of the assessment division condition is not 0 (S6 in FIG. 15: No).

In this case, as shown in FIG. 32, the record in the assessment split master 106d of FIG. 29 is stored in the assessment split cursor 106e (S8 of FIG. 15).

Next, as shown in FIG. 33, it is called from the first row record of the assessment division cursor 106e (S9 in FIG. 15). Also, in this example, as shown in FIG. 32, the number of acquired records of the assessment division cursor 106e is 1 (S10 in FIG. 15: number of acquired records=1).

Here, as shown in FIG. 33, the balance classification in the record on the first line of the assessment division cursor 106e is "0: Whole". is obtained.

On the other hand, the amount condition and the amount condition category included in the assessment division condition acquired by the rule acquisition unit 102c2 are "100,000 yen" and "less than 0", respectively, as shown in FIG.

In this case, it is determined that the above-mentioned split principal amount of 194,400 yen does not satisfy the condition "less than 100,000 yen" acquired by the rule acquisition unit 102c2.

If it is determined that the above conditions are not satisfied, the remaining split amount of 194,400 yen in S4 is substituted as the split amount, and the remaining split consumption tax amount of 14,400 yen in S4 is substituted as the split consumption tax amount. 0 is substituted for the amount, and 0 is substituted for the division pattern flag (S11 in FIG. 15). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16(A), as shown in FIG. 33, the appraisal division work 106f including the billing statement with the division amount 194,400 of S11 as one bill is updated (S12 of FIG. 16). 10 is created based on the assessment divided work 106f shown in FIG. Then, return to FIG.

As a result of the above processing, there is no remaining detail in the assessment split cursor 106e (because all records in the assessment split cursor 106e have been called), so the process of the assessment split cursor 106e is exited (S9 in FIG. 15: End of processing Next detail process). Then, since there are no remaining details in the order request cursor 106c (since all the details in the order request cursor 106c have been called up), the processing of the order request cursor 106c is exited, and all processing ends (S3 in FIG. 15: end of processing). ).

[4-3. When dividing based on the total amount]
As an overview of the division based on the total amount, as shown in FIG. 11, billing data 106g including billing details with billing amount including billing amount of 194,400 yen, which is the total amount of 194,400 yen including ordering tax, is created. be. Detailed processing is described below.

First, the order request input unit 102a receives input of an order request. Next, the order confirmation processing unit 102b performs an order confirmation process for the two checked details of the order request details shown in (screen item) in FIG. As a result, the two details are added to the order details work 106b as order confirmation details, and the order details work 106b is updated (S1 in FIG. 15). The updated order details work 106b is shown in FIG.

Next, from the updated order detail work 106b, 1 to 2 with the same combination of the division code, supplier code, order date, project code, project branch number, construction number and construction division The confirmed order details of the row are aggregated and stored in the first row of the order request cursor 106c in FIG. 35 (S2 in FIG. 15).

Next, as shown in FIG. 36, the consolidated details on the first line of the order request cursor 106c are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 194,400 yen in the summed up details on the first line that has been called up for the divided principal amount, and the order consumption tax amount of 14,400 yen in the summed up details on the first line that has been called up. to the split amount of consumption tax, assign the above split amount of 194,400 yen to the split remaining amount, assign the above split amount of 14,400 yen to the split remaining consumption tax amount, and set "1" to the invoice split number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-3], as shown in FIG. 34, one assessment split condition is set in the assessment split master 106d, so the rule acquisition unit 102c2 acquires the assessment split condition. be able to. That is, the number of acquisitions of the assessment division condition is not 0 (S6 in FIG. 15: No).

In this case, as shown in FIG. 37, the record in the assessment split master 106d of FIG. 34 is stored in the assessment split cursor 106e (S8 of FIG. 15).

Next, as shown in FIG. 38, it is called from the first row record of the assessment division cursor 106e (S9 in FIG. 15). Also, in this example, as shown in FIG. 37, the number of acquired records of the assessment division cursor 106e is 1 (S10 in FIG. 15: number of acquired records=1).

Here, as shown in FIG. 38, the balance classification in the record on the first line of the assessment division cursor 106e is "0: Whole". is obtained.

Here, the amount condition and the amount condition category included in the assessment division condition acquired by the rule acquisition unit 102c2 are "200,000 yen" and "less than 0", respectively, as shown in FIG.

On the other hand, the amount condition and the amount condition category included in the assessment division condition acquired by the rule acquisition unit 102c2 are "200,000 yen" and "less than 0", respectively, as shown in FIG.

In this case, it is determined that the split principal amount of 194,400 yen satisfies the condition "less than 200,000 yen" acquired by the rule acquisition unit 102c2.

If it is determined that the above condition is satisfied, the obtained split principal amount of 194,400 yen is determined according to the accrued amount classification "0: full amount" included in the record on the first line of the assessment split cursor 106e of FIG. The total amount is substituted for the split amount (S11 in FIG. 15). In addition, since the 194,400 yen is the same value as the 194,400 yen divided balance amount in S4, it can be said that the 194,400 yen divided balance amount in S4 is substituted for the divided amount. Also, the divided remaining consumption tax amount of 14,400 yen of S4 is substituted for the divided consumption tax amount, 0 is substituted for the divided remaining amount, and 0 is substituted for the division pattern flag (S11 in FIG. 15). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 38, the appraisal divided work 106f with the above-mentioned divided amount of 194,400 yen in S11 as the billing amount including tax is updated (S12 in FIG. 16). 11 is created based on the assessment divided work 106f shown in FIG. Then, return to FIG.

As a result of the above processing, there is no remaining detail in the assessment split cursor 106e (because all records in the assessment split cursor 106e have been called), so the process of the assessment split cursor 106e is exited (S9 in FIG. 15: End of processing Next detail process). Then, since there are no remaining details in the order request cursor 106c (since all the details in the order request cursor 106c have been called up), the processing of the order request cursor 106c is exited, and all processing ends (S3 in FIG. 15: end of processing). ).

[4-4. When splitting based on the fixed amount and the total balance]
As an overview of splitting based on the fixed amount and the total balance, as shown in Fig. 12, the billing statement with the fixed amount of 100,000 yen as the billing amount including tax and the billing amount from 194,400 yen including the order tax included amount Billing data 106g including a billing statement with the total billing amount of 944,00 yen including the billing amount of 944,00 yen after deducting the tax-included amount of 100,000 yen is created. Detailed processing is described below.

First, the order request input unit 102a receives input of an order request. Next, the order confirmation processing unit 102b performs order confirmation processing for the two checked details of the order request details shown in (screen item) in FIG. As a result, the two details are added to the order details work 106b as order confirmation details, and the order details work 106b is updated (S1 in FIG. 15). The updated order details work 106b is shown in FIG.

Next, from the updated order detail work 106b, 1 to 2 with the same combination of the division code, supplier code, order date, project code, project branch number, construction number and construction division The confirmed order details of the row are aggregated and stored in the first row of the order request cursor 106c in FIG. 40 (S2 in FIG. 15).

Next, as shown in FIG. 41, the consolidated details on the first line of the order request cursor are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 194,400 yen in the summed up details on the first line that has been called up for the divided principal amount, and the order consumption tax amount of 14,400 yen in the summed up details on the first line that has been called up. to the split amount of consumption tax, assign the above split amount of 194,400 yen to the split remaining amount, assign the above split amount of 14,400 yen to the split remaining consumption tax amount, and set "1" to the invoice split number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-4], two assessment split conditions are set in the assessment split master 106d as shown in FIG. be able to. That is, the number of acquisitions of the assessment division condition is not 0 (S6 in FIG. 15: No).

In this case, as shown in FIG. 42, the record in the assessment split master 106d of FIG. 39 is stored in the assessment split cursor 106e (S8 of FIG. 15).

[4-4-1. Processing for the record on the first row of the assessment division cursor 106e]
Next, as shown in FIG. 43, it is called from the first row record of the assessment division cursor 106e (S9 in FIG. 15). Then, the process described below is performed on the called record of the first row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Further, in this example, the balance category in the record of the first row is "0: whole" (S13: YES in FIG. 15). In this example, the amount condition classification in the record of the first row is neither "0: less than" (S14: No in FIG. 17) nor "1: less than or equal to" (S17: No in FIG. 17). ), and "2: greater than or equal to" (S20 of FIG. 17: YES).

In this case, it is checked as follows whether or not the condition "said split principal amount described in S4≧amount condition in the record on the first line of the assessment split cursor 106e" is satisfied (S21 in FIG. 17). ). First, the value acquisition unit 102c3 acquires the split principal amount of 194,400 yen described in S4 according to the amount category of the balance category 0 included in the assessment split condition acquired by the rule acquisition unit 102c2. Then, the determination unit 102c4 determines that the split principal amount of 194,400 yen acquired by the value acquisition unit 102c3 is the combination of the amount condition and the amount condition category included in the assessment split condition acquired by the rule acquisition unit 102c2, which is "100,000 yen or more." ” is satisfied.

Since the split principal amount of 194,400 yen is 100,000 yen or more (S21 of FIG. 17: Yes), the process proceeds to S22 of FIG. In this example, the division pattern flag is set to 2 according to the accrued amount category 1 in the record of the first row (S22 in FIG. 17). Then, the process proceeds to FIG. 21(A).

In this example, as described in the previous paragraph, the division pattern flag is not 1 (S42 in FIG. 21: No) but 2 (S44 in FIG. 21: Yes).

Next, since the divided balance amount of 194,400 yen described in S4 is equal to or greater than the accrued amount of 100,000 yen in the first row record of the assessment division cursor 106e (S45 of FIG. 21: Yes), the calculation unit 102c5 In accordance with the accrued amount category "1: fixed amount" included in the record on the first line of the assessment division cursor 106e, a divided amount corresponding to the accrued amount category is calculated. That is, when the accrued amount category is "1: fixed amount", the accrued amount included in the assessment split condition is output as the divided amount. (S46 in FIG. 21).

Further, the updating unit 102c6 substitutes 94,400 yen, which is a value obtained by subtracting the divided amount of 100,000 yen calculated by the calculation unit 102c5 from the divided balance amount of 194,400 yen described in S4, into the divided balance amount. The remaining amount is updated (S48 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 43, the appraisal divided work 106f including billing details with the billing tax included amount of the divided amount of 100,000 yen calculated in S46 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 43, the details of the first line (the details of the claim number 000000000001) in the billing data 106g shown in FIG. 12 are created. Then, return to FIG.

[4-4-2. Processing for the record on the second row of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 44, the record on the second line of the assessment division cursor 106e is called (S9 in FIG. 15). Then, the process described below is performed on the called record of the second row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Also, in this example, the balance classification in the second row record is not "0: whole" (S13 of FIG. 15: No). In this example, the amount condition classification in the record on the second line is neither "0: less than" (S28: No in FIG. 19) nor "1: less than or equal to" (S31: No in FIG. 19). ), neither "2: more than" (S34: No in FIG. 19), neither "3: over" (S37: No in FIG. 20), and "9: none" (S40: Yes in FIG. 20).

Here, the value acquisition unit 102c3 acquires the split balance amount of 94,400 yen updated in [4-4-1] according to the amount category of the balance category 1 included in the assessment split condition shown in FIG.

Since the amount condition classification in the record on the second line is "9: none", there is no condition that the acquired divided balance amount of 94,400 yen should satisfy. Therefore, the process proceeds to S41 of FIG. 20, and the division pattern flag is set to 1 according to the accrued amount category 0 in the second row record. Then, the process proceeds to FIG. 19(D) and then to FIG. 21(A).

In this example, as described in the previous paragraph, the division pattern flag is 1 (S42 in FIG. 21: Yes).

Next, the calculation unit 102c5 calculates the divided amount corresponding to the incurred amount category "0: full amount" included in the record on the second line of the assessment division cursor 106e in FIG. That is, when the accrual amount category is "0: full amount", the value obtained by the value obtaining unit 102c3 is output as the divided amount. The amount of 944,00 yen is substituted for the divided amount (S43 in FIG. 21). Next, the update unit 102c6 substitutes 0 yen, which is a value obtained by subtracting the divided balance amount of 94,400 yen calculated by the calculation unit 102c5 from the divided balance amount of 94,400 yen updated in [4-4-1], into the divided balance amount. By doing so, the divided balance amount is updated (S43 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16(A), as shown in FIG. 44, the assessment divided work 106f including billing details with the billing tax included amount of the divided amount of 94,400 yen calculated in S43 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 44, the details of the second line (the details of the claim number 000000000002) in the billing data 106g shown in FIG. 12 are created. Continuing, it progresses to FIG. 15(A).

[4-4-3. end of processing]
As a result of the processing described in [4-4-1] and [4-4-2] above, there is no remaining detail in the assessment split cursor 106e (because all records in the assessment split cursor 106e have been called). The process of the division cursor 106e is exited (S9 in FIG. 15: end of process, start of next detail process). Then, since there are no remaining details in the order request cursor 106c (because all the details in the order request cursor 106c have been called), the processing of the order request cursor 106c is exited (S3 in FIG. 15: end of processing), and all processing is completed. do.

[4-5. When dividing based on the proportional division rate and the total amount of the balance]
As an overview of splitting based on the apportionment rate and the total amount of the remaining balance, as shown in Figure 13, the total amount including the order tax of 194,400 yen is apportioned at a 30% apportionment rate, and the amount of 58,320 yen is the billing statement with the billing amount including tax. , the billing statement with the invoice tax amount of 97,200 yen obtained by dividing the total order tax included amount of 194,400 yen at a proportional division rate of 50%, and Billing data 106g including a billing statement of the total amount of 38,880 yen including the billing tax of 38,880 yen is created. Detailed processing is described below.

First, the order request input unit 102a receives input of an order request. Next, the order confirmation processing unit 102b performs order confirmation processing for the two checked details of the order request details shown in (screen item) in FIG. As a result, the two details are added to the order details work 106b as order confirmation details, and the order details work 106b is updated (S1 in FIG. 15). The updated order details work 106b is shown in FIG.

Next, from the updated order detail work 106b, 1 to 2 with the same combination of the division code, supplier code, order date, project code, project branch number, construction number and construction division The confirmed order details of the row are aggregated and stored in the first row of the order request cursor 106c in FIG. 46 (S2 in FIG. 15).

Next, as shown in FIG. 47, the consolidated details on the first line of the order request cursor are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 194,400 yen in the summed up details on the first line that has been called up for the divided principal amount, and the order consumption tax amount of 14,400 yen in the summed up details on the first line that has been called up. to the split amount of consumption tax, assign the above split amount of 194,400 yen to the split remaining amount, assign the above split amount of 14,400 yen to the split remaining consumption tax amount, and set "1" to the invoice split number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-5], as shown in FIG. 45, three assessment split conditions are set in the assessment split master 106d, so the rule acquisition unit 102c2 acquires the assessment split conditions. be able to. That is, the number of acquisitions of the assessment division condition is not 0 (S6 in FIG. 15: No).

In this case, as shown in FIG. 48, the record in the assessment split master 106d of FIG. 45 is stored in the assessment split cursor 106e (S8 of FIG. 15).

[4-5-1. Processing for the record on the first row of the assessment division cursor 106e]
Next, as shown in FIG. 49, it is called from the first row record of the assessment division cursor 106e (S9 in FIG. 15). Then, the process described below is performed on the called record of the first row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Further, in this example, the balance category in the record of the first row is "0: whole" (S13: YES in FIG. 15). In this example, the amount condition classification in the record of the first row is neither "0: less than" (S14: No in FIG. 17) nor "1: less than or equal to" (S17: No in FIG. 17). ), and "2: greater than or equal to" (S20 of FIG. 17: YES).

In this case, it is checked as follows whether or not the condition "said split principal amount described in S4≧amount condition in the record on the first line of the assessment split cursor 106e" is satisfied (S21 in FIG. 17). ). First, the value acquisition unit 102c3 acquires the split principal amount of 194,400 yen described in S4 according to the amount category of the balance category 0 included in the assessment split condition acquired by the rule acquisition unit 102c2. Then, the determination unit 102c4 determines that the split principal amount of 194,400 yen acquired by the value acquisition unit 102c3 is the combination of the amount condition and the amount condition category included in the assessment split condition acquired by the rule acquisition unit 102c2, which is "100,000 yen or more." ” is satisfied.

Since the split principal amount of 194,400 yen is 100,000 yen or more (S21 of FIG. 17: Yes), the process proceeds to S22 of FIG. In this example, the division pattern flag is set to 3 according to the accrued amount classification 2 in the record of the first row (S22 in FIG. 17). Then, the process proceeds to FIG. 21(A).

In this example, as described in the previous paragraph, the division pattern flag is not 1 (S42 of FIG. 21: No) nor 2 (S44 of FIG. 21: No) but is 3 (S49 of FIG. 21: Yes).

Next, in this example, since the balance classification in the first row record is "0: whole" (S50 in FIG. 21: Yes), the calculation unit 102c5 194,400 yen x (proportional division ratio 30%/100 in the first row record) = 58,320 yen is substituted for the judgment amount (S51 in Fig. 21).

Next, in this example, since the amount fractional unit in the first row record is 0, the fractional number is 1 (S53 in FIG. 21: No). In this case, the calculation unit 102c5 substitutes FLOOR ((the judgment amount 58,320 yen/the fraction 1) × 10)/10 = 58,320 yen for the judgment multiple, and further substitutes the judgment multiple 58,320 yen for the first line. A judgment multiple of 58,320 yen is calculated by rounding down according to the fraction division in the record (S55 in FIG. 21).

Next, the calculation unit 102c5 substitutes the fraction 1×the determination multiple 58,320 yen=58,320 yen for the divided amount (S56 in FIG. 21).

Next, in this example, the condition "the split amount of 194,400 yen explained in S4<the split amount of 58,320 yen explained in S56" is not satisfied (S57 in FIG. 21: No), and an illegal setting is made. do not have. Also, in this example, the condition "the divided balance amount of 194,400 yen explained in S4<the divided amount of 58,320 yen explained in S56" is not satisfied (S59 of FIG. 21: No), and an illegal setting has not been made. do not have.

Next, the updating unit 102c6 substitutes 136,080 yen, which is the result of subtracting the divided balance amount of 194,400 yen described in S4 from the divided balance amount of 58,320 yen described in S56, into the divided balance amount. The amount is updated (S61 in FIG. 21). In addition, the calculation unit 102c5 divides 4,320 yen, which is the result of calculating the above-mentioned consumption tax amount 14,400 yen described in S4 × (the above-mentioned split amount 58,320 yen described in S56/the above-mentioned split amount 194,400 yen described in S4). Substitute into the amount of consumption tax (S61 in FIG. 21). Then, the updating unit 102c6 substitutes 10,080 yen, which is a value obtained by subtracting the divided consumption tax amount of 4,320 yen described in this paragraph from the divided remaining consumption tax amount of 14,400 yen described in S4, into the divided remaining consumption tax amount. The divided remaining consumption tax amount is updated (S61 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 49, the appraisal divided work 106f including billing details with the billing tax included amount of the divided amount of 58,320 yen calculated in S56 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 49, the details of the first line (the details of the claim number 000000000001) in the billing data 106g shown in FIG. 13 are created. Next, return to FIG. 15(A).

[4-5-2. Processing for the record on the second row of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 50, the record on the second line of the assessment division cursor 106e is called (S9 in FIG. 15). Here, the record on the second line of the assessment split cursor 106e contains the same information as the record on the first line of the assessment split cursor 106e, except that the apportionment rate is 50%. Therefore, since the same processing as the processing described in [4-5-1] is performed, only the calculation performed by the calculating unit 102c5 and the updating unit 102c6 for the second row record will be described below.

The calculation unit 102c5 substitutes the split principal amount of 194,400 yen described in S4×(the apportionment rate of 50%/100 in the second row record)=97,200 yen into the judgment amount (S51 in FIG. 21). Subsequently, the calculation unit 102c5 substitutes FLOOR ((the judgment amount 97,200 yen/the fraction 1)×10)/10=97,200 yen for the judgment multiple, and further substitutes the judgment multiple 97,200 yen for the second line. A judgment multiple of 97,200 yen is calculated by rounding down according to the fraction division in the record (S55 in FIG. 21). Subsequently, the calculation unit 102c5 substitutes the fraction 1×the determination multiple 97,200 yen=97,200 yen for the division amount (S56 in FIG. 21).

Next, the update unit 102c6 subtracts the divided balance amount of 97,200 yen described in S56 from the divided balance amount of 136,080 yen updated in S61 of [4-5-1], and subtracts the divided balance amount of 38,800 yen from the divided balance amount of 38,800 yen. to update the divided balance amount (S61 in FIG. 21). Further, the calculation unit 102c5 calculates 7,200 yen, which is the calculation result of 14,400 yen for the divided consumption tax amount described in S4×(97,200 yen for the divided amount described in S56/194,400 yen for the divided amount described in S4). Substitute into the divided consumption tax amount (S61 in FIG. 21). Then, the updating unit 102c6 subtracts the divided consumption tax amount of 7,200 yen described in this paragraph from the remaining divided consumption tax amount of 10,080 yen updated in S61 of [4-5-1], and adds 2,880 yen to the remaining divided consumption tax amount of 2,880 yen. By substituting for the tax amount, the remaining divided consumption tax amount is updated (S61 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16(A), as shown in FIG. 50, the assessment divided work 106f including billing details with the billing tax included amount of the divided amount of 97,200 yen calculated in S56 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 50, the details of the second line (the details of the claim number 000000000002) in the billing data 106g shown in FIG. 13 are created. Next, return to FIG. 15(A).

[4-5-3. Processing for the third row record of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 51, the record on the third line of the assessment division cursor 106e is called (S9 in FIG. 15). Then, the process described below is performed on the called record of the third row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Also, in this example, the balance category in the third row record is "1: balance" (S13 in FIG. 15: No). In this example, the amount condition classification in the third row record is neither "0: less than" (S28: No in FIG. 19) nor "1: less than or equal to" (S31: No in FIG. 19). ), neither "2: more than" (S34: No in FIG. 19), neither "3: more than" (S37: No in FIG. 20), and "9: none" (S40: Yes in FIG. 20).

Here, the value acquisition unit 102c3 acquires the split balance amount of 38,800 yen updated in [4-5-2] according to the amount category of balance category 1 included in the assessment split condition shown in FIG.

Since the amount condition classification in the record of the third row is "9: none", there is no condition that the acquired divided balance amount of 38,800 yen should satisfy. Therefore, the process proceeds to S41 of FIG. 20, and the division pattern flag is set to 1 according to the accrued amount classification 0 in the record of the third row. Then, the process proceeds to FIG. 19(D) and then to FIG. 21(A).

In this example, as described in the previous paragraph, the division pattern flag is 1 (S42 in FIG. 21: Yes).

Next, the calculation unit 102c5 calculates the divided amount corresponding to the incurred amount category "0: full amount" included in the third row record of the assessment division cursor 106e in FIG. That is, when the accrual amount category is "0: full amount", the value obtained by the value obtaining unit 102c3 is output as the divided amount. The amount of 38,800 yen is substituted for the divided amount (S43 in FIG. 21). Next, the update unit 102c6 sets 0 yen, which is the value obtained by subtracting the divided balance amount of 38,800 yen calculated by the calculation unit 102c5 from the divided balance amount of 38,800 yen updated in [4-5-2], to the divided balance amount. By substituting, the divided balance amount is updated (S43 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 51, the assessment divided work 106f including the billing details with the billing tax included amount of 38,800 yen calculated in S43 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 51, the details of the third line (the details of the claim number 000000000003) in the billing data 106g shown in FIG. 13 are created. Continuing, it progresses to FIG. 15(A).

[4-5-4. end of processing]
As a result of the processing described in [4-5-1] to [4-5-3] above, there is no remaining detail in the assessment split cursor 106e (because all records in the assessment split cursor 106e have been called). The process of the division cursor 106e is exited (S9 in FIG. 15: end of process, start of next detail process). Then, since there are no remaining details in the order request cursor 106c (because all the details in the order request cursor 106c have been called), the processing of the order request cursor 106c is exited (S3 in FIG. 15: end of processing), and all processing is completed. do.

[4-6. When performing a somewhat complicated division based on the pro rata ratio and the total amount of the balance]
As an overview of a somewhat complicated division based on the apportionment rate and the total amount of the remaining balance, as shown in Fig. 14, the total amount including the order tax of 194,400 yen is apportioned at a rate of 50%, resulting in an amount of 97,200 yen, which is the billing amount including tax. and the balance of 97,200 yen obtained by subtracting the above-mentioned apportioned amount of 97,200 yen from the total order tax-included amount of 194,400 yen. Billing statement with billing tax amount of 34,020 yen, which is the balance of 68,040 yen obtained by subtracting the apportioned amount of 29,160 yen from yen, and the amount of 34,020 yen obtained by apportioning the apportionment rate of 50%, and the balance of the above balance of 68,040 yen minus the apportioned amount of 34,020 yen. Billing data 106g including a billing statement with the total amount of 34,020 yen including billing tax of 34,020 yen is created. Detailed processing is described below.

First, the order request input unit 102a receives input of an order request. Next, the order confirmation processing unit 102b performs order confirmation processing for the two checked details of the order request details shown in (screen item) in FIG. As a result, the two details are added to the order details work 106b as order confirmation details, and the order details work 106b is updated (S1 in FIG. 15). The updated order details work 106b is shown in FIG.

Next, from the updated order detail work 106b, 1 to 2 with the same combination of the division code, supplier code, order date, project code, project branch number, construction number and construction division The confirmed order details of the row are aggregated and stored in the first row of the order request cursor 106c in FIG. 53 (S2 in FIG. 15).

Next, as shown in FIG. 54, the consolidated details on the first line of the order request cursor are called (S3 in FIG. 15).

Next, the initial value setting unit 102c1 substitutes the order tax amount of 194,400 yen in the summed up details on the first line that has been called up for the divided principal amount, and the order consumption tax amount of 14,400 yen in the summed up details on the first line that has been called up. to the split amount of consumption tax, assign the above split amount of 194,400 yen to the split remaining amount, assign the above split amount of 14,400 yen to the split remaining consumption tax amount, and set "1" to the invoice split number. (S4 in FIG. 15).

Next, the rule acquisition unit 102c2 acquires the assessment split conditions from the assessment split master 106d (S5 in FIG. 15).

Here, in this item [4-6], as shown in FIG. 52, five assessment split conditions are set in the assessment split master 106d, so the rule acquisition unit 102c2 acquires the assessment split conditions. be able to. That is, the number of acquisitions of the assessment division condition is not 0 (S6 in FIG. 15: No).

In this case, as shown in FIG. 55, the record in the assessment split master 106d of FIG. 52 is stored in the assessment split cursor 106e (S8 of FIG. 15).

[4-6-1. Processing for the record on the first row of the assessment division cursor 106e]
Next, as shown in FIG. 56, it is called from the first row record of the assessment division cursor 106e (S9 in FIG. 15). Here, the record on the first line of the assessment division cursor 106e of this item [4-6] is the same as the record on the first line of the assessment division cursor 106e of [4-5] except that the apportionment rate is 50%. contain the same information. Therefore, since the same processing as the processing described in [4-5-1] is performed, only the calculation performed by the calculating unit 102c5 and the updating unit 102c6 for the first row record of the assessment division cursor 106e in FIG. will explain.

The calculation unit 102c5 substitutes the split principal amount 194,400 yen described in S4×(proportional division ratio 50%/100 in the first row record)=97,200 yen for the judgment amount (S51 in FIG. 21). Subsequently, the calculation unit 102c5 substitutes FLOOR ((the judgment amount 97,200 yen/the fraction 1)×10)/10=97,200 yen for the judgment multiple, and further substitutes the judgment multiple 97,200 yen for the first line. A judgment multiple of 97,200 yen is calculated by rounding down according to the fraction division in the record (S55 in FIG. 21). Subsequently, the calculation unit 102c5 substitutes the fraction 1×the determination multiple 97,200 yen=97,200 yen for the division amount (S56 in FIG. 21).

Next, the updating unit 102c6 substitutes 97,200 yen, which is the result of subtracting the divided balance amount of 97,200 yen described in S56 from the divided balance amount of 194,400 yen described in S4, into the divided balance amount. The amount is updated (S61 in FIG. 21). In addition, the calculation unit 102c5 divides 7,200 yen, which is the result of calculation of the consumption tax amount 14,400 yen (the divided amount described in S56) x (the divided amount 97,200 yen described in S56/the divided amount 194,400 yen described in S4). Substitute into the amount of consumption tax (S61 in FIG. 21). Then, the updating unit 102c6 substitutes 7,200 yen, which is a value obtained by subtracting the divided consumption tax amount of 7,200 yen described in this paragraph from the divided remaining consumption tax amount of 14,400 yen described in S4, into the divided remaining consumption tax amount. The divided remaining consumption tax amount is updated (S61 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 56, the appraisal divided work 106f including billing details with the billing tax included amount of the divided amount of 97,200 yen calculated in S56 is updated (S12 in FIG. 16). Based on the assessment division work 106f shown in FIG. 56, the details of the first line (the details of the claim number 000000000001) in the billing data 106g shown in FIG. 14 are created. Next, return to FIG. 15(A).

[4-6-2. Processing for the record on the second row of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 57, the record on the second line of the assessment division cursor 106e is called (S9 in FIG. 15). Then, the process described below is performed on the called record of the second row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Further, in this example, the balance classification in the second row record is "1: Balance" (S13 in FIG. 15: No). In this example, the amount condition classification in the second row record is "less than 0" (S28 of FIG. 19: Yes).

In this case, whether or not the condition ``the divided balance amount updated in S61 of [4-6-1]<the amount condition in the second row record of the assessment division cursor 106e'' is satisfied is determined as follows. It is checked (S29 in FIG. 19). First, the value acquisition unit 102c3 acquires the split balance amount of 97,200 yen updated in S61 of [4-6-1] according to the amount category of balance category 1 included in the assessment split condition acquired by the rule acquisition unit 102c2. do. Then, the determination unit 102c4 decides that the divided balance amount of 97,200 yen acquired by the value acquisition unit 102c3 is "less than 50,000 yen", which is the combination of the amount condition and the amount condition category included in the assessment division condition acquired by the rule acquisition unit 102c2. ” is satisfied.

Since the divided balance amount of 97,200 yen is not less than 50,000 (S29 in FIG. 19: No), the process proceeds to FIG. 16(A). In this example, since the division amount is not calculated, the assessment division work 106f is not updated in S12 of FIG. Next, return to FIG. 15(A).

[4-6-3. Processing for the third row record of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 58, the record on the third line of the assessment division cursor 106e is called (S9 in FIG. 15). Then, the process described below is performed on the called record of the third row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Also, in this example, the balance category in the third row record is "1: balance" (S13 in FIG. 15: No). In this example, the amount condition classification in the third row record is neither "0: less than" (S28: No in FIG. 19) nor "1: less than or equal to" (S31: No in FIG. 19). ), and "2: greater than or equal to" (S34 of FIG. 19: YES).

In this case, whether or not the condition "the divided balance amount updated in S61 of [4-6-1]≧the amount condition in the third row record of the assessment division cursor 106e" is satisfied is determined as follows. It is checked (S35 in FIG. 19). First, the value acquisition unit 102c3 acquires the split balance amount of 97,200 yen updated in S61 of [4-6-1] according to the amount category of balance category 1 included in the assessment split condition acquired by the rule acquisition unit 102c2. do. Then, the determination unit 102c4 determines that the divided balance amount of 97,200 yen acquired by the value acquisition unit 102c3 is "50,000 yen or more" in the combination of the amount condition and the amount condition category included in the assessment division condition acquired by the rule acquisition unit 102c2. ” is satisfied.

Since the divided balance amount of 97,200 yen is 50,000 yen or more (S35 of FIG. 19: Yes), the process proceeds to S36 of FIG. In this example, the division pattern flag is 3 according to the amount accrual classification 2 in the record of the third row. Then, the process proceeds to FIG. 21(A).

In this example, as described in the previous paragraph, the division pattern flag is not 1 (S42 of FIG. 21: No) nor 2 (S44 of FIG. 21: No) but is 3 (S49 of FIG. 21: Yes).

Next, in this example, since the balance classification in the record of the third row is "1: Balance" (S50 in FIG. 21: No), the calculation unit 102c5 performs [4-6-1]. The divided balance amount 97,200 yen updated in S61×(proportional division ratio 30%/100 in the third row record)=29,160 yen is substituted for the judgment amount (S52 in FIG. 21).

Next, in this example, since the amount fraction unit in the third row record is 0, the fraction is 1 (S53 in FIG. 21: No). In this case, the calculation unit 102c5 substitutes FLOOR ((the judgment amount 29,160 yen/the fraction 1) × 10)/10 = 29,160 yen for the judgment multiple, and further substitutes the judgment multiple 29,160 yen for the third line. A judgment multiple of 29,160 yen is calculated by rounding down according to the fraction division in the record (S55 in FIG. 21).

Next, the calculation unit 102c5 substitutes the fraction 1×the determination multiple 29,160 yen=29,160 yen for the divided amount (S56 in FIG. 21).

Next, in this example, the condition "the above-mentioned division amount of 194,400 yen explained in S4<the above-mentioned division amount of 29,160 yen explained in S56" is not satisfied (S57 in FIG. 21: No), and the setting is incorrect. is not done. In addition, in this example, the condition "97,200 yen for the remaining split amount updated in S61 of [4-6-1]<29,160 yen for the split amount explained in S56" is not satisfied (S59 in FIG. 21: No). , is not configured incorrectly.

Next, the updating unit 102c6 subtracts the divided balance amount of 29,160 yen described in S56 from the divided balance amount of 97,200 yen updated in S61 of [4-6-1], and subtracts the divided balance amount of 68,040 yen from the divided balance amount of 68,040 yen. to update the divided balance amount (S61 in FIG. 21). Further, the calculation unit 102c5 divides 2,160 yen, which is the result of calculation of the above-mentioned split source consumption tax amount of 14,400 yen described in S4 × (the above-mentioned split amount of 29,160 yen described in S56/the above-mentioned split base amount of 194,400 yen described in S4). Substitute into the amount of consumption tax (S61 in FIG. 21). Then, the updating unit 102c6 subtracts the divided remaining consumption tax amount of 7,200 yen updated in S61 of [4-6-1] from the divided remaining consumption tax amount of 2,160 yen described in this paragraph, which is 5,040 yen. By substituting for the tax amount, the remaining divided consumption tax amount is updated (S61 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 58, the appraisal divided work 106f including billing details with the billing tax included amount of the divided amount of 29,160 yen calculated in S56 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 58, the details of the second line (the details of the claim number 000000000002) in the billing data 106g shown in FIG. 14 are created. Next, return to FIG. 15(A).

[4-6-4. Processing for the fourth row record of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 59, the record on the fourth line of the assessment division cursor 106e is called (S9 in FIG. 15). Here, the record on the fourth line of the assessment split cursor 106e contains the same information as the record on the third line of the assessment split cursor 106e, except that the apportionment rate is 50%. Therefore, since the same processing as the processing described in [4-6-3] is performed, only the calculation performed by the calculating unit 102c5 and the updating unit 102c6 for the fourth row record will be described below.

The calculation unit 102c5 substitutes the divided balance amount 68,040 yen updated in S61 of [4-6-3] × (proportional division ratio 50%/100 in the record of the fourth row) = 34,020 yen for the judgment amount ( S51 in FIG. 21). Subsequently, the calculation unit 102c5 substitutes FLOOR ((the judgment amount of 34,020 yen/the fraction 1)×10)/10=34,020 yen into the judgment multiple, and further substitutes the judgment multiple of 34,020 yen into the fourth line. A judgment multiple of 34,020 yen is calculated by rounding down according to the fractional division in the record (S55 in FIG. 21). Subsequently, the calculation unit 102c5 substitutes 34,020 yen = 34,020 yen for the fraction 1 x the judgment multiple (S56 in Fig. 21).

Next, the update unit 102c6 subtracts the divided balance amount of 34,020 yen described in S56 from the divided balance amount of 68,040 yen updated in S61 of [4-6-3], and subtracts the divided balance amount of 34,020 yen from the divided balance amount of 34,020 yen. to update the divided balance amount (S61 in FIG. 21). In addition, the calculation unit 102c5 divides 2,520 yen, which is the result of calculation of the consumption tax amount of 14,400 yen (the divided amount of 34,020 yen described in S56/the divided amount of 194,400 yen described in S4). Substitute into the amount of consumption tax (S61 in FIG. 21). Then, the updating unit 102c6 subtracts the divided consumption tax amount of 2,520 yen described in this paragraph from the divided remaining consumption tax amount of 5,040 yen updated in S61 of [4-6-3], and adds 2,520 yen to the divided remaining consumption tax amount of 2,520 yen. By substituting for the tax amount, the remaining divided consumption tax amount is updated (S61 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 59, the appraisal divided work 106f including billing details with the billing tax included amount of 34,020 yen calculated in S56 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 59, the details of the third line (the details of the claim number 000000000003) in the billing data 106g shown in FIG. 14 are created. Next, return to FIG. 15(A).

[4-6-5. Processing for the fifth row record of the assessment division cursor 106e]
Returning to FIG. 15A, as shown in FIG. 60, the record on the fifth line of the assessment division cursor 106e is called (S9 in FIG. 15). Then, the process described below is performed on the called record of the fifth row.

In this example, the number of acquired records of the assessment division cursor 106e is greater than 1 (S10 in FIG. 15: number of acquired records>1). Also, in this example, the balance category in the record on the fifth line is "1: Balance" (S13 in FIG. 15: No). In this example, the amount condition classification in the fifth row record is neither "0: less than" (S28: No in FIG. 19) nor "1: less than or equal to" (S31: No in FIG. 19). ), neither "2: more than" (S34: No in FIG. 19), neither "3: over" (S37: No in FIG. 20), and "9: none" (S40: Yes in FIG. 20).

Here, the value acquisition unit 102c3 acquires the split balance amount of 34,020 yen updated in [4-6-4] according to the amount category of the balance category 1 included in the assessment split condition shown in FIG.

Since the amount condition classification in the record on the fifth line is "9: None", there is no condition that the acquired divided balance amount of 34,020 yen should satisfy. Therefore, the process proceeds to S41 in FIG. 20, and the division pattern flag is set to 1 according to the accrued amount category 0 in the record of the fifth row. Then, the process proceeds to FIG. 19(D) and then to FIG. 21(A).

In this example, as described in the previous paragraph, the division pattern flag is 1 (S42 in FIG. 21: Yes).

Next, the calculation unit 102c5 calculates the divided amount corresponding to the incurred amount category "0: full amount" included in the record on the fifth line of the assessment division cursor 106e in FIG. That is, when the accrual amount category is "0: full amount", the value obtained by the value obtaining unit 102c3 is output as the divided amount. The amount of 34,020 yen is substituted for the divided amount (S43 in FIG. 21). Next, the updating unit 102c6 sets 0 yen, which is the value obtained by subtracting the divided balance amount of 34,020 yen calculated by the calculation unit 102c5 from the divided balance amount of 34,020 yen updated in [4-6-4], to the divided balance amount. By substituting, the divided balance amount is updated (S43 in FIG. 21). Then, the process proceeds to FIG. 16(A).

Proceeding to FIG. 16A, as shown in FIG. 60, the appraisal divided work 106f including billing details with the billing tax included amount of the divided amount of 34,020 yen calculated in S43 is updated (S12 in FIG. 16). Then, based on the assessment division work 106f shown in FIG. 60, the details of the fourth line (the details of the claim number 000000000004) in the billing data 106g shown in FIG. 14 are created. Continuing, it progresses to FIG. 15(A).

[4-6-6. end of processing]
As a result of the processing described in [4-6-1] to [4-6-5] above, there is no remaining detail in the assessment split cursor 106e (because all records in the assessment split cursor 106e have been called). The process of the division cursor 106e is exited (S9 in FIG. 15: end of process, start of next detail process). Then, since there are no remaining details in the order request cursor 106c (because all the details in the order request cursor 106c have been called), the processing of the order request cursor 106c is exited (S3 in FIG. 15: end of processing), and all processing is completed. do.

[4-7. summary]
As described above in [4-1] to [4-6], according to the business support device 100 according to the present embodiment, the principal amount to be divided is divided and a plurality of divided amounts are output. be able to. As a result, it is possible to greatly reduce the burden that has conventionally been required for dividing the bill amount.

[5. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed arbitrarily.

Also, with respect to the business support device 100, each constituent element shown in the figure is functionally conceptual, and does not necessarily need to be physically configured as shown in the figure.

For example, all or any part of the processing functions provided by the business support device 100, particularly each processing function performed by the control unit, may be realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is recorded on the business support apparatus as necessary. 100 mechanically read. That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the business support apparatus 100 via any network, and all or part of it can be downloaded as necessary. be.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" means memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (Registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the business support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which arbitrary peripheral devices are connected. Further, the task support device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in this embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in the real estate industry, the construction industry, and the like.

100 business support device 102 control unit
102a Order request input unit
102b Order Confirmation Processing Unit
102c division amount output unit
102c1 Initial value setting part
102c2 Rule Acquisition Unit
102c3 value acquisition unit
102c4 decision unit
102c5 calculator
102c6 update part
102d document data creation unit
102e purchase input unit 104 communication interface unit 106 storage unit
106a Order request data
106b Order details work
106c Order request cursor
106d Master of assessment division method at the time of customer order
106e Assessment division cursor when placing an order with a customer
106f Assessment division work
106g Invoice data
106h document data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (4)

A business support device comprising a control unit,
The control unit comprises split amount output means for outputting a plurality of split amounts by splitting the principal amount that is the basis for splitting into a plurality of payment periods ,
The divided amount output means is
initial value setting means for substituting the principal amount into a principal amount variable and a balance amount variable;
rule acquisition means for acquiring the division rule from a division rule set including a plurality of division rules;
Among the principal amount classification meaning to obtain the value of the principal amount variable and the balance amount classification meaning to obtain the value of the balance amount variable included in the division rule obtained by the rule obtaining means a value acquiring means for acquiring the value of the principal amount variable or the value of the balance amount variable at the time of execution of this process according to any of the amount categories;
judgment means for judging whether the value acquired by the value acquisition means satisfies an amount condition included in the division rule acquired by the rule acquisition means;
a predetermined amount output classification, which means that a predetermined amount included in the division rule obtained by the rule obtaining unit is output as the divided amount when the determining means determines that the amount condition is satisfied; and The combination of the predetermined amount, the ratio reference amount output category meaning that the product of the value obtained by the value obtaining means and a predetermined ratio is output as the divided amount, the combination of the predetermined ratio, and the value obtained by the value obtaining means Acquisition of the divided amount corresponding to the output classification by the information or the value obtaining means according to the output classification included in any information of the full output classification meaning that the value is output as the divided amount a calculation means for calculating based on the value obtained;
updating means for substituting, into the balance amount variable, a value obtained by subtracting the divided amount calculated by the calculation means from the value of the balance amount variable at the time of execution of this processing;
with
operating the rule acquisition means, the value acquisition means, the determination means, the calculation means, and the update means a plurality of times ;
The principal amount is the order amount for the construction work of the detached house ordered by the developer to the construction company,
The divided amount is the amount billed by the construction company to the developer for the construction work, and is described in the invoice sent by the developer to the construction company when placing the order;
A business support device characterized by: Equipped with a display,
The divided amount output means starts operating after the principal amount is set on a predetermined screen for confirming the contents of the order displayed on the display unit;
The business support device according to claim 1 , characterized by: A divided amount output method executed by a business support device comprising a control unit,
including a split amount output step of outputting a plurality of split amounts by splitting the principal amount that is the basis for splitting into a plurality of payment periods , executed by the control unit;
The split amount output step includes:
an initial value setting step of substituting the principal amount into a principal amount variable and a balance amount variable;
a rule acquisition step of acquiring the splitting rule from a splitting rule set including a plurality of splitting rules;
Among the principal amount classification meaning to obtain the value of the principal amount variable and the balance amount classification meaning to obtain the value of the balance amount variable included in the split rule obtained in the rule obtaining step a value acquisition step of acquiring the value of the principal amount variable or the value of the balance amount variable at the time of execution of this process according to one of the amount categories;
a judgment step of judging whether the value acquired in the value acquisition step satisfies an amount condition included in the division rule acquired in the rule acquisition step;
if it is determined in the determining step that the money amount condition is satisfied, a predetermined amount output classification that means that a predetermined amount is to be output as the divided amount included in the division rule acquired in the rule acquiring step; and The combination of the predetermined amount, the ratio reference amount output category meaning that the product of the value obtained in the value obtaining step and a predetermined ratio is output as the divided amount, the combination of the predetermined ratio, and the value obtained in the value obtaining step Acquiring the divided amount corresponding to the output classification in the information or the value obtaining step according to the output classification included in any information of the full output classification meaning that the value is output as the divided amount. A calculation step of calculating based on the value obtained;
an update step of substituting, into the balance amount variable, a value obtained by subtracting the divided amount calculated in the calculation step from the value of the balance amount variable at the time of execution of this process;
including
the rule acquisition step, the value acquisition step, the determination step, the calculation step, and the update step are performed multiple times ;
The principal amount is the order amount for the construction work of the detached house ordered by the developer to the construction company,
The divided amount is the amount billed by the construction company to the developer for the construction work, and is described in the invoice sent by the developer to the construction company when placing the order;
A split amount output method characterized by: A divided amount output program to be executed by a business support device having a control unit,
including a split amount output step of outputting a plurality of split amounts by splitting the principal amount that is the basis for splitting into a plurality of payment periods, for execution by the control unit;
The split amount output step includes:
an initial value setting step of substituting the principal amount into a principal amount variable and a balance amount variable;
a rule acquisition step of acquiring the splitting rule from a splitting rule set including a plurality of splitting rules;
Among the principal amount classification meaning to obtain the value of the principal amount variable and the balance amount classification meaning to obtain the value of the balance amount variable included in the split rule obtained in the rule obtaining step a value acquisition step of acquiring the value of the principal amount variable or the value of the balance amount variable at the time of execution of this process according to one of the amount categories;
a judgment step of judging whether the value acquired in the value acquisition step satisfies an amount condition included in the division rule acquired in the rule acquisition step;
if it is determined in the determining step that the money amount condition is satisfied, a predetermined amount output classification that means that a predetermined amount is to be output as the divided amount included in the division rule acquired in the rule acquiring step; and The combination of the predetermined amount, the ratio reference amount output category meaning that the product of the value obtained in the value obtaining step and a predetermined ratio is output as the divided amount, the combination of the predetermined ratio, and the value obtained in the value obtaining step Acquiring the divided amount corresponding to the output classification in the information or the value obtaining step according to the output classification included in any information of the full output classification meaning that the value is output as the divided amount. A calculation step of calculating based on the value obtained;
an update step of substituting, into the balance amount variable, a value obtained by subtracting the divided amount calculated in the calculation step from the value of the balance amount variable at the time of execution of this process;
including
the rule acquisition step, the value acquisition step, the determination step, the calculation step, and the update step are performed multiple times ;
The principal amount is the order amount for the construction work of the detached house ordered by the developer to the construction company,
The divided amount is the amount billed by the construction company to the developer for the construction work, and is described in the invoice sent by the developer to the construction company when placing the order;
A divided amount output program characterized by

Images