Smart Texts
The standard text view object provides details about smart texts that can be embedded in objects such as Service Request.
Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.StandardTextExtractPVO
Primary Keys : StdTxtId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BUOrgId | The unique identifier of the service business unit. |
| CreatedBy | The user who created the row. |
| CreationDate | The date and time when the row was created. |
| Domain | The domain or category for the smart text. |
| EnabledFlag | Indicates if the smart text is enabled for use. |
| EndDate | The date till when the smart text can be used. |
| FolderId | The foreign key to the associated folder. |
| HtmlFlag | Indicates if the smart text contains plain or rich text. |
| LastUpdateDate | The date and time when the row was last updated. |
| LastUpdateLogin | The session login of the user who last updated the row. |
| LastUpdatedBy | The user who last updated the row. |
| Object | The primary object that this smart text is used for. This is a reference to the ViewObjectCd of the Smart Text Objects view object. |
| ObjectVersionNumber | The number of times the row has been updated. |
| Scope | Indicates if the smart text is for global use or specific to a user. If the scope is user, then UserPartyId will identify the specific user. |
| StartDate | Indicates the starting date the smart text can be used. |
| StdTxtId | The unique identifier of the record. This is the primary key for the view object. |
| StdTxtNumber | The alternate public unique identifier of the record. This is the secondary key for the view object. |
| StdTxtUniqueNumber | The secondary alternate public unique identifier for the record. This is the tertiary key for the view object. |
| StdtxtName | A short descriptive name for the smart text. |
| StripeCd | The lookup code that indicates the stripe code, such as CRM, HCM, or PRM. |
| UserPartyId | The unique identifier of the user who can use this smart text. This is a foreign key to the Party view object. |