Business rule address omc0036 NUTS 3 region mandatory

Card of business rule address omc0036 NUTS 3 region mandatory

Name

address omc0036 NUTS 3 region mandatory

Code

omc0036

Comment

NUTS 3 region of the address is mandatory when the foreign counterparty is in a reporting member state.

ECB Validation identifier: CY0090

Rule Type

Constraint


Server expression of the business rule address omc0036 NUTS 3 region mandatory

(if (('address'.'reporting agent identifier' = 'foreign counterparty'.'reporting agent identifier') and
('address'.'street' = 'foreign counterparty'.'address street') and
('address'.'city / town / village' = 'foreign counterparty'.'address city / town / village') and
('address'.'postal code' = 'foreign counterparty'.'postal code') and
('address'.'country' = 'foreign counterparty'.'country') and
('foreign counterparty'.'reporting reference date' = 'counterparty'.'reporting reference date) and
('foreign counterparty'.'reporting agent identifier' = 'counterparty'.'reporting agent identifier') and
('foreign counterparty'.'counterparty identifier' = 'counterparty'.'counterparty identifier') and
((('counterparty'.'reporting reference date' = 'part of legal entity'.'reporting reference date) and
('counterparty'.'reporting agent identifier' = 'part of legal entity'.'reporting agent identifier') and
('counterparty'.'counterparty identifier' = 'part of legal entity'.'counterparty identifier') and
('part of legal entity'.'reporting reference date' = 'foreign branch in reporting member state'.'reporting reference date) and
('part of legal entity'.'reporting agent identifier' = 'foreign branch in reporting member state'.'reporting agent identifier') and
('part of legal entity'.'counterparty identifier' = 'foreign branch in reporting member state'.'counterparty identifier'))
or
(('counterparty'.'reporting reference date' = 'legal entity'.'reporting reference date) and
('counterparty'.'reporting agent identifier' = 'legal entity'.'reporting agent identifier') and
('counterparty'.'counterparty identifier' = 'legal entity'.'counterparty identifier') and
('legal entity'.'reporting reference date' = 'foreign legal entity'.'reporting reference date) and
('legal entity'.'reporting agent identifier' = 'foreign legal entity'.'reporting agent identifier') and
('legal entity'.'counterparty identifier' = 'foreign legal entity'.'counterparty identifier'))))
then (('address'.'NUTS 3 region' <> null)))


List of DNB-specific attributes of the business rule address omc0036 NUTS 3 region mandatory

Name

Value

business rule classification

other model constraint

business rule scope

Checked within the data delivery

severity

blocking


List of attached objects of the business rule address omc0036 NUTS 3 region mandatory

Short Description

Entity Attribute 'address.NUTS 3 region'