The rule in plain words
Double, trailing or leading whitespaces are not allowed
This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
List of items on own funds: subordinated MMA (S.23.04.01.01)
Columns
- C0010Description of subordinated mutual members' accounts
- C0020Amount
- C0030Tier
- C0040Currency Code
- C0070Counted under transitionals?
- C0080Counterparty (if specific)
- C0090Issue date
- C0100Maturity date
- C0110First call date
- C0120Details of further call dates
- C0130Details of incentives to redeem
- C0140Notice period
- C0160Buy back during the year
List of items on own funds: subordinated MMA (S.23.04.04.01)
Columns
- C0010Description of subordinated mutual member accounts
- C0020Amount
- C0030Tier
- C0040Currency Code
- C0050Issuing entity
- C0060Lender (if specific)
- C0070Counted under transitionals?
- C0080Counterparty (if specific)
- C0090Issue date
- C0100Maturity date
- C0110First call date
- C0120Details of further call dates
- C0130Details of incentives to redeem
- C0140Notice period
- C0150Name of supervisory authority having given authorisation
- C0160Buy back during the year
- C0170% of the issue held by entities in the group
- C0180Contribution to group subordinated mutual member accounts
Which returns it applies to
Line4 Check runs it on quarterly solo (QRS), quarterly group (QRG), quarterly branch (QRB), annual solo (ARS), annual group (ARG), annual branch (ARB), financial stability solo (QFS), financial stability group (QFG) and financial stability branch (QFB) returns on EIOPA taxonomy 2.10.0. EIOPA applies it to quarterly ECB branch (QEB), quarterly ECB solo (QES), annual branch (ARB), annual solo (ARS), financial stability group (QFG), quarterly group (QRG), financial stability solo (QFS), financial stability branch (QFB), quarterly branch (QRB), quarterly solo (QRS), annual ECB solo (AES), annual ECB branch (AEB) and annual group (ARG) returns, as a blocking check.
EIOPA’s own words and formula
The plain words above are EIOPA’s own, word for word, from its list of validations.
Show the formulaShowHide
EIOPA's formula. Cells are written as {t: table, r: row, c: column}.
not(matches(dim({d: [s2c_dim:YG]},[s2c_dim:YG]), "((^\s)|(\s\s)|(\s$))+"))Other rules on List of items on own funds (S.23.04)
- List of items on own funds: double, trailing or leading whitespaces are not allowed (TV21)Blocking
- List of items on own funds: double, trailing or leading whitespaces are not allowed (TV22)Blocking
- List of items on own funds: double, trailing or leading whitespaces are not allowed (TV23)Blocking
- List of items on own funds: double, trailing or leading whitespaces are not allowed (TV24)Blocking
- List of items on own funds: double, trailing or leading whitespaces are not allowed (TV25)Blocking
- List of items on own funds: double, trailing or leading whitespaces are not allowed (TV13)Blocking
- List of items on own funds: a total must equal the sum of its parts (BV1771)
Every Solvency II rule on S.23.04
Checks like this one, run at the point of submission, are the first step to real-time supervision. Line4 builds SupTech software for financial regulators that runs checks like these as each return arrives.
