Index of Entity-Relationship Diagrams by Data Area

At the highest level, OpenAir data can be categorized by business area. The following diagram summarize the different business data areas.

The following tables lists the ER diagrams for record types in the different data areas.

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.

Data Area	ER diagrams
Customers	Agreement Category Customer Deal Proposal
Projects	Issue Project Project Group Project Pricing Project Task
Revenue	Revenue Container Revenue Recognition
Resources	Attachment Booking Leave Accrual Resource Profile Resource Request Schedule User
Costs	Accounting Period Billing Budget Cost Envelope Estimate Expense Policy Invoice Item Job Rate Payment Purchase Item Purchase Order Request Item Slip Task Time Workhour
Management	Approval Process Authorization Custom Field Filter Miscellaneous Product Role Reporting Script Switch Tag Tax Workspace