# DCT_FLD: Field dictionary - Name: `DCT_FLD` - Catalog: `AccountView` - Label: Field dictionary - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `DCT_FLD` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AUTO_DISP` | `boolean` | Display automatically on window | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COL_LIST` | `boolean` | Columns in overview window | ☐ | | | `COL_PICK` | `boolean` | Columns in selection window | ☐ | | | `COM_BLK` | `boolean` | Block for COM | ☐ | | | `CTRL_LIST` | `boolean` | Use Form Class as Popup-List | ☐ | | | `DBF_NAME` | `string(8)` | Table name | ☐ | | | `DESC_FLD` | `string(10)` | Field name of description field | ☐ | | | `ENUM_CLASS` | `string(40)` | Enumeration Class | ☐ | | | `EXPN_NAME` | `string(10)` | Expression | ☐ | | | `EXPN_OBJ` | `string(4)` | Expression Object | ☐ | | | `FIELD_DEC` | `decimal` | Decimals | ☐ | | | `FIELD_LEN` | `decimal` | Width | ☐ | | | `FIELD_NAME` | `string(10)` | Field name | ☐ | | | `FIELD_TYPE` | `string(1)` | Field type | ☐ | | | `FILT_LIST` | `boolean` | Select in overview window | ☐ | | | `FILT_PICK` | `boolean` | Select in selection window | ☐ | | | `FLD_ACTIVE` | `boolean` | Field active | ☐ | | | `FLD_CLASS` | `string(100)` | Form Class | ☐ | | | `FLD_CLEAR` | `boolean` | Clear when carrying over master data | ☐ | | | `FLD_CLIB` | `string(100)` | Form Class Library | ☐ | | | `FLD_DATA` | `string(4)` | Table-specific data | ☐ | | | `FLD_DESC` | `string(50)` | Field description | ☐ | | | `FLD_DFLT` | `string(25)` | Default value | ☐ | | | `FLD_EXPN` | `string(4)` | Virtual expression | ☐ | | | `FLD_EXTRA` | `string(4)` | Additional field information | ☐ | | | `FLD_FMT` | `string(1)` | Format | ☐ | | | `FLD_MASK` | `string(100)` | Input mask | ☐ | | | `FLD_MEMO` | `string(4)` | Field notes | ☐ | | | `FLD_NOCPY` | `boolean` | Do not carry over when copying | ☐ | | | `FLD_NULL` | `boolean` | Null value allowed | ☐ | | | `FLD_OPT` | `boolean` | Optimise field | ☐ | | | `FLD_ORDER` | `int32` | Field order | ☐ | | | `FLD_TRN` | `boolean` | Translate field | ☐ | | | `FLD_UPD` | `boolean` | Virtual field editable | ☐ | | | `FLD_VIRT` | `boolean` | Virtual field | ☐ | | | `FRM_DESC` | `string(40)` | Master data title | ☐ | | | `GRD_DESC` | `string(40)` | Column title | ☐ | | | `GRD_WID` | `int32` | Column width | ☐ | | | `GRDE_CLASS` | `string(4)` | Edit Grid Class | ☐ | | | `GRDE_CLIB` | `string(4)` | Edit Grid Class Library | ☐ | | | `GRDL_CLASS` | `string(4)` | List Grid Class | ☐ | | | `GRDL_CLIB` | `string(4)` | List Grid Class Library | ☐ | | | `HDR_ALIGN` | `int32` | Column title alignment | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_MAND` | `boolean` | Input required | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LIST_TYPE` | `int32` | List type | ☐ | | | `LST_CODE` | `string(10)` | User list code | ☐ | | | `NO_CPTRANS` | `boolean` | Ignore code page changes | ☐ | | | `PKY_TBL` | `string(8)` | Main table name | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REC_CUST` | `boolean` | Customised | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `SL_SRC` | `string(10)` | Subledger identification | ☐ | | | `SORT_LIST` | `boolean` | Sort in overview window | ☐ | | | `SORT_PICK` | `boolean` | Sort in selection window | ☐ | | | `SRC_UPPER` | `boolean` | Case-sensitive search | ☐ | | | `TXT_ID` | `string(10)` | Text identification | ☐ | | | `USR_TAB` | `string(15)` | User field tab | ☐ | | | `WHEN_EXPN` | `string(4)` | Visible as | ☐ | |