Skip to content
Longport WhaleLongport Whale
Deposit Reconciliation

Bank Deposit Reconciliation Details

Queries Bank Deposit Reconciliation Details data. Combine business filters in filters, and use page, page_size, and orderBy to control pagination and sorting.

Response

On success, the API returns the matching records and pagination metadata. See each filter field for its purpose, allowed values, and dynamic value source.

GEThttps://b-api.longbridge.xyz/v1/datasets/booking_reconciliation_details

This Dataset query is read-only. Use GET by default. If the encoded query parameters are too large, send the same parameters as a JSON body with POST to the same path.

Authorization

Authorizationstringheadercmbc.reconciliation_deposit_withdraw_queryRequired

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

Query parameters

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

depositdeposit_registertransfer_intransfer_outwithdraw

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

1234

match_keystring

Deposit ID. Filters results by Deposit ID.

bill_idstring

Deposit Statement ID. Filters results by Deposit 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 Deposit Reconciliation Details 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

Deposit 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

Deposit ID. Returned value: Deposit ID.

bill_datetimestring

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

rms_datestring

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

bill_idstring

Deposit Statement ID. Returned value: Deposit Statement ID.

bill_id_valstring

Deposit 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

Whale Docs