• Linkage Functions
  • ACT Function
  • BALDESC Function
  • CLASS Function
  • CLASSDESC Function
  • CURLANG Function
  • CVEXCEL Function
  • DESC Function
  • DMDESC Function
  • DOCNUM Function
  • ENTABBR Function
  • ENTCLP Function
  • ENTDESC Function
  • Entity Function
  • GRP Function
  • GRPDESC Function
  • GRPENT Function
  • ISINGRP Function
  • Linkage Functions
  • LS Function
  • LSDESC Function
  • M3TAX Function
  • MAP Function
  • MAPDESC Function
  • MASK Function
  • NUMTOTDID Function
  • RATE Function
  • RAWENT Function
  • TAX Function
  • TDIDTONUM Function

MAPDESC Function

The MAPDESC function links the description of a map number 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.

Syntax

MAPDESC(map number,<argument>,<language identifier>)

Parameters

Map Number:

The map number you want to display the description of.

Argument (Optional):

Controls the type of description that displays in the cell. If omitted, it returns the name set in the map number properties in Working Papers.

Value	Description
0	Returns the name from the map number properties in Working Papers.
1	Returns the extended description from the map number properties in Working Papers.
2	Returns the extended description from the map number properties in Working Papers. If no extended description exists, returns the map number name.
3	Identical to using 1 (provided for backward compatibility).
4	Identical to using 2 (provided for backward compatibility).

Language Identifier (Optional):

Returns the Name assigned to the specified language Identifier in the Options | Language dialog of Working Papers. If omitted, the current language is used.

Example 1

MAPDESC("100101")

Where 100101 is the map number and "Cash" is the description, the cell displays Cash.

Example 2

MAPDESC("100101",2)

Where 100101 is the map number, "Cash" is the description and "Cash on hand" the extended description, the cell displays "Cash on hand".

Example 3

MAPDESC("100101",2,"FRE")

Where 100101 is the map number, "Comptant" is the description and no extended description exists associated with language "FRE", the cells displays "Comptant".

Related Topics

• Linkage Functions