Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

application-->

APPLICATION_ID

(NUMBER)

x

x

WObjdProjectInfo

object

8 The Custom Object definition to which this milestone belongs.

--> Links to the table that contains information that is not included in ZObjectDefinition because it is only necessary for Custom Object Definitions (such as phase definitions, object autonumbering, and object naming pattern).

completionDate

COMPLETION_DATE

(DATE)

Completion Date

(General block)

x

date

The date the milestone was completed.

x

completionEventIID

COMPLETION_EVENT_IID

(NUMBER)

phase is Started/Completed

(General block)

x

Enum

Indicates whether the milestone should be automatically marked as completed when the related project phase (selected in the phase--> attribute) is started or completed.

0 - Started (STARTED)

1 - Completed (COMPLETED)

createdBy-->

CREATED_BY_ID

(NUMBER)

Created By

(Security block)

x

x

YUser

object

8 User who created the milestone record.

--> Links to specific information about the user account.

x

x

createdOn

CREATED_ON

(DATE)

Created On

(Security block)

x

date

Date the milestone record was created.

x

x

createdOnBehalfOf

CREATED_ON_ BEHALF_OF_ID

x

TContact

object

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

X

defaultCategory-->

DEFAULT_CATEGO RY_ID

(NUMBER)

Indicated by a blue diamond (Categories block)

x

x

YRecentlyViewedRecord

object

8 The default category for the milestone.

--> Links to specific information about the category.

x

detailList-->

n/a

x

x

EMileDetail

In Object Navigator, links to Category list which is displayed in the UI only.

8 The list of categories added to the current object.

--> In the object model, the added categories link to the values that have been added for custom fields, according to field type.

--> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it.

documentFolder-->

DOCUMENT_FOLD ER_ID

(NUMBER)

x

TDocument

object

Links to specific information about the document folder.

extensionDate

EXTENSION_DATE

(DATE)

Extension

(General block)

x

date

The extended date of the milestone.

x

groupAccessList-->

n/a

x

EInvlGroupAccess

Links to the group security information entered through the Security block of the record.

historyList-->

n/a

History tab

x

x

THistory

8 The list of histories that are related to the milestone record.

--> Links to specific history information for all of the milestone's history records.

isPhaseUsed

IS_PHASE_USED

(NUMBER)

Mark this milestone complete when (check box - General block)

x

boolean

Indicates whether the milestone record is set to be marked as complete automatically when the related project record reaches a certain phase.

0 - Do not use phase to mark milestone as complete

1 - Use phase to mark milestone as complete

milestoneDate

MILESTONE_DATE

(DATE)

x

date

This contains one of the last of the three dates for the milestone record in the following order.

Projected Date

Extended Date

Completion Date

For example, if the Projected Date and Extended Date have values, then the Milestone Date will be populated with the same date as the Extended Date.

modifiedBy-->

MODIFIED_BY_ID

(NUMBER)

x

x

YUser

object

8 The user who last modified the record.

--> Links to specific information about the user account.

modifiedOn

MODIFIED_ON

(DATE)

x

date

The date on which the record was last modified.

note-->

NOTE_ID

(NUMBER)

x

JNote

object

Links to the table that contains the text entered into the Notes field of the record.

phase-->

PHASE_ID

(NUMBER)

x

x

WObjdPhaseType

object

8 The phase of the related project record at which the milestone will be automatically marked as complete.

--> Links to definition information for the phase.

x

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the milestone record.

project-->

PROJECT_ID

(NUMBER)

x

x

TProject

object

8 The project to which this milestone belongs.

--> Links to specific information about the project record.

x

projectedDate

PROJECTED_DATE

(DATE)

Projected Date

(General block)

x

date

The projected date of completion of the milestone.

x

x

securityTypeIID

SECURITY_TYPE_I ID

(NUMBER)

Public/Private (Security block)

x

Enum

Specifies whether the milestone record is public or private.

0 - Public (PUBLIC)

2 - Private (PRIVATE)

shortDescription

SHORT_DESCRIPT ION

(VARCHAR2) (250)

Subject

(General block)

x

string (250)

The subject (or description) of the milestone record.

x

userAccessList-->

n/a

x

EInvlUserAccess

Links to the user security information entered through the Security block of the record.

version

VERSION

(NUMBER)

x

int

Indicates how many times the milestone record has been updated.