Records and Fields Reference
OpenAir provide technical documentation for identifying record types, corresponding tables in the OpenAir database, and field names. See OpenAir Data Dictionary.
Integration Manager does not support all tables and fields in the OpenAir database. This section provides a list of OpenAir record types available for import and export using Integration Manager, see OpenAir Records Available for Export and Import.
Click the links in the list of supported record types to view the list of standard fields supported for each record type.
OpenAir Data Dictionary
The OpenAir Data Dictionary provides a summary of all tables, and standard fields in OpenAir.
Go to the OpenAir Data Dictionary
The Database Guide also provides an overview of the corresponding tables and their relationships for most record types in OpenAir with cross-references to the OpenAir Data Dictionary for details. See Database Guide.
To view the OpenAir Data Dictionary, use the following URL: https://<account-domain>/database/single_user.html.
-
The URL includes the domain name for your OpenAir account
<account-domain>. For more information about your account-specific domain name, see Your OpenAir Account URLs. -
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, usehttps://<account-domain>/database/single_user.html#projectto view the details of the Project table. -
You can access the data dictionary from the OpenAir Help Center using the link in the navigation bar if you have the View Help Center role permission.
OpenAir Records Available for Export and Import
The following table lists the OpenAir record types available for import and export using Integration Manager. Some record types are supported only when exporting information from OpenAir to a CSV file, or only when importing information from a CSV file into OpenAir. Check marks under the Export and Import columns indicate that you can export or import records of that type.
When exporting information from OpenAir to a CSV file, supported standard fields for other record types directly related with the record type you selected for export are also available for mapping. A check mark under the Export (Related Object) column indicates the record types available as related objects and the fields available for these related object. Some of records are only supported as related object.
Click the links in the list of supported record types to view the list of standard fields supported for each record type.
|
OpenAir Record |
Export |
Export (Related Object) |
Import |
|---|---|---|---|
|
|
— |
|
|
|
— |
— |
|
|
|
— |
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
|
— |
|
|
Category_1 (see Category_<N>) |
|
— |
|
|
Category_2 (see Category_<N>) |
|
— |
|
|
Category_3 (see Category_<N>) |
|
— |
|
|
Category_4 (see Category_<N>) |
|
— |
|
|
Category_5 (see Category_<N>) |
|
— |
|
|
|
— |
|
|
|
— |
— |
|
|
|
|
|
|
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
— |
|
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
|
|
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
— |
|
|
|
— |
|
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
— |
|
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
|
— |
|
|
|
|
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
(only non-PO purchase items) |
|
|
— |
|
— |
|
|
— |
|
— |
|
|
— |
|
— |
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
— |
|
|
|
— |
|
|
|
|
|
|
|
|
|
— |
— |
|
|
|
— |
|
|
|
|
— |
— |
|
|
— |
|
— |
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
— |
|
— |
|
|
— |
|
— |
|
|
|
|
|
|
|
— |
|
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
— |
|
