Table Name:N_AttributeValue
Table Number:5469
Group:Flexible Attribute
Description:Contains an instance of a flexible attribute
Flags:CACHEOBJIDS 
Baseline/Custom:Baseline
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
N_ConfigValueLONGint   DIRECT, ALLOW_NULL Set to 1 if the attribute was instantiated by the Configurator  
N_DateValueCLK_TIMEdatetime    If a datetime or dateonly attribute, the datetime or dateonly value  
N_DecimalValueDECIMALdecimal (19,4)    If a decimal attribute, the decimal value  
N_FocusLowidLONGint   DIRECT Focus objid of owning object instance  
N_FocusTypeLONGint   DIRECT The schema type_id of the instance of the attribute; e.g., case=0, subcase=24. etc  
N_LongValueLONGint   DIRECT If a long attribute, the long value  
N_ModificationDateCLK_TIMEdatetime46  ALLOW_NULL Date and time when the information was last modified  
N_NameCHARvarchar 50  Name of the attribute - copied from N_Attribute  
N_RequiredLONGint   DIRECT, ALLOW_NULL 1 = Required field  
N_StatusLONGint   DIRECT The status of the value for Process Manager. 0 = OK, 1 = Request(s) pending for dependent field, 2 = Requests pending for activation  
N_StringValueCHARvarchar 255  If a string attribute, the string value  
N_TargetFieldCHARvarchar 30 ALLOW_NULL This field holds the name of a field used to display data from the related target record  
N_TargetLowidLONGint   DIRECT If a relation type the objid of the related object  
N_TargetTypeLONGint   DIRECT If a relation type, the schema type_id the target object of the relation; e.g., case=0, subcase=24. etc  
N_TypeLONGint   DIRECT See N_Type on N_Attribute  
objidLONGint3  DIRECT Internal record number  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
value2N_PropertiesMTON_Propertiesvalue2N_AttributeValueN_Properties that defines the attribute instance    
value2rqst_pendingOTMrqst_pendingpending2N_AttributeValueRequests that are pendinf this attribute    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5469N_FocusType:N_FocusLowid:N_NameUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
I5469N_FocusType, N_FocusLowid, N_Namenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
v2np5469value2N_Propertiesnonclustered located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
N_AttributeValue