Bank Withdrawal Reconciliation Details - Withdrawal

Query line-level details within a withdrawal reconciliation batch, used to check how each individual withdrawal transaction matches between Longbridge's internal accounting and the bank side.

Request parameters

Combine business filter conditions through filters (see the filters field notes below for optional fields), and use page, page_size, and orderBy to control pagination and sorting.

Business notes

Each record represents the reconciliation result of a single withdrawal transaction and can be linked back to its batch through batch_id.

A record carries the withdrawal number, ledger date and reconciliation date, business type (such as client withdrawal or deposit refund), upstream and downstream amounts and currencies, and the reconciliation mismatch type (such as the external side not existing).

Finance operations use it to drill down from a batch and locate unmatched or discrepant withdrawal transactions one by one.

Returns

On success, returns the matched record list with pagination info. See the response definition for the meaning of each returned column.

POSThttps://b-api.lbkrs.com/v1/datasets/booking_reconciliation_details_withdraw

Authorization

AuthorizationstringheaderRequired

Send the Broker ACCESS_TOKEN as Authorization: Bearer <token>.

Permission

cmbc.reconciliation_deposit_withdraw_query

The Broker ACCESS_TOKEN must be granted the permission above, or the call will be rejected.

Request body application/json

filtersobject

Filters. Combines business filters. Omit a filter field to disable that filter.

Child attributes

trade_typestring

Business Type. Filters results by Business Type.

Allowed values: deposit Client Deposit, deposit_register Account Opening Deposit, transfer_in Deposit Refund (credit), transfer_out Deposit Refund (debit), withdraw Client Withdrawal

Values

deposit: Client Deposit
deposit_register: Account Opening Deposit
transfer_in: Deposit Refund (credit)
transfer_out: Deposit Refund (debit)
withdraw: Client Withdrawal

trade_datestring

Reconciliation date. Filters results by Reconciliation date.

ledger_datestring

Ledger date. Filters results by Ledger date.

currencystring

Currency. Filters results by Currency.

Values are dynamic. Call GET /v1/datasets/refs/tenant_currencies_by_channel to retrieve the current data dictionary, and use the returned entry's key as this parameter's value.

mis_typestring

Reconciliation Results. Filters results by Reconciliation Results.

Allowed values: 1 Reconciled, 2 Unreconciled, 3 External side does not exist, 4 Internal side does not exist

Values

1: Reconciled
2: Unreconciled
3: External side does not exist
4: Internal side does not exist

match_keystring

Withdrawal ID. Filters results by Withdrawal ID.

bill_idstring

Withdrawal Statement ID. Filters results by Withdrawal Statement ID.

batch_idstring

Check number. Filters results by Check number.

pageinteger

Page. Page number to retrieve, starting from 1.

page_sizeinteger

Page Size. Number of records to return per page.

orderByarray<object>

Order By. Array of sorting rules. Each item defines a sort field and direction.

Responses

HTTP 200On success, returns paginated Bank Withdrawal Reconciliation Details - Withdrawal records together with pagination metadata such as the page number, page size, and total record count.

Standard response envelopecodemessagedata

dataobjectdata structure

listarray<object>required

List. Returned value: List of list.

Child attributes

idstring

Withdrawal Reconciliation ID. Returned value: Unique identifier of the current record.

trade_typestring

Business Type. Returned value: Business Type.

trade_type_valstring

Business Type (raw value). Raw value of trade_type. The trade_type field contains the display value resolved through a dictionary or related record; this field contains the underlying code or ID.

trade_datestring

Reconciliation date. Returned value: Reconciliation date. The date or time format follows the value returned by the API.

ledger_datestring

Ledger date. Returned value: Ledger date. The date or time format follows the value returned by the API.

lb_simple_namestring

Bank Abbreviation. Returned value: Bank Abbreviation.

lb_bank_accountstring

A/C No.. Returned value: A/C No..

lb_bank_namestring

Bank Name. Returned value: Bank Name.

upstream_currencystring

Upstream Currency. Returned value: Upstream Currency.

downstream_currencystring

Downstream Currency. Returned value: Downstream Currency.

upstream_amountstring

Upstream Amount. Returned value: Upstream Amount.

downstream_amountstring

Downstream Amount. Returned value: Downstream Amount.

batch_idstring

Check Number. Returned value: Check Number.

match_keystring

Withdrawal ID. Returned value: Withdrawal ID.

bill_datetimestring

Debit Date. Returned value: Debit Date. The date or time format follows the value returned by the API.

rms_datestring

Withdrawal Success Date. Returned value: Withdrawal Success Date. The date or time format follows the value returned by the API.

bill_idstring

Withdrawal Statement ID. Returned value: Withdrawal Statement ID.

bill_id_valstring

Withdrawal Statement ID (raw value). Raw value of bill_id. The bill_id field contains the display value resolved through a dictionary or related record; this field contains the underlying code or ID.

mis_typestring

Reconciliation Results. Returned value: Reconciliation Results.

mis_type_valstring

Reconciliation Results (raw value). Raw value of mis_type. The mis_type field contains the display value resolved through a dictionary or related record; this field contains the underlying code or ID.

created_atstring

Created Time. Returned value: Created Time. The date or time format follows the value returned by the API.

totalintegerrequired

Total. Returned value: Total number of matching records, used for pagination.

HTTP 400Bad request. Check the business error code in code and the error details in message.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

HTTP 401The user is not authenticated, or the login session has expired.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

HTTP 403The current account is not authorized to use this feature. Grant the required permission to the account in User Permission.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

HTTP 408The request timed out. Check the business error code in code and the error details in message.

Standard response envelopecodemessagedata

dataobjectdata structure

No nested fields

Request

curl --request POST \
  --url 'https://b-api.lbkrs.com/v1/datasets/booking_reconciliation_details_withdraw' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json'
  --data '{
  "filters": {},
  "page": 1,
  "page_size": 20,
  "orderBy": []
}'

Response

{
  "code": 0,
  "message": "success",
  "data": {
    "list": [
      {
        "id": "372997",
        "trade_type": "Deposit Refund (debit)",
        "trade_type_val": "transfer_out",
        "trade_date": "20260715",
        "ledger_date": "20260715",
        "lb_simple_name": "工银亚洲0012",
        "lb_bank_account": "Zhang San",
        "lb_bank_name": "072-072 ICBC (Asia) Ltd",
        "upstream_currency": "HKD",
        "downstream_currency": "",
        "upstream_amount": "666.10",
        "downstream_amount": "0.00",
        "batch_id": "167062",
        "match_key": "169978",
        "bill_datetime": "",
        "rms_date": "",
        "bill_id": " ",
        "bill_id_val": "",
        "mis_type": "External side does not exist",
        "mis_type_val": "3",
        "created_at": "1784116804"
      }
    ],
    "total": 77
  }
}