Records and Fields Reference
SuiteProjects Pro provide technical documentation for identifying record types, corresponding tables in the SuiteProjects Pro database, and field names. See SuiteProjects Pro Data Dictionary.
Integration Manager does not support all tables and fields in the SuiteProjects Pro database. This section provides a list of SuiteProjects Pro record types available for import and export using Integration Manager, see SuiteProjects Pro 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.
SuiteProjects Pro Data Dictionary
The SuiteProjects Pro Data Dictionary provides a summary of all tables, and standard fields in SuiteProjects Pro.
Go to SuiteProjects Pro Data Dictionary
The Database Guide also provides an overview of the corresponding tables and their relationships for most record types in SuiteProjects Pro with cross-references to the SuiteProjects Pro Data Dictionary for details. See Database Guide.
To view the SuiteProjects Pro Data Dictionary, use the following URL: https://<account-domain>/database/single_user.html.
-
The URL includes the domain name for your SuiteProjects Pro account
<account-domain>. For more information about your account-specific domain name, see Your 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 SuiteProjects Pro Help Center using the link in the navigation bar if you have the View Help Center role permission.
SuiteProjects Pro Records Available for Export and Import
The following table lists the SuiteProjects Pro record types available for import and export using Integration Manager. Some record types are supported only when exporting information from SuiteProjects Pro to a CSV file, or only when importing information from a CSV file into SuiteProjects Pro. Check marks under the Export and Import columns indicate that you can export or import records of that type.
When exporting information from SuiteProjects Pro 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.
|
SuiteProjects Pro 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) |
|
|
— |
|
— |
|
|
— |
|
— |
|
|
— |
|
— |
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
— |
|
|
|
— |
|
|
|
|
|
|
|
|
|
— |
— |
|
|
|
— |
|
|
|
|
— |
— |
|
|
— |
|
— |
|
|
|
— |
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
— |
|
— |
|
|
— |
|
— |
|
|
|
|
|
|
|
— |
|
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
— |
|
|
|
— |
— |
|
|
|
|
|
|
|
|
— |
|
|
|
|
— |
|
|
|
— |
— |
|
|
|
|
— |
|
|
|
|
— |
|
