Order Records Overview

The Order Records feature is used to query and manage deposit orders and payout orders in the system, providing powerful filtering and query capabilities.

Feature Overview

Order Records includes the following features:

• Deposit Order Query: Query deposit order records
• Payout Order Query: Query payout order records
• Balance Records: Query merchant balance changes
• Service Statistics: View statistics by service dimension
• Success Rate Statistics: Analyze order success rates

Main Features

Deposit Order Records (Payment)

Path: Record → Payment

Query all deposit orders.

Main Fields:

Field	Description
Merchant Order No.	Order number from the merchant's system
Platform Order No.	DiamondPay platform order number
Requested Amount	Amount requested by the merchant for deposit
Actual Amount	Amount actually received
Credited Amount	Amount after deducting fees
Fee	Platform fee charged
Order Status	In Progress / Success / Failed / Closed
Created Time	Order creation time
Completed Time	Order completion time
Merchant ID	Owning merchant ID
Service ID	Service type used
Channel	Payment channel used

Filter Conditions:

• Time range (Created Time / Completed Time)
• Merchant filter
• Order status
• Order number search
• Service type
• Channel filter
• Amount range

[!TIP] When using time filters, it is recommended not to select an excessively long time range to improve query speed.

Payout Order Records (Payout)

Path: Record → Payout

Query all payout orders.

Main Fields:

Field	Description
Merchant Order No.	Order number from the merchant's system
Platform Order No.	DiamondPay platform order number
Requested Amount	Amount requested by the merchant for payout
Actual Amount	Amount actually paid
Fee	Platform fee charged
Order Status	In Progress / Success / Failed / Under Review
Recipient Info	Recipient name, account, etc.
Bank Info	Recipient bank code
Created Time	Order creation time
Completed Time	Order completion time

Special Operations:

• Upload payout proof
• Manually mark as failed
• View payout details

[!NOTE] Payout orders may go through an audit process. The audit status is shown in the order status.

Balance Records (BalanceRecord)

Path: Record → BalanceRecord

Query merchant balance change records across channels.

Record Types:

• Deposit credit
• Payout debit
• Balance freeze
• Balance unfreeze
• Manual adjustment
• Manual supplement adjustment

Main Fields:

• Change time
• Merchant ID
• Channel
• Change type
• Change amount
• Balance before change
• Balance after change
• Associated order number
• Remarks

Use Cases:

• Track fund flows
• Reconcile accounts
• Troubleshoot issues

Balance Transfer (BalanceTransfer)

Path: Record → BalanceTransfer

Query balance transfer records between merchants.

Record Information:

• Source Merchant
• Destination Merchant
• Transfer Amount
• Currency Type
• Operation Time
• Operator

Order Status Descriptions

Deposit Order Statuses

Status Code	Status Name	Description
0	In Progress	Order created, awaiting payment
1	Success	Deposit successful, credited
2	Failed	Deposit failed
3	Closed	Order closed or expired

Payout Order Statuses

Status Code	Status Name	Description
0	In Progress	Order processing
1	Success	Payout successful
2	Failed	Payout failed
3	Under Review	Awaiting manual review
4	Review Rejected	Review not passed

[!IMPORTANT] Order status changes trigger callback notifications to the merchant's system. Ensure merchants properly handle all status types.

Advanced Queries

Combined Queries

Multiple filter conditions can be used simultaneously:

Time Range: 2024-01-01 ~ 2024-01-31
Merchant: PF0001
Status: Success
Service: SVC0001

The system will return orders matching all conditions.

Quick Order Number Search

Enter an order number directly in the search box:

• Supports merchant order number
• Supports platform order number
• Automatically identifies the order type

Export Function

Some pages support exporting query results to Excel:

1. Set filter conditions
2. Click the export button
3. Select export fields
4. Download the file

[!WARNING] Exporting large volumes of data may take a long time. It is recommended to export in batches.

Order Details

Viewing Order Details

Click an order to view complete information:

Basic Information:

• Order Number
• Created Time
• Completed Time
• Merchant Information
• Service Information

Amount Information:

• Requested Amount
• Actual Amount
• Fee
• Credited Amount

Channel Information:

• Channel used
• Channel Order Number
• Upstream response information

Status Information:

• Current Status
• Status Change History
• Callback Notification Records

Order Operations

Depending on the order status and type, the following operations may be available:

Deposit Orders:

• View payment page
• Close order
• View QR code

Payout Orders:

• Upload payout proof
• Manually mark as failed
• Re-initiate payout

Notification Records

Notification Details (NotificationDetail)

Path: Record → NotificationDetail

View callback notification records sent by the system to merchants.

Record Information:

• Order Number
• Notification Time
• Notification Content
• Merchant Response
• Retry Count
• Notification Status

Notification Statuses:

• Success: Merchant responded correctly
• Failed: Merchant response was abnormal
• Retrying: Awaiting retry

[!NOTE] The system automatically retries failed notifications, up to a maximum of 5 retries.

FAQ

Q: How to quickly find a specific order?

A:

1. Enter the order number directly in the search box
2. The system will automatically search both merchant and platform order numbers
3. If you cannot recall the order number, use time range and merchant filters to narrow the scope

Q: What to do when order amounts don't match?

A: Check the following:

1. View the amount details in the order details
2. Verify that fee calculations are correct
3. Check balance records to confirm crediting
4. Cross-reference with the upstream channel's order information

Q: What to do when an order is stuck in progress?

A:

1. Check the order creation time to determine if it has timed out
2. Verify that the channel status is normal
3. Check if there are callback notifications
4. Contact the upstream channel to confirm the order status
5. Manually process the order if necessary

Q: How to get transaction volume statistics for a specific time period?

A: Use the "Service Statistics" or "Success Rate Statistics" features and set the time range to view aggregated data.

Related Pages

• Statistical Reports - View data statistics
• Merchant Management - Manage merchant configurations
• Channel Management - View channel statuses