Base View idvClientMainSICCodeLink

Description

This view represents the links between business clients and their main (singleton) SIC codes.

The view is phrased to cope with inadvertent duplicate relationships on the database, and behave in the same way as the IRIS application would. In particular it is guaranteed to return a single result for each primary object.

 

For use by

Base view suitable for advanced end users.

 

Columns

ClientObjectType

Type of client object

ClientInternalId

Internal identifier of client object

SICCodeInternalId

Internal identifier of the SIC Code

 

  •