| PRIORITYCODE |
tinyint |
|
Default = 0 |
Priority Type |
| PRIORITY |
nvarchar(6) (Computed) |
yes |
CASE [PRIORITYCODE] WHEN 0 THEN N'Normal' WHEN 1 THEN N'High' END |
Provides a translation for the 'PRIORITYCODE' field. |
| SORTORDER |
int |
|
Default = 0 |
SortOrder |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| DISPLAYAINAMELIST |
bit |
|
Default = 1 |
Display Action Item Name in Listing Fields |
| DISPLAYSYNOPSIS |
bit |
|
Default = 1 |
Display Synopsis in Listing Fields |
| DISPLAYTHUMBNAIL |
bit |
|
Default = 1 |
Display Thumbnail in Listing Fields |
| DISPLAYAINAME |
bit |
|
Default = 1 |
Display Action Item Name in Detail Fields |
| DISPLAYFULLDESCRIPTION |
bit |
|
Default = 1 |
Display Full Description in Detail Fields |
| DISPLAYLOGO |
bit |
|
Default = 1 |
Display Logo in Detail Fields |