OpportunityFEPhases 
Default Table Name  OpportunityFEPhases 
Definition  
This table contains fee estimate phase data for opportunities.
 

OpportunityFEPhases Columns 
ColumnName  Domain  Datatype  NULL  Definition 
OpportunityID(PK)    varchar(32)  NO  
The opportunity number.
 
PhaseCode(PK)    nvarchar(7)  NO  
The phase number.
 
Description    nvarchar(150)  NO  
The description of the phase.
 
FEPercent    decimal(19, 4)  NO  
The default percentage of the fee for this phase.
 
TotalFee    decimal(19, 4)  NO  
The calculated total fee for this phase.
 
Percent1    decimal(19, 4)  NO  
This field determines what fraction of the first functional group fee is attributed to this phase.
 
Fee1    decimal(19, 4)  NO  
The currency field to record the calculated fee for the first functional group.
 
Percent2    decimal(19, 4)  NO  
This field determines what fraction of the second functional group fee is attributed to this phase.
 
Fee2    decimal(19, 4)  NO  
The currency field to record the calculated fee for the second functional group.
 
Percent3    decimal(19, 4)  NO  
This field determines what fraction of the third functional group fee is attributed to this phase.
 
Fee3    decimal(19, 4)  NO  
The currency field to record the calculated fee for the third functional group.
 
Percent4    decimal(19, 4)  NO  
This field determines what fraction of the fourth functional group fee is attributed to this phase.
 
Fee4    decimal(19, 4)  NO  
The currency field to record the calculated fee for the fourth functional group.
 
Percent5    decimal(19, 4)  NO  
This field determines what fraction of the fifth functional group fee is attributed to this phase.
 
Fee5    decimal(19, 4)  NO  
The currency field to record the calculated fee for the fifth functional group.
 
Percent6    decimal(19, 4)  NO  
This field determines what fraction of the sixth functional group fee is attributed to this phase.
 
Fee6    decimal(19, 4)  NO  
The currency field to record the calculated fee for the sixth functional group.
 
Percent7    decimal(19, 4)  NO  
This field determines what fraction of the seventh functional group fee is attributed to this phase.
 
Fee7    decimal(19, 4)  NO  
The currency field to record the calculated fee for the seventh functional group.
 
Percent8    decimal(19, 4)  NO  
This field determines what fraction of the eighth functional group fee is attributed to this phase.
 
Fee8    decimal(19, 4)  NO  
The currency field to record the calculated fee for the eighth functional group .
 
Percent9    decimal(19, 4)  NO  
This field determines what fraction of the ninth functional group fee is attributed to this phase.
 
Fee9    decimal(19, 4)  NO  
The currency field to record the calculated fee for the ninth functional group.
 
Percent10    decimal(19, 4)  NO  
This field determines what fraction of the tenth functional group fee is attributed to this phase.
 
Fee10    decimal(19, 4)  NO  
The currency field to record the calculated fee for the tenth functional group.
 
Percent11    decimal(19, 4)  NO  
This field determines what fraction of the eleventh functional group fee is attributed to this phase.
 
Fee11    decimal(19, 4)  NO  
The currency field to record the calculated fee for the eleventh functional group.
 
Percent12    decimal(19, 4)  NO  
This field determines what fraction of the twelfth functional group fee is attributed to this phase.
 
Fee12    decimal(19, 4)  NO  
The currency field to record the calculated fee for the twelfth functional group.
 
Percent13    decimal(19, 4)  NO  
This field determines what fraction of the 13th functional group fee is attributed to this phase.
 
Fee13    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 13th functional group.
 
Percent14    decimal(19, 4)  NO  
This field determines what fraction of the 14th functional group fee is attributed to this phase.
 
Fee14    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 14th functional group.
 
Percent15    decimal(19, 4)  NO  
This field determines what fraction of the 15th functional group fee is attributed to this phase.
 
Fee15    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 15th functional group.
 
Percent16    decimal(19, 4)  NO  
This field determines what fraction of the 16th functional group fee is attributed to this phase.
 
Fee16    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 16th functional group.
 
Percent17    decimal(19, 4)  NO  
This field determines what fraction of the 17th functional group fee is attributed to this phase.
 
Fee17    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 17th functional group.
 
Percent18    decimal(19, 4)  NO  
This field determines what fraction of the 18th functional group fee is attributed to this phase.
 
Fee18    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 18th functional group.
 
Percent19    decimal(19, 4)  NO  
This field determines what fraction of the 19th functional group fee is attributed to this phase.
 
Fee19    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 19th functional group.
 
Percent20    decimal(19, 4)  NO  
This field determines what fraction of the 20th functional group fee is attributed to this phase.
 
Fee20    decimal(19, 4)  NO  
The currency field to record the calculated fee for the 20th functional group.
 

OpportunityFEPhases Primary and Unique Keys 
Key Name  Key Type  Keys 
OpportunityFEPhasesPK  PrimaryKey  OpportunityID, PhaseCode 

OpportunityFEPhases Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication