# SEC_USR: Users - Name: `SEC_USR` - Catalog: `AccountView` - Label: Users - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `SEC_USR` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AI_API` | `string(36)` | API key (user) AutoInvoice | ☐ | | | `ALL_ADM` | `boolean` | Show all administrations | ☐ | | | `AUTH_CODE` | `string(10)` | Approval profile | ☐ | | | `BOS_IMP` | `boolean` | Backoffice Server impersonation | ☐ | | | `CANNOT_CNG` | `boolean` | User cannot change password | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `D_USR_NAME` | `string(30)` | Network user name | ☐ | | | `EM2_SYS` | `boolean` | Changing system hours pages allowed | ☐ | | | `EMAIL` | `string(50)` | Email address | ☐ | | | `FST_NAME` | `string(20)` | First Name | ☐ | | | `FVW_NOSTD` | `boolean` | Suppress AccountView views | ☐ | | | `IGN_CPER` | `boolean` | Posting in blocked periods allowed | ☐ | | | `IMP_AVAIL` | `boolean` | Temporary login allowed | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LAST_PWD` | `string(4)` | Last used password | ☐ | | | `LST_NAME` | `string(40)` | Last Name | ☐ | | | `MUST_CNG` | `boolean` | User must change password on login | ☐ | | | `NO_EXP` | `boolean` | Password does not expire | ☐ | | | `ODP_ID` | `int32` | Visma ID user | ☐ | | | `PW_HASH` | `string(16)` | Password hash | ☐ | | | `PWD_CNGD` | `datetime` | Date of last password change | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `RJT_BOSIMP` | `boolean` | Do not allow BOS impersonation of this user | ☐ | | | `SOA_NOMSG` | `boolean` | Suppress sales advice notifications | ☐ | | | `USR_ID` | `string(20)` | User name | ☐ | | | `USR_NAME` | `string(70)` | Full user name | ☐ | | | `WF_ACCESS` | `int32` | IFA role | ☐ | |