NetSuite SuiteProjects Pro

Explore the interactive ERD

Table & Field Reference

project_phase_attachment_id

Column	Type	Keys
`id`	Unknown	PKFK
`project_phase_id`	Unknown	PKFK

project_phase

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`project_id`	Unknown	FK
`calculated_finish`	Unknown
`calculated_start`	Unknown
`created`	LocalDateTime
`currency`	Unknown
`default_category_on_phase`	Unknown
`default_category_on_phase_1`	Unknown
`default_category_on_phase_2`	Unknown
`default_category_on_phase_3`	Unknown
`default_category_on_phase_4`	Unknown
`default_category_on_phase_5`	Unknown
`external_id`	Unknown
`id_number`	Unknown
`is_closed`	Unknown
`is_ready_for_recognition`	Unknown
`name`	Unknown
`note`	Unknown
`originating_id`	Unknown
`parent_id`	Unknown
`percent_complete`	Unknown
`planned_hour`	Unknown
`predecessor`	Unknown
`predecessor_lag`	Unknown
`predecessors_type`	Unknown
`priority`	Unknown
`seq`	Unknown
`updated`	LocalDateTime

project_phase_attachment

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`uploaded_by`	Unknown	FK
`attachment_category_id`	Unknown
`created`	LocalDateTime
`file_name`	Unknown
`file_type`	Unknown
`has_thumbnail`	Unknown
`is_excluded_from_alert`	Unknown
`is_folder`	Unknown
`is_locked`	Unknown
`is_viewable`	Unknown
`locked_by`	Unknown
`name`	Unknown
`note`	Unknown
`size`	Unknown
`updated`	LocalDateTime
`workspace_id`	Unknown

project_milestone_attachment

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`uploaded_by`	Unknown	FK
`attachment_category_id`	Unknown
`created`	LocalDateTime
`file_name`	Unknown
`file_type`	Unknown
`has_thumbnail`	Unknown
`is_excluded_from_alert`	Unknown
`is_folder`	Unknown
`is_locked`	Unknown
`is_viewable`	Unknown
`locked_by`	Unknown
`name`	Unknown
`note`	Unknown
`size`	Unknown
`updated`	LocalDateTime
`workspace_id`	Unknown

project_milestone_attachment_id

Column	Type	Keys
`id`	Unknown	PKFK
`project_milestone_id`	Unknown	PKFK

project_milestone

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`project_id`	Unknown	FK
`calculated_starts`	Unknown
`created`	LocalDateTime
`currency`	Unknown
`default_category`	Unknown
`default_category_1`	Unknown
`default_category_2`	Unknown
`default_category_3`	Unknown
`default_category_4`	Unknown
`default_category_5`	Unknown
`external_id`	Unknown
`id_number`	Unknown
`is_closed`	Unknown
`is_non_billable`	Unknown
`name`	Unknown
`note`	Unknown
`originating_id`	Unknown
`parent_id`	Unknown
`predecessor`	Unknown
`predecessor_lag`	Unknown
`predecessor_type`	Unknown
`priority`	Unknown
`project_task_type_id`	Unknown
`seq`	Unknown
`start_date`	Unknown
`updated`	LocalDateTime
`use_all_can_assign`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`accounting_code`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`address_4`	Unknown
`can_bill`	Unknown
`can_sell`	Unknown
`can_ship`	Unknown
`city`	Unknown
`country`	Unknown
`created`	LocalDateTime
`email`	Unknown
`external_id`	Unknown
`fax`	Unknown
`first_name`	Unknown
`is_active`	Unknown
`job_title`	Unknown
`last_name`	Unknown
`mobile`	Unknown
`nickname`	Unknown
`note`	Unknown
`phone`	Unknown
`state`	Unknown
`title`	Unknown
`updated`	LocalDateTime
`zip`	Unknown

job_code

Column	Type	Keys
`id`	Unknown	PK
`accounting_code`	Unknown
`created`	LocalDateTime
`currency`	Unknown
`external_id`	Unknown
`generic_resource_id`	Unknown
`is_active`	Unknown
`loaded_cost`	Unknown
`name`	Unknown
`note`	Unknown
`updated`	LocalDateTime

project_attachment

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`uploaded_by`	Unknown	FK
`attachment_category_id`	Unknown
`created`	LocalDateTime
`file_name`	Unknown
`file_type`	Unknown
`has_thumbnail`	Unknown
`is_excluded_from_alert`	Unknown
`is_folder`	Unknown
`is_locked`	Unknown
`is_viewable`	Unknown
`locked_by`	Unknown
`name`	Unknown
`note`	Unknown
`size`	Unknown
`updated`	LocalDateTime
`workspace_id`	Unknown

project_hierarchy_node

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK

project_attachment_id

Column	Type	Keys
`id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_filter_set

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK

project

Column	Type	Keys
`id`	Unknown	PK
`billing_contact_id`	Unknown	FK
`contact_id`	Unknown	FK
`customer_id`	Unknown	FK
`project_approver_1`	Unknown	FK
`project_approver_2`	Unknown	FK
`project_approver_3`	Unknown	FK
`shipping_contact_id`	Unknown	FK
`sold_to_contact_id`	Unknown	FK
`user_id`	Unknown	FK
`accounting_code`	Unknown
`auto_bill_cap_value`	Unknown
`billing_code`	Unknown
`booking_approval_process`	Unknown
`booking_approver`	Unknown
`booking_request_approval_process`	Unknown
`booking_request_approver`	Unknown
`budget`	Unknown
`budget_approval_process`	Unknown
`budget_approver`	Unknown
`budget_cost`	Unknown
`budget_time`	Unknown
`category_filter`	Unknown
`copy_approver`	Unknown
`copy_booking`	Unknown
`copy_cp_exclude_filter`	Unknown
`copy_custom_field`	Unknown
`copy_dashboard_setting`	Unknown
`copy_expense_policy`	Unknown
`copy_invoice_layout_setting`	Unknown
`copy_issue`	Unknown
`copy_loaded_cost`	Unknown
`copy_notification_setting`	Unknown
`copy_project_assignment_profile`	Unknown
`copy_project_billing_auto_setting`	Unknown
`copy_project_billing_rule`	Unknown
`copy_project_budget_group`	Unknown
`copy_project_pricing`	Unknown
`copy_revenue_recognition_auto_setting`	Unknown
`copy_revenue_recognition_rule`	Unknown
`cost_center_id`	Unknown
`created`	LocalDateTime
`credit_invoice_layout_id`	Unknown
`currency`	Unknown
`dashboard_from`	Unknown
`dashboard_message`	Unknown
`discussion_message_count`	Unknown
`expense_allowance_approval_process`	Unknown
`expense_allowance_approver`	Unknown
`expense_approval_process`	Unknown
`expense_approver`	Unknown
`expense_authorization_approval_process`	Unknown
`expense_authorization_approver`	Unknown
`external_id`	Unknown
`finish_date`	Unknown
`invoice_approval_process`	Unknown
`invoice_approver`	Unknown
`invoice_layout_id`	Unknown
`invoice_text`	Unknown
`is_active`	Unknown
`is_auto_bill`	Unknown
`is_auto_bill_cap`	Unknown
`is_auto_bill_overriden`	Unknown
`is_dashboard_enabled`	Unknown
`is_portfolio_project`	Unknown
`msp_link_type`	Unknown
`name`	Unknown
`news_feed_id`	Unknown
`note`	Unknown
`notify_assignees`	Unknown
`notify_assignment_cc`	Unknown
`notify_issue_assigned_to`	Unknown
`notify_issue_closed_assigned_to`	Unknown
`notify_issue_closed_customer_owner`	Unknown
`notify_issue_closed_project_owner`	Unknown
`notify_issue_created_customer_owner`	Unknown
`notify_issue_created_project_owner`	Unknown
`notify_owner`	Unknown
`notify_sr_submitted_project_owner`	Unknown
`only_owner_can_edit`	Unknown
`originating_id`	Unknown
`payroll_type_filter`	Unknown
`portfolio_project_id`	Unknown
`project_location_id`	Unknown
`project_stage_id`	Unknown
`purchase_order_approval_process`	Unknown
`purchase_order_approver`	Unknown
`purchase_request_approval_process`	Unknown
`purchase_request_approver`	Unknown
`rate`	Unknown
`rate_card_id`	Unknown
`revenue_approval_process`	Unknown
`revenue_approver`	Unknown
`sga_labor`	Unknown
`start_date`	Unknown
`sync_workspace`	Unknown
`task_budget_cost`	Unknown
`task_budget_revenue`	Unknown
`tax_location_id`	Unknown
`tax_rate_federal`	Unknown
`tax_rate_state`	Unknown
`template_project_id`	Unknown
`timesheet_approval_process`	Unknown
`timesheet_approver`	Unknown
`timetype_filter`	Unknown
`updated`	LocalDateTime
`user_filter`	Unknown

time_entry

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`job_code_id`	Unknown	FK
`project_id`	Unknown	FK
`project_task_id`	Unknown	FK
`user_id`	Unknown	FK
`accounting_date`	Unknown
`category_1_id`	Unknown
`category_2_id`	Unknown
`category_3_id`	Unknown
`category_4_id`	Unknown
`category_5_id`	Unknown
`category_id`	Unknown
`cost_center_id`	Unknown
`created`	LocalDateTime
`date`	LocalDate
`decimal_hour`	Unknown
`description`	Unknown
`end_time`	Unknown
`exported`	Unknown
`hour`	Unknown
`hours_remaining`	Unknown
`minute`	Unknown
`note`	Unknown
`payroll_type_id`	Unknown
`project_task_type_id`	Unknown
`schedule_request_item_id`	Unknown
`slip_id`	Unknown
`start_time`	Unknown
`thin_client_id`	Unknown
`time_type_id`	Unknown
`timesheet_id`	Unknown
`updated`	LocalDateTime

users

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`job_code_id`	Unknown	FK
`line_manager_id`	Unknown	FK
`accounting_code`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`address_4`	Unknown
`attachments`	Json
`bcc_self`	Unknown
`booking_approval_process`	Unknown
`booking_approver`	Unknown
`booking_request_approval_process`	Unknown
`booking_request_approver`	Unknown
`budget_approval_process`	Unknown
`budget_approver`	Unknown
`city`	Unknown
`cost_center_id`	Unknown
`country`	Unknown
`created`	LocalDateTime
`currency`	Unknown
`deal_booking_request_approval_process`	Unknown
`deal_booking_request_approver`	Unknown
`default_saml_settings_name`	Unknown
`department_id`	Unknown
`display_name`	Unknown
`email`	Unknown
`expense_allowance_approval_process`	Unknown
`expense_allowance_approver`	Unknown
`expense_approval_process`	Unknown
`expense_approver`	Unknown
`expense_authorization_approval_process`	Unknown
`expense_authorization_approver`	Unknown
`expenses_filter_set`	Unknown
`external_id`	Unknown
`fax`	Unknown
`first_name`	Unknown
`generic`	Unknown
`invoice_filter_set`	Unknown
`is_active`	Unknown
`is_guest`	Unknown
`is_locked`	Unknown
`is_password_forced_change`	Unknown
`last_name`	Unknown
`mfa_setup_date`	Unknown
`mfa_status`	Unknown
`middle_name`	Unknown
`mobile`	Unknown
`my_account_filter_set`	Unknown
`name`	Unknown
`nickname`	Unknown
`opportunties_filter_set`	Unknown
`payroll_code`	Unknown
`phone`	Unknown
`primary_filter_set`	Unknown
`project_access_node`	Unknown
`project_filter_set`	Unknown
`proposal_approval_process`	Unknown
`proposal_approver`	Unknown
`purchase_filter_set`	Unknown
`purchase_order_approval_process`	Unknown
`purchase_order_approver`	Unknown
`purchase_request_approval_process`	Unknown
`purchase_request_approver`	Unknown
`rate`	Unknown
`report_filter_set`	Unknown
`resource_filter_set`	Unknown
`resource_profile_approval_process`	Unknown
`resource_profile_approver`	Unknown
`role_id`	Unknown
`rpc_api_updated`	Unknown
`rpc_updated_by`	Unknown
`rpc_user_updated`	Unknown
`salutation`	Unknown
`schedule_request_approval_process`	Unknown
`schedule_request_approver`	Unknown
`ssn`	Unknown
`state`	Unknown
`territory_id`	Unknown
`timesheet_approval_process`	Unknown
`timesheet_approver`	Unknown
`timesheets_filter_set`	Unknown
`timezone`	Unknown
`updated`	LocalDateTime
`user_location_id`	Unknown
`week_start`	Unknown
`work_schedule_id`	Unknown
`workspace_filter_set`	Unknown
`zip`	Unknown

project_task_attachment

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`uploaded_by`	Unknown	FK
`attachment_category_id`	Unknown
`created`	LocalDateTime
`file_name`	Unknown
`file_type`	Unknown
`has_thumbnail`	Unknown
`is_excluded_from_alert`	Unknown
`is_folder`	Unknown
`is_locked`	Unknown
`is_viewable`	Unknown
`locked_by`	Unknown
`name`	Unknown
`note`	Unknown
`size`	Unknown
`updated`	LocalDateTime
`workspace_id`	Unknown

project_task_time_type_filter

Column	Type	Keys
`id`	Unknown	PK
`project_task_id`	Unknown	PKFK

project_task_assigned_user

Column	Type	Keys
`id`	Unknown	PKFK
`project_task_id`	Unknown	PKFK

project_task_assigned_group

Column	Type	Keys
`id`	Unknown	PK
`project_task_id`	Unknown	PKFK

project_task_attachment_id

Column	Type	Keys
`id`	Unknown	PKFK
`project_task_id`	Unknown	PKFK

project_task_task_split

Column	Type	Keys
`id`	Unknown	PK
`project_task_id`	Unknown	PKFK

project_task_user_assignment

Column	Type	Keys
`id`	Unknown	PK
`project_task_id`	Unknown	PKFK

project_task

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`parent_id`	Unknown	FK
`project_id`	Unknown	FK
`assignment_cc`	Unknown
`assignment_cc_email`	Unknown
`calculated_finish`	LocalDate
`calculated_start`	LocalDate
`cost_center_id`	Unknown
`created`	LocalDateTime
`currency`	Unknown
`default_category`	Unknown
`default_category_1`	Unknown
`default_category_2`	Unknown
`default_category_3`	Unknown
`default_category_4`	Unknown
`default_category_5`	Unknown
`external_id`	Unknown
`fn_lt_date`	Unknown
`hours_remaining_estimate`	Json
`id_number`	Unknown
`is_closed`	Unknown
`is_non_billable`	Unknown
`is_ready_for_recognition`	Unknown
`is_sign_off_required`	Unknown
`is_using_project_assignment`	Unknown
`name`	Unknown
`note`	Unknown
`originating_id`	Unknown
`percent_complete`	Unknown
`planned_hour`	Unknown
`predecessor`	Unknown
`predecessor_lag`	Unknown
`predecessor_type`	Unknown
`priority`	Unknown
`project_task_type_id`	Unknown
`seq`	Unknown
`start_date`	Unknown
`task_budget_cost`	Unknown
`task_budget_revenue`	Unknown
`updated`	LocalDateTime
`use_all_can_assign`	Unknown
`use_manual_task_budget`	Unknown

booking_attachment

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`uploaded_by`	Unknown	FK
`attachment_category_id`	Unknown
`created`	LocalDateTime
`file_name`	Unknown
`file_type`	Unknown
`has_thumbnail`	Unknown
`is_excluded_from_alert`	Unknown
`is_folder`	Unknown
`is_locked`	Unknown
`is_viewable`	Unknown
`locked_by`	Unknown
`name`	Unknown
`note`	Unknown
`size`	Unknown
`updated`	LocalDateTime
`workspace_id`	Unknown

booking_attachment_id

Column	Type	Keys
`booking_id`	Unknown	PKFK
`id`	Unknown	PKFK

booking

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`job_code_id`	Unknown	FK
`project_id`	Unknown	FK
`project_task_id`	Unknown	FK
`user_id`	Unknown	FK
`approval_status`	Unknown
`as_percentage`	Unknown
`booking_request_id`	Unknown
`booking_type_id`	Unknown
`created`	LocalDateTime
`date_approved`	Unknown
`date_rejected`	Unknown
`date_submitted`	Unknown
`end_date`	LocalDate
`end_time`	Unknown
`external_id`	Unknown
`hour`	Unknown
`location_id`	Unknown
`match_score`	Unknown
`note`	Unknown
`notify_owner`	Unknown
`owner_id`	Unknown
`percentage`	Unknown
`preferred`	Unknown
`priority`	Unknown
`project_assignment_profile_id`	Unknown
`repeat_id`	Unknown
`resource_request_queue_id`	Unknown
`rm_approver_1`	Unknown
`rm_approver_2`	Unknown
`rm_approver_3`	Unknown
`schedule_request_item_id`	Unknown
`source_booking_id`	Unknown
`start_date`	LocalDate
`start_time`	Unknown
`updated`	LocalDateTime

customer

Column	Type	Keys
`id`	Unknown	PK
`billing_contact_id`	Unknown	FK
`primary_contact_id`	Unknown	FK
`shipping_contact_id`	Unknown	FK
`sold_to_contact_id`	Unknown	FK
`user_id`	Unknown	FK
`accounting_code`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`address_4`	Unknown
`billing_code`	Unknown
`business_type_id`	Unknown
`city`	Unknown
`company`	Unknown
`company_size_id`	Unknown
`cost_center_id`	Unknown
`country`	Unknown
`created`	LocalDateTime
`credit_invoice_layout_id`	Unknown
`currency`	Unknown
`customer_location_id`	Unknown
`customer_source_id`	Unknown
`email`	Unknown
`external_id`	Unknown
`fax`	Unknown
`invoice_approval_process`	Unknown
`invoice_approver`	Unknown
`invoice_email_text`	Unknown
`invoice_layout_id`	Unknown
`invoice_prefix`	Unknown
`invoice_text`	Unknown
`is_active`	Unknown
`name`	Unknown
`note`	Unknown
`phone`	Unknown
`rate`	Unknown
`state`	Unknown
`statement`	Unknown
`sync_workspace`	Unknown
`term`	Unknown
`territory_id`	Unknown
`type`	Unknown
`updated`	LocalDateTime
`web`	Unknown
`zip`	Unknown