wo.update - eMES API

1. Basic Information

Item	Description
API Chinese Name	Work Order Update (Quantity/Date Adjustment)
API English Name	Work Order Update
API Code	`wo.update`
Case Number	0189142
REST Endpoint	`POST /ESB/API/upModetail`
Call Direction	ERP → MES
Trigger Timing	When ERP modifies order quantity or dates, sync to MES
Main Business Scenario	ERP adjusts order quantity or schedule dates, sync update MES order and lot data
Request Format	JSON (Content-Type: application/json)
Sync/Async	Synchronous call
Transaction Control	Required

Call Direction Note
This API is ERP → MES one-way push.
OperationType = 2 indicates modify operation.

2. Business Flow

Code Reference

API Entry: WoUpdate.java:59-100
Qty Validation: RegularESB.java:1234-1319
LOT Update: RegularESB.java:1243-1472
Process Recalc: SFT_OP_REALRUN.sqlUpdate_RecalculateAll()

3. Request Specification

Format: JSON
Content-Type: application/json

3.1 Outer Structure

Field	Type	Required	Description
CompanyID	string	Y	Company code
OperationType	int	Y	Operation type (2=Modify)
content	array	Y	Work order data array

3.2 content Array Contents

Field	Type	Required	Description	Affected Field
wo_no	string	Y	Work order number (type-number)	Condition field
item_no	string	Y	Item number	ITEMID
unit_no	string	Y	Unit code	UNIT
plan_date_s	string	Y	Planned start date	PLANPROCESSST
plan_date_e	string	Y	Planned end date	DUEDATETIME
wo_qty	decimal	Y	New planned quantity	QTY / PLANRELEASEQTY / LOT.LOTSIZE
so_no	string	N	Sales order number	DOID
so_seq	string	N	Sales order line	SEQUENCE
factory_no	string	Y	Factory code	FACTORYID
warehouse_no	string	N	Warehouse code	WAREHOUSEID
remark	string	N	Remarks	DESCRIPTION
priority	string	N	Priority	MO032

4. Response Specification

Field	Type	Description
code	string	200=Success, 500=Failure
msg	string	Processing result message
query	array	Query result

Success Behavior

UPDATE MODETAIL (Order master: QTY, DOID, dates, etc.)
UPDATE/INSERT/DELETE LOT (Lot quantity adjustment)
SFT_OP_REALRUN.sqlUpdate_RecalculateAll() (Recalculate process)

5. Quantity Validation Logic

Key Variable Definitions

MOQTY: MODETAIL.PLANRELEASEQTY (Original planned release qty)
MOREQTY: MODETAIL.RELEASEDQTY (Already released qty)
LOTQTY: LOT.LOTSIZE (Pending release qty)
newQTY: New quantity from ERP
MODIQTY: SFT_MO_MODI sum (Supplementary release qty)
BATQTY: SFT_BATCH_REC sum (Split batch qty)

5.1 Increase Quantity Scenario

newQTY > (MOQTY - MODIQTY)

// Increase quantity - directly add
Increase amount = newQTY - (MOQTY - MODIQTY)

IF LOT exists THEN
    UPDATE LOT SET LOTSIZE += increase amount
ELSE
    INSERT LOT (create new lot record)
END IF

UPDATE MODETAIL SET PLANRELEASEQTY += increase amount

5.2 Decrease Quantity Scenario

newQTY < (MOQTY - MODIQTY)

// Decrease quantity - need to check changeable allowance
Max changeable amount = MOQTY - MOREQTY - BATQTY
This change amount = MOQTY - newQTY - MODIQTY

IF Max changeable amount >= This change amount THEN
    // Can decrease
    IF LOTQTY - This change amount > 0 THEN
        UPDATE LOT SET LOTSIZE -= This change amount
    ELSE
        DELETE FROM LOT  // Qty becomes zero or negative after decrease
    END IF
    UPDATE MODETAIL SET PLANRELEASEQTY -= This change amount
ELSE
    // Cannot decrease - already released or split batch exceeds allowance
    Throw Exception("JS_0126_00060")
END IF

Important Restriction
If MES side released qty + split batch qty > new qty, cannot decrease, throws error JS_0126_00060.

5.3 Flow Diagram

6. Error Codes

Code	Message	Description
JS_0126_00060	Change qty less than pending release qty, not allowed	Decrease amount exceeds changeable allowance
JS_0096_00058	Item number does not exist	Item not found in ITEM table
JS_0016_00134	Unit does not exist, please confirm	Unit not found in UnitBasis
JS_0016_00115	Factory code does not exist	Factory not found in FACTORY
JS_0135_00036	Warehouse code does not exist	Warehouse not found in WAREHOUSE
remind_002	Data does not exist	Order number does not exist

7. JSON Examples

Request (Increase Quantity)

{
  "CompanyID": "COMP01",
  "OperationType": 2,  // 2=Modify
  "content": [{
    "wo_no": "5101-20260319001",
    "item_no": "FG-A001-001",
    "unit_no": "PCS",
    "plan_date_s": "2026-03-19 08:00:00",
    "plan_date_e": "2026-03-21 17:00:00",
    "wo_qty": 1500,  // Original 1000, increase 500
    "factory_no": "P001",
    "remark": "Additional order"
  }]
}

Request (Decrease Quantity)

{
  "CompanyID": "COMP01",
  "OperationType": 2,
  "content": [{
    "wo_no": "5101-20260319001",
    "item_no": "FG-A001-001",
    "unit_no": "PCS",
    "plan_date_s": "2026-03-19 08:00:00",
    "plan_date_e": "2026-03-20 17:00:00",
    "wo_qty": 800,  // Original 1000, decrease 200
    "factory_no": "P001",
    "remark": "Customer reduced order"
  }]
}

Response (Success)

{
  "code": "200",
  "msg": "success",
  "query": []
}

Response (Failure - Cannot Decrease)

{
  "code": "500",
  "msg": "JS_0126_00060",  // Released qty exceeds new qty
  "query": []
}

8. Database Update SQL

8.1 UPDATE MODETAIL (Update Order Master)

UPDATE MODETAIL SET
    PLANPROCESSST = :PLANPROCESSST,      -- Planned start date
    DUEDATETIME = :DUEDATETIME,          -- Planned end date
    DOID = :DOID,                        -- Sales order number
    SEQUENCE = :SEQUENCE,                -- Sales order line
    FACTORYID = :FACTORYID,              -- Factory code
    WAREHOUSEID = :WAREHOUSEID,          -- Warehouse code
    DESCRIPTION = :DESCRIPTION,          -- Remarks
    MO032 = :MO032,                      -- Priority
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{current_time}',
    FLAG = (SELECT MAX(FLAG)+1 FROM MODETAIL WHERE CMOID = :CMOID)
WHERE CMOID = :CMOID

8.2 Increase Quantity (UPDATE LOT)

-- Increase amount = newQTY - (MOQTY - MODIQTY)
UPDATE LOT SET
    LOTSIZE = LOTSIZE + {increase amount}
WHERE MOID = :CMOID

-- Also update MODETAIL planned release qty
UPDATE MODETAIL SET
    PLANRELEASEQTY = PLANRELEASEQTY + {increase amount},
    QTY = :newQTY
WHERE CMOID = :CMOID

8.3 Decrease Quantity (UPDATE/DELETE LOT)

-- Decrease amount = MOQTY - newQTY - MODIQTY
-- First check changeable allowance
Max changeable amount = MOQTY - MOREQTY - BATQTY

IF LOTQTY - decrease amount > 0 THEN
    -- Still has remaining after decrease
    UPDATE LOT SET
        LOTSIZE = LOTSIZE - {decrease amount}
    WHERE MOID = :CMOID
ELSE
    -- Qty becomes zero or negative after decrease, delete lot
    DELETE FROM LOT WHERE MOID = :CMOID
END IF

-- Also update MODETAIL planned release qty
UPDATE MODETAIL SET
    PLANRELEASEQTY = PLANRELEASEQTY - {decrease amount},
    QTY = :newQTY
WHERE CMOID = :CMOID

8.4 Recalculate Process

-- Recalculate all processes after update
SFT_OP_REALRUN.sqlUpdate_RecalculateAll("updateMODETAIL")

Quantity Validation Related Tables

MODETAIL.PLANRELEASEQTY: Planned release qty (MOQTY)
MODETAIL.RELEASEDQTY: Already released qty (MOREQTY)
LOT.LOTSIZE: Pending release qty (LOTQTY)
SFT_MO_MODI: Supplementary release qty (MODIQTY)
SFT_BATCH_REC: Split batch qty (BATQTY)

Code Location
Qty Validation: RegularESB.java:1234-1319
LOT Update: RegularESB.java:1243-1472

Work Order Update (Quantity/Date Adjustment)