Customer Master Data

Basic Information

Response Fields

Response Example

{
  "customer_data": [
    {
      "customer_no": "CUST001",
      "customer_shortname": "Test Customer",
      "customer_name": "Test Customer Co., Ltd.",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

Database Update SQL

Check Insert or Update

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

INSERT (Add Customer)

INSERT INTO CUSTOMER (
    ID, SHOTNAME, NAME, TEL, FAX, EMAIL,
    AREA_ID, AREA_NAME, ADDRESS,
    CHECKMAINTAINNO, LASTMAINTAINUSER, LASTMAINTAINDATETIME
) VALUES (
    :CUSTOMERID,
    :SHOTNAME,
    :CUSTOMER_NAME,
    :TEL,
    :FAX,
    :EMAIL,
    :AREA_ID,
    :AREA_NAME,
    :ADDRESS,
    1,
    :Creator,
    GETDATE()
)

UPDATE (Modify Customer)

UPDATE CUSTOMER SET
    SHOTNAME = :SHOTNAME,
    NAME = :CUSTOMER_NAME,
    TEL = :TEL,
    FAX = :FAX,
    EMAIL = :EMAIL,
    AREA_ID = :AREA_ID,
    AREA_NAME = :AREA_NAME,
    ADDRESS = :ADDRESS
WHERE ID = :CUSTOMERID

MES Default Values