Table Abbreviation Description Module Activity code
SNPOPPOR SOPP Project Common Data PJM

Key Description Duplicates Activity code
OPP0 SNPVCR+OPPNUM No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
CHGTYP Rate type   M 15 202      
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREHOU Creation time   HM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[SOPP]CUR Block  
OPPCLO Closed project   M 4 1      
OPPCMGNUM Campaign code   CMG     [CMG]CMG0=[SOPP]OPPCMGNUM Block  
OPPCMP BP   BPR     [BPR]BPR0=[SOPP]OPPCMP Block  
OPPDATOPN Opening date   D          
OPPEXTNUM External identifier   A 20        
OPPMCN Contact (relationship)   AIN     [AIN]AIN0=OPPMCN Block  
OPPNUM Project chrono   VCR          
OPPOPGNUM Operation code   VCR          
OPPOPGTYP Operation type   AOB     [AOB]ABREV=[SOPP]OPPOPGTYP Block  
OPPORI Source   M 15 2995      
OPPORITYP Source type   M 15 3037      
OPPORIVCR Document no.   VCR          
OPPORIVCRL Line no.   L 8        
OPPREP Sales rep   REP     [REP]REP0=[SOPP]OPPREP Block  
OPPTYP Category   ADI     [ADI]CODE=434;OPPTYP Block  
SALFCY Sales site   FCY     [FCY]FCY0=[SOPP]SALFCY Block  
SNPVCR Snapshot code   VPJ          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5