<- Back to Overview

Basic Concept

A BCP module, or billing, collection, and payment module, is used in the insurance industry to manage the billing and payment processes for insurance policies.

The system now supports querying all kinds of financial records of all status, and exporting basic information in an Excel format at the platform level.

User Scenario

For anyone who wants to use our platform to query financial data.

BCP Statistics

In this section, user will be able to choose the search criteria such as the product and date range to view the overall transaction summary of the following types:

• Total Number of Transaction: to get an overall understanding of how many cases have been created in the past.
• Total XXX Amount: to get an overall understanding of the amount that have been generated in the past.
• Total XXX Balance: to get an overall understanding of the outstanding balances from past transactions.
• Statistics Report: to get Statistics Report according to the required conditions.

If you want to have more specific tailored dashboard, you can click on the link at the bottom of the page, go to query page to search, and export data in excel format.

Statistics Search Condition

1. By default, platform will provide some available search criteria. User can click on the filter icon which in the upper right corner of the Search Condition Card, to add or remove search conditions on the page.
2. If user wants to add or hide some criteria in the filter, user can contact development team to configure them in Arap, Collection & BcpPayment index via Index Management module.
3. User can also click on the ARAP tab, Collection tab and Payment tab in the upper left corner to obtain the data of the respective business type.

Tabs: ARAP, Collection, and Payment, each showing statistics for the respective business type.

The following business transaction category filters are also provided for a personalized statistics view:

• Whether it’s ARAP, Collection or Payment
• Whether its status is outstanding, settled, collected, confirmed or paid

Users can click the filter icon to open a transfer-box configuration panel with 32 available query fields (including Quote No., Reinsurance Policy No., Bill No., Endorsement No., ARAP Status, etc.). The right panel shows the selected query fields. The panel has Push (apply changes) and Pull (reset to defaults) buttons.

The Index Management configuration for ARAP search includes:

• Index schema: bcp_arap
• Read alias: bcp_arap_r_alias, Write alias: bcp_arap_w_alias5
• Rebuild batch task: arapIndexRebuildBatch

Field-level rules control search behavior (the table below shows a partial example; more fields can be configured via Index Management):

Dashboard KPI Cards

Below the search condition card are three core KPI cards. Each KPI card supports switching between Day/Month granularity, switching chart types (column bar, line chart), and viewing detail data.

Status color mapping used across the KPI charts:

Note: The exact color of each status varies by KPI card (see each card below). Switching Day/Month granularity only changes the time-series aggregation; the headline total is always the full-period figure and is not affected by the granularity switch.

Total Number of Transaction

1. User can view the transaction quantity by month or day.
2. User can choose outstanding, settled or canceled to view the transaction quantity.
3. Both column bar and line charts are provided in case different users might have different favorites.
4. User can see the details, and the page displays the date and quantity range, with different colors indicating different status. In the upper right corner, users can also switch between Data View, Column Bar Chart and Line Chart, or Save it as image.

Status colors (transaction count):

• Outstanding (blue): pending transactions
• Settled (dark gray/black): completed transactions
• Canceled (light gray): voided transactions

Detail view: Displays a time-series area/line chart covering the full filter period. The right-side toolbar provides: Data View toggle, Line Chart toggle, Column Bar Chart toggle, and Export button.

Total ARAP Amount

1. User can view the total amount by month or day.
2. User can choose outstanding, settled or canceled to view the total amount.
3. Both column bar and line charts are provided in case different users might have different favorites.
4. User can see the details, and the page displays the date and amount range, with different colors indicating different status. In the upper right corner, users can also switch between Data View, Column Bar Chart and Line Chart, or Save it as image.

Status colors (ARAP amount): Outstanding (light purple, area-filled), Settled (dark gray), Canceled (light gray). The filled line chart highlights the outstanding amount trend over time.

Detail view: Provides a stacked column bar chart by month with the same three status colors. Controls on the right include: Export, Line Chart view, Stacked Column Bar Chart view (default), and Data Download.

Total ARAP Balance

1. User can view the total balance by month or day.
2. User can choose outstanding, settled or canceled to view the total balance.
3. Both column bar and line charts are provided in case different users might have different favorites.
4. User can see the details, and the page displays the date and balance range, with different colors indicating different status. In the upper right corner, users can also switch between Data View, Column Bar Chart and Line Chart, or Save it as image.

Status colors (ARAP balance): Outstanding (purple, dominant), Settled (light gray), Canceled (light gray). In the current period, outstanding balance dominates while settled and canceled balances are negligible.

Detail view: Shows a daily breakdown table with the following columns. The reconciliation logic is: previous-day outstanding balance + today’s new ARAP amount = today’s outstanding balance + today’s settled amount + today’s canceled amount.

Get My Own Statistics Report (Custom Statistics Report)

Below the KPI cards is a custom Statistics Report area. It supports configuring Group Type, Average Field, and Sum Field for custom aggregation. Results are displayed in a table with pagination and export capability.

1. User can choose the criteria for Group Type, Average Field and Sum Field.
2. Group Type is a condition, Average Field and Sum Field is the statistical result calculated based on the condition, which also support export.
3. The fields in Group Type, Average Field and Sum Field are configured in Index. If user wants to add or hide some data, user can contact development team to configure them in Arap, Collection & BcpPayment index via Index Management module. If the added field type is string, it displays in Group Type; if the field type is double or long, it displays in Average Field and Sum Field.

Configuration options:

Result columns:

Supports pagination and export. The total number of statistical results is shown in the pagination control (e.g. 19 rows in 4 pages).

BCP Query UI Operation

For every transaction with an amount, the system will generate a respective AR or AP. Users can check the status and other information of the ARAP.

Users can query each ARAP/Receipt/payment/application record by different search criteria.

Query ARAP

Path: BCP Query / Query ARAP.

1. Prerequisites: ARAP records are generated by business transaction.
2. Users can search ARAP records by multiple search criteria.
3. Users can click + on the left of DN/CN No. to expand and view detailed ARAP information.
4. Users can click Fee to view detailed fee information.
5. Users can click Commission to view detailed commission information.
6. Users can click View Icon on the right to view associated transaction details information.
7. Users can click N (Note) to add comments.
8. Users can export the ARAP to an excel file to view these records.

Search Criteria:

The default search form is laid out in three columns and is fully customizable via the user preference component (see BCP Query UI Configuration).

Result Columns:

Expanded detail fields: Quote No., Reinsurance Policy No., Endorsement No., Currency, Product Name, ARAP Category, Generation Date, Policy Expiry Date, Policyholder Name, Payer/Payee Type, Branch, Agent, etc.

Operation Buttons:

Search (execute search) Reset (clear the search form) Export To Excel (export the ARAP list to an Excel file)

Query Receipt

Path: BCP Query / Query Receipt.

1. Prerequisites: The collection is performed successfully in the system, and the receipt no. is generated by the system.
2. Users can search receipt records by multiple search criteria.
3. Users can click + on the left of Receipt No. to expand and view detailed receipt information.
4. Users can click View Icon on the right to view associated transaction details information.
5. Users can click N (Note) to add comments.
6. Users can export the receipt to an Excel file to view these records.

Search Criteria:

Result Columns:

Operation Buttons:

Search (execute search) Reset (clear the search form) Export To Excel (export the receipt list to an Excel file)

Query Payment

Path: BCP Query / Query Payment.

1. Prerequisites: The payment records must be generated.
2. Users can search payment records by multiple search criteria.
3. Users can click + on the left of Payment No. to expand and view detailed payment information.
4. Users can click View Icon on the right to view associated transaction details information.
5. Users can click N (Note) to add comments.
6. Users can export the payment to an Excel file to view these records.

Search Criteria:

The default search form is laid out in two rows and is fully customizable via the user preference component.

Result Columns:

Expanded detail fields: Quote No., Currency, Endorsement No., Approval Date, etc.

Operation Buttons:

Search (execute search) Reset (clear the search form) Export To Excel (export the payment list to an Excel file)

Query Application Offset

Path: BCP Query / Query Application & Offset.

1. Prerequisites: An application or ARAP offset transaction must be performed by a user in the system.
2. Users can search for offset records by multiple search criteria.
3. Users can click + on the left of Offset No. to expand and view detailed offset information.
4. Users can click View Icon on the right to view associated transaction details information.
5. Users can click N (Note) to add comments.
6. Users can export the offset to an excel file to view these records.

Search Criteria:

Result Columns:

Expanded detail fields: Offset Operator, Payer/Payee Code, Statement No., Insert Time, Reverse Operator, Currency Code, Reverse Time, Receipt No., Branch, Booking Currency Code, Direct Writer, Direct Handler, etc.

Operation Buttons:

Search (execute search) Reset (clear the search form) Export To Excel (export the offset list to an Excel file)

Query GL

Path: BCP Query / Query GL.

1. Prerequisites: GL voucher data must be generated and transmitted to the GL module.
2. Users can search GL records by multiple search criteria.
3. Users can export GL records to an Excel file to view these records.
4. GL is a complex business process that depends on GL rule configuration. For GL rules configuration, see the data table GLIntegrationMappingRule.

Export Column Configuration: The export function supports specifying which columns to export and the column order. This is configured via the Global Parameter path: BCPConfig → bcp.export.gl.columns. The configuration accepts a comma-separated list of column field names, and the export file will include only the specified columns in the defined order. For example:

bcp.export.gl.columns = GLVoucherNo,PolicyNo,GLDate,Amount,GLStatus,Branch

Query Statement

Path: BCP Query / Query Statement.

1. Prerequisites: Statement must be generated in the system.
2. Users can search statement records by multiple search criteria.
3. Users can click ARAP List to view ARAP attached to the statement.

Search Criteria:

Result Columns:

Operation Buttons:

Search (execute search) Reset (clear the search form)

Query BizTransaction

Path: BCP Query / Query BizTransaction.

1. Prerequisites: Data must be synchronized to BCP via API, which can contain ARAP or not contain ARAP.
2. Users can search biz transaction records by multiple search criteria.
3. Users can click + on the left of Policy No. to expand and view detailed biz transaction information.
4. Users can click Fee in TransactionDetail to view detailed fee information.

Search Criteria:

Result Columns:

Fee Detail modal columns:

Operation Buttons:

Search (execute search) Reset (clear the search form) Export To Excel (export the biz transaction list to an Excel file)

BCP Query UI Configuration

User Preference & Display Configuration

Besides the default search criteria and results, the system now supports users in adding more tailored search criteria and results via the user preference component for those ES-search-based UIs.

If users want to add or remove any search criteria and results, they can click on the user preference component (the gear icon in the upper right corner).

For more details about user preference, see User Preference Guide.

The user preference transfer-box component contains an Unselected fields pool (left) and a Selected fields pool (right). Use Push to add fields to the display, Pull to remove fields back to the available pool. The configuration takes effect only for the current login account.

Note: Custom field configuration only applies to the current login account. Different roles can prioritize different columns — e.g. finance roles may show Amount, Balance, Currency first, while operation roles may show Policy, Claim, Policyholder first. Exporting with no query result will produce an empty Excel file.

Index Configuration

Index Management provides configurable search engine indexes for the BCP query screens. Take the Policy index configuration as an example:

Index-level configuration:

Configured field mappings:

Note: Add to _all = N means the field does not participate in the global fuzzy search. Need Display controls whether the field is returned to the front-end. Numeric/Date fields must be mapped with the correct type, otherwise range queries and sorting will fail.

Configuration for BCP Load Detail UI

Now, if you expand the selection, you will see a lot of new information related to the transaction.

Expanded detail fields: Quote No., Policy No., Endorsement No., Product Name, Policyholder Name, Payment Method, Payer/Payee Type, Generation Date, Policy Expiry Date, Branch, Agent, ARAP Category, Reinsurance Policy No., Statement No., Endorsement Effective Date, Supervisor, etc.

All information here is actually loaded from the respective object model based on the data dictionary definition. So if you want to display more information here, you can configure the respective field in the DD and pass the values via API. The result will automatically appear in the detail screen.

The Data Dictionary (Module = BCP, Group = BCP_Core, Context = Common) manages the metadata of BCP business objects (BizTransaction, ARAP, Commission, Invoice, Prepaid Order, Collection, Offset, etc.). Take the BcpArap business object as an example — its tenant-level extension fields:

Note: Tenant-maintained fields are tenant-isolated and only take effect for the current tenant. Field changes must be deployed before they take effect in the business environment. The Data Dictionary supports metadata import/export deployment packages for cross-environment migration (same-version platforms only).

BCP Export API

• /bcp-core/core/export/v1/exportArap
• /bcp-core/core/export/v1/exportPayment
• /bcp-core/core/export/v1/exportReceipt
• /bcp-core/core/export/v1/exportAppOffset
• /bcp-core/core/export/v1/paymentApproveExport
• /bcp-core/core/export/v1/asyncExport

BCP Query via Skills

The insuremo-gi-bcp-query skill provides programmatic API access to query all BCP transaction data. It covers the following business domains:

• Suspense — parked funds awaiting allocation
• BizTransaction — root business transactions (new business, endorsement, claim, etc.)
• Collection — money received from customers
• Payment — money disbursed (claim payouts, refunds)
• Offset — AR/AP netting and reconciliation
• GL Voucher — GL accounting entries
• ARAP — accounts receivable and payable
• Commission & Settlement — commission records and settlement details
• GL Mapping Rules & Fee Types — BCP configuration data (GL double-entry mapping rules and fee type definitions)

These are the APIs for data export in BCP. For the function description of each API, please refer to the instructions in the SDK. This section introduces the supported capabilities for exporting data in the API.

• columnList: Specify the data columns to be exported
• Label: rename column header
• CodeTable: convert Code values
• datePattern: specify the date format
• x-mo-lang-id: specifying the output language through the parameter “x-mo-lang-id” in the header.

X-mo-lang-id Code Table

Sample request

{
    "columnList": [  //Specify the data columns to be exported
        "ArapNo",
        "BranchCode",
        "BranchName",
        {
            "name": "ArapType",
            "label": "Arap Type Test", //rename column header
            "codeTable": "BcpArapType" //convert Code values
        },
        {
            "name": "InsertTime",
            "label": "Time Test",
            "datePattern":"yyy-MM-dd" //specify the date format
        }

    ],
    "conditions": {
        "ArapType": "-1001"
    },
    "fromRangeConditions": {
        "InsertTime":"2023-07-17"
    },
    "toRangeConditions": {
        "InsertTime":"2023-07-17"
    },
    "fuzzyConditions": {}
}

Data Source Options Reference

The drop-down fields on the BCP Query screens are backed by the code tables below. Tables marked Data Table have a fixed option list; tables marked Master Data are maintained in their own maintenance menus and their options come from master records.

Platform Doc & Skills Reference

• BCP Query — Platform technical documentation for the BCP query module
• User Preference Guide — How to customize search criteria and result columns
• You can also use the deep search skill to look up more details on BCP query APIs, SDK calls, and configuration data