NIPO Fieldwork System Version 1.14
LookupTables
If more than one LookupValues table is used, this table stores the table names and information for lookup values. For NIPO FMS internal use only.
LookupTables table
|
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
|
LookupTableName
|
Lookup table name
|
varchar
|
50
|
NOT NULL
|
|
IndexField
|
Index field
|
varchar
|
50
|
|
|
KeyField
|
Key field
|
varchar
|
50
|
|
|
DescriptionField
|
Description field
|
varchar
|
50
|
|
|
NotInUseField
|
Not in use field
|
varchar
|
50
|
|
|
|
|
|
|
|
|
