db_company

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
campaign	String
gclid	String
referrer	String
currency_symbol	String
contact_name	String
contact_email	String
country	String
server_name	String
industry	String
created	Date
fl	Integer
document_fo_id	Integer	db_folder.id	ID of the document folder
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	String
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
te_is_hours_in_decimal	Boolean (t or f)		Is Time entered in decimals
te_billing_model	Integer
te_remind_at	String
te_limit_allocated	Boolean (t or f)
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
load_optimal_low	Float
load_optimal_high	Float