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 |