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>)

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.

Notes

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

Related Topics