JP2015228149A - Domestic marine transportation management system, server, method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To uniformly manage a fuel purchased amount, a fuel balance and a fuel consumption amount in respective ships based on information accumulated to a marine transportation company.SOLUTION: A domestic marine transportation management server includes: a data processing unit for storing fuel purchase data and fuel measured data in respective ships to a managing data base; a data search unit for reading out purchased amount data and balance data of a prior month by searching for the fuel purchased data and the fuel measured data using a ship name code and a product name code as search key words when the fuel measured data for the current month is received from a client terminal; a data operation unit for calculating the current month fuel consumption amount by adding a current month fuel consumption amount to the prior month fuel balance for every product name of fuel; and a network connection unit for displaying the prior month fuel balance, the current month fuel purchased amount, the current month fuel balance, and the current month fuel consumption amount to the client terminal along with the measured date and the ship name.

Description

  The present invention relates to a domestic shipping management system for managing data relating to domestic shipping in a shipping company. Furthermore, the present invention relates to a domestic shipping management server, a domestic shipping management method, and a domestic shipping management program used in such a domestic shipping management system.

  In the domestic shipping business, shipping companies use ships to carry packages in response to requests from shippers. In order to operate a ship, a shipping company purchases fuel such as heavy oil from a fuel supplier and pays in accordance with a bill issued by the fuel supplier. However, in the past, the amount of fuel purchased and the amount of fuel purchased described in the bill issued by the fuel supplier are often simply stored in a list, and shipping companies store the fuel storage amount ( Fuel balance) and fuel consumption could not be accurately grasped.

  If shipping companies do not accurately grasp the amount of fuel purchased, the balance of fuel, and the amount of fuel consumed for each ship, it will hinder ship operations. Therefore, in the coastal shipping business, there is a demand for a coastal shipping management system that can centrally manage the amount of fuel purchased, the fuel balance, and the fuel consumption in each ship.

  In addition, simply storing the fuel purchase amount described in the invoice issued by the fuel supplier in the list is not sufficient in the accounting process. For example, the fuel consumption amount is obtained from another list and the accounting is performed. It was necessary to manually enter the amount of fuel purchased and the amount of fuel consumed into the system and perform journalizing work.

  As a related technology, Patent Document 1 discloses a series of products related to products between different companies by connecting a computer of a management center, a via terminal, a vendor terminal, and a terminal of a warehouse / transport company through a communication network. A logistics management system that performs unified management of logistics related information is disclosed.

  This distribution management system is based on the ordering information of products from the website provided by the management center computer to the via terminal via the communication network, and the ordering of the goods at the via terminal, the invoice and invoice from the vendor terminal, Receipt of ordered products, logistics-related information including information on payment to vendor terminals, orders for products from vendor terminals, shipping instructions to warehouse / transport company terminals, invoices and invoices from warehouse / transport company terminals, Logistics-related information, including payment receipt information from via terminals, payment information to warehouse / transport company terminals, shipping instructions for warehouse / transport company terminals, product shipment processing, invoices to vendor terminals and billing Logistics-related information, including payment receipt information from vendors and vendor terminals, is collected via the communication network and centrally managed by a computer in the management center It has been.

  According to the distribution management system of Patent Document 1, various information management such as inventory confirmation and inventory at a via terminal, a vendor terminal, a warehouse / transport company terminal is centrally managed via a communication network by a computer of a management center. Can do. However, even if the physical distribution management system of Patent Document 1 is used in the domestic shipping business, it is not possible to manage the fuel balance and fuel consumption in each ship.

JP 2005-174031 A (Abstract, Claim 2, Paragraph 0010, FIG. 1)

  Therefore, in view of the above points, the first object of the present invention is to centrally manage the fuel purchase amount, the fuel balance, and the fuel consumption amount in each ship based on the information accumulated in the shipping company. It is to provide a domestic shipping management system. A second object of the present invention is to automatically create an accounting table that can be used in an accounting system based on the amount of fuel purchased and the amount of fuel consumed for each ship. A third object of the present invention is to provide a domestic shipping management server, a domestic shipping management method, and a domestic shipping management program used in such a domestic shipping management system.

  In order to solve the above problems, a coastal shipping management server according to one aspect of the present invention, together with at least one client terminal connected via a network, in order to manage data relating to coastal shipping in a shipping company. The domestic shipping management server used is a recording unit that records a management database that stores data related to the domestic shipping of a shipping company, date data that identifies the shipping date of fuel purchased by the shipping company, and purchased fuel. Receiving from the at least one client terminal fuel purchase data including a ship name code for specifying a ship name of a ship to be supplied, a product name code for specifying a product name of fuel, and purchase amount data for specifying a fuel purchase amount; A plurality of items included in the fuel purchase data are stored in the management database in association with each other, and Measurement date data that identifies the measurement date when the fuel balance was measured in the ship used by the ship, a ship name code that identifies the ship name of the ship where the fuel balance was measured, a product name code that identifies the fuel product name, and Fuel measurement data including balance data specifying the fuel balance at the end of the month for each fuel product name is received from the at least one client terminal, and a plurality of items included in the fuel measurement data are associated with each other in the management database. Purchasing fuel using the received ship name code and product name code as search keywords when the fuel measurement data for the current month is received from the client terminal together with the data processing unit to be stored and the fuel purchase data and fuel measurement data search request Search the data, read the date data associated with the ship name code and product name code, and receive the measurement Extract date data corresponding to the measurement date specified by the month data, read the purchase quantity data associated with the extracted date data, and use the received ship name code and product name code as search keywords Search the fuel measurement data, read the measurement date data associated with the ship name code and the product name code, and extract the measurement date data corresponding to the previous month of the measurement date specified by the received measurement date data. The data retrieval unit that reads the balance data of the previous month associated with the extracted measurement date data, and the fuel purchase name data that is identified by the received product name code are identified by the read purchase amount data. Calculate the total purchase amount data for the current month, which represents the fuel purchase amount for the current month, by adding the total fuel purchase amount, and specify the balance data for the previous month The current month fuel balance is added to the previous month fuel balance, and the current month fuel balance is subtracted from the current month fuel balance specified by the received current month balance data. The balance of the previous month for each fuel product name specified by the received product name code, together with the measurement date and ship name specified by the received measurement date data and ship name code respectively. Fuel information including the previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption specified by the data, current month total purchase amount data, current month balance data, and current month consumption data, respectively. A network connection unit to be displayed on the display unit of the client terminal.

  The coastal shipping management system according to one aspect of the present invention responds to a search command when the domestic shipping management server according to any aspect of the present invention and fuel measurement data for the current month are input, Along with the search request for fuel purchase data and fuel measurement data, the fuel measurement data of the current month is sent to the domestic shipping management server, and based on the file received from the domestic shipping management server, along with the measurement date and ship name, Each fuel item includes at least one client terminal that displays fuel information including a previous month fuel balance, a current month fuel purchase amount, a current month fuel balance, and a current month fuel consumption amount on a display unit.

  A coastal shipping management method according to one aspect of the present invention is a coastal shipping management method used for managing data related to domestic shipping in a shipping company, and specifies a shipping date of fuel purchased by the shipping company. At least one fuel purchase data including date data, a ship name code that identifies a ship name of a ship to which the purchased fuel is supplied, a product name code that identifies a fuel product name, and a purchase quantity data that identifies a fuel purchase quantity A step (a) of receiving a plurality of items contained in the fuel purchase data in association with each other and storing them in the management database, and a measurement date when the fuel balance is measured in the ship used by the shipping company Measurement date data for identifying fuel, ship name code for identifying the ship name of the ship whose fuel balance was measured, product name code for identifying the fuel product name, and each fuel product name Receiving fuel measurement data including balance data specifying a fuel balance at the end of the month from the at least one client terminal, and storing a plurality of items included in the fuel measurement data in the management database in association with each other (b) ) And the fuel purchase data and fuel measurement data search request, and when the fuel measurement data for the current month is received from the client terminal, the fuel purchase data is searched using the received ship name code and product name code as search keywords. The date data associated with the ship name code and product name code is read out, the date data corresponding to the measurement date specified by the received measurement date data is extracted, and the purchase associated with the extracted date data is extracted. A key to read the quantity data and search the received ship name code and product name code The measurement year corresponding to the previous month of the measurement date specified by the received measurement date data is retrieved by searching the fuel measurement data and reading the measurement date data associated with the ship name code and product name code. Step (c) of reading out the month data and reading out the balance data of the previous month associated with the extracted measurement year / month data, and the purchase read out for each fuel item name specified by the received item name code The total fuel purchase amount for the current month, which represents the fuel purchase amount for the current month, is calculated by summing the fuel purchase amount specified by the volume data, and the fuel purchase amount for the current month is compared to the fuel balance for the previous month specified by the balance data for the previous month. And subtracting the current fuel balance specified by the received balance data for the current month to determine the current month's fuel consumption amount. For each fuel product name specified by the received product name code, together with the measurement date and ship name specified by the received measurement date data and ship name code respectively. Includes previous month fuel balance, current month fuel balance, current month fuel balance, current month fuel consumption, current month balance data, current month balance data, and current month consumption data, respectively. (E) displaying fuel information on a display unit of the client terminal.

  A domestic shipping management program according to one aspect of the present invention is a domestic shipping management program used in a domestic shipping management server for managing data relating to domestic shipping in a shipping company, which is purchased by a shipping company. Includes date data that identifies the date of shipment of fuel, ship name code that identifies the name of the ship to which the purchased fuel is supplied, product name code that identifies the name of the fuel, and purchase quantity data that identifies the amount of fuel purchased A procedure (a) of receiving fuel purchase data from at least one client terminal and associating a plurality of items included in the fuel purchase data with each other and storing them in a management database; and a fuel balance in a ship used by a shipping company The measurement date data that identifies the measurement date, the ship name code that identifies the ship name of the ship whose fuel balance was measured, and the fuel product name The fuel measurement data including the product name code and the balance data specifying the fuel balance at the end of the month for each fuel product name is received from the at least one client terminal, and a plurality of items included in the fuel measurement data are mutually received. When the fuel measurement data for the current month is received from the client terminal together with the procedure (b) for storing in the management database in association with the search request for the fuel purchase data and the fuel measurement data, the received ship name code and product name code are received. Search the fuel purchase data as a search keyword, read the date data associated with the ship name code and the product name code, extract the date data corresponding to the measurement date specified by the received measurement date data Read the purchase volume data associated with the extracted date data and receive the ship Search the fuel measurement data using the code and product name code as a search keyword, read the measurement date data associated with the ship name code and product name code, and the previous month of the measurement date specified by the received measurement date data For each item name of the fuel specified by the procedure (c) of reading out the measurement date data corresponding to the above and reading the balance data of the previous month associated with the extracted measurement date data, and the received item name code, By summing the fuel purchase amount specified by the read purchase amount data, the total purchase amount data for the current month representing the fuel purchase amount for the current month is calculated, and the fuel balance for the previous month specified by the balance data for the previous month is calculated. , By adding the fuel purchase amount for the current month and subtracting the current fuel balance specified by the received balance data for the current month. Identifies by the received product name code together with the measurement date and ship name specified by the procedure (d) for calculating the consumption data for the current month specifying the amount of consumption and the received measurement date data and ship name code, respectively. For each fuel product name, the previous month fuel balance, current month fuel balance, current month fuel balance, current month total purchase amount data, current month balance data, and current month consumption data, respectively, Then, the CPU is caused to execute the procedure (e) for displaying the fuel information including the fuel consumption for the current month on the display unit of the client terminal.

  According to one aspect of the present invention, when a shipping company reports information on fuel purchase and information on a ship's fuel balance in a management database in association with a ship name code, the fuel balance for the current month is reported from the ship. In addition, by inputting the information on the fuel balance of the current month to the client terminal together with the ship name code, the fuel information on the ship is displayed on the display unit of the client terminal, so the fuel purchase amount, the fuel balance, and , Fuel consumption can be centrally managed.

The figure which shows the structural example of the coastal shipping management system which concerns on one Embodiment of this invention. The figure which shows the example of the fuel purchase input screen displayed on the display part of a client terminal. The figure which shows structures, such as fuel purchase data stored in the payment table of a management database. The figure which shows the example of the fuel purchase input screen at the time of the search displayed on the display part of a client terminal. The figure which shows the example of the stored goods input screen displayed on the display part of a client terminal. The figure which shows structures, such as fuel measurement data stored in the payment table of a management database. The figure which shows the example of the updated stored goods input screen displayed on the display part of a client terminal. The figure which shows the example of a 1st accounting table. The figure which shows the example of a 2nd accounting table. The flowchart which shows operation | movement of the domestic shipping management server shown in FIG.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
<System configuration>
FIG. 1 is a diagram illustrating a configuration example of a coastal shipping management system according to an embodiment of the present invention. This coastal shipping management system is provided in a shipping company that operates the coastal shipping business. As shown in FIG. 1, the domestic shipping management system includes a domestic shipping management server 10 for managing data relating to domestic shipping, and a domestic shipping management server via a network such as a LAN (local area network). 10 and at least one client terminal 20 connected to the client terminal 10 and at least one printer 30 connected to the client terminal 20 via a network or the like.

  The client terminal 20 includes, for example, a personal computer provided with an operation unit including a keyboard and a mouse used for inputting various data and commands, and a display unit for displaying an image such as an input screen or a search result screen. You can use a computer. The printer 30 is used to create a navigation instruction for a ship, a shipping request for a fuel supplier, a fare bill for a shipper, and the like.

  The domestic shipping management server 10 includes an operation unit 11, a network connection unit 12, a data processing unit 13, a data search unit 14, a data calculation unit 15, a recording unit 16, and a display unit 17. . Here, at least a part of the network connection unit 12 to the data calculation unit 15 includes a central processing unit (CPU) and software (inland shipping management program) for causing the CPU to perform various processes. May be. The software is recorded on the recording medium of the recording unit 16.

  In addition to the above software, the recording unit 16 records a management database that stores data relating to the domestic shipping of the shipping company. As a recording medium in the recording unit 16, an external hard disk, a flexible disk, various memories, a CD-ROM, a DVD-ROM, or the like can be used in addition to the built-in hard disk.

  The operation unit 11 includes, for example, a keyboard and a mouse, and is used to operate the domestic shipping management server 10. The network connection unit 12 includes, for example, an HTTP (Hypertext Transfer Protocol) server unit, a TCP / IP (Transport Control Protocol / Internet Protocol) control unit, and the like, and an input screen or a search result screen is displayed on the display unit of the client terminal 20. And the like, and data is transmitted to and received from the client terminal 20 via the network.

  The data processing unit 13 processes data received from the client terminal 20 via the network connection unit 12, generates necessary data, stores the data in the management database, and records the data in the recording unit 16. The data search unit 14 can search for data in the management database recorded in the recording unit 16. The data calculation unit 15 performs a calculation based on the data read by the data search unit 14. The display unit 17 includes an LCD display or the like and displays an image such as an operation screen.

  The management database recorded in the recording unit 16 includes a business daily report table that stores business data related to business daily reports, a payment table that stores payment data related to payments to fuel companies, port agents, repair companies, etc., and a shipper A billing table for accumulating billing data for billing, a first accounting table used to create a balance sheet, and a second accounting table used to create a profit and loss statement. The payment data includes fuel purchase data, payment amount data, fuel measurement data, fuel increase / decrease data, and fuel amount data.

  In addition, the management database includes a supplier master table that stores a supplier code and data related to a supplier correspondingly, a ship name master table that stores a ship name code and data related to a ship name, and a product name code. And a product name master table that stores data relating to product names and character data representing port codes and port names, and corresponding location data and character data representing location names at the port. Including a port master table to store.

Next, the operation of the coastal shipping management system shown in FIG. 1 will be described.
<Input fuel purchase data>
When the shipping company purchases fuel from the fuel supplier, the operator of the shipping company operates the operation unit of the client terminal 20 to access the inland shipping management server 10 via the network.

  The network connection unit 12 of the coastal shipping management server 10 displays a menu on the display unit of the client terminal 20 when receiving access from the client terminal 20 via the network. When the operator selects “fuel purchase input” from the menu displayed on the display unit of the client terminal 20, the network connection unit 12 of the coastal shipping management server 10 displays the fuel purchase input screen on the display unit of the client terminal 20. To display.

  FIG. 2 is a diagram illustrating an example of a fuel purchase input screen displayed on the display unit of the client terminal. When the fuel purchase input screen is displayed on the display unit of the client terminal 20, the operator operates the operation unit of the client terminal 20, so that the shipping company specifies the purchase source code for purchasing the fuel and the fuel shipment. Fuel including date data for specifying the date, ship name code for specifying the ship name of the ship to which the purchased fuel is supplied, product name code for specifying the name of the fuel, purchase quantity data for specifying the fuel purchase quantity (quantity), etc. Enter purchase data into the fuel purchase entry screen.

  For example, a shipping company purchased 65 kiloliters of A heavy oil and 65 kiloliters of heavy fuel oil C on March 10, 2008 from Japan ○○ Co., Ltd., a fuel supplier, and the purchased heavy oil A and heavy oil C The case where it is supplied to the ship is described. The operator of the shipping company inputs the purchaser code “001111” for specifying the fuel purchaser “Japan XX Co., Ltd.” on the fuel purchase input screen.

  Further, for the heavy oil A, the operator specifies date data “2008/03/10” for specifying the fuel shipment date, ship name code “001234” for specifying the ship name “Nippon Maru” of the ship to which the purchased fuel is supplied, The product name code “00123” specifying the fuel product name “A heavy oil”, the purchase amount data “65.000” kiloliters specifying the fuel purchase amount (quantity), and the like are input to the fuel purchase input screen.

  Further, for C heavy oil, the operator specifies date data “2008/03/10” for specifying the fuel shipment date, ship name code “001234” for specifying the ship name “Nippon Maru” of the ship to which the purchased fuel is supplied, The product name code “00124” specifying the fuel product name “C heavy oil”, the purchase amount data “65.000” kiloliters specifying the fuel purchase amount (quantity), and the like are input to the fuel purchase input screen.

  Note that the same payment destination code “001111” as the purchase destination code may be displayed as a default, or the operator may input the payment destination code. In addition, the operator may input the order numbers “00001110” and “000001111”, or the data processing unit 13 of the domestic shipping management server 10 may automatically issue the order numbers as serial numbers.

  Shipping companies sometimes use their own ships to carry loads, and sometimes borrow ships from ship owners (ship owners) to carry loads. In addition, an agreement may be established between the shipping company, the shipowner and the shipper regarding the burden of fuel purchase costs. There are cases where the shipping company bears the fuel purchase cost, the shipowner bears the fuel purchase cost, and the shipper bears the fuel purchase cost in accordance with the arrangement regarding the burden of the fuel purchase cost. If the shipowner bears the fuel purchase cost, the shipping company will replace the fuel purchase cost with the shipowner. If the shipper bears the fuel purchase cost, the shipping company will purchase the fuel to the shipper. It will change the cost.

  Therefore, the operator inputs a replacement classification code indicating the replacement classification and a shipowner code or shipper code for specifying the shipowner or shipper as necessary on the fuel purchase input screen. For example, when the shipping company bears the fuel purchase cost, the operator inputs the replacement classification code “0” representing the shipping company's burden (normal). Alternatively, the replacement classification code “0” may be input in advance as a default.

  On the other hand, when the shipping company replaces the fuel purchase cost with the shipowner, the operator inputs a replacement classification code “1” indicating the replacement to the shipowner and a shipowner code for identifying the shipowner. Alternatively, when the shipping company renews the fuel purchase cost for the shipper, the operator inputs a replacement classification code “2” indicating the return to the shipper and a shipper code indicating the shipper.

  When the operator clicks a “search” button in the fuel purchase input screen using a mouse or the like, the client terminal 20 transmits fuel purchase data to the domestic shipping management server 10 via the network. The data processing unit 13 and the data search unit 14 of the coastal shipping management server 10 receive fuel purchase data from the client terminal 20 via the network connection unit 12.

  The data search unit 14 reads out character data representing the fuel purchase destination “Japan XX Co., Ltd.” by referring to the supplier master table based on the purchase destination code “001111”. The data search unit 14 reads character data representing the ship name “Nippon Maru” by referring to the ship name master table based on the ship name code “001234”. Further, the data search unit 14 reads the character data representing the fuel product names “A heavy oil” and “C heavy oil” by referring to the product name master table based on the product name codes “00123” and “00124”.

  The network connection unit 12 generates a file (HTML (hypertext markup language) file or the like) representing the updated fuel purchase input screen based on the received fuel purchase data and the read character data. And transmitted to the client terminal 20 via the network. Thereby, in the display part of the client terminal 20, the fuel purchase destination “Japan XX Co., Ltd.”, the ship name “Nippon Maru” of the ship to which the purchased fuel is supplied, the fuel product name “A heavy oil” and “C heavy oil” A fuel purchase input screen including “and the like” is displayed.

  When the operator clicks a “registration” button in the fuel purchase input screen using a mouse or the like, a registration command is transmitted from the client terminal 20 to the domestic shipping management server 10 via the network. The data processing unit 13 that has received the registration command via the network connection unit 12 of the domestic shipping management server 10 stores and registers the fuel purchase data in the payment table of the management database. In this way, fuel purchase data related to fuel purchased in the past is accumulated in the payment table of the management database.

  FIG. 3 is a diagram showing the structure of fuel purchase data and the like stored in the payment table of the management database. As shown in FIG. 3, a plurality of items included in the fuel purchase data are associated with each other and stored in the payment table of the management database. The payment amount data, which will be described later, is also stored in the payment table in association with the fuel purchase data. In FIG. 3, as an example, payment amount data representing a payment amount without consumption tax is shown.

<Search for fuel purchase data>
By using the coastal shipping management system shown in FIG. 1, it is possible to search for fuel purchase data related to fuel purchased in the past and calculate the amount of payment. The operator operates the operation unit of the client terminal 20 to access the coastal shipping management server 10 via the network.

  The network connection unit 12 of the coastal shipping management server 10 displays a menu on the display unit of the client terminal 20 when receiving access from the client terminal 20 via the network. When the operator selects “fuel purchase input” from the menu displayed on the display unit of the client terminal 20, the network connection unit 12 of the coastal shipping management server 10 displays the fuel purchase input screen on the display unit of the client terminal 20. To display.

  The operator operates the operation unit of the client terminal 20 to identify the purchaser code for identifying the purchaser where the shipping company purchased the fuel and the start date of the set period for setting the range of the fuel shipment date to be searched. The first data to be input and the second data specifying the end date of the set period are input to the fuel purchase input screen. The set period for setting the range of fuel shipment dates to be searched may be one month. However, since the fuel price is retroactively revised every three months, it is desirable to set the set period to three months.

  For example, if the price of fuel was revised at the end of March 2008, when the fuel supplier issues a bill for March 2008, the amount charged for fuel shipped in March 2008 will be For fuels that are calculated by price and shipped in January and February 2008, according to the revised fuel prices, the invoices for the January and February 2008 invoices and the revised prices are used. The difference from the charged amount is charged or reduced. Therefore, in the following, a case where the set period is 3 months will be described.

  FIG. 4 is a diagram illustrating an example of a fuel purchase input screen at the time of search displayed on the display unit of the client terminal. For example, in April 2008, when an invoice for March 2008 arrived at the shipping company from Japan ○○ Co., Ltd., the fuel supplier, ○ Specify the purchaser code “001111” specifying “Co., Ltd.”, the first data “2008/01/01” specifying the start date of the set period in the “Purchase date” column, and the end date of the set period The second data “2008/03/31” to be input is input to the fuel purchase input screen.

  When the operator clicks the “search” button in the fuel purchase input screen using a mouse or the like, the client terminal 20 responds to the search command and sends a purchase destination code, a first purchase request along with a fuel purchase data search request. The data and the second data are transmitted to the domestic shipping management server 10 via the network. The data search unit 14 of the domestic shipping management server 10 receives the purchase code, the first data, and the second data together with the fuel purchase data search request from the client terminal 20 via the network connection unit 12. To do.

  The data search unit 14 reads out the date data associated with the purchase destination code by searching the fuel purchase data stored in the payment table of the management database using the received purchase destination code as a search keyword. The data search unit 14 extracts date data corresponding to the date from the start date to the end date of the set period by comparing the read date data with the first and second data.

  Here, the data search unit 14 uses the extracted date data for the fuel in the first period (March 2008 corresponding to the last month in the set period) in which the purchase amount is calculated according to the revised fuel price. The second period in which the adjustment amount is calculated according to the difference between the date data for specifying the shipping date and the fuel price before the revision and the fuel price after the revision (corresponds to the month before the last month in the set period) And date data for specifying the fuel shipment date in January and February 2008).

  Further, the data search unit 14 reads out the order number, ship name code, replacement classification code, ship owner / shipper code, product name code, purchase quantity data, etc. associated with the date data specifying the fuel shipment date in the first period. Then, they are supplied to the network connection unit 12 together with the date data. In addition, the data search unit 14 reads out the ship name code, replacement classification code, shipowner / shipper code, product name code, purchase quantity data, etc. associated with the date data for specifying the fuel shipment date in the second period. Is supplied to the network connection unit 12.

  At the same time, the data search unit 14 reads the character data representing the fuel purchase destination “Japan XX Co., Ltd.” by referring to the supplier master table based on the received purchase destination code “001111”. The data search unit 14 reads character data representing the ship name “Nippon Maru” by referring to the ship name master table based on the ship name code “001234” associated with the extracted date data. Further, the data search unit 14 refers to the product name master table based on the product name codes “00123” and “00124” associated with the extracted date data, so that the fuel product names “A heavy oil” and “C heavy oil”. Character data representing is read. The read character data is supplied to the network connection unit 12.

  The network connection unit 12 purchases fuel in the first period together with the fuel purchase destination specified by the received purchase destination code and the start date and end date of the set period specified by the first and second data. Input the unit price data representing the unit price of the fuel corresponding to the information, and the difference unit price data representing the unit price difference associated with the price revision of the fuel corresponding to the fuel purchase information in the second period A file (HTML file or the like) representing a fuel purchase input screen including an input field for performing the operation is generated. The network connection unit 12 displays the updated fuel purchase input screen on the display unit of the client terminal 20 by transmitting the generated file to the client terminal 20 via the network.

  For example, as shown in FIG. 4, the client terminal 20 uses the purchase destination code “001111”, the fuel purchase destination “Japan XX Co.”, the set period of time based on the file received from the domestic shipping management server 10. From the start date “2008/01/01” to the end date “2008/03/31” of the set period, the “purchase date” column, and the unit price data input column corresponding to the fuel purchase information in the first period A fuel purchase input screen including an “ordinary” column and an “adjustment” column indicating an input column for differential unit price data corresponding to the fuel purchase information in the second period is displayed on the display unit. The purchase number “00000100” may be input by the operator, or the data processing unit 13 of the coastal shipping management server 10 may automatically issue a serial number.

<Calculation of payment amount>
Further, the operator inputs the unit price data representing the unit price of the fuel and the difference unit price data representing the difference unit price associated with the revision of the fuel price to the client terminal 20 based on the invoice issued from the fuel supplier to the shipping company. Then, the domestic shipping management server 10 can calculate the payment amount. The unit price for the difference is a value obtained by subtracting the unit price at the previous price revision from the unit price at the current price revision. Therefore, the difference unit price becomes a positive value when the unit price at the current price revision is higher than the unit price at the previous price revision, and at the time of the current price revision than the unit price at the previous price revision. It becomes negative when the unit price is lower.

  The operator operates the operation unit of the client terminal 20 to input unit price data in the “unit price” column corresponding to the fuel purchase information in the “normal” column and to correspond to the fuel purchase information in the “adjustment” column. Enter the unit price difference data in the “Unit Price” field. Further, when the operator clicks the “search” button in the fuel purchase input screen using a mouse or the like, the client terminal 20 sends the unit price corresponding to each input field to the domestic shipping management server 10 via the network. Data and differential unit price data are transmitted.

  The data processing unit 13 and the data calculation unit 15 of the coastal shipping management server 10 receive the unit price data and the difference unit price data corresponding to the respective input fields from the client terminal 20 via the network connection unit 12. In addition, the data calculation unit 15 acquires purchase amount data corresponding to each input field from the data search unit 14.

  The data calculation unit 15 calculates purchase price data representing the purchase price by obtaining a purchase price that is the product of the unit price of fuel represented by the received unit price data and the corresponding fuel purchase quantity. Here, the data calculation unit 15 calculates purchase amount data representing the purchase amount without consumption tax, purchase amount data representing the amount of consumption tax, and purchase amount data representing the purchase amount including consumption tax. Also good.

  Further, the data calculation unit 15 calculates adjustment amount data representing the adjustment amount by obtaining an adjustment amount that is the product of the difference unit price represented by the received difference unit price data and the corresponding fuel purchase amount. Here, the data calculation unit 15 calculates adjustment amount data representing the adjustment amount excluding consumption tax, adjustment amount data representing the amount of consumption tax, and adjustment amount data representing the adjustment amount including consumption tax. Also good.

  Further, the data calculation unit 15 calculates total purchase amount data representing the total purchase amount by totaling the purchase amounts of the fuel shipped in the first period. Further, the data calculation unit 15 calculates the total adjustment amount data representing the total adjustment amount by summing the adjustment amounts of the fuel shipped in the second period. Next, the data calculation unit 15 calculates total amount data representing the total amount by adding the total purchase amount and the total adjustment amount.

  The network connection unit 12 includes the unit price and the difference unit price represented by the received unit price data and the difference unit price data, the purchase amount data calculated by the data calculation unit 15, the total purchase amount data, and the adjustment amount together with the fuel purchase information. A file (HTML) representing a fuel purchase input screen further including purchase amount, total purchase amount, adjustment amount, total adjustment amount, and total amount, respectively represented by data, total adjustment amount data, and total amount data File). The network connection unit 12 displays the updated fuel purchase input screen on the display unit of the client terminal 20 by transmitting the generated file to the client terminal 20 via the network.

  When the operator clicks a “registration” button in the fuel purchase input screen showing the search result using a mouse or the like, a registration command is transmitted from the client terminal 20 to the domestic shipping management server 10 via the network. The data processing unit 13 of the coastal shipping management server 10 includes the unit price data and the difference unit price data received from the client terminal 20 via the network connection unit 12, the purchase amount data and the adjustment amount data calculated by the data calculation unit 15. Are associated with the corresponding fuel purchase data and stored in the payment table of the management database as payment amount data (see FIG. 3).

<Input fuel measurement data>
Each ship that the shipping company uses to carry the cargo reports the amount of fuel stored at the end of the month (fuel balance) to the shipping company. When the shipping company receives a report on the fuel balance from each ship, the shipping company operator operates the operation unit of the client terminal 20 to access the inland shipping management server 10 via the network.

  The network connection unit 12 of the coastal shipping management server 10 displays a menu on the display unit of the client terminal 20 when receiving access from the client terminal 20 via the network. When the operator selects “stored item input” from the menu displayed on the display unit of the client terminal 20, the network connection unit 12 of the domestic shipping management server 10 displays the stored item input screen on the display unit of the client terminal 20. To display.

  FIG. 5 is a diagram illustrating an example of a stored item input screen displayed on the display unit of the client terminal. The stored goods input screen shown in FIG. 5 has an input field for inputting measurement date data for specifying the measurement date (processing date) and an input for inputting a ship name code for specifying the ship name of the ship. Field, an input field for inputting a product name code for specifying a fuel product name, and an input field for inputting balance data for the current month for specifying the fuel balance of the current month (balance at the end of the current month) for each fuel product name. It is out.

  When the stored item input screen is displayed on the display unit of the client terminal 20, the operator operates the operation unit of the client terminal 20 to measure the measurement date (processing) when the fuel balance is measured in the ship used by the shipping company. Date), the ship name code that identifies the ship name of the ship whose fuel balance was measured, the product name code that identifies the fuel product name, and the end of the measurement date for each fuel product name Fuel measurement data including balance data for the current month that specifies the current month fuel balance (the balance at the end of the current month) is input to the stored goods input screen.

  For example, a case where a balance of 35.880 kiloliters of A heavy oil and a balance of 34.120 kiloliters of C heavy oil are measured at the end of March 2008 on a ship called Nippon Maru used by a shipping company will be described. The operator of the shipping company uses the measurement date data “2008/03” to specify the measurement date (processing date) when the fuel balance was measured at Nippon Maru, and the ship name “Japan” where the fuel balance was measured. The ship name code “001234” for specifying “maru” is input to the stored item input screen. The operator may input date data “2008/03/31” or the like specifying the date of recording on the stored item input screen.

  In addition, the operator can use the product name code “00123” for specifying the fuel name “A heavy oil” and balance data “35.880” kiloliters for specifying the fuel balance of A heavy oil at the end of March 2008 (the balance at the end of the current month). Is input to the supplies input screen. In addition, the operator inputs the product name code “00124” for specifying the fuel name “C heavy oil” and the balance data “34.120” kiloliters for specifying the fuel balance of C heavy oil at the end of March 2008. To enter.

<Search for fuel purchase data and fuel measurement data>
The payment table of the management database stores fuel purchase data and fuel measurement data registered in the past. When the operator clicks a “search” button in the stored item input screen using a mouse or the like, the client terminal 20 requests the domestic shipping management server 10 to search for fuel purchase data and fuel measurement data via the network. At the same time, fuel measurement data for the current month is transmitted.

  The data processing unit 13 and the data search unit 14 of the domestic shipping management server 10 receive the fuel measurement data for the current month together with the fuel purchase data and the fuel measurement data search request from the client terminal 20 via the network connection unit 12. . The fuel measurement data for the current month includes measurement year / month data, a ship name code, a product name code, and balance data for the current month. The data search unit 14 supplies the received balance data of the current month to the data calculation unit 15 together with the product name code.

  Further, the data search unit 14 searches for fuel purchase data using the received ship name code and product name code as a search keyword, reads out date data associated with the ship name code and product name code, and receives the received measurement. The date data corresponding to the measurement date specified by the year / month data is extracted, and the purchase amount data associated with the extracted date data is read out. The data search unit 14 supplies the read purchase amount data to the data calculation unit 15 together with the product name code.

  Further, the data search unit 14 searches the fuel measurement data by using the received ship name code and product name code as a search keyword, reads out the measurement date data associated with the ship name code and product name code, and receives them. The measurement year / month data corresponding to the previous month of the measurement year / month specified by the measurement year / month data is extracted, and the balance data of the previous month associated with the extracted measurement year / month data is read. The data search unit 14 supplies the read balance data of the previous month to the network connection unit 12, the data processing unit 13, and the data calculation unit 15 together with the product name code.

  The data calculation unit 15 sums the fuel purchase amount specified by the read purchase amount data for each fuel product name specified by the received product name code, thereby calculating the current month fuel purchase amount. Calculate purchase volume data. Further, the data calculation unit 15 adds the current month fuel purchase amount to the previous month fuel balance specified by the previous month balance data, and subtracts the current month fuel balance specified by the received current month balance data. Thus, the consumption data for the current month that specifies the fuel consumption for the current month is calculated. The data calculation unit 15 supplies the total purchase amount data and consumption amount data for the current month to the network connection unit 12 and the data processing unit 13 together with the product name code as fuel increase / decrease data.

  The data search unit 14 reads character data representing the ship name “Nippon Maru” by referring to the ship name master table based on the ship name code “001234”. Further, the data search unit 14 reads out character data representing the fuel product names “A heavy oil” and “C heavy oil” by referring to the product name master table based on the product name codes “00123” and “00124”. The read character data is supplied to the network connection unit 12.

  The network connection unit 12 stores the balance data of the previous month for each fuel product name specified by the received product name code, together with the measurement date and ship name specified by the received measurement date data and ship name code, respectively. File representing fuel information including the previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption specified by the current month total purchase amount data, current month balance data, and current month consumption data, respectively. (HTML file etc.) is generated. The network connection unit 12 transmits the generated file to the client terminal 20 via the network, thereby causing the display unit of the client terminal 20 to display a stored item input screen representing the search result.

  Based on the file received from the domestic shipping management server 10, the client terminal 20 determines the fuel balance of the previous month, the fuel purchase amount of the current month, the fuel balance of the current month, Fuel information including consumption is displayed on the display unit. Thereby, the fuel purchase amount, the fuel balance, and the fuel consumption amount in each ship can be centrally managed.

  For example, as shown in FIG. 5, the stored item input screen showing the search result includes a measurement date (processing date) “2008/03”, a ship name code “001234”, a ship name “Nippon Maru”, a recording date. Date "2008/03/31", fuel information related to heavy fuel oil A, and fuel information related to heavy fuel oil C.

  Fuel information on A heavy oil includes product name code “00123”, product name “A heavy oil”, last month fuel balance (carried over the previous month) “29.520” kiloliters, current month fuel purchase (purchased this month) “65.000” kiloliters, This includes the fuel balance for the current month (the balance at the end of the month) “35.880” kiloliters and the fuel consumption for the current month (consumption for the current month) “58.640” kiloliters.

  Fuel information on C heavy oil includes product name code “00124”, product name “C heavy oil”, previous month fuel balance (carried over from the previous month) “23.670” kiloliter, fuel purchase volume of this month (purchase of the current month) “65.000” km Liters, current fuel balance (month end balance) “34.120” kiloliters, and current month fuel consumption (current month consumption) “54.550” kiloliters.

  When the operator uses the mouse or the like to click the “Register” button in the stored item input screen, a registration command is transmitted from the client terminal 20 to the domestic shipping management server 10 via the network. The data processing unit 13 that has received the registration command via the network connection unit 12 of the coastal shipping management server 10 stores and registers the fuel measurement data together with the fuel increase / decrease data in the payment table of the management database. In this way, fuel measurement data and fuel increase / decrease data relating to fuel measured in the past are stored in the payment table of the management database.

  FIG. 6 is a diagram showing the structure of fuel measurement data and the like stored in the payment table of the management database. As shown in FIG. 6, a plurality of items included in the fuel purchase data are associated with each other and stored in the payment table of the management database. In the payment table, fuel increase / decrease data including total purchase amount data and consumption amount data and fuel amount data described later are also stored in association with the fuel measurement data. In FIG. 6, as an example, fuel amount data representing a fuel amount without consumption tax is shown.

<Calculation of fuel amount>
When the invoice issued from the fuel supplier arrives at the shipping company, the operator of the fuel supplier can input unit price data representing the unit price of the fuel to the client terminal 20 based on the invoice from the fuel supplier. The operator operates the operation unit of the client terminal 20 to access the coastal shipping management server 10 via the network.

  The network connection unit 12 of the coastal shipping management server 10 displays a menu on the display unit of the client terminal 20 when receiving access from the client terminal 20 via the network. When the operator selects “stored item input” from the menu displayed on the display unit of the client terminal 20, the network connection unit 12 of the domestic shipping management server 10 displays the stored item input screen on the display unit of the client terminal 20. To display.

  When the stored item input screen is displayed on the display unit of the client terminal 20, the operator operates the operation unit of the client terminal 20, for example, measurement date data “2008” indicating the measurement date (processing date). / 03 ”and the ship name code“ 001234 ”for specifying the ship name of the ship“ Nippon Maru ”whose fuel balance has been measured are input to the stored goods input screen.

  When the operator uses the mouse or the like to click the “Search” button in the stored item input screen, the client terminal 20 transmits the measurement date data and ship name code to the domestic shipping management server 10 via the network. To do. The data search unit 14 of the domestic shipping management server 10 receives the measurement date data and ship name code from the client terminal 20 via the network connection unit 12.

  The data search unit 14 searches the fuel measurement data and the fuel increase / decrease data stored in the payment table of the management database based on the received measurement date data and ship name code, thereby obtaining the corresponding fuel measurement data and The fuel increase / decrease data is read and supplied to the network connection unit 12.

  The data search unit 14 reads character data representing the ship name “Nippon Maru” by referring to the ship name master table based on the received ship name code “001234”. Further, the data search unit 14 refers to the product name master table based on the read product name codes “00123” and “00124”, thereby obtaining character data representing the fuel product names “A heavy oil” and “C heavy oil”. read out. The read character data is supplied to the network connection unit 12.

  Based on the fuel measurement data, the fuel increase / decrease data, and the character data supplied from the data search unit 14, the network connection unit 12 generates a file (HTML file or the like) representing the corresponding stored item input screen, To the client terminal 20. Thereby, the stored goods input screen shown in FIG. 5 is displayed on the display unit of the client terminal 20.

  The storage item input screen shown in FIG. 5 includes an input field for inputting current unit price data representing the current unit price for each fuel product name, and an input field for inputting previous month unit price data representing the previous month unit price as necessary. And further. The operator operates the operation unit of the client terminal 20 to input the current month unit price data representing the revised month unit price on the storage product input screen. If the previous month unit price has been revised, the previous month unit price after the revision is entered. The previous month unit price data representing is input to the stored goods input screen.

  For example, the operator inputs the unit price “60,000” yen after the revision of the heavy oil A in March 2008 on the stored item input screen. Further, when the unit price of heavy fuel oil A in February 2008 has been revised, the operator inputs the unit price “59,400” yen after the revision of heavy fuel oil A in February 2008 to the stored goods input screen.

  In addition, the operator inputs the unit price “60,000” yen after the revision of C heavy oil in March 2008 to the stored goods input screen. Further, when the unit price of C heavy oil in February 2008 has been revised, the operator inputs the unit price “59,400” yen after the revision of C heavy oil in February 2008 to the stored goods input screen.

  When the operator uses the mouse or the like to click the “search” button in the stored item input screen, the client terminal 20 sends the current month unit price data and the previous month unit price data ( If entered). The data processing unit 13 and the data calculation unit 15 of the coastal shipping management server 10 send the current unit price data for each fuel product name specified by the product name code read from the client terminal 20 via the network connection unit 12. And the previous month unit price data (when input) is received.

  When the data processing unit 13 does not receive the previous month unit price data from the client terminal 20, the data search unit 14 receives the measurement year / month data corresponding to the previous month of the measurement year / month specified by the received measurement year / month data. From the fuel price data associated with the ship name code, the previous month unit price data is read for each fuel product name specified by the read product name code. The data search unit 14 supplies the read previous month unit price data to the data calculation unit 15, and the data calculation unit 15 receives the previous month unit price data from the data search unit 14.

  For each fuel item name specified by the read item name code, the data calculation unit 15 calculates the previous month balance amount data representing the previous month fuel balance amount, which is the product of the previous month fuel balance and the previous month unit price, the current month fuel purchase amount and the current month. The current month purchase amount data representing the current month fuel purchase amount which is a product of the unit price, and the current month balance amount data representing the current month fuel balance amount which is the product of the current month fuel balance and the current month unit price are calculated.

  Further, the data calculation unit 15 calculates current month consumption amount data representing the current month fuel consumption amount by adding the current month fuel purchase amount to the previous month fuel balance amount and subtracting the current month fuel balance amount. Fuel amount data including unit price data, balance amount data, purchase amount data, and consumption amount data is supplied to the network connection unit 12 and the data processing unit 13.

  The network connection unit 12 is identified by the previous month balance amount data, the current month purchase amount data, the current month balance amount data, and the current month consumption amount data for each fuel product name specified by the read product name code together with the fuel information. A file (HTML file or the like) representing an updated stored item input screen further including the previous month fuel balance amount, current month fuel purchase amount, current month fuel balance amount, and current month fuel consumption amount is generated. The network connection unit 12 displays the updated stored item input screen on the display unit of the client terminal 20 by transmitting the generated file to the client terminal 20 via the network.

  Based on the file received from the domestic shipping management server 10, the client terminal 20 displays, for example, the updated stored item input screen illustrated in FIG. 7 on the display unit. In the updated stored goods input screen shown in FIG. 7, regarding A heavy oil, the previous month unit price “59,400” yen, the previous month fuel balance amount “1,753,488” yen, the current month unit price “60,000” yen, the current month A fuel purchase amount “3,900,000” yen, a current month fuel balance amount “2,152,800” yen, and a current month fuel consumption amount “3,500,688” yen are displayed.

  Regarding C heavy oil, the previous month unit price “59,400” yen, the previous month fuel balance amount “1,405,998” yen, the current month unit price “60,000” yen, the current month fuel purchase amount “3,900,000” yen, The fuel balance amount “2,047,200” yen for the current month and the fuel consumption amount “3,258,798” for the current month are displayed.

  When the operator uses the mouse or the like to click the “Register” button in the stored item input screen, a registration command is transmitted from the client terminal 20 to the domestic shipping management server 10 via the network. The data processing unit 13 that has received the registration command via the network connection unit 12 of the domestic shipping management server 10 stores and registers the fuel amount data for the current month in the payment table of the management database (see FIG. 6). In this way, fuel amount data relating to the amount of fuel is stored in the payment table of the management database together with the fuel measurement data and the fuel increase / decrease data.

<Storing amount data in the accounting table>
The management database recorded in the recording unit 16 shown in FIG. 1 is a first accounting table used to create a shipping company balance sheet, and a first accounting table used to create a shipping company income statement. 2 accounting tables are stored.

  FIG. 8 is a diagram illustrating an example of the first accounting table. The first accounting table corresponds to the journal. FIG. 9 is a diagram showing an example of the second accounting table. When the data calculation unit 15 calculates the purchase amount data for the current month, the data processing unit 13 stores the purchase amount data for the current month in the debit column of the first accounting table as data representing an increase in the amount of fuel held. In the credit column of the table, the purchase amount data for the current month is stored as data representing a decrease in the amount held.

  For example, when a shipping company purchases A heavy oil in cash in March 2008 and a purchase price of A heavy oil of 3,900,000 yen is recorded on March 31, 2008, the data processing unit 13 The date data specifying the date of recording the purchase price of heavy oil is stored in the first accounting table, and the purchase price data for the current month representing the purchase price of A heavy oil of 3,900,000 yen represents an increase in “stored goods” Data is stored in the debit column in the first accounting table, and data representing a decrease in “cash” is stored in the credit column in the first accounting table.

  In addition, when a shipping company purchases C heavy oil in cash in March 2008 and a purchase price of C heavy oil of 3,900,000 yen is recorded on March 31, 2008, the data processing unit 13 The date data specifying the date of recording the purchase price of heavy oil is stored in the first accounting table, and the purchase price data for the current month representing the purchase price of C heavy oil of 3,900,000 yen represents an increase in “stored goods” Data is stored in the debit column in the first accounting table, and data representing a decrease in “cash” is stored in the credit column in the first accounting table.

  Further, when the data calculation unit 15 calculates the current month consumption amount data, the data processing unit 13 stores the current month consumption amount data as data representing a decrease in the held fuel in the credit column in the first accounting table. In the expense column in the accounting table of No. 2, consumption amount data for the current month is stored as data representing an increase in expense.

  For example, when the consumption amount of 3,500,688 yen of A heavy oil is recorded on March 31, 2008, the data processing unit 13 stores date data specifying the recording date in the first accounting table. , Amount of consumption of A heavy oil 3,500,688 yen purchase data for the current month is stored in the debit column of the first accounting table as data representing "profit and loss", and data representing the decrease in "stored goods" Stored in the credit column in the first accounting table.

  Further, the data processing unit 13 stores the date data for specifying the date of recording in the second accounting table, and the purchase amount data for the current month representing the consumption amount of A heavy oil 3,500,688 yen as “consumption of A heavy oil” It is stored in the expense column in the second accounting table as data representing “amount”. Thereby, the consumption amount of A heavy oil is transferred to expense.

  In addition, when the consumption amount of C heavy oil 3,258,798 yen is recorded on March 31, 2008, the data processing unit 13 stores the date data for specifying the recording date in the first accounting table. , The purchase amount data for the current month representing C fuel oil consumption amount of 3,258,798 yen is stored in the debit column of the first accounting table as data representing “profit / loss”, and data representing the decrease in “stored goods” Stored in the credit column in the first accounting table.

  Further, the data processing unit 13 stores the date data for specifying the date of recording in the second accounting table, and the purchase amount data for the current month representing the consumption amount of C heavy oil 3,258,798 yen, “consumption of C heavy oil” It is stored in the expense column in the second accounting table as data representing “amount”. Thereby, the consumption amount of C heavy oil is transferred to expense.

  In this way, an accounting table that can be used in the accounting system is automatically created based on the amount of fuel purchased and the amount of fuel consumed in each ship. Therefore, it is not necessary to manually input the fuel purchase amount and the fuel consumption amount into the accounting system and perform the journalizing work, thereby saving the accounting process.

<Inland shipping management method>
Next, a coastal shipping management method according to an embodiment of the present invention will be described with reference to FIGS. FIG. 10 is a flowchart showing the operation of the domestic shipping management server shown in FIG. When an operator of the shipping company starts up the power supply of the coastal shipping management server 10 and starts the coastal shipping management program, the CPU of the coastal shipping management server 10 starts a series of operations.

  In step S1 of FIG. 10, the data processing unit 13 sets the date data for specifying the shipping date of the fuel purchased by the shipping company, the ship name code for specifying the ship name of the ship to which the purchased fuel is supplied, and the name of the fuel. A management database that receives fuel purchase data including at least one client terminal 20 including a product name code to be specified and purchase amount data to specify a fuel purchase amount, and associates a plurality of items included in the fuel purchase data with each other To store.

  In step S <b> 2, the data processing unit 13 uses measurement date / time data for specifying the measurement date / time when the fuel balance is measured in the ship used by the shipping company, and a ship name code for specifying the ship name of the ship where the fuel balance is measured. The fuel measurement data including the product name code for specifying the fuel product name and the balance data for specifying the fuel balance at the end of the month for each fuel product name is received from at least one client terminal 20 and included in the fuel measurement data. A plurality of items are associated with each other and stored in the management database.

  In step S3, when the data search unit 14 receives the fuel purchase data and fuel measurement data search request and the fuel measurement data of the current month from the client terminal 20, the data search unit 14 uses the received ship name code and product name code as a search keyword. To retrieve the fuel purchase data, read the date data associated with the ship name code and product name code, and extract the date data corresponding to the measurement date specified by the received measurement date data The purchase amount data associated with the date data is read out.

  Further, the data search unit 14 searches the fuel measurement data using the received ship name code and product name code as a search keyword, reads out the measurement date data associated with the ship name code and product name code, and received the received data. The measurement year / month data corresponding to the previous month of the measurement year / month specified by the measurement year / month data is extracted, and the balance data of the previous month associated with the extracted measurement year / month data is read.

  In step S4, the data calculation unit 15 adds the fuel purchase amount specified by the read purchase amount data for each fuel item name specified by the received item name code, thereby obtaining the current fuel purchase amount. Total purchase amount data for the current month is calculated, and the fuel purchase amount for the current month is added to the fuel balance for the previous month specified by the balance data for the previous month, and the fuel balance for the current month specified by the received balance data for the current month is calculated. By subtracting, the consumption data for the current month that specifies the current fuel consumption is calculated.

  In step S5, the network connection unit 12 adds the previous month for each fuel product name specified by the received product name code together with the measurement date and ship name specified by the received measurement date data and ship name code, respectively. Fuel, including previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption specified by the current balance data, current month total purchase data, current month balance data, and current month consumption data, respectively. The information is displayed on the display unit of the client terminal 20.

  In the above embodiment, the case where the coastal shipping management server is configured by one terminal has been described. However, the present invention is not limited to this embodiment, and the coastal shipping management server is configured by a plurality of terminals. It may be configured. Thus, many modifications are possible within the technical idea of the present invention by those who have ordinary knowledge in the technical field.

  DESCRIPTION OF SYMBOLS 10 ... Domestic shipping management server, 11 ... Operation part, 12 ... Network connection part, 13 ... Data processing part, 14 ... Data search part, 15 ... Data operation part, 16 ... Recording part, 17 ... Display part, 20 ... Client Terminal, 30 ... Printer

Claims (6)

A domestic shipping management server used with at least one client terminal connected via a network to manage data relating to domestic shipping in a shipping company,
A recording unit for recording a management database for storing data relating to the domestic shipping of the shipping company;
Date data that identifies the shipping date of the fuel purchased by the shipping company, ship name code that identifies the ship name of the ship to which the purchased fuel is supplied, product name code that identifies the fuel product name, and fuel purchase quantity In a ship used by a shipping company, fuel purchase data including purchase amount data is received from the at least one client terminal, and a plurality of items included in the fuel purchase data are associated with each other and stored in the management database. Measurement date data that identifies the measurement date when the fuel balance was measured, ship name code that identifies the ship name of the ship where the fuel balance was measured, product name code that identifies the fuel product name, and each fuel product name Fuel measurement data including balance data specifying the fuel balance at the end of the month is received from the at least one client terminal and is included in the fuel measurement data. A data processing unit for storing a plurality of items in the management database in association with each other that are,
When the fuel measurement data for the current month is received from the client terminal together with a search request for fuel purchase data and fuel measurement data, the fuel purchase data is searched using the received ship name code and product name code as search keywords. Read the date data associated with the code and product name code, extract the date data corresponding to the measurement date specified by the received measurement year / month data, and obtain the purchase volume data associated with the extracted date data In addition to reading, the fuel measurement data is retrieved using the received ship name code and product name code as a search keyword, and the measurement date data associated with the ship name code and product name code is read, and the received measurement date data is Extracts the measurement date corresponding to the month before the specified measurement date, and the extracted measurement date A data retrieval unit to read the previous month's balance data associated with the over data,
For each fuel product name specified by the received product name code, the total fuel purchase amount for the current month is calculated by summing the fuel purchase amount specified by the read purchase data. The current month fuel balance is added to the previous month fuel balance specified by the previous month balance data, and the current month fuel balance specified by the received current month balance data is subtracted. A data calculator that calculates consumption data for the current month,
Along with the measurement date and ship name specified by the received measurement date and ship name code, respectively, the balance data for the previous month and the total purchase amount data for the current month for each fuel product name specified by the received product name code. Fuel information including the previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption specified by the current month balance data and current month consumption data are displayed on the display unit of the client terminal. Network connection
Coastal shipping management server equipped with. The network connection unit includes an input field for inputting current unit price data representing the current unit price for each fuel product name, and an input field for inputting previous month unit price data representing the previous month unit price as necessary. Display the screen on the display unit of the client terminal,
The data calculation unit receives the current month unit price data and the previous month unit price data, and for each fuel item name, the previous month balance amount data representing the previous month fuel balance amount, which is the product of the previous month fuel balance and the previous month unit price, the current month fuel purchase amount Current month purchase amount data representing the current month fuel purchase amount, which is the product of the current month unit price, and current month balance amount data representing the current month fuel balance amount, which is the product of the current month fuel balance and current month unit price. By adding the fuel purchase amount for the current month to the balance amount and subtracting the fuel balance amount for the current month, the current month consumption amount data representing the fuel consumption amount for the current month is calculated.
The network connection unit displays the previous month fuel balance amount and the current month fuel purchase amount for each fuel product name, as well as the previous month balance amount data, current month purchase amount data, current month balance amount data, and current month consumption amount data. , Display the updated input screen further including the current month fuel balance amount and the current month fuel consumption amount on the display unit of the client terminal,
The domestic shipping management server according to claim 1. The management database further stores a first accounting table used to create a shipping company balance sheet and a second accounting table used to create a profit and loss statement for the shipping company. ,
The data processing unit stores the purchase amount data for the current month as data representing an increase in fuel held in the debit column in the first accounting table, and the decrease in the amount held in the credit column in the first accounting table. The purchase amount data for the current month is stored as data representing the amount of money, and the consumption amount data for the current month is stored in the credit column of the first accounting table as data representing a decrease in the amount of fuel held. In the column, store the consumption data for the current month as data representing the increase in expenses.
The domestic shipping management server according to claim 2. The domestic shipping management server according to any one of claims 1 to 3,
When the fuel measurement data for the current month is input, in response to the search command, the fuel measurement data for the current month is sent to the domestic shipping management server together with the fuel purchase data and the fuel measurement data search request. Based on the file received from the operation management server, fuel information including the previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption is displayed for each fuel product name along with the measurement date and ship name. At least one client terminal to be displayed on the department;
Coastal shipping management system equipped with. A domestic shipping management method used in a shipping company to manage data related to domestic shipping,
Date data that identifies the shipping date of the fuel purchased by the shipping company, ship name code that identifies the ship name of the ship to which the purchased fuel is supplied, product name code that identifies the fuel product name, and fuel purchase quantity Receiving fuel purchase data including purchase amount data from at least one client terminal, and storing a plurality of items included in the fuel purchase data in a management database in association with each other;
Measurement date data that identifies the measurement date when the fuel balance was measured on the ship used by the shipping company, ship name code that identifies the ship name of the ship where the fuel balance was measured, product name code that identifies the fuel product name, And receiving fuel measurement data including balance data specifying the fuel balance at the end of the month for each fuel product name from the at least one client terminal, and associating a plurality of items included in the fuel measurement data with each other Storing in a database (b);
When the fuel measurement data for the current month is received from the client terminal together with a search request for fuel purchase data and fuel measurement data, the fuel purchase data is searched using the received ship name code and product name code as search keywords. Read the date data associated with the code and product name code, extract the date data corresponding to the measurement date specified by the received measurement year / month data, and obtain the purchase volume data associated with the extracted date data In addition to reading, the fuel measurement data is retrieved using the received ship name code and product name code as a search keyword, and the measurement date data associated with the ship name code and product name code is read, and the received measurement date data is Extracts the measurement date corresponding to the month before the specified measurement date, and the extracted measurement date And step (c) to read the previous month's balance data associated with the over data,
For each fuel product name specified by the received product name code, the total fuel purchase amount for the current month is calculated by summing the fuel purchase amount specified by the read purchase data. The current month fuel balance is added to the previous month fuel balance specified by the previous month balance data, and the current month fuel balance specified by the received current month balance data is subtracted. Calculating consumption data for the current month to be identified (d);
Along with the measurement date and ship name specified by the received measurement date and ship name code, respectively, the balance data for the previous month and the total purchase amount data for the current month for each fuel product name specified by the received product name code. Fuel information including the previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption specified by the current month balance data and current month consumption data are displayed on the display unit of the client terminal. Step (e),
A domestic shipping management method comprising: A domestic shipping management program used in a domestic shipping management server for managing domestic shipping data in a shipping company,
Date data that identifies the shipping date of the fuel purchased by the shipping company, ship name code that identifies the ship name of the ship to which the purchased fuel is supplied, product name code that identifies the fuel product name, and fuel purchase quantity Receiving fuel purchase data including purchase amount data from at least one client terminal, and associating a plurality of items included in the fuel purchase data with each other and storing them in the management database;
Measurement date data that identifies the measurement date when the fuel balance was measured on the ship used by the shipping company, ship name code that identifies the ship name of the ship where the fuel balance was measured, product name code that identifies the fuel product name, And receiving fuel measurement data including balance data specifying the fuel balance at the end of the month for each fuel product name from the at least one client terminal, and associating a plurality of items included in the fuel measurement data with each other (B) storing in the database;
When the fuel measurement data for the current month is received from the client terminal together with a search request for fuel purchase data and fuel measurement data, the fuel purchase data is searched using the received ship name code and product name code as search keywords. Read the date data associated with the code and product name code, extract the date data corresponding to the measurement date specified by the received measurement year / month data, and obtain the purchase volume data associated with the extracted date data In addition to reading, the fuel measurement data is retrieved using the received ship name code and product name code as a search keyword, and the measurement date data associated with the ship name code and product name code is read, and the received measurement date data is Extracts the measurement date corresponding to the month before the specified measurement date, and the extracted measurement date Procedure for reading the previous month's balance data associated with the over data and (c),
For each fuel product name specified by the received product name code, the total fuel purchase amount for the current month is calculated by summing the fuel purchase amount specified by the read purchase data. The current month fuel balance is added to the previous month fuel balance specified by the previous month balance data, and the current month fuel balance specified by the received current month balance data is subtracted. A procedure (d) for calculating consumption data for the current month to be identified;
Along with the measurement date and ship name specified by the received measurement date and ship name code, respectively, the balance data for the previous month and the total purchase amount data for the current month for each fuel product name specified by the received product name code. Fuel information including the previous month fuel balance, current month fuel purchase amount, current month fuel balance, and current month fuel consumption specified by the current month balance data and current month consumption data are displayed on the display unit of the client terminal. Step (e)
A coastal shipping management program that causes the CPU to execute.