# JobNimbus schema ERD

Table and field reference for the Fivetran JobNimbus connector.

## Table & Field Reference

### account_setting_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_setting_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### account_setting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| can_access_by_all | Unknown |  |
| icon | Unknown |  |
| is_active | Unknown |  |
| is_sub_contractor | Unknown |  |
| is_supplier | Unknown |  |
| is_vendor | Unknown |  |
| name | Unknown |  |
| object_type | Unknown |  |
| orders | Unknown |  |

### material_order_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| material_order_id | Unknown | PK, FK |
| category | Unknown |  |
| color | Unknown |  |
| cost | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| photos | Json |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| uom | Unknown |  |

### material_order_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| material_order_id | Unknown | PK, FK |

### material_order_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| material_order_id | Unknown | PK, FK |
| name | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |

### material_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| sales_rep | Unknown | FK |
| address | Json |  |
| attachment_id | Unknown |  |
| class_id | Unknown |  |
| class_name | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer_note | Unknown |  |
| date_created | Unknown |  |
| date_material_order | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| duplicate_from_id | Unknown |  |
| esigned | Unknown |  |
| external_id | Unknown |  |
| guid | Unknown |  |
| internal_note | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| location_id | Unknown |  |
| merged | Unknown |  |
| number | Unknown |  |
| recid | Unknown |  |
| rules | Json |  |
| sections | Json |  |
| status | Unknown |  |
| status_name | Unknown |  |
| supplier | Json |  |
| template_id | Unknown |  |
| type | Unknown |  |

### activity_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |

### activity_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| email_status | Unknown |  |
| external_id | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_editable | Unknown |  |
| is_private | Unknown |  |
| is_status_change | Unknown |  |
| location_id | Unknown |  |
| location_parent_id | Unknown |  |
| merged | Unknown |  |
| note | Unknown |  |
| primary_id | Unknown |  |
| primary_name | Unknown |  |
| primary_new_status | Unknown |  |
| primary_number | Unknown |  |
| primary_old_status | Unknown |  |
| primary_type | Unknown |  |
| record_type | Unknown |  |
| record_type_name | Unknown |  |
| rules | Json |  |
| sales_rep | Unknown |  |
| sales_rep_name | Unknown |  |
| source | Unknown |  |
| stack | Unknown |  |
| type | Unknown |  |

### file_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| file_id | Unknown | PK, FK |

### file_related

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| name | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content_type | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| date_created | Unknown |  |
| date_file_created | Unknown |  |
| date_updated | Instant |  |
| description | Unknown |  |
| file_name | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_private | Unknown |  |
| record_type | Unknown |  |
| record_type_name | Unknown |  |
| sales_rep | Unknown |  |
| size | Unknown |  |
| sub_type | Unknown |  |
| type | Unknown |  |
| exif_** |  |  |

### contact_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_time | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| approved_estimate_total | Unknown |  |
| approved_invoice_due | Unknown |  |
| approved_invoice_total | Unknown |  |
| attachment_count | Unknown |  |
| city | Unknown |  |
| class_id | Unknown |  |
| class_name | Unknown |  |
| color | Unknown |  |
| color_shade | Unknown |  |
| company | Unknown |  |
| country_name | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| date_created | Unknown |  |
| date_end | Unknown |  |
| date_start | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| description | Unknown |  |
| disable_auto_text | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| estimated_time | Unknown |  |
| external_id | Unknown |  |
| fax_number | Unknown |  |
| field_assist | Json |  |
| first_name | Unknown |  |
| home_phone | Unknown |  |
| image_id | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_closed | Unknown |  |
| is_lead | Unknown |  |
| is_sub_contractor | Unknown |  |
| is_user | Unknown |  |
| last_budget_gross_margin | Unknown |  |
| last_budget_gross_profit | Unknown |  |
| last_budget_revenue | Unknown |  |
| last_estimate | Unknown |  |
| last_estimate_date_created | Unknown |  |
| last_estimate_date_estimate | Unknown |  |
| last_estimate_jnid | Unknown |  |
| last_estimate_number | Unknown |  |
| last_invoice | Unknown |  |
| last_invoice_date_created | Unknown |  |
| last_invoice_date_invoice | Unknown |  |
| last_invoice_jnid | Unknown |  |
| last_invoice_number | Unknown |  |
| last_name | Unknown |  |
| latitude | Unknown |  |
| location_id | Unknown |  |
| location_name | Unknown |  |
| location_parent_id | Unknown |  |
| longitude | Unknown |  |
| merged | Unknown |  |
| mobile_phone | Unknown |  |
| number | Unknown |  |
| open_edge_id | Unknown |  |
| recid | Unknown |  |
| record_type | Unknown |  |
| record_type_name | Unknown |  |
| related | Json |  |
| rules | Json |  |
| sales_rep | Unknown |  |
| sales_rep_name | Unknown |  |
| source | Unknown |  |
| source_name | Unknown |  |
| state_text | Unknown |  |
| status | Unknown |  |
| status_name | Unknown |  |
| subcontractors | Json |  |
| sunlight_event | Unknown |  |
| sunlight_status_and_id | Unknown |  |
| tags | Json |  |
| task_count | Unknown |  |
| type | Unknown |  |
| website | Unknown |  |
| work_phone | Unknown |  |
| zip | Unknown |  |
| custom_** |  |  |

### estimate_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| estimate_id | Unknown | PK, FK |

### estimate_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| estimate_id | Unknown | PK, FK |
| name | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |

### estimate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| sales_rep | Unknown | FK |
| attachment_id | Unknown |  |
| cost | Unknown |  |
| count | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| date_created | Unknown |  |
| date_estimate | Unknown |  |
| date_sign_requested | Unknown |  |
| date_signed | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| esigned | Unknown |  |
| guid | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| items | Json |  |
| location_id | Unknown |  |
| margin | Unknown |  |
| number | Unknown |  |
| recid | Unknown |  |
| sales_rep_name | Unknown |  |
| sections | Json |  |
| status | Unknown |  |
| status_name | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| template_id | Unknown |  |
| total | Unknown |  |
| type | Unknown |  |

### payment_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| invoice_id | Unknown | FK |
| amount | Unknown |  |
| created_by | Unknown |  |
| date_created | Unknown |  |
| is_active | Unknown |  |

### payment_owner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| payment_id | Unknown | PK, FK |
| id | Unknown |  |

### payment_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| sales_rep | Unknown | FK |
| chargeback_id | Unknown |  |
| count | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| created_by_processor | Unknown |  |
| credit | Unknown |  |
| date_created | Unknown |  |
| date_payment | Unknown |  |
| date_updated | Instant |  |
| global_pay_payment | Unknown |  |
| global_pay_refund | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| location_id | Unknown |  |
| merged | Unknown |  |
| method_id | Unknown |  |
| primary_record | Json |  |
| reference | Unknown |  |
| refund_id | Unknown |  |
| refunded_amount | Unknown |  |
| total | Unknown |  |
| transaction_id | Unknown |  |
| type | Unknown |  |
| wepay_payment_status | Unknown |  |

### work_order_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| work_order_id | Unknown | PK, FK |
| amount | Unknown |  |
| category | Unknown |  |
| color | Unknown |  |
| cost | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| item_type | Unknown |  |
| labor | Unknown |  |
| name | Unknown |  |
| photos | Json |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| uom | Unknown |  |

### work_order_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| work_order_id | Unknown | PK, FK |

### work_order_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| work_order_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |

### work_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| sales_rep | Unknown | FK |
| all_day | Unknown |  |
| all_day_end_date | Unknown |  |
| all_day_start_date | Unknown |  |
| attachment_id | Unknown |  |
| class_id | Unknown |  |
| class_name | Unknown |  |
| count | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer_note | Unknown |  |
| date_created | Unknown |  |
| date_end | Unknown |  |
| date_start | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| esigned | Unknown |  |
| external_id | Unknown |  |
| guid | Unknown |  |
| internal_note | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| location_id | Unknown |  |
| merged | Unknown |  |
| number | Unknown |  |
| parent_approved_estimate_total | Unknown |  |
| parent_approved_invoice_due | Unknown |  |
| parent_approved_invoice_total | Unknown |  |
| parent_fax_number | Unknown |  |
| parent_home_phone | Unknown |  |
| parent_last_estimate | Unknown |  |
| parent_last_invoice | Unknown |  |
| parent_mobile_phone | Unknown |  |
| parent_work_phone | Unknown |  |
| payments | Json |  |
| recid | Unknown |  |
| record_type | Unknown |  |
| record_type_name | Unknown |  |
| rules | Json |  |
| sections | Json |  |
| status | Unknown |  |
| status_name | Unknown |  |
| subcontractors | Json |  |
| supplier | Unknown |  |
| template_id | Unknown |  |
| type | Unknown |  |

### budget_commission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount | Unknown |  |
| date_paid | Unknown |  |
| description | Unknown |  |
| is_amount | Unknown |  |
| is_paid | Unknown |  |
| of | Unknown |  |
| percentage | Unknown |  |
| to_name | Unknown |  |
| to_receiver | Unknown |  |

### budget_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount | Unknown |  |
| description | Unknown |  |
| is_percentage | Unknown |  |
| quantity | Unknown |  |

### budget_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_id | Unknown | PK, FK |

### budget_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### budget

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| sales_rep | Unknown | FK |
| costs | Json |  |
| count | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| date_budget | Unknown |  |
| date_created | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| duplicate_from_id | Unknown |  |
| gross_margin | Unknown |  |
| gross_profit | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| location_id | Unknown |  |
| merged | Unknown |  |
| net_margin | Unknown |  |
| net_profit | Unknown |  |
| number | Unknown |  |
| recid | Unknown |  |
| revenue | Unknown |  |
| status | Unknown |  |
| status_name | Unknown |  |
| total_cost | Unknown |  |
| type | Unknown |  |

### product_uom

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| labor_cost | Unknown |  |
| labor_price | Unknown |  |
| material_cost | Unknown |  |
| material_price | Unknown |  |
| uom | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| created_by | Unknown |  |
| date_created | Unknown |  |
| date_updated | Instant |  |
| description | Unknown |  |
| external_id | Unknown |  |
| is_active | Unknown |  |
| item_type | Unknown |  |
| location_id | Unknown |  |
| name | Unknown |  |
| suppliers | Json |  |
| tax_exempt | Unknown |  |
| type | Unknown |  |

### task_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | PK, FK |

### task_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| name | Unknown |  |
| subject | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_time | Unknown |  |
| all_day | Unknown |  |
| all_day_end_date | Unknown |  |
| all_day_start_date | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| date_created | Unknown |  |
| date_end | Unknown |  |
| date_sort | Unknown |  |
| date_start | Unknown |  |
| date_updated | Instant |  |
| description | Unknown |  |
| estimated_time | Unknown |  |
| external_id | Unknown |  |
| hide_from_calendarview | Unknown |  |
| hide_from_tasklist | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_completed | Unknown |  |
| location_id | Unknown |  |
| merged | Unknown |  |
| number | Unknown |  |
| priority | Unknown |  |
| recid | Unknown |  |
| record_type | Unknown |  |
| record_type_name | Unknown |  |
| rules | Json |  |
| subcontractors | Json |  |
| tags | Json |  |
| title | Unknown |  |
| type | Unknown |  |

### invoice_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |

### invoice_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| name | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| sales_rep | Unknown | FK |
| attachment_id | Unknown |  |
| class_id | Unknown |  |
| class_name | Unknown |  |
| cost | Unknown |  |
| count | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| date_created | Unknown |  |
| date_due | Unknown |  |
| date_invoice | Unknown |  |
| date_paid_in_full | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| due | Unknown |  |
| duplicate_from_id | Unknown |  |
| esigned | Unknown |  |
| external_id | Unknown |  |
| first_payment_date | Unknown |  |
| guid | Unknown |  |
| internal_note | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| items | Json |  |
| location_id | Unknown |  |
| margin | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| payments | Json |  |
| recid | Unknown |  |
| sections | Json |  |
| status | Unknown |  |
| status_name | Unknown |  |
| subtotal | Unknown |  |
| supplier | Unknown |  |
| tax | Unknown |  |
| template_id | Unknown |  |
| terms | Unknown |  |
| total | Unknown |  |
| total_paid | Unknown |  |
| type | Unknown |  |
| version | Unknown |  |

### job_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |

### job_related

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |
| name | Unknown |  |
| subject | Unknown |  |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_time | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| all_day | Unknown |  |
| all_day_end_date | Unknown |  |
| all_day_start_date | Unknown |  |
| approved_estimate_total | Unknown |  |
| approved_invoice_due | Unknown |  |
| approved_invoice_total | Unknown |  |
| attachment_count | Unknown |  |
| city | Unknown |  |
| class_id | Unknown |  |
| class_name | Unknown |  |
| country_name | Unknown |  |
| created_by | Unknown |  |
| created_by_name | Unknown |  |
| customer | Unknown |  |
| date_created | Unknown |  |
| date_end | Unknown |  |
| date_start | Unknown |  |
| date_status_change | Unknown |  |
| date_updated | Instant |  |
| description | Unknown |  |
| estimated_time | Unknown |  |
| external_id | Unknown |  |
| field_assist | Json |  |
| image_id | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_closed | Unknown |  |
| is_lead | Unknown |  |
| last_budget_gross_margin | Unknown |  |
| last_budget_gross_profit | Unknown |  |
| last_budget_revenue | Unknown |  |
| last_estimate | Unknown |  |
| last_estimate_date_created | Unknown |  |
| last_estimate_date_estimate | Unknown |  |
| last_estimate_jnid | Unknown |  |
| last_estimate_number | Unknown |  |
| last_invoice | Unknown |  |
| last_invoice_date_created | Unknown |  |
| last_invoice_date_invoice | Unknown |  |
| last_invoice_jnid | Unknown |  |
| last_invoice_number | Unknown |  |
| latitude | Unknown |  |
| location_id | Unknown |  |
| location_parent_id | Unknown |  |
| longitude | Unknown |  |
| merged | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| open_edge_id | Unknown |  |
| parent_approved_estimate_total | Unknown |  |
| parent_approved_invoice_due | Unknown |  |
| parent_approved_invoice_total | Unknown |  |
| parent_fax_number | Unknown |  |
| parent_home_phone | Unknown |  |
| parent_last_estimate | Unknown |  |
| parent_last_invoice | Unknown |  |
| parent_mobile_phone | Unknown |  |
| parent_work_phone | Unknown |  |
| recid | Unknown |  |
| record_type | Unknown |  |
| record_type_name | Unknown |  |
| rules | Json |  |
| sales_rep | Unknown |  |
| sales_rep_name | Unknown |  |
| source | Unknown |  |
| source_name | Unknown |  |
| state_text | Unknown |  |
| status | Unknown |  |
| status_name | Unknown |  |
| subcontractors | Json |  |
| sunlight_events | Unknown |  |
| sunlight_status_and_id | Unknown |  |
| tags | Json |  |
| task_count | Unknown |  |
| type | Unknown |  |
| zip | Unknown |  |

## Relationships

- account_setting_status(account_setting_id) → account_setting(id)
- material_order_item(material_order_id) → material_order(id)
- material_order_owner(material_order_id) → material_order(id)
- material_order_related(material_order_id) → material_order(id)
- material_order(sales_rep) → contact(sales_rep)
- material_order(customer) → contact(customer)
- activity_owner(activity_id) → activity(id)
- activity_related(activity_id) → activity(id)
- file_owner(file_id) → file(id)
- file_related(id) → contact(id)
- file_related(file_id) → file(id)
- contact_owner(contact_id) → contact(id)
- estimate_owner(estimate_id) → estimate(id)
- estimate_related(estimate_id) → estimate(id)
- estimate(sales_rep) → contact(sales_rep)
- estimate(customer) → contact(customer)
- payment_invoice(invoice_id) → invoice(id)
- payment_invoice(payment_id) → payment(id)
- payment_owner(payment_id) → payment(id)
- payment_related(payment_id) → payment(id)
- payment(sales_rep) → contact(sales_rep)
- payment(customer) → contact(customer)
- work_order_item(work_order_id) → work_order(id)
- work_order_owner(work_order_id) → work_order(id)
- work_order_related(work_order_id) → work_order(id)
- work_order(sales_rep) → contact(sales_rep)
- work_order(customer) → contact(customer)
- budget_commission(budget_id) → budget(id)
- budget_cost(budget_id) → budget(id)
- budget_owner(budget_id) → budget(id)
- budget_related(budget_id) → budget(id)
- budget(sales_rep) → contact(sales_rep)
- budget(customer) → contact(customer)
- product_uom(product_id) → product(id)
- product(customer) → contact(customer)
- task_owner(task_id) → task(id)
- task_related(id) → contact(id)
- task_related(task_id) → task(id)
- invoice_owner(invoice_id) → invoice(id)
- invoice_related(invoice_id) → invoice(id)
- invoice(sales_rep) → contact(sales_rep)
- invoice(customer) → contact(customer)
- job_owner(job_id) → job(id)
- job_related(id) → contact(id)
- job_related(job_id) → job(id)