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