workstation.get - Workstation Master Data

Basic Information

API Name

workstation.get

Method Name

upWorkStationCROSS_workstation

Target Table

WORKSTATION

JSON Node

workstation_data

Primary Key

ID

Code Location

RegularESB.java:3830

Response Fields

ERP Field	MES Field	Description
`workstation_no`	ID	Workstation number (Primary Key)
`workstation_name`	NAME	Workstation name
`factory_no`	FACTORYID	Factory number
`modify_no`	-	Modified by
`tran_status`	TRAN_STATUS	Transaction status

Response Example

{
  "workstation_data": [
    {
      "workstation_no": "WS001",
      "workstation_name": "Assembly Line A",
      "factory_no": "FACTORY01",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

Database Update SQL

Check Insert or Update

SELECT COUNT(1) FROM WORKSTATION WHERE ID = N'{workstation_no}'
-- count > 0 → UPDATE, count = 0 → INSERT

INSERT (Add Workstation)

INSERT INTO WORKSTATION (
    ID, NAME, DESCRIPTION, LOCATION,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME,
    WS002, WS003, WS004, WS007, BARCODEUSE, DISPATCHUSE
) VALUES (
    :WSID,
    :WSNAME,
    :WSDESCRIPTION,
    :WSLOCATION,          -- Parent factory
    :userid,
    N'{current_time}',
    'N',                  -- WS002
    'Y',                  -- WS003
    'N',                  -- WS004
    'Y',                  -- WS007
    2,                    -- BARCODEUSE
    2                     -- DISPATCHUSE
)

UPDATE (Modify Workstation)

UPDATE WORKSTATION SET
    NAME = :WSNAME,
    DESCRIPTION = :WSDESCRIPTION,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{current_time}'
WHERE ID = :WSID AND LOCATION = :WSLOCATION