Stores organization related information. Every record corresponds to an organization.
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| name | String | The name of the company | |
| decimal_format | String | ||
| currency_symbol | String | ||
| homepage | String | ||
| String | |||
| street | String | ||
| locality | String | ||
| state | String | ||
| country | String | ||
| zip | String | ||
| phone | String | ||
| server_name | String | ||
| industry | String | ||
| created | Date | ||
| fl | Integer | ||
| document_fo_id | Integer | db_folder.id | ID of the document folder |
| forum_fo_id | Integer | db_folder.id | ID of the forum folder |
| admin_id | Integer | db_user.id | ID of the administrator account |
| admin_gid | Integer | db_group.id | ID of the administrator security role |
| accountant_gid | Integer | db_group.id | ID of the accountant security role |
| project_owner_gid | Integer | db_group.id | ID of the project manager dynamic security role |
| project_team_gid | Integer | db_group.id | ID of the project team member dynamic security role |
| staff_gid | Integer | db_group.id | ID of the staff security role (db_group) |
| management_gid | Integer | ID of the management security role (db_group) | |
| company_code | String | The company code. This should be used while logging in to the API | |
| time_zone | String | The default time zone of the organization | |
| te_on_cp | Boolean (t or f) | Indicates whether time can be filled on archived project | |
| te_on_any | Boolean (t or f) | Allow time on any task | |
| te_auto_approve | Integer | Auto approve time | |
| use_ot | Boolean (t or f) | Whether this organization uses the concept of 'Overtime' rates | |
| all_in_alloc | Boolean (t or f) | Show all users during allocation of tasks to resources (true) or just the project team members (false) | |
| process_client_user_visibility | Integer | Does the client see only the PM (1) or all users (0) | |
| first_day_of_week | Integer | The first day of the week in calendar. 1 for Sunday, 2 for Monday, 3 for Tuesday, etc. | |
| min_days_in_first_week | Integer | The minimum number of days in the first week | |
| minutes_in_day | Integer | Minutes in day. This is used for scheduling. Default is 8 hours i.e. 480. |