Table OPPOR
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| OPPOR | OPP | Project | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| OPP0 | OPPNUM | No | |
| OPP2 | OPPCMGNUM | Yes | |
| OPP3 | OPPOPGNUM | Yes | |
| OPP4 | OPPCMP | Yes | |
| OPP5 | OPPMCN | Yes |
| 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=[OPP]CUR | Block | ||||
| 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 | ||||||
| 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=[OPP]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=[OPP]OPPREP | Block | ||||
| OPPTYP | Category | ADI | [ADI]CODE=434;OPPTYP | Block | ||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[OPP]SALFCY | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |