Describes an app itemStores resources, contacts, clients and users
| Column | Type | References | Comments | ||
| id | IntegerInteger | Primary key | guid | StringPrimary key | |
| vdb_id | Integer | ||||
| guid | String | ||||
| created | Date | ||||
| vdb_id | Integer | ||||
| created | Date | Date created | |||
| summary | String | Short summary | |||
| detail | String | Detailed description | |||
| due_date | Date | Due date | |||
| is_delayed | Boolean (t or f) | Is this app item delayed? | |||
| priority | Integer | Priority : 1 = highest, 5 = lowest | |||
| type_id | Integer | db_process_type.id | Process type ID | ||
| category_id | Integer | db_category.id | Category ID | ||
| department_id | Integer | ID of the department this app item belongs to | |||
| last_state_changed | Date | Last state change on | |||
| last_updated | Date | Last update on | |||
| requestor_id | Integer | db_person.id | Requestor ID | ||
| requestor_name | String | Requestor name (in case requestor is not a user of the system) | |||
| requestor_email | String | Requestor email (in case requestor is not a user of the system) | |||
| creator_id | Integer | db_person.id | Creator ID | ||
| assigned_to_id | Integer | db_person.id | Current owner | ||
| state_id | Integer | db_state.id | State this app item is in | ||
| completed | Date | Completed on | |||
| is_requestor_visible | Boolean (t or f) | Is visible to requestor? | |||
| custom_field_string | String | (New column since v9.1) Includes a JSON formatted string of all custom fields attached to this entity | |||
| name | String | Name of the user | |||
| login_name | String | Login name | |||
| pwd | String | Encrypted password | |||
| pwd_changed_at | Date | ||||
| phone | String | ||||
| String | Email Address | ||||
| keywords | String | Keywords related to this user e.g. skills, qualifications | |||
| archived | Date | Date on which this user was archived | |||
| discriminator | Integer | 4 = contact, 24 = user, 63 = client | |||
| folder_id | Integer | db_folder.id | ID of the personal document folder of this user | ||
| is_public | Boolean (t or f) | Is this record viewable by anyone in the company | |||
| creator_id | Integer | Creator Id | |||
| in_out_status | String | ||||
| in_out_updated_on | Date | ||||
| is_in | Boolean (t or f) | If this user is in or out | |||
| last_access | Date | The last time the user accessed the system | |||
| parent_id | Integer | The parent of this record. In case of client this is the ID of the parent. | |||
| path | String | Path separated by '/' from root user object. | |||
| locale_id | String | ||||
| time_zone_id | String | Time zone ID of this user | |||
| calendar_id | Integer | db_working_calendar.id | The working calendar of this user |