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. |