You are here: All Help Topics > Other Information > Cell Functions > MAPDESC function

MAPDESC Function

The MAPDESC function links a map number description from the accounting database in Working Papers or Time. To link a map number description automatically, create a new alphanumeric cell (the description being linked is alphanumeric) and enter the calculation.

MAPDESC("Map Number",<Argument>,<language identifier>)

The Argument is optional and controls the type of description that appears in the cell.

Value Description

0

Returns the map number description from the map number properties in Working Papers/Time.

1

Returns the Extended Description from the map number properties in Working Papers/Time.

2

Returns the Extended Description from the map number properties in Working Papers/Time. If no Extended Description is present, the map number description will appear in the cell.

3

Returns the Extended Description from the map number properties in Working Papers/Time.

4

Returns the Extended Description from the map number properties in Working Papers/Time. If no Extended Description is present, the map number description will appear in the cell.

If you do not provide an argument, CaseView returns the map number name as show in the Engagement | Mapping screen.

MAPDESC("100101")

Where 100101 is the map number with a description of Cash. Therefore, the cell displays Cash.

MAPDESC("100101","2")

Where 100101 is the map number with a description of Cash and possibly an extended description. Therefore, the cell displays the extended description, if any, otherwise displays Cash.

MAPDESC("100101","0","FRE")

In Working Papers, under Tools | Options | Language, it is possible to specify multiple global languages. Please refer to the Working Papers helpWorking Papers help for more information on multiple language support.

Each language will have an applicable Identifier which can be used to draw map number names and extended descriptions into CaseView. This example would link to the French version of map number 100101's name.

  • Line breaks in the extended description are preserved when linking in CaseView.

Related Topics