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