Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | No. | Code20 | ||
2 | Team Code | Code10 |
|
|
3 | Salesperson Code | Code10 |
|
|
4 | Campaign No. | Code20 |
|
|
5 | Contact No. | Code20 |
|
|
6 | Opportunity No. | Code20 |
|
|
7 | Segment No. | Code20 |
|
|
8 | Type | Option | [ ,Meeting,Phone Call] | |
9 | Date | Date | NotBlank: Yes | |
10 | Status | Option | [Not Started,In Progress,Completed,Waiting,Postponed] | |
11 | Priority | Option | [Low,Normal,High] InitValue: Normal |
|
12 | Description | Text50 | ||
13 | Closed | Boolean | ||
14 | Date Closed | Date | Editable: No | |
15 | No. Series | Code10 |
|
Editable: No |
16 | Comment | Boolean |
|
Editable: No FlowField |
17 | Canceled | Boolean | ||
18 | Contact Name | Text50 |
|
Editable: No FlowField |
19 | Team Name | Text50 |
|
NotBlank: No Editable: No FlowField |
20 | Salesperson Name | Text50 |
|
Editable: No FlowField |
21 | Campaign Description | Text50 |
|
Editable: No FlowField |
22 | Contact Company No. | Code20 |
|
|
23 | Contact Company Name | Text50 |
|
Editable: No FlowField |
24 | Recurring | Boolean | ||
25 | Recurring Date Interval | DateFormula | ||
26 | Calc. Due Date From | Option | [ ,Due Date,Closing Date] | |
27 | Opportunity Description | Text50 |
|
Editable: No FlowField |
28 | Start Time | Time | ||
29 | Duration | Duration | ||
31 | Opportunity Entry No. | Integer |
|
|
32 | Last Date Modified | Date | ||
33 | Last Time Modified | Time | ||
34 | All Day Event | Boolean | ||
35 | Location | Text50 | ||
36 | Organizer To-do No. | Code20 |
|
|
37 | Interaction Template Code | Code10 |
|
|
38 | Language Code | Code10 |
|
|
39 | Attachment No. | Integer | ||
40 | Subject | Text50 | ||
41 | Unit Cost (LCY) | Decimal (2:2) | ||
42 | Unit Duration (Min.) | Decimal (0:2) | ||
43 | No. of Attendees | Integer |
|
Editable: No FlowField |
44 | Attendees Accepted No. | Integer |
|
Editable: No FlowField |
45 | System To-do Type | Option | [Organizer,Salesperson Attendee,Contact Attendee,Team] | |
46 | Completed By | Code10 |
|
|
47 | Ending Date | Date | ||
48 | Ending Time | Time | ||
9501 | Wizard Step | Option | [ ,1,2,3,4,5,6] | Editable: No |
9504 | Team To-do | Boolean | ||
9505 | Send on finish | Boolean | ||
9506 | Segment Description | Text50 | ||
9507 | Team Meeting Organizer | Code20 | ||
9508 | Activity Code | Code10 |
|
|
9509 | Wizard Contact Name | Text50 | ||
9510 | Wizard Campaign Description | Text50 | ||
9511 | Wizard Opportunity Description | Text50 |
Keys
# | Fields | ||
---|---|---|---|
0 | No. | Clustered: Yes | |
1 | Contact Company No.,Date,Contact No.,Closed | ||
2 | Contact Company No.,Contact No.,Closed,Date | ||
3 | Salesperson Code,Date,Closed | ||
4 | Team Code,Date,Closed | ||
5 | Campaign No.,Date | ||
6 | Segment No.,Date | ||
7 | Opportunity No.,Date,Closed | ||
8 | Organizer To-do No.,System To-do Type |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Activity Code | Activity | Code |
|
1..n |
Campaign No. | Campaign | No. |
|
1..n |
Contact Company No. | Contact |
|
1..n | |
Interaction Template Code | Interaction Template | Code |
|
1..n |
Language Code | Language | Code |
|
1..n |
No. Series | No. Series | Code |
|
1..n |
Opportunity No. | Opportunity | No. |
|
1..n |
Opportunity Entry No. | Opportunity Entry | Entry No. |
|
1..n |
Completed By | Salesperson/Purchaser | Code |
|
1..n |
Segment No. | Segment Header | No. |
|
1..n |
Team Code | Team | Code |
|
1..n |
Organizer To-do No. | To-do | No. |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Attendee | To-do No. |
|
1..n |
Interaction Log Entry | To-do No. |
|
1..n |
Rlshp. Mgt. Comment Line | No. |
|
1..n |
Segment Line | To-do No. |
|
1..n |
To-do | Organizer To-do No. |
|
1..n |
To-do Interaction Language | To-do No. |
|
1..n |