Column Name | Data Type | Description |
object_id | integer | Unique identifier (object ID) for identifying the form this field belongs to in the ii_objects catalog. Other information about the form (such as name, owner, and object class) is stored in the ii_objects catalog. |
flseq | smallint | The sequence number of the field in the form (or column in a table field). This determines the tabbing order among fields and among columns in a table field. |
fldname | varchar(32) | The name of the field. |
fldatatype | smallint | The data type of the field. Possible values are listed here with nullable data types being the negative of the listed value: 3 date 5 money 20 char 21 varchar 30 integer 31 floating point 32 c 37 text |
fllength | smallint | The internal data length of the field in bytes. This cannot be the same as the user-defined length. This is the length used by Ingres. |
flprec | smallint | Reserved for future use. |
flwidth | smallint | The number of characters displayed in the field on the form including wrap characters. For example, if the format for the field is c20.10, flwidth is 20. If the field is a table field, this value is the number of columns in the table field. |
flmaxlin | smallint | The number of lines occupied by the field (title and data). |
flmaxcol | smallint | The number of columns occupied by the field (title and data). |
flposy | smallint | The y coordinate of the upper left corner of the field. |
flposx | smallint | The x coordinate of the upper left corner of the field. |
fldatawidth | smallint | The width of the data entry area for the field. If field format is c20.10, fldatawidth is 10. |
fldatalin | smallint | The y-coordinate position of the data entry area relative to the upper left corner of the field. |
fldatacol | smallint | The x-coordinate position of the data entry area relative to the upper left corner of the field. |
fltitle | varchar(50) | The field title. |
fltitcol | smallint | The x-coordinate position of the title relative to the upper left corner of the field. |
fltitlin | smallint | The y-coordinate position of the title relative to the upper left corner of the field. |
flintrp | smallint | Reserved for future use. |
fldflags | integer | The field attributes, such as box and reverse video. Valid (octal) values are: 1 boxed field 04 query-only 10 keep previous values 20 mandatory 40 no row lines (table field) 100 force lowercase 200 force uppercase 400 reverse video 1000 blinking 2000 underline 4000 change intensity 10000 no autotab 20000 no echo 40000 no column title (table field only) 200000 foreground color 1 400000 foreground color 2 1000000 foreground color 3 2000000 foreground color 4 4000000 foreground color 5 10000000 foreground color 6 20000000 foreground color 7 100000000 invisible 10000000000 row highlight (table field) |
fld2flags | integer | More attributes for the field, including scrolling: 0100 scrollable 01000 display-only 04000 derived field |
fldfont | smallint | Reserved for future use. |
fldptsz | smallint | Reserved for future use. |
fldefault | varchar(50) | The default value for the field. |
flformat | varchar(50) | The display format for the field (for example, c10 or f10.2). |
flvalmsg | varchar(100) | The message to be displayed if the validation check fails. |
flvalchk | varchar(240) | The validation check for the field. |
fltype | smallint | Indicates if the record describes a regular field, a table field or a column in a table field. Possible values are: 0 simple field; 1 table field; 2 table field column; |
flsubseq | smallint | A unique identifying record number with respect to the set of records that describe all the fields in a form. |