|
# |
Name |
Type |
Name |
|
1. |
ID |
Task | |
|
2. |
Title |
Unicode string [250] |
Task |
|
3. |
StartDate |
Start Date | |
|
4. |
DueDate |
End Date | |
|
5. |
Priority | ||
|
6. |
Owner | ||
|
7. |
Contact | ||
|
8. |
Account | ||
|
9. |
Campaign | ||
|
10. |
Opportunity | ||
|
11. |
Document | ||
|
12. |
Invoice | ||
|
13. |
Contract | ||
|
14. |
Status | ||
|
15. |
Type | ||
|
16. |
PercentDue |
Completion % | |
|
17. |
Result | ||
|
18. |
DetailedResult |
Unicode string [250] |
Detailed Result |
|
19. |
ShowInScheduler |
Show In Schedule | |
|
20. |
Description |
Description | |
|
21. |
Duration |
Duration in minutes | |
|
22. |
ActualFinishDate |
Actual End Date | |
|
23. |
ActualDurationHours |
Actual Duration Hours in minutes | |
|
24. |
ActualDurationMinutes |
Actual Duration Minutes | |
|
25. |
Workflow Item | ||
|
26. |
Incident | ||
|
27. |
RemindingToAuthorID |
Reminding To Author | |
|
28. |
RemindingToOwnerID |
Reminding To Owner | |
|
29. |
MSOutlookTaskEntryID |
Unicode string [250] |
MS Outlook Task |
|
30. |
CreatedOn |
Created On | |
|
31. |
Created By | ||
|
32. |
ModifiedOn |
Modified On | |
|
33. |
Modified By |
|
# |
Relation name |
Field |
Table |
Cascade relation |
|
1. |
FTask_AccountID |
AccountID |
No | |
|
2. |
FTask_CampaignID |
CampaignID |
No | |
|
3. |
FTask_OwnerID |
OwnerID |
No | |
|
4. |
FTaskContactID |
ContactID |
No | |
|
5. |
FTaskOpportunityID |
OpportunityID |
No | |
|
6. |
FTaskDocumentID |
DocumentID |
No | |
|
7. |
FTaskInvoiceID |
InvoiceID |
No | |
|
8. |
FTaskContractID |
ContractID |
No | |
|
9. |
FTaskTypeID |
TypeID |
No | |
|
10. |
FTaskResultID |
ResultID |
No | |
|
11. |
FTaskWorkflowItemID |
WorkflowItemID |
No | |
|
12. |
FTaskIncidentID |
IncidentID |
No | |
|
13. |
FTaskStatusID |
StatusID |
No | |
|
14. |
FTaskPriorityID |
PriorityID |
No |
|
# |
Name |
Unique |
Structure |
|
1. |
ITask |
No |
StatusID |
|
2. |
ITask1 |
No |
IncidentID |
|
3. |
ITask2 |
No |
WorkflowItemID |
|
4. |
ITask3 |
No |
ResultID |
|
5. |
ITask4 |
No |
TypeID |
|
6. |
ITask5 |
No |
ContractID |
|
7. |
ITask6 |
No |
InvoiceID |
|
8. |
ITask7 |
No |
DocumentID |
|
9. |
ITask8 |
No |
OpportunityID |
|
10. |
ITask9 |
No |
ContactID |
|
11. |
ITask10 |
No |
OwnerID |
|
12. |
ITask11 |
No |
CampaignID |
|
13. |
ITask12 |
No |
AccountID |
|
14. |
ITask13 |
No |
PriorityID |
|
15. |
ITaskCreatedByID |
No |
CreatedByID |
|
16. |
ITaskModifiedByID |
No |
ModifiedByID |
|
17. |
ITaskRemindingToAuthorID |
No |
RemindingToAuthorID |
|
18. |
ITaskRemindingToOwnerID |
No |
RemindingToOwnerID |
|
Copyright (ñ) Terrasoft 2002-2007.
|