Stores organization related information. Every record corresponds to an organization.
Column | Type | References | Comments |
id | Integer | Primary key | |
guid | String | ||
vdb_id | Integer | ||
name | String | The name of the company | |
currency_symbol | String | ||
homepage | String | ||
String | |||
country | String | ||
server_name | String | ||
industry | String | ||
created | Date | ||
fl | Integer | ||
document_fo_id | Integer | db_folder.id | ID of the document folder |
admin_id | Integer | db_person.id | ID of the administrator account |
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 |
task_team_gid | Integer | ID of the task team member dynamic security role | |
staff_gid | Integer | db_group.id | ID of the staff security role (db_group) |
company_code | String | The company code. This should be used while logging in to the API | |
locale_id | String | ||
time_zone_id | 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 | |
te_is_hours_in_decimal | Boolean (t or f) | Is Time entered in decimals | |
all_in_alloc | Boolean (t or f) | Show all users during allocation of tasks to resources (true) or just the project team members (false) | |
allow_users_wte | Boolean (t or f) | Allow users to specify whether they are working (true)/non-working (false) when entering calendar events. If true, exceptions will immediately impact scheduling. | |
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. | |
task_start_before | Integer | The number of hours to start the task before | |
task_with_time | Boolean (t or f) | Whether to show time in task start and finish | |
affiliate_unique_id | String |