object_id

integer

Object ID of the frame.

vq_seq

smallint

Column sequence number (for ordering).

tvq_seq

smallint

Sequence number of table in visual query from ii_vqtables.

col_name

varchar(32)

Column name.

ref_name

varchar(32)

Name used on the form for field containing data.

adf_type

smallint

Type information for column. See description of iicolumns. column_ingdatatype for details.

adf_length

integer

Column size in bytes.

adf_scale

integer

Currently not used.

col_flags

integer

This column contains multiple pieces of information about the column in a bitmap format. The following values are present (expressed in Hex):
1 = Column is to be used on form/report.
2 = Column is joined to a detail table and must be displayed.
4 = Column is joined to a lookup table and must be displayed.
8 = Column is a subordinate join field; therefore it cannot be displayed.

0x10 = Column is sequenced (generate new surrogate key value for INSERT statements).
0x20 = Column is descending (for sort).
0x40 = Column is part of the table's unique key.
0x100 = Set if column allows defaults.

col_sortorder

smallint

Sort order for this column. Set to 0 if not part of sort sequence. For lookup tables, this gives the order of the column in the lookup screen.

col_info

varchar(240)

Information entered by developer for this column in visual query. For Browse & Update frames, this is a query restriction and is added to the WHERE clause of the SELECT statement. For Append frames, this gives default value information and is either used in 4gl assignment statements for a displayed column, or in the INSERT statement for a not-displayed column.