InventoryWebService Web Service

InventoryWebService

Click here for a complete list of operations.

UpdateItemsDetailsByColumn

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /InventoryWebService.asmx HTTP/1.1
Host: laluws.compulinerp.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://tempuri.org/UpdateItemsDetailsByColumn"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <UpdateItemsDetailsByColumn xmlns="http://tempuri.org/">
      <details>
        <ITEM_MAST>
          <ITEM>string</ITEM>
          <DESC1>string</DESC1>
          <DESC2>string</DESC2>
          <PACK>decimal</PACK>
          <UNIT>string</UNIT>
          <ROL>decimal</ROL>
          <ROQ>decimal</ROQ>
          <MAX_S>decimal</MAX_S>
          <MIN_S>decimal</MIN_S>
          <QIH>decimal</QIH>
          <BF_BAL>decimal</BF_BAL>
          <CF_BAL>decimal</CF_BAL>
          <COST_PRICE>decimal</COST_PRICE>
          <IS_ROUND>boolean</IS_ROUND>
          <IS_CUTTED>boolean</IS_CUTTED>
          <CUT_STAT>int</CUT_STAT>
          <LENGTH>decimal</LENGTH>
          <WIDTH>decimal</WIDTH>
          <ITEM_UNIT1>string</ITEM_UNIT1>
          <ITEM_UNIT2>string</ITEM_UNIT2>
          <ACTUAL_COST>int</ACTUAL_COST>
          <IS_SERVICE_ITEM>int</IS_SERVICE_ITEM>
          <LAST_CHANGE_DATE>dateTime</LAST_CHANGE_DATE>
          <UNIT_1_QTY>decimal</UNIT_1_QTY>
          <UNIT_2_QTY>decimal</UNIT_2_QTY>
          <BACK_UNIT_1_QTY>decimal</BACK_UNIT_1_QTY>
          <BACK_UNIT_2_QTY>decimal</BACK_UNIT_2_QTY>
          <ACTIVE_STAT>int</ACTIVE_STAT>
          <CHANGED>int</CHANGED>
          <UNIT_1_RESERVED_QTY>decimal</UNIT_1_RESERVED_QTY>
          <UNIT_2_RESERVED_QTY>decimal</UNIT_2_RESERVED_QTY>
          <COMPCODE>string</COMPCODE>
          <LOCA_CODE>string</LOCA_CODE>
          <CATCODE>string</CATCODE>
          <CATCODE_L2>string</CATCODE_L2>
          <CATCODE_L3>string</CATCODE_L3>
          <ITEM_UNIT0>string</ITEM_UNIT0>
          <Is_stocks_in_second__unit>int</Is_stocks_in_second__unit>
          <CATCODE_L4>string</CATCODE_L4>
          <SALES_PRICE_BULK>decimal</SALES_PRICE_BULK>
          <SALES_PRICE_LOOSE>decimal</SALES_PRICE_LOOSE>
          <COST_PRICE_BULK>decimal</COST_PRICE_BULK>
          <COST_PRICE_LOOSE>decimal</COST_PRICE_LOOSE>
          <Last_GRN_No>string</Last_GRN_No>
          <UNIT_1_QTY_FREEZED>decimal</UNIT_1_QTY_FREEZED>
          <UNIT_2_QTY_FREEZED>decimal</UNIT_2_QTY_FREEZED>
          <DATE_FREEZED>dateTime</DATE_FREEZED>
          <PHYSICAL_PROCESS_ID>string</PHYSICAL_PROCESS_ID>
          <UNIT_1_QTY_PHY_ENTERED>decimal</UNIT_1_QTY_PHY_ENTERED>
          <UNIT_2_QTY_PHY_ENTERED>decimal</UNIT_2_QTY_PHY_ENTERED>
          <DATE_PHY_ENTERED>dateTime</DATE_PHY_ENTERED>
          <PHY_ENTERED_PROCESS_ID>string</PHY_ENTERED_PROCESS_ID>
          <SALES_PRICE_BULK_BACK>decimal</SALES_PRICE_BULK_BACK>
          <SALES_PRICE_LOOSE_BACK>decimal</SALES_PRICE_LOOSE_BACK>
          <LAST_DOC_NO>string</LAST_DOC_NO>
          <SALES_PRICE_BULK_MIN>decimal</SALES_PRICE_BULK_MIN>
          <SALES_PRICE_LOOSE_MIN>decimal</SALES_PRICE_LOOSE_MIN>
          <ITEM_IMAGE>base64Binary</ITEM_IMAGE>
          <COST_PRICE_BULK_BACK>decimal</COST_PRICE_BULK_BACK>
          <COST_PRICE_LOOSE_BACK>decimal</COST_PRICE_LOOSE_BACK>
          <COST_PRICE_BULK_P1>decimal</COST_PRICE_BULK_P1>
          <COST_PRICE_LOOSE_P1>decimal</COST_PRICE_LOOSE_P1>
          <COST_PRICE_BULK_P2>decimal</COST_PRICE_BULK_P2>
          <COST_PRICE_LOOSE_P2>decimal</COST_PRICE_LOOSE_P2>
          <ITEM_BRAND>string</ITEM_BRAND>
          <ITEM_TYPE>string</ITEM_TYPE>
          <ITEM_MANUFACTURE_ID>string</ITEM_MANUFACTURE_ID>
          <CATCODE_DESCRIPTION>string</CATCODE_DESCRIPTION>
          <LAST_PURCHASE_PRICE>decimal</LAST_PURCHASE_PRICE>
          <IS_SERIAL_AVAILABLE>decimal</IS_SERIAL_AVAILABLE>
          <WARRANTY_STATEMENT>string</WARRANTY_STATEMENT>
          <WARRANTY_PERIOD>decimal</WARRANTY_PERIOD>
          <HIRING_DEPOSIT>decimal</HIRING_DEPOSIT>
          <HIRING_RATE>decimal</HIRING_RATE>
          <UNIT_1_QTY_RESERVED>decimal</UNIT_1_QTY_RESERVED>
          <UNIT_2_QTY_RESERVED>decimal</UNIT_2_QTY_RESERVED>
          <ECOMMERCE_OLD_PRICE>decimal</ECOMMERCE_OLD_PRICE>
          <ECOMMERCE_NEW_PRIZE>decimal</ECOMMERCE_NEW_PRIZE>
          <ECOMMERCE_LONG_DESC>string</ECOMMERCE_LONG_DESC>
          <ECOMMERCE_IMAGE_PATH>string</ECOMMERCE_IMAGE_PATH>
          <ECOMMERCE_GLOBAL_SEQ>int</ECOMMERCE_GLOBAL_SEQ>
          <ECOMMERCE_LOCAL_SEQ>int</ECOMMERCE_LOCAL_SEQ>
          <ECOMMERCE_IS_VISIBLE>int</ECOMMERCE_IS_VISIBLE>
          <ECOMMERCE_QTY_AVAILABLE>decimal</ECOMMERCE_QTY_AVAILABLE>
          <ECOMMERCE_ITEM_SIZE>string</ECOMMERCE_ITEM_SIZE>
          <ECOMMERCE_MAX_QTY_PER_ORDER>decimal</ECOMMERCE_MAX_QTY_PER_ORDER>
          <STOCK_AGE_START_DATE>dateTime</STOCK_AGE_START_DATE>
        </ITEM_MAST>
        <ITEM_MAST>
          <ITEM>string</ITEM>
          <DESC1>string</DESC1>
          <DESC2>string</DESC2>
          <PACK>decimal</PACK>
          <UNIT>string</UNIT>
          <ROL>decimal</ROL>
          <ROQ>decimal</ROQ>
          <MAX_S>decimal</MAX_S>
          <MIN_S>decimal</MIN_S>
          <QIH>decimal</QIH>
          <BF_BAL>decimal</BF_BAL>
          <CF_BAL>decimal</CF_BAL>
          <COST_PRICE>decimal</COST_PRICE>
          <IS_ROUND>boolean</IS_ROUND>
          <IS_CUTTED>boolean</IS_CUTTED>
          <CUT_STAT>int</CUT_STAT>
          <LENGTH>decimal</LENGTH>
          <WIDTH>decimal</WIDTH>
          <ITEM_UNIT1>string</ITEM_UNIT1>
          <ITEM_UNIT2>string</ITEM_UNIT2>
          <ACTUAL_COST>int</ACTUAL_COST>
          <IS_SERVICE_ITEM>int</IS_SERVICE_ITEM>
          <LAST_CHANGE_DATE>dateTime</LAST_CHANGE_DATE>
          <UNIT_1_QTY>decimal</UNIT_1_QTY>
          <UNIT_2_QTY>decimal</UNIT_2_QTY>
          <BACK_UNIT_1_QTY>decimal</BACK_UNIT_1_QTY>
          <BACK_UNIT_2_QTY>decimal</BACK_UNIT_2_QTY>
          <ACTIVE_STAT>int</ACTIVE_STAT>
          <CHANGED>int</CHANGED>
          <UNIT_1_RESERVED_QTY>decimal</UNIT_1_RESERVED_QTY>
          <UNIT_2_RESERVED_QTY>decimal</UNIT_2_RESERVED_QTY>
          <COMPCODE>string</COMPCODE>
          <LOCA_CODE>string</LOCA_CODE>
          <CATCODE>string</CATCODE>
          <CATCODE_L2>string</CATCODE_L2>
          <CATCODE_L3>string</CATCODE_L3>
          <ITEM_UNIT0>string</ITEM_UNIT0>
          <Is_stocks_in_second__unit>int</Is_stocks_in_second__unit>
          <CATCODE_L4>string</CATCODE_L4>
          <SALES_PRICE_BULK>decimal</SALES_PRICE_BULK>
          <SALES_PRICE_LOOSE>decimal</SALES_PRICE_LOOSE>
          <COST_PRICE_BULK>decimal</COST_PRICE_BULK>
          <COST_PRICE_LOOSE>decimal</COST_PRICE_LOOSE>
          <Last_GRN_No>string</Last_GRN_No>
          <UNIT_1_QTY_FREEZED>decimal</UNIT_1_QTY_FREEZED>
          <UNIT_2_QTY_FREEZED>decimal</UNIT_2_QTY_FREEZED>
          <DATE_FREEZED>dateTime</DATE_FREEZED>
          <PHYSICAL_PROCESS_ID>string</PHYSICAL_PROCESS_ID>
          <UNIT_1_QTY_PHY_ENTERED>decimal</UNIT_1_QTY_PHY_ENTERED>
          <UNIT_2_QTY_PHY_ENTERED>decimal</UNIT_2_QTY_PHY_ENTERED>
          <DATE_PHY_ENTERED>dateTime</DATE_PHY_ENTERED>
          <PHY_ENTERED_PROCESS_ID>string</PHY_ENTERED_PROCESS_ID>
          <SALES_PRICE_BULK_BACK>decimal</SALES_PRICE_BULK_BACK>
          <SALES_PRICE_LOOSE_BACK>decimal</SALES_PRICE_LOOSE_BACK>
          <LAST_DOC_NO>string</LAST_DOC_NO>
          <SALES_PRICE_BULK_MIN>decimal</SALES_PRICE_BULK_MIN>
          <SALES_PRICE_LOOSE_MIN>decimal</SALES_PRICE_LOOSE_MIN>
          <ITEM_IMAGE>base64Binary</ITEM_IMAGE>
          <COST_PRICE_BULK_BACK>decimal</COST_PRICE_BULK_BACK>
          <COST_PRICE_LOOSE_BACK>decimal</COST_PRICE_LOOSE_BACK>
          <COST_PRICE_BULK_P1>decimal</COST_PRICE_BULK_P1>
          <COST_PRICE_LOOSE_P1>decimal</COST_PRICE_LOOSE_P1>
          <COST_PRICE_BULK_P2>decimal</COST_PRICE_BULK_P2>
          <COST_PRICE_LOOSE_P2>decimal</COST_PRICE_LOOSE_P2>
          <ITEM_BRAND>string</ITEM_BRAND>
          <ITEM_TYPE>string</ITEM_TYPE>
          <ITEM_MANUFACTURE_ID>string</ITEM_MANUFACTURE_ID>
          <CATCODE_DESCRIPTION>string</CATCODE_DESCRIPTION>
          <LAST_PURCHASE_PRICE>decimal</LAST_PURCHASE_PRICE>
          <IS_SERIAL_AVAILABLE>decimal</IS_SERIAL_AVAILABLE>
          <WARRANTY_STATEMENT>string</WARRANTY_STATEMENT>
          <WARRANTY_PERIOD>decimal</WARRANTY_PERIOD>
          <HIRING_DEPOSIT>decimal</HIRING_DEPOSIT>
          <HIRING_RATE>decimal</HIRING_RATE>
          <UNIT_1_QTY_RESERVED>decimal</UNIT_1_QTY_RESERVED>
          <UNIT_2_QTY_RESERVED>decimal</UNIT_2_QTY_RESERVED>
          <ECOMMERCE_OLD_PRICE>decimal</ECOMMERCE_OLD_PRICE>
          <ECOMMERCE_NEW_PRIZE>decimal</ECOMMERCE_NEW_PRIZE>
          <ECOMMERCE_LONG_DESC>string</ECOMMERCE_LONG_DESC>
          <ECOMMERCE_IMAGE_PATH>string</ECOMMERCE_IMAGE_PATH>
          <ECOMMERCE_GLOBAL_SEQ>int</ECOMMERCE_GLOBAL_SEQ>
          <ECOMMERCE_LOCAL_SEQ>int</ECOMMERCE_LOCAL_SEQ>
          <ECOMMERCE_IS_VISIBLE>int</ECOMMERCE_IS_VISIBLE>
          <ECOMMERCE_QTY_AVAILABLE>decimal</ECOMMERCE_QTY_AVAILABLE>
          <ECOMMERCE_ITEM_SIZE>string</ECOMMERCE_ITEM_SIZE>
          <ECOMMERCE_MAX_QTY_PER_ORDER>decimal</ECOMMERCE_MAX_QTY_PER_ORDER>
          <STOCK_AGE_START_DATE>dateTime</STOCK_AGE_START_DATE>
        </ITEM_MAST>
      </details>
      <option>int</option>
    </UpdateItemsDetailsByColumn>
  </soap:Body>
</soap:Envelope>

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <UpdateItemsDetailsByColumnResponse xmlns="http://tempuri.org/">
      <UpdateItemsDetailsByColumnResult>boolean</UpdateItemsDetailsByColumnResult>
    </UpdateItemsDetailsByColumnResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /InventoryWebService.asmx HTTP/1.1
Host: laluws.compulinerp.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <UpdateItemsDetailsByColumn xmlns="http://tempuri.org/">
      <details>
        <ITEM_MAST>
          <ITEM>string</ITEM>
          <DESC1>string</DESC1>
          <DESC2>string</DESC2>
          <PACK>decimal</PACK>
          <UNIT>string</UNIT>
          <ROL>decimal</ROL>
          <ROQ>decimal</ROQ>
          <MAX_S>decimal</MAX_S>
          <MIN_S>decimal</MIN_S>
          <QIH>decimal</QIH>
          <BF_BAL>decimal</BF_BAL>
          <CF_BAL>decimal</CF_BAL>
          <COST_PRICE>decimal</COST_PRICE>
          <IS_ROUND>boolean</IS_ROUND>
          <IS_CUTTED>boolean</IS_CUTTED>
          <CUT_STAT>int</CUT_STAT>
          <LENGTH>decimal</LENGTH>
          <WIDTH>decimal</WIDTH>
          <ITEM_UNIT1>string</ITEM_UNIT1>
          <ITEM_UNIT2>string</ITEM_UNIT2>
          <ACTUAL_COST>int</ACTUAL_COST>
          <IS_SERVICE_ITEM>int</IS_SERVICE_ITEM>
          <LAST_CHANGE_DATE>dateTime</LAST_CHANGE_DATE>
          <UNIT_1_QTY>decimal</UNIT_1_QTY>
          <UNIT_2_QTY>decimal</UNIT_2_QTY>
          <BACK_UNIT_1_QTY>decimal</BACK_UNIT_1_QTY>
          <BACK_UNIT_2_QTY>decimal</BACK_UNIT_2_QTY>
          <ACTIVE_STAT>int</ACTIVE_STAT>
          <CHANGED>int</CHANGED>
          <UNIT_1_RESERVED_QTY>decimal</UNIT_1_RESERVED_QTY>
          <UNIT_2_RESERVED_QTY>decimal</UNIT_2_RESERVED_QTY>
          <COMPCODE>string</COMPCODE>
          <LOCA_CODE>string</LOCA_CODE>
          <CATCODE>string</CATCODE>
          <CATCODE_L2>string</CATCODE_L2>
          <CATCODE_L3>string</CATCODE_L3>
          <ITEM_UNIT0>string</ITEM_UNIT0>
          <Is_stocks_in_second__unit>int</Is_stocks_in_second__unit>
          <CATCODE_L4>string</CATCODE_L4>
          <SALES_PRICE_BULK>decimal</SALES_PRICE_BULK>
          <SALES_PRICE_LOOSE>decimal</SALES_PRICE_LOOSE>
          <COST_PRICE_BULK>decimal</COST_PRICE_BULK>
          <COST_PRICE_LOOSE>decimal</COST_PRICE_LOOSE>
          <Last_GRN_No>string</Last_GRN_No>
          <UNIT_1_QTY_FREEZED>decimal</UNIT_1_QTY_FREEZED>
          <UNIT_2_QTY_FREEZED>decimal</UNIT_2_QTY_FREEZED>
          <DATE_FREEZED>dateTime</DATE_FREEZED>
          <PHYSICAL_PROCESS_ID>string</PHYSICAL_PROCESS_ID>
          <UNIT_1_QTY_PHY_ENTERED>decimal</UNIT_1_QTY_PHY_ENTERED>
          <UNIT_2_QTY_PHY_ENTERED>decimal</UNIT_2_QTY_PHY_ENTERED>
          <DATE_PHY_ENTERED>dateTime</DATE_PHY_ENTERED>
          <PHY_ENTERED_PROCESS_ID>string</PHY_ENTERED_PROCESS_ID>
          <SALES_PRICE_BULK_BACK>decimal</SALES_PRICE_BULK_BACK>
          <SALES_PRICE_LOOSE_BACK>decimal</SALES_PRICE_LOOSE_BACK>
          <LAST_DOC_NO>string</LAST_DOC_NO>
          <SALES_PRICE_BULK_MIN>decimal</SALES_PRICE_BULK_MIN>
          <SALES_PRICE_LOOSE_MIN>decimal</SALES_PRICE_LOOSE_MIN>
          <ITEM_IMAGE>base64Binary</ITEM_IMAGE>
          <COST_PRICE_BULK_BACK>decimal</COST_PRICE_BULK_BACK>
          <COST_PRICE_LOOSE_BACK>decimal</COST_PRICE_LOOSE_BACK>
          <COST_PRICE_BULK_P1>decimal</COST_PRICE_BULK_P1>
          <COST_PRICE_LOOSE_P1>decimal</COST_PRICE_LOOSE_P1>
          <COST_PRICE_BULK_P2>decimal</COST_PRICE_BULK_P2>
          <COST_PRICE_LOOSE_P2>decimal</COST_PRICE_LOOSE_P2>
          <ITEM_BRAND>string</ITEM_BRAND>
          <ITEM_TYPE>string</ITEM_TYPE>
          <ITEM_MANUFACTURE_ID>string</ITEM_MANUFACTURE_ID>
          <CATCODE_DESCRIPTION>string</CATCODE_DESCRIPTION>
          <LAST_PURCHASE_PRICE>decimal</LAST_PURCHASE_PRICE>
          <IS_SERIAL_AVAILABLE>decimal</IS_SERIAL_AVAILABLE>
          <WARRANTY_STATEMENT>string</WARRANTY_STATEMENT>
          <WARRANTY_PERIOD>decimal</WARRANTY_PERIOD>
          <HIRING_DEPOSIT>decimal</HIRING_DEPOSIT>
          <HIRING_RATE>decimal</HIRING_RATE>
          <UNIT_1_QTY_RESERVED>decimal</UNIT_1_QTY_RESERVED>
          <UNIT_2_QTY_RESERVED>decimal</UNIT_2_QTY_RESERVED>
          <ECOMMERCE_OLD_PRICE>decimal</ECOMMERCE_OLD_PRICE>
          <ECOMMERCE_NEW_PRIZE>decimal</ECOMMERCE_NEW_PRIZE>
          <ECOMMERCE_LONG_DESC>string</ECOMMERCE_LONG_DESC>
          <ECOMMERCE_IMAGE_PATH>string</ECOMMERCE_IMAGE_PATH>
          <ECOMMERCE_GLOBAL_SEQ>int</ECOMMERCE_GLOBAL_SEQ>
          <ECOMMERCE_LOCAL_SEQ>int</ECOMMERCE_LOCAL_SEQ>
          <ECOMMERCE_IS_VISIBLE>int</ECOMMERCE_IS_VISIBLE>
          <ECOMMERCE_QTY_AVAILABLE>decimal</ECOMMERCE_QTY_AVAILABLE>
          <ECOMMERCE_ITEM_SIZE>string</ECOMMERCE_ITEM_SIZE>
          <ECOMMERCE_MAX_QTY_PER_ORDER>decimal</ECOMMERCE_MAX_QTY_PER_ORDER>
          <STOCK_AGE_START_DATE>dateTime</STOCK_AGE_START_DATE>
        </ITEM_MAST>
        <ITEM_MAST>
          <ITEM>string</ITEM>
          <DESC1>string</DESC1>
          <DESC2>string</DESC2>
          <PACK>decimal</PACK>
          <UNIT>string</UNIT>
          <ROL>decimal</ROL>
          <ROQ>decimal</ROQ>
          <MAX_S>decimal</MAX_S>
          <MIN_S>decimal</MIN_S>
          <QIH>decimal</QIH>
          <BF_BAL>decimal</BF_BAL>
          <CF_BAL>decimal</CF_BAL>
          <COST_PRICE>decimal</COST_PRICE>
          <IS_ROUND>boolean</IS_ROUND>
          <IS_CUTTED>boolean</IS_CUTTED>
          <CUT_STAT>int</CUT_STAT>
          <LENGTH>decimal</LENGTH>
          <WIDTH>decimal</WIDTH>
          <ITEM_UNIT1>string</ITEM_UNIT1>
          <ITEM_UNIT2>string</ITEM_UNIT2>
          <ACTUAL_COST>int</ACTUAL_COST>
          <IS_SERVICE_ITEM>int</IS_SERVICE_ITEM>
          <LAST_CHANGE_DATE>dateTime</LAST_CHANGE_DATE>
          <UNIT_1_QTY>decimal</UNIT_1_QTY>
          <UNIT_2_QTY>decimal</UNIT_2_QTY>
          <BACK_UNIT_1_QTY>decimal</BACK_UNIT_1_QTY>
          <BACK_UNIT_2_QTY>decimal</BACK_UNIT_2_QTY>
          <ACTIVE_STAT>int</ACTIVE_STAT>
          <CHANGED>int</CHANGED>
          <UNIT_1_RESERVED_QTY>decimal</UNIT_1_RESERVED_QTY>
          <UNIT_2_RESERVED_QTY>decimal</UNIT_2_RESERVED_QTY>
          <COMPCODE>string</COMPCODE>
          <LOCA_CODE>string</LOCA_CODE>
          <CATCODE>string</CATCODE>
          <CATCODE_L2>string</CATCODE_L2>
          <CATCODE_L3>string</CATCODE_L3>
          <ITEM_UNIT0>string</ITEM_UNIT0>
          <Is_stocks_in_second__unit>int</Is_stocks_in_second__unit>
          <CATCODE_L4>string</CATCODE_L4>
          <SALES_PRICE_BULK>decimal</SALES_PRICE_BULK>
          <SALES_PRICE_LOOSE>decimal</SALES_PRICE_LOOSE>
          <COST_PRICE_BULK>decimal</COST_PRICE_BULK>
          <COST_PRICE_LOOSE>decimal</COST_PRICE_LOOSE>
          <Last_GRN_No>string</Last_GRN_No>
          <UNIT_1_QTY_FREEZED>decimal</UNIT_1_QTY_FREEZED>
          <UNIT_2_QTY_FREEZED>decimal</UNIT_2_QTY_FREEZED>
          <DATE_FREEZED>dateTime</DATE_FREEZED>
          <PHYSICAL_PROCESS_ID>string</PHYSICAL_PROCESS_ID>
          <UNIT_1_QTY_PHY_ENTERED>decimal</UNIT_1_QTY_PHY_ENTERED>
          <UNIT_2_QTY_PHY_ENTERED>decimal</UNIT_2_QTY_PHY_ENTERED>
          <DATE_PHY_ENTERED>dateTime</DATE_PHY_ENTERED>
          <PHY_ENTERED_PROCESS_ID>string</PHY_ENTERED_PROCESS_ID>
          <SALES_PRICE_BULK_BACK>decimal</SALES_PRICE_BULK_BACK>
          <SALES_PRICE_LOOSE_BACK>decimal</SALES_PRICE_LOOSE_BACK>
          <LAST_DOC_NO>string</LAST_DOC_NO>
          <SALES_PRICE_BULK_MIN>decimal</SALES_PRICE_BULK_MIN>
          <SALES_PRICE_LOOSE_MIN>decimal</SALES_PRICE_LOOSE_MIN>
          <ITEM_IMAGE>base64Binary</ITEM_IMAGE>
          <COST_PRICE_BULK_BACK>decimal</COST_PRICE_BULK_BACK>
          <COST_PRICE_LOOSE_BACK>decimal</COST_PRICE_LOOSE_BACK>
          <COST_PRICE_BULK_P1>decimal</COST_PRICE_BULK_P1>
          <COST_PRICE_LOOSE_P1>decimal</COST_PRICE_LOOSE_P1>
          <COST_PRICE_BULK_P2>decimal</COST_PRICE_BULK_P2>
          <COST_PRICE_LOOSE_P2>decimal</COST_PRICE_LOOSE_P2>
          <ITEM_BRAND>string</ITEM_BRAND>
          <ITEM_TYPE>string</ITEM_TYPE>
          <ITEM_MANUFACTURE_ID>string</ITEM_MANUFACTURE_ID>
          <CATCODE_DESCRIPTION>string</CATCODE_DESCRIPTION>
          <LAST_PURCHASE_PRICE>decimal</LAST_PURCHASE_PRICE>
          <IS_SERIAL_AVAILABLE>decimal</IS_SERIAL_AVAILABLE>
          <WARRANTY_STATEMENT>string</WARRANTY_STATEMENT>
          <WARRANTY_PERIOD>decimal</WARRANTY_PERIOD>
          <HIRING_DEPOSIT>decimal</HIRING_DEPOSIT>
          <HIRING_RATE>decimal</HIRING_RATE>
          <UNIT_1_QTY_RESERVED>decimal</UNIT_1_QTY_RESERVED>
          <UNIT_2_QTY_RESERVED>decimal</UNIT_2_QTY_RESERVED>
          <ECOMMERCE_OLD_PRICE>decimal</ECOMMERCE_OLD_PRICE>
          <ECOMMERCE_NEW_PRIZE>decimal</ECOMMERCE_NEW_PRIZE>
          <ECOMMERCE_LONG_DESC>string</ECOMMERCE_LONG_DESC>
          <ECOMMERCE_IMAGE_PATH>string</ECOMMERCE_IMAGE_PATH>
          <ECOMMERCE_GLOBAL_SEQ>int</ECOMMERCE_GLOBAL_SEQ>
          <ECOMMERCE_LOCAL_SEQ>int</ECOMMERCE_LOCAL_SEQ>
          <ECOMMERCE_IS_VISIBLE>int</ECOMMERCE_IS_VISIBLE>
          <ECOMMERCE_QTY_AVAILABLE>decimal</ECOMMERCE_QTY_AVAILABLE>
          <ECOMMERCE_ITEM_SIZE>string</ECOMMERCE_ITEM_SIZE>
          <ECOMMERCE_MAX_QTY_PER_ORDER>decimal</ECOMMERCE_MAX_QTY_PER_ORDER>
          <STOCK_AGE_START_DATE>dateTime</STOCK_AGE_START_DATE>
        </ITEM_MAST>
      </details>
      <option>int</option>
    </UpdateItemsDetailsByColumn>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <UpdateItemsDetailsByColumnResponse xmlns="http://tempuri.org/">
      <UpdateItemsDetailsByColumnResult>boolean</UpdateItemsDetailsByColumnResult>
    </UpdateItemsDetailsByColumnResponse>
  </soap12:Body>
</soap12:Envelope>