Siebel Order Management Infrastructure Guide > Data Transfer Utilities Business Service > About Data Transfer Utilities >

Calculation Expressions in DTU

When Data Map Field Source or Destination Type is Expression, the Source or Destination Fields are calculation expressions that follow Siebel Query Language syntax. See Siebel Personalization Administration Guide for more information about Siebel Query Language.

DTU contains two extensions to Siebel Query Language: curly bracket pair {field}, and named parameter.

Curly Bracket Pair {field}

Use this syntax to refer to a buscomp field at the other business component side. For example, if you define the following expression as the source:

{ContactId}

[ContactId] would be evaluated at the destination bsucomp. When {} is involved, please note that {} takes the highest precedence over other operator. Thus, if you have an expression like:

'{Last Name}' + 'Test'

{Last Name} has precedence over quotes "". If the person's last name is Agee, {Last Name} is evaluated to be "Agee". As a result, the final value is:

"Agee" Test

instead of

{Last Name} Test

Named Parameter

A calculation expression can contain named parameters, using the syntax of [&Parameter]. It is important to pre-fix the ampersand to indicate a named parameter. For example,

"Sadmin's opportunity #" + [&OpptyId]

For more information about named parameters, see Using Named Parameters in DTU.