NIPO Fieldwork System Version 1.14
			
FieldInfo
This table contains field information used within NIPO FMS and is used for system purposes only. 
FieldInfo table 
|  
 | 
Fieldname
 | 
Description / Default value
 | 
Type
 | 
Length
 | 
NOT NULL
 | 
 
  
 | 
Description 
 | 
  
 | 
nvarchar 
 | 
50 
 | 
NULL 
 | 
 
  
 | 
FieldName 
 | 
  
 | 
nvarchar 
 | 
50 
 | 
NOT NULL 
 | 
 
  
 | 
FieldType 
 | 
  
 | 
tinyint 
 | 
  
 | 
  
 | 
 
  
 | 
MemoAsRTF 
 | 
  
 | 
tinyint 
 | 
  
 | 
  
 | 
 
  
 | 
TableConst 
 | 
  
 | 
nvarchar 
 | 
50 
 | 
NOT NULL 
 | 
 
  
 | 
UsedForAssignments 
 | 
  
 | 
tinyint 
 | 
  
 | 
  
 | 
 
  
 | 
  
 | 
  
 | 
  
 | 
  
 | 
  
 | 
 
 
		 |