Implementing a one-to-many batch reconciliation method for entry files in the marketing system

Abstract

The present invention provides a method for implementing one-to-many batch reconciliation of account entry files in a marketing system, and relates to the technical field of batch file reconciliation. The method for implementing one-to-many batch reconciliation of account entry files in a marketing system includes the following steps: registering a reconciliation file record table A; reading unprocessed records in the reconciliation result table B on day T-N, obtaining transaction records from the reconciliation record table A based on the transaction serial number, and performing reconciliation; reading records from the reconciliation file record table A, obtaining transaction records from the marketing system flow information table D based on the transaction serial number, and performing reconciliation; reading records from the marketing system flow information table D on day T-N+1, obtaining records from the reconciliation file history table C based on the transaction serial number, and performing reconciliation; and reading records from the reconciliation result table B on day T to generate a reconciliation result file. By providing a reconciliation file based on day T of the Tonglian payment system and reconciling it with the account entry data from days T-N and T-N+1 of the credit card marketing system, data loss in the reconciliation result is avoided.

Description

Technical Field

[0001] The present invention relates to the technical field of batch reconciliation of files, and in particular to a method for implementing batch reconciliation of one-to-many account entry files in a marketing system. Background Art

[0002] Due to the different cut-off times and accounting methods between the credit card marketing system and the Tonglian payment system, the same transaction is recorded on different dates in the credit card marketing system and the Tonglian payment system. Consequently, the same transaction is recorded on different dates in different systems, making it more difficult to reconcile the accounting records. This method uses the Tonglian payment system's T-day reconciliation file as the primary method and reconciles it with the credit card marketing system's TN and T-N+1 day accounting data, thus avoiding data loss in the reconciliation results. Summary of the Invention

[0003] (1) Technical problems solved

[0004] In view of the shortcomings of the existing technology, the present invention provides a method for realizing one-to-many batch reconciliation of account entry files in a marketing system, which solves the problem of data loss in the reconciliation results.

[0005] (2) Technical solution

[0006] To achieve the above objectives, the present invention is implemented through the following technical solutions: a method for batch reconciliation of one-to-many account entry files in a marketing system, comprising the following steps:

[0007] Step 1:

[0008] Download the T-day reconciliation file from the Tonglian Payment System and register it in Reconciliation File Record Sheet A;

[0009] Step 2:

[0010] Read the unprocessed records in the Reconciliation Result Table B for the TN purpose, obtain the transaction records in the Reconciliation Record Table A based on the transaction serial number, perform reconciliation, and update the Reconciliation Result Table B and the Reconciliation File History Table C with the status as processed and the processing date as day T.

[0011] Step 3:

[0012] Read the records in Reconciliation File Record Table A, obtain the transaction records in Marketing System Transaction Information Table D based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in Reconciliation Result Table B and Reconciliation File History Table C. The status is processed and the processing date is T.

[0013] Step 4:

[0014] Read the D record from the marketing system's transaction information table for day T-N+1, obtain the C record from the reconciliation file history table based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in the reconciliation result table B with the status as processed and the processing date as day T.

[0015] Step 5:

[0016] Read the B record of the reconciliation result table on day T and generate the reconciliation result file.

[0017] Preferably, the parameter N is the number of days for reconciliation and comparison.

[0018] Preferably, in step 2, after the processing is completed, the corresponding account reconciliation file table A record is cleared.

[0019] Preferably, in step three, after the processing is completed, the corresponding account reconciliation file table A record is cleared.

[0020] Preferably, in step five, after the reconciliation result file is generated, the reconciliation result file is pushed to the bank.

[0021] (3) Beneficial effects

[0022] The present invention provides a method for achieving one-to-many batch reconciliation of account entry files in a marketing system. It has the following beneficial effects:

[0023] 1. This method mainly uses the T-day reconciliation file of the Tonglian Payment System and the TN and T-N+1-day account data of the credit card marketing system to reconcile, avoiding data loss in the reconciliation results.

[0024] 2. Data accuracy can be improved through multiple and repeated reconciliation processes. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 It is a schematic diagram of the process of the present invention. DETAILED DESCRIPTION

[0026] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0027] Example 1:

[0028] like Figure 1 As shown, an embodiment of the present invention provides a method for implementing one-to-many batch reconciliation of account entry files in a marketing system, comprising the following steps:

[0029] Step 1:

[0030] Download the T-day reconciliation file from the Tonglian Payment System and register it in Reconciliation File Record Sheet A;

[0031] Step 2:

[0032] Read the unprocessed records in Reconciliation Result Table B on day TN, obtain the transaction records in Reconciliation Record Table A based on the transaction serial number, perform reconciliation, and update Reconciliation Result Table B and Reconciliation File History Table C after processing is complete. The status is processed and the processing date is day T.

[0033] Step 3:

[0034] Read the records in Reconciliation File Record Table A, obtain the transaction records in Marketing System Transaction Information Table D based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in Reconciliation Result Table B and Reconciliation File History Table C. The status is processed and the processing date is T.

[0035] Step 4:

[0036] Read the D record from the marketing system's transaction information table for day T-N+1, obtain the C record from the reconciliation file history table based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in the reconciliation result table B with the status as processed and the processing date as day T.

[0037] Step 5:

[0038] Read the B record of the reconciliation result table on day T and generate the reconciliation result file.

[0039] Example 2:

[0040] like Figure 1 As shown, an embodiment of the present invention provides a method for implementing one-to-many batch reconciliation of account entry files in a marketing system, comprising the following steps:

[0041] Step 1:

[0042] Download the T-day reconciliation file from the Tonglian Payment System, register it in the reconciliation file record table A, and obtain the "reconciliation comparison day parameter N" from the database;

[0043] Step 2:

[0044] Read the unprocessed records in Reconciliation Result Table B on day TN, obtain the transaction records in Reconciliation Record Table A based on the transaction serial number, perform reconciliation, and update Reconciliation Result Table B and Reconciliation File History Table C with the status as processed and the processing date as day T. Clear the corresponding records in Reconciliation File Table A.

[0045] Step 3:

[0046] Read the record in Reconciliation File Record Table A, obtain the transaction record in Marketing System Transaction Information Table D based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in Reconciliation Result Table B and Reconciliation File History Table C. The status is processed and the processing date is T day. The corresponding record in Reconciliation File Table A is cleared.

[0047] Step 4:

[0048] Read the D record from the marketing system's transaction information table for day T-N+1, obtain the C record from the reconciliation file history table based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in the reconciliation result table B with the status as processed and the processing date as day T.

[0049] Step 5:

[0050] Read the B record of the reconciliation result table on day T, generate the reconciliation result file, and push the reconciliation result file to the bank.

[0051] In this method for implementing one-to-many batch reconciliation of account entries in the marketing system, the T-day reconciliation file of the Tonglian payment system is provided as the main one, and it is reconciled with the TN and T-N+1 day account entry data of the credit card marketing system, thereby avoiding data loss in the reconciliation results.

[0052] While embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions, and variations may be made to these embodiments without departing from the principles and spirit of the invention, and that the scope of the invention is defined by the appended claims and their equivalents.

Claims

1. Implement a one-to-many batch reconciliation method for account entry files in the marketing system, characterized by: The following steps are involved: Step 1: Registration Record Form A Download the T-day reconciliation file from the Tonglian Payment System and register it in Reconciliation File Record Sheet A; Step 2: Update reconciliation data Read the unprocessed records in Reconciliation Result Table B on day TN, obtain the transaction records in Reconciliation Record Table A based on the transaction serial number, perform reconciliation, and update Reconciliation Result Table B and Reconciliation File History Table C after processing is complete. The status is processed and the processing date is day T. Step 3: Preliminary registration of reconciliation data Read the records in Reconciliation File Record Table A, obtain the transaction records in Marketing System Transaction Information Table D based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in Reconciliation Result Table B and Reconciliation File History Table C. The status is processed and the processing date is T. Step 4: Register reconciliation data again Read the D record from the marketing system's transaction information table for day T-N+1, obtain the C record from the reconciliation file history table based on the transaction serial number, perform reconciliation, register the completed transaction, and record it in the reconciliation result table B with the status as processed and the processing date as day T. Step 5: Output the reconciliation result file Read the B record of the reconciliation result table on day T, generate the reconciliation result file, and push the reconciliation result file to the bank after generating the reconciliation result file.

2. The method for realizing one-to-many batch reconciliation of account entry files in a marketing system according to claim 1, characterized in that: The parameter N is the number of days for reconciliation and comparison.

3. The method for realizing one-to-many batch reconciliation of account entry files in a marketing system according to claim 1, characterized in that: In step 2, after the processing is completed, the corresponding account reconciliation file table A record is cleared.

4. The method for realizing one-to-many batch reconciliation of account entry files in a marketing system according to claim 1, characterized in that: In step 3, after the processing is completed, the corresponding account reconciliation file table A record is cleared.

Images