# ServiceTitan schema ERD

Table and field reference for the Fivetran ServiceTitan connector.

## Table & Field Reference

### form_submission_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_submission_id | Unknown | PK, FK |
| type | Unknown |  |

### form_submission_unit_sub_unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_submission_id | Unknown | PK, FK |
| form_submission_unit_section_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

### pricebook_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| active | Unknown |  |
| add_on_member_price | Unknown |  |
| add_on_price | Unknown |  |
| assets | Json |  |
| bonus | Unknown |  |
| budget_cost_code | Unknown |  |
| budget_cost_type | Unknown |  |
| business_unit_id | Unknown |  |
| calculated_price | Unknown |  |
| categories_active | Unknown |  |
| categories_id | Unknown |  |
| categories_name | Unknown |  |
| code | Unknown |  |
| commission_bonus | Unknown |  |
| cost | Unknown |  |
| created_on | Unknown |  |
| cross_sale_group | Unknown |  |
| default_asset_url | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| external_data | Json |  |
| external_id | Unknown |  |
| hours | Unknown |  |
| is_labor | Unknown |  |
| member_price | Unknown |  |
| modified_on | Unknown |  |
| pays_commission | Unknown |  |
| price | Unknown |  |
| recommendations | Unknown |  |
| service_equipment_quantity | Unknown |  |
| service_equipment_sku_id | Unknown |  |
| service_materials_quantity | Unknown |  |
| service_materials_sku_id | Unknown |  |
| sold_by_commission | Unknown |  |
| source | Unknown |  |
| taxable | Unknown |  |
| upgrades | Unknown |  |
| use_static_price | Unknown |  |
| warranty_description | Unknown |  |
| warranty_duration | Unknown |  |

### 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 |  |

### project_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| modified_on | Instant |  |
| name | Unknown |  |
| orders | Unknown |  |

### project_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |
| type_id | Unknown |  |
| value | 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 | PK, FK |
| name | Unknown |  |
| type_id | Unknown |  |
| value | Unknown |  |

### 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 |  |
| role | Unknown |  |
| role_id | Json |  |
| 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 |  |

### zone_zip

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| zip | Unknown |  |

### zone_city

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| city | Unknown |  |

### zone_territory_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| territory_number | Unknown |  |

### zone_locn_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| locn_number | Unknown |  |

### zone_service_day

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| service_day | Unknown |  |

### zone_business_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| business_unit | Unknown |  |

### zone_technician

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| 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 |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown |  |
| created_on | Unknown |  |
| is_archived | Unknown |  |
| modified_by | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| reference_id | Unknown |  |
| title | Unknown |  |

### estimate_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| estimate_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

### equipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown |  |
| active | Unknown |  |
| add_on_member_price | Unknown |  |
| add_on_price | Unknown |  |
| asset_account | Unknown |  |
| assets_alias | Unknown |  |
| assets_file_name | Unknown |  |
| assets_is_default | Unknown |  |
| assets_type | Unknown |  |
| assets_url | Unknown |  |
| bonus | Unknown |  |
| budget_cost_code | Unknown |  |
| budget_cost_type | Unknown |  |
| categories | Unknown |  |
| code | Unknown |  |
| commission_bonus | Unknown |  |
| cost | Unknown |  |
| cost_of_sale_account | Unknown |  |
| created_on | Unknown |  |
| cross_sale_group | Unknown |  |
| default_asset_url | Unknown |  |
| description | Unknown |  |
| dimensions_depth | Unknown |  |
| dimensions_height | Unknown |  |
| dimensions_width | Unknown |  |
| display_in_amount | Unknown |  |
| display_name | Unknown |  |
| equipment_materials_quantity | Unknown |  |
| equipment_materials_sku_id | Unknown |  |
| external_data_key | Unknown |  |
| external_data_value | Unknown |  |
| external_id | Unknown |  |
| general_ledger_account_id | Unknown |  |
| hours | Unknown |  |
| is_configurable_equipment | Unknown |  |
| is_inventory | Unknown |  |
| manufacturer | Unknown |  |
| manufacturer_warranty_description | Unknown |  |
| manufacturer_warranty_duration | Unknown |  |
| member_price | Unknown |  |
| model | Unknown |  |
| modified_on | Unknown |  |
| other_vendors_cost | Unknown |  |
| other_vendors_id | Unknown |  |
| other_vendors_vendor_id | Unknown |  |
| other_vendors_vendor_name | Unknown |  |
| pays_commission | Unknown |  |
| price | Unknown |  |
| primary_vendor_active | Unknown |  |
| primary_vendor_cost | Unknown |  |
| primary_vendor_id | Unknown |  |
| primary_vendor_memo | Unknown |  |
| primary_vendor_name | Unknown |  |
| primary_vendor_part | Unknown |  |
| primary_vendor_sub_account_cost | Unknown |  |
| primary_vendor_sub_account_id | Unknown |  |
| primary_vendor_sub_account_name | Unknown |  |
| primary_vendor_vendor_id | Unknown |  |
| recommendations_sku_id | Unknown |  |
| recommendations_type | Unknown |  |
| service_provider_warranty_description | Unknown |  |
| service_provider_warranty_duration | Unknown |  |
| source | Unknown |  |
| taxable | Unknown |  |
| type_id | Unknown |  |
| unit_of_measure | Unknown |  |
| upgrade | Unknown |  |
| variations_or_configurable_equipment | Unknown |  |

### campaign_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| created_on | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### finding

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| active | Unknown |  |
| archived | Unknown |  |
| created_by | Unknown |  |
| created_on | Unknown |  |
| description | Unknown |  |
| installed_equipment_id | Unknown |  |
| internal_note | Unknown |  |
| modified_by | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| recommended_solution | Unknown |  |
| source_job_id | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| urgency_level | 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 | PK, FK |
| purchase_order_item_id | Unknown | PK, FK |
| number | Unknown |  |

### purchase_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_id | Unknown | PK, FK |
| name | Unknown |  |
| type_id | Unknown |  |
| value | 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_** |  |  |

### location_recurring_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| membership_id | Unknown | FK |
| activated_from_id | Unknown |  |
| active | Unknown |  |
| allocation | Unknown |  |
| business_unit_id | Unknown |  |
| campaign_id | Unknown |  |
| created_by_id | Unknown |  |
| created_on | Unknown |  |
| duration_length | Unknown |  |
| duration_type | Unknown |  |
| estimated_payroll_cost | Unknown |  |
| first_visit_complete | Unknown |  |
| from_date | Unknown |  |
| import_id | Unknown |  |
| invoice_template_for_following_years_id | Unknown |  |
| invoice_template_id | Unknown |  |
| job_start_time | Unknown |  |
| job_summary | Unknown |  |
| job_type_id | Unknown |  |
| memo | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| preferred_technician_ids | Json |  |
| priority | Unknown |  |
| recurrence_day_of_nth_week | Json |  |
| recurrence_days_of_month | Json |  |
| recurrence_days_of_week | Json |  |
| recurrence_interval | Unknown |  |
| recurrence_months | Json |  |
| recurrence_type | Unknown |  |
| recurrence_week | Json |  |
| recurring_service_type_id | Unknown |  |
| tag_type_ids | Json |  |
| to_date | Unknown |  |

### location_recurring_service_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | FK |
| location_recurring_service_id | Unknown | FK |
| membership_id | Unknown | FK |
| created_by_id | Unknown |  |
| created_on | Unknown |  |
| date | Unknown |  |
| modified_on | Unknown |  |
| status | Unknown |  |

### job_type_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_type_id | Unknown | PK, FK |
| skill | Unknown |  |

### job_type_business_unit_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| job_type_id | Unknown | PK, FK |
| 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 |  |

### 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 | PK, FK |
| 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 |  |

### service_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_unit_id | Unknown | FK |
| customer_id | Unknown | FK |
| location_id | Unknown | FK |
| account_manager_id | Unknown |  |
| auto_renew | Unknown |  |
| billing_schedule | Unknown |  |
| billing_schedule_type | Unknown |  |
| billing_service_id | Unknown |  |
| created_by_id | Unknown |  |
| created_on | Unknown |  |
| default_auto_renew | Unknown |  |
| default_campaign_id | Unknown |  |
| default_document_template_id | Unknown |  |
| default_extra_travel_cost_per_hour | Unknown |  |
| default_flat_price | Unknown |  |
| default_labor_cost_per_hour | Unknown |  |
| default_labor_markup_percentage | Unknown |  |
| default_labor_surcharge | Unknown |  |
| default_markup_percentage | Unknown |  |
| default_material_markup_percentage | Unknown |  |
| default_material_surcharge | Unknown |  |
| default_pricing_strategy | Unknown |  |
| default_rate_sheet_id | Unknown |  |
| default_surcharge | Unknown |  |
| default_target_margin_value | Unknown |  |
| default_target_margin_value_type | Unknown |  |
| duration_months | Unknown |  |
| end_date | Unknown |  |
| estimated_gross_margin_amount | Unknown |  |
| estimated_gross_margin_percentage | Unknown |  |
| estimated_labor_cost | Unknown |  |
| estimated_material_cost | Unknown |  |
| estimated_travel_cost | Unknown |  |
| general_ledger_account_id | Unknown |  |
| import_id | Unknown |  |
| imported_deferred_amount | Unknown |  |
| imported_recognized_amount | Unknown |  |
| invoice_cancellation_mode | Unknown |  |
| labor_markup_percentage | Unknown |  |
| labor_surcharge | Unknown |  |
| location_ids | Json |  |
| material_markup_percentage | Unknown |  |
| material_surcharge | Unknown |  |
| modified_by_id | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| negative_liability_service_id | Unknown |  |
| origin | Unknown |  |
| original_template_id | Unknown |  |
| payment_method_id | Unknown |  |
| payment_term_id | Unknown |  |
| positive_income_service_id | Unknown |  |
| rate_sheet_id | Unknown |  |
| renewal_agreement_id | Unknown |  |
| revenue_recognition_mode | Unknown |  |
| sold_by_id | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| summary | Unknown |  |
| tag_type_ids | Json |  |
| total_agreement_price | Unknown |  |

### technician_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| technician_id | Unknown | PK, FK |
| 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 |
| --- | --- | --- |
| 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 |
| id | Unknown |  |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| type_id | Unknown |  |
| value | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| 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_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| name | Unknown |  |
| type_id | Unknown |  |
| value | Unknown |  |

### 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 |  |
| 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_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_id | Unknown | PK, FK |
| name | Unknown |  |
| type_id | 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_** |  |  |

## Relationships

- form_submission_owner(form_submission_id) → form_submission(id)
- form_submission_unit_sub_unit(form_submission_unit_section_id) → form_submission_unit_section(id)
- form_submission_unit_sub_unit(form_submission_id) → form_submission_unit_section(form_submission_id)
- form_submission_unit_section(form_submission_id) → form_submission(id)
- form_submission(created_by_id) → employee(id)
- booking(campaign_id) → campaign(id)
- booking(business_unit_id) → business_unit(id)
- booking(job_id) → job(id)
- booking(job_type_id) → job_type(id)
- gross_pay_item(job_id) → job(id)
- gross_pay_item(invoice_id) → invoice(id)
- gross_pay_item(employee_id) → employee(id)
- gross_pay_item(customer_id) → customer(id)
- gross_pay_item(invoice_item_id) → invoice_item(id)
- gross_pay_item(project_id) → project(id)
- gross_pay_item(location_id) → location(id)
- gross_pay_item(payroll_id) → payroll(id)
- project_custom_field(project_id) → project(id)
- project(sub_status_id) → project_sub_status(id)
- project(status_id) → project_status(id)
- project(customer_id) → customer(id)
- project(location_id) → location(id)
- appointment(job_id) → job(id)
- appointment(customer_id) → customer(id)
- employee_custom_field(employee_id) → employee(id)
- employee(business_unit_id) → business_unit(id)
- job_canceled_log(job_id) → job(id)
- job_canceled_log(reason_id) → job_cancel_reason(id)
- job_canceled_log(created_by_id) → employee(id)
- zone_zip(zone_id) → zone(id)
- zone_city(zone_id) → zone(id)
- zone_territory_number(zone_id) → zone(id)
- zone_locn_number(zone_id) → zone(id)
- zone_service_day(zone_id) → zone(id)
- zone_business_unit(zone_id) → zone(id)
- zone_technician(zone_id) → zone(id)
- zone(created_by) → employee(id)
- estimate_item(estimate_id) → estimate(id)
- estimate_external_link(estimate_id) → estimate(id)
- estimate(business_unit_id) → business_unit(id)
- estimate(job_id) → job(id)
- estimate(customer_id) → customer(id)
- estimate(project_id) → project(id)
- estimate(location_id) → location(id)
- campaign_cost(campaign_id) → campaign(id)
- payment_applied_to(applied_by) → employee(login_name)
- payment_applied_to(payment_id) → payment(id)
- payment(created_by) → employee(login_name)
- payment(customer_id) → customer(id)
- appointment_assignment(technician_id) → technician(id)
- appointment_assignment(appointment_id) → appointment(id)
- appointment_assignment(job_id) → job(id)
- finding(location_id) → location(id)
- invoice_item(business_unit_id) → business_unit(id)
- invoice_item(invoice_id) → invoice(id)
- purchase_order_item_serial_number(purchase_order_id) → purchase_order_item(purchase_order_id)
- purchase_order_item_serial_number(purchase_order_item_id) → purchase_order_item(id)
- purchase_order_item(purchase_order_id) → purchase_order(id)
- purchase_order_custom_field(purchase_order_id) → purchase_order(id)
- purchase_order(technician_id) → technician(id)
- purchase_order(business_unit_id) → business_unit(id)
- purchase_order(job_id) → job(id)
- purchase_order(invoice_id) → invoice(id)
- purchase_order(project_id) → project(id)
- payroll_adjustment(invoice_id) → invoice(id)
- payroll_adjustment(employee_id) → employee(id)
- campaign_phone_number(campaign_id) → campaign(id)
- campaign(category_id) → campaign_category(id)
- payroll(employee_id) → employee(id)
- job_custom_field(job_id) → job(id)
- job(campaign_id) → campaign(id)
- job(business_unit_id) → business_unit(id)
- job(first_appointment_id) → appointment(id)
- job(created_by_id) → employee(id)
- job(invoice_id) → invoice(id)
- job(customer_id) → customer(id)
- job(booking_id) → booking(id)
- job(project_id) → project(id)
- job(location_id) → location(id)
- job(job_type_id) → job_type(id)
- job(last_appointment_id) → appointment(id)
- job(membership_id) → membership(id)
- location_recurring_service(location_id) → location(id)
- location_recurring_service(membership_id) → membership(id)
- location_recurring_service_event(location_recurring_service_id) → location_recurring_service(id)
- location_recurring_service_event(job_id) → job(id)
- location_recurring_service_event(membership_id) → membership(id)
- job_type_skill(job_type_id) → job_type(id)
- job_type_business_unit_id(id) → business_unit(id)
- job_type_business_unit_id(job_type_id) → job_type(id)
- membership(business_unit_id) → business_unit(id)
- membership(created_by_id) → employee(id)
- membership(customer_id) → customer(id)
- membership(membership_type_id) → membership_type(id)
- membership(location_id) → location(id)
- job_split(job_id) → job(id)
- job_split(technician_id) → technician(id)
- membership_type_billing_duration(membership_type_id) → membership_type(id)
- membership_type(created_by_id) → employee(id)
- service_agreement(business_unit_id) → business_unit(id)
- service_agreement(customer_id) → customer(id)
- service_agreement(location_id) → location(id)
- technician_custom_field(technician_id) → technician(id)
- technician(business_unit_id) → business_unit(id)
- team(created_by) → employee(id)
- customer_contact(customer_id) → customer(id)
- lead(campaign_id) → campaign(id)
- lead(business_unit_id) → business_unit(id)
- lead(created_by_id) → employee(id)
- lead(customer_id) → customer(id)
- lead(booking_id) → booking(id)
- lead(location_id) → location(id)
- lead(job_type_id) → job_type(id)
- lead(call_id) → call(id)
- non_job_appointment(technician_id) → technician(id)
- non_job_appointment(created_by_id) → employee(id)
- call(project_id) → project(id)
- call(business_unit_id) → business_unit(id)
- call(job_number) → job(id)
- call(lead_call_reason_id) → call_reason(id)
- call(lead_call_customer_id) → customer(id)
- call(campaign_id) → campaign(id)
- timesheet(technician_id) → technician(id)
- timesheet(appointment_id) → appointment(id)
- timesheet(job_id) → job(id)
- inventory_bill_item(inventory_bill_id) → inventory_bill(id)
- inventory_bill(created_by) → employee(name)
- inventory_bill(job_id) → job(id)
- inventory_bill(business_unit_id) → business_unit(id)
- project_sub_status(status_id) → project_status(id)
- location_custom_field(location_id) → location(id)
- location(zone_id) → zone(id)
- location(created_by_id) → employee(id)
- location(customer_id) → customer(id)
- invoice_custom_field(invoice_id) → invoice(id)
- invoice(project_id) → project(id)
- invoice(customer_id) → customer(id)
- invoice(location_id) → location(id)
- invoice(business_unit_id) → business_unit(id)
- invoice(job_id) → job(id)
- invoice(employee_id) → employee(id)
- location_contact(location_id) → location(id)
- customer_custom_field(customer_id) → customer(id)
- customer(created_by_id) → employee(id)