The rule in plain words
Transportation and storage must equal these five added up:
- H.49 - land transport and transport via pipelines
- H.50 - Water transport
- H.51 - air transport
- H.52 - Warehousing and support activities for transportation
- H.53 - Postal and courier activities
All the values are in the average weighted maturity column (0160) of D 01.00.
EBA writes it out 15 times. These words are for the first; the others are the same rule on other cells.
The template it checks
Rows
- 0450H - Transportation and storage
- 0460H.49 - Land transport and transport via pipelines
- 0470H.50 - Water transport
- 0480H.51 - Air transport
- 0490H.52 - Warehousing and support activities for transportation
- 0500H.53 - Postal and courier activities
Column
- 0160Average weighted maturity
Show the rule as writtenShowHide
EBA's formula, as written out for the first of its checks. Cells are written as {template, row, column, sheet}.
{D_01.00,r0450,c0160,} = {D_01.00,r0460,c0160,} + {D_01.00,r0470,c0160,} + {D_01.00,r0480,c0160,} + {D_01.00,r0490,c0160,} + {D_01.00,r0500,c0160,}And 14 more, the same formula for the other cells it covers.
Other rules on D 01.00
- Gross carrying amount (Mln EUR) cannot be less than non-performing exposures (v89453_m)Warning
- Gross carrying amount (Mln EUR) cannot be less than stage 2 exposures (v89452_m)Warning
- C - Manufacturing: gross carrying amount (Mln EUR) cannot be less than environmentally sustainable (CCM) (v89451_m)Warning
- Gross carrying amount (Mln EUR) cannot be less than exposures towards companies excluded from EU Paris-aligned Benchmarks in accordance with Article 12(1) points (d) to (g) and Artic (v89450_m)Warning
- Transportation and storage must equal the sum of its five parts (row 0450, v89444_m)Warning
- Construction must equal the sum of its three parts (row 0400, v89443_m)Warning
- Manufacturing must equal the sum of its 24 parts (v89442_m)Warning
- Mining and quarrying must equal the sum of its five parts (row 0030, v89441_m)Warning
Checks like this one, run at the point of submission, are the first step to real-time supervision.
