# DCT_SQL: SQL Dictionary - Name: `DCT_SQL` - Catalog: `AccountView` - Label: SQL Dictionary - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `DCT_SQL` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `DLG_CTRLS` | `string(4)` | Report dialogue controls | ☐ | | | `FLD_AMT` | `string(80)` | Crosstab field name amount field | ☐ | | | `FLD_DATE` | `string(80)` | Crosstab field name date field | ☐ | | | `FLD_HORZ` | `string(80)` | Crosstab field name X axis | ☐ | | | `FLD_PER` | `string(80)` | Crosstab field name period field | ☐ | | | `FLD_QTY` | `string(80)` | Crosstab field name quantity field | ☐ | | | `FLD_VERT` | `string(4)` | Query fields | ☐ | | | `FRM_NAME` | `string(40)` | Window name | ☐ | | | `FROM_FRCE` | `boolean` | Fixed join order | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `OBJ_CODE` | `string(10)` | Query Code | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PCT_BASE` | `string(20)` | Base column percentages | ☐ | | | `QRY_EXTRA` | `string(50)` | Query options | ☐ | | | `QRY_FILES` | `string(4)` | Query file list | ☐ | | | `QRY_FROM` | `string(4)` | From expression | ☐ | | | `QRY_GROUP` | `string(4)` | Query group expression | ☐ | | | `QRY_JOIN1` | `string(4)` | Query join expression | ☐ | | | `QRY_ORDER` | `string(4)` | Query order expression | ☐ | | | `QRY_RPT` | `string(20)` | Query report name | ☐ | | | `QRY_WHER1` | `string(4)` | Query selection expression | ☐ | | | `RPT_DESC` | `string(60)` | Query description | ☐ | | | `RPT_TDESC` | `string(60)` | Query description (translated) | ☐ | | | `SEL_DIST` | `boolean` | Unique selection | ☐ | | | `SEL_TOP` | `decimal` | Select top percentage | ☐ | | | `SUM_LST` | `string(80)` | Field total | ☐ | | | `TOP_PCT` | `boolean` | Top selection | ☐ | | | `TXT_ID` | `string(10)` | Text identification | ☐ | | | `WHEN_EXPN` | `string(100)` | When expression | ☐ | |