Table OPPORI
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
OPPORI | OPPI | Project | Common Data | PJM |
Key | Description | Duplicates | Activity code |
---|---|---|---|
OPPI | AUUID | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCCOD | Accounting code | CAC | [CAC]CAC0=37;ACCCOD;[V]GSUPCLE | Other | ||||
AUUID | Single identifier | AUUID | ||||||
CHGTYP | Rate type | M | 15 | 202 | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[OPPI]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[OPPI]CUR | Block | ||||
CUROPP | Financial currency | CUR | [TCU]TCU0=[OPPI]CUROPP | Block | ||||
DUEDAT | Due date | D | ||||||
ENDDAT | End date | D | ||||||
EREVCOM | Estimated revenue at completion | MD1 | ||||||
GRPOPP | Group | DES | ||||||
OPEDEFFCY | Operating site | FCY | [FCY]FCY0=[OPPI]OPEDEFFCY | Other | ||||
OPPCMP | BP | BPR | [BPR]BPR0=[OPPI]OPPCMP | Block | ||||
OPPDUR | Duration | C | 4 | |||||
OPPFRT | Projected | M | 4 | 1 | ||||
OPPIMPT | Intermediate batch | M | 4 | 1 | ||||
OPPINT | Internal | M | 4 | 1 | ||||
OPPMCN | Contact (relationship) | AIN | [AIN]AIN0=OPPMCN | Block | ||||
OPPMOD | Template | M | 4 | 1 | ||||
OPPNUM | Project chrono | VCR | ||||||
OPPPROACTIV | Activation | M | 4 | 1 | ||||
OPPREP | Sales rep | REP | [REP]REP0=[OPPI]OPPREP | Block | ||||
OPPTYP | Category | ADI | [ADI]CODE=434;OPPTYP | Block | ||||
PIMDESAX1 | Short description | DES | ||||||
PIMDESAXX | Description | DCO | ||||||
PRCCPL | Estimated (%) comple | RAT | ||||||
PRCCPLADI | Progress range | ADI | [ADI]CODE=385;PRCCPLADI | Block | ||||
PROBIL | Billing mode | M | 15 | 7769 | ||||
RPBAUS | Person responsible | AUS | [AUS]CODUSR=[OPPI]RPBAUS | Block | ||||
RRCC | Revenue recognition | REVREC | [REVREC]REVREC0=[V]GSOCIETE;RRCC | Block | REVRC | |||
SALFCY | Sales site | FCY | [FCY]FCY0=[OPPI]SALFCY | Other | ||||
STRDAT | Start date | D | ||||||
TASBUDAUT | Task creates budget | M | 4 | 1 | ||||
UIDSES | Session | L | 8 | |||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[OPPI]UPDUSR | Other |