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 | Name | Text50 | ||
| 3 | Search Name | Code50 | ||
| 4 | Name 2 | Text50 | ||
| 5 | Address | Text50 | ||
| 6 | Address 2 | Text50 | ||
| 7 | City | Text30 |
|
|
| 9 | Phone No. | Text30 [Phone No.] | ||
| 10 | Telex No. | Text20 | ||
| 15 | Territory Code | Code10 |
|
|
| 22 | Currency Code | Code10 |
|
|
| 24 | Language Code | Code10 |
|
|
| 29 | Salesperson Code | Code20 |
|
|
| 35 | Country/Region Code | Code10 |
|
|
| 38 | Comment | Boolean |
|
Editable: No FlowField |
| 54 | Last Date Modified | Date | Editable: No | |
| 84 | Fax No. | Text30 | ||
| 85 | Telex Answer Back | Text20 | ||
| 86 | VAT Registration No. | Text20 | ||
| 89 | Picture | BLOB [Bitmap] | ||
| 91 | Post Code | Code20 |
|
|
| 92 | County | Text30 | ||
| 102 | Text80 [E-Mail] | |||
| 103 | Home Page | Text80 [URL] | ||
| 107 | No. Series | Code20 |
|
|
| 140 | Image | Media [Person] | ||
| 5050 | Type | Option | [Company,Person] | |
| 5051 | Company No. | Code20 |
|
|
| 5052 | Company Name | Text50 |
|
|
| 5053 | Lookup Contact No. | Code20 |
|
Editable: No |
| 5054 | First Name | Text30 | ||
| 5055 | Middle Name | Text30 | ||
| 5056 | Surname | Text30 | ||
| 5058 | Job Title | Text30 | ||
| 5059 | Initials | Text30 | ||
| 5060 | Extension No. | Text30 | ||
| 5061 | Mobile Phone No. | Text30 [Phone No.] | ||
| 5062 | Pager | Text30 | ||
| 5063 | Organizational Level Code | Code10 |
|
|
| 5064 | Exclude from Segment | Boolean | ||
| 5065 | Date Filter | Date | FlowFilter | |
| 5066 | Next Task Date | Date |
|
Editable: No FlowField |
| 5067 | Last Date Attempted | Date |
|
Editable: No FlowField |
| 5068 | Date of Last Interaction | Date |
|
Editable: No FlowField |
| 5069 | No. of Job Responsibilities | Integer |
|
Editable: No FlowField |
| 5070 | No. of Industry Groups | Integer |
|
Editable: No FlowField |
| 5071 | No. of Business Relations | Integer |
|
Editable: No FlowField |
| 5072 | No. of Mailing Groups | Integer |
|
Editable: No FlowField |
| 5073 | External ID | Code20 | ||
| 5074 | No. of Interactions | Integer |
|
Editable: No FlowField |
| 5076 | Cost (LCY) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5077 | Duration (Min.) | Decimal (0:0) |
|
Editable: No FlowField |
| 5078 | No. of Opportunities | Integer |
|
Editable: No FlowField |
| 5079 | Estimated Value (LCY) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5080 | Calcd. Current Value (LCY) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5082 | Opportunity Entry Exists | Boolean |
|
Editable: No FlowField |
| 5083 | Task Entry Exists | Boolean |
|
Editable: No FlowField |
| 5084 | Salesperson Filter | Code20 |
|
FlowFilter |
| 5085 | Campaign Filter | Code20 |
|
FlowFilter |
| 5087 | Action Taken Filter | Option | [ ,Next,Previous,Updated,Jumped,Won,Lost] | FlowFilter |
| 5088 | Sales Cycle Filter | Code10 |
|
FlowFilter |
| 5089 | Sales Cycle Stage Filter | Integer |
|
FlowFilter |
| 5090 | Probability % Filter | Decimal (1:1) | MaxValue: 100 | FlowFilter |
| 5091 | Completed % Filter | Decimal (1:1) | MaxValue: 100 | FlowFilter |
| 5092 | Estimated Value Filter | Decimal | AutoFormatType: 1 | FlowFilter |
| 5093 | Calcd. Current Value Filter | Decimal | AutoFormatType: 1 | FlowFilter |
| 5094 | Chances of Success % Filter | Decimal (0:0) | MaxValue: 100 | FlowFilter |
| 5095 | Task Status Filter | Option | [Not Started,In Progress,Completed,Waiting,Postponed] | FlowFilter |
| 5096 | Task Closed Filter | Boolean | FlowFilter | |
| 5097 | Priority Filter | Option | [Low,Normal,High] | FlowFilter |
| 5098 | Team Filter | Code10 |
|
FlowFilter |
| 5099 | Close Opportunity Filter | Code10 |
|
FlowFilter |
| 5100 | Correspondence Type | Option | [ ,Hard Copy,Email,Fax] | |
| 5101 | Salutation Code | Code10 |
|
|
| 5102 | Search E-Mail | Code80 | ||
| 5104 | Last Time Modified | Time | ||
| 5105 | E-Mail 2 | Text80 [E-Mail] | ||
| 8050 | Xrm Id | GUID | Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | No. | Clustered: Yes | |
| 1 | Search Name | ||
| 2 | Company Name,Company No.,Type,Name | ||
| 3 | Company No. | ||
| 4 | Territory Code | ||
| 5 | Salesperson Code | ||
| 6 | VAT Registration No. | ||
| 7 | Search E-Mail | ||
| 8 | Name | ||
| 9 | City | ||
| 10 | Post Code | ||
| 11 | Phone No. |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Campaign Filter | Campaign | No. |
|
1..n |
| Close Opportunity Filter | Close Opportunity Code | Code |
|
1..n |
| Lookup Contact No. | Contact | No. |
|
1..n |
| Country/Region Code | Country/Region | Code |
|
1..n |
| Currency Code | Currency | Code |
|
1..n |
| Language Code | Language | Code |
|
1..n |
| No. Series | No. Series | Code |
|
1..n |
| Organizational Level Code | Organizational Level | Code |
|
1..n |
| Sales Cycle Filter | Sales Cycle | Code |
|
1..n |
| Sales Cycle Stage Filter | Sales Cycle Stage | Stage |
|
1..n |
| Salesperson Filter | Salesperson/Purchaser | Code |
|
1..n |
| Salutation Code | Salutation | Code |
|
1..n |
| Team Filter | Team | Code |
|
1..n |
| Territory Code | Territory | Code |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Attendee | Attendee No. |
|
1..n |
| Campaign | Contact Company Filter |
|
1..n |
| Campaign Target Group | No. |
|
1..n |
| Communication Method | Contact No. |
|
1..n |
| Cont. Duplicate Search String | Contact Company No. |
|
1..n |
| Contact | Lookup Contact No. |
|
1..n |
| Contact Alt. Addr. Date Range | Contact No. |
|
1..n |
| Contact Alt. Address | Contact No. |
|
1..n |
| Contact Business Relation | Contact No. |
|
1..n |
| Contact Duplicate | Duplicate Contact No. |
|
1..n |
| Contact Industry Group | Contact No. |
|
1..n |
| Contact Job Responsibility | Contact No. |
|
1..n |
| Contact Mailing Group | Contact No. |
|
1..n |
| Contact Profile Answer | Contact Company No. |
|
1..n |
| Contact Value | Contact No. |
|
1..1 |
| Contact Web Source | Contact No. |
|
1..n |
| Customer | Primary Contact No. |
|
1..n |
| Interaction Log Entry | Contact Company No. |
|
1..n |
| Opportunity | Contact Company No. |
|
1..n |
| Opportunity Entry | Contact Company No. |
|
1..n |
| Purch. Cr. Memo Hdr. | Pay-to Contact No. |
|
1..n |
| Purch. Inv. Entity Aggregate | Buy-from Contact No. |
|
1..n |
| Purch. Inv. Header | Pay-to Contact No. |
|
1..n |
| Purch. Rcpt. Header | Pay-to Contact no. |
|
1..n |
| Purchase Header | Pay-to Contact No. |
|
1..n |
| Purchase Header Archive | Pay-to Contact No. |
|
1..n |
| RM Matrix Management | Contact Company Filter |
|
1..n |
| Return Receipt Header | Bill-to Contact No. |
|
1..n |
| Return Shipment Header | Pay-to Contact No. |
|
1..n |
| Rlshp. Mgt. Comment Line | No. |
|
1..n |
| Sales Cr. Memo Entity Buffer | Sell-to Contact No. |
|
1..n |
| Sales Cr.Memo Header | Bill-to Contact No. |
|
1..n |
| Sales Header | Bill-to Contact No. |
|
1..n |
| Sales Header Archive | Bill-to Contact No. |
|
1..n |
| Sales Invoice Entity Aggregate | Sell-to Contact No. |
|
1..n |
| Sales Invoice Header | Bill-to Contact No. |
|
1..n |
| Sales Order Entity Buffer | Sell-To Contact No. |
|
1..n |
| Sales Quote Entity Buffer | Sell-to Contact No. |
|
1..n |
| Sales Shipment Header | Bill-to Contact No. |
|
1..n |
| Salesperson/Purchaser | Contact Company Filter |
|
1..n |
| Salutation Formula | Contact No. Filter |
|
1..n |
| Segment History | Contact No. |
|
1..n |
| Segment Line | Contact Company No. |
|
1..n |
| Service Contract Header | Bill-to Contact No. |
|
1..n |
| Service Cr.Memo Header | Bill-to Contact No. |
|
1..n |
| Service Header | Bill-to Contact No. |
|
1..n |
| Service Invoice Header | Bill-to Contact No. |
|
1..n |
| Service Shipment Header | Bill-to Contact No. |
|
1..n |
| Team | Contact Company Filter |
|
1..n |
| To-do | Contact Company No. |
|
1..n |
| Vendor | Primary Contact No. |
|
1..n |