V_INSTALLED_MAPENTITYCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| DESCRIPTION | nvarchar(max) | ||
| FROMRECORDTYPEID | uniqueidentifier | ||
| MAPPEDRECORDTYPEID | uniqueidentifier | ||
| ADDRESSRECORDTYPEID | uniqueidentifier | yes | |
| RETURNSMULTIPLE | bit | ||
| IDISSELECTIONID | bit | ||
| MAPPINGPROCEDURE | nvarchar(255) | ||
| SEARCHLISTID | uniqueidentifier | ||
| ADDDATAFORMINSTANCEID | uniqueidentifier | yes | |
| IMAGEKEY | nvarchar(512) | ||
| MAPENTITYXML | xml | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| SPECUINAME | nvarchar(100) | ||
| UINAME | nvarchar(100) |
Definition
Copy
CREATE view dbo.V_INSTALLED_MAPENTITYCATALOG as
select
MAPENTITYCATALOG.ID,
MAPENTITYCATALOG.NAME,
MAPENTITYCATALOG.DESCRIPTION,
MAPENTITYCATALOG.FROMRECORDTYPEID,
MAPENTITYCATALOG.MAPPEDRECORDTYPEID,
MAPENTITYCATALOG.ADDRESSRECORDTYPEID,
MAPENTITYCATALOG.RETURNSMULTIPLE,
MAPENTITYCATALOG.IDISSELECTIONID,
MAPENTITYCATALOG.MAPPINGPROCEDURE,
MAPENTITYCATALOG.SEARCHLISTID,
MAPENTITYCATALOG.ADDDATAFORMINSTANCEID,
MAPENTITYCATALOG.IMAGEKEY,
MAPENTITYCATALOG.MAPENTITYXML,
MAPENTITYCATALOG.SECURITYUIFOLDER,
MAPENTITYCATALOG.ADDEDBYID,
MAPENTITYCATALOG.CHANGEDBYID,
MAPENTITYCATALOG.DATEADDED,
MAPENTITYCATALOG.DATECHANGED,
MAPENTITYCATALOG.TS,
MAPENTITYCATALOG.TSLONG,
MAPENTITYCATALOG.SPECUINAME,
MAPENTITYCATALOG.UINAME
from
dbo.MAPENTITYCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = MAPENTITYCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 33
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1