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.