# USR_RPT: User reports - Name: `USR_RPT` - Catalog: `AccountView` - Label: User reports - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `USR_RPT` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BUS_FILT` | `boolean` | Use Business selection | ☐ | | | `BUS_SORT` | `boolean` | Use Business sorting | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COMMENT` | `string(4)` | Note | ☐ | | | `DYN_QRY` | `boolean` | Interactive report (?) | ☐ | | | `EXPFIL_CNG` | `boolean` | Fixed export file name | ☐ | | | `EXPORT_FIL` | `string(80)` | Export file name | ☐ | | | `EXPORT_RPT` | `boolean` | Export report only | ☐ | | | `EXPORT_TYP` | `string(254)` | File type | ☐ | | | `FLD_VERT` | `string(4)` | SQL Fields | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `MENU_TYPE` | `decimal` | Menu type | ☐ | | | `OBJ_CODE` | `string(4)` | Object Code | ☐ | | | `OBJ_NAME` | `string(40)` | Object name | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `QRY_CNG` | `boolean` | Query definition changed | ☐ | | | `QRY_CODE` | `string(10)` | Query Code | ☐ | | | `QRY_FILES` | `string(4)` | SQL Tables | ☐ | | | `QRY_FROM` | `string(4)` | SQL From | ☐ | | | `QRY_GROUP` | `string(4)` | SQL Group By | ☐ | | | `QRY_JOIN1` | `string(4)` | SQL Join | ☐ | | | `QRY_ORDER` | `string(4)` | SQL Order By | ☐ | | | `QRY_RPT` | `string(50)` | Layout file | ☐ | | | `QRY_WHER1` | `string(4)` | SQL Where | ☐ | | | `REC_BLK` | `boolean` | Hide | ☐ | | | `RPT_CNG` | `boolean` | Report definition changed | ☐ | | | `RPT_DESC` | `string(60)` | Query description | ☐ | | | `SEL_DESC` | `boolean` | Show descriptions instead of numbers | ☐ | | | `SEL_DIST` | `boolean` | Unique selection | ☐ | | | `SEL_TOP` | `int32` | Top selection value | ☐ | | | `SUMM_TYPE` | `int32` | Report view | ☐ | | | `TOP_PCT` | `boolean` | Top selection | ☐ | | | `TXT_ID` | `string(10)` | Text identification | ☐ | | | `VCNG_DATE` | `string(10)` | Date last modified | ☐ | | | `WIZ_DATA` | `string(4)` | User report data | ☐ | |