JobNimbus
Explore the interactive ERD
Table & Field Reference
account_setting_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_setting_id | Unknown | PKFK |
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 |
|---|---|---|
id | Unknown | PK |
material_order_id | Unknown | PKFK |
category | Unknown | |
color | Unknown | |
cost | Unknown | |
description | 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 | PKFK |
material_order_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
material_order_id | Unknown | PKFK |
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 | PKFK |
activity_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_id | Unknown | PKFK |
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 | PKFK |
file_related
| Column | Type | Keys |
|---|---|---|
file_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
estimate_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
estimate_id | Unknown | PKFK |
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 | PKFK |
invoice_id | Unknown | FK |
amount | Unknown | |
created_by | Unknown | |
date_created | Unknown | |
is_active | Unknown |
payment_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_id | Unknown | PKFK |
payment_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
payment_id | Unknown | PKFK |
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 |
|---|---|---|
id | Unknown | PK |
work_order_id | Unknown | PKFK |
amount | Unknown | |
category | Unknown | |
color | Unknown | |
cost | Unknown | |
description | 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 | PKFK |
work_order_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
work_order_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
amount | Unknown | |
description | Unknown | |
is_percentage | Unknown | |
quantity | Unknown |
budget_owner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_id | Unknown | PKFK |
budget_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
budget_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
task_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
task_id | Unknown | PKFK |
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 | PKFK |
invoice_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
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 | PKFK |
job_related
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
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 |