2.1 NC_ADF Table

The NC_ADF Table contains reference data about administrator-defined fields.

Column

Key

Type

Null

Description

ADFOID

PK

numeric(19,0) identity

No

Internal ID number used as a primary key.

TableName

nvarchar(32)

No

Table to which the ADF is associated.

InternalName

nvarchar(8)

No

Database column name, this is the internal representation.

Label

nvarchar(32)

No

Displayed field label

DataType

smallint

 

Data type used when querying. Possible data types include:

0 Character

1 Integer

2 Decimal

3 Date

InUse

tinyint

No

True(1) indicates if the field is already in use.

DefaultValue

nvarchar(255)

Default value.

IsDisplay

 

smallint

 

True(1) displays the field, FALSE to hide it.

IsEditable

 

smallint

 

True(1) indicates if field is editable, FALSE if ReadOnly.

ControlType

 

smallint

 

Edit, mask, list, combo, check, button, etc.

EditMask

 

nvarchar(64)

 

Data entry editing mask.

AutoFill

 

smallint

 

Indicates when to fill in a field with the default value.

IsStoreMask

 

smallint

 

True(1) stores the mask template with data.

IsRequired

 

smallint

 

True(1) indicates the user must fill field in with data.

IsUnique

 

smallint

 

True(1) indicates the value must be unique.

MaxLength

 

smallint

 

Maximum field length (number of characters).

DateLastModified

 

datetime

 

The date the record was last modified.