Last Updated: October 04 2024
Overview
Below is a list of fields and tables available in BI Reporting. Tables are prefixed by 'simpro_'. These are important to ensure the correct usage of terminology when you write SQL queries.
Learn more in How to Use Native Query in BI Reporting.
Required setup
In order to view content or perform actions referred to in this article you need to have the appropriate permissions enabled in your security group. Go to System 
> Setup > Security Groups and access your security group to update your permissions. The relevant security group tab and specific permissions for this article can be found here:
Accounts
| simpro_accounts |
|
account_id account_no company_id (Multi-company only) company_name (Multi-company only) name removed type |
| simpro_invoice_cost_centre_accounts |
|
company_id (Multi-company only) company_name (Multi-company only) customer customer_id income_account_id income_account_name invoice_id job_cost_centre_id job_id recurring_invoice_costcentre_id recurring_invoice_id site site_id total_ex total_inc |
Assets
* All custom fields contained within one field, e.g. "Custom Field 1"="value1","Custom Field 2"="value2" etc.
| simpro_assets |
|
asset_id asset_type display_order custom_fields * customer_id customer site_id site_name contract_id contract_name removed |
| simpro_asset_service_levels |
|
name years months days next_service_date service_start_date asset_id |
| failure_points |
|
set_id set_type company_id company_name contractor_id contractor_name date_tested employee_id employee_name failure_points job_costcentre_ set_id job_id service_level_name |
| simpro_assets_test |
|
job_id employee_id employee_name contractor_id contractor_name service_level_name asset_id asset_type pass date_tested |
| test_readings |
|
asset_id asset_type company_id company_name contractor_id contractor_name date_tested employee_id employee_name job_costcentre_asset_id job_costcentre_id job_id service_level_name test_readings |
| simpro_asset_job_cost_centre |
|
job_costcentre_asset_id asset_id asset_type job_costcentre_id job_id |
| recommendations |
|
asset_id asset_type company_id company_name contractor_id contractor_name date_tested employee_id employee_name failure_name job_costcentre_asset_id job_id recommendations service_level_name |
Assigned / Billable items
| simpro_assigned_items |
|
job_id job_costcentre_id stock_item_id name storage_name quantity cost date_allocated time_allocated |
| simpro_billable_items |
|
billable_item_id sundry_item_id stock_item_id prebuild_id name type part_no cost_price markup sell_price billable_quantity job_id job_costcentre_id income_account_id income_account_name item_type |
| simpro_billable_labours |
|
labour_type cost_rate markup sell_price time job_id job_costcentre_id income_account_id income_account_name |
| simpro_billable_materials |
|
illable_item_id stock_item_id prebuild_id service_fee_id name type part_no cost_price markup sell_price billable_quantity job_id job_costcentre_id income_account_id income_account_name |
| simpro_billable_sundries |
|
sundry_item_id name type cost_price estimated_cost_price markup sell_price billable_quantity job_id job_costcentre_id actual_cost_date income_account_id income_account_name item_type |
| non_billable_items |
|
actual_cost_date company_id company_name cost_price estimated_cost_price item_id job_costcentre_id job_id name non_billable_quantity prebuild_id service_fee_id stock_item_id sundry_item_id type item_type |
| non_billable_material_items |
|
company_id company_name cost_price item_id job_costcentre_id job_id name non_billable_quantity prebuild_id service_fee_id stock_item_id type |
| non_billable_sundry_items |
|
actual_cost_date company_id company_name cost_price estimated_cost_price job_costcentre_id job_id name non_billable_quantity sundry_item_id type item_type |
Catalogue items
| simpro_catalogue_items |
|
stock_item_id name is_favorite is_inventory is_asset multi_currency part_no upc manufacturer origin_country measurement_unit estimated_time trade_price split_price storage_location purchase_tax_code sales_tax_code group_name subgroup_1_name subgroup_2_name subgroup_3_name removed default_cost_price |
Commission Tiers / Companies
| simpro_commission_tiers |
|
commission_tier_id name removed |
| simpro_companies |
|
company_id name abn acn licence website address bsb account account_name bank currency country timezone |
| simpro_business_groups |
|
business_group_id name |
Contracts
| simpro_contracts |
|
contract_id name date_start date_end no value customer_id customer_name |
| simpro_contract_pricing_tiers |
|
contract_id contract_name pricing_tiers default_markup |
| simpro_contractors |
|
contractor_id name street_address suburb state post_code country date_beginning date_birth date_created contact_name contact_email contact_secondary_email contact_phone contact_extension contact_mobile_phone contact_fax licence_user licence_pos licence_call_centre licence_mobility security_group salesperson project_manager storage_device_name preferred_language pay_rate employment_costs overhead_costs cost_centres zones teams removed |
| simpro_contractor_invoices |
|
contractor_invoice_id contractor_invoice_no contractor_jobs date_approved date_invoice date_paid invoice_no paid sub_total tax_total total type |
| simpro_contractor_jobs |
|
contractor_job_id contact contractor contractor_id job_costcentre_id job_id quote_cost_centre_id quote_id date labour_cost material_cost tax_code |
| simpro_contractor_job_cards |
|
job_id costcentre_id date start_time end_time hours schedule_rate employee_id employee_name approved pay_rate_cost overhead_cost employment_cost |
Cost Centres / Customer groups / Customers
| simpro_cost_centres |
|
costcentre_id name removed income_account_id income_account_name expense_account_id expense_account_name |
| simpro_customer_groups |
|
customer_group_id name |
| simpro_customers |
|
customer_id entity_type business_name first_name last_name title abn type website main_phone alt_phone mobile_phone do_not_call street_address suburb state post_code country mail_street_address mail_suburb mail_state mail_post_code mail_country date_created profile_name group_name account_manager_id referred_by_id payment_term payment_type currency credit_limit on_stop payment_method service_fee discount fee current_memberships expired_memberships pricing_tier default_markup removed |
| simpro_customer_profiles |
|
customer_profile_id name removed |
| simpro_customer_tags |
|
customer_tag_id name |
Employee
| simpro_employees |
|
employee_id name street_address suburb state post_code country date_beginning date_birth date_created contact_email contact_secondary_email contact_phone contact_extension contact_mobile_phone contact_fax licence_user licence_pos licence_call_centre licence_mobility security_group salesperson project_manager storage_device_name preferred_language pay_rate employment_costs overhead_costs costcentres zones teams removed |
| simpro_employee_licences |
|
employee_id employee_name name ref expiry_date |
Invoices
| simpro_invoice_cost_centres |
|
invoice_id invoice_costcentre_id name total_ex total_inc total_discount |
| simpro_invoiced_items |
|
name billable_item_id invoice_id invoiced_quantity part no progress_claimed sell price sundry_item_id income_account_id income_account_name |
| simpro_invoices |
|
invoice_id invoice_type job_id claim_no customer customer_id date_issued period_start period_end due_date stage per_item category comment recurring recurring_invoice_id total_price_ex total_price_inc total_discount total_retention_ex total_retention_inc credit |
| simpro_invoice_jobs |
|
job_id invoice_id order_no status |
| simpro_recurring_invoices |
|
recurring_invoice_id type customer_id customer site_id site request_no order_no date_created technician technician_id manager manager_id sales_person sales_person_id recurring_start_date recurring_frequency recurring_next_date tags description notes total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment estimated_total_materials budgeted_total_materials estimated_total_labour budgeted_total_labour total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs removed customer_contract_id |
| simpro_recurring_invoice_cost_centres |
|
recurring_invoice_costcentre_id name default_name recurring_invoice_id recurring_invoice_type section_name description notes site site_id order_no start_date end_date total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment total_material_price_ex_tax total_material_price_inc_tax total_labor_price_ex_tax total_labor_price_inc_tax total_service_fee_ex_tax total_service_fee_inc_tax total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs removed |
Labour / leads / Plant items
| simpro_leads |
|
lead_id customer_id customer primary_contact site_id site site_contact cost_center sales_person project_manager status date_follow_up date_creation estimated_price sales_probability date_due_expected removed archive_reason tags lead_id - simpro_leads.lead_id lead_customer_id - simpro_leads.customer_id lead_customer - simpro_leads.customer lead_primary_contact - simpro_leads.primary_contact lead_site_id - simpro_leads.site_id lead_site - simpro_leads.site lead_site_contact - simpro_leads.site_contact lead_site_contact_id - simpro_leads.site_contact_id lead_primary_customer_contact_id - simpro_leads.primary_customer_contact_id lead_cost_center - simpro_leads.cost_center lead_sales_person - simpro_leads.sales_person lead_project_manager - simpro_leads.project_manager lead_status - simpro_leads.status lead_date_follow_up - simpro_leads.date_follow_up lead_date_creation - simpro_leads.date_creation lead_estimated_price - simpro_leads.estimated_price lead_sales_probability - simpro_leads.sales_probability lead_date_due_expected - simpro_leads.date_due_expected lead_removed - simpro_leads.removed lead_archive_reason - simpro_leads.archive_reason lead_tags - simpro_leads.tags lead_name - simpro_leads.project_name |
| simpro_plants |
|
plant_id name service_fee_id service_fee_name type status servicing service_frequency_number service_frequency_period start_service next_service billing cost_rate overhead_rate sell_rate sale_tax_code removed |
| converted_lead |
|
company_id company_name date_converted lead_archive_reason lead_cost_center lead_customer lead_customer_id lead_date_creation lead_date_due_expected lead_date_follow_up lead_estimated_price lead_id lead_name lead_primary_contact lead_primary_customer_contact_id lead_project_manager lead_removed lead_sales_person lead_sales_probability lead_site lead_site_contact lead_site_contact_id lead_site_id lead_status lead_tags quote_budgeted_commission_costs quote_budgeted_gross_margin quote_budgeted_gross_pl quote_budgeted_labor_costs quote_budgeted_labor_hours quote_budgeted_labor_markup quote_budgeted_material_costs quote_budgeted_material_markup quote_budgeted_net_margin quote_budgeted_net_pl quote_budgeted_overhead quote_budgeted_plant_costs quote_budgeted_plant_hours quote_budgeted_plant_markup quote_budgeted_total_labour quote_budgeted_total_materials quote_customer quote_customer_id quote_date_created quote_date_due quote_date_due_expected quote_estimated_commission_costs quote_estimated_gross_margin quote_estimated_gross_pl quote_estimated_labor_costs quote_estimated_labor_hours quote_estimated_labor_markup quote_estimated_material_costs quote_estimated_material_markup quote_estimated_net_margin quote_estimated_net_pl quote_estimated_overhead quote_estimated_plant_costs quote_estimated_plant_hours quote_estimated_plant_markup quote_estimated_total_labour quote_estimated_total_materials quote_id quote_manager quote_manager_id quote_name quote_order_no quote_request_no quote_retention_period quote_sales_person quote_sales_person_id quote_sales_probability quote_site quote_site_id quote_stage quote_status quote_tags quote_technician quote_technician_id quote_total_adjustment quote_total_calculated_ex_tax quote_total_calculated_inc_tax quote_total_discount_currency_ex_tax quote_total_discount_currency_inc_tax quote_total_discount_ex_tax quote_total_discount_inc_tax quote_total_price_currency_ex_tax quote_total_price_currency_inc_tax quote_total_price_ex_tax quote_total_price_inc_tax quote_total_retention_ex_tax quote_total_retention_inc_tax quote_total_retention_rebate_ex_tax quote_total_retention_rebate_inc_tax quote_total_stcs quote_total_veecs quote_type quote_validity |
Quotes
| simpro_quotes |
|
quote_id customer_id customer site_id site type request_no order_no date_created date_due validity sales_person sales_person_id manager manager_id technician technician_id stage status tags retention_period sales_probability date_due_expected total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment estimated_total_materials budgeted_total_materials estimated_total_labour budgeted_total_labour total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_retention_ex_tax total_retention_inc_tax total_retention_rebate_ex_tax total_retention_rebate_inc_tax total_stcs total_veecs total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs description notes archive_reason |
| simpro_quote_cost_centres |
|
quote_costcentre_id name quote_id quote_type section_name description notes type site site_id order_no start_date end_date total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment total_material_price_ex_tax total_material_price_inc_tax total_labor_price_ex_tax total_labor_price_inc_tax total_service_fee_ex_tax total_service_fee_inc_tax total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs |
| simpro_converted_quotes |
|
date_converted job_actual_commission_costs job_actual_committed_overhead_costs job_actual_gross_margin job_actual_gross_pl job_actual_labor_committed_hours job_actual_labor_costs job_actual_labor_hours job_actual_labor_markup job_actual_material_committed_costs job_actual_material_costs job_actual_material_markup job_actual_net_margin job_actual_net_pl job_actual_overhead_costs job_actual_plant_committed_costs job_actual_plant_committed_hours job_actual_plant_costs job_actual_plant_hours job_actual_plant_markup job_actual_plant_overhead_costs job_actual_total_labour job_actual_total_materials job_budgeted_commission_costs job_budgeted_gross_margin job_budgeted_gross_pl job_budgeted_labor_costs job_budgeted_labor_hours job_budgeted_labor_markup job_budgeted_material_costs job_budgeted_material_markup job_budgeted_net_margin job_budgeted_net_pl job_budgeted_overhead job_budgeted_plant_costs job_budgeted_plant_hours job_budgeted_plant_markup job_budgeted_total_labour job_budgeted_total_materials job_customer job_customer_id job_date_created job_due_date job_estimated_commission_costs job_estimated_gross_margin job_estimated_gross_pl job_estimated_labor_costs job_estimated_labor_hours job_estimated_labor_markup job_estimated_material_costs job_estimated_material_markup job_estimated_net_margin job_estimated_net_pl job_estimated_overhead job_estimated_plant_costs job_estimated_plant_hours job_estimated_plant_markup job_estimated_total_labour job_estimated_total_materials job_id job_manager job_manager_id job_order_no job_request_no job_retention_period job_sales_person job_sales_person_id job_site job_site_id job_stage job_status job_tags job_technician job_technician_id job_total_adjustment job_total_calculated_ex_tax job_total_calculated_inc_tax job_total_discount_currency_ex_tax job_total_discount_currency_inc_tax job_total_discount_ex_tax job_total_discount_inc_tax job_total_price_currency_ex_tax job_total_price_currency_inc_tax job_total_price_ex_tax job_total_price_inc_tax job_total_retention_ex_tax job_total_retention_inc_tax job_total_retention_rebate_ex_tax job_total_retention_rebate_inc_tax job_total_stcs job_total_veecs job_type quote_budgeted_commission_costs quote_budgeted_gross_margin quote_budgeted_gross_pl quote_budgeted_labor_costs quote_budgeted_labor_hours quote_budgeted_labor_markup quote_budgeted_material_costs quote_budgeted_material_markup quote_budgeted_net_margin quote_budgeted_net_pl quote_budgeted_overhead quote_budgeted_plant_costs quote_budgeted_plant_hours quote_budgeted_plant_markup quote_budgeted_total_labour quote_budgeted_total_materials quote_customer quote_customer_id quote_date_created quote_due_date quote_date_due_expected quote_estimated_commission_costs quote_estimated_gross_margin quote_estimated_gross_pl quote_estimated_labor_costs quote_estimated_labor_hours quote_estimated_labor_markup quote_estimated_material_costs quote_estimated_material_markup quote_estimated_net_margin quote_estimated_net_pl quote_estimated_overhead quote_estimated_plant_costs quote_estimated_plant_hours quote_estimated_plant_markup quote_estimated_total_labour quote_estimated_total_materials quote_id quote_manager quote_manager_id quote_order_no quote_request_no quote_retention_period quote_sales_person quote_sales_person_id quote_sales_probability quote_site quote_site_id quote_stage quote_status quote_tags quote_technician quote_technician_id quote_total_adjustment quote_total_calculated_ex_tax quote_total_calculated_inc_tax quote_total_discount_currency_ex_tax quote_total_discount_currency_inc_tax quote_total_discount_ex_tax quote_total_discount_inc_tax quote_total_price_currency_ex_tax quote_total_price_currency_inc_tax quote_total_price_ex_tax quote_total_price_inc_tax quote_total_retention_ex_tax quote_total_retention_inc_tax quote_total_retention_rebate_ex_tax quote_total_retention_rebate_inc_tax quote_total_stcs quote_total_veecs quote_type quote_validity |
Jobs
| simpro_job_cards |
|
job_id costcentre_id date start_time end_time hours schedule_rate employee_id employee_name approved work_completed technician_notes |
| simpro_job_cost_centres |
|
job_costcentre_id name default_name job_id job_type section_name description notes site site_id order_no start_date end_date stage total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment total_material_price_ex_tax total_material_price_inc_tax total_labor_price_ex_tax total_labor_price_inc_tax total_service_fee_ex_tax total_service_fee_inc_tax total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs actual_material_costs actual_material_committed_costs actual_labor_hours actual_plant_hours actual_labor_committed_hours actual_plant_committed_hours actual_labor_costs actual_plant_costs actual_plant_committed_costs actual_plant_overhead_costs actual_material_markup actual_labor_markup actual_plant_markup actual_overhead_costs actual_committed_overhead_costs actual_net_pl actual_gross_pl actual_net_margin actual_gross_margin actual_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs |
| simpro_jobs |
|
job_id customer_id customer site_id site request_no order_no date_created date_due sales_person manager technician stage status retention_period total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment actual_total_materials estimated_total_materials budgeted_total_materials actual_total_labour estimated_total_labour budgeted_total_labour total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_retention_ex_tax total_retention_inc_tax total_retention_rebate_ex_tax total_retention_rebate_inc_tax total_stcs total_veecs total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs actual_material_costs actual_material_committed_costs actual_labor_hours actual_plant_hours actual_labor_committed_hours actual_plant_committed_hours actual_labor_costs actual_plant_costs actual_plant_committed_costs actual_plant_overhead_costs actual_material_markup actual_labor_markup actual_plant_markup actual_overhead_costs actual_committed_overhead_costs actual_net_pl actual_gross_pl actual_net_margin actual_gross_margin actual_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs description notes archive reason removed |
| simpro_recurring_jobs |
|
recurring_job_id type customer_id customer site_id site request_no order_no date_created technician technician_id manager manager_id sales_person sales_person_id recurring_start_date recurring_frequency recurring_next_date tags description notes total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment estimated_total_materials budgeted_total_materials estimated_total_labour budgeted_total_labour total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs removed |
| simpro_recurring_job_cost_centres |
|
recurring_job_costcentre_id name default_name recurring_job_id recurring_job_type section_name description notes site site_id order_no start_date end_date total_discount_ex_tax total_discount_inc_tax total_price_ex_tax total_price_inc_tax total_adjustment total_material_price_ex_tax total_material_price_inc_tax total_labor_price_ex_tax total_labor_price_inc_tax total_service_fee_ex_tax total_service_fee_inc_tax total_price_currency_inc_tax total_price_currency_ex_tax total_discount_currency_inc_tax total_discount_currency_ex_tax total_calculated_ex_tax total_calculated_inc_tax total_membership_discount_ex total_membership_discount_inc total_membership_discount_currency_ex total_membership_discount_currency_inc estimated_labor_hours estimated_material_costs estimated_labor_costs estimated_plant_costs estimated_material_markup estimated_labor_markup estimated_plant_markup estimated_overhead estimated_plant_hours estimated_gross_pl estimated_net_pl estimated_gross_margin estimated_net_margin estimated_commission_costs budgeted_labor_hours budgeted_plant_hours budgeted_material_costs budgeted_labor_costs budgeted_plant_costs budgeted_material_markup budgeted_labor_markup budgeted_plant_markup budgeted_overhead budgeted_gross_pl budgeted_net_pl budgeted_gross_margin budgeted_net_margin budgeted_commission_costs removed |
Purchase orders / Receipts
| simpro_purchase_orders |
|
order_no storage_device date_issued supplier supplier_id quote_no reference job_id date_due status sub_total tax total stage completed pending received |
| simpro_receipts |
|
supplier_receipt_id date_invoice date_ordered freight invoice_no job_id packing_slip_no purchase_order_no reference supplier_id supplier_name supplier_receipt_no tax_adjustment total |
| simpro_items_purchased |
|
name date_invoiced date_ordered order_no part_no price quantity receipt_no stock_item_id total item_date_due item_notes |
Schedules / Sites / Stock
| simpro_schedules |
|
schedule_id contractor_id contractor_name date employee_id employee_name employment_cost end_time hours job_costcentre_id job_id lead_id overhead_cost pay_rate_cost quote_cost_centre_id quote_id schedule_rate start_time type |
| simpro_schedule_logs |
|
user_id name log_time schedule_id description type |
| simpro_schedule_rate |
|
schedule_rate_id name removed |
| simpro_sites |
|
site_id name zone_name street_address suburb state post_code mail_contact mail_street_address mail_suburb mail_state mail_post_code country certification_date stc_zone_name veec_zone_name contact_title contact_first_name contact_last_name contact_email contact_work_phone contact_mobile_phone contact_fax contact_position preferred_technicians part_tax_code labour_tax_code date_created removed |
| simpro_stock_items |
|
stock_item_id quantity inventory_price date_stocked stock_name storage_name |
Suppliers
| simpro_suppliers |
|
supplier_id name abn website work_phone fax street_address suburb state post_code country mail_street_address mail_suburb mail_state mail_post_code mail_country date_created account currency purchase_tax_code payment_terms payment_terms_type removed |
Tasks
| simpro_tasks |
|
task_id actual_hours assigned_contractor_id assigned_employee_id associated_customer_id associated_customer_name billable category contact date_completed date_created date_due date_start description estimated_hours job_id notes parent_task_id priority site_id site_name status subject assigned_employee_id assigned_contractor_id completed_by |
| task_assignment |
|
assigned_contractor_id assigned_employee_id task_assignment_id task_id |
Setup
| simpro_labour_rates |
|
labour_rate_id name |
| simpro_memberships |
|
membership_id name removed |
| simpro_invoice_payments |
|
invoice_id payment_no date deposit_account finance_charge method total |
| simpro_plant_checks |
|
plant_check_id plant_id plant_name employee_id employee_name checked_in checked_out |
| simpro_prebuilds |
|
prebuild_id name part_no material_cost material_markup labour_cost labour_time labour_markup sales_tax_code has_stc zone_1_stc zone_2_stc zone_3_stc zone_4_stc zone_5_stc veec_zone_1_gas veec_zone_2_gas veec_zone_1_elec veec_zone_2_elec removed group_name group_id |
| simpro_prepaid_times |
|
job_id customer_id customer date_purchased expiry time_purchased invoice_id |
| simpro_pricing_tiers |
|
pricing_tier_id name |
| simpro_project_tags |
|
project_tag_id name |
| simpro_response_times |
|
response_time_id name removed |
| simpro_job_response_times |
|
job_response_time_id job_id response_time_id created due job_start_time response_time_achieved |
| simpro_service_fees |
|
service_fee_id name removed |
| simpro_status_codes |
|
status_code_id name |
| simpro_teams |
|
team_id name |
| simpro_zones |
|
zone_id name |
Mobile
| mobile_status |
|
accuracy company_id company_name contractor_id customer date employee_id geostamp job_cost_centre_id job_id mobile_status quote_cost_centre_id quote_id site time |
Data
| simpro_data_refresh_time |
|
refresh_date refresh_time timezone |