• Linkage Functions
  • Linkage Functions
  • ACT function
  • CLASS function
  • CVEXCEL function
  • DESC function
  • DMDESC function
  • DOCNUM function
  • ENTABBR function
  • ENTCLP function
  • ENTDESC function
  • ENTITY function
  • GRP function
  • GRPDESC function
  • GRPENT function
  • LS function
  • LSDESC function
  • M3TAX function
  • MAP function
  • MAPDESC function
  • MASK function
  • PERTOJ function
  • RATE function
  • RAWENT function
  • TAX function

ENTDESC Function

The ENTDESC function returns the description entered in Working Papers for the specified entity in a consolidation.

It is possible to use the extended description for the specified entity. This is useful since entries in the name field are limited to 50 characters but a company or subsidiary may have a legal name longer than 50 characters that must be displayed in full on its statements.

Syntax

ENTDESC(abbreviation,<argument>,<language identifier>)

Where

The abbreviation represents the ID code for the entity entered in the Entity Properties dialog of the consolidated file.

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

Value	Description
0	Returns the entity name.
1	Returns the Extended Description from the Entity Properties dialog.
2	Returns the Extended Description from the Entity Properties dialog. If no Extended Description is present, the entity name will appear in the cell.
3	Returns the Extended Description from the Entity Properties dialog.
4	Returns the Extended Description from the Entity Properties dialog. If no Extended Description is present, the entity name will appear in the cell.

If no argument is provided, CaseView enters the short description (entity name) for the item being linked.

Example 1

ENTDESC("SCO2")

Where SCO2 is the abbreviation for Sub Company 2. The result is that Sub Company 2 will be entered as a string in the cell.

Example 2

ENTDESC("SCO2","2")

Using Example 1, the extended description Sub Company 2, a limited subsidiary of Consolidated Corporation of Canada will be entered as a string in the cell. If there is no extended description, the short description will be entered.

Example 3

ENTDESC("") or ENTDESC()

Gives the description of the active entity for the current CaseView document using the calculation.

Example 4

ENTDESC("SCO2","0","FRE")

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

Each language will have an applicable Identifier which can be used to draw account names and extended descriptions into CaseView. This example would link to the French version of the Entity Name for abbreviation SCO2.

Related Topics

• Linkage Functions