Identifier (main field of the data set)
- Main name of the object, operation, or privileged data field described in the record that represents the record
- Display field in selection lists
Customer or object number
Number (e.g. customer numbers). If the field consists of a string data type, only digits are allowed here.
- AcceptedValues are already preset here
Customer- or Objectname
- The name of a company, object or other object
Person identification number or ID
- personal identification number or other identification number for a person
First name
- First name of a natural person
Last name
- Last name of a natural person
Street
- Name of a street
House number
- House number , if necessary with house number supplement
(initially limited to 6 characters)
Adress (compact in one string)
Address, compactly represented with line breaks in a character string, enables international address spelling in a simple way
Zip code
(initially limited to 10 characters)
- AcceptedValues preset for postal codes common in Germany
City
- Name der Stadt
Web address (URL)
- Web address (URL), optionally as absolute address (e.g. “http://www.scopeland.de” or shortened “www.scopeland.de”) or as relative address (e.g. “../MyPage/MyFile.html”)
- AcceptedValues preset
Country
Name des Landes
Email adress
- Email aderss(e.g. “example@googlemail.com”)
- AcceptedValues preset
Phone number
- AcceptedValues preset
Fax number
- AcceptedValues preset
Comment
comments field
- by default not active in the data view
Formatted text
Formatiertes Textfeld
- by default not visible in table
Numerical value
Number as value, e.g. length in meters, numbers of employees or age in years
- ([0-9], permissible special characters: minus symbol ‘-‘ and comma symbol ‘,’)
Relational block number
Automatic numbering is given within the data space of identical other ID fields (across the entire table if no other ID fields exist).
- (initially limited to 11 digits)
- Auto numbering only works when using this data type
File name, fixed type
Path and file name without extension; file is of fixed type of the extension specified in the parameter for the field type.
- Security relevant, e.g. to ensure that only files of a specific type can be uploaded during a file upload
Document name (without path)
Document name (e.g. ‘MyLetter’) withouth path or extension, from which a file can be created
Datum, Uhrzeit
Datum, Uhrzeit
Date (futere)
- Accepts only data in the future (at the time of editing)
Month
- AcceptedValues vorbelegt
Year, two digits
Year, double-digit displayed
- AcceptedValues preset
Jahr, four digits
Year,displayed with four digits
- AcceptedValues preset
File, fixed type
- BLOB-field
- Security relevant, e.g. to ensure during file upload that only files of a specific type can be uploaded.
File
- File of an unknown data type
File name
- Path and file name incl. extension, e.g. ‘MyFile.xml’ or ‘C:Files/MyFile.doc’.
Extension
- File of the data type specified as parameter (file extension such as ‘docx’ or ‘html’)
- Security relevant, e.g. to ensure during file upload that only files of a specific type can be uploaded.
Geographical high value
Geo-positioning information as high value (latitude) in the context of a specific reference system
- Can be created together as a group with legal value
- Representation in map control as GIS point
- by default not visible in table
Geographical legal value
Geo-positioning as right value (longitude) in the context of a certain reference system
- Can be created together as a group with legal value
- Representation in map control as GIS point
- by default not visible in table
ID of a GIS object
- ID of a GIS object of a connected GIS system
GIS-object
- GIS object in the database (point, line or polygon or area)
GIS-Punkt Objekt
GIS-Punkt Objekt in der Datenbank, geographisch (WGS84)
- Darstellung im Map-Control als GIS-Punkt
- per Default nicht sichtbar in Tabelle
GIS-Linien Objekt
GIS-Linien Objekt in der Datenbank, geographisch (WGS84)
- Darstellung im Map-Control als GIS-Linie
- per Default nicht sichtbar in Tabelle
GIS polygon object
GIS-Polygon Objekt in der Datenbank, geographisch (WGS84)
- Display in map control as GIS polygon
- by default not visible in table
Information
Internal technical information field
- by default not visible in data view
Status field
Status field for workflow or process models, usually numeric or as an abbreviation; usually also refers to a status catalog as a foreign key
- by default not active in data view!
User name
- User name in the computer system (usually identical to the log-in name and managed as a user within the program)
Password field
- Field for hidden password entry
Valid from
- The content validity of the data record (for example, of a catalog entry) usually has nothing to do with the change history
Valid until
The content validity of the data record (for example, of a catalog entry) usually has nothing to do with the change history.
- Preassignment planned for test data generation
Created by
Dataset created by user
- Is set automatically when saving
- by default not active in data view
Created on
dataset created on
- Is set automatically when saving
- by default not active in data view
Edited by
Last change
- Is set automatically when saving
- by default not active in data view
Edited on
Last change
- Is set automatically when saving
- by default not active in data view