The V1DCHFLF table is used for ANURDFLF and ANDCHFLF views. The following table describes the columns in the V1DCHFLF table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| MCRECID | BINARY | 4 | 0 | machine/company ID |
| FILRECID | BINARY | 9 | 0 | file ID |
| FLDRECID | BINARY | 9 | 0 | field ID |
| FLDDISPL | BINARY | 5 | 0 | field displacement |
| FLDNAME | CHARACTER | 128 | 0 | field name |
| FLDLEN | BINARY | 5 | 0 | field length |
| FLDINT | BINARY | 3 | 0 | field integer |
| FLDDEC | BINARY | 3 | 0 | field decimal |
| FLDSIGN | CHARACTER | 1 | 0 | field sign |
| FLDTYPE | CHARACTER | 1 | 0 |
field type:
|
| TYPNAME | CHARACTER | 128 | 0 | ODBC Data Type Name |
| TYPNUM | DECIMAL | 5 | 0 | ODBC Data Type Number |
| FLDNAT | CHARACTER | 1 | 0 | field nature |
| FLJUSTIFY | CHARACTER | 1 | 0 | justify flag |
| CLATYPE | BINARY | 3 | 0 | field class |
| INFOPROV | CHARACTER | 3 | 0 | information origin |
| MINVAL | CHARACTER | 33 | 0 | minimum value |
| MAXVAL | CHARACTER | 33 | 0 | maximum value |
| AVGVAL | DECIMAL | 18 | 0 | average value |
| SPEDIFVAL | BINARY | 5 | 0 | number of different values |
| USERPGM | CHARACTER | 10 | 0 | user program |
| HASSPE | CHARACTER | 1 | 0 | spectrum presence flag |
| FLSPE | CHARACTER | 1 | 0 | spectrum calculation flag |
| LOGMON | CHARACTER | 1 | 0 | logging enabled |
| DCMON | CHARACTER | 1 | 0 | data corruption enabled |
| LOGALARM | CHARACTER | 1 | 0 | logging alarm |
| DCALARM | CHARACTER | 1 | 0 | data corruption alarm |
| NULLCAP | CHARACTER | 1 | 0 | null capable field |
| VARLEN | CHARACTER | 1 | 0 | field with variable length |
| ISANAG | CHARACTER | 1 | 0 | demographic field |
| ESTCARD | BINARY | 9 | 0 | estimated cardinality |
| ESTCLA | BINARY | 3 | 0 | estimated class |
| SAMPVAL | CHARACTER | 33 | 0 | sample value |
| SAMPNBR | BINARY | 9 | 0 | sample OCCURS |
| FLDTXT | CHARACTER | 50 | 0 | text |
| ISKEY | CHARACTER | 1 | 0 | primary key |
| FLCLAVAL | CHARACTER | 1 | 0 | use class value |
| ANAGPRO | CHARACTER | 3 | 0 | demographic provider |
| CHGFLG | CHARACTER | 1 | 0 | Data Changer active |
| CHGPGM | CHARACTER | 8 | 0 | Data Changer program |
| METHOD | CHARACTER | 10 | 0 | Method |