AccuLynx
Explore the interactive ERD
Table & Field Reference
contact_email_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | PKFK |
address | Unknown | |
is_primary | Unknown | |
type | Unknown |
contact_phone_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | PKFK |
ext | Unknown | |
is_primary | Unknown | |
number | Unknown | |
type | Unknown |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
billing_address_city | Unknown | |
billing_address_country_abbreviation | Unknown | |
billing_address_country_id | Unknown | |
billing_address_country_name | Unknown | |
billing_address_state_abbreviation | Unknown | |
billing_address_state_id | Unknown | |
billing_address_state_name | Unknown | |
billing_address_street_1 | Unknown | |
billing_address_street_2 | Unknown | |
billing_address_zip_code | Unknown | |
company_name | Unknown | |
cross_reference | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
mailing_address_city | Unknown | |
mailing_address_country_abbreviation | Unknown | |
mailing_address_country_id | Unknown | |
mailing_address_country_name | Unknown | |
mailing_address_state_abbreviation | Unknown | |
mailing_address_state_id | Unknown | |
mailing_address_state_name | Unknown | |
mailing_address_street_1 | Unknown | |
mailing_address_street_2 | Unknown | |
mailing_address_zip_code | Unknown | |
salutation | Unknown |
estimate_section_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
estimate_id | Unknown | PKFK |
estimate_section_id | Unknown | PKFK |
description | Unknown | |
estimate_unit | Unknown | |
fixed_price | Unknown | |
labour_cost | Unknown | |
material_cost | Unknown | |
measurement_quantity | Unknown | |
name | Unknown | |
order_quantity | Unknown | |
order_unit | Unknown | |
override_name | Unknown | |
price | Unknown | |
quantity | Unknown | |
selected_unit | Unknown | |
total_price | Unknown | |
type | Unknown | |
unit_coversion | Unknown | |
waste | Unknown |
estimate_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
estimate_id | Unknown | PKFK |
created_by_id | Unknown | FK |
modified_by_id | Unknown | FK |
created_date | Unknown | |
description | Unknown | |
modified_date | Unknown | |
profit_margin_rate | Unknown | |
profit_margin_total | Unknown | |
section_financial_overhead_rate | Unknown | |
section_financial_overhead_total | Unknown | |
section_financial_profit_rate | Unknown | |
section_financial_profit_total | Unknown | |
section_financial_tax_rate | Unknown | |
section_financial_tax_total | Unknown | |
section_financial_total_cost | Unknown | |
section_financial_total_price | Unknown | |
title | Unknown |
company_setting
| Column | Type | Keys |
|---|---|---|
company_id | Unknown | PK |
has_insurance | Unknown | |
name | Unknown | |
time_zone_info_adjusted_utc_offset | Unknown | |
time_zone_info_base_utc_offset | Unknown | |
time_zone_info_daylight_name | Unknown | |
time_zone_info_name | Unknown | |
time_zone_info_supports_daylight_saving | Unknown |
calendar_appointment
| Column | Type | Keys |
|---|---|---|
end_date | Unknown | PK |
id | Unknown | PK |
start_date | Unknown | PK |
calendar_id | Unknown | PKFK |
all_day | Unknown | |
event_type | Unknown | |
job_name | Unknown | |
location | Unknown | |
notes | Unknown | |
title | Unknown |
calendar
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
display_name | Unknown | |
email | Unknown | |
employee_id | Unknown | |
first_name | Unknown | |
initial | Unknown | |
last_name | Unknown | |
mobile_phone | Unknown | |
phone | Unknown | |
role_id | Unknown | |
role_name | Unknown | |
status | Unknown |
company_lead_source_child
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lead_source_id | Unknown | PKFK |
name | Unknown |
company_lead_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
estimate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
job_id | Unknown | FK |
modified_by_id | Unknown | FK |
created_date | Unknown | |
description | Unknown | |
estimate_number | Unknown | |
financial_overhead_rate | Unknown | |
financial_overhead_total | Unknown | |
financial_profit_rate | Unknown | |
financial_profit_total | Unknown | |
financial_tax_rate | Unknown | |
financial_tax_total | Unknown | |
financial_total_cost | Unknown | |
financial_total_price | Unknown | |
is_primary | Unknown | |
modified_date | Unknown | |
note | Unknown | |
profit_margin_rate | Unknown | |
profit_margin_total | Unknown | |
title | Unknown |
job_contact_email_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_contact_id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_contact_phone_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_contact_id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
contact_guid | Unknown | |
is_primary | Unknown | |
relation_to_primary | Unknown |
job_trade_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
name | Unknown |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lead_source_id | Unknown | FK |
created_date | Unknown | |
current_milestone | Unknown | |
geo_location_latitude | Unknown | |
geo_location_longitude | Unknown | |
job_category_id | Unknown | |
job_category_name | Unknown | |
job_name | Unknown | |
job_number | Unknown | |
lead_dead_reason | Unknown | |
location_address_city | Unknown | |
location_address_country_abbreviation | Unknown | |
location_address_country_id | Unknown | |
location_address_country_name | Unknown | |
location_address_state_abbreviation | Unknown | |
location_address_state_id | Unknown | |
location_address_state_name | Unknown | |
location_address_street_1 | Unknown | |
location_address_street_2 | Unknown | |
location_address_zip_code | Unknown | |
milestone_date | Unknown | |
modified_date | Instant | |
work_type_id | Unknown | |
work_type_name | Unknown | |
work_type_system_default | Unknown |
lead_history
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
job_id | Unknown | FK |
action | Unknown | |
created_by_id | Unknown | |
created_by_link | Unknown | |
date | Unknown | |
lead_dead_reason | Unknown |
financial_worksheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
financial_id | Unknown | PKFK |
job_id | Unknown | PKFK |
financial_amendment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
financial_id | Unknown | PKFK |
job_id | Unknown | PKFK |
financial
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
approved_job_value | Unknown | |
balance_due | Unknown | |
worksheet_id | Unknown | |
worksheet_section_total_change_order_total | Unknown | |
worksheet_section_total_discount_total | Unknown | |
worksheet_section_total_financial_total | Unknown | |
worksheet_section_total_insurance_claim_total | Unknown | |
worksheet_section_total_supplement_total | Unknown | |
worksheet_section_total_upgrade_total | Unknown | |
worksheet_section_total_work_not_doing_total | Unknown |
milestone_history
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
job_id | Unknown | FK |
date | Unknown | |
name | Unknown |
invoice_section_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
invoice_section_id | Unknown | PKFK |
job_id | Unknown | PKFK |
parent_item_id | Unknown | FK |
hierarchy_sort_order | Unknown | |
item_name | Unknown | |
line_item_assignment | Unknown | |
price | Unknown | |
total_price | Unknown |
invoice_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
job_id | Unknown | PKFK |
invoice_worksheet_section_type | Unknown | |
total_price | Unknown |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
balance_due | Unknown | |
created_date | Unknown | |
current_invoice_state | Unknown | |
due_date | Unknown | |
invoice_date | Unknown | |
invoice_name | Unknown | |
invoice_number | Unknown | |
invoice_sequence | Unknown | |
recording_classification | Unknown | |
recording_status | Unknown | |
sort_index | Unknown | |
total_price | Unknown |