ServiceTitan
Explore the interactive ERD
Table & Field Reference
form_submission_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_submission_id | Unknown | PKFK |
type | Unknown |
form_submission_unit_sub_unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_submission_id | Unknown | PKFK |
form_submission_unit_section_id | Unknown | PKFK |
attachments | Json | |
comment | Unknown | |
name | Unknown | |
option | Unknown | |
type | Unknown | |
value | Unknown | |
values | Json |
form_submission_unit_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_submission_id | Unknown | PKFK |
attachments | Json | |
comment | Unknown | |
description | Unknown | |
name | Unknown | |
option | Unknown | |
type | Unknown | |
value | Unknown | |
values | Json |
form_submission
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
form_id | Unknown | |
form_name | Unknown | |
status | Unknown | |
submitted_on | Unknown |
booking
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
campaign_id | Unknown | FK |
job_id | Unknown | FK |
job_type_id | Unknown | FK |
active | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
address_unit | Unknown | |
address_zip | Unknown | |
booking_provider_id | Unknown | |
created_on | Unknown | |
customer_type | Json | |
dismissing_reason_id | Unknown | |
external_id | Unknown | |
is_first_time_client | Unknown | |
is_send_confirmation_email | Unknown | |
modified_on | Instant | |
name | Unknown | |
priority | Unknown | |
source | Unknown | |
start | Unknown | |
status | Unknown | |
summary | Unknown | |
uploaded_image | Json |
gross_pay_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
employee_id | Unknown | FK |
invoice_id | Unknown | FK |
invoice_item_id | Unknown | FK |
job_id | Unknown | FK |
location_id | Unknown | FK |
payroll_id | Unknown | FK |
project_id | Unknown | FK |
active | Unknown | |
activity | Unknown | |
activity_code | Unknown | |
activity_code_id | Unknown | |
amount | Unknown | |
amount_adjustment | Unknown | |
budget_code_id | Unknown | |
business_unit_name | Unknown | |
created_on | Unknown | |
date | Unknown | |
employee_payroll_id | Unknown | |
employee_type | Json | |
ended_on | Unknown | |
gross_pay_item_type | Json | |
invoice_number | Unknown | |
is_prevailing_wage_job | Unknown | |
labor_type_code | Unknown | |
labor_type_id | Unknown | |
memo | Unknown | |
modified_on | Unknown | |
paid_duration_hour | Unknown | |
paid_time_type | Json | |
payout_business_unit_name | Unknown | |
source_entity_id | Unknown | |
started_on | Unknown | |
tax_zone_name | Unknown | |
zone_name | Unknown |
technician_payroll_setting_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
technician_payroll_setting_technician_id | Unknown | PKFK |
name | Unknown | |
type_id | Unknown | |
value | Unknown |
technician_payroll_setting
| Column | Type | Keys |
|---|---|---|
technician_id | Unknown | PKFK |
manager_id | Unknown | FK |
payroll_business_unit_id | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
employee_type | Unknown | |
external_payroll_id | Unknown | |
hire_date | Unknown | |
hourly_rate | Unknown | |
is_included_in_payroll | Unknown | |
modified_on | Unknown |
project_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
modified_on | Instant | |
name | Unknown | |
orders | Unknown |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
location_id | Unknown | FK |
status_id | Unknown | FK |
sub_status_id | Unknown | FK |
active | Unknown | |
actual_completion_date | Unknown | |
business_unit_ids | Json | |
created_on | Unknown | |
job_id | Json | |
modified_on | Instant | |
name | Unknown | |
number | Unknown | |
project_manager_id | Json | |
project_type_id | Unknown | |
start_date | Unknown | |
status | Unknown | |
sub_status | Unknown | |
summary | Unknown | |
target_completion_date | Unknown | |
custom_** |
appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
job_id | Unknown | FK |
active | Unknown | |
appointment_number | Unknown | |
arrival_window_end | Unknown | |
arrival_window_start | Unknown | |
created_by_id | Unknown | |
created_on | Unknown | |
ends | Unknown | |
is_confirmed | Unknown | |
modified_on | Instant | |
special_instruction | Unknown | |
start | Unknown | |
status | Unknown | |
unused | Unknown |
employee_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_id | Unknown | PKFK |
name | Unknown | |
type_id | Unknown | |
value | Unknown |
employee_role
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
id | Unknown | PKFK |
employee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
aad_user_id | Unknown | |
active | Unknown | |
created_on | Unknown | |
email | Unknown | |
login_name | Unknown | |
modified_on | Instant | |
name | Unknown | |
user_id | Unknown |
job_canceled_log
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
job_id | Unknown | FK |
reason_id | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
memo | Unknown |
employee_payroll_setting_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
employee_payroll_setting_employee_id | Unknown | PKFK |
name | Unknown | |
type_id | Unknown | |
value | Unknown |
employee_payroll_setting
| Column | Type | Keys |
|---|---|---|
employee_id | Unknown | PKFK |
manager_id | Unknown | FK |
payroll_business_unit_id | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
employee_type | Unknown | |
external_payroll_id | Unknown | |
hire_date | Unknown | |
hourly_rate | Unknown | |
is_included_in_payroll | Unknown | |
modified_on | Unknown |
zone_zip
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
zip | Unknown |
zone_city
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
city | Unknown |
zone_territory_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
territory_number | Unknown |
zone_locn_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
locn_number | Unknown |
zone_service_day
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
service_day | Unknown |
zone_business_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
business_unit | Unknown |
zone_technician
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
zone_id | Unknown | PKFK |
technician | Unknown |
zone
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
modified_on | Unknown | |
name | Unknown | |
service_days_enabled | Unknown |
estimate_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
estimate_id | Unknown | PKFK |
created_on | Unknown | |
description | Unknown | |
item_group_name | Unknown | |
item_group_root_id | Unknown | |
membership_type_id | Unknown | |
modified_on | Unknown | |
qty | Unknown | |
sku_account | Unknown | |
sku_display_name | Unknown | |
sku_general_ledger_account_id | Unknown | |
sku_general_ledger_account_name | Unknown | |
sku_id | Unknown | |
sku_modified_on | Unknown | |
sku_name | Unknown | |
sku_sold_hours | Unknown | |
sku_type | Unknown | |
total | Unknown | |
total_cost | Unknown | |
unit_cost | Unknown | |
unit_rate | Unknown |
estimate_external_link
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
estimate_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
estimate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
customer_id | Unknown | FK |
job_id | Unknown | FK |
location_id | Unknown | FK |
project_id | Unknown | FK |
active | Unknown | |
business_unit_name | Unknown | |
created_on | Unknown | |
modified_on | Instant | |
name | Unknown | |
sold_by | Unknown | |
sold_on | Unknown | |
status_name | Unknown | |
status_value | Unknown | |
subtotal | Unknown | |
summary | Unknown |
campaign_cost
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | FK |
daily_cost | Unknown | |
month | Unknown | |
year | Unknown |
payment_applied_to
| Column | Type | Keys |
|---|---|---|
applied_id | Unknown | PK |
applied_by | Unknown | FK |
payment_id | Unknown | FK |
applied_amount | Unknown | |
applied_on | Unknown | |
applied_to | Unknown |
payment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
customer_id | Unknown | FK |
active | Unknown | |
auth_code | Unknown | |
batch_id | Unknown | |
batch_name | Unknown | |
batch_number | Unknown | |
check_number | Unknown | |
created_on | Unknown | |
date | Unknown | |
general_ledger_account_detail_type | Unknown | |
general_ledger_account_id | Unknown | |
general_ledger_account_name | Unknown | |
general_ledger_account_number | Unknown | |
general_ledger_account_type | Unknown | |
memo | Unknown | |
modified_on | Instant | |
reference_number | Unknown | |
sync_status | Unknown | |
total | Unknown | |
type | Unknown | |
type_id | Unknown | |
unapplied_amount | Unknown | |
custom_** |
job_cancel_reason
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created_on | Unknown | |
modified_on | Unknown | |
name | Unknown |
task_priority
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
task_resolution_type
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
task_status
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
task_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
excluded_task_resolution_id | Json | |
name | Unknown |
task_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
name | Unknown |
task_resolution
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
excluded_task_type_id | Json | |
name | Unknown | |
type | Unknown |
call_reason
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created_on | Unknown | |
is_lead | Unknown | |
modified_on | Unknown | |
name | Unknown |
appointment_assignment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
technician_id | Unknown | PKFK |
appointment_id | Unknown | FK |
job_id | Unknown | FK |
active | Unknown | |
assigned_by_id | Unknown | |
assigned_on | Unknown | |
is_paused | Unknown | |
status | Unknown | |
technician_name | Unknown |
job_hold_reason
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created_on | Unknown | |
modified_on | Instant | |
name | Unknown |
campaign_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created_on | Unknown | |
name | Unknown | |
type | Unknown |
business_unit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_code | Unknown | |
acknowledgement_paragraph | Unknown | |
active | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
address_unit | Unknown | |
address_zip | Unknown | |
authorization_paragraph | Unknown | |
concept_code | Unknown | |
corporate_contract_number | Unknown | |
created_on | Unknown | |
currency | Unknown | |
default_tax_rate | Unknown | |
email | Unknown | |
franchise_id | Unknown | |
invoice_header | Unknown | |
invoice_message | Unknown | |
material_sku | Unknown | |
modified_on | Instant | |
name | Unknown | |
official_name | Unknown | |
phone_number | Unknown | |
quickbooks_class | Unknown | |
tenant_account_code | Unknown | |
tenant_concept_code | Unknown | |
tenant_franchise_id | Unknown | |
tenant_id | Unknown | |
tenant_modified_on | Unknown | |
tenant_name | Unknown | |
custom_** |
invoice_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
invoice_id | Unknown | FK |
active | Unknown | |
asset_account_detail_type | Unknown | |
asset_account_id | Unknown | |
asset_account_name | Unknown | |
asset_account_number | Unknown | |
asset_account_type | Unknown | |
cost | Unknown | |
cost_of_sale_account_detail_type | Unknown | |
cost_of_sale_account_id | Unknown | |
cost_of_sale_account_name | Unknown | |
cost_of_sale_account_number | Unknown | |
cost_of_sale_account_type | Unknown | |
description | Unknown | |
display_name | Unknown | |
general_ledger_account_detail_type | Unknown | |
general_ledger_account_id | Unknown | |
general_ledger_account_name | Unknown | |
general_ledger_account_number | Unknown | |
general_ledger_account_type | Unknown | |
inventory | Unknown | |
inventory_location | Unknown | |
item_group_name | Unknown | |
item_group_root_id | Unknown | |
membership_type_id | Unknown | |
modified_on | Instant | |
orders | Unknown | |
price | Unknown | |
quantity | Unknown | |
service_date | Unknown | |
sku_id | Unknown | |
sku_name | Unknown | |
sold_hours | Unknown | |
taxable | Unknown | |
total | Unknown | |
total_cost | Unknown | |
type | Unknown |
purchase_order_item_serial_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
purchase_order_item_id | Unknown | PKFK |
number | Unknown |
purchase_order_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
budget_code_id | Unknown | |
chargeable | Unknown | |
cost | Unknown | |
created_on | Unknown | |
description | Unknown | |
modified_on | Unknown | |
quantity | Unknown | |
quantity_received | Unknown | |
sku_code | Unknown | |
sku_id | Unknown | |
sku_name | Unknown | |
sku_type | Unknown | |
status | Unknown | |
total | Unknown | |
vendor_part_number | Unknown |
purchase_order_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
purchase_order_id | Unknown | PKFK |
name | Unknown | |
type_id | Unknown | |
value | Unknown |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
invoice_id | Unknown | FK |
job_id | Unknown | FK |
project_id | Unknown | FK |
technician_id | Unknown | FK |
active | Unknown | |
batch_id | Unknown | |
budget_code_id | Unknown | |
created_on | Unknown | |
date | Unknown | |
inventory_location_id | Unknown | |
modified_on | Unknown | |
number | Unknown | |
received_on | Unknown | |
required_on | Unknown | |
sent_on | Unknown | |
ship_to_city | Unknown | |
ship_to_country | Unknown | |
ship_to_state | Unknown | |
ship_to_street | Unknown | |
ship_to_unit | Unknown | |
ship_to_zip | Unknown | |
shipping | Unknown | |
status | Unknown | |
summary | Unknown | |
tax | Unknown | |
total | Unknown | |
type_id | Unknown | |
vendor_document_number | Unknown | |
vendor_id | Unknown |
timesheet_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
applicable_employee_type | Unknown | |
code | Unknown | |
created_on | Unknown | |
custom_hourly_rate | Unknown | |
description | Unknown | |
hourly_rate | Unknown | |
modified_on | Unknown | |
rate_multiplier | Unknown | |
type | Unknown |
payroll_adjustment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
invoice_id | Unknown | FK |
active | Unknown | |
activity_code_id | Unknown | |
amount | Unknown | |
created_on | Unknown | |
employee_type | Unknown | |
hours | Unknown | |
memo | Unknown | |
modified_on | Unknown | |
posted_on | Unknown | |
rate | Unknown |
campaign_phone_number
| Column | Type | Keys |
|---|---|---|
phone_number | Unknown | PK |
campaign_id | Unknown | PKFK |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
active | Unknown | |
business_unit | Unknown | |
category_active | Unknown | |
category_name | Unknown | |
created_on | Unknown | |
medium | Unknown | |
modified_on | Instant | |
name | Unknown | |
other_medium | Unknown | |
other_source | Unknown | |
source | Unknown |
payroll
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
employee_id | Unknown | FK |
active | Unknown | |
burden_rate | Unknown | |
created_on | Unknown | |
employee_type | Unknown | |
ended_on | Unknown | |
manager_approved_on | Unknown | |
modified_on | Unknown | |
started_on | Unknown | |
status | Unknown |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
booking_id | Unknown | FK |
business_unit_id | Unknown | FK |
campaign_id | Unknown | FK |
created_by_id | Unknown | FK |
customer_id | Unknown | FK |
first_appointment_id | Unknown | FK |
invoice_id | Unknown | FK |
job_type_id | Unknown | FK |
last_appointment_id | Unknown | FK |
location_id | Unknown | FK |
membership_id | Unknown | FK |
project_id | Unknown | FK |
active | Unknown | |
completed_on | Unknown | |
created_from_estimate_id | Unknown | |
created_on | Unknown | |
customer_po | Unknown | |
estimate_id | Json | |
job_generated_lead_source_employee_id | Unknown | |
job_generated_lead_source_job_id | Unknown | |
job_number | Unknown | |
job_status | Unknown | |
lead_call_id | Unknown | |
modified_on | Instant | |
no_charge | Unknown | |
notifications_enabled | Unknown | |
partner_lead_call_id | Unknown | |
priority | Unknown | |
recall_for_id | Unknown | |
sold_by_id | Unknown | |
summary | Unknown | |
tag_type_id | Json | |
warranty_id | Unknown | |
custom_** |
job_type_skill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_type_id | Unknown | PKFK |
skill | Unknown |
job_type_business_unit_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_type_id | Unknown | PKFK |
id | Unknown | FK |
job_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
class | Unknown | |
duration | Unknown | |
enforce_recurring_service_event_selection | Unknown | |
invoice_signature_required | Unknown | |
modified_on | Instant | |
name | Unknown | |
no_charge | Unknown | |
priority | Unknown | |
sold_threshold | Unknown | |
summary | Unknown | |
tag_type_id | Json | |
custom_** |
tag_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
allow_to_use_on_timesheet_activity | Unknown | |
code | Unknown | |
color | Unknown | |
created_on | Unknown | |
importance | Json | |
is_conversion_opportunity | Unknown | |
modified_on | Unknown | |
name | Unknown |
membership
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
created_by_id | Unknown | FK |
customer_id | Unknown | FK |
location_id | Unknown | FK |
membership_type_id | Unknown | FK |
activated_by_id | Unknown | |
activated_from_id | Unknown | |
active | Unknown | |
billing_frequency | Unknown | |
billing_template_id | Unknown | |
cancellation_balance_invoice_id | Unknown | |
cancellation_date | Unknown | |
cancellation_invoice_id | Unknown | |
created_on | Unknown | |
customer_po | Unknown | |
duration | Unknown | |
follow_up_custom_status_id | Unknown | |
follow_up_on | Unknown | |
follow_up_status | Unknown | |
from_date | Unknown | |
import_id | Unknown | |
initial_deferred_revenue | Unknown | |
memo | Unknown | |
modified_on | Unknown | |
next_scheduled_bill_date | Unknown | |
payment_method_id | Unknown | |
payment_type_id | Unknown | |
recurring_location_id | Unknown | |
renewal_billing_frequency | Unknown | |
renewal_duration | Unknown | |
renewal_membership_task_id | Unknown | |
renewed_by_id | Unknown | |
sold_by_id | Unknown | |
status | Unknown | |
to_date | Unknown |
user_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
created_on | Unknown | |
employee_type | Unknown | |
name | Unknown | |
role_source | Unknown |
job_split
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
technician_id | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
modified_on | Instant | |
split | Unknown |
membership_type_billing_duration
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
membership_type_id | Unknown | PKFK |
billing_frequency | Json | |
duration | Unknown |
membership_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
active | Unknown | |
auto_calculate_invoice_template | Unknown | |
billing_template_id | Unknown | |
created_on | Unknown | |
discount_mode | Json | |
display_name | Unknown | |
import_id | Unknown | |
location_target | Json | |
modified_on | Unknown | |
name | Unknown | |
revenue_recognition_mode | Json | |
show_membership_saving | Unknown | |
use_membership_pricing_table | Unknown |
technician_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
technician_id | Unknown | PKFK |
name | Unknown | |
type_id | Unknown | |
value | Unknown |
technician
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
aad_user_id | Unknown | |
active | Unknown | |
burden_rate | Unknown | |
created_on | Unknown | |
daily_goal | Unknown | |
email | Unknown | |
home_city | Unknown | |
home_country | Unknown | |
home_latitude | Unknown | |
home_longitude | Unknown | |
home_state | Unknown | |
home_street | Unknown | |
home_street_address | Unknown | |
home_unit | Unknown | |
home_zip | Unknown | |
is_managed_tech | Unknown | |
login_name | Unknown | |
main_zone_id | Unknown | |
modified_on | Instant | |
name | Unknown | |
phone_number | Unknown | |
role_id | Json | |
team | Unknown | |
user_id | Unknown | |
zone_id | Json |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
modified_on | Unknown | |
name | Unknown |
customer_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
active | Unknown | |
memo | Unknown | |
modified_on | Instant | |
phone_settings_do_not_text | Unknown | |
phone_settings_phone_number | Unknown | |
type | Unknown | |
value | Unknown |
lead
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
booking_id | Unknown | FK |
business_unit_id | Unknown | FK |
call_id | Unknown | FK |
campaign_id | Unknown | FK |
created_by_id | Unknown | FK |
customer_id | Unknown | FK |
job_type_id | Unknown | FK |
location_id | Unknown | FK |
active | Unknown | |
call_reason_id | Unknown | |
capture_source | Unknown | |
city | Unknown | |
country | Unknown | |
created_on | Unknown | |
customer_name | Unknown | |
dismissing_reason_id | Unknown | |
email | Unknown | |
follow_up_date | Unknown | |
manual_call_id | Unknown | |
modified_on | Instant | |
phone | Unknown | |
priority | Unknown | |
state | Unknown | |
status | Unknown | |
street | Unknown | |
summary | Unknown | |
tag_type_id | Json | |
unit | Unknown | |
url | Unknown | |
zip | Unknown |
non_job_appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
technician_id | Unknown | FK |
active | Unknown | |
all_day | Unknown | |
clear_dispatch_board | Unknown | |
clear_technician_view | Unknown | |
created_on | Unknown | |
duration | Unknown | |
name | Unknown | |
remove_technician_from_capacity_planning | Unknown | |
start | Unknown | |
summary | Unknown | |
timesheet_code_id | Unknown |
call
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lead_call_id | Unknown | PK |
business_unit_id | Unknown | FK |
campaign_id | Unknown | FK |
job_number | Unknown | FK |
lead_call_customer_id | Unknown | FK |
lead_call_reason_id | Unknown | FK |
project_id | Unknown | FK |
lead_call_active | Unknown | |
lead_call_agent_external_id | Unknown | |
lead_call_agent_id | Unknown | |
lead_call_agent_name | Unknown | |
lead_call_call_type | Unknown | |
lead_call_created_by | Unknown | |
lead_call_created_on | Unknown | |
lead_call_direction | Unknown | |
lead_call_duration | Unknown | |
lead_call_from | Unknown | |
lead_call_modified_on | Unknown | |
lead_call_reason | Unknown | |
lead_call_received_on | Unknown | |
lead_call_recording_url | Unknown | |
lead_call_to | Unknown | |
lead_call_voice_mail_url | Unknown | |
type_id | Unknown | |
type_modified_on | Unknown | |
type_name | Unknown |
timesheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | FK |
job_id | Unknown | FK |
technician_id | Unknown | FK |
active | Unknown | |
arrived_on | Unknown | |
canceled_on | Unknown | |
created_on | Unknown | |
dispatched_on | Unknown | |
done_on | Unknown | |
modified_on | Unknown |
inventory_bill_item
| Column | Type | Keys |
|---|---|---|
orders | Unknown | PK |
sku_id | Unknown | PK |
inventory_bill_id | Unknown | PKFK |
asset_account_detail_type | Unknown | |
asset_account_id | Unknown | |
asset_account_name | Unknown | |
asset_account_number | Unknown | |
asset_account_type | Unknown | |
budget_code_id | Unknown | |
cost | Unknown | |
cost_of_sale_account_detail_type | Unknown | |
cost_of_sale_account_id | Unknown | |
cost_of_sale_account_name | Unknown | |
cost_of_sale_account_number | Unknown | |
cost_of_sale_account_type | Unknown | |
description | Unknown | |
general_ledger_account_detail_type | Unknown | |
general_ledger_account_id | Unknown | |
general_ledger_account_name | Unknown | |
general_ledger_account_number | Unknown | |
general_ledger_account_type | Unknown | |
inventory_location | Unknown | |
name | Unknown | |
quantity | Unknown | |
receipt_item_id | Unknown | |
serial_number | Unknown | |
sku_code | Unknown | |
sku_type | Unknown |
inventory_bill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
created_by | Unknown | FK |
job_id | Unknown | FK |
active | Unknown | |
batch_id | Unknown | |
batch_name | Unknown | |
batch_number | Unknown | |
bill_amount | Unknown | |
bill_date | Unknown | |
budget_code_id | Unknown | |
created_on | Unknown | |
due_date | Unknown | |
job_number | Unknown | |
modified_on | Unknown | |
post_date | Unknown | |
purchase_order_id | Unknown | |
reference_number | Unknown | |
ship_to_city | Unknown | |
ship_to_country | Unknown | |
ship_to_description | Unknown | |
ship_to_state | Unknown | |
ship_to_street | Unknown | |
ship_to_unit | Unknown | |
ship_to_zip | Unknown | |
shipping_amount | Unknown | |
summary | Unknown | |
sync_status | Unknown | |
tax_amount | Unknown | |
tax_zone | Unknown | |
term_name | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_number | Unknown | |
custom_** |
project_sub_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
status_id | Unknown | FK |
modified_on | Instant | |
name | Unknown | |
orders | Unknown |
location_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
location_id | Unknown | PKFK |
name | Unknown | |
type_id | Unknown | |
value | Unknown |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
created_by_id | Unknown | FK |
zone_id | Unknown | FK |
active | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_latitude | Unknown | |
address_longitude | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
address_unit | Unknown | |
address_zip | Unknown | |
created_on | Unknown | |
merged_to_id | Unknown | |
modified_on | Instant | |
name | Unknown | |
tag_type_id | Json | |
tax_zone_id | Unknown | |
custom_** |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_unit_id | Unknown | FK |
customer_id | Unknown | FK |
employee_id | Unknown | FK |
job_id | Unknown | FK |
location_id | Unknown | FK |
project_id | Unknown | FK |
active | Unknown | |
adjustment_to_id | Unknown | |
balance | Unknown | |
batch_id | Unknown | |
batch_name | Unknown | |
batch_number | Unknown | |
commission_eligibility_date | Unknown | |
created_by | Unknown | |
created_on | Unknown | |
custom_fields | Json | |
deposited_on | Unknown | |
due_date | Unknown | |
employee_modified_on | Unknown | |
invoice_date | Unknown | |
invoice_type_id | Unknown | |
invoice_type_name | Unknown | |
items | Unknown | |
job_type | Unknown | |
modified_on | Instant | |
reference_number | Unknown | |
royalty_date | Unknown | |
royalty_memo | Unknown | |
royalty_sent_on | Unknown | |
royalty_status | Unknown | |
sales_tax | Unknown | |
sales_tax_code_id | Unknown | |
sales_tax_code_name | Unknown | |
sales_tax_code_rate | Unknown | |
sub_total | Unknown | |
summary | Unknown | |
sync_status | Unknown | |
term_name | Unknown | |
total | Unknown |
location_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
active | Unknown | |
created_on | Unknown | |
memo | Unknown | |
modified_on | Instant | |
phone_settings_do_not_text | Unknown | |
phone_settings_phone_number | Unknown | |
preference | Unknown | |
type | Unknown | |
value | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
active | Unknown | |
balance | Unknown | |
created_on | Unknown | |
do_not_mail | Unknown | |
do_not_service | Unknown | |
merged_to_id | Unknown | |
modified_on | Instant | |
name | Unknown | |
tag_type_id | Json | |
type | Unknown | |
custom_** |