Taxonomy Mapping Mode
After you select the main data object for your interface and click Create, you see the EBS Worksheet. You can use Taxonomy mapping mode there. In Taxonomy mapping mode, the main Data Object you chose is at the left and the Taxonomy is at the right.
To map a field from the main Data Object to the Taxonomy, use a drag-and-drop operation to drag a field from the main Data Object and drop it to a Taxonomy field. See the following figure.
You can change the Name of output fields by clicking the name you want to change and typing a new name.
Calculated Field Examples
It is possible to create calculated fields by using classic Message Center expression syntax. Here are some examples in the following table.
| Expression | Meaning |
|---|---|
| |ENTITY_ID| + '_' + |ENTITY_NAME| | Concatenating entity id with entity name |
| iif( stringlength(|POST_DATE|) = 0, |EFFECTIVE_DATE|, |POST_DATE| ) | Conditional assignment: if post date is empty, use effective date instead |
| convert( currenttime(), ''hh:mm:ss ) | Current time in custom format |
| convert( today() - 1, 'mm/dd/yyyy' ) | Yesterday's date in custom format |
0 Comments