Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Code (Code) | Code10 | NotBlank: Yes | |
| 2 | Name (Name) | Text50 | ||
| 3 | Commission % (Commission %) | Decimal (2:2) | MaxValue: 100 | |
| 5050 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
| 5051 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 5052 | E-Mail (E-Mail) | Text80 [E-Mail] | ||
| 5053 | Phone No. (Phone No.) | Text30 [Phone No.] | ||
| 5054 | Next To-do Date (Next To-do Date) | Date |
|
Editable: No FlowField |
| 5055 | No. of Opportunities (No. of Opportunities) | Integer |
|
Editable: No FlowField |
| 5056 | Estimated Value (LCY) (Estimated Value (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5057 | Calcd. Current Value (LCY) (Calcd. Current Value (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5058 | Date Filter (Date Filter) | Date | FlowFilter | |
| 5059 | No. of Interactions (No. of Interactions) | Integer |
|
Editable: No FlowField |
| 5060 | Cost (LCY) (Cost (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5061 | Duration (Min.) (Duration (Min.)) | Decimal (0:0) |
|
Editable: No FlowField |
| 5062 | Job Title (Job Title) | Text30 | ||
| 5063 | Action Taken Filter (Action Taken Filter) | Option | [ ,Next,Previous,Updated,Jumped,Won,Lost] | FlowFilter |
| 5064 | Sales Cycle Filter (Sales Cycle Filter) | Code10 |
|
FlowFilter |
| 5065 | Sales Cycle Stage Filter (Sales Cycle Stage Filter) | Integer |
|
FlowFilter |
| 5066 | Probability % Filter (Probability % Filter) | Decimal (1:1) | MaxValue: 100 | FlowFilter |
| 5067 | Completed % Filter (Completed % Filter) | Decimal (1:1) | MaxValue: 100 | FlowFilter |
| 5068 | Avg. Estimated Value (LCY) (Avg. Estimated Value (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5069 | Avg.Calcd. Current Value (LCY) (Avg.Calcd. Current Value (LCY)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5070 | Contact Filter (Contact Filter) | Code20 |
|
FlowFilter |
| 5071 | Contact Company Filter (Contact Company Filter) | Code20 |
|
FlowFilter |
| 5072 | Campaign Filter (Campaign Filter) | Code20 |
|
FlowFilter |
| 5073 | Estimated Value Filter (Estimated Value Filter) | Decimal | AutoFormatType: 1 | FlowFilter |
| 5074 | Calcd. Current Value Filter (Calcd. Current Value Filter) | Decimal | AutoFormatType: 1 | FlowFilter |
| 5075 | Chances of Success % Filter (Chances of Success % Filter) | Decimal (0:0) | MaxValue: 100 | FlowFilter |
| 5076 | To-do Status Filter (To-do Status Filter) | Option | [Not Started,In Progress,Completed,Waiting,Postponed] | FlowFilter |
| 5077 | Closed To-do Filter (Closed To-do Filter) | Boolean | FlowFilter | |
| 5078 | Priority Filter (Priority Filter) | Option | [Low,Normal,High] | FlowFilter |
| 5079 | Team Filter (Team Filter) | Code10 |
|
FlowFilter |
| 5082 | Opportunity Entry Exists (Opportunity Entry Exists) | Boolean |
|
Editable: No FlowField |
| 5083 | To-do Entry Exists (To-do Entry Exists) | Boolean |
|
Editable: No FlowField |
| 5084 | Close Opportunity Filter (Close Opportunity Filter) | Code10 |
|
FlowFilter |
| 5085 | Search E-Mail (Search E-Mail) | Code80 | ||
| 5086 | E-Mail 2 (E-Mail 2) | Text80 [E-Mail] |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Code (Code) | Clustered: Yes | |
| 1 | Search E-Mail (Search E-Mail) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Campaign Filter (Campaign Filter) | Campaign | No. (No.) |
|
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 |
| 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 |
| Team Filter (Team Filter) | Team | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Attendee | Attendee No. (Attendee No.) |
|
1..n |
| Bank Account | Our Contact Code (Our Contact Code) |
|
1..n |
| Bank Account Ledger Entry | Our Contact Code (Our Contact Code) |
|
1..n |
| CV Ledger Entry Buffer | Salesperson Code (Salesperson Code) |
|
1..n |
| Campaign | Salesperson Filter (Salesperson Filter) |
|
1..n |
| Campaign Entry | Salesperson Code (Salesperson Code) |
|
1..n |
| Contact | Salesperson Filter (Salesperson Filter) |
|
1..n |
| Cust. Ledger Entry | Salesperson Code (Salesperson Code) |
|
1..n |
| Customer | Salesperson Code (Salesperson Code) |
|
1..n |
| Default Dimension | No. (No.) |
|
1..n |
| Employee | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Filed Service Contract Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Gen. Journal Line | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Interaction Log Entry | Salesperson Code (Salesperson Code) |
|
1..n |
| Item Journal Line | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Marketing Setup | Default Salesperson Code (Default Salesperson Code) |
|
1..n |
| Opportunity | Salesperson Code (Salesperson Code) |
|
1..n |
| Opportunity Entry | Salesperson Code (Salesperson Code) |
|
1..n |
| Phys. Inventory Ledger Entry | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Purch. Cr. Memo Hdr. | Purchaser Code (Purchaser Code) |
|
1..n |
| Purch. Inv. Header | Purchaser Code (Purchaser Code) |
|
1..n |
| Purch. Rcpt. Header | Purchaser Code (Purchaser Code) |
|
1..n |
| Purchase Header | Purchaser Code (Purchaser Code) |
|
1..n |
| Purchase Header Archive | Purchaser Code (Purchaser Code) |
|
1..n |
| RM Matrix Management | Salesperson Filter (Salesperson Filter) |
|
1..n |
| Return Receipt Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Return Shipment Header | Purchaser Code (Purchaser Code) |
|
1..n |
| Sales Cr.Memo Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Sales Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Sales Header Archive | Salesperson Code (Salesperson Code) |
|
1..n |
| Sales Invoice Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Sales Shipment Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Segment Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Segment Line | Salesperson Code (Salesperson Code) |
|
1..n |
| Segment Wizard Filter | Salesperson Code Filter (Salesperson Code Filter) |
|
1..n |
| Service Contract Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Service Cr.Memo Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Service Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Service Invoice Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Service Shipment Header | Salesperson Code (Salesperson Code) |
|
1..n |
| Standard General Journal Line | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Standard Item Journal Line | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Team | Salesperson Filter (Salesperson Filter) |
|
1..n |
| Team Salesperson | Salesperson Code (Salesperson Code) |
|
1..n |
| To-do | Completed By (Completed By) |
|
1..n |
| Value Entry | Salespers./Purch. Code (Salespers./Purch. Code) |
|
1..n |
| Vendor | Purchaser Code (Purchaser Code) |
|
1..n |
| Vendor Ledger Entry | Purchaser Code (Purchaser Code) |
|
1..n |