Advanced Mapping Definition for Vendor Labor Subtask

Use this subtask to create more options for defining the key fields that map vendor labor from Cobra to Costpoint.

Advanced Mapping Definition

Use the fields in this block to specify advanced mapping definitions for employee labor accounts.

Field Description
For

This field always displays Employee Labor.

Prefix/Literal

Enter the text you want added to the beginning of the fields concatenated below. If no fields are expressed, then this effectively becomes the BE that is assigned to all records that fit the rule.

Use Part of the Above Result

Select this check box to choose a substring from the result of the advanced mapping definitions. Enter the substrings in the Starting From Position and Ending Position fields.

Starting From Position

Enter a starting point for a substring of the result.

Ending Position

Enter an ending point for the substring within the result.

Length of Final Result

This field displays the possible total length of the result. If you did not select the Use Part of the Above Result check box, you can modify this field. The data values are truncated at this length.

Advanced Mapping Definition Details

Use this table window to set more detailed specifications.

Field Description
Order Number

This field displays the order in which the row's information is placed into the result.

Field

Enter, or click binoculars.gif to select, a field.

Description

This field displays the descriptive name for the selected Field.

Table

This field displays the table related to the selected Field.

Starting Character Position

Enter the starting point for use when selecting a potential subset of the selected field's data.

Ending Character Position

Enter the ending point for use when selecting a potential subset of the selected field's data.

Characters Added to the End

Enter characters that are added to the end of the field. The primary use for this field is to be a one character delimiter between the field data values.

Subtask

Subtask Description
Result Test Click this link to open the Result Test subtask and view sample data that satisfy the specified criteria in the Advanced Mapping Definition Details table window.