Update Column Data

Description

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

Support

This method can only support for project or 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 and Shell Level

Yes

Program Level

No

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 or shell in Unifier.

columnName

Identifier of the cost sheet column in Unifier. 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 or 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 then "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 then "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 or 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 description

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 both Project (Standard) and Shells of cost code type CBS.

Related Topics

Cost Sheet Methods

Get Column Data



Legal Notices | Your Privacy Rights
Copyright © 1998, 2022

Last Published Tuesday, February 8, 2022