Index of Tables and Entity-Relationship Diagrams

The following table lists the tables described in the data dictionary and corresponding ER diagrams.

Note:

Unless you are viewing this help topic in the OpenAir Help Center, links to the data dictionary use the generic OpenAir domain for production accounts (app.openair.com). In some instances, you may need to replace the generic domain name with your account-specific domain name in the link URLs.

  • To view the OpenAir Data Dictionary, use the following URL:

    https://<account-domain>/database/single_user.html, where <account-domain> is the account-specific domain for your account.

  • To view the details of a specific table, append a hash symbol # followed by the table name to the end of the data dictionary URL.

    For example, use https://<account-domain>/database/single_user.html#project to view the details of the Project table.

For more information about your account-specific domain name, see Your Account URLs.

Table

ER Diagram

account

Switch

accounting_period

Accounting Period

accounts_payable

Purchase Order

actual_cost

Cost

address

Proposal

adhoc_report

Reporting

agreement

Agreement

agreement_to_project

Agreement

alert

Item

approval

Approval Process

approval_confirmation_status

Miscellaneous

approvalprocess

Approval Process

approvalprocess_rule

Approval Process

assign_by_day

Miscellaneous

assignment_profile

Resource Profile

attachment

Attachment

attachment_category

Attachment

attachment_revision

Attachment

attachment_text

Attachment

attribute

Resource Profile

attribute_set

Resource Profile

authorization

Authorization

authorization_item

Authorization

auto_bill

Billing

baseline_by_day

Miscellaneous

billing_action

Billing

billing_split

Billing

booking

Booking

booking_baseline

Booking

booking_by_day

Booking

booking_request

Booking

booking_type

Booking

budget

Budget

budget_activity

Budget

budget_allocation

Budget

budget_category

Budget

builtin_crosstab

Reporting

builtin_detail

Reporting

bulk_payment

Payment

bus_type

Customer

carrier

Purchase Order

category

Category

category_1

Category

category_2

Category

category_3

Category

category_4

Category

category_5

Category

cc_rate

Category

company_size

Customer

contact

Proposal

cost_category

Cost

cost_center

Cost

cost_center_used

Cost

cost_type

Cost

currency

Payment

current_period

Accounting Period

cust_field

Custom Field

custom_detail

Custom Field

customer

Customer

customer_location

Customer

customerpo

Customer

customerpo_to_project

Customer

deal

Deal

deal_booking_request

Deal

deal_contact

Deal

deal_schedule

Deal

deal_stage

Deal

department

User

dependent_custom_field

Custom Field

discussion

Workspace

discussion_message

Workspace

email_template

Miscellaneous

entity_report

Reporting

entity_tag

Tag

envelope

Envelope

estimate

Estimate

estimate_adjustment

Estimate

estimate_expense

Estimate

estimate_labor

Estimate

estimate_markup

Estimate

estimate_phase

Estimate

event

Proposal

expense_policy

Expense Policy

expense_policy_item

Expense Policy

extended_field

Custom Field

filter

Filter

filter_set

Filter

filter_user

Filter

fob_location

Purchase Order

folder

Project Group

folder_content

Project Group

forex

Payment

form_script_deployment

Script

form_script_deployment_log

Script

fulfillment

Request Item

hear_about

Customer

hierarchy

Resource Request

hierarchy_node

Resource Request

history

User

import_export

Miscellaneous

import_export_state

Miscellaneous

invoice

Invoice

invoice_layout

Invoice

invoice_tax_rates

Invoice

issue

Issue

issue_category

Issue

issue_severity

Issue

issue_source

Issue

issue_stage

Issue

issue_status

Issue

item

Item

item_to_user_location

Item

item_history

Item

job_code

Job Rate

job_code_history

Job Rate

job_code_rate_by_task

Job Rate

job_code_used

Job Rate

leave_accrual_rule

Leave Accrual

leave_accrual_rule_to_user

Leave Accrual

leave_accrual_transaction

Leave Accrual

line_manager

User

loaded_cost

Cost

manufacturer

Product

merchant

Payment

newsfeed

News Feed

newsfeed_message

News Feed

ns_config

NetSuite Connector

ns_export_queue

NetSuite Connector

ns_last_import

NetSuite Connector

ns_mapping

NetSuite Connector

ns_queue

NetSuite Connector

ns_realtime

NetSuite Connector

ns_run

NetSuite Connector

ns_switch

NetSuite Connector

ns_tab

NetSuite Connector

ns_workflow

NetSuite Connector

owner

User

payment

Payment

payment_terms

Payment

payment_type

Payment

payroll_type

Payment

pending_booking

Booking

preference

Switch

product

Product

project

Project

project_assign

Project

project_assignment_profile

Resource Profile

project_assignment_profile_filter

Resource Profile

project_baseline

Project

project_billing_rule

Billing

project_billing_transaction

Billing

project_booking_grid

Booking

project_group

Project Group

project_group_assign

Project Group

project_location

Project

project_mutex

Project

project_mutex_override

Project

project_pricing

Project Pricing

project_pricing_approval

Project Pricing

project_pricing_estimate

Project Pricing

project_pricing_split

Project Pricing

project_pricing_type

Project Pricing

project_stage

Project

project_task

Project Task

project_task_assign

Project Task

project_task_baseline

Project Task

project_task_estimate

Project Task

project_task_split

Project Task

project_transfer

Project

projecttask_type

Project Task

proposal

Proposal

proposal_block

Proposal

proxy

Role

purchase_item

Purchase Item

purchaseorder

Purchase Order

purchaser

Purchase Order

purchaserequest

Request Item

queue

Item

rate_card

Job Rate

rate_card_item

Job Rate

receiving

Purchase Order

registry_entry

Miscellaneous

reimbursement

Envelope

repeat

Miscellaneous

report

Reporting

request_item

Request Item

resource_request

Resource Request

resource_request_queue

Resource Request

resourceprofile

Resource Profile

resourceprofile_type

Resource Profile

resourcesearch

Resource Request

revenue_container

Revenue Container

revenue_container_summary

Revenue Container

revenue_projection

Revenue Recognition

revenue_recognition_rule

Revenue Recognition

revenue_recognition_rule_amount

Revenue Recognition

revenue_recognition_rule_date

Revenue Recognition

revenue_recognition_transaction

Revenue Recognition

revenue_stage

Revenue Container

role

Role

role_booking_type_default

Role

role_edit_exclusion

Role

role_priv

Role

schedule_by_day

Schedule

schedule_request

Schedule

schedule_request_item

Schedule

scheduleexception

Schedule

script_deployment

Script

script_deployment_log

Script

security_questions

Role

shared_folder

Project Group

shared_report

Reporting

shipping_terms

Purchase Order

short_url

Miscellaneous

signer

Project

signoff

Task

slip

Slip

slip_projection

Slip

slip_stage

Slip

slip_type

Slip

snapshot

Miscellaneous

switch

Switch

switch_history

Switch

switch_total

Switch

tag_group

Tag

tag_group_attribute

Tag

target_utilization

Miscellaneous

task

Task

task_adjustment

Task

tax_location

Tax

tax_rate

Tax

template

Proposal

territory

Deal

ticket

Ticket

ticket_adjustment

Ticket

ticket_approval

Ticket

time_card

Time

time_period

Time

time_period_set

Time

timer

Time

timesheet

Time

timesheet_status

Time

timetype

Time

todo

Proposal

up_rate

Job Rate

user

User

user_location

User

user_login

User

user_stat

User

user_tag_by_day

Tag

valuelist_custom_field

Custom Field

vehicle

Slip

vendor

Product

viewfilter

User

viewfilter_rule

User

workhour

Workhour

workhour_workday

Workhour

workschedule

Workhour

workschedule_workhour

Workhour

workspace

Workspace

workspace_link

Workspace

workspace_user

Workspace