Diagrams


Table

Attendee

DynamicsDocs.comAttendee«Table 5199»AttendeeTo-do No. [PK]Line No. [PK]Attendance Type; [Required,Optional,To...Attendee Type; [Contact,Salesperson]Attendee No.Attendee NameSend InvitationInvitation Response Type; [None,Accept...Invitation Sent«Table 5080»To-doNo. [PK]Team CodeSalesperson CodeCampaign No.Contact No.Opportunity No.Segment No.Type; [,Meeting,Phone Call]Date [NN]Status; [Not Started,In Progress,Compl...Priority; [Low,Normal,High]DescriptionClosedDate ClosedNo. SeriesCommentCanceledContact NameTeam NameSalesperson NameCampaign DescriptionContact Company No.Contact Company NameRecurringRecurring Date IntervalCalc. Due Date From; [,Due Date,Closin...Opportunity DescriptionStart TimeDurationOpportunity Entry No.Last Date Modified...«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P......<To-do No.><Attendee No.><Attendee No.><Salesperson Code><Completed By><Contact No.><Contact Company No.><Organizer To-do No.><Salesperson Code><Salesperson Filter><Contact Filter><Contact Company Filter><Company No.><Lookup Contact No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 To-do No. Code20
2 Line No. Integer
3 Attendance Type Option
4 Attendee Type Option
5 Attendee No. Code20
6 Attendee Name Text50 Editable: No
7 Send Invitation Boolean
8 Invitation Response Type Option
9 Invitation Sent Boolean

Keys

# Fields
0 To-do No.,Line No. Clustered: Yes
1 To-do No.,Attendee Type,Attendee No.
2 To-do No.,Attendance Type

Table Relations To Other Tables

Field Related Table Related Field
Attendee No. Contact No. 1..n
Attendee No. Salesperson/Purchaser Code 1..n
To-do No. To-do No. 1..n

Table Relations From Other Tables

From Table From Field