The platform and upstream reconciliation logic _ reconciliation

Source: Internet
Author: User
Tags bulk insert

Platform data: Platform Transaction table Trans_info

Upstream data: Upstream reconciliation document

Reconciliation Table:

Check_account_batch//Reconciliation lot Table (reconciliation lot number, receipts agency, total amount (upstream and platform), total number of pens (upstream and platform), total number of successful reconciliations (upstream and platform), total number of reconciliation failures (upstream and platform), reconciliation results (success/failure/ongoing), Reconciliation file date, reconciliation document name, reconciliation date

Check_account_detail//Reconciliation Details table, success (field with Transaction table, Plus: Reconciliation status (Success/Transaction amount error/platform unilateral/upstream unilateral), reconciliation lot number, reconciliation account description)

Check_account_detail_fail/Reconciliation Details table, failure (IBID.)


Reconciliation Logic: 1, the selected reconciliation transaction date, generally for one day, the platform transaction period conditions must be the same as the transaction time period of the reconciliation documents, to ensure that the transaction time is not misplaced;
2, to determine the current batch number reconciliation status, if the account has been successful or in progress, no longer continue, reconciliation failed or not reconciled, then continue;
3, access to the Platform transaction list and reconciliation documents list;
4, if the reconciliation has failed, then delete the reconciliation batch records, delete reconciliation records (including success and failure);
5, Calculation: The total amount of transactions (upstream and platform), the total number of transactions (upstream and platform), the number of successful accounts (upstream and platform), reconciliation failure of the number of pens (upstream and platform);
6, to the upstream of the accounting documents, traversing the platform transaction data, compare the details of each transaction, the transaction details to the platform data, the reconciliation of successful transactions and reconciliation failure of the transaction record
7, insert the Account Details table, reconciliation success details and reconciliation failure details two tables, and indicate the status: Success, platform unilateral, upstream unilateral, the amount of error;

8, insert the reconciliation of the batch table;

9, the transaction data is generally too large, you can set a value such as 1000, bulk Insert table;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.