Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(100) | Default = '' | The name of the goal. | |
AMOUNT | money | Default = 0 | The amount of the goal in the campaign's base currency. | |
STARTDATE | datetime | The date that revenue should start counting towards the goal. | ||
ENDDATE | datetime | The date that revenue should stop counting towards the goal. | ||
DATEADDED | datetime | Default = getdate() | Indicates the date this record was added. | |
DATECHANGED | datetime | Default = getdate() | Indicates the date this record was last changed. | |
TS | timestamp | Timestamp. | ||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) | Numeric representation of the timestamp. | |
ORGANIZATIONAMOUNT | money | Default = 0 | The amount of the goal in organization currency. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
CAMPAIGNID | uniqueidentifier | CAMPAIGN.LOCALID | FK to CAMPAIGN | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CURRENCYEXCHANGERATEID | uniqueidentifier | CURRENCYEXCHANGERATE.ID | The exchange rate used to convert from amount to organization amount. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_CAMPAIGNHIERARCHYGOAL_CURRENCYEXCHANGERATEID | CURRENCYEXCHANGERATEID | |||
IX_CAMPAIGNHIERARCHYGOAL_DATEADDED | DATEADDED | |||
IX_CAMPAIGNHIERARCHYGOAL_DATECHANGED | DATECHANGED | |||
PK_CAMPAIGNHIERARCHYGOAL | ID | |||
UIX_CAMPAIGNHIERARCHYGOAL_NAME_CAMPAIGNID | NAME, CAMPAIGNID |
Trigger Name | Description |
---|---|
TR_CAMPAIGNHIERARCHYGOAL_AUDIT_ETLDELETEDID | |
TR_CAMPAIGNHIERARCHYGOAL_AUDIT_UPDATE | |
TR_CAMPAIGNHIERARCHYGOAL_AUDIT_DELETE | |
TR_CAMPAIGNHIERARCHYGOAL_IU_ORGANIZATIONAMOUNT |
Referenced by | Field |
---|---|
CAMPAIGNGOAL | CAMPAIGNHIERARCHYGOALID |