Update Column Data

Description

This method updates data of a project/shell (cost code type CBS) cost sheet column. This method replaces entire data.

Support

This method can only support for project/shell level cost sheet column that is defined as Manual Entry Method. This column does not support Assigned Budget column. This method does not support incremental or delta changes to a column.

Installation: ASP and Self host

Level	Yes or No
Company Level	No
Project/Shell Level	Yes

Prototype

public XMLObject updateColumnData(String shortname, String authcode, string projectNumber, String ColumnName, String DataXML);

Parameters

Parameter	Description
shortname	identifier of the company, company's short name
authcode	authentication key for the company, in text string
projectNumber	Identifier of the project/shell.
columnName	Identifier of the cost sheet column. This is case-sensitive and should be the name of Column that is defined in Unifier.
columnXML	identifier for Column content in XML format

Return Value

DataXML Elements

The elements that include as part of DataXML parameter are:

Tag Name	Description
<CBS_code>	CBS Code is a required field.
<short_description>	This is a required field.
<long_description>	This is an optional field
<work_package>	This is an optional field. But use should specify a work package name which is valid under a project/shell. Data entered under this element will be ignored for company-level cost column
<spends_category>	This is an optional field. Data sent through this data element should be validated against the data set values
<quantity>	This is an optional field. Data sent through this data element should be numeric. Any other data will be considered as illegal and error should be returned back to user. If user did not send a value for this, "0" will be assumed as value.
<unit_of_measure>	This is an optional field. Data sent through this data element should be validated against the data set values
<unit_cost>	This is an optional field. Data sent through this data element should be numeric. Any other data will be considered as illegal. If user did not send a value for this, "0" will be assumed as value.
<amount>	This is an optional field. User cannot enter any value for this element. Value of this data element should be automatically calculated as (Quantity * Unit Cost)

Project/Shell à Administrator will be used as user who is performing this integration. Audit log will track and trace all changes done through this web services method.

Sample Method

updateColumnData("acme", "acme_authcode", "project_info","my column name", "DataXML")

Additional Information

Following are the failure reasons and descriptions:

Reason	Description
Column is not valid	Invalid Column Name
Column is not manual	Column is not defined as manual entry
Administrator is inactivated	Administrator is inactive. Cannot create column data.

This service can be used for projects/shells of cost code type CBS.