Skip to main content
PM

PMTask

PX.Objects.PM
Field NameTypeDisplay NameForeign Key
ProjectID API Default Navigation
intProject IDPMProject
Description:No description available
TaskCD
nvarchar(30)Task ID-
Description:The unique identifier of the task. This is a segmented key, which format is configured on the Segmented Keys (CS202000) form.
AllocationIDDefault Navigation
nvarchar(15)Allocation RulePMAllocation
Description:The allocation rules.
ApproverIDDefault Navigation
intApproverEPEmployee
Description:The EPEmployee that approves or rejects the activities created under the given task. If the value is null, the approval is not required. Otherwise, either PMTask.ApproverID or PMProject.ApproverID must approve the activity before it can be released to the project.
Attributes API Nonexistent in DB
unspecified-
Description:The entity attributes.
AutoIncludeInPrj
bitAutomatically Include in Project-
Description:Specifies (if set to ) that this task should be automatically created when a template is assigned to the project. This field is used for project templates.
BillingIDDefault Navigation
nvarchar(15)Billing RulePMBilling
Description:The billing rules.
BillingOption
char(1)Billing Option-
Description:The way the project is billed.
BillSeparately
bitBill Separately-
Description:Specifies (if set to ) that the task is billed in a separate invoice.
ClassIDNonexistent in DB
nvarchar(20)-
Description:The class ID for the attributes. Always returns GroupTypes.Task.
CompletedPctMethod
char(1)Completion Method-
Description:The calculation method of the completion.
CompletedPercent
decimal(19, 4)Completed (%)-
Description:The task completion state in percents. Depending on settings, this value either maintained manually or can be auto-calculated based on the budget ratio of actual or revised values.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CustomerIDDefault Navigation
intCustomerBAccount
Description:The customer for the task. The customer is always set at the project level. The value is copied from the project.
DefaultAccrualAccountIDDefault Navigation
intAccrual AccountAccount
Description:The default accrual account. The field is used depending on the PMSetup.ExpenseAccrualSubMask mask setting.
DefaultAccrualSubIDDefault Navigation
intAccrual SubaccountSub
Description:The default accrual subaccount. The field is used depending on the PMSetup.ExpenseAccrualSubMask mask setting.
DefaultBranchIDDefault Navigation
intBranchBranch
Description:The identifier of the Branch associated with the project task. The value of this field corresponds to the value of the Branch.BranchID field.
DefaultCostCodeIDDefault Navigation
intDefault Cost CodePMCostCode
Description:No description available
DefaultExpenseAccountIDDefault Navigation
intDefault Cost AccountAccount
Description:The default cost account. The value can be used in an allocation or a cost transaction as a default for the new PMTran.
DefaultExpenseSubIDDefault Navigation
intDefault Cost SubaccountSub
Description:The default cost subaccount. The value can be used in an allocation or a cost transaction as a default for the new PMTran.
DefaultSalesAccountIDDefault Navigation
intDefault Sales AccountAccount
Description:The default sales account. The value can be used in an allocation or a billing as a default for the new PMTran and ARTran.
DefaultSalesSubIDDefault Navigation
intDefault Sales SubaccountSub
Description:The default sales subaccount. The value can be used in an allocation or a billing as a default for the new PMTran and ARTran.
Description API
nvarchar(250)Description-
Description:The description of the task.
EndDate
datetimeEnd Date-
Description:The actual date when the task is finished.
ExtRefNbr
nvarchar(30)External Ref. Nbr-
Description:The external reference number.
IsActive
bitActive-
Description:Specifies (if set to ) that the task is active. PMTran can be created only for active tasks.
IsCancelled
bitCancelled-
Description:Specifies (if set to ) that the task is cancelled.
IsCompleted
bitCompleted-
Description:Specifies (if set to ) that the task is completed.
IsDefault
bitDefault-
Description:Specifies (if set to ) that the task is default.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)-
Description:No description available
LastModifiedDateTime API
datetimeLast Modified On-
Description:No description available
LocationIDDefault Navigation
intCustomer LocationLocation
Description:The customer location.
NoteID
uniqueidentifier-
Description:No description available
PlannedEndDate
datetimePlanned End Date-
Description:The date when the task is supposed to be finished.
PlannedStartDate
datetimePlanned Start Date-
Description:The date when the task is supposed to be started.
ProgressBillingBase
nvarchar(1)Progress Billing Basis-
Description:No description available
RateTableIDDefault Navigation
nvarchar(15)Rate Table CodePMRateTable
Description:The rate table.
SelectedNonexistent in DB
bitSelected-
Description:No description available
StartDate
datetimeStart Date-
Description:The actual date when the task is started.
Status API
char(1)Status-
Description:The task status.
TaskID
int-
Description:The unique identifier of the task.
TaxCategoryIDDefault Navigation
nvarchar(15)Tax CategoryTaxCategory
Description:Obsolete field. Not used anywhere.
TemplateIDNonexistent in DB
int-
Description:No description available
tstamp
timestamp-
Description:No description available
Type
varchar(10)Type-
Description:The task type.
VisibleInAP
bitAP-
Description:Specifies (if set to ) that the task is visible in the AP module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInAR
bitAR-
Description:Specifies (if set to ) that the task is visible in the AR module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInCA
bitCA-
Description:Specifies (if set to ) that the task is visible in the CA module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInCR
bitCRM-
Description:Specifies (if set to ) that the task is visible in the CR module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInEA
bitExpenses-
Description:No description available
VisibleInGL
bitGL-
Description:Specifies (if set to ) that the task is visible in the GL module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInIN
bitIN-
Description:Specifies (if set to ) that the task is visible in the IN module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInPO
bitPO-
Description:Specifies (if set to ) that the task is visible in the PO module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInSO
bitSO-
Description:Specifies (if set to ) that the task is visible in the SO module. If the task is invisible, it will not be displayed in the field selectors in this module.
VisibleInTA
bitTime Entries-
Description:No description available
WipAccountGroupIDDefault Navigation
intNon-Billable WIP Account GroupPMAccountGroup
Description:The identifier of the work-in-progress account group associated with the task. The value of this field corresponds to the value of the PMAccountGroup.GroupID field.