Dictionary >  Module Common Data >  Table Project  

Display all Hide all

Table Abbreviation Description Module Activity code
OPPOR OPP Project Common Data  

Key Description Duplicates Activity code
OPP0 OPPNUM No  
OPP1 OPPCDA Yes  
OPP2 OPPCMGNUM Yes  
OPP3 OPPOPGNUM Yes  
OPP4 OPPCMP Yes  
OPP5 OPPMCN Yes  
OPP6 OPPREP+OPPCDA Yes  
OPP7 OPPORI+OPPORIVCR+OPPORIVCRL Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ASE Strengths 15 DCO          
AUUID Single identifier   AUUID          
CHGTYP Rate type   M 15 202      
CPP Competitor 15 ADI     [ADI]CODE=418;CPP Block  
CPPAMT Competitor amount 15 MD1          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREHOU Creation time   HM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[OPP]CUR Block  
DAM Double weighting   MD1          
DAMAVE By average   M 4 1      
DAMCUM Cumulated   M 4 1      
DON Phase end 15 M 4 1      
DONX Phase end 15 M 4 1      
ENDDAT Date 15 D          
ENDDATX Date 15 D          
OPPAAM Weighted amount   MD1          
OPPAMT Amount   MD1          
OPPCDA Desired conclusion   D          
OPPCLO Closed project   M 4 1      
OPPCMGNUM Campaign code   CMG     [CMG]CMG0=[OPP]OPPCMGNUM Block  
OPPCMP BP   BPR     [BPR]BPR0=[OPP]OPPCMP Block  
OPPDATOPN Opening date   D          
OPPDES Project description   DCO          
OPPEXTNUM External identifier   A 20        
OPPMCN Contact (relationship)   AIN     [AIN]AIN0=OPPMCN Block  
OPPNBQ Number of quotes   L 4        
OPPNUM Project chrono   VCR          
OPPOPGNUM Operation code   VCR          
OPPOPGTYP Operation type   AOB     [AOB]ABREV=[OPP]OPPOPGTYP Block  
OPPORI Source   M 15 2995      
OPPORITYP Source type   M 15 3037      
OPPORIVCR Document no.   VCR          
OPPORIVCRL Line no.   L 8        
OPPREACDA Actual conclusion   D          
OPPREP Sales rep   REP     [REP]REP0=[OPP]OPPREP Block  
OPPSRENUM Service request   SRE     [SRE]SRE0=[OPP]OPPSRENUM Block  
OPPSTE Step   ADI     [ADI]CODE=OPPSTEADI;OPPSTE Block  
OPPSTEA2 Fixed stage code   A 10        
OPPSTEADI Miscellaneous table   ADV     [ADV]CODE=[OPP]OPPSTEADI Block  
OPPSUC Success probability   L 3        
OPPTYP Category   ADI     [ADI]CODE=434;OPPTYP Block  
PBYPRJ Project probability   L 3        
PBYPRJAAM Weighted project   MD1          
REN Reason 15 DES          
RENX Reason 15 DES          
SALFCY Sales site   FCY     [FCY]FCY0=[OPP]SALFCY Block  
SBBPJT Sub-project 15 OPP     [OPP]OPP0=[OPP]SBBPJT Block  
SHC Weaknesses 15 DCO          
STE Step 15 ADI     [ADI]CODE=400;STE Block  
STEX Step 15 ADI     [ADI]CODE=421;STEX Block  
STRSTE Since   D          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5