Table Name:N_Attribute
Table Number:5468
Group:Flexible Attribute
Description:Defines a flexible attribute
Flags: 
Baseline/Custom:Baseline
select * from table_N_Attribute
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
N_DefaultValueCHARvarchar 255 ALLOW_NULL Default value for attribute  
N_DescriptionCHARvarchar 255  Description of the attribute  
N_EffectiveDateCLK_TIMEdatetime   ALLOW_NULL The first date on which the information should be used  
N_ExpirationDateCLK_TIMEdatetime   ALLOW_NULL Last date when the information should be used  
N_ModificationDateCLK_TIMEdatetime46  ALLOW_NULL Date and time when the information was last modified  
N_NameCHARvarchar 50  Name of the attribute  
N_RequiredLONGint   DIRECT, ALLOW_NULL 1 = Required field  
N_TargetFieldCHARvarchar 30 ALLOW_NULL This field holds the name of a field used to display data from the related target record  
N_TargetObjectCHARvarchar 64  For relation types, the schema type_id target object of the relation; e.g., case=0, subcase=24. etc  
N_TypeLONGint   DIRECT Data type: 0=Relation, 3=Long, 4=float, 6=Decimal, 7=Datetime, 8=String, Boolean=11, 17=Dateonly  
N_ValidRangeCHARvarchar 255 ALLOW_NULL Valid Range of values for numeric attribute, name of user-defined popup list for string  
objidLONGint3  DIRECT Internal record number  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
attr2N_PropertiesOTMN_Propertiesn_propts2N_AttributeN_Properties which define the attribute    
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
I5468N_NameUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
I5468N_Namenonclustered, unique located on PRIMARY
objindexobjidclustered, unique located on PRIMARY
Referenced in Views:
View IDView NameTables
My Recent Objects
N_Attribute      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user