Method and system for automatically generating coastal dry bulk cargo transportation price confirmation letter

Abstract

The invention relates to the technical field of sea transportation file processing, in particular to a coastal dry bulk cargo transportation price confirmation letter automatic generation method and system, and the method comprises the steps: obtaining a shipping electronic contract in real time, and obtaining contract term information based on the shipping electronic contract; based on a preset freight rate index database and the contract term information, acquiring a voyage number reference freight rate; calculating voyage number freight rate data according to the contract term information and voyage number reference freight rate; and generating a freight rate confirmation letter based on the voyage freight rate data, and generating a confirmed freight rate confirmation letter according to a preset confirmation letter synchronization rule. The voyage freight rate confirmation letter is automatically generated, and the execution efficiency of the freight rate confirmation letter is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of shipping document processing, and in particular to a method and system for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter. Background Art

[0002] Charter contracts for China's coastal dry bulk cargo transportation are mainly divided into two categories: one is the COA contract, which is a long-term contract for chartering a ship; the other is a single voyage contract, which is a one-time charter contract for a single shipment of goods. Due to the large fluctuations in coastal transportation prices, the market price at the time of signing the contract is quite different from the market price at the time of actual transportation. In order to reduce risks and set reasonable prices, most cargo owners and shipowners use the China Coastal Bulk Freight Index as the benchmark freight rate when signing the contract, and then calculate the voyage freight rate through the freight rate calculation rules agreed in the contract, and finally generate a freight confirmation letter. The freight confirmation letter is an important commercial document used to detail and confirm the specific price and related data of cargo transportation. It usually includes data such as loading port, discharge port, ship name, voyage, cargo type, cargo volume, demurrage rate, freight rate, etc. This document not only provides a detailed cost clause confirmation for both parties to the transportation, but also ensures that the understanding and expectations of the costs of both parties are consistent during the transportation process, avoiding possible disputes in the future. In addition, the freight confirmation letter is also used as the basis for settlement to ensure the accuracy and traceability of transportation costs. The importance of this document lies in that it defines specific data based on the cost terms of the transport contract, so that the quality and price of the transport service are clearly guaranteed, thus protecting the interests of both parties.

[0003] At present, there are two ways to operate the freight confirmation letter for coastal dry bulk transportation: Method 1: Traditional manual operation, Method 2: Semi-electronic operation, Method 1 is to print out the freight confirmation letter in paper form, and then send it to the other party for signature by mail or other physical means. This form of confirmation letter requires physical space for storage, and may be subject to the risk of time delay and loss during the delivery process. Method 2 replaces the form of mailing paper letters in Method 1 by sending electronic letters through email or WeChat, which reduces the time of letter delivery, but it still needs to be stamped, confirmed and archived in the form of paper letters.

[0004] Whether it is the traditional pure manual operation method or the semi-electronic operation method, the following problems exist: In terms of operation: manual operation is cumbersome and archiving and retrieval are difficult; in terms of timeliness: the circulation takes too long and the execution efficiency is low; in terms of accuracy: human errors are easy to occur, and modifications are difficult to distinguish between true and false; in terms of security: easy to be stained and lost, and difficult to authenticate without encryption; in terms of format: the production is highly arbitrary, and there is no standard or standard. Therefore, there is room for improvement. Summary of the invention

[0005] In order to realize automatic generation of voyage freight rate confirmation letters and improve the execution efficiency of freight rate confirmation letters, the present application provides a method and system for automatically generating freight rate confirmation letters for coastal dry bulk cargo transportation.

[0006] The above-mentioned invention objective of the present application is achieved through the following technical solutions: A method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter, the automatic generation of the coastal dry bulk cargo transportation freight rate confirmation letter comprises the steps of: Acquire the shipping electronic contract in real time, and acquire the contract terms information based on the shipping electronic contract; Obtaining a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; Calculate the voyage freight rate data based on the contract terms and the voyage benchmark freight rate; A freight rate confirmation letter is generated based on the voyage freight rate data, and a confirmed freight rate confirmation letter is generated according to a preset confirmation letter synchronization rule.

[0007] By adopting the above technical solution, in the process of generating the voyage freight confirmation letter, the electronic shipping contract of the voyage is obtained in real time by uploading the electronic contract on the shipping e-commerce platform, and the information of the shipping electronic contract is extracted to obtain the contract terms information, and the contract terms information is displayed, so that the staff can directly check and extract the contract terms for freight rate calculation. At the same time, the voyage benchmark freight rate is obtained through the preset freight index database. The freight index database refers to the storage of China's coastal bulk freight index data. The voyage freight data of the voyage is automatically calculated using the obtained contract terms information and the voyage benchmark freight rate, such as the voyage Freight rates, demurrage rates, dispatch rates and other data, and automatically generate freight confirmation letters based on voyage freight rate data, and send the freight confirmation letters to the other party of the contract according to the preset confirmation letter synchronization rules, so as to confirm the freight confirmation letters. The system automatically identifies the contract content and automatically generates freight confirmation letters according to the rules agreed in the contract, realizing paperless transmission of freight confirmation letters and improving the execution efficiency of freight confirmation letters. This technical solution can effectively improve the generation efficiency and accuracy of freight confirmation letters, reduce errors caused by manual operations, and significantly shorten the time for confirmation letter generation and confirmation, making the execution process of coastal dry bulk shipping contracts more convenient and efficient.

[0008] In a preferred example, the present application may be further configured as follows: the real-time acquisition of the shipping electronic contract and the acquisition of contract terms information based on the shipping electronic contract specifically include: Acquire the electronic shipping contract in real time, input the electronic shipping contract into a preset transport contract evaluation model, and acquire contract information features; The contract information features are integrated to form contract clause information, wherein the contract clause information includes basic shipping information and contract calculation clause information.

[0009] By adopting the above technical solution, by acquiring the shipping electronic contract in real time and inputting the contract into the preset transport contract evaluation model, the key terms information in the contract, such as the loading port, unloading port, and freight calculation rules agreed in the contract, can be automatically analyzed, thereby significantly reducing the time for manual search and screening of contract terms, improving work efficiency, and integrating the acquired contract information features to form complete contract terms information, which includes but is not limited to basic shipping information and contract calculation terms information, ensuring that all necessary basic data are available for subsequent freight calculations, improving the speed of generating freight confirmation letters, and ensuring the accuracy of information, avoiding data errors caused by human factors, and being able to achieve efficient and accurate automatic generation of freight confirmation letters for coastal dry bulk transportation.

[0010] In a preferred example, the present application may be further configured as follows: before obtaining the voyage benchmark freight rate based on the preset freight rate index database, the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter further includes: Obtain the freight index website, input the preset RPA robot into the freight index website, and read the freight index information; The freight rate index information is integrated to form a freight rate index database.

[0011] By adopting the above technical solution, by obtaining the freight index website and inputting the preset RPA robot into the website, the freight index information can be automatically read, and the information can be integrated into a freight index database, thereby providing accurate data support for the subsequent acquisition of the voyage benchmark freight rate, and improving the accuracy and efficiency of the freight confirmation letter generation.

[0012] In a preferred example, the present application can be further configured as follows: the obtaining of the freight index website, inputting a preset RPA robot into the freight index website, and reading the freight index information specifically includes: Based on the preset RPA robot, the freight index information features are obtained and the column header is read; According to the freight index information characteristics, the column header is read to read data in the freight index website, and the read data is integrated to form the freight index information.

[0013] By adopting the above technical solution, the freight index information feature reading column header is obtained through the setting information in the RPA robot. The freight index information feature reading column header refers to the crawling class that reads the freight index website data, and then the data can be quickly crawled on the freight index website according to the freight index information feature reading column header, and the read data is integrated to form the freight index information, so that the freight index information can be integrated efficiently and accurately, thereby improving the accuracy and efficiency of freight index reading.

[0014] In a preferred example, the present application may be further configured as follows: the voyage freight rate data is calculated according to the contract terms information and the voyage benchmark freight rate, specifically including: Obtaining appropriate freight rate calculation rules in a preset freight rate calculation rule library based on the contract terms information; The voyage base freight rate is input into the freight rate calculation rules to obtain the voyage freight rate data.

[0015] By adopting the above technical solution, the applicable freight rate calculation rules are determined according to the contract terms and information, such as using the base freight rate plus or minus the floating price or multiplying by the proportional coefficient, so as to accurately calculate the voyage freight rate data. This process ensures that the freight rate calculation results comply with the calculation method agreed in the contract and improves the accuracy and reliability of the freight rate confirmation letter.

[0016] In a preferred example, the present application may be further configured as follows: the voyage freight rate data is calculated according to the contract terms information and the voyage benchmark freight rate, and further includes: Obtaining basic parameters of shipping rates, and obtaining shipping rate data in the contract terms information based on the basic parameters of shipping rates; The shipping fee data is used as the second voyage freight rate data.

[0017] By adopting the above technical solution, after obtaining the voyage benchmark freight rate, not only the voyage freight rate data is calculated according to the contract terms information, but also the basic parameters of the shipping rate are further obtained, and the shipping rate data is obtained in the contract terms information based on these parameters, so that the shipping rate data is used as the second voyage freight rate data, and the accurate voyage freight rate can be calculated more comprehensively, thereby improving the accuracy and reliability of the generation of the freight rate confirmation letter.

[0018] In a preferred example, the present application can be further configured as follows: the generating of the freight confirmation letter based on the voyage freight rate data, and the generating of the confirmed freight confirmation letter according to the preset confirmation letter synchronization rule, specifically including: Input the voyage freight rate data into the preset freight rate confirmation letter template to generate a freight rate confirmation letter; Performing data conversion on the freight rate confirmation letter to obtain electronic metadata and confirmation letter business electronic data; The electronic metadata and confirmation letter business electronic data are sent to the confirmation terminal, and the confirmed freight rate confirmation letter is received.

[0019] By adopting the above technical solution, the voyage freight rate data is input into the preset freight rate confirmation letter template to automatically generate a freight rate confirmation letter; further, the generated freight rate confirmation letter is converted to obtain electronic metadata and confirmation letter business electronic data; finally, the electronic metadata and confirmation letter business electronic data are sent to the confirmation terminal, and the confirmed freight rate confirmation letter is received, thereby realizing the rapid generation and synchronization of the freight rate confirmation letter and improving work efficiency.

[0020] The second object of the invention is achieved by the following technical solutions: A system for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter, the system comprising: A contract clause information generation module, used to obtain the shipping electronic contract in real time and obtain the contract clause information based on the shipping electronic contract; A voyage benchmark freight rate generation module, used to obtain a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; The voyage freight rate calculation module is used to calculate the voyage freight rate data according to the contract terms information and the voyage benchmark freight rate; The freight confirmation letter confirmation module is used to generate a freight confirmation letter based on the voyage freight rate data, and generate a confirmed freight confirmation letter according to a preset confirmation letter synchronization rule.

[0021] By adopting the above technical solution, in the process of generating the voyage freight confirmation letter, the electronic shipping contract of the voyage is obtained in real time by uploading the electronic contract on the shipping e-commerce platform, and the information of the shipping electronic contract is extracted to obtain the contract terms information, and the contract terms information is displayed, so that the staff can directly check and extract the contract terms for freight rate calculation. At the same time, the voyage benchmark freight rate is obtained through the preset freight index database. The freight index database refers to the storage of China's coastal bulk freight index data. The voyage freight data of the voyage is automatically calculated using the obtained contract terms information and the voyage benchmark freight rate, such as the voyage Freight rates, demurrage rates, dispatch rates and other data, and automatically generate freight confirmation letters based on voyage freight rate data, and send the freight confirmation letters to the other party of the contract according to the preset confirmation letter synchronization rules, so as to confirm the freight confirmation letters. The system automatically identifies the contract content and automatically generates freight confirmation letters according to the rules agreed in the contract, realizing paperless transmission of freight confirmation letters and improving the execution efficiency of freight confirmation letters. This technical solution can effectively improve the generation efficiency and accuracy of freight confirmation letters, reduce errors caused by manual operations, and significantly shorten the time for confirmation letter generation and confirmation, making the execution process of coastal dry bulk shipping contracts more convenient and efficient.

[0022] The third objective of the present application is achieved through the following technical solutions: A computer device comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the above-mentioned method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter when executing the computer program.

[0023] The fourth objective of the present application is achieved through the following technical solutions: A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the above-mentioned method for automatically generating a coastal dry bulk shipping freight rate confirmation letter.

[0024] In summary, the present application includes at least one of the following beneficial technical effects: 1. In the process of generating the voyage freight confirmation letter, the electronic shipping contract of the voyage is obtained in real time by uploading the electronic contract on the shipping e-commerce platform, and the information of the shipping electronic contract is extracted to obtain the contract terms information, and the contract terms information is displayed, so that the staff can directly check and extract the contract terms for freight calculation. At the same time, the voyage benchmark freight rate is obtained through the preset freight index database. The freight index database refers to the storage of China's coastal bulk freight index data. The voyage freight data of the voyage, such as voyage freight rate, demurrage, etc., is automatically calculated using the obtained contract terms information and voyage benchmark freight rate. The system automatically identifies the contract content and automatically generates a freight confirmation letter according to the rules of the contract, so as to realize paperless transmission of the freight confirmation letter and improve the execution efficiency of the freight confirmation letter. This technical solution can effectively improve the generation efficiency and accuracy of the freight confirmation letter, reduce the errors caused by manual operation, and significantly shorten the time of generating and confirming the confirmation letter, making the execution process of the coastal dry bulk cargo transportation contract more convenient and efficient. 2. By acquiring the shipping electronic contract in real time and inputting the contract into the preset transport contract evaluation model, it can automatically analyze the key terms and conditions in the contract, such as the loading port, the unloading port, and the freight calculation rules agreed in the contract, thereby significantly reducing the time for manual search and screening of contract terms and improving work efficiency. The acquired contract information features are integrated to form complete contract terms information, which includes but is not limited to basic shipping information and contract calculation terms information, ensuring that all necessary basic data are available for subsequent freight calculations, improving the speed of generating freight confirmation letters, and ensuring the accuracy of information, avoiding data errors caused by human factors, and being able to automatically generate freight confirmation letters for coastal dry bulk transportation efficiently and accurately; 3. By obtaining the freight index website and inputting the preset RPA robot into the website, the freight index information can be automatically read and integrated into a freight index database, thereby providing accurate data support for the subsequent acquisition of the voyage benchmark freight rate and improving the accuracy and efficiency of the freight confirmation letter generation; 4. Determine the applicable freight rate calculation rules based on the contract terms, such as using the base freight rate plus or minus the floating price or multiplying by a proportional coefficient, so as to accurately calculate the voyage freight rate data. This process ensures that the freight rate calculation results comply with the calculation method agreed in the contract and improves the accuracy and reliability of the freight rate confirmation letter. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 is a flow chart of a method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Figure 2 It is a flowchart for realizing step S10 in the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Figure 3 It is a flowchart of the construction of a freight index database in the method for automatically generating a freight confirmation letter for coastal dry bulk cargo transportation in one embodiment of the present application; Figure 4 It is a flowchart for realizing step S201 in the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Figure 5 It is a flowchart for realizing step S30 in the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Figure 6 This is another implementation flow chart of step S30 in the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Figure 7 It is a flowchart for realizing step S40 in the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Figure 8This is a principle block diagram of a system for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter in one embodiment of the present application; Fig. 9 It is a schematic diagram of a computer device in one embodiment of the present application. DETAILED DESCRIPTION

[0026] The present application is further described in detail below in conjunction with the accompanying drawings.

[0027] In one embodiment, if Figure 1 As shown, the present application discloses a method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter, which specifically includes the following steps: S10: Acquire the shipping electronic contract in real time, and acquire contract terms information based on the shipping electronic contract.

[0028] Specifically, in the process of generating the voyage freight confirmation letter, by uploading the electronic contract on the shipping e-commerce platform, the shipping electronic contract for the voyage is obtained in real time, the information of the shipping electronic contract is extracted, the contract terms information is obtained, and the contract terms information is displayed, so that the staff can directly check and extract the contract terms for freight rate calculation.

[0029] S20: Obtaining a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information.

[0030] Specifically, the voyage benchmark freight rate is obtained through a preset freight index database. The freight index database refers to the database that stores China's coastal bulk freight index data. According to the terms of the contract, the freight index of a certain route on a certain date or a certain date period agreed in the contract is obtained, and then the arithmetic average of these freight indices is taken to obtain the benchmark freight index.

[0031] For example, the index freight rate of the “China Coastal Coal Index: Qinhuangdao – Shanghai (40,000 – 50,000 DWT)” route from August 2 to August 9, 2024 (according to the contract agreement, the index prices of the arrival date and the first five index days are taken. Since August 10 and 11 are weekends and no index is released, the index prices of the first six index days are taken). The benchmark freight rate is obtained by taking the arithmetic average of the index freight rates of these days.

[0032] S30: Calculate the voyage freight rate data according to the contract terms information and the voyage benchmark freight rate.

[0033] Specifically, the obtained contract terms information and the voyage benchmark freight rate are used to automatically calculate the voyage freight rate data of the voyage, such as the voyage freight rate, demurrage rate, dispatch rate and other data.

[0034] S40: generating a freight rate confirmation letter based on the voyage freight rate data, and generating a confirmed freight rate confirmation letter according to a preset confirmation letter synchronization rule.

[0035] Specifically, a freight confirmation letter is automatically generated based on the voyage freight rate data, and the freight confirmation letter is sent to the other party of the contract according to the preset confirmation letter synchronization rules to facilitate confirmation of the freight confirmation letter.

[0036] In this embodiment, in the process of generating the voyage freight confirmation letter, the electronic shipping contract of the voyage is obtained in real time by uploading the electronic contract on the shipping e-commerce platform, and the information of the shipping electronic contract is extracted to obtain the contract terms information, and the contract terms information is displayed, so that the staff can directly check and extract the contract terms for freight rate calculation. At the same time, the voyage benchmark freight rate is obtained through the preset freight index database, which refers to the storage of China's coastal bulk freight index data. The voyage freight data of the voyage, such as the voyage freight rate, is automatically calculated using the obtained contract terms information and the voyage benchmark freight rate. , demurrage rate and dispatch rate and other data, and automatically generate a freight confirmation letter based on the voyage freight data, and send the freight confirmation letter to the other party of the contract according to the preset confirmation letter synchronization rules, so as to confirm the freight confirmation letter. The system automatically identifies the contract content, and automatically generates a freight confirmation letter according to the rules agreed in the contract, realizes paperless transmission of freight confirmation letters, and improves the execution efficiency of freight confirmation letters. This technical solution can effectively improve the generation efficiency and accuracy of freight confirmation letters, reduce errors caused by manual operations, and significantly shorten the time for confirmation letter generation and confirmation, making the execution process of coastal dry bulk shipping contracts more convenient and efficient.

[0037] In one embodiment, if Figure 2 As shown, in step S10, the shipping electronic contract is obtained in real time, and the contract terms information is obtained based on the shipping electronic contract, which specifically includes: S11: Acquire the electronic shipping contract in real time, input the electronic shipping contract into a preset transport contract evaluation model, and acquire contract information features.

[0038] S12: Integrate the contract information features to form contract clause information, where the contract clause information includes basic shipping information and contract calculation clause information.

[0039] Specifically, by acquiring electronic shipping contracts in real time and inputting the contracts into the preset transport contract evaluation model, it is possible to automatically analyze key terms in the contract, such as loading port, unloading port, freight calculation rules agreed in the contract, etc., thereby significantly reducing the time for manual search and screening of contract terms and improving work efficiency. The acquired contract information features are integrated to form complete contract terms information, which includes but is not limited to basic shipping information and contract calculation terms information, ensuring that all necessary basic data are available for subsequent freight calculations, improving the speed of generating freight confirmation letters, and ensuring the accuracy of information, avoiding data errors caused by human factors, and being able to efficiently and accurately automatically generate freight confirmation letters for coastal dry bulk shipping.

[0040] In one embodiment, if Figure 3 As shown, before step S20, the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter further includes: S201: Obtain a freight index website, input a preset RPA robot into the freight index website, and read freight index information.

[0041] S202: Integrate the freight rate index information to form a freight rate index database.

[0042] Specifically, by obtaining the freight index website and inputting the preset RPA robot into the website, the freight index information can be automatically read and integrated into a freight index database, thereby providing accurate data support for the subsequent acquisition of voyage benchmark freight rates and improving the accuracy and efficiency of freight confirmation letter generation.

[0043] In one embodiment, if Figure 4 As shown, in step S201, the freight index website is obtained, and the preset RPA robot is input into the freight index website to read the freight index information, which specifically includes: S2011: Based on the preset RPA robot, the freight index information features are obtained and the column header is read.

[0044] S2012: Read the column header and data in the freight index website according to the freight index information characteristics, and integrate the read data to form the freight index information.

[0045] In this embodiment, the freight index information feature reading column header refers to a crawling class that reads freight index website data.

[0046] Specifically, the freight index information feature reading column header is obtained through the setting information in the RPA robot. The freight index information feature reading column header refers to the crawling class that reads the freight index website data, and then the data can be quickly crawled on the freight index website according to the freight index information feature reading column header, and the read data is integrated to form the freight index information, so that the freight index information can be integrated efficiently and accurately, improving the accuracy and efficiency of freight index reading.

[0047] In one embodiment, if Figure 5 As shown, in step S30, the voyage freight rate data is calculated according to the contract terms information and the voyage benchmark freight rate, which specifically includes: S31: Acquire appropriate freight rate calculation rules in a preset freight rate calculation rule library based on the contract terms information.

[0048] S32: Input the voyage base freight rate into the freight rate calculation rules to obtain voyage freight rate data.

[0049] Specifically, the applicable freight calculation rules are determined based on the contract terms and information, such as using the base freight rate plus or minus the floating price or multiplying by a proportional coefficient, so as to accurately calculate the voyage freight data. This process ensures that the freight calculation results comply with the calculation method agreed in the contract and improves the accuracy and reliability of the freight confirmation letter.

[0050] In this embodiment, since the loading and unloading ports of the current voyage may be inconsistent with the loading and unloading ports of the reference route, the final voyage freight rate needs to float based on the benchmark freight rate. This system provides four voyage freight rate calculation rules: 1. Add or subtract the floating price from the base freight rate. The formula is: Voyage freight rate = base freight rate ± X yuan / ton.

[0051] 2. Multiply the base freight rate by the proportional coefficient. The formula is: Voyage freight rate = base freight rate * proportional coefficient.

[0052] 3. First multiply the base freight rate by the proportional coefficient, and then add or subtract the floating price. The formula is: Voyage Freight = Base Freight * Proportional Coefficient ± X Yuan / Ton.

[0053] Customize the freight rate calculation rules. The above three calculation methods have met the freight rate calculation rules for more than 90% of coastal voyages. If the contract stipulates more complex freight rate calculation rules, you can choose to customize them.

[0054] In one embodiment, if Figure 6 As shown, in step S30, the voyage freight rate data is calculated according to the contract terms information and the voyage benchmark freight rate, and also includes: S33: Obtain basic parameters of shipping rates, and obtain shipping rate data in the contract terms information based on the basic parameters of shipping rates.

[0055] S32: Using the shipping fee data as second voyage freight rate data.

[0056] Specifically, after obtaining the base voyage freight rate, not only is the voyage freight rate data calculated based on the contract terms information, but also the basic parameters of the shipping rate are further obtained, and based on these parameters, the shipping rate data is obtained within the contract terms information, so that the shipping rate data is used as the second voyage freight rate data, which can more comprehensively calculate the accurate voyage freight rate and improve the accuracy and reliability of the generation of the freight rate confirmation letter.

[0057] Furthermore, single voyage contracts generally stipulate specific demurrage rates, dispatch rates and loading and unloading days in the contract, but COA long-term contracts may involve multiple loading ports, multiple unloading ports and multiple ship types, and the freight rates for voyages in different periods are also quite different, resulting in inconsistent demurrage rates, dispatch rates and loading and unloading days for each voyage. Generally speaking, COA contracts have defined corresponding rules for demurrage rates, dispatch rates and loading and unloading days under various conditions. It only needs to automatically find the matching demurrage rates, dispatch rates and loading and unloading days in the contract terms based on the current voyage's loading port, unloading port, freight rate, cargo volume and other parameters.

[0058] In one embodiment, if Figure 7 As shown, in step S40, a freight confirmation letter is generated based on the voyage freight rate data, and a confirmed freight confirmation letter is generated according to a preset confirmation letter synchronization rule, specifically including: S41: Input the voyage freight rate data into a preset freight rate confirmation letter template to generate a freight rate confirmation letter.

[0059] S42: Perform data conversion on the freight rate confirmation letter to obtain electronic metadata and confirmation letter business electronic data.

[0060] S43: Send the electronic metadata and confirmation letter business electronic data to the confirmation terminal, and receive the confirmed freight confirmation letter.

[0061] Specifically, the voyage freight rate data is input into the preset freight rate confirmation letter template to automatically generate the freight rate confirmation letter; Furthermore, the generated freight confirmation letter is converted to obtain electronic metadata and confirmation letter business electronic data, the electronic metadata is the main information related to the voyage and the message metadata information, the confirmation letter business electronic data is the freight confirmation letter business data, and finally the electronic metadata and confirmation letter business electronic data are sent to the confirmation terminal, and the confirmed freight confirmation letter is received, so as to realize the rapid generation and synchronization of the freight confirmation letter and improve work efficiency.

[0062] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0063] In one embodiment, a system for automatically generating a confirmation letter for coastal dry bulk cargo transportation freight rates is provided, and the system for automatically generating a confirmation letter for coastal dry bulk cargo transportation freight rates corresponds one-to-one to the method for automatically generating a confirmation letter for coastal dry bulk cargo transportation freight rates in the above embodiment. Figure 8 As shown, the automatic generation system of the coastal dry bulk freight rate confirmation letter includes a contract terms information generation module, a voyage benchmark freight rate generation module, a voyage freight rate calculation module and a freight rate confirmation letter confirmation module. The detailed description of each functional module is as follows: A contract clause information generation module, used to obtain the shipping electronic contract in real time and obtain the contract clause information based on the shipping electronic contract; A voyage benchmark freight rate generation module, used to obtain a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; The voyage freight rate calculation module is used to calculate the voyage freight rate data according to the contract terms information and the voyage benchmark freight rate; The freight confirmation letter confirmation module is used to generate a freight confirmation letter based on the voyage freight rate data, and generate a confirmed freight confirmation letter according to a preset confirmation letter synchronization rule.

[0064] The specific limitations of the automatic generation system of the coastal dry bulk cargo transportation freight rate confirmation letter can be found in the above limitations of the automatic generation method of the coastal dry bulk cargo transportation freight rate confirmation letter, which will not be repeated here. Each module in the above-mentioned automatic generation system of the coastal dry bulk cargo transportation freight rate confirmation letter can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0065] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Fig. 9As shown. The computer device includes a processor, a memory, a network interface and a database connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store shipping cost data and information. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for automatically generating a coastal dry bulk shipping freight rate confirmation letter is implemented.

[0066] In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the following steps when executing the computer program: Acquire the shipping electronic contract in real time, and acquire the contract terms information based on the shipping electronic contract; Obtaining a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; Calculate the voyage freight rate data based on the contract terms and the voyage benchmark freight rate; A freight rate confirmation letter is generated based on the voyage freight rate data, and a confirmed freight rate confirmation letter is generated according to a preset confirmation letter synchronization rule.

[0067] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented: Acquire the shipping electronic contract in real time, and acquire the contract terms information based on the shipping electronic contract; Obtaining a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; Calculate the voyage freight rate data based on the contract terms and the voyage benchmark freight rate; A freight rate confirmation letter is generated based on the voyage freight rate data, and a confirmed freight rate confirmation letter is generated according to a preset confirmation letter synchronization rule.

[0068] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0069] Those skilled in the art can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above.

[0070] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter, characterized in that: The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter comprises the following steps: Acquire the shipping electronic contract in real time, and acquire the contract terms information based on the shipping electronic contract; Obtaining a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; Calculate the voyage freight rate data based on the contract terms and the voyage benchmark freight rate; A freight rate confirmation letter is generated based on the voyage freight rate data, and a confirmed freight rate confirmation letter is generated according to a preset confirmation letter synchronization rule.

2. The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter according to claim 1, characterized in that: The real-time acquisition of the shipping electronic contract and the acquisition of contract terms information based on the shipping electronic contract specifically include: Acquire the electronic shipping contract in real time, input the electronic shipping contract into a preset transport contract evaluation model, and acquire contract information features; The contract information features are integrated to form contract clause information, wherein the contract clause information includes basic shipping information and contract calculation clause information.

3. The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter according to claim 1, characterized in that: Before obtaining the voyage benchmark freight rate based on the preset freight rate index database, the method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter further includes: Obtain the freight index website, input the preset RPA robot into the freight index website, and read the freight index information; The freight rate index information is integrated to form a freight rate index database.

4. The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter according to claim 3, characterized in that: The method of obtaining the freight index website and inputting the preset RPA robot into the freight index website to read the freight index information specifically includes: Based on the preset RPA robot, the freight index information features are obtained and the column header is read; According to the freight index information characteristics, the column header is read to read data in the freight index website, and the read data is integrated to form the freight index information.

5. The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter according to claim 1, characterized in that: The voyage freight rate data is calculated based on the contract terms information and the voyage benchmark freight rate, specifically including: Obtaining appropriate freight rate calculation rules in a preset freight rate calculation rule library based on the contract terms information; The voyage base freight rate is input into the freight rate calculation rules to obtain the voyage freight rate data.

6. The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter according to claim 1, characterized in that: The calculating of voyage freight rate data according to the contract terms information and the voyage benchmark freight rate also includes: Obtaining basic parameters of shipping rates, and obtaining shipping rate data in the contract terms information based on the basic parameters of shipping rates; The shipping fee data is used as the second voyage freight rate data.

7. The method for automatically generating a coastal dry bulk cargo transportation freight rate confirmation letter according to claim 1, characterized in that: The generating of the freight confirmation letter based on the voyage freight rate data and generating a confirmed freight confirmation letter according to a preset confirmation letter synchronization rule specifically includes: Input the voyage freight rate data into the preset freight rate confirmation letter template to generate a freight rate confirmation letter; Performing data conversion on the freight rate confirmation letter to obtain electronic metadata and confirmation letter business electronic data; The electronic metadata and confirmation letter business electronic data are sent to the confirmation terminal, and the confirmed freight rate confirmation letter is received.

8. An automatic generation system for coastal dry bulk cargo transportation freight rate confirmation letter, characterized in that: The automatic generation system of coastal dry bulk cargo transportation freight rate confirmation letter includes: A contract clause information generation module, used to obtain the shipping electronic contract in real time and obtain the contract clause information based on the shipping electronic contract; A voyage benchmark freight rate generation module, used to obtain a voyage benchmark freight rate based on a preset freight rate index database and the contract terms information; The voyage freight rate calculation module is used to calculate the voyage freight rate data according to the contract terms information and the voyage benchmark freight rate; The freight confirmation letter confirmation module is used to generate a freight confirmation letter based on the voyage freight rate data, and generate a confirmed freight confirmation letter according to a preset confirmation letter synchronization rule.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method for automatically generating a coastal dry bulk shipping freight rate confirmation letter as described in any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method for automatically generating a coastal dry bulk shipping freight rate confirmation letter as described in any one of claims 1 to 7 are implemented.

Images