# DCT_FILE: Data Dictionary - Name: `DCT_FILE` - Catalog: `AccountView` - Label: Data Dictionary - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `DCT_FILE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADD_BASE` | `boolean` | Add real fields and indexes to base table | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `DBF_BASE` | `string(8)` | Reference to base table | ☐ | | | `DBF_CATEG` | `int32` | Category | ☐ | | | `DBF_CATEGD` | `string(25)` | Category description | ☐ | | | `DBF_DESC` | `string(40)` | Table description | ☐ | | | `DBF_DESCT` | `string(40)` | Table description (translated) | ☐ | | | `DBF_EXTRA` | `string(4)` | Note | ☐ | | | `DBF_NAME` | `string(8)` | Table name | ☐ | | | `DBF_TYPE` | `int32` | Table type | ☐ | | | `DBF_TYPED` | `string(25)` | Table type description | ☐ | | | `DBF_VIRT` | `boolean` | Virtual table | ☐ | | | `DESC_EXPN` | `string(40)` | Key field description expression | ☐ | | | `FILE_EXTRA` | `string(4)` | Additional table information | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LOG_DEL` | `boolean` | Log deletions | ☐ | | | `LOG_INS` | `boolean` | Log additions | ☐ | | | `LOG_UPD` | `boolean` | Log changes | ☐ | | | `NO_COPY` | `boolean` | Copying not possible | ☐ | | | `NO_DELETE` | `boolean` | Deleting not possible | ☐ | | | `NO_INSERT` | `boolean` | Adding not possible | ☐ | | | `NO_UPDATE` | `boolean` | Changing not possible | ☐ | | | `NO_XML_UPD` | `boolean` | Changes not via Web API | ☐ | | | `OBJ_ACTIVE` | `boolean` | Object active | ☐ | | | `OBJ_CODE` | `string(4)` | Object Code | ☐ | | | `OBJ_GRP` | `string(40)` | Explorer subgroups | ☐ | | | `OBJ_IMP` | `boolean` | Object usable for import | ☐ | | | `OBJ_LIST` | `boolean` | Object in query list | ☐ | | | `OBJ_TASK` | `boolean` | Object suitable for task-oriented interface | ☐ | | | `OBJ_TYPE` | `decimal` | Object type | ☐ | | | `OBJ_WHEN` | `string(100)` | Object visible as | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REC_CUST` | `boolean` | Customised | ☐ | | | `REC_DESC` | `string(40)` | Record description | ☐ | | | `SETUP_DATA` | `boolean` | Carry over to new year | ☐ | | | `SORT_EXPN` | `string(70)` | Sort expression | ☐ | | | `STD_VIEW` | `boolean` | Use standard object | ☐ | | | `TBL_ACTIVE` | `boolean` | Table active | ☐ | | | `TBL_CHILD` | `string(8)` | Line table | ☐ | | | `TBL_HDR` | `string(8)` | Header table | ☐ | | | `TXT_ID` | `string(10)` | Text identification | ☐ | | | `WHEN_EXPN` | `string(100)` | When expression | ☐ | |