|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Opportunity - Competitors
Table Name: OPR3
Table Description: Opportunity - Competitors
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| OpportId | Sequence No. | Int | 11 | - | Â | Â | Â |
| Line | Row No. | Int | 6 | - | Â | Â | Â |
| CompetId | Competitors | Int | 11 | OCMT | Â | Â | Â |
| Memo | Details | nVarChar | 50 | - | Â | Â | Â |
| Won | Won or Lost | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ThreatLevl | Threat Level | Int | 6 | - | Â | 1 | Low |
| Â | Â | Â | Â | Â | Â | 2 | Medium |
| Â | Â | Â | Â | Â | Â | 3 | High |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | OpportId |
| Â | Â | Line |