(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)))
|