The formatitem table defines the data-file records. Each field of a data file is described by an entry in this table. Use the Records Format window to prepare the record formats. Table 4 lists the possible values for the ftype column. For more information, see Figure 54.
| Column | Type | Description |
|---|---|---|
| formid | INTEGER | Record format identifier (foreign key to the formats table) |
| seq | INTEGER | Item sequence number for internal organization |
| fname | CHAR(128) | Name of record field |
| ftype | INTEGER | A number that indicates the type of data in the field |
| bytes | INTEGER | Number of bytes in field |
| decimals | INTEGER | Number of decimal values to format when converting to ASCII |
| offset | INTEGER | Offset in record image where field starts |
| qual | INTEGER | Informix DATETIME/INTERVAL qualifier |
| picture | CHAR(15) | COBOL picture definition |