CN118628227A - Logistics supply chain financial risk control method based on real-time data analysis - Google Patents
Logistics supply chain financial risk control method based on real-time data analysis Download PDFInfo
- Publication number
- CN118628227A CN118628227A CN202410700506.7A CN202410700506A CN118628227A CN 118628227 A CN118628227 A CN 118628227A CN 202410700506 A CN202410700506 A CN 202410700506A CN 118628227 A CN118628227 A CN 118628227A
- Authority
- CN
- China
- Prior art keywords
- data
- accounts receivable
- pool
- enterprise
- logistics
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/03—Credit; Loans; Processing thereof
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
Description
技术领域Technical Field
本发明涉及金融风险管控技术领域,具体涉及了一种基于实时数据分析的物流供应链金融风险控制方法。The present invention relates to the technical field of financial risk management and control, and in particular to a logistics supply chain financial risk control method based on real-time data analysis.
背景技术Background Art
物流企业是一种运输、货运公司的类型,泛指经营物流相关的运输、仓储、配送等行业的公司,物流企业常在供货商与零售业者之间扮演集货、理货、配送的角色。A logistics company is a type of transportation and freight company, and generally refers to companies that operate in logistics-related transportation, warehousing, distribution and other industries. Logistics companies often play the role of collecting, sorting and distributing goods between suppliers and retailers.
物流企业作为运输配送领域的中间角色,其营业收入主要由上游企业进行支付。然而由于项目周期或者是上游企业与物流企业之间按照周期进行结算,物流企业的资金回笼具有一定的周期性,例如上游企业在当月发布的物流订单,下月才会向物流企业支付运费,又或者是按季度进行结算。此类已经产生业务,但是还未回笼的资金,被称为应收账款,越是规模庞大,业务量越大的物流企业,应收账款的量就越大。As an intermediary in the field of transportation and distribution, logistics companies' operating income is mainly paid by upstream companies. However, due to the project cycle or the periodic settlement between upstream companies and logistics companies, the capital recovery of logistics companies has a certain periodicity. For example, the logistics orders issued by upstream companies in the current month will not be paid to logistics companies until the next month, or settlement is made on a quarterly basis. This type of funds that have generated business but have not yet been recovered are called accounts receivable. The larger the scale and the larger the business volume of the logistics company, the larger the amount of accounts receivable.
而物流企业为了保证自身正常运作,需要保证资金充足,因此对于未回笼的资金,物流企业通常会利用应收账款向银行或者是金融机构进行抵质押登记,以进行融资,在资金回笼后,再归还银行资金,解除抵质押登记。因此对于银行来说,需要对物流企业的金融风险进行识别,以此来决定是否给物流企业进行融资,以及在物流企业资金回笼后,追踪物流企业的资金回笼情况以及还款情况。目前,通常是物流企业负责人自己直接前往办理,银行对物流企业的资产情况以及业务情况进行收集,然后对物流企业的金融风险进行评估。然而物流企业通常会有多个上游企业,每一笔应收账款的来源不同,同时物流企业每一笔资金回笼的数据量较大,在进行风险评估时,由银行或金融机构来整理物流企业金融数据工作量庞大,且容易产生数据缺失,导致风险评估失误的问题。后续对也需要时刻追踪物流企业资金回笼以及还款。In order to ensure the normal operation of logistics enterprises, they need to ensure sufficient funds. Therefore, for the funds that have not been recovered, logistics enterprises usually use accounts receivable to register with banks or financial institutions for mortgages and pledges to obtain financing. After the funds are recovered, they return the bank funds and cancel the mortgage registration. Therefore, for banks, it is necessary to identify the financial risks of logistics enterprises to decide whether to provide financing to logistics enterprises, and to track the capital recovery and repayment of logistics enterprises after the funds of logistics enterprises are recovered. At present, it is usually the person in charge of logistics enterprises who goes directly to handle it. The bank collects the assets and business conditions of the logistics enterprises, and then evaluates the financial risks of the logistics enterprises. However, logistics enterprises usually have multiple upstream enterprises, and the sources of each account receivable are different. At the same time, the amount of data for each fund recovery of logistics enterprises is large. When conducting risk assessment, it is a huge workload for banks or financial institutions to sort out the financial data of logistics enterprises, and it is easy to have data missing, which leads to the problem of risk assessment errors. Subsequent tracking of the capital recovery and repayment of logistics enterprises is also required at all times.
发明内容Summary of the invention
本发明所解决的技术问题在于提供一种基于实时数据分析的物流供应链金融风险控制方法,能够帮助银行判断物流企业的金融风险。The technical problem solved by the present invention is to provide a logistics supply chain financial risk control method based on real-time data analysis, which can help banks judge the financial risks of logistics companies.
本发明提供的基础方案:一种基于实时数据分析的物流供应链金融风险控制方法,包括以下步骤:The basic solution provided by the present invention is a logistics supply chain financial risk control method based on real-time data analysis, comprising the following steps:
S100:采集各物流企业的实时金融数据;S100: Collect real-time financial data of logistics companies;
S200:对进行实时金融数据识别后,根据实时金融数据的金融状态,对企业资金数据池中的资金数据进行更新,所述资金数据池包括应收账款池、抵质押登记池、可抵质押应收账款池、资金回笼池;S200: after real-time financial data is identified, the capital data in the enterprise capital data pool is updated according to the financial status of the real-time financial data, wherein the capital data pool includes an accounts receivable pool, a mortgage registration pool, a mortgageable accounts receivable pool, and a capital recovery pool;
S300:根据各资金数据池中的资金数据变化,分析物流企业的金融风险。S300: Analyze the financial risks of logistics enterprises based on changes in fund data in each fund data pool.
本发明的原理及优点在于:通过采集到物流企业的实时金融数据,金融数据包括银行提供的数据以及企业自身提供的数据,当采集到物流企业的金融数据后,根据资金数据的金融类型,对物流企业的资金数据池进行更新,资金数据池包括有应收账款池、抵质押登记池、可抵质押应收账款池以及资金回笼池。其中应收账款池中的资金数据,是物料企业向上游企业应收但是没有收的资金,抵质押登记池中的资金数据,是物流企业已经抵质押给银行或融资机构的应收账款。可抵质押应收账款池中的资金数据,是来自银行或融资机构认可的上游企业的未进行抵质押的应收账款,资金回笼池的资金数据,是企业已经回笼的应收账款。通过实时获取到物流企业的金融数据,然后对企业资金池中的金融数据进行更新,例如当物流企业有新的应收账款时,应收账款池中的资金数据便会更新,若是产生应收账款的上游企业是收到银行或金融机构认可,这可抵质押应收账款池便会进行更新。此后根据各个资金池中的资金数据的变化,判断物流企业是否存在金融风险。例如应收账款持续下降,又或者是物料企业的资金回笼后,并没有及时归还等等。相比于现有技术,通过建立各个资金池,不同资金池归集不同类型的金融数据,直接对资金池中的金融数据进行监控,便能够直观明了确定物流企业的经营情况以及金融情况,根据实时金融数据,对资金池中的金融数据进行更新,及时反映物料企业资金变化情况,更加便于风险评估、追踪以及预警。The principle and advantage of the present invention are: by collecting the real-time financial data of the logistics enterprise, the financial data includes the data provided by the bank and the data provided by the enterprise itself. After the financial data of the logistics enterprise is collected, the capital data pool of the logistics enterprise is updated according to the financial type of the capital data. The capital data pool includes the accounts receivable pool, the pledge registration pool, the pledgeable accounts receivable pool and the capital recovery pool. The capital data in the accounts receivable pool is the funds that the material enterprise should collect from the upstream enterprise but has not collected. The capital data in the pledge registration pool is the accounts receivable that the logistics enterprise has pledged to the bank or financing institution. The capital data in the pledgeable accounts receivable pool is the accounts receivable that have not been pledged from the upstream enterprise recognized by the bank or financing institution. The capital data in the capital recovery pool is the accounts receivable that the enterprise has recovered. By acquiring the financial data of logistics enterprises in real time, the financial data in the enterprise's fund pool is updated. For example, when a logistics enterprise has new accounts receivable, the fund data in the accounts receivable pool will be updated. If the upstream enterprise that generates the accounts receivable is recognized by a bank or financial institution, the pledged accounts receivable pool will be updated. After that, according to the changes in the fund data in each fund pool, it is judged whether the logistics enterprise has financial risks. For example, accounts receivable continue to decline, or the funds of the material enterprise are not returned in time after being recovered, etc. Compared with the existing technology, by establishing various fund pools, different fund pools collect different types of financial data, and directly monitor the financial data in the fund pool, it is possible to intuitively and clearly determine the operating conditions and financial conditions of the logistics enterprise. According to real-time financial data, the financial data in the fund pool is updated to timely reflect the changes in the funds of the material enterprise, which is more convenient for risk assessment, tracking and early warning.
进一步,所述S200包括以下步骤:Further, the S200 includes the following steps:
S210:根据物流企业的业务数据,对应收账款池中的各上游企业的应收账款进行更新,根据实际发生业务计入,根据实际回款登出;S210: Based on the business data of the logistics enterprise, the accounts receivable of each upstream enterprise in the accounts receivable pool are updated, and the accounts receivable are recorded according to the actual business and logged out according to the actual payment;
S220:根据物流企业在银行或金融机构的应收账款质押登记数据以及应收账款回款数据,对抵质押登记池中的已抵质押应收账款进行更新,根据唯一抵质押有效登记计入,根据应收账款的实际回款或资方释放登出;S220: Update the pledged accounts receivable in the pledge registration pool according to the logistics enterprise's accounts receivable pledge registration data and accounts receivable collection data in banks or financial institutions, enter according to the only valid pledge registration, and log out according to the actual collection of accounts receivable or release by the capital party;
S230:根据物流企业的业务数据以及应收账款质押登记数据,对可抵质押应收账款池中的可抵质押应收账款进行更新,根据未进行抵质押登记的上游企业的应收账款计入,根据未进行抵质押登记的应收账款的实际回款或应收账款已抵质押登记登出;S230: Update the pledgeable accounts receivable in the pledgeable accounts receivable pool according to the business data of the logistics enterprise and the accounts receivable pledge registration data, include the accounts receivable of the upstream enterprises that have not been registered for pledge, and log out the accounts receivable according to the actual payment of the accounts receivable that have not been registered for pledge or the accounts receivable that have been registered for pledge;
S240:根据物料企业的应收账款回款数据,对资金回笼池中的应收账款的回款进行更新,根据应收账款的实际回款对资金回笼池进行计入。S240: Update the accounts receivable collection data in the capital recovery pool based on the accounts receivable collection data of the material enterprise, and include the accounts receivable collection data in the capital recovery pool based on the actual collection of accounts receivable.
应收账款池对物流企业的所有当前的应收账款进行记录,记录各个上游企业产生的应收账款,以实际发生的业务进行计入,依据可以是TMS真实性业务统计、上游企业对账单、运输合同及发票进行计入,根据实际回款登出,依据可以是物流企业的银行流水。抵质押登记池对物流企业已经向银行或金融机构抵质押登记的应收账款进行统计,以《动产和权利担保统一登记办法》作为实际依据,整合物流企业在银行进行的应收账款质押登记数据。根据唯一抵质押有效登记计入,依据为应收账款未回款且第三方抵质押登记查询有效,以应收账款回款或资方释放登出,依据为物流企业银行流水、融资机构抵质押释放情况及第三方抵质押登记查询未登记。可抵质押登记池对物流企业的可进行抵质押登记的资金数据进行管理,可抵质押登记池中的资金数据,是上游企业获得银行或金融机构的认可后,该上游企业产生的没有进行抵质押登记的应收账款。资金回笼池,即使对应收账款的资金回笼进行归集。The accounts receivable pool records all current accounts receivable of logistics enterprises, and the accounts receivable generated by each upstream enterprise. It is recorded based on the actual business, which can be based on TMS authenticity business statistics, upstream enterprise reconciliation statements, transportation contracts and invoices. It is logged out based on the actual payment, which can be based on the bank flow of the logistics enterprise. The pledge registration pool counts the accounts receivable that the logistics enterprise has registered for pledge with banks or financial institutions, and integrates the pledge registration data of the accounts receivable conducted by the logistics enterprise in the bank based on the "Uniform Registration Methods for Movable Property and Rights Guarantee". It is recorded based on the only valid registration of pledge, based on the fact that the accounts receivable have not been paid back and the third-party pledge registration query is valid, and is logged out based on the payment of accounts receivable or the release of the capital party, based on the bank flow of the logistics enterprise, the pledge release of the financing institution, and the fact that the third-party pledge registration query has not been registered. The pledge registration pool manages the data of funds that can be pledged by logistics enterprises. The funds in the pledge registration pool are the accounts receivable that have not been pledged and registered after the upstream enterprises have obtained the approval of banks or financial institutions. The fund recovery pool collects the funds recovered from accounts receivable.
本方案中,通过获取到物流企业的实时金融数据,生成各个资金池,当物流企业的资金数据产生变化时,便能够即时对各个资金池的资金数据进行更新,分析得到物流企业当前的应收账款,已抵质押的应收账款,可抵质押的应收账款,以及应收账款的回款情况。In this solution, by acquiring the real-time financial data of the logistics company, various fund pools are generated. When the fund data of the logistics company changes, the fund data of each fund pool can be updated immediately, and the current accounts receivable of the logistics company, the pledged accounts receivable, the pledgeable accounts receivable, and the collection status of the accounts receivable can be analyzed.
进一步,所述S300包括以下步骤:Further, the S300 includes the following steps:
S311:识别应收账款池中资金数据的数据波动情况;S311: Identify data fluctuations of fund data in the accounts receivable pool;
S321:按照预设的波动识别规则,对应收账款池中的资金数据的数据波动情况进行识别,分析物流企业是否具有金融风险。S321: According to the preset fluctuation identification rules, the data fluctuation of the fund data in the accounts receivable pool is identified to analyze whether the logistics enterprise has financial risks.
对物流企业的应收账款池中的资金数据的波动情况进行分析,应收账款池中的资金数据直接反映物流企业的业务经营情况,当物流企业的应收账款池中的资金数据出现较大波动时,则判断物流企业当前的业务经营存在一定问题,因此当识别得到应收账款池中的资金数据波动较大时,便可判断物流企业具有金融风险。Analyze the fluctuation of the capital data in the accounts receivable pool of the logistics company. The capital data in the accounts receivable pool directly reflects the business operation of the logistics company. When the capital data in the accounts receivable pool of the logistics company fluctuates greatly, it is judged that there are certain problems in the current business operation of the logistics company. Therefore, when it is identified that the capital data in the accounts receivable pool fluctuates greatly, it can be judged that the logistics company has financial risks.
进一步,所述S300还包括以下步骤:Furthermore, the S300 further includes the following steps:
S320:获取银行或金融机构对物流企业的已抵质押应收账款授予的融资金额;S320: Obtain the financing amount granted by the bank or financial institution to the pledged accounts receivable of the logistics enterprise;
S321:当获取到资金回笼池后的资金数据更新后,判断更新的资金数据对应的应收账款是否是已抵质押应收账款,若是则执行S322;S321: After the fund data of the fund recovery pool is updated, it is determined whether the accounts receivable corresponding to the updated fund data are pledged accounts receivable. If so, S322 is executed;
S322:将对应的应收账款从抵质押登记池中登出后,重新计算按照现有的已抵质押应收账款的融资额度,并获取物流企业还款数据,判断还款后的剩余欠款是否超过重新计算后的融资额度,若否判断不具有金融风险,若是则执行S323;S322: After the corresponding accounts receivable are deregistered from the pledge registration pool, the financing amount of the existing pledged accounts receivable is recalculated, and the repayment data of the logistics enterprise is obtained to determine whether the remaining amount after repayment exceeds the recalculated financing amount. If not, it is determined that there is no financial risk. If so, S323 is executed;
S323:获取物流企业的抵质押登记池中是否有新的已抵质押应收账款计入,若是则判断不具有金融风险,若否则判断具有金融风险。S323: Obtain whether there are new pledged accounts receivable in the pledge registration pool of the logistics enterprise. If so, it is judged that there is no financial risk. Otherwise, it is judged that there is financial risk.
银行或金融机构根据物流企业的应收账款的数量,授予物流企业融资金额,当物流企业的应收账款资金回笼后,首先判断回笼资金的应收账款是否是已抵质押的应收账款。若是则需要重新计算出授予物流企业的融资额度,由于物流企业将应收账款抵押给银行或金融机构,在这笔账款回款后,抵押给银行的应收账款的总额就会下降,因此此时需要重新计算出授予给物流企业的融资金额,再结合物流企业在资金回笼后的还款情况,判断目前物流企业所欠的钱是否超过授予的融资金额,若超过时,则是说明物流企业在应收账款的资金回笼后,归还给银行或金融机构的资金较少,此时需要判断物流企业是否有新的应收账款进行抵质押,即是否有应收账款从可抵质押应收账款池转移到抵质押登记池中。例如物流企业在银行抵质押登记有一笔200万的应收账款和一笔100万的应收账款,总共抵质押给银行300万的应收账款,假设根据300万的60%,授予了180万的融资金额,当物流企业200万的应收账款回笼后,抵质押给银行的,便仅有100万的应收账款,此时授予的融资金额便下降到60万,此时获取企业的还款情况,若是物料企业将欠银行的钱还款至60万以下,便认为是没有风险,或者是物流企业再引入一笔新的抵质押登记,引入后重新授予的融资金额高于当前未还的金额也可。Banks or financial institutions grant financing to logistics companies based on the amount of accounts receivable of logistics companies. When the accounts receivable funds of logistics companies are recovered, they first determine whether the accounts receivable of the recovered funds are accounts receivable that have been pledged. If so, it is necessary to recalculate the financing amount granted to the logistics company. Since the logistics company pledges the accounts receivable to the bank or financial institution, after the funds are recovered, the total amount of accounts receivable pledged to the bank will decrease. Therefore, it is necessary to recalculate the financing amount granted to the logistics company at this time, and then combine the repayment situation of the logistics company after the funds are recovered to determine whether the money currently owed by the logistics company exceeds the granted financing amount. If it exceeds, it means that the logistics company has less funds returned to the bank or financial institution after the funds of the accounts receivable are recovered. At this time, it is necessary to determine whether the logistics company has new accounts receivable for pledge, that is, whether there are accounts receivable transferred from the pledgeable accounts receivable pool to the pledge registration pool. For example, a logistics company has a 2 million account receivable and a 1 million account receivable registered as collateral with a bank, with a total of 3 million account receivable pledged to the bank. Assuming that 60% of 3 million is used to grant a financing amount of 1.8 million, when the 2 million account receivable of the logistics company is recovered, only 1 million account receivable will be pledged to the bank. At this time, the granted financing amount will drop to 600,000. At this time, the company's repayment situation is obtained. If the material company repays the money owed to the bank to less than 600,000, it is considered to be risk-free. Alternatively, the logistics company introduces a new collateral registration, and the amount of financing re-granted after the introduction is also acceptable if it is higher than the current outstanding amount.
进一步,还包括以下步骤:Further, the method further comprises the following steps:
S410:计算物流企业的剩余欠款与更新后的融资金额的差值;S410: Calculate the difference between the remaining debt of the logistics enterprise and the updated financing amount;
S420:根据差值从可抵质押应收账款池中选择合适的可抵质押应收账款,发送给物流企业。S420: Select appropriate pledgeable accounts receivable from the pledgeable accounts receivable pool based on the difference and send it to the logistics enterprise.
当物流企业在应收账款资金回笼后,抵押给银行的应收账款金额不足时,若需要将新的应收账款进行抵质押,根据剩余欠款与融资金额的差值,从可抵质押应收账款中,选择出最合适的可抵质押应收账款,告知给物流企业。When the amount of accounts receivable pledged to the bank by a logistics enterprise is insufficient after the funds of accounts receivable are recovered, if new accounts receivable need to be pledged, the most suitable accounts receivable that can be pledged shall be selected from the pledgeable accounts receivable based on the difference between the remaining debt and the financing amount, and the pledged accounts receivable shall be notified to the logistics enterprise.
进一步,还包括以下步骤:Further, the method further comprises the following steps:
S500:识别物流企业关联的上游企业以及各上游企业的应收账款所在的资金数据池;S500: Identify the upstream enterprises associated with the logistics enterprise and the fund data pool where the accounts receivable of each upstream enterprise are located;
S510:将上游企业在资金回笼池中的应收账款标记为第一账款,将企业应收账款标记为第二账款;S510: Mark the accounts receivable of the upstream enterprise in the capital recovery pool as the first account, and mark the enterprise's accounts receivable as the second account;
S520:识别不同周期中同一上游企业的第一账款和第二账款的比例,判断上游企业第一账款和第二账款的比例波动是否在预设的波动范围内,当在波动范围内的上游企业数量高于物流企业关联的上游企业的占比阈值,则判断该物流企业具有金融风险,否则判断不具有金融风险。S520: Identify the ratio of the first account and the second account of the same upstream enterprise in different periods, and determine whether the fluctuation of the ratio of the first account and the second account of the upstream enterprise is within a preset fluctuation range. When the number of upstream enterprises within the fluctuation range is higher than the proportion threshold of the upstream enterprises associated with the logistics enterprise, the logistics enterprise is judged to have financial risks, otherwise it is judged to have no financial risks.
将在资金回笼池中的应收账款,即已经汇款的账款标记为第一账款,其余的未回款的账款标记为第二账款。识别不同周期中同一上游企业的第一账款和第二账款的比例,即已回款的账款和未回款的账款的比例。判断不同周期上游企业的第一账款和第二账款的比例是否在预设的波动范围内,当在波动范围内时,则说明与该上游企业近期的业务往来以及回款较为稳定。当物流企业关联的上游企业数量较多时,判断该物流不具有金融风险,否则判断具有金融风险。Mark the accounts receivable in the fund recovery pool, that is, the accounts receivable that have been remitted, as the first accounts receivable, and the remaining accounts receivable that have not been remitted as the second accounts receivable. Identify the ratio of the first accounts receivable and the second accounts receivable of the same upstream enterprise in different cycles, that is, the ratio of the accounts receivable that have been remitted to the accounts receivable that have not been remitted. Determine whether the ratio of the first accounts receivable and the second accounts receivable of upstream enterprises in different cycles is within the preset fluctuation range. If it is within the fluctuation range, it means that the recent business dealings and collection of funds with the upstream enterprise are relatively stable. When the number of upstream enterprises associated with a logistics enterprise is large, it is judged that the logistics does not have financial risks, otherwise it is judged to have financial risks.
进一步,还包括以下步骤:Further, the method further comprises the following steps:
S530:当识别到物流企业具有金融风险时,将第一账款和第二账款的比例波动不在预设的波动范围内的上游企业标记为风险企业,并识别各个风险企业的第二账款所在的资金数据池;S530: When it is identified that the logistics enterprise has financial risks, the upstream enterprises whose ratio fluctuation of the first account and the second account is not within the preset fluctuation range are marked as risky enterprises, and the fund data pool where the second account of each risky enterprise is located is identified;
S540:若风险企业在抵质押等级池与可抵质押等级池中的应收账款高于第二账款中的其余应收账款时,取消风险企业的标记;S540: If the accounts receivable of the risk enterprise in the pledge level pool and the pledgeable level pool are higher than the remaining accounts receivable in the second account, the risk enterprise mark is cancelled;
S550:重新执行S520,重新执行时,将取消风险标记的上游企业视为第一账款和第二账款的比例波动在预设的波动范围内的上游企业。S550: Re-execute S520. When re-executed, the upstream enterprise whose risk mark is cancelled is regarded as an upstream enterprise whose ratio fluctuation of the first account and the second account is within a preset fluctuation range.
进一步,所述S200还包括以下步骤:Furthermore, the S200 further includes the following steps:
S250:分别设置不同的数据库存储不同资金数据池的资金数据,包括应收账款数据库、抵质押登记数据库、可抵质押应收账款数据库以及资金回笼数据库,还包括备份数据库;S250: Different databases are respectively set up to store fund data of different fund data pools, including an accounts receivable database, a mortgage registration database, a mortgageable accounts receivable database, and a fund recovery database, and also includes a backup database;
S251:当采集到实时金融数据后,将实时金融数据转换为资金数据存放进对应资金数据池所对应的数据库,并根据资金数据对资金数据池的状态进行更新;S251: After the real-time financial data is collected, the real-time financial data is converted into capital data and stored in a database corresponding to the corresponding capital data pool, and the status of the capital data pool is updated according to the capital data;
S252:识别原始实时金融数据转换为资金数据存放进数据库中时,存放的数据库数量、数据库的库名以及资金数据存放时的时间戳;S252: When the original real-time financial data is converted into fund data and stored in the database, the number of the stored database, the database name, and the timestamp when the fund data is stored are identified;
S253:当原始实时金融数据转换为资金数据后,存放的数据数据库数量为一时,执行步骤S254,存放的数据库数量超过一时,执行步骤S255;S253: When the number of the stored data databases after the original real-time financial data is converted into capital data is one, step S254 is executed; when the number of the stored data databases exceeds one, step S255 is executed;
S254:将资金数据与存放时的时间戳生成备份文件,将备份文件存储至备份数据库;S254: Generate a backup file with the fund data and the timestamp when the storage is performed, and store the backup file in a backup database;
S255:识别所存放的各个数据库的库名,生成该资金数据的存放数据库信息,将存放数据库信息与时间戳存放至备份数据库;S255: Identify the database name of each stored database, generate the storage database information of the fund data, and store the storage database information and timestamp into the backup database;
还包括以下步骤:The following steps are also included:
S600:当有数据库存在数据丢失时,识别备份数据库中丢失数据对应时间戳是否存在备份文件,若存在备份文件,根据备份文件还原丢失数据,若不存在备份文件,查询对应时间戳的存放数据库信息,查询其余存储丢失数据对应的数据库的库名,从其他数据库中还原丢失数据。S600: When data is lost in a database, identify whether there is a backup file corresponding to the timestamp of the lost data in the backup database. If there is a backup file, restore the lost data according to the backup file. If there is no backup file, query the storage database information of the corresponding timestamp, query the library names of other databases corresponding to the lost data, and restore the lost data from other databases.
附图说明BRIEF DESCRIPTION OF THE DRAWINGS
图1为本发明一种基于实时数据分析的物流供应链金融风险控制方法实施例的流程示意图。FIG1 is a flow chart of an embodiment of a logistics supply chain financial risk control method based on real-time data analysis according to the present invention.
具体实施方式DETAILED DESCRIPTION
下面通过具体实施方式进一步详细说明:The following is further described in detail through specific implementation methods:
实施例基本如附图1所示:The embodiment is basically as shown in Figure 1:
一种基于实时数据分析的物流供应链金融风险控制方法,包括以下步骤:A logistics supply chain financial risk control method based on real-time data analysis includes the following steps:
S100:采集各物流企业的实时金融数据;S100: Collect real-time financial data of logistics companies;
S200:对进行实时金融数据识别后,根据实时金融数据的金融状态,对企业资金数据池中的资金数据进行更新,所述资金数据池包括应收账款池、抵质押登记池、可抵质押应收账款池、资金回笼池;S200: after real-time financial data is identified, the capital data in the enterprise capital data pool is updated according to the financial status of the real-time financial data, wherein the capital data pool includes an accounts receivable pool, a mortgage registration pool, a mortgageable accounts receivable pool, and a capital recovery pool;
S300:根据各资金数据池中的资金数据变化,分析物流企业的金融风险。S300: Analyze the financial risks of logistics enterprises based on changes in fund data in each fund data pool.
通过采集到物流企业的实时金融数据,金融数据包括银行提供的数据以及企业自身提供的数据,当采集到物流企业的金融数据后,根据资金数据的金融类型,对物流企业的资金数据池进行更新,资金数据池包括有应收账款池、抵质押登记池、可抵质押应收账款池以及资金回笼池。其中应收账款池中的资金数据,是物料企业向上游企业应收但是没有收的资金,抵质押登记池中的资金数据,是物流企业已经抵质押给银行或融资机构的应收账款。可抵质押应收账款池中的资金数据,是来自银行或融资机构认可的上游企业的未进行抵质押的应收账款,资金回笼池的资金数据,是企业已经回笼的应收账款。通过实时获取到物流企业的金融数据,然后对企业资金池中的金融数据进行更新,例如当物流企业有新的应收账款时,应收账款池中的资金数据便会更新,若是产生应收账款的上游企业是收到银行或金融机构认可,这可抵质押应收账款池便会进行更新。此后根据各个资金池中的资金数据的变化,判断物流企业是否存在金融风险。例如应收账款持续下降,又或者是物料企业的资金回笼后,并没有及时归还等等。相比于现有技术,通过建立各个资金池,不同资金池归集不同类型的金融数据,直接对资金池中的金融数据进行监控,便能够直观明了确定物流企业的经营情况以及金融情况,根据实时金融数据,对资金池中的金融数据进行更新,及时反映物料企业资金变化情况,更加便于风险评估、追踪以及预警。By collecting the real-time financial data of logistics enterprises, including data provided by banks and data provided by the enterprises themselves, after collecting the financial data of logistics enterprises, the capital data pool of logistics enterprises is updated according to the financial type of capital data. The capital data pool includes accounts receivable pool, pledge registration pool, pledgeable accounts receivable pool and capital recovery pool. The capital data in the accounts receivable pool is the funds that the material enterprises should receive from upstream enterprises but have not received. The capital data in the pledge registration pool is the accounts receivable that the logistics enterprises have pledged to banks or financing institutions. The capital data in the pledgeable accounts receivable pool is the accounts receivable that have not been pledged from upstream enterprises recognized by banks or financing institutions. The capital data in the capital recovery pool is the accounts receivable that the enterprise has recovered. By acquiring the financial data of logistics enterprises in real time, the financial data in the enterprise's fund pool is updated. For example, when a logistics enterprise has new accounts receivable, the fund data in the accounts receivable pool will be updated. If the upstream enterprise that generates the accounts receivable is recognized by a bank or financial institution, the pledged accounts receivable pool will be updated. After that, according to the changes in the fund data in each fund pool, it is judged whether the logistics enterprise has financial risks. For example, accounts receivable continue to decline, or the funds of the material enterprise are not returned in time after being recovered, etc. Compared with the existing technology, by establishing various fund pools, different fund pools collect different types of financial data, and directly monitor the financial data in the fund pool, it is possible to intuitively and clearly determine the operating conditions and financial conditions of the logistics enterprise. According to real-time financial data, the financial data in the fund pool is updated to timely reflect the changes in the funds of the material enterprise, which is more convenient for risk assessment, tracking and early warning.
所述S200包括以下步骤:The S200 includes the following steps:
S210:根据物流企业的业务数据,对应收账款池中的各上游企业的应收账款进行更新,根据实际发生业务计入,根据实际回款登出;S210: Based on the business data of the logistics enterprise, the accounts receivable of each upstream enterprise in the accounts receivable pool are updated, and the accounts receivable are recorded according to the actual business and logged out according to the actual payment;
S220:根据物流企业在银行或金融机构的应收账款质押登记数据以及应收账款回款数据,对抵质押登记池中的已抵质押应收账款进行更新,根据唯一抵质押有效登记计入,根据应收账款的实际回款或资方释放登出;S220: Update the pledged accounts receivable in the pledge registration pool according to the logistics enterprise's accounts receivable pledge registration data and accounts receivable collection data in banks or financial institutions, enter according to the only valid pledge registration, and log out according to the actual collection of accounts receivable or release by the capital party;
S230:根据物流企业的业务数据以及应收账款质押登记数据,对可抵质押应收账款池中的可抵质押应收账款进行更新,根据未进行抵质押登记的上游企业的应收账款计入,根据未进行抵质押登记的应收账款的实际回款或应收账款已抵质押登记登出;S230: Update the pledgeable accounts receivable in the pledgeable accounts receivable pool according to the business data of the logistics enterprise and the accounts receivable pledge registration data, include the accounts receivable of the upstream enterprises that have not been registered for pledge, and log out the accounts receivable according to the actual payment of the accounts receivable that have not been registered for pledge or the accounts receivable that have been registered for pledge;
S240:根据物料企业的应收账款回款数据,对资金回笼池中的应收账款的回款进行更新,根据应收账款的实际回款对资金回笼池进行计入。S240: Update the accounts receivable collection data in the capital recovery pool based on the accounts receivable collection data of the material enterprise, and include the accounts receivable collection data in the capital recovery pool based on the actual collection of accounts receivable.
应收账款池对物流企业的所有当前的应收账款进行记录,记录各个上游企业产生的应收账款,以实际发生的业务进行计入,依据可以是TMS真实性业务统计、上游企业对账单、运输合同及发票进行计入,根据实际回款登出,依据可以是物流企业的银行流水。抵质押登记池对物流企业已经向银行或金融机构抵质押登记的应收账款进行统计,以《动产和权利担保统一登记办法》作为实际依据,整合物流企业在银行进行的应收账款质押登记数据。根据唯一抵质押有效登记计入,依据为应收账款未回款且第三方抵质押登记查询有效,以应收账款回款或资方释放登出,依据为物流企业银行流水、融资机构抵质押释放情况及第三方抵质押登记查询未登记。可抵质押登记池对物流企业的可进行抵质押登记的资金数据进行管理,可抵质押登记池中的资金数据,是上游企业获得银行或金融机构的认可后,该上游企业产生的没有进行抵质押登记的应收账款。资金回笼池,即使对应收账款的资金回笼进行归集。The accounts receivable pool records all current accounts receivable of logistics enterprises, and the accounts receivable generated by each upstream enterprise. It is recorded based on the actual business, which can be based on TMS authenticity business statistics, upstream enterprise reconciliation statements, transportation contracts and invoices. It is logged out based on the actual payment, which can be based on the bank flow of the logistics enterprise. The pledge registration pool counts the accounts receivable that the logistics enterprise has registered for pledge with banks or financial institutions, and integrates the pledge registration data of the accounts receivable conducted by the logistics enterprise in the bank based on the "Uniform Registration Methods for Movable Property and Rights Guarantee". It is recorded based on the only valid registration of pledge, based on the fact that the accounts receivable have not been paid back and the third-party pledge registration query is valid, and is logged out based on the payment of accounts receivable or the release of the capital party, based on the bank flow of the logistics enterprise, the pledge release of the financing institution, and the fact that the third-party pledge registration query has not been registered. The pledge registration pool manages the data of funds that can be pledged by logistics enterprises. The funds in the pledge registration pool are the accounts receivable that have not been pledged and registered after the upstream enterprises have obtained the approval of banks or financial institutions. The fund recovery pool collects the funds recovered from accounts receivable.
通过获取到物流企业的实时金融数据,生成各个资金池,当物流企业的资金数据产生变化时,便能够即时对各个资金池的资金数据进行更新,分析得到物流企业当前的应收账款,已抵质押的应收账款,可抵质押的应收账款,以及应收账款的回款情况。By acquiring the real-time financial data of logistics companies and generating various fund pools, when the fund data of logistics companies changes, the fund data of each fund pool can be updated immediately, and the current accounts receivable of the logistics companies, the accounts receivable that have been pledged, the accounts receivable that can be pledged, and the collection status of the accounts receivable can be obtained through analysis.
所述S300包括以下步骤:The S300 includes the following steps:
S311:识别应收账款池中资金数据的数据波动情况;S311: Identify data fluctuations of fund data in the accounts receivable pool;
S321:按照预设的波动识别规则,对应收账款池中的资金数据的数据波动情况进行识别,分析物流企业是否具有金融风险。S321: According to the preset fluctuation identification rules, the data fluctuation of the fund data in the accounts receivable pool is identified to analyze whether the logistics enterprise has financial risks.
对物流企业的应收账款池中的资金数据的波动情况进行分析,应收账款池中的资金数据直接反映物流企业的业务经营情况,当物流企业的应收账款池中的资金数据出现较大波动时,则判断物流企业当前的业务经营存在一定问题,因此当识别得到应收账款池中的资金数据波动较大时,便可判断物流企业具有金融风险。Analyze the fluctuation of the capital data in the accounts receivable pool of the logistics company. The capital data in the accounts receivable pool directly reflects the business operation of the logistics company. When the capital data in the accounts receivable pool of the logistics company fluctuates greatly, it is judged that there are certain problems in the current business operation of the logistics company. Therefore, when it is identified that the capital data in the accounts receivable pool fluctuates greatly, it can be judged that the logistics company has financial risks.
所述S300还包括以下步骤:The S300 further includes the following steps:
S320:获取银行或金融机构对物流企业的已抵质押应收账款授予的融资金额;S320: Obtain the financing amount granted by the bank or financial institution to the pledged accounts receivable of the logistics enterprise;
S321:当获取到资金回笼池后的资金数据更新后,判断更新的资金数据对应的应收账款是否是已抵质押应收账款,若是则执行S322;S321: After the fund data of the fund recovery pool is updated, it is determined whether the accounts receivable corresponding to the updated fund data are pledged accounts receivable. If so, S322 is executed;
S322:将对应的应收账款从抵质押登记池中登出后,重新计算按照现有的已抵质押应收账款的融资额度,并获取物流企业还款数据,判断还款后的剩余欠款是否超过重新计算后的融资额度,若否判断不具有金融风险,若是则执行S323;S322: After the corresponding accounts receivable are deregistered from the pledge registration pool, the financing amount of the existing pledged accounts receivable is recalculated, and the repayment data of the logistics enterprise is obtained to determine whether the remaining amount after repayment exceeds the recalculated financing amount. If not, it is determined that there is no financial risk. If so, S323 is executed;
S323:获取物流企业的抵质押登记池中是否有新的已抵质押应收账款计入,若是则判断不具有金融风险,若否则判断具有金融风险。S323: Obtain whether there are new pledged accounts receivable in the pledge registration pool of the logistics enterprise. If so, it is judged that there is no financial risk. Otherwise, it is judged that there is financial risk.
银行或金融机构根据物流企业的应收账款的数量,授予物流企业融资金额,当物流企业的应收账款资金回笼后,首先判断回笼资金的应收账款是否是已抵质押的应收账款。若是则需要重新计算出授予物流企业的融资额度,由于物流企业将应收账款抵押给银行或金融机构,在这笔账款回款后,抵押给银行的应收账款的总额就会下降,因此此时需要重新计算出授予给物流企业的融资金额,再结合物流企业在资金回笼后的还款情况,判断目前物流企业所欠的钱是否超过授予的融资金额,若超过时,则是说明物流企业在应收账款的资金回笼后,归还给银行或金融机构的资金较少,此时需要判断物流企业是否有新的应收账款进行抵质押,即是否有应收账款从可抵质押应收账款池转移到抵质押登记池中。例如物流企业在银行抵质押登记有一笔200万的应收账款和一笔100万的应收账款,总共抵质押给银行300万的应收账款,假设根据300万的60%,授予了180万的融资金额,当物流企业200万的应收账款回笼后,抵质押给银行的,便仅有100万的应收账款,此时授予的融资金额便下降到60万,此时获取企业的还款情况,若是物料企业将欠银行的钱还款至60万以下,便认为是没有风险,或者是物流企业再引入一笔新的抵质押登记,引入后重新授予的融资金额高于当前未还的金额也可。Banks or financial institutions grant financing to logistics companies based on the amount of accounts receivable of logistics companies. When the accounts receivable funds of logistics companies are recovered, they first determine whether the accounts receivable of the recovered funds are accounts receivable that have been pledged. If so, it is necessary to recalculate the financing amount granted to the logistics company. Since the logistics company pledges the accounts receivable to the bank or financial institution, after the funds are recovered, the total amount of accounts receivable pledged to the bank will decrease. Therefore, it is necessary to recalculate the financing amount granted to the logistics company at this time, and then combine the repayment situation of the logistics company after the funds are recovered to determine whether the money currently owed by the logistics company exceeds the granted financing amount. If it exceeds, it means that the logistics company has less funds returned to the bank or financial institution after the funds of the accounts receivable are recovered. At this time, it is necessary to determine whether the logistics company has new accounts receivable for pledge, that is, whether there are accounts receivable transferred from the pledgeable accounts receivable pool to the pledge registration pool. For example, a logistics company has a 2 million account receivable and a 1 million account receivable registered as collateral with a bank, with a total of 3 million account receivable pledged to the bank. Assuming that 60% of 3 million is used to grant a financing amount of 1.8 million, when the 2 million account receivable of the logistics company is recovered, only 1 million account receivable will be pledged to the bank. At this time, the granted financing amount will drop to 600,000. At this time, the company's repayment situation is obtained. If the material company repays the money owed to the bank to less than 600,000, it is considered to be risk-free. Alternatively, the logistics company introduces a new collateral registration, and the amount of financing re-granted after the introduction is also acceptable if it is higher than the current outstanding amount.
S410:计算物流企业的剩余欠款与更新后的融资金额的差值;S410: Calculate the difference between the remaining debt of the logistics enterprise and the updated financing amount;
S420:根据差值从可抵质押应收账款池中选择合适的可抵质押应收账款,发送给物流企业。S420: Select appropriate pledgeable accounts receivable from the pledgeable accounts receivable pool based on the difference and send it to the logistics enterprise.
实施例二Embodiment 2
本实施例和实施例一的区别在于,还包括以下步骤:The difference between this embodiment and the first embodiment is that the following steps are further included:
S500:识别物流企业关联的上游企业以及各上游企业的各笔应收账款所在的资金数据池;S500: Identify the upstream enterprises associated with the logistics enterprise and the fund data pool where each account receivable of each upstream enterprise is located;
S510:将上游企业在资金回笼池中的应收账款标记为第一账款,将企业应收账款标记为第二账款;S510: Mark the accounts receivable of the upstream enterprise in the capital recovery pool as the first account, and mark the enterprise's accounts receivable as the second account;
S520:识别不同周期中同一上游企业的第一账款和第二账款的比例,判断上游企业第一账款和第二账款的比例波动是否在预设的波动范围内,当在波动范围内的上游企业数量高于物流企业关联的上游企业的占比阈值,则判断该物流企业具有金融风险,否则判断不具有金融风险。S520: Identify the ratio of the first account and the second account of the same upstream enterprise in different periods, and determine whether the fluctuation of the ratio of the first account and the second account of the upstream enterprise is within a preset fluctuation range. When the number of upstream enterprises within the fluctuation range is higher than the proportion threshold of the upstream enterprises associated with the logistics enterprise, the logistics enterprise is judged to have financial risks, otherwise it is judged to have no financial risks.
具体的,本实例中,还会识别与物流企业关联的上游企业,以及来自上游企业的各笔应收账款所在的资金数据池。将在资金回笼池中的应收账款,即已经汇款的账款标记为第一账款,其余的未回款的账款标记为第二账款。识别不同周期中同一上游企业的第一账款和第二账款的比例,即已回款的账款和未回款的账款的比例。判断不同周期上游企业的第一账款和第二账款的比例是否在预设的波动范围内,当在波动范围内时,则说明与该上游企业近期的业务往来以及回款较为稳定。当物流企业关联的上游企业数量较多时,判断该物流不具有金融风险,否则判断具有金融风险。Specifically, in this example, upstream enterprises associated with the logistics enterprise and the fund data pool where each account receivable from the upstream enterprise is located are also identified. The accounts receivable in the fund recovery pool, that is, the accounts receivable that have been remitted, are marked as the first accounts receivable, and the remaining accounts receivable that have not been recovered are marked as the second accounts receivable. The ratio of the first accounts receivable and the second accounts receivable of the same upstream enterprise in different periods is identified, that is, the ratio of the accounts receivable that have been recovered and the accounts receivable that have not been recovered. It is determined whether the ratio of the first accounts receivable and the second accounts receivable of the upstream enterprise in different periods is within the preset fluctuation range. If it is within the fluctuation range, it means that the recent business dealings and collection of funds with the upstream enterprise are relatively stable. When the number of upstream enterprises associated with a logistics enterprise is large, it is judged that the logistics does not have financial risks, otherwise it is judged that it has financial risks.
S530:当识别到物流企业具有金融风险时,将第一账款和第二账款的比例波动不在预设的波动范围内的上游企业标记为风险企业,并识别各个风险企业的第二账款所在的资金数据池;S530: When it is identified that the logistics enterprise has financial risks, the upstream enterprises whose ratio fluctuation of the first account and the second account is not within the preset fluctuation range are marked as risky enterprises, and the fund data pool where the second account of each risky enterprise is located is identified;
S540:若风险企业在抵质押等级池与可抵质押等级池中的应收账款高于第二账款中的其余应收账款时,取消风险企业的标记;S540: If the accounts receivable of the risk enterprise in the pledge level pool and the pledgeable level pool are higher than the remaining accounts receivable in the second account, the risk enterprise mark is cancelled;
S550:重新执行S520,重新执行时,将取消风险标记的上游企业视为第一账款和第二账款的比例波动在预设的波动范围内的上游企业。S550: Re-execute S520. When re-executed, the upstream enterprise whose risk mark is cancelled is regarded as an upstream enterprise whose ratio fluctuation of the first account and the second account is within a preset fluctuation range.
实施例三Embodiment 3
本实施例和实施例一的区别在于,本实施例中,所述S200还包括以下步骤:The difference between this embodiment and the first embodiment is that, in this embodiment, S200 further includes the following steps:
S250:分别设置不同的数据库存储不同资金数据池的资金数据,包括应收账款数据库、抵质押登记数据库、可抵质押应收账款数据库以及资金回笼数据库,还包括备份数据库;S250: Different databases are respectively set up to store fund data of different fund data pools, including an accounts receivable database, a mortgage registration database, a mortgageable accounts receivable database, and a fund recovery database, and also includes a backup database;
S251:当采集到实时金融数据后,将实时金融数据转换为资金数据存放进对应资金数据池所对应的数据库,并根据资金数据对资金数据池的状态进行更新;S251: After the real-time financial data is collected, the real-time financial data is converted into capital data and stored in a database corresponding to the corresponding capital data pool, and the status of the capital data pool is updated according to the capital data;
S252:识别原始实时金融数据转换为资金数据存放进数据库中时,存放的数据库数量、数据库的库名以及资金数据存放时的时间戳;S252: When the original real-time financial data is converted into fund data and stored in the database, the number of the stored database, the database name, and the timestamp when the fund data is stored are identified;
S253:当原始实时金融数据转换为资金数据后,存放的数据数据库数量为一时,执行步骤S254,存放的数据库数量超过一时,执行步骤S255;S253: When the number of the stored data databases after the original real-time financial data is converted into capital data is one, step S254 is executed; when the number of the stored data databases exceeds one, step S255 is executed;
S254:将资金数据与存放时的时间戳生成备份文件,将备份文件存储至备份数据库;S254: Generate a backup file with the fund data and the timestamp when the storage is performed, and store the backup file in a backup database;
S255:识别所存放的各个数据库的库名,生成该资金数据的存放数据库信息,将存放数据库信息与时间戳存放至备份数据库;S255: Identify the database name of each stored database, generate the storage database information of the fund data, and store the storage database information and timestamp into the backup database;
还包括以下步骤:The following steps are also included:
S600:当有数据库存在数据丢失时,识别备份数据库中丢失数据对应时间戳是否存在备份文件,若存在备份文件,根据备份文件还原丢失数据,若不存在备份文件,查询对应时间戳的存放数据库信息,查询其余存储丢失数据对应的数据库的库名,从其他数据库中还原丢失数据。S600: When data is lost in a database, identify whether there is a backup file corresponding to the timestamp of the lost data in the backup database. If there is a backup file, restore the lost data according to the backup file. If there is no backup file, query the storage database information of the corresponding timestamp, query the library names of other databases corresponding to the lost data, and restore the lost data from other databases.
具体的,本实施例中,通过设置不同的数据库管理不同资金数据池的资金数据,包括有应收账款数据库、抵质押登记数据库、可抵质押应收账款数据库和资金回笼数据库,应收账款数据库对应收账款池的资金数据进行存储,抵质押登记数据库对抵质押登记池中的资金数据进行存储,可抵质押应收账款数据库对可抵质押应收账款池中的资金数据进行存储,资金回笼数据库对资金回笼池中的资金数据进行存储。通过在数据库中存放资金数据的变动记录,便于后续对各个资金数据池的变化进行追溯,同时通过不同的数据库对不同资金数据池的数据进行存储,通过数据库内存储的数据,可以查看各个资金池中的增加和减少的情况。各个资金数据池的数据相互独立,便于对不同金融状态的数据进行管理。Specifically, in this embodiment, different databases are set up to manage the fund data of different fund data pools, including accounts receivable database, pledge registration database, pledgeable accounts receivable database and fund recovery database. The accounts receivable database stores the fund data of the accounts receivable pool, the pledge registration database stores the fund data in the pledge registration pool, the pledgeable accounts receivable database stores the fund data in the pledgeable accounts receivable pool, and the fund recovery database stores the fund data in the fund recovery pool. By storing the change records of fund data in the database, it is convenient to trace the changes of each fund data pool later. At the same time, the data of different fund data pools are stored in different databases. Through the data stored in the database, the increase and decrease in each fund pool can be viewed. The data of each fund data pool is independent of each other, which is convenient for managing data in different financial states.
当获取到实时金融数据后,将实时金融数据转换为资金数据后存放至对应的数据库,例如当获取到物流企业与上游企业产生业务计入后,生成应收账款的资金数据,并将该应收账款的资金数据存放至应收账款池的状态进行更新。同时,在原始数据转换为资金数据存放进数据库中时,识别存放的数据库数量、数据库的库名以及资金数据存放时的时间戳。由于有些资金数据会存在多个资金数据池中的情况,例如实际回款会在应收账款池中登出,若是抵质押的应收账款,还会在抵质押登记池中登出,以及在资金回笼池计入。而这笔回款数据,将会被记录在多个数据库中,因此当原始实时金融数据转换为资金数据后识别,原始数据转换为资金数据后存放的数据库的数量,以及数据库名。After obtaining real-time financial data, the real-time financial data is converted into capital data and stored in the corresponding database. For example, after obtaining the business data generated by the logistics enterprise and the upstream enterprise, the capital data of the accounts receivable is generated, and the capital data of the accounts receivable is stored in the state of the accounts receivable pool for updating. At the same time, when the original data is converted into capital data and stored in the database, the number of stored databases, the database name, and the timestamp when the capital data is stored are identified. Because some capital data may exist in multiple capital data pools, for example, the actual collection will be logged out in the accounts receivable pool. If it is a pledged account receivable, it will also be logged out in the pledge registration pool and included in the capital recovery pool. This collection data will be recorded in multiple databases. Therefore, when the original real-time financial data is converted into capital data, the number of databases and the database name where the original data is stored after being converted into capital data are identified.
在数据存储时,数据库可能因为硬件故障、软件故障、人为错误等原因导致数据丢失,因此通常都会进行数据备份。本方案中,由于同一个资金数据可能被多个数据库进行存储,因此在存储时,识别资金数据是否存在多个数据库中,当只存在一个数据库中,则将资金数据生成备份文件,备份在备份数据库中。而当存储在多个数据库中时,则生成存放数据库信息,存放数据库信息内容为该条资金数据存放在了哪些数据库里。当识别到出现数据缺失时,首先查询备份数据库中是否有缺失数据对应时间戳的备份文件,若是有备份文件,则直接根据备份文件进行还原。若是没有备份文件,则查询存放数据库信息,根据存放数据库信息查找到该项资金数据还存放在了哪些数据库中,从而从其他数据库中提取出该项资金数据进行还原。通过本发明中技术方案,在备份时,无需备份全部数据,从而减少备份文件占用空间,提高备份数据量。When storing data, the database may lose data due to hardware failure, software failure, human error, etc., so data backup is usually performed. In this solution, since the same fund data may be stored in multiple databases, when storing, it is identified whether the fund data exists in multiple databases. When it exists in only one database, a backup file is generated for the fund data and backed up in the backup database. When it is stored in multiple databases, storage database information is generated, and the storage database information content is which databases the fund data is stored in. When it is identified that data is missing, first query the backup database to see if there is a backup file with a timestamp corresponding to the missing data. If there is a backup file, restore it directly according to the backup file. If there is no backup file, query the storage database information, find out which databases the fund data is also stored in according to the storage database information, and then extract the fund data from other databases for restoration. Through the technical solution of the present invention, when backing up, it is not necessary to back up all the data, thereby reducing the space occupied by the backup file and increasing the amount of backup data.
以上的仅是本发明的实施例,方案中公知的具体结构及特性等常识在此未作过多描述,所属领域普通技术人员知晓申请日或者优先权日之前发明所属技术领域所有的普通技术知识,能够获知该领域中所有的现有技术,并且具有应用该日期之前常规实验手段的能力,所属领域普通技术人员可以在本申请给出的启示下,结合自身能力完善并实施本方案,一些典型的公知结构或者公知方法不应当成为所属领域普通技术人员实施本申请的障碍。应当指出,对于本领域的技术人员来说,在不脱离本发明结构的前提下,还可以作出若干变形和改进,这些也应该视为本发明的保护范围,这些都不会影响本发明实施的效果和专利的实用性。本申请要求的保护范围应当以其权利要求的内容为准,说明书中的具体实施方式等记载可以用于解释权利要求的内容。The above are only embodiments of the present invention. Common knowledge such as the known specific structures and characteristics in the scheme is not described in detail here. Ordinary technicians in the relevant field are aware of all the common technical knowledge in the technical field to which the invention belongs before the application date or priority date, can obtain all the existing technologies in the field, and have the ability to apply conventional experimental means before that date. Ordinary technicians in the relevant field can improve and implement this scheme in combination with their own abilities under the enlightenment given by this application. Some typical known structures or known methods should not become obstacles for ordinary technicians in the relevant field to implement this application. It should be pointed out that for those skilled in the art, without departing from the structure of the present invention, several deformations and improvements can be made, which should also be regarded as the scope of protection of the present invention, which will not affect the effect of the implementation of the present invention and the practicality of the patent. The scope of protection required by this application shall be based on the content of its claims, and the specific implementation methods and other records in the specification can be used to interpret the content of the claims.
Claims (6)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202410700506.7A CN118628227A (en) | 2024-05-31 | 2024-05-31 | Logistics supply chain financial risk control method based on real-time data analysis |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202410700506.7A CN118628227A (en) | 2024-05-31 | 2024-05-31 | Logistics supply chain financial risk control method based on real-time data analysis |
Publications (1)
Publication Number | Publication Date |
---|---|
CN118628227A true CN118628227A (en) | 2024-09-10 |
Family
ID=92607606
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202410700506.7A Pending CN118628227A (en) | 2024-05-31 | 2024-05-31 | Logistics supply chain financial risk control method based on real-time data analysis |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN118628227A (en) |
-
2024
- 2024-05-31 CN CN202410700506.7A patent/CN118628227A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Berry‐Stölzle et al. | Enterprise risk management and the cost of capital | |
KR101182703B1 (en) | A central finance information system used at an integrated finance information system | |
JP2004528657A5 (en) | ||
CN112241916A (en) | Personal credit risk default early warning method, device, equipment and storage medium | |
Gallucci et al. | Financial ratios, corporate governance and bank-firm information: A Bayesian approach to predict SMEs’ default | |
Snow et al. | Developing a government reporting taxonomy | |
US20030208422A1 (en) | Computer system and method for selectively monetizing and trading the results of risk factor populations found in financial exposures | |
US7454383B2 (en) | Methods and systems for assessing loan portfolios | |
CN119494722A (en) | A loan overdue monitoring and early warning system based on data analysis | |
CN113449010A (en) | Investment institution income information mining method and device, electronic equipment and storage medium | |
CN111626843A (en) | Vintage analysis method based on risk management data | |
US20140081890A1 (en) | Wealth information management system | |
KR20110088986A (en) | Bad debt management system and method | |
US20030126052A1 (en) | Method and apparatus for establishing real estate investments | |
KR20170037299A (en) | System and Method for Real time based Credit Risk Analysis using the Integrated Account Information | |
CN118822738A (en) | Treasury management system based on smart green finance digital platform | |
CN118628227A (en) | Logistics supply chain financial risk control method based on real-time data analysis | |
Fery | IMPAIRMENT IN VALUE OF PSAK 7 FINANCIAL ACCOUNTING STANDARDS, CLASSIFICATION OF ACCOUNTING MEASUREMENTS IN HEDGING COMPANIESIN THE BANKING SECTOR DUE TO CORONA VIRUS | |
JP3351736B2 (en) | Sales management system | |
Hašková et al. | Determining the price of the business share of a business in a group. | |
Dollery et al. | Municipal budgeting and accounting | |
JP2011040016A (en) | Financial management method and system | |
Bradbury | Issues in the drive to measure liabilities at fair value | |
KR20170004934A (en) | System and Method for Real time based Credit Risk Analysis using the Integrated Account Information | |
CN112967129A (en) | Financial data measuring and calculating method and device, computer equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |