Documentation
Guidance on the usage of REMIT Relax.
UTI Handling
The UTI is generated according to the ACER algorithm published in the Transaction Reporting User Manual (TRUM), after which some extra validation rules apply. You can ignore these rules if you create your own UTI and do not use REMIT Relax to generate one.
Please make sure all fields are formatted as “Text”—otherwise formatting errors with date and number fields (especially decimal separators) are very likely to occur.
You have the option to write generated UTIs and Contract IDs back into the Excel sheet by ticking “Write generated UTIs back into input Excel?”.
Reporting On Behalf of Others (ROBO): The UTI algorithm contains a running number at the end that counts up when the same trade is entered twice—which happens when you enter the trade both for yourself and for your counterparty. The result would be that the UTIs do not match, since the first ends with 001 and the second with 002. If you want to use REMIT Relax for ROBO and want it to create the UTI for you, it is therefore important to copy the generated UTI into the counterparty's trade as well.
On the History screen, where the latest generated files are shown, you can click the Info button at the end of a row to also retrieve the UTI base string that was used to generate the UTI.
Validation Rules for UTI (T1) Generation
The same rules apply for the UTI generation for Executions (T1).
| Excel Column | ACER Table 1 Data | ACER Field No. | Remarks |
|---|---|---|---|
| B | ID of Market Participant | 1 | Mandatory; must be an ACER code ([A-Za-z0-9_]+\.[A-Z][A-Z]) with a length of 12. |
| D | ID of Other MP | 4 | Mandatory; must be an ACER code ([A-Za-z0-9_]+\.[A-Z][A-Z]) with a length of 12. |
| K | Contract Type | 23 | Mandatory; must be one of: FW, OP, OP_FW, OP_SW, SP, SW, OT. |
| L | Energy Commodity | 24 | Mandatory; must be one of: EL, NG. |
| N | Settlement Method | 26 | Mandatory; must be one of: P, C, O. |
| T | Trade Date | 30 | Mandatory; must be in YYYY-MM-DD format. The algorithm takes the first 10 characters of the transaction timestamp. |
| V | Price | 35 | Optional; must be a valid decimal number, up to 20 digits total, with a dot (.) as the decimal mark and 5 decimal places (fill with zeros if necessary). |
| W | Currency | 37 | Optional; must be one of: BGN, CHF, CZK, DKK, EUR, GBP, HRK, HUF, ISK, NOK, PCT, PLN, RON, SEK, USD, OTH. |
| Z | Quantity Volume | 4 | Optional; must be a valid decimal number, up to 20 digits total, with a dot (.) as the decimal mark and 5 decimal places (fill with zeros if necessary). |
| AA | Quantity Unit | 42 | Optional; must be one of: KWh/h, KWh/d, MWh/h, MWh/d, GWh/h, GWh/d, Therm/d, KTherm/d, MTherm/d, cm/d, mcm/d, Btu/d, MMBtu/d, MJ/d, 100MJ/d, MMJ/d, GJ/d. Do not simply use MW—always use MWh/h. |
| O | Delivery Point or Zone | 48 | Mandatory; must match [0-9][0-9][XYZTWV].+ with a length of 16. For T2: must be a single value—multiple values are not allowed. |
| P | Delivery Start Date | 49 | Mandatory; must be in YYYY-MM-DD format. |
| Q | Delivery End Date | 50 | Mandatory; must be in YYYY-MM-DD format. |
Validation Rules for Contract ID (T2) Generation
| Excel Column | ACER Table 2 Data | ACER Field No. | Remarks |
|---|---|---|---|
| B | ID of Market Participant | 1 | Mandatory; must be an ACER code ([A-Za-z0-9_]+\.[A-Z][A-Z]) with a length of 12. |
| C | ID of Other MP | 3 | Mandatory; must be an ACER code ([A-Za-z0-9_]+\.[A-Z][A-Z]) with a length of 12. Must be a single value—multiple values are not allowed. |
| J | Contract Type | 13 | Mandatory; must be one of: FW, OP, OP_FW, OP_SW, SP, SW, OT. |
| K | Energy Commodity | 14 | Mandatory; must be one of: EL, NG. |
| V | Settlement Method | 31 | Mandatory; must be one of: P, C, O. |
| I | Trade Date | 12 | Mandatory; must be in YYYY-MM-DD format. |
| L | Price | 15 | Optional; must be a valid decimal number, up to 20 digits total, with a dot (.) as the decimal mark and 5 decimal places (fill with zeros if necessary). |
| M | Currency | 15 | Mandatory if Price is given; must be one of: BGN, CHF, CZK, DKK, EUR, GBP, HRK, HUF, ISK, NOK, PCT, PLN, RON, SEK, USD, OTH. |
| Q | Quantity Volume | 18 | Optional; must be a valid decimal number, up to 20 digits total, with a dot (.) as the decimal mark and 5 decimal places (fill with zeros if necessary). |
| R | Quantity Unit | 18 | Mandatory if Quantity Volume is given; must be one of: KWh/h, KWh/d, MWh/h, MWh/d, GWh/h, GWh/d, Therm/d, KTherm/d, MTherm/d, cm/d, mcm/d, Btu/d, MMBtu/d, MJ/d, 100MJ/d, MMJ/d, GJ/d. Do not simply use MW—always use MWh/h. |
| W | Delivery Point or Zone | 41 | Mandatory; must match [0-9][0-9][XYZTWV].+ with a length of 16. Must be a single value—multiple values are not allowed. |
| X | Delivery Start Date | 42 | Mandatory; must be in YYYY-MM-DD format. |
| Y | Delivery End Date | 43 | Mandatory; must be in YYYY-MM-DD format. |