|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Project Management Document
Table Name: OPMG
Table Description: Project Management Document
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| OWNER | Owner | Int | 11 | OHEM | Â | Â | Â |
| NAME | Project Name | nVarChar | 254 | - | Â | Â | Â |
| START | Project Start Date | Date | 8 | - | Â | Â | Â |
| FINISHED | Deduction - Percentage | Num | 19.6 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| Series | Series | Int | 11 | - | Â | Â | Â |
| TYP | Project Type | VarChar | 1 | - | E | E | External |
| Â | Â | Â | Â | Â | Â | I | Internal |
| CARDCODE | BP Code | nVarChar | 15 | OCRD | Â | Â | Â |
| CARDNAME | BP Name | nVarChar | 200 | - | Â | Â | Â |
| CONTACT | Contact Person | Int | 11 | OCPR | Â | Â | Â |
| TERRITORY | Business Partner Territory | Int | 11 | OTER | Â | Â | Â |
| EMPLOYEE | Sales Employee | Int | 11 | OSLP | -1 | Â | Â |
| WithPhases | Project with Phases | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| STATUS | Status | VarChar | 1 | - | S | S | Started |
| Â | Â | Â | Â | Â | Â | P | Paused |
| Â | Â | Â | Â | Â | Â | T | Stopped |
| Â | Â | Â | Â | Â | Â | F | Finished |
| Â | Â | Â | Â | Â | Â | N | Canceled |
| DUEDATE | Due Date | Date | 8 | - | Â | Â | Â |
| CLOSING | Closing Date | Date | 8 | - | Â | Â | Â |
| FIPROJECT | Financial Project | nVarChar | 20 | OPRJ | Â | Â | Â |
| RISK | Risk Level | VarChar | 1 | - | L | L | Low |
| Â | Â | Â | Â | Â | Â | M | Medium |
| Â | Â | Â | Â | Â | Â | H | High |
| INDUSTRY | Industry Code | Int | 11 | OOND | Â | Â | Â |
| REASON | Comments | Text | 16 | - | Â | Â | Â |
| Free_Text | Free Text | Text | 16 | - | Â | Â | Â |
| BPLid | Business Place ID | Int | 11 | OBPL | Â | Â | Â |
| AtcEntry | Attachment Entry | Int | 11 | OATC | Â | Â | Â |
| Attachment | Attachments | Text | 16 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| CreateDate | Production Date | Date | 8 | - | Â | Â | Â |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | D | Erased |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |