Diagrams


Table

Opportunity

DynamicsDocs.comOpportunity«Table 5092»OpportunityNo. [PK]DescriptionSalesperson CodeCampaign No.Contact No.Contact Company No.Sales Cycle CodeSales Document No.Creation DateStatus; [Not Started,In Progress,Won,L...Priority; [Low,Normal,High]ClosedDate ClosedNo. SeriesCommentCurrent Sales Cycle StageEstimated Value [LCY]Probability %Calcd. Current Value [LCY]Chances of Success %Completed %Contact NameContact Company NameSalesperson NameCampaign DescriptionSegment No.Estimated Closing DateSales Document Type; [,Quote,Order,Pos...No. of InteractionsWizard Step; [,1,2,3,4,5,6]Activate First Stage...«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 5061»Rlshp. Mgt. Comment LineTable Name; [Contact,Campaign,To-do,We...No. [PK]Sub No. [PK]Line No. [PK]DateCodeCommentLast Date Modified«Table 5065»Interaction Log EntryEntry No. [PK]Contact No.Contact Company No.DateDescriptionInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Attachment No.Cost [LCY]Duration [Min.]User IDInteraction Group CodeInteraction Template CodeCampaign No.Campaign Entry No.Campaign ResponseCampaign TargetSegment No.Evaluation; [,Very Positive,Positive,N...Time of InteractionAttempt FailedTo-do No.Salesperson CodeDelivery Status; [,In Progress,Error]CanceledCorrespondence Type; [,Hard Copy,E-Mai...Contact Alt. Address CodeLogged Segment Entry No.Document Type; [,Sales Qte.,Sales Blnk...Document No.Version No....«Table 5077»Segment LineSegment No. [PK]Line No. [PK]Contact No.Campaign No.Salesperson CodeCorrespondence Type; [,Hard Copy,E-Mai...Interaction Template CodeCost [LCY]Duration [Min.]Attachment No.Campaign ResponseContact NameInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Contact Alt. Address CodeEvaluation; [,Very Positive,Positive,N...Campaign TargetContact Company NameLanguage CodeDescriptionDateTime of InteractionAttempt FailedTo-do No.Contact Company No.Campaign Entry No.Interaction Group CodeDocument Type; [,Sales Qte.,Sales Blnk...Document No.Send Word Doc. As Attmt.Contact Via...«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 5093»Opportunity EntryEntry No. [PK]Opportunity No.Sales Cycle CodeSales Cycle StageContact No.Contact Company No.Salesperson CodeCampaign No.Date of ChangeActiveDate ClosedDays OpenAction Taken; [,Next,Previous,Updated,...Estimated Value [LCY]Calcd. Current Value [LCY]Completed %Chances of Success %Probability %Close Opportunity CodePrevious Sales Cycle StageEstimated Close DateWizard Step; [,1,2,3,4,5,6]Cancel Old To DoAction Type; [,First,Next,Previous,Ski...Sales Cycle Stage Description«Table 5107»Sales Header ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %Global 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...Closed To-do Filter...«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«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. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«Table 5090»Sales CycleCode [PK,NN]DescriptionProbability Calculation; [Multiply,Add...BlockedNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]CommentDate Filter«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 5076»Segment HeaderNo. [PK]DescriptionCampaign No.Salesperson CodeCorrespondence Type [Default]; [,Hard...Interaction Template CodeUnit Cost [LCY]Unit Duration [Min.]Attachment No.DateCampaign TargetInformation Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]No. SeriesCampaign ResponseNo. of LinesCost [LCY]Duration [Min.]Language Code [Default]Interaction Group CodeNo. of Criteria ActionsSend Word Docs. as Attmt.Ignore Contact Corres. TypeSubject [Default]Campaign Description<Salesperson Code><Campaign No.><Contact No.><Contact Company No.><Sales Cycle Code><Sales Document No.><Opportunity No.><Sales Document No.><No. Series><Segment No.><No.><Opportunity No.><Opportunity No.><Opportunity No.><Opportunity No.><Opportunity No.><Salesperson Code><Last Posting No.><Last Prepayment No.><No. Series><Posting No. Series><Shipping No. Series><Prepayment No. Series><Prepmt. Cr. Memo No. Series><Return Receipt No. Series><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><No.><No.><No.><No.><Contact No.><Contact Company No.><Campaign No.><To-do No.><Salesperson Code><Segment No.><Contact No.><Contact Company No.><Campaign No.><Salesperson Code><To-do No.><Salesperson Code><Completed By><Campaign No.><Contact No.><Contact Company No.><Segment No.><No. Series><Opportunity Entry No.><Organizer To-do No.><Sales Cycle Code><Contact No.><Contact Company No.><Salesperson Code><Campaign No.><Salesperson Code><Last Posting No.><Last Prepayment No.><Last Prepmt. Cr. Memo No.><No. Series><Posting No. Series><Shipping No. Series><Prepayment No. Series><Prepmt. Cr. Memo No. Series><Return Receipt No. Series><Campaign No.><Sell-to Contact No.><Bill-to Contact No.><Sales Cycle Filter><Contact Filter><Contact Company Filter><Salesperson Code><Salesperson Filter><Campaign Filter><Salesperson Code><Salesperson Filter><Salesperson Code><Salesperson Code><No. Series><Sales Cycle Filter><Contact Filter><Contact Company Filter><Campaign Filter><Campaign No.><Campaign No.><No. Series><Company No.><Lookup Contact No.><Sales Cycle Filter><Sell-to Contact No.><Bill-to Contact No.><Pre-Assigned No. Series><No. Series><Order No. Series><Prepayment No. Series><No. Series>

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 Description Text50
3 Salesperson Code Code10
4 Campaign No. Code20
5 Contact No. Code20
6 Contact Company No. Code20
7 Sales Cycle Code Code10
8 Sales Document No. Code20
9 Creation Date Date
10 Status Option Editable: No
11 Priority Option
12 Closed Boolean Editable: No
13 Date Closed Date Editable: No
15 No. Series Code10 Editable: No
16 Comment Boolean Editable: No
FlowField
17 Current Sales Cycle Stage Integer BlankZero: Yes
Editable: No
FlowField
18 Estimated Value (LCY) Decimal Editable: No
FlowField
19 Probability % Decimal (1:1) Editable: No
FlowField
20 Calcd. Current Value (LCY) Decimal Editable: No
FlowField
21 Chances of Success % Decimal (0:0) Editable: No
FlowField
22 Completed % Decimal (0:0) Editable: No
FlowField
23 Contact Name Text50 Editable: No
FlowField
24 Contact Company Name Text50 Editable: No
FlowField
25 Salesperson Name Text50 Editable: No
FlowField
26 Campaign Description Text50 Editable: No
FlowField
27 Segment No. Code20
28 Estimated Closing Date Date Editable: No
FlowField
29 Sales Document Type Option
30 No. of Interactions Integer Editable: No
FlowField
9501 Wizard Step Option Editable: No
9502 Activate First Stage Boolean
9503 Segment Description Text50
9504 Wizard Estimated Value (LCY) Decimal
9505 Wizard Chances of Success % Decimal (0:0)
9506 Wizard Estimated Closing Date Date
9507 Wizard Contact Name Text50
9508 Wizard Campaign Description Text50

Keys

# Fields
0 No. Clustered: Yes
1 Contact Company No.,Contact No.,Closed
2 Salesperson Code,Closed
3 Campaign No.,Closed
4 Segment No.,Closed
5 Sales Document Type,Sales Document No.

Table Relations To Other Tables

Field Related Table Related Field
Campaign No. Campaign No. 1..n
Contact Company No. Contact 1..n
No. Series No. Series Code 1..n
Sales Cycle Code Sales Cycle Code 1..n
Sales Document No. Sales Header No. 1..n
Sales Document No. Sales Invoice Header No. 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Segment No. Segment Header No. 1..n

Table Relations From Other Tables

From Table From Field
Interaction Log Entry Opportunity No. 1..n
Opportunity Entry Opportunity No. 1..n
Rlshp. Mgt. Comment Line No. 1..n
Sales Header Opportunity No. 1..n
Sales Header Archive Opportunity No. 1..n
Segment Line Opportunity No. 1..n
To-do Opportunity No. 1..n