|
|
  |
tbl_Incident [Incident]
|
Property |
Value |
|
Name |
tbl_Incident |
|
Caption |
Incident |
|
X25 | |
|
USI |
X25\Workspaces\Incidents\General\MainGrid\tbl_Incident |
|
Table Group | |
|
Is administrated by field |
Yes |
|
Is administrated by record |
Yes |
|
Record change is logged |
No |
|
# |
Name |
Type |
Name |
|
1. |
ID |
Incident | |
|
2. |
CreatedOn |
Created On | |
|
3. |
Created By | ||
|
4. |
ModifiedOn |
Modification Date | |
|
5. |
Modified By | ||
|
6. |
IncidentNumber |
Unicode string [250] |
Incident Number |
|
7. |
Subject |
Unicode string [250] |
Subject |
|
8. |
Incident Types | ||
|
9. |
Incident Category | ||
|
10. |
Topic | ||
|
11. |
Account | ||
|
12. |
Contact | ||
|
13. |
Opportunity | ||
|
14. |
Offering | ||
|
15. |
Incident Source | ||
|
16. |
Contract | ||
|
17. |
SerialNumber |
Unicode string [250] |
Serial number |
|
18. |
Date |
Date | |
|
19. |
ActualStart |
Actual Start Date | |
|
20. |
DueDate |
End Date | |
|
21. |
ActualDueDate |
Actual End Date | |
|
22. |
Notification | ||
|
23. |
Satisfaction Level | ||
|
24. |
Priority | ||
|
25. |
Status | ||
|
26. |
Specialist | ||
|
27. |
Owner | ||
|
28. |
Description |
Description | |
|
29. |
DurationMinutes |
Duration Minutes | |
|
30. |
DurationHours |
Duration Hours | |
|
31. |
ActualDurationMinutes |
Actual Duration Minutes | |
|
32. |
ActualDurationHours |
Actual Duration Hours | |
|
33. |
EnteringDate |
Input Date |
|
# |
Relation name |
Field |
Table |
Cascade relation |
|
1. |
FIncidentAccountID |
AccountID |
No | |
|
2. |
FIncidentContactID |
ContactID |
No | |
|
3. |
FIncidentOpportunityID |
OpportunityID |
No | |
|
4. |
FIncidentOfferingID |
OfferingID |
No | |
|
5. |
FIncidentIncidentOriginID |
IncidentOriginID |
No | |
|
6. |
FIncidentContractID |
ContractID |
No | |
|
7. |
FIncidentSpecialistID |
SpecialistID |
No | |
|
8. |
FIncidentOwnerID |
OwnerID |
No | |
|
9. |
FIncidentIncidentTypeID |
IncidentTypeID |
No | |
|
10. |
FIncidentIncidentCategoryID |
IncidentCategoryID |
No | |
|
11. |
FIncidentNotifiedID |
NotifiedID |
No | |
|
12. |
FIncidentSatisfactionLevelID |
SatisfactionLevelID |
No | |
|
13. |
FIncidentPriorityID |
PriorityID |
No | |
|
14. |
FIncidentStatusID |
StatusID |
No | |
|
15. |
FIncidentTopicID |
TopicID |
No |
|
# |
Name |
Unique |
Structure |
|
1. |
IIncident |
No |
TopicID  |
|
2. |
IIncidentStatusID |
No |
StatusID |
|
3. |
IIncidentPriorityID |
No |
PriorityID |
|
4. |
IIncidentSatisfactionLevelID |
No |
SatisfactionLevelID |
|
5. |
IIncidentNitificationID |
No |
NotifiedID |
|
6. |
IIncidentIncidentCategoryID |
No |
IncidentCategoryID |
|
7. |
IIncidentIncidentTypeID |
No |
IncidentTypeID |
|
8. |
IIncidentOwnerID |
No |
OwnerID |
|
9. |
IIncidentSpecialistID |
No |
SpecialistID |
|
10. |
IIncidentContractID |
No |
ContractID |
|
11. |
IIncidentIncidentOriginID |
No |
IncidentOriginID |
|
12. |
IIncidentOfferingID |
No |
OfferingID |
|
13. |
IIncidentOpportunityID |
No |
OpportunityID |
|
14. |
IIncidentContctID |
No |
ContactID |
|
15. |
IIncidentAccountID |
No |
AccountID |
|
16. |
IIncidentSubjectID |
No |
Subject |
|
17. |
IIncidentIncidentID |
No |
ID |
|
18. |
IIncidentIncidentNumber |
No |
IncidentNumber |
|
19. |
IIncidentDate |
No |
Date |
|
20. |
IIncidentCreatedByID |
No |
CreatedByID |
|
21. |
IIncidentModifiedByID |
No |
ModifiedByID |
|
Copyright (ñ) Terrasoft 2002-2007.
|
Properties