Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Entry No. (Entry No.) | Integer | ||
2 | Contact No. (Contact No.) | Code20 |
|
|
3 | Contact Company No. (Contact Company No.) | Code20 |
|
|
4 | Date (Date) | Date | ||
5 | Description (Description) | Text50 | ||
6 | Information Flow (Information Flow) | Option | [ ,Outbound,Inbound] | |
7 | Initiated By (Initiated By) | Option | [ ,Us,Them] | |
8 | Attachment No. (Attachment No.) | Integer |
|
|
9 | Cost (LCY) (Cost (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
10 | Duration (Min.) (Duration (Min.)) | Decimal (0:0) | Editable: No | |
11 | User ID (User ID) | Code50 |
|
|
12 | Interaction Group Code (Interaction Group Code) | Code10 |
|
|
13 | Interaction Template Code (Interaction Template Code) | Code10 |
|
|
14 | Campaign No. (Campaign No.) | Code20 |
|
|
15 | Campaign Entry No. (Campaign Entry No.) | Integer |
|
|
16 | Campaign Response (Campaign Response) | Boolean | ||
17 | Campaign Target (Campaign Target) | Boolean | ||
18 | Segment No. (Segment No.) | Code20 | ||
19 | Evaluation (Evaluation) | Option | [ ,Very Positive,Positive,Neutral,Negative,Very Negative] | Editable: No |
20 | Time of Interaction (Time of Interaction) | Time | ||
21 | Attempt Failed (Attempt Failed) | Boolean | ||
23 | To-do No. (To-do No.) | Code20 |
|
|
24 | Salesperson Code (Salesperson Code) | Code10 |
|
|
25 | Delivery Status (Delivery Status) | Option | [ ,In Progress,Error] | |
26 | Canceled (Canceled) | Boolean | ||
27 | Correspondence Type (Correspondence Type) | Option | [ ,Hard Copy,E-Mail,Fax] | |
28 | Contact Alt. Address Code (Contact Alt. Address Code) | Code10 |
|
|
29 | Logged Segment Entry No. (Logged Segment Entry No.) | Integer |
|
|
30 | Document Type (Document Type) | Option | [ ,Sales Qte.,Sales Blnkt. Ord,Sales Ord. Cnfrmn.,Sales Inv.,Sales Shpt. Note,Sales Cr. Memo,Sales Stmnt.,Sales Rmdr.,Serv. Ord. Create,Serv. Ord. Post,Purch.Qte.,Purch. Blnkt. Ord.,Purch. Ord.,Purch. Inv.,Purch. Rcpt.,Purch. Cr. Memo,Cover Sheet,Sales Return Order,Sales Finance Charge Memo,Sales Return Receipt,Purch. Return Shipment,Purch. Return Ord. Cnfrmn.,Service Contract,Service Contract Quote,Service Quote] | |
31 | Document No. (Document No.) | Code20 | ||
32 | Version No. (Version No.) | Integer | ||
33 | Doc. No. Occurrence (Doc. No. Occurrence) | Integer | ||
34 | Contact Via (Contact Via) | Text80 | ||
35 | Send Word Docs. as Attmt. (Send Word Docs. as Attmt.) | Boolean | ||
36 | Interaction Language Code (Interaction Language Code) | Code10 |
|
|
37 | E-Mail Logged (E-Mail Logged) | Boolean | ||
38 | Subject (Subject) | Text50 | ||
39 | Contact Name (Contact Name) | Text50 |
|
Editable: No FlowField |
40 | Contact Company Name (Contact Company Name) | Text50 |
|
Editable: No FlowField |
43 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
44 | Opportunity No. (Opportunity No.) | Code20 |
|
|
45 | Postponed (Postponed) | Boolean |
Keys
# | Fields | ||
---|---|---|---|
0 | Entry No. (Entry No.) | Clustered: Yes | |
1 | Contact Company No.,Contact No.,Date,Postponed (Contact Company No.,Contact No.,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
2 | Contact Company No.,Date,Contact No.,Canceled,Initiated By,Attempt Failed,Postponed (Contact Company No.,Date,Contact No.,Canceled,Initiated By,Attempt Failed,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | MaintainSIFTIndex: No |
3 | Interaction Group Code,Date (Interaction Group Code,Date) | ||
4 | Interaction Group Code,Canceled,Date,Postponed (Interaction Group Code,Canceled,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
5 | Interaction Template Code,Date (Interaction Template Code,Date) | ||
6 | Interaction Template Code,Canceled,Date,Postponed (Interaction Template Code,Canceled,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
7 | Canceled,Campaign No.,Campaign Entry No.,Date,Postponed (Canceled,Campaign No.,Campaign Entry No.,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
8 | Campaign No.,Campaign Entry No.,Date,Postponed (Campaign No.,Campaign Entry No.,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
9 | Salesperson Code,Date,Postponed (Salesperson Code,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
10 | Canceled,Salesperson Code,Date,Postponed (Canceled,Salesperson Code,Date,Postponed) | SumIndexFields: Cost (LCY),Duration (Min.) | |
11 | Logged Segment Entry No.,Postponed (Logged Segment Entry No.,Postponed) | ||
12 | Attachment No. (Attachment No.) | ||
13 | To-do No.,Date (To-do No.,Date) | ||
14 | Contact No.,Correspondence Type,E-Mail Logged,Subject,Postponed (Contact No.,Correspondence Type,E-Mail Logged,Subject,Postponed) | ||
15 | Campaign No.,Campaign Target (Campaign No.,Campaign Target) | ||
16 | Campaign No.,Contact Company No.,Campaign Target,Postponed (Campaign No.,Contact Company No.,Campaign Target,Postponed) | ||
17 | Opportunity No.,Date (Opportunity No.,Date) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Attachment No. (Attachment No.) | Attachment | No. (No.) |
|
1..n |
Campaign No. (Campaign No.) | Campaign | No. (No.) |
|
1..n |
Campaign Entry No. (Campaign Entry No.) | Campaign Entry | Entry No. (Entry No.) |
|
1..n |
Contact Company No. (Contact Company No.) | Contact | () |
|
1..n |
Contact Alt. Address Code (Contact Alt. Address Code) | Contact Alt. Address | Code (Code) |
|
1..n |
Interaction Group Code (Interaction Group Code) | Interaction Group | Code (Code) |
|
1..n |
Interaction Template Code (Interaction Template Code) | Interaction Template | Code (Code) |
|
1..n |
Interaction Language Code (Interaction Language Code) | Language | Code (Code) |
|
1..n |
Logged Segment Entry No. (Logged Segment Entry No.) | Logged Segment | Entry No. (Entry No.) |
|
1..n |
Opportunity No. (Opportunity No.) | Opportunity | No. (No.) |
|
1..n |
Salesperson Code (Salesperson Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
To-do No. (To-do No.) | To-do | No. (No.) |
|
1..n |
User ID (User ID) | User | User Name (User Name) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Inter. Log Entry Comment Line | Entry No. (Entry No.) |
|
1..n |