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.

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.

Process Definition

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

1

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.

2

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.

3

Closing Confirmation

Once sales history verification is complete, process closing confirmation for that date.

4

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.

5

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.

6

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.

7

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.

API Function List_Sales History Lookup

API	Description	Server	Method	Remarks
Closing Confirmation	Process closing confirmation by sales date.	BO	POST	🔗View API >
Closing Confirmation Cancellation	Process closing confirmation cancellation by sales date.	BO	POST	🔗View API >
Sales History Summary Lookup	Look up the per-vendor summary of sales history.	BO	GET	🔗View API >
Sales History List Lookup	Look up the list of sales history by order number and product unit.	BO	GET	🔗View API >
Sales History Excel Download	Download the list data on the sales history lookup screen as a bulk Excel file.	BO	GET	🔗View API >
Sales Closing Status Count Lookup	Before closing confirmation is processed, look up the settlement registration count, closing confirmation count, and sales transmission count by sales date.	BO	GET	🔗View API >

API Function List_Mileage Lookup

API	Description	Server	Method	Remarks
Mileage Accrual Summary List Lookup	Look up the mileage accrual summary list.	BO	GET	🔗View API >
Mileage Accrual List Lookup	Look up the mileage accrual list by accrual category.	BO	GET	🔗View API >
Mileage Accrual List Count Lookup	Look up the count of the mileage accrual list by accrual category.	BO	GET	🔗View API >
Mileage Accrual List Excel Download	Download the mileage accrual list data as a bulk Excel file.	BO	GET	🔗View API >
Mileage Usage Summary List Lookup	Look up the mileage usage summary list.	BO	GET	🔗View API >
Mileage Usage List Lookup	Look up the mileage usage list by usage category.	BO	GET	🔗View API >
Mileage Usage List Count Lookup	Look up the count of the mileage usage list by usage category.	BO	GET	🔗View API >
Mileage Usage List Excel Download	Download the mileage usage list data as a bulk Excel file.	BO	GET	🔗View API >

API Function List_Delivery Fee Lookup

API	Description	Server	Method	Remarks
Per-Vendor Delivery Fee Summary Lookup	Look up the per-vendor delivery fee summary list.	BO	GET	🔗View API >
Per-Vendor Delivery Fee List Lookup	Look up the per-vendor delivery fee list.	BO	GET	🔗View API >
Per-Vendor Delivery Fee List Count Lookup	Look up the count of the per-vendor delivery fee list.	BO	GET	🔗View API >
Per-Vendor Delivery Fee Excel Download	Download the per-vendor delivery fee list data as a bulk Excel file.	BO	GET	🔗View API >

API Function List_Per-Vendor Sales Commission Lookup

API	Description	Server	Method	Remarks
Per-Vendor Sales Commission Summary Lookup	Look up the per-vendor sales commission summary list.	BO	GET	🔗View API >
Per-Vendor Sales Commission List Lookup	Look up the per-vendor sales commission list.	BO	GET	🔗View API >
Per-Vendor Sales Commission List Count Lookup	Look up the count of the per-vendor sales commission list.	BO	GET	🔗View API >
Per-Vendor Sales Commission List Excel Download	Download the per-vendor sales commission list data as a bulk Excel file.	BO	GET	🔗View API >

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

Order History Category	Sales Recognition Point (Order History Status)	Delivery Fee Information	Payment Information
General Order	Delivery Completed	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	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
Exchange	Recognized up to the exchange pickup-completed order at the time of exchange delivery completion	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	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
Return	Return Completed	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	When an order belonging to the same claim number is return-completed, the aggregation includes the refund amount and pickup delivery fee payment information
Return During Exchange	Return Completed (exchange and exchange-cancellation orders arising from a return during exchange are not included)		The exchange and exchange-cancellation amounts arising from a return during exchange are not included in the payment information

• 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)