NetSuite SuiteProjects Pro Lite
NetSuite SuiteProjects Pro (formerly known as Oracle NetSuite OpenAir) is a cloud-based project management solution.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | FULFILLMENT_ORDER table | |
| History mode | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Setup guide
Follow our step-by-step NetSuite SuiteProjects Pro setup guide to connect NetSuite SuiteProjects Pro with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables:
BOOKINGCONTACTCUSTOMERPROJECTPROJECT_MILESTONEPROJECT_PHASEPROJECT_TASKTIME_ENTRYUSERS
We re-import the remaining tables during every sync to capture updates and deletes.
Schema information
This schema applies to all NetSuite SuiteProjects Pro connections.
Explore NetSuite SuiteProjects Pro schema ERD
See the NetSuite SuiteProjects Pro ERD in table format | NetSuite SuiteProjects Pro ERD as Markdown