JDBC Driver for NetSuite

Build 22.0.8462

projecttemplate

The projecttemplate table.

Columns

Name Type References Description
id [KEY] Integer Internal ID
allowallresourcesfortasks Boolean Display All Resources for Project Task Assignment
allowexpenses Boolean Allow Expenses
allowtime Boolean Allow Time Entry
billingschedule String Billing Schedule
entityid String Name
estimatedcost Decimal Estimated Cost
estimatedgrossprofit Decimal Estimated Gross Profit
estimatedgrossprofitpercent Double Estimated Gross Profit Percent
estimatedlaborcost Decimal Estimated Labor Cost
estimatedlaborrevenue Decimal Estimated Labor Revenue
estimatedrevenue Decimal Estimated Revenue
estimatedtimeoverride Double Estimated Work
externalid String ExternalId
forecastchargerunondemand Boolean Forecast Charge Run on Demand
includecrmtasksintotals Boolean Include CRM Task In Job Totals
isexempttime Boolean Classify Time as Exempt
isinactive Boolean Inactive
isproductivetime Boolean Classify Time as Productive
isutilizedtime Boolean Classify Time as Utilized
jobbillingtype String Billing Type
jobitem String Billing Item
jobprice Decimal Project Price
limittimetoassignees Boolean Limit Time and Expenses To Resources
materializetime Boolean Create Planned Time Entries
projectmanager String Job Manager
startdate Date Start Date

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462