VirtualFieldsDef, 122 (ver3.6.1)
These are the user-defined/custom field definitions for their respective custom tables (VirtualTablesDef) and their respective display information.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AccessPrivileges | 3.6.1 | Varchar(20) | Not currently used. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Default_Value | 3.6.1 | Varchar(79) | Default value for this field if data has not been entered. |
Description | 3.6.1 | CLOB | An optional area to describe any information about this virtual table. |
DisplayInList | 3.6.1 | Number(10,0) | In the automatic list view, this option indicates if the field must be displayed in the list. |
DisplayInPageView | 3.6.1 | Number(10,0) | In the automatic list view, this option indicates if the field must be displayed on the page. |
Display_As | 3.6.1 | Varchar(11) | The display attribute for this field. N=Native, C=Checkbox, M=Multi Line text, P=Popup. |
Format | 3.6.1 | Varchar(31) | You can enter a format string to set up how the value is displayed. This is something like ####0.00, MM/DD/YYYY, etc. |
HideFromUser | 3.6.1 | Number(10,0) | Indicates whether to hide this field from user for data entry. 1=yes. |
Kind | 3.6.1 | Varchar(11) | The type of field this is: CUSTOM, REAL, etc. |
LinkTo_VirtTabDefID | 3.6.1 | Number(10,0) | Unique ID from VirtualTableDef, to which this field belongs. Indexed. |
Mandatory | 3.6.1 | Number(10,0) | Indicates whether this is a required field for data entry. |
MaxNbrOfChars | 3.6.1 | Number(10,0) | Maximum number of characters allowed for this field. |
Maximum_Value | 3.6.1 | Varchar(79) | Maximum value allowed for this field. |
Minimum_Value | 3.6.1 | Varchar(79) | Minimum value allowed for this field. |
Modifiable | 3.6.1 | Number(10,0) | Indicates whether the data on this field is modifiable. 1=yes. |
Name | 3.6.1 | Varchar(30) | Name assigned for this virtual field. |
OrderOnEntryForm | 3.6.1 | Number(10,0) | Order of appearance on the Entry form for this field relative to others. |
PopupMenuContents | 3.6.1 | CLOB | Items to show up in the popup menu if this is a popup menu field. Value to return=value to display. |
Reference | 3.6.1 | Number(10,0) | Internal reference number associated to this field. |
Type | 3.6.1 | Number(10,0) | Datatype for this field. Ex; INT, TEXT, etc. |
Unique_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
UserLabel | 3.6.1 | Varchar(40) | Name to appear on the screen for this table. |