JP7220111B2 - Data creation device, data creation program and data creation method - Google Patents

Description

The present invention relates to a data creation device, a data creation program, and a data creation method.

Due to the nature of the business of delivery companies, it is often the case that they ask other business offices to deliver the parts that cannot be dispatched by the business office that receives the order. In this way, when the work corresponding to one order is carried out at multiple offices, it is necessary for the ordering office to grasp the internal cost, while for the office receiving the request, it is necessary to grasp the internal sales and actual sales. It is necessary to dispatch and purchase vehicles. Until now, it was common to calculate the sales and cost of sales at each business site at the time of internal trading by multiplying the total amount of orders for which work occurred by a certain rate.

In addition, in Patent Document 1, a supervising company sales journal creation process based on supervising company PJ data, etc., a supervising company purchase journal creation process based on order purchase data 106b, etc., and a support company sales journal based on help company PJ data 106d, etc. It describes the creation process.

JP 2018-81507 A

However, with the general calculation method described above, it is difficult to accurately capture the sales and costs of each business office generated from one order.

The present invention has been made in view of the above. It is an object of the present invention to provide a data creation device, a data creation program, and a data creation method that enable capturing.

In order to solve the above-described problems and achieve the object, a data creation device according to the present invention is a data creation device comprising a control unit, wherein the control unit controls a business office of a company to perform work from an external company. Origin order data that retains order information related to an order received and order information related to ordering of the work by the business establishment of the orderer to another business establishment of the company; Designated business by referring to a storage unit that stores received order data that holds order information related to the order received for the work and that can store order information related to the order placed by the other office of the orderer to an external company for the work Extract the order data with the place of order as the order source business, create the sales data of the specified business based on the extracted order data, and if the order information is retained in the extracted order data Sales/purchase data creation means for creating purchase data for the designated business establishment; A customer master and a purchase containing a customer, an office of the company, and a classification as to whether or not the customer belongs to the company, based on the purchase data of the business office of all the order-receiving sources Outside of each business establishment that constitutes all the business establishments of the above-mentioned order source according to the supplier master including the destination, the business establishment of the above-mentioned company, and the classification as to whether the supplier belongs to the above-mentioned company and breakdown data creation means for creating breakdown data relating to breakdowns of sales, internal sales, external purchases, and internal purchases.

In addition, in the data creation device according to the present invention, the company may be a carrier, and the business may be transportation.

In addition, the data creation program according to the present invention provides an information processing apparatus having a control unit to receive order information related to an order received from an external company by an office of a company and to other offices of the company by the office that received the order. Origin order data that holds order information related to the order of the said work, and order information related to the order received by the said other business establishment from the said business establishment that received the order, and externally by the other business establishment that received the order referring to a storage unit for storing generated order data capable of holding order information relating to the ordering of the business to a company, extracting order data having a designated business establishment as an order originating business, and extracting the extracted order data create sales data of the specified business establishment based on the above, and if order information is held in the extracted order data, create sales/purchase data of the specified business establishment Means, based on the sales data of all the business establishments of the order-receiving sources and the purchase data of all the business establishments of the order-receiving sources linked to the order of the business from the external company, and the location of said company and the segmentation as to whether said customer belongs to said company and the supplier and the location of said company and whether said supplier belongs to said company Breakdown data on the breakdown of external sales, internal sales, external purchases, and internal purchases of each of the business establishments that make up all the above-mentioned order source business establishments according to the supplier master including the classification of It is intended to function as a breakdown data creation means for creating the

Further, a data creation method according to the present invention includes order information relating to an order received by an office of a company from an external company and the order received by the office of the order receiving source, executed by the control unit of an information processing apparatus having a control unit. Origin order data holding order information relating to ordering of said work to another business establishment of a company, and order receiving information relating to order acceptance by said other business establishment of said business from said business establishment of said orderer, Referencing the storage unit for storing generated order data capable of holding order information relating to the ordering of the work to the external company by the other office, extracting the order data with the designated office as the orderer office. , creating sales data for the specified business establishment based on the extracted order data, and creating purchase data for the specified business establishment when order information is held in the extracted order data. a step of creating sales/purchase data; and the sales data of all the business establishments of the order-receiving source and the purchases of all the business establishments of the order-receiving source linked to the order of the business from the external company. Based on the data, a customer master containing the customer, the office of the said company, and a classification as to whether the customer belongs to the said company, and the supplier, the office of the said company, and the supplier. External sales, internal sales, external purchases, and internal sales of each business establishment that constitutes all the above-mentioned order source business establishments according to the supplier master including classification as to whether it belongs to the said company and an itemized data creation step of creating itemized data relating to itemized purchases.

Advantageous Effects of Invention The present invention has the effect of making it possible to accurately grasp the sales and costs of each business office generated from one order when the work corresponding to one order is carried out at a plurality of business establishments. .

FIG. 1 is a diagram showing an example of the configuration of a data creation device. FIG. 2 is a diagram showing an example of the office master. FIG. 3 is a diagram showing an example of a customer master. FIG. 4 is a diagram showing an example of a supplier master. FIG. 5 is a diagram showing an example of an inter-store setting master. FIG. 6 is a diagram showing an example of a vehicle master. FIG. 7 is a diagram showing an example of order data. FIG. 8 is a diagram showing an example of sales data and purchase data. FIG. 9 is a diagram showing an example of sales data and purchase data. FIG. 10 is a diagram showing an example of a customer master and a supplier master. FIG. 11 is a diagram showing an example of management table data. FIG. 12 is a diagram showing an example of the flow of creating order data. FIG. 13 is a diagram showing an example of the flow of creating order data. FIG. 14 is a diagram showing an example of the flow of creating order data.

EMBODIMENT OF THE INVENTION Below, embodiment of the data preparation apparatus which concerns on this invention, a data preparation program, and a data preparation method is described in detail based on drawing. It should be noted that the present invention is not limited by this embodiment.

[1. composition]
An example of the configuration of the data creation device according to this embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a block diagram showing an example of the configuration of a data creation device.

The data creation device 100 is based on a commercially available server device. The data creation device 100 is installed, for example, at the headquarters or data center of a company (for example, a carrier, delivery company, etc.).

The data creation device 100 is connected to a PC 200 (for example, a desktop personal computer) used at each business office (for example, Osaka branch, Nagoya branch, etc.) via a network 300 (for example, the Internet, LAN (Local Area Network), etc.). or portable information processing devices such as notebook personal computers, PDAs (Personal Digital Assistants), smartphones, tablet personal computers, etc.).

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

The communication interface unit 104 communicably connects the data creation 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.

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. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 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 an office master 106a (see FIG. 2), a customer master 106b (see FIGS. 3 and 10), a supplier master 106c (see FIGS. 4 and 10), and an inter-store setting master 106d (see FIG. 5). ), vehicle master 106e (see FIG. 6), order data 106f (see FIG. 7) including original order data and generated order data of the present invention, sales data 106g (see FIGS. 8 and 9), purchase data 106h (see FIG. 8) , 9), management table data 106i (see FIG. 11) corresponding to the breakdown data of the present invention, and the like are stored. The customer master 106b includes the customer, the business office of the company, and whether the customer belongs to the company (inside the company) or to an external company (outside the company). In addition, the supplier master 106c includes the supplier, the company's place of business, and whether the supplier belongs to the company (inside the company) or an external company (outside the company). be The order data 106f includes order information (external order information) regarding an order received from an external company for work (for example, transportation/delivery work) by a company's office (office A) and the office (business Origin order data (record) that holds order information (internal order information) related to orders placed by business office A) to another business office of the same company (business office B), and other business office (business office B) retains order information (internal order information) related to orders for work from the place of business (place of business A) that is the source of the order, and order information ( Order data (record) that can hold external order information) is stored.

The control unit 102 is a CPU or the like that controls the data generation device 100 in an integrated manner. 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. Execute.

The control unit 102 functionally conceptually includes a sales/purchase data creation unit 102a (corresponding to sales/purchase data creation means of the present invention) and a management table data creation unit 102b (corresponding to breakdown data creation means of the present invention). , an order input unit 102c and an inter-store data creation unit 102d.

The sales/purchase data creation unit 102a refers to the order data 106f and refers to the specified office (for example, the operator of each office designates his/her own office via the screen (not shown) of the PC 200). is extracted as the order data (record) from which the order was placed, and based on the extracted order data (record), the sales data (record) of the specified business office is created, and the extracted order data ( It is information processing means for creating purchase data (record) of the specified establishment when order information is held in the record).

The management table data creation unit 102b stores the sales data (records) of all the business establishments that received orders from external companies, which are stored in the sales data 106g, and the purchase data 106h. Based on the purchase data (records) of all of the orderer's business establishments, according to the customer master 106b and the supplier master 106c, is an information processing means for creating management table data (records) relating to the breakdown of sales, internal sales, external purchases, and internal purchases.

The order input unit 102c allows the operator of each business office to input external order information and internal order information via an order input processing screen (not shown) of the PC 200, and based on the input information, the original order is processed. Information processing means for creating order reception data (record) corresponding to data.

The inter-store data creating unit 102d causes the operator of each office to input the office to which he/she belongs via the inter-shop data creation processing screen (see FIG. 12) of the PC 200, and the entered office is designated as the orderer. Information processing means for creating order data (record) corresponding to generated order data based on order data (record) corresponding to origin order data of a business establishment.

12, 13 and 14 for an example of the processing performed by the order input unit 102c and inter-store data creation unit 102d. 12 and 13 are diagrams showing an example of the process until the order data 106f shown in FIG. 7 is obtained. Also, FIG. 14 is a diagram showing an example of a processing flow including a business flow. Here, in FIG. 14, in step S4, the record of the supplier classification "2: in-house" of the supplier master 106c is selected, and in step S6, the chartered vehicle flag of "0: own vehicle" of the vehicle master 106e is selected. A record is selected, and in step S7, a record with a chartered vehicle flag "1: chartered vehicle" in the vehicle master 106e or a vehicle number CD that does not exist in the vehicle master 106e is selected, and in step S9, inter-store data shown in FIG. 12 is created. Order data after processing is created, and in step S10, order data after inter-store data creation processing shown in FIG. 13 is created.

[2. Specific example of processing]
Here, a specific example of processing executed by the data creation device 100 will be described with reference to each drawing.

In addition, in this description, it is assumed that the record shown in FIG. 7 is stored in the order data 106f. The upper two records in FIG. 7 were created by the processing of the order input unit 102c and inter-store data creation unit 102d for case 1 below, and the lower two records in FIG. 2 is created by the processing of the order input unit 102c and the inter-store data creation unit 102d. The order data 106f shown in FIG. 7 is obtained through the processes shown in FIGS.
・Case 1: The Osaka branch of a carrier receives an order for a transportation business from an external company, XX Logistics, and the Osaka branch places an order for the ordered transportation business with the same carrier’s Nagoya branch. The branch office carried out the transportation work for which the order was received (an example of a case in which multiple divisions carried out the work corresponding to one order).
・Case 2: The Osaka branch of a carrier receives an order for transportation from an external company, XX Logistics, and the Osaka branch places an order for the ordered transportation with the Nagoya branch of the same carrier. An order has been placed with XX Transport, which is a company, for the transportation work for which the order was received (an example of a case in which multiple business departments performed the work corresponding to one order).

[Step 1: Create sales and purchase data at each branch]
When an operator of the Osaka branch who uses the PC 200 installed in the Osaka branch designates the Osaka branch to which he/she belongs via a sales/purchase record screen (not shown), the sales/purchase data creation unit 102a By referring to the order data 106f, the order record having the specified Osaka branch as the order acceptance office is extracted, and based on the extracted order record, the sales data of the specified Osaka branch is created and extracted. If the received order data contains order information, purchase data for the specified Osaka branch is created. As a result, sales data 106g and purchase data 106h corresponding to the Osaka branch shown in FIG. 8 are created.

Similarly, when an operator at the Nagoya branch using the PC 200 installed at the Nagoya branch designates the Nagoya branch to which he/she belongs via the sales/purchase recording screen (not shown), sales/purchase data is created. The unit 102a refers to the order data 106f, extracts order records for which the specified Nagoya branch office is the order acceptance office, and based on the extracted order records, creates sales data for the specified Nagoya branch. If the order information is retained in the extracted order data, purchase data for the specified Nagoya branch is created. As a result, sales data 106g and purchase data 106h corresponding to the Nagoya branch shown in FIG. 9 are created. Regarding the purchase data 106h, since the order information is not held in the second order record from the top in FIG. 7, the purchase record is not created from the second order record.

[Step 2: Create management table data]
Based on the sales data 106g and purchase data 106h shown in FIG. 8 and the sales data 106g and purchase data 106h shown in FIG. According to the master 106c (see FIG. 10), management table data 106i including management table records for the Osaka branch and the Nagoya branch are created. As a result, management table data 106i shown in FIG. 11 is created.

Here, in the sales data 106g of the Osaka branch shown in FIG. 8, the customer is 0x logistics, and referring to the customer master 106b, the customer classification is "normal" ( That is, outside the company), the sales amount of the sales data 106g shown in FIG. 8 is totaled as normal sales (outside sales). Also, in the purchase data 106h of the Osaka branch shown in FIG. 8, the supplier is the Nagoya branch, and referring to the supplier master 106c, the purchase classification is "internal" for the combination of the Nagoya branch and the Osaka branch. Since it is set, the purchase amount of the purchase data 106h shown in FIG. 8 is counted as in-house purchase.

In addition, in the sales data 106g of the Nagoya branch shown in FIG. 9, the customer is the Osaka branch, and referring to the customer master 106b, the customer classification is set to "internal" for the combination of the Osaka branch and the Nagoya branch. Therefore, the sales amount of the sales data 106g shown in FIG. 9 is aggregated as in-house sales. In the purchase data 106h of the Nagoya branch shown in FIG. 9, the supplier is XX transportation. ' (that is, outside the company), the purchase amount of the purchase data 106h shown in FIG. 9 is aggregated as normal purchase (external purchase).

According to step 2, a management table record for each related branch that aggregates both cases 1 and 2 is created. As a result, it is possible to accurately grasp the sales and costs of each office generated from the order group when the work corresponding to the order group is performed at a plurality of offices.

In step 2, management table records for each related branch corresponding to each case may be created separately. In this case, for case 1, the management table record of the Osaka branch includes "regular sales amount: ¥300,000, internal sales amount: ¥0, normal purchase amount: ¥0, internal purchase amount: 240,000". Therefore, the management table record of the Nagoya branch includes "normal sales amount: 0 yen, internal sales amount: 240,000 yen, normal purchase amount: 0 yen, internal purchase amount: 0 yen". As for case 2, the management table record of the Osaka branch includes "regular sales amount: ¥400,000, internal sales amount: ¥0, normal purchase amount: ¥0, internal purchase amount: 300,000". Thus, the management table record for the Nagoya branch corresponding to case 2 is "Regular sales amount: ¥0, internal sales amount: ¥300,000, normal purchase amount: ¥250,000, internal purchase amount: ¥0". shall include. As a result, it is possible to accurately grasp the sales and costs of each business office generated from one order when the work corresponding to one order is carried out at a plurality of business offices.

As described above, according to the present embodiment, when work corresponding to one order or a group of orders is carried out at a plurality of business places, the sales and costs generated from one order or group of orders can be accurately calculated. Make it possible to capture.

In the past, when multiple business offices performed work for a single order, the business office that received the order had to understand the internal costs, while the business office that received the request had to understand the internal sales, actual vehicle delivery, and delivery. must be entered. Until now, it was common to calculate the sales and cost of sales at each business site at the time of internal trading by multiplying the total amount of orders for which work occurred by a certain rate. As a result, it was difficult to accurately grasp the external balance and internal balance of payments. However, according to the present embodiment, by linking the original order data of the work (original order data) and the order data of the actual work (occurred order data), the cost incurred in one order and the internal transfer amount can be reduced. It has become possible to manage, and it has become easier to manage income and expenditure inside and outside the company. Furthermore, this has made it possible to analyze internal and external sales and costs, and use the analysis results to optimize the amount of sales per order in the future.

[3. 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 regard to the data generation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the data generation device 100, particularly the processing functions performed by the control unit, may be implemented in whole or in part 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 device to execute the processing described in the present embodiment, and the data creation device if 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.

In addition, this computer program may be stored in an application program server connected to the data creation 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" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (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 data creation 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. Also, the data creation device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment in the device.

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 particularly useful in industries such as the transportation industry in which intra-company transactions occur.

100 data creation device (server (eg, web server, etc.))
102 control unit
102a Sales/purchase data creation unit
102b Management table data creation unit
102c Order input unit
102d inter-store data creation unit 104 communication interface unit 106 storage unit
106a Office master
106b Customer master
106c Supplier Master
106d Inter-store setting master
106e vehicle master
106f Order data
106g sales data
106h purchase data
106i management table data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (4)

A data creation device comprising a control unit,
The control unit
Origin order data that retains order information relating to an order received from an external company by a place of business of a company and order information relating to an order for said work to another place of business of said company by said place of business of the order-receiving source, and said other business store received order data that can hold order information related to the order received by the business office for the work from the business establishment that is the order source and that can hold order information related to the order for the work to an external company by the other business establishment that is the order source; Referencing the storage unit, extracting order data for which the specified business office is the order receiving business, creating sales data for the specified business based on the extracted order data, and receiving the extracted order sales/purchase data creation means for creating purchase data for the specified business establishment when order information is held in the data;
Based on the sales data of all the business establishments of the order recipient and the purchase data of all the business establishments of the order recipient associated with the order of the business from the external company, the customer and the A customer master containing a company's place of business and classification as to whether the said customer belongs to the said company, and information about the supplier, the said company's place of business and whether the said supplier belongs to the said company According to the supplier master including the categories, create breakdown data on the breakdown of external sales, internal sales, external purchases, and internal purchases of each business establishment that constitutes all the above-mentioned order source business establishments. a breakdown data creation means for
to provide
A data creation device characterized by: said entity is a carrier;
that the business is transportation;
The data creation device according to claim 1, characterized by: an information processing device comprising a control unit,
Origin order data that retains order information relating to an order received from an external company by a place of business of a company and order information relating to an order for said work to another place of business of said company by said place of business of the order-receiving source, and said other business store received order data that can hold order information related to the order received by the business office for the work from the business establishment that is the order source and that can hold order information related to the order for the work to an external company by the other business establishment that is the order source; Referencing the storage unit, extracting order data for which the specified business office is the order receiving business, creating sales data for the specified business based on the extracted order data, and receiving the extracted order sales/purchase data creation means for creating purchase data for the specified business establishment when order information is held in the data;
Based on the sales data of all the business establishments of the order recipient and the purchase data of all the business establishments of the order recipient associated with the order of the business from the external company, the customer and the A customer master containing a company's place of business and classification as to whether the said customer belongs to the said company, and information about the supplier, the said company's place of business and whether the said supplier belongs to the said company According to the supplier master including the categories, create breakdown data on the breakdown of external sales, internal sales, external purchases, and internal purchases of each business establishment that constitutes all the above-mentioned order source business establishments. Breakdown data creation means for
Data creation program for functioning as Executed by the control unit of an information processing device comprising a control unit,
Origin order data that retains order information relating to an order received from an external company by a place of business of a company and order information relating to an order for said work to another place of business of said company by said place of business of the order-receiving source, and said other business store received order data that can hold order information related to the order received by the business office for the work from the business establishment that is the order source and that can hold order information related to the order for the work to an external company by the other business establishment that is the order source; Referencing the storage unit, extracting order data for which the specified business office is the order receiving business, creating sales data for the specified business based on the extracted order data, and receiving the extracted order a sales/purchase data creation step of creating purchase data for the specified business establishment when order information is held in the data;
Based on the sales data of all the business establishments of the order recipient and the purchase data of all the business establishments of the order recipient associated with the order of the business from the external company, the customer and the A customer master containing a company's place of business and classification as to whether the said customer belongs to the said company, and information about the supplier, the said company's place of business and whether the said supplier belongs to the said company According to the supplier master including the categories, create breakdown data on the breakdown of external sales, internal sales, external purchases, and internal purchases of each business establishment that constitutes all the above-mentioned order source business establishments. a breakdown data creation step for
A data creation method comprising:

Images