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 | Description (Description) | Text50 | ||
3 | Starting Date (Starting Date) | Date | ||
4 | Ending Date (Ending Date) | Date | ||
5 | Salesperson Code (Salesperson Code) | Code10 |
|
|
6 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
7 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
8 | No. Series (No. Series) | Code10 |
|
Editable: No |
9 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
10 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
11 | Status Code (Status Code) | Code10 |
|
|
12 | Target Contacts Contacted (Target Contacts Contacted) | Integer |
|
Editable: No FlowField |
13 | Contacts Responded (Contacts Responded) | Integer |
|
Editable: No FlowField |
14 | Duration (Min.) (Duration (Min.)) | Decimal (0:0) |
|
Editable: No FlowField |
16 | Cost (LCY) (Cost (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
17 | No. of Opportunities (No. of Opportunities) | Integer |
|
Editable: No FlowField |
18 | Estimated Value (LCY) (Estimated Value (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
19 | Calcd. Current Value (LCY) (Calcd. Current Value (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
20 | Date Filter (Date Filter) | Date | FlowFilter | |
23 | Action Taken Filter (Action Taken Filter) | Option | [ ,Next,Previous,Updated,Jumped,Won,Lost] | FlowFilter |
24 | Sales Cycle Filter (Sales Cycle Filter) | Code10 |
|
FlowFilter |
25 | Sales Cycle Stage Filter (Sales Cycle Stage Filter) | Integer |
|
FlowFilter |
26 | Probability % Filter (Probability % Filter) | Decimal (1:1) | MaxValue: 100 | FlowFilter |
27 | Completed % Filter (Completed % Filter) | Decimal (1:1) | MaxValue: 100 | FlowFilter |
28 | Contact Filter (Contact Filter) | Code20 |
|
FlowFilter |
29 | Contact Company Filter (Contact Company Filter) | Code20 |
|
FlowFilter |
30 | Estimated Value Filter (Estimated Value Filter) | Decimal | AutoFormatType: 1 | FlowFilter |
31 | Calcd. Current Value Filter (Calcd. Current Value Filter) | Decimal | AutoFormatType: 1 | FlowFilter |
32 | Chances of Success % Filter (Chances of Success % Filter) | Decimal (0:0) | MaxValue: 100 | FlowFilter |
33 | To-do Status Filter (To-do Status Filter) | Option | [Not Started,In Progress,Completed,Waiting,Postponed] | FlowFilter |
34 | To-do Closed Filter (To-do Closed Filter) | Boolean | FlowFilter | |
35 | Priority Filter (Priority Filter) | Option | [Low,Normal,High] | FlowFilter |
36 | Team Filter (Team Filter) | Code10 |
|
FlowFilter |
37 | Salesperson Filter (Salesperson Filter) | Code10 |
|
FlowFilter |
38 | Opportunity Entry Exists (Opportunity Entry Exists) | Boolean |
|
Editable: No FlowField |
39 | To-do Entry Exists (To-do Entry Exists) | Boolean |
|
Editable: No FlowField |
40 | Close Opportunity Filter (Close Opportunity Filter) | Code10 |
|
FlowFilter |
41 | Activated (Activated) | Boolean |
|
Editable: No FlowField |
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Salesperson Code (Salesperson Code) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Status Code (Status Code) | Campaign Status | Code (Code) |
|
1..n |
Close Opportunity Filter (Close Opportunity Filter) | Close Opportunity Code | Code (Code) |
|
1..n |
Contact Company Filter (Contact Company Filter) | Contact | () |
|
1..n |
Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
Sales Cycle Filter (Sales Cycle Filter) | Sales Cycle | Code (Code) |
|
1..n |
Sales Cycle Stage Filter (Sales Cycle Stage Filter) | Sales Cycle Stage | Stage (Stage) |
|
1..n |
Salesperson Filter (Salesperson Filter) | Salesperson/Purchaser | Code (Code) |
|
1..n |
Team Filter (Team Filter) | Team | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Campaign Entry | Campaign No. (Campaign No.) |
|
1..n |
Campaign Target Group | Campaign No. (Campaign No.) |
|
1..n |
Comment Line | No. (No.) |
|
1..n |
Contact | Campaign Filter (Campaign Filter) |
|
1..n |
Default Dimension | No. (No.) |
|
1..n |
Gen. Journal Line | Campaign No. (Campaign No.) |
|
1..n |
Interaction Log Entry | Campaign No. (Campaign No.) |
|
1..n |
Interaction Template | Campaign No. (Campaign No.) |
|
1..n |
Opportunity | Campaign No. (Campaign No.) |
|
1..n |
Opportunity Entry | Campaign No. (Campaign No.) |
|
1..n |
Purch. Cr. Memo Hdr. | Campaign No. (Campaign No.) |
|
1..n |
Purch. Inv. Header | Campaign No. (Campaign No.) |
|
1..n |
Purch. Rcpt. Header | Campaign No. (Campaign No.) |
|
1..n |
Purchase Header | Campaign No. (Campaign No.) |
|
1..n |
Purchase Header Archive | Campaign No. (Campaign No.) |
|
1..n |
RM Matrix Management | Campaign Filter (Campaign Filter) |
|
1..n |
Return Receipt Header | Campaign No. (Campaign No.) |
|
1..n |
Return Shipment Header | Campaign No. (Campaign No.) |
|
1..n |
Rlshp. Mgt. Comment Line | No. (No.) |
|
1..n |
Sales Cr.Memo Header | Campaign No. (Campaign No.) |
|
1..n |
Sales Header | Campaign No. (Campaign No.) |
|
1..n |
Sales Header Archive | Campaign No. (Campaign No.) |
|
1..n |
Sales Invoice Header | Campaign No. (Campaign No.) |
|
1..n |
Sales Line Discount | Sales Code (Sales Code) |
|
1..n |
Sales Price | Sales Code (Sales Code) |
|
1..n |
Sales Price Worksheet | Sales Code (Sales Code) |
|
1..n |
Sales Shipment Header | Campaign No. (Campaign No.) |
|
1..n |
Salesperson/Purchaser | Campaign Filter (Campaign Filter) |
|
1..n |
Segment Header | Campaign No. (Campaign No.) |
|
1..n |
Segment Line | Campaign No. (Campaign No.) |
|
1..n |
Standard General Journal Line | Campaign No. (Campaign No.) |
|
1..n |
Team | Campaign Filter (Campaign Filter) |
|
1..n |
To-do | Campaign No. (Campaign No.) |
|
1..n |