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