> For the complete documentation index, see [llms.txt](https://tech.x2bee.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tech.x2bee.com/api-guide/api-guides-en/back-office/settlement-bo/sales-settlement-management.md).

# Sales Settlement Management

The sales settlement management service is used to systematically track the site's order history and communicate with vendors. Key features include sales history lookup, daily sales aggregation, mileage lookup, delivery fee lookup, and per-vendor sales commission lookup.

***

## Key Features

* **Daily Sales Aggregation**
  * At 00:10, a batch job aggregates sales information, order benefit information, delivery fee information, and payment information by date.
  * From the settlement sales aggregation information, look up the sales amount, discount share, delivery fee share, net sales amount, sales commission, and settlement amount by vendor.
* **Mileage Lookup**
  * Look up mileage accrual and usage history.
  * Accrual is classified into basic accrual, grade-based additional accrual, and promotional accrual.
  * Usage is classified into payment and refund.
* **Delivery Fee Lookup**
  * Look up the delivery fee history incurred by vendor.
  * Vendors other than the vendor of the logged-in user cannot be looked up.
* **Per-Vendor Sales Commission Lookup**
  * Look up the sales commission history incurred by vendor.
  * Vendors other than the vendor of the logged-in user cannot be looked up.
* **Closing Confirmation and Cancellation**
  * Confirm or cancel the closing of sales for a selected period.
  * After closing confirmation, sales aggregation for that date cannot be reworked; after cancellation, rework becomes possible again.
* **Sales Transmission Check**
  * If a sales transmission record exists, closing confirmation cannot be canceled.

{% hint style="warning" %}
**Notes**

* Daily sales aggregation is processed by batch at 00:10 every day.
* Vendors other than the vendor of the logged-in user cannot be looked up in certain lookup functions.
  {% endhint %}

## Process Definition

This refers to the process for sales history lookup, closing confirmation, delivery fee lookup, mileage lookup, and per-vendor sales commission lookup.

<figure><img src="https://2999922013-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXTxKSWMmuxEkop1pvuwe%2Fuploads%2FpdeHOA5RQzjK3XbGcdWv%2F%E1%84%86%E1%85%A2%E1%84%8E%E1%85%AE%E1%86%AF.png?alt=media&#x26;token=94926571-83fb-4274-b44f-7bc1a5c9eb10" alt=""><figcaption></figcaption></figure>

{% stepper %}
{% step %}

### Sales Aggregation

Every day at 00:10, a daily sales aggregation batch job runs and aggregates sales information, order benefit information, delivery fee information, and payment information.
{% endstep %}

{% step %}

### Sales History Lookup

On the sales history lookup screen, verify sales information, delivery fee information, discount information, etc. Also check that the data matches the delivery fee lookup screen and the per-vendor sales commission lookup screen.
{% endstep %}

{% step %}

### Closing Confirmation

Once sales history verification is complete, process closing confirmation for that date.
{% endstep %}

{% step %}

### Closing Confirmation Cancellation

If sales aggregation rework is required, process closing confirmation cancellation and run the sales aggregation batch job for that date. However, if a sales transmission record exists, closing confirmation cannot be canceled.
{% endstep %}

{% step %}

### Mileage Lookup

The mileage screen is divided into two tabs: mileage accrual and mileage usage. Each tab provides a summary list and a detail list by category, along with a bulk Excel download feature.
{% endstep %}

{% step %}

### Delivery Fee Lookup

The delivery fee lookup screen provides a per-vendor delivery fee summary list and detail list, along with a bulk Excel download feature. When accessed via the PO system, vendors other than the vendor of the logged-in user cannot be looked up.
{% endstep %}

{% step %}

### Per-Vendor Sales Commission Lookup

The per-vendor sales commission lookup screen provides a per-vendor sales commission summary list and detail list, along with a bulk Excel download feature. When accessed via the PO system, vendors other than the vendor of the logged-in user cannot be looked up.
{% endstep %}
{% endstepper %}

## API Function List\_Sales History Lookup

<table><thead><tr><th width="129">API</th><th width="352.888916015625">Description</th><th width="92.4444580078125" align="center">Server</th><th width="89.111083984375" align="center">Method</th><th>Remarks</th></tr></thead><tbody><tr><td>Closing Confirmation</td><td>Process closing confirmation by sales date.</td><td align="center">BO</td><td align="center">POST</td><td><a href="http://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%A4%EC%B6%9C%EB%82%B4%EC%97%AD%EC%A1%B0%ED%9A%8C&#x26;path=saveSaleClose">🔗View API ></a></td></tr><tr><td>Closing Confirmation Cancellation</td><td>Process closing confirmation cancellation by sales date.</td><td align="center">BO</td><td align="center">POST</td><td><a href="http://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%A4%EC%B6%9C%EB%82%B4%EC%97%AD%EC%A1%B0%ED%9A%8C&#x26;path=saveSaleCloseCancel">🔗View API ></a></td></tr><tr><td>Sales History Summary Lookup</td><td>Look up the per-vendor summary of sales history.</td><td align="center">BO</td><td align="center">GET</td><td><a href="http://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%A4%EC%B6%9C%EB%82%B4%EC%97%AD%EC%A1%B0%ED%9A%8C&#x26;path=getAcSaleInfoSummary">🔗View API ></a></td></tr><tr><td>Sales History List Lookup</td><td>Look up the list of sales history by order number and product unit.</td><td align="center">BO</td><td align="center">GET</td><td><a href="http://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%A4%EC%B6%9C%EB%82%B4%EC%97%AD%EC%A1%B0%ED%9A%8C&#x26;path=getAcSaleInfoList">🔗View API ></a></td></tr><tr><td>Sales History Excel Download</td><td>Download the list data on the sales history lookup screen as a bulk Excel file.</td><td align="center">BO</td><td align="center">GET</td><td><a href="http://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%A4%EC%B6%9C%EB%82%B4%EC%97%AD%EC%A1%B0%ED%9A%8C&#x26;path=getAcSaleInfoExcelDown">🔗View API ></a></td></tr><tr><td>Sales Closing Status Count Lookup</td><td>Before closing confirmation is processed, look up the settlement registration count, closing confirmation count, and sales transmission count by sales date.</td><td align="center">BO</td><td align="center">GET</td><td><a href="http://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%A4%EC%B6%9C%EB%82%B4%EC%97%AD%EC%A1%B0%ED%9A%8C&#x26;path=getAcSaleInfoCount">🔗View API ></a></td></tr></tbody></table>

## API Function List\_Mileage Lookup

<table><thead><tr><th width="135.6666259765625">API</th><th width="304.111083984375">Description</th><th width="94.666748046875" align="center">Server</th><th width="99.111083984375" align="center">Method</th><th>Remarks</th></tr></thead><tbody><tr><td>Mileage Accrual Summary List Lookup</td><td>Look up the mileage accrual summary list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=getMileageRsrvSummaryList">🔗View API ></a></td></tr><tr><td>Mileage Accrual List Lookup</td><td>Look up the mileage accrual list by accrual category.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=getMileageRsrvDetailList">🔗View API ></a></td></tr><tr><td>Mileage Accrual List Count Lookup</td><td>Look up the count of the mileage accrual list by accrual category.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=getMileageRsrvDetailListCount">🔗View API ></a></td></tr><tr><td>Mileage Accrual List Excel Download</td><td>Download the mileage accrual list data as a bulk Excel file.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=downloadMileageRsrvExcel">🔗View API ></a></td></tr><tr><td>Mileage Usage Summary List Lookup</td><td>Look up the mileage usage summary list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=getMileageUseSummaryList">🔗View API ></a></td></tr><tr><td>Mileage Usage List Lookup</td><td>Look up the mileage usage list by usage category.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=getMileageUseDetailList">🔗View API ></a></td></tr><tr><td>Mileage Usage List Count Lookup</td><td>Look up the count of the mileage usage list by usage category.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=getMileageUseDetailListCount">🔗View API ></a></td></tr><tr><td>Mileage Usage List Excel Download</td><td>Download the mileage usage list data as a bulk Excel file.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%A7%88%EC%9D%BC%EB%A6%AC%EC%A7%80%20%EC%A1%B0%ED%9A%8C&#x26;path=downloadMileageUseExcel">🔗View API ></a></td></tr></tbody></table>

## API Function List\_Delivery Fee Lookup

<table><thead><tr><th width="145.6666259765625">API</th><th width="336.666748046875">Description</th><th width="93.5555419921875" align="center">Server</th><th width="94.6666259765625" align="center">Method</th><th>Remarks</th></tr></thead><tbody><tr><td>Per-Vendor Delivery Fee Summary Lookup</td><td>Look up the per-vendor delivery fee summary list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%B0%B0%EC%86%A1%EB%B9%84%20%EC%A1%B0%ED%9A%8C&#x26;path=getAcDeliveryAmountSummaryList">🔗View API ></a></td></tr><tr><td>Per-Vendor Delivery Fee List Lookup</td><td>Look up the per-vendor delivery fee list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%B0%B0%EC%86%A1%EB%B9%84%20%EC%A1%B0%ED%9A%8C&#x26;path=getAcDeliveryAmountDetailList">🔗View API ></a></td></tr><tr><td>Per-Vendor Delivery Fee List Count Lookup</td><td>Look up the count of the per-vendor delivery fee list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%B0%B0%EC%86%A1%EB%B9%84%20%EC%A1%B0%ED%9A%8C&#x26;path=getAcDeliveryAmountDetailListCount">🔗View API ></a></td></tr><tr><td>Per-Vendor Delivery Fee Excel Download</td><td>Download the per-vendor delivery fee list data as a bulk Excel file.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%EB%B0%B0%EC%86%A1%EB%B9%84%20%EC%A1%B0%ED%9A%8C&#x26;path=downloadAcDeliveryAmountExcel">🔗View API ></a></td></tr></tbody></table>

## API Function List\_Per-Vendor Sales Commission Lookup

<table><thead><tr><th width="126.77783203125">API</th><th width="356.111083984375">Description</th><th width="93.5555419921875" align="center">Server</th><th width="95.77783203125" align="center">Method</th><th>Remarks</th></tr></thead><tbody><tr><td>Per-Vendor Sales Commission Summary Lookup</td><td>Look up the per-vendor sales commission summary list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%ED%98%91%EB%A0%A5%EC%82%AC%EB%B3%84%20%EB%A7%A4%EC%B6%9C%EC%88%98%EC%88%98%EB%A3%8C%20%EC%A1%B0%ED%9A%8C&#x26;path=getEntrCommisionSummaryList">🔗View API ></a></td></tr><tr><td>Per-Vendor Sales Commission List Lookup</td><td>Look up the per-vendor sales commission list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%ED%98%91%EB%A0%A5%EC%82%AC%EB%B3%84%20%EB%A7%A4%EC%B6%9C%EC%88%98%EC%88%98%EB%A3%8C%20%EC%A1%B0%ED%9A%8C&#x26;path=getEntrCommissionDetailList">🔗View API ></a></td></tr><tr><td>Per-Vendor Sales Commission List Count Lookup</td><td>Look up the count of the per-vendor sales commission list.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%ED%98%91%EB%A0%A5%EC%82%AC%EB%B3%84%20%EB%A7%A4%EC%B6%9C%EC%88%98%EC%88%98%EB%A3%8C%20%EC%A1%B0%ED%9A%8C&#x26;path=getEntrCommissionDetailListCount">🔗View API ></a></td></tr><tr><td>Per-Vendor Sales Commission List Excel Download</td><td>Download the per-vendor sales commission list data as a bulk<br>Excel file.</td><td align="center">BO</td><td align="center">GET</td><td><a href="https://apibo.x2bee.com/content?bo=settlement&#x26;depth=%ED%98%91%EB%A0%A5%EC%82%AC%EB%B3%84%20%EB%A7%A4%EC%B6%9C%EC%88%98%EC%88%98%EB%A3%8C%20%EC%A1%B0%ED%9A%8C&#x26;path=entrCommissionDetailExcelDownload">🔗View API ></a></td></tr></tbody></table>

## Other Notes

* Benefit information is aggregated for records where the order number and order processing sequence number of the sales-recognized order are the same

<table><thead><tr><th width="105.888916015625">Order History Category</th><th width="220.6666259765625">Sales Recognition Point (Order History Status)</th><th>Delivery Fee Information</th><th>Payment Information</th></tr></thead><tbody><tr><td>General Order</td><td>Delivery Completed</td><td>If an initial delivery fee arises due to a canceled order, when an order belonging to the same delivery number is delivery-completed, the aggregation includes the initial delivery fee information</td><td>If a canceled order occurs, when an order belonging to the same delivery number is delivery-completed, the aggregation includes the refund amount and initial delivery fee payment information</td></tr><tr><td>Exchange</td><td>Recognized up to the exchange pickup-completed order at the time of exchange delivery completion</td><td>If a pickup delivery fee or exchange delivery fee arises, when the exchange delivery is completed, the aggregation includes the pickup delivery fee and exchange delivery fee of orders belonging to the same claim number</td><td>If a pickup delivery fee or exchange delivery fee arises, when the exchange delivery is completed, the aggregation includes the payment information for the pickup delivery fee and exchange delivery fee of orders belonging to the same claim number</td></tr><tr><td>Return</td><td>Return Completed</td><td>If a pickup delivery fee arises, when an order belonging to the same claim number is return-completed, the aggregation includes the pickup delivery fee information</td><td>When an order belonging to the same claim number is return-completed, the aggregation includes the refund amount and pickup delivery fee payment information</td></tr><tr><td>Return During Exchange</td><td>Return Completed<br><mark style="color:red;">(exchange and exchange-cancellation orders arising from</mark><br><mark style="color:red;">a return during exchange are</mark><br><mark style="color:red;">not included)</mark></td><td></td><td>The exchange and exchange-cancellation amounts arising from a return during exchange are not included in the payment information</td></tr></tbody></table>

* The common codes used on the sales history lookup screen are as follows:
  * Sales Classification Code (AC004)
  * User Classification Code (UR001)
* The common codes used on the mileage lookup screen are as follows:
  * Additional Cost Detail Classification Code (OM019)
  * Payment Classification Code (OM012)
  * Order History Classification (OM003)
* The common codes used on the delivery fee lookup screen are as follows:
  * Delivery Type (LO002)
  * Delivery Processing Type (PR008)
  * Cost Classification Code (OM043)
  * Occurrence Classification Code (OM017)
  * User Classification Code (UR001)
* The common code used on the per-vendor sales commission lookup screen is as follows:
  * User Classification Code (UR001)