|
ATTRIBUTES |
TYPE |
|
|
Amount |
Numeric |
|
|
AttachmentCount |
Numeric |
|
|
BillingStatus |
Numeric |
Id of the billing status. 1=Billable,2=Non-Billable,3=Don't Know,4=Approved For Billing,5=Has Been Billed |
|
BillingStatusText |
Text |
As above |
|
By |
Numeric |
Id of the user the action is for |
|
ByText |
Text |
Name of the user, on contact, the action is linked to |
|
Completed |
Date |
|
|
CompletedTimeZone |
Numeric |
|
|
CompletedTimeZoneText |
Text (50) |
|
|
CompletedTime |
Date |
Has both date & time |
|
ContactBusiness |
Numeric |
Id of the business the action is linked to |
|
ContactBusinessText |
Text |
Name of the business the action is linked to |
|
ContactPerson |
Numeric |
Id of the person the action is linked to |
|
ContactPersonText |
Text |
Name of the person the action is linked to |
|
Date |
Date |
Alias for DueDate - primarily for saved Messages Searches |
|
Description |
Text |
|
|
DueDate |
Date |
|
|
DueDateTime |
Date |
Has both date & time |
|
DueDateTimeZone |
Numeric |
|
|
DueDateTimeZoneText |
Text (50) |
|
|
EmailSent |
Text |
Y/N. For draft emails, has the email been sent |
|
Id |
Numeric |
|
|
FullLock |
Text |
Y / N |
|
Lock |
Text |
Y / N |
|
Message |
Text |
This will contain the HTML for email actions |
|
Object |
Numeric |
|
|
ObjectContext |
Numeric |
Type of object that the action is linked to. For the full list of values click here |
|
ObjectText |
Text |
|
|
Priority |
Numeric |
Id of the priority. 1=Low,2=Medium,3=High,4=Critical |
|
PriorityText |
Text |
As above |
|
Private |
Text |
Y/N |
|
Reference |
Text |
|
|
SourceAction |
Numeric |
Id of parent action |
|
Reportable |
Text |
Y / N |
|
SourceActionText |
Text |
|
|
Status |
Numeric |
Id of the action status. 1=Completed,2=Not Started,3=Cancelled,4=In Progress |
|
StatusText |
Text |
As above |
|
Subject |
Text |
Alias for ActionReference - primarily for saved Messages Searches |
|
Tags |
Text |
|
|
TargetDate |
Date |
|
|
TargetDateTimeZone |
Numeric |
|
|
TargetDateTimeZoneText |
Text (50) |
|
|
TargetDateTime |
Date |
Has both date & time |
|
Text |
Text |
Extended text. For eg if the action is an email, this field would contain the email text |
|
TotalTimeHrs |
Text |
Action time in hours |
|
TotalTimeMin |
Text |
Action time in minutes |
|
Type |
Numeric |
Id of the action type. You can define your own, plus there are standard ones. eg 1=Phone Call,2=Site Visit,3=Meeting |
|
TypeText |
Text |
As above |
|
|
|
|
|
Audit Fields |
|
Click here for more information |