LEM Reports – Available Fields Reference

Modified on Thu, 5 Nov at 10:09 AM

When you build a report in the Entities module, the first choice is the Content. This guide explains what each Content covers and which fields are available. For step-by-step instructions on building, filtering and exporting reports, see Report Overview.


❓ What is the Content?

The Content is the type of data the report is built on, in other words what each row represents. It decides the default columns and the filters available.


⭐ Choose the right Content

Companies

  • Each row is: one legal entity (managed or non-managed)
  • Covers: Legal identification, capital structure, registered address and management information
  • Key fields: Type, Name, Legal Form, Country, Creation date, Mother company, Capital, Voting rights, Full address

Documents

  • Each row is: one document attached to an entity
  • Covers: Document identification, folder, owner and dates
  • Key fields: Type, Title, Folder, Attached to, Owner, Added on, Updated on

Delegations

  • Each row is: one delegation of authority
  • Covers: Delegation identity (Name, Faculty), parties (Delegatee, Delegator) and lifecycle (Status, Start/End date)
  • Key fields: Name, Faculty, Company, Delegatee, Delegator, Status, Start date, End date, Requirements

Bank Accounts

  • Each row is: one bank account linked to a company
  • Covers: Account identification and bank details
  • Key fields: Name, Account number, Bank name, Type

Shareholding

  • Each row is: one shareholder of a company
  • Covers: Every entity holding shares in a company, with capital and voting breakdowns, share quantities by ownership type (Full ownership, Bare, Usufruct) and share status (Blocked, Lent, Borrowed, Pledged). A shareholder with several types of share appears once, with holdings combined.
  • Key fields: Shareholders, Capital %, Vote %, Number of shares (Full / Bare / Usufruct), Blocked / Lent / Borrowed / Pledged shares

Shareholding Details

  • Each row is: one share type held by one shareholder
  • Covers: The same list as Shareholding, split by share type: a shareholder with three types of share appears on three lines. Can be linked to Shares (Issuing) for share-type data.
  • Key fields: Same as Shareholding, plus links to Shares (Issuing), Companies (Issuing), Scope (Holdings)

Scope (Holdings)

  • Each row is: one entity owned or controlled by the reference company
  • Covers: Starting from a reference company chosen in the report settings, looks downwards through the ownership chain (subsidiaries, sub-subsidiaries, etc.), with consolidated capital interest, shares interest and control (direct and indirect)
  • Key fields: Capital interest (direct / indirect), Shares interest (direct / indirect), Control (bare / usufruct, direct / indirect)

Scope (Shareholding)

  • Each row is: one entity that owns the reference company, directly or indirectly
  • Covers: The mirror of Scope (Holdings): from the same reference company, looks upwards (direct shareholders, then their shareholders) up to the ultimate beneficial owners. Same standard fields as Scope (Holdings)
  • Key fields: Same as Scope (Holdings)

Shares

  • Each row is: one share type created in a company
  • Covers: Share type definition, quantities, valuation and voting rights setup
  • Key fields: Designation, Shares issued, Share value, Capital value, Capital, Voting rights rate

Individuals

  • Each row is: one natural person (director, officer, shareholder…)
  • Covers: Personal identification, contact details and management information. Includes PII / GDPR date filters.
  • Key fields: First/Last name, Birth date, Gender, Email address, Full address, End management date

Instances

  • Each row is: one governance body (board, committee…)
  • Covers: Body identity, issuing company and lifecycle (Status, Creation date, End date)
  • Key fields: Instance, Company, Status, Creation date, End date

Mandates

  • Each row is: one mandate or appointment
  • Covers: Position and type, parties (Company, Instance, Attendee, Representing) and full lifecycle (Status, Nomination date, Expiry, End date, Last renewal)
  • Key fields: Status, Company, Instance, Attendee, Position, Nomination date, Expiry, End date, Type

Representations

  • Each row is: one representation within an instance
  • Covers: Parties (Company, Instance, Attendee, Representative) and lifecycle (Status, Nomination date, End date)
  • Key fields: Status, Company, Instance, Attendee, Representative, Nomination date, End date

✊ Combine two Contents

Turn on Link a content to add columns from a related record to your main rows. The second Contents available depend on the first one:

  • Companies: Documents, Delegations, Bank Accounts, Shares (Issued), Shareholding, Scope (Shareholding), Shareholding Details, Scope (Holdings), Companies (Related branches), Instances (Issued), Mandates (Issued), Representations (Issued), Mandates (Companies), Mandates (Attendee), Owned mandates, Mandates, Representations (Representative), Records
  • Documents: Companies (Related documents), Individuals (Related documents)
  • Delegations: Companies, Individuals (Delegating), Individuals (Delegatees)
  • Bank Accounts: Companies
  • Shareholding: Companies
  • Shareholding Details: Shares (Issuing), Companies (Issuing), Scope (Holdings)
  • Scope (Holdings): Individuals (Reference entity), Companies (Reference entity), Shareholding of holdings, Holdings of companies in scope, Mandates in subsidiaries
  • Scope (Shareholding): Companies
  • Shares: Companies (Issuing), Shareholding Details
  • Individuals: Documents (Related documents), Delegations (Given), Delegations (Received), Scope (Holdings), Mandates (Attendee), Owned mandates, Representations (Representative)
  • Instances: Companies (Issuing)
  • Mandates: Scope (Holdings), Companies (Issuing), Companies (Companies), Companies (Attendee), Individuals (Attendee), Companies (Owned mandates)
  • Representations: Companies (Issuing), Companies (Representative), Individuals (Representative)

By default, only rows with a match in the second Content are shown. Turn on Show unmatched items to also see records with no linked data.

When the second Content is a company or an individual (for example, shareholders, attendees, representatives, holdings), Enhanced Columns let you add their standard and custom fields to the report.


❔ Common questions

What is the difference between Shareholding and Shareholding Details?

Both list a company's shareholders with the same fields. In Shareholding, a shareholder with several types of share appears on one line. In Shareholding Details, they appear on one line per type of share. Use Shareholding for an overview, and Shareholding Details for the breakdown by share category.

What is the difference between Scope (Holdings) and Scope (Shareholding)?

Both start from a reference company chosen in the report settings, with the same fields. Scope (Holdings) looks downwards: the entities the reference company owns or controls. Scope (Shareholding) looks upwards: the entities that own the reference company, up to the ultimate beneficial owners.

What is the "Reference entity" field in Scope reports?

It is the starting point of the Scope report. Use it to focus on specific holdings, parent companies or branches.

How are ownership interest and control calculated?

Ownership interest is the sum of all direct and indirect ownership paths. Control only follows links above the 50% voting-rights threshold: below it, the chain breaks and the holdings further down are excluded. See How Is Ownership Calculated in LEM?

Why do two users see different data in the same report?

Report data depends on each user's role, access rights and perimeters.

Can reports show historical data?

Yes. When you create a report, choose current or historical data. Pick a date for past information, or leave it empty for today's data.


◻ Standard fields by Content

Besides standard fields, you can add custom fields set up by your administrator, and Enhanced Columns with fields from linked records. See Create and Manage Custom Fields.

  • Companies: Type, Name, Internal Name, Legal Form, Creation date, End management date, Country, Mother company, Currency, Added on, Last updated, Company representatives, Perimeters, Capital Shares, Capital, Voting rights, Simplified Capital management, Percentage capital, Automatic numbering of accounts and movements of shares, Shares numbering, Type of ownership management, Full address (Country, Address, City, Province, Postal code)
  • Documents: Type, DiliTrust ID, Title, Folder, Attached to, Owner, Added on, Updated on
  • Delegations: DiliTrust ID, Name, Faculty, Description, Company, Delegatee, Delegator, Status, Start date, End date, Added on, Last updated, Requirements
  • Bank Accounts: Name, Account number, Bank name, Type, Added on, Last updated
  • Shareholding & Shareholding Details: Shareholder type, Company, Shareholders, Capital %, Capital % per share type, Vote %, Votes % per share type, Number of shares (Full ownership / Bare ownership / Usufruct), Capital (Shares Qty), Capital (Shares Qty) %, Capital, Votes (bare), Votes (bare) %, Votes (usufruct), Votes (usufruct) %, Blocked shares (Full / Bare / Usufruct), Lent shares (Full / Bare / Usufruct), Borrowed shares (Full / Bare / Usufruct), Pledged shares (Full / Bare / Usufruct)
  • Scope (Holdings) & Scope (Shareholding): Shareholder type, Company, Shareholders, Capital interest, Interest (capital) direct / indirect, Shares interest, Interest (shares) direct / indirect, Control (bare), Control (bare) direct / indirect, Control direct / indirect, Control (usufruct), Control (usufruct) direct / indirect
  • Shares: DiliTrust ID, Company, Designation, Shares issued, Share value, Capital value, Capital, Voting rights rate, Votes, Capital shares, Included in global calculations
  • Individuals: DiliTrust ID, First name, Last name, Birth date, Gender, End management date, Email address, Added on, Last updated, Perimeter, Full address (Country, Address, City, Province, Postal code)
  • Instances: DiliTrust ID, Status, Company, Instance, Creation date, End date, Added on, Last updated
  • Mandates: DiliTrust ID, Status, Company, Instance, Attendee, Position, Nomination date, Expiry, End date, Added on, Last updated, Last renewal, Type, Representing
  • Representations: DiliTrust ID, Status, Company, Instance, Attendee, Representative, Nomination date, End date, Added on, Last updated
  • Records (Second Content of Companies only): Title, Added on, Last updated

See also: Report Overview | How Is Ownership Calculated in LEM? | Entities – PII Reports & GDPR Compliance Tools

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article