DESIGNATIONLEVELGOAL (4.0SP20)

ID

uniqueidentifier

DESIGNATIONLEVELID

uniqueidentifier

false

The parent record for this goal.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

ORGANIZATIONEXCHANGERATEID

uniqueidentifier

true

The exchange rate used to convert from goal amount to organization goal amount.

BASECURRENCYID

uniqueidentifier

true

The base currency associated with this goal.

NAME

nvarchar(100)

false

The name of the Designation Level Goal.

GOAL

money

false

The amount of the goal.

STARTDATE

datetime

false

The start date for this goal.

ENDDATE

datetime

false

The end date for this goal.

DATEADDED

datetime

false

Indicates the date this record was added.

DATECHANGED

datetime

false

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

ORGANIZATIONGOAL

money

false

Amount of the goal in organization currency.

IX_DESIGNATIONLEVELGOAL_BASECURRENCYID

False

False

False

IX_DESIGNATIONLEVELGOAL_DATEADDED

False

False

True

IX_DESIGNATIONLEVELGOAL_DATECHANGED

False

False

False

IX_DESIGNATIONLEVELGOAL_ORGANIZATIONEXCHANGERATEID

False

False

False

PK_DESIGNATIONLEVELGOAL

True

True

False

UIX_DESIGNATIONLEVELGOAL_NAME_DESIGNATIONLEVELID

True

False

False

TR_DESIGNATIONLEVELGOAL_DESIGNATIONGOAL_INSERT

TR_DESIGNATIONLEVELGOAL_DESIGNATIONGOAL_UPDATE

TR_DESIGNATIONLEVELGOAL_AUDIT_UPDATE

TR_DESIGNATIONLEVELGOAL_AUDIT_DELETE

DESIGNATIONGOAL

DESIGNATIONLEVELGOALID