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.

Note:

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, use https://<account-domain>/database/single_user.html#project to 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
Accounting Period		-
Actual Cost	-	-
Agreement	-
Agreement to Project		-
Approval Process		-
Booking		-
Booking Type		-
Budget		-
Budget Allocation		-
Category	-		-
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>)		-
Contact		-
Cost Category	-	-
Cost Center
Cost Type	-	-
Currency		-
Customer
Customer PO	-
Customer PO to Project	-	-
Deal			-
DealContact		-	-
DealSchedule		-	-
Department
Entity tag		-
Envelope
Estimate			-
EstimateAdjustment		-	-
EstimateExpense		-	-
EstimateLabor		-	-
EstimatePhase		-	-
Event		-
Expense Item	-
Filter set	-	-
ForexInput	-	-
Invoice
Issue		-
Item to User Location		-
Job Code		-
Leave accrual rule
Leave accrual rule to user		-
Leave accrual trans		-
Loaded Cost		-
Payment		-
Payment Terms		-
Payment Type
Payroll Type	-
Product	-
Profile Type
Project
Project Assignment		-
Project Billing Rule
Project Billing Transaction		-
Project Group		-
Project Stage	-		-
Project Task
Project task assign		-
Projecttask_type	-	-
Proposal			-
ProposalBlock		-	-
Prospect		-
Proxy	-	-
Purchase item		-	(only non-PO purchase items)
Purchase order	-		-
Purchaser	-		-
Purchase request	-		-
Rate Card	-	-
Rate Card Item		-
Receipt
Reimbursement		-
Repeat		-
Resource Profile		-
Resource Request		-
Resource Request Queue		-
Resource Search		-
Rev. Recogn. Amount	-	-
Rev. Recogn. Rule		-
Rev. Recogn. Trans.		-
Revenue Container		-
Revenue Stage		-	-
Schedule Exception		-
ScheduleRequest
ScheduleRequest item		-	-
Service		-
Slip Projection		-	-
Slip Stage	-		-
Tag Group		-
Tag Group Attribute		-
Target Utilization		-
Tax Location	-	-
Tax Rate	-		-
Time Type	-		-
TimeBill
Timecard	-		-
Timesheet
Timesheet entry		-
Timesheet/Timecard entry		-	-
Todo		-	-
User
User Project Rate		-
User Workschedule		-
Vendor	-	-
Workspace Link		-
Workspace User		-

SuiteProjects Pro Record

Export

Export (Related Object)

Import

Check mark

Check mark

Check mark

Check mark

Check mark

Check mark

Check mark

Check mark

Check mark