Method and system for processing rebate settlement

Abstract

The invention discloses a method for processing rebate settlement, and the method comprises the following steps: 100, obtaining the configuration parameter information of rebate settlement, setting or defining a plurality of corresponding functional components according to the configuration parameter information, and forming a rebate settlement model; step 200, accessing a database, extracting marketing business data associated with the configuration parameter information and transmitting the marketing business data to a rebate settlement model; and step 300, the rebate settlement model carries out calculation processing on the marketing business data, outputs rebate settlement data, and carries out rebate settlement through a financial settlement process. According to the invention, the appeal of a vehicle enterprise on the online marketing rebate settlement process is solved, meanwhile, a rebate policy configuration function oriented to a business party is provided, the problem of independent development of each rebate policy is eliminated, the settlement process is completed more quickly and efficiently, meanwhile, a settlement board is provided, the rebate policy cost is more intuitively reflected, and the rebate settlement efficiency is improved. And an automobile enterprise is assisted to optimize a rebate policy.

Description

Technical Field

[0001] This invention relates to the technical field of marketing rebate management, and more particularly to a method and system for processing rebate settlements. Background Technology

[0002] In the automotive industry, OEMs formulate rebate policies to incentivize and guide dealers to achieve various business targets. These rebate policies cover aspects such as vehicle sales, parts ordering, marketing activities, and routine performance evaluations, and are currently a crucial component of dealer revenue and an effective means for OEMs to manage dealers. From the OEM's perspective, it's essential to be able to quickly and accurately calculate rebates based on dealer performance and return them to dealers, while also providing a clear and intuitive display of marketing rebate costs. From the dealer's perspective, tools are needed to help calculate the rebate performance achievable in the current period in real time, allowing for timely adjustments to marketing strategies.

[0003] Currently, rebate calculations among car manufacturers take several forms. Some still use manual, offline reporting methods, while others have built separate IT functions for each rebate policy, lacking overall planning and monitoring, and thus failing to fully meet the needs of enterprise digital transformation. Summary of the Invention

[0004] The main objective of this invention is to address the shortcomings of existing technologies, such as long cycles and uncontrolled processes for manual offline data collection, arbitrary adjustments to indicators, inability to verify financial information, inability for distributors to intuitively perceive the current rebates received, and excessively long processes required for each new rebate policy. This invention provides a method and system for processing rebate settlements.

[0005] To achieve the above objectives, the present invention provides a method for processing rebate settlements, comprising the following steps: A method for processing rebate settlements, comprising the following steps:

[0006] Step 100: Obtain the configuration parameter information for rebate settlement, and set or define the corresponding multiple functional components according to the configuration parameter information to form a rebate settlement model;

[0007] Step 200: Access the database, extract marketing business data associated with the configuration parameter information, and transfer it to the rebate settlement model;

[0008] Step 300: The rebate settlement model calculates and processes the marketing business data, outputs rebate settlement data, and performs rebate settlement through the financial settlement process.

[0009] Preferably, the configuration parameter information in step 100 includes settlement cycle time node data, rebate sharing method, settlement statistics dimension, settlement subject scope, rebate eligibility conditions, rebate data calculation formula, and indicator information for participating in rebate settlement.

[0010] Preferably, the first method for obtaining marketing business data from the database in step 200 is as follows: obtain the data source address information of the original business data and the definition information of the database data model, configure and define the database, extract the original business data from the data source by periodically querying the data source, classify and integrate the original business data according to the data items defined by the data model, process it into marketing business data, and write it into the database;

[0011] The second method for obtaining marketing business data from the database in step 200 is as follows: obtain the API interface request address information of the original business data and the definition information of the database data model, configure and define the database, and the database extracts the original business data by periodically requesting the API interface, classifies and integrates the original business data according to the data items defined in the data model, processes it into marketing business data, and writes it into the database.

[0012] The third method for obtaining marketing business data from the database in step 200 is as follows: obtain the definition information of the database's data model, define the database, import the categorized and integrated external business data into the database using the EXCEL template data import method, and write the external business data into the database.

[0013] Preferably, step 200 includes: accessing the database, retrieving marketing business data from the database based on periodic time node data and settlement subject scope, extracting marketing business data within the periodic time node scope and settlement subject scope, and transmitting it to the rebate settlement model.

[0014] Preferably, step 300 includes: the rebate settlement model extracts indicator data from marketing business data based on indicator information participating in rebate settlement, determines whether rebate calculation is required based on the rebate conditions, if not, the rebate settlement data output is 0, if so, the rebate data calculation formula is retrieved, the indicator data is input into the rebate data calculation formula for rebate settlement data calculation, and the rebate settlement data of the corresponding dimension is output to the financial settlement component according to the statistical settlement dimension, and the financial settlement component performs settlement.

[0015] Preferably, the method further includes step 400: performing rebate settlement data allocation calculation processing according to the rebate allocation method, and transmitting the rebate settlement data after allocation processing to the viewing and display area.

[0016] Furthermore, to achieve the above objectives, the present invention also provides a system for processing rebate settlements, comprising: an acquisition module for acquiring configuration parameter information for rebate settlements; a setting module for setting or defining multiple corresponding functional components according to the configuration parameter information to form a rebate settlement model; an extraction module for extracting marketing business data associated with the configuration parameter information from a database; a processing module for performing calculations on the marketing business data; and a transmission module for transmitting the marketing business data associated with the configuration parameter information to the rebate settlement model and transmitting the rebate settlement data to the financial settlement process. Preferably, the configuration parameter information for rebate settlements acquired by the acquisition module includes settlement cycle time node data, rebate allocation method, settlement statistical dimension, settlement subject scope, rebate eligibility conditions, rebate data calculation formula, and indicator information for participating in rebate settlements.

[0017] Preferably, it also includes a retrieval module for retrieving marketing business data in the database based on periodic time node data and settlement subject scope; the extraction module is used to extract marketing business data in the database within the periodic time node scope and settlement subject scope.

[0018] Preferably, the processing module is further configured to perform rebate settlement data allocation calculation processing according to the rebate allocation method; the transmission module is further configured to transmit the rebate settlement data after allocation processing to the viewing and display area.

[0019] The method for processing rebate settlement provided by this invention has the following beneficial effects:

[0020] By acquiring configuration parameters for rebate settlement and setting them on components, multiple components are integrated through execution logic to form a settlement model. This provides online rebate settlement tools and methods to meet various needs, satisfying the systematic transformation of each rebate policy. By defining data models, collecting raw data online through multiple methods, and processing the raw data, suitable marketing business data for rebate settlement is provided, enabling rebate settlement to more comprehensively meet rebate settlement needs. By interacting with rebate settlement data with the financial settlement process and viewing display area, the accuracy and timeliness of financial settlement are achieved, and a more convenient and intuitive understanding of the current rebates is realized. Attached Figure Description

[0021] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on the provided drawings without creative effort:

[0022] Figure 1 The diagram shown is a flowchart illustrating a method for processing rebate settlement according to an embodiment of the present invention.

[0023] Figure 2 The diagram shown is a schematic diagram of the system module structure of a system for processing rebate settlement according to an embodiment of the present invention. Detailed Implementation

[0024] To facilitate understanding of the present invention, a more complete description will be given below with reference to the accompanying drawings. Typical embodiments of the invention are shown in the drawings. However, the invention can be implemented in many different forms and is not limited to the embodiments described herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete.

[0025] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention.

[0026] The general idea of ​​this invention is as follows: Addressing the shortcomings of existing technologies, such as long and uncontrolled manual offline data collection, arbitrary indicator adjustments, lack of financial verification, inability for distributors to intuitively perceive current rebates, and lengthy processes required for each new rebate policy, this invention obtains rebate settlement configuration parameters and sets them on components. Multiple components are then integrated through execution logic to form a settlement model, providing online rebate settlement tools and methods to meet various needs and satisfying the systematic transformation of each rebate policy. By defining a data model, collecting raw data online through multiple methods, and processing the raw data, suitable marketing business data for rebate settlement is provided, enabling rebate settlement to comprehensively meet rebate settlement requirements. By interacting with the financial settlement process and viewing display area, the accuracy and timeliness of financial settlement are achieved, and a more convenient and intuitive understanding of the current rebates is realized.

[0027] To better understand the above technical solutions, the following will describe the above technical solutions in detail with reference to the accompanying drawings and specific embodiments. It should be understood that the embodiments of the present invention and the specific features in the embodiments are detailed descriptions of the technical solutions of this application, rather than limitations on the technical solutions of this application. In the absence of conflict, the embodiments of the present invention and the technical features in the embodiments can be combined with each other.

[0028] Reference Figure 1 , Figure 1The diagram shown is a flowchart illustrating a method for processing rebate settlement according to an embodiment of the present invention. In this embodiment, a method for processing rebate settlement includes:

[0029] Step 100: Obtain the configuration parameter information for rebate settlement, and set or define the corresponding multiple functional components according to the configuration parameter information to form a rebate settlement model.

[0030] Automakers often reward dealers with rebates. Automakers formulate rebate policies based on actual market conditions. At this point, it is necessary to interpret and break down the rebate policy, convert the relevant matters in the rebate policy into corresponding configuration parameter information, and perform parameter copying, parameter selection, and parameter definition for the corresponding functional components in the rebate settlement system according to the actual needs of rebate settlement. Through the control center of the system, the set functional components are integrated to form a rebate settlement model. The rebate settlement model is used to calculate rebates from marketing business data to obtain rebate data.

[0031] For each rebate policy of an automaker, the configuration parameter information is not exactly the same. For each rebate settlement application with different needs, the configuration parameter settings, selections, and definitions are not exactly the same. Each rebate settlement is based on a new rebate settlement model formed according to the specific configuration parameter information.

[0032] To gain a deeper understanding of the rebate settlement model, the specific configuration parameters include settlement cycle time nodes, rebate allocation method, settlement statistics dimensions, settlement entity scope, rebate eligibility conditions, rebate data calculation formula, and indicators for participating in rebate settlement.

[0033] The key metrics for rebate settlement include: the project entity for rebate settlement (e.g., number of vehicles picked up, number of vehicles delivered, difference between the number of vehicles submitted and the number of vehicles delivered), the settlement period (e.g., July 20, 2023 – August 20, 2023), the settlement period for current needs, providing a basis for obtaining marketing business data, the settlement entity scope (e.g., the dealer's location), which can be categorized by region (e.g., South China, Central China, Guangdong, Shanghai) or dealer level (e.g., first-tier agent, second-tier agent), providing a basis for obtaining marketing business data within that scope, and the rebate eligibility criteria (e.g., the threshold conditions for receiving rebates as stipulated in the rebate policy, such as requiring more than 10 vehicles to receive a rebate, providing a basis for obtaining marketing business data). Whether rebate calculation is required requires providing a basis; the rebate data calculation formula is used to calculate the rebate based on the marketing business data that meets the rebate criteria. For example, rebate data = number of vehicles delivered * rebate amount per vehicle. If the number of vehicles delivered is 20 and the rebate amount per vehicle is 1,000 yuan, then the rebate data = 20 * 1,000, which is 20,000 yuan; the settlement statistics dimension refers to the selected settlement item, such as whether the settlement dimension is based on vehicle model or dealer. One is based on the item, and the other is based on the block; the rebate allocation method can be divided into three types: no allocation, average allocation, and proportional allocation. For rebates calculated based on vehicles, no additional allocation is required, and the rebate amount is directly calculated for each vehicle. Average allocation means that the rebate amount within the dealer's settlement period is evenly allocated to each vehicle within the settlement period. Proportional allocation means that the rebate amount within the dealer's settlement period is allocated to each vehicle within the settlement period according to the vehicle model ratio.

[0034] Step 200: Access the database, extract the marketing business data associated with the configuration parameter information, and transfer it to the rebate settlement model.

[0035] Rebate settlement requires inputting marketing business data into the rebate settlement model for calculation and settlement. Typically, the system reads the configuration parameter information in the rebate settlement model, accesses the system's database with the set and defined configuration parameter information, extracts the marketing business data associated with the configuration parameter information, inputs it into the rebate settlement model for calculation, and obtains the rebate data.

[0036] To ensure the standardization of marketing business data input into the rebate settlement model, the data in the database consists of standard data items. The data model in the database needs to define metadata. For example, if the data model name is "Vehicle Performance," it includes data items such as Dealer ID, Dealer Name, Dealer Region, Dealer Agency Level, Number of Vehicles Taken, Number of Vehicles Delivered, Taken Date, and Delivered Date. Corresponding physical tables should be created. The definition of the data model is related to the configuration parameters of the rebate settlement model. Data items associated with the configuration parameters must be defined in the data model; for example, settlement cycle time node data must include a data item for the taken date.

[0037] Because the original business data is not standardized and is stored in other locations, the database needs to employ certain methods to acquire the original business data and form standardized marketing business data. In this invention, the database uses the following three methods for acquisition.

[0038] The first method is to obtain the data source address information of the original business data and the definition information of the database data model, configure and define the database, and then periodically query the data source to extract the original business data from the data source. The original business data is then classified and integrated according to the data items defined in the data model, processed into marketing business data, and written into the database.

[0039] First, by obtaining the definition information of the database data model, corresponding physical tables are created in the database. As explained above, after the database is defined, data source information and query statements are configured. Data interacts with the data source through the data source address. The query statement retrieves the original business data from the data source. Since the original business data in the data source does not correspond to the data items in the database data model, the original data needs to be categorized and integrated, processed according to the database's data item standards, and finally formed into marketing business data consistent with the data items in the data model, which is then incorporated into the database for storage. The second method involves obtaining the API interface request address information for the original business data and the definition information of the database data model. The database is then configured and defined. The database periodically requests and connects to the API interface to extract the original business data, categorizes and integrates the original business data according to the data items defined in the data model, processes it into marketing business data, and writes it into the database.

[0040] First, by obtaining the definition information of the database data model, corresponding physical tables are created in the database. As explained above, after the database is defined, the API interface request address information is obtained, and the request statements are configured. Data is obtained through the API interface request address. Through the request statements, the original business data is extracted. Since the original business data does not correspond to the data items in the database data model, the original data needs to be classified and integrated. It is processed according to the database data item standards, and finally, marketing business data consistent with the data items in the data model is formed and incorporated into the database for storage.

[0041] The third method is to obtain the definition information of the database's data model, define the database, import the categorized and integrated external business data into the database using the EXCEL template data import method, and write the external business data into the database.

[0042] Offline business personnel organize and fill in the original business data into the corresponding Excel files according to the Excel data template. The business data in the Excel files is then written into the database through the system's data import function. Since the Excel data template and the physical tables in the database are consistent, the data can be directly imported without further classification, integration, or processing.

[0043] Specifically, to extract marketing business data, the database is accessed, and marketing business data within the periodic time node data and settlement subject scope is retrieved from the database. Marketing business data within the periodic time node scope and settlement subject scope is extracted and transmitted to the rebate settlement model.

[0044] Before accessing the database, the configuration parameter information is read first. The periodic time node data and settlement entity range in the configuration parameter information are extracted. For example, if the periodic time node data is 2023 / 7 / 20-2023 / 8 / 20 and the settlement entity range is Guangdong Province, the marketing business data in the data model is retrieved, selecting data with vehicle pickup times between 2023 / 7 / 20 and 2023 / 8 / 20. The dealer's region in the data model is also retrieved, selecting data from Guangdong Province. Data that simultaneously meets these criteria is extracted and transmitted to the rebate settlement model. This ensures that the data transmitted to the rebate settlement model is standardized and valid, avoiding calculation errors or operational malfunctions in the rebate settlement model. Step 300: The rebate settlement model calculates and processes the marketing business data, outputs rebate settlement data, and performs rebate settlement through the financial settlement process.

[0045] The rebate settlement model receives marketing business data, performs calculations on the marketing business data, and after the calculation is completed, outputs rebate settlement data to the financial settlement process in the system for final settlement.

[0046] Specifically, the rebate settlement model extracts indicator data from marketing business data based on the indicator information involved in the rebate settlement. It then determines whether rebate calculation is required based on the rebate conditions. If not, the rebate settlement data output is 0. If so, the rebate calculation formula is retrieved, the indicator data is input into the formula, and the rebate settlement data is calculated. Based on the statistical settlement dimensions, the corresponding rebate settlement data is output to the financial settlement component, which then performs the settlement.

[0047] Marketing business data that meets the settlement cycle node data and settlement entity scope is extracted from the database and transmitted to the rebate settlement model. For example, marketing business data with vehicle delivery time between July 20, 2023 and August 20, 2023, and where the dealership is located in Guangdong Province, is extracted. From this data, the indicator information for participating in rebate settlement is extracted. If the indicator information for participating in rebate settlement is the number of vehicles delivered, then the number of vehicles delivered by the same dealership in this cycle is counted to obtain the total number of vehicles delivered. For example, if the number of vehicles delivered is 200, the indicator information for participating in rebate settlement is judged according to the rebate conditions information in the configuration parameter information to determine whether rebate calculation is required. The condition for rebates is that the number of vehicles delivered must be greater than 100. If 200 is greater than 100, then the rebate condition is met, and this data needs to be calculated. If the number of vehicles delivered is 50, which is less than 100, then the rebate condition is not met, and the rebate calculation proceeds to the next dealer. When rebate calculation is needed, the rebate calculation formula in the configuration parameters is retrieved. The indicator data is input into the rebate calculation formula for calculation. For example, the rebate calculation formula is: Rebate Data = Indicator Data * Rebate Amount. If the indicator data is 200 vehicles delivered, and the rebate amount per vehicle is 1000 yuan, the calculated rebate data is 200,000 yuan. Then, based on the statistical settlement dimension in the configuration parameters, the corresponding rebate calculation data is output. If the statistical settlement dimension is dealer, the output is "XXX dealer rebate 200,000 yuan"; if the statistical settlement dimension is vehicle model, the output is "XXX dealer XXX vehicle model rebate 200,000 yuan". After outputting the rebate calculation data, the rebate calculation data is transmitted to the system's financial settlement process for financial settlement, thus completing the rebate settlement for the distributor.

[0048] To make it easier for dealers to see their current rebate performance in a timely manner, the method of the present invention further includes step 400: performing rebate settlement data allocation calculation processing according to the rebate allocation method, and transmitting the allocated rebate settlement data to the viewing and display area.

[0049] After the rebate calculation data is generated, it is output to the financial settlement process for financial settlement, and it can also be output to the dealer's viewing and display area so that dealers can view it in a timely manner. In order to enable dealers to have a more comprehensive understanding of the rebate performance of various models, dealers can set the allocation method in the configuration parameter information according to their needs. The rebate settlement model recalculates the rebate calculation data according to the allocation method and outputs the rebate data corresponding to the rebate allocation method. For example, if the allocation method is proportional allocation, the rebate calculation output is allocated to each car based on the proportion of the car model price, thereby reflecting the rebate data of each car.

[0050] Based on the above methods, this invention obtains the configuration parameter information for rebate settlement and sets it on the components. Multiple components are then integrated through execution logic to form a settlement model, thus providing online rebate settlement tools and methods to meet various needs and satisfying the systematic transformation of each rebate policy. By defining a data model, collecting raw data online through multiple methods, and processing the raw data, it provides marketing business data suitable for rebate settlement, enabling it to more comprehensively meet rebate settlement needs. By interacting with the rebate settlement data with the financial settlement process and viewing display area, it achieves the accuracy and timeliness of financial settlement, and provides a more convenient and intuitive understanding of the currently obtained rebates.

[0051] Accordingly, the present invention also provides a system for processing rebate settlements, referring to... Figure 2 , Figure 2 The diagram shows a system module structure for processing rebate settlement according to an embodiment of the present invention. This system calculates and manages rebate settlement requirements using the method described above to achieve rebate settlement. The system includes: an acquisition module for acquiring configuration parameter information for rebate settlement; a setting module for setting or defining multiple corresponding functional components based on the configuration parameter information to form a rebate settlement model; an extraction module for extracting marketing business data associated with the configuration parameter information from the database; a processing module for performing calculations on the marketing business data; and a transmission module for transmitting the marketing business data associated with the configuration parameter information to the rebate settlement model and transmitting the rebate settlement data to the financial settlement process.

[0052] Preferably, the configuration parameter information for rebate settlement acquired by the acquisition module includes settlement cycle time node data, rebate allocation method, settlement statistics dimension, settlement subject scope, rebate eligibility conditions, rebate data calculation formula, and indicator information for participating in rebate settlement.

[0053] Preferably, it also includes a retrieval module for retrieving marketing business data in the database based on periodic time node data and settlement subject scope; the extraction module is used to extract marketing business data in the database within the periodic time node scope and settlement subject scope.

[0054] Preferably, the processing module is further configured to perform rebate settlement data allocation calculation processing according to the rebate allocation method; the transmission module is further configured to transmit the rebate settlement data after allocation processing to the viewing and display area.

[0055] Numerous specific details are set forth in the specification provided herein. However, it will be understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures, and techniques have not been shown in detail so as not to obscure the understanding of this specification.

[0056] Similarly, it should be understood that, in order to simplify this disclosure and aid in understanding one or more of the various aspects of the invention, in the above description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof. However, this method of disclosure should not be construed as reflecting an intention that the claimed invention requires more features than are expressly recited in each claim. Rather, as reflected in the following claims, inventive aspects lie in fewer than all features of a single foregoing disclosed embodiment. Therefore, the claims following the detailed description are hereby expressly incorporated into this detailed description, wherein each claim itself is a separate embodiment of the invention.

[0057] Those skilled in the art will understand that modules in the device of the embodiments can be adaptively changed and placed in one or more devices different from that embodiment. Modules, units, or components in the embodiments can be combined into a single module, unit, or component, and further, they can be divided into multiple sub-modules, sub-units, or sub-components. Except where at least some of such features and / or processes or units are mutually exclusive, any combination can be used to combine all features disclosed in this specification (including the accompanying claims, abstract, and drawings) and all processes or units of any method or device so disclosed. Unless expressly stated otherwise, each feature disclosed in this specification (including the accompanying claims, abstract, and drawings) may be replaced by an alternative feature that serves the same, equivalent, or similar purpose.

[0058] Furthermore, those skilled in the art will understand that although some embodiments herein include certain features included in other embodiments but not others, combinations of features from different embodiments are intended to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments can be used in any combination.

[0059] The various component embodiments of the present invention can be implemented in hardware, or as software modules running on one or more processors, or a combination thereof. Those skilled in the art will understand that microprocessors or digital signal processors (DSPs) can be used in practice to implement some or all of the functions of some or all of the components according to the embodiments of the present invention. The present invention can also be implemented as a device or apparatus program (e.g., a computer program and computer program product) for performing part or all of the methods described herein. Such programs implementing the present invention can be stored on a computer-readable medium, or can be in the form of one or more signals. Such signals can be downloaded from an Internet website, provided on a carrier signal, or provided in any other form.

[0060] It should be noted that the above embodiments are illustrative of the invention and not restrictive, and that those skilled in the art can devise alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses should not be construed as limiting the claims. The word "comprising" does not exclude the presence of elements or steps not listed in the claims. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention can be implemented by means of hardware comprising several different elements and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by the same item of hardware. The use of the words first, second, and third, etc., does not indicate any order. These words can be interpreted as names.

Claims

1. A method for processing rebate settlement, characterized in that: The following steps are involved: Step 100: Obtain configuration parameter information of rebate settlement, and set or define corresponding multiple functional components according to the configuration parameter information to form a rebate settlement model; Step 200: Access the database, extract the marketing business data associated with the configuration parameter information and transmit it to the rebate settlement model; Step 300: The rebate settlement model calculates and processes the marketing business data, outputs the rebate settlement data, and performs rebate settlement through the financial settlement process.

2. The method for processing rebate settlement according to claim 1, characterized in that: The configuration parameter information in step 100 includes settlement cycle time node data, rebate allocation method, settlement statistical dimension, settlement subject range, rebate-eligible condition information, rebate data calculation formula, and indicator information participating in rebate settlement.

3. The method for processing rebate settlement according to claim 2, characterized in that: The first method for the database to obtain marketing business data in step 200 is: obtaining the data source address information of the original business data and the definition information of the data model of the database, configuring and defining the database, the database extracts the original business data from the data source by periodically querying the data source, and classifies and integrates the original business data according to the data items defined in the data model, processes it into marketing business data, and writes it into the database; The second method for the database to obtain marketing business data in step 200 is: obtain API interface request address information of the original business data and definition information of the data model of the database, configure and define the database, the database extracts the original business data by connecting to the API interface through regular requests, and classifies and integrates the original business data according to the data items defined in the data model, processes it into marketing business data, and writes it into the database; The third method for the database in step 200 to obtain marketing business data is: obtaining the definition information of the data model of the database, defining the database, importing the classified and integrated external business data through the EXCEL template data import method, and writing the external business data into the database.

4. The method for processing rebate settlement according to claim 3, characterized in that: The step 200 comprises: Access the database, retrieve the marketing business data in the database according to the cycle time node data and the settlement subject scope, extract the marketing business data within the cycle time node scope and the settlement subject scope, and transmit it to the rebate settlement model.

5. The method for processing rebate settlement according to claim 4, characterized in that: The step 300 includes: The rebate settlement model extracts indicator data from the marketing business data based on the indicator information involved in the rebate settlement, and determines whether rebate calculation is required based on the conditional information that meets the rebate requirements. If not, the rebate settlement data output is 0. If required, the rebate data calculation formula is retrieved, and the indicator data is input into the rebate data calculation formula to calculate the rebate settlement data. The rebate settlement data of the corresponding dimension is output according to the statistical settlement dimension to the financial settlement component, and the financial settlement component performs settlement.

6. The method for processing rebate settlement according to claim 5, characterized in that: The step 400 is also included: performing calculation and processing on the rebate settlement data according to the rebate allocation method, and transmitting the rebate settlement data after the allocation processing to the viewing and display area.

7. A system for processing rebate settlement, characterized in that: include: The acquisition module is used to obtain the configuration parameter information of the rebate settlement; A setting module, used to set or define corresponding multiple functional components according to the configuration parameter information to form a rebate settlement model; An extraction module, used to extract marketing business data associated with configuration parameter information in a database; A processing module is used to perform calculations on marketing business data; The transmission module is used to transmit the marketing business data associated with the configuration parameter information to the rebate settlement model, and is used to transmit the rebate settlement data to the financial settlement process.

8. The system for processing rebate settlement according to claim 7, characterized in that: The configuration parameter information of the rebate settlement acquired by the acquisition module includes settlement cycle time node data, rebate allocation method, settlement statistical dimension, settlement subject range, rebate-eligible condition information, rebate data calculation formula, and indicator information participating in rebate settlement.

9. The system for processing rebate settlement according to claim 8, characterized in that: It also includes a retrieval module for retrieving the marketing business data in the database according to the cycle time node data and the settlement subject range; the extraction module is used to extract the marketing business data in the database within the cycle time node range and the settlement subject range.

10. The system for processing rebate settlement according to claim 9, characterized in that: The processing module is also used to perform apportionment calculation processing on the rebate settlement data according to the rebate apportionment method; the transmission module is also used to transmit the rebate settlement data after the apportionment processing to the viewing and display area.

Images