|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Project Management Subproject - History
Table Name: APHA
Table Description: Project Management Subproject - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| OWNER | Owner | Int | 11 | OHEM | Â | Â | Â |
| NAME | Name | nVarChar | 254 | - | Â | Â | Â |
| START | Subproject Start Date | Date | 8 | - | Â | Â | Â |
| FINISHED | Deduction - Percentage | Num | 19.6 | - | Â | Â | Â |
| ParentID | Parent Subproject | Int | 11 | - | Â | Â | Â |
| ProjectID | Project No. | Int | 11 | OPMG | Â | Â | Â |
| Code | Subproject No. | Int | 11 | - | Â | Â | Â |
| TYP | Subproject Type | Int | 11 | PMC1 | Â | Â | Â |
| CONTRIB | Subproject Contribution - Percentage | Num | 19.6 | - | Â | Â | Â |
| STATUS | Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| END | Subproject End Date | Date | 8 | - | Â | Â | Â |
| COST | Actual Cost | Num | 19.6 | - | Â | Â | Â |
| PLANNED | Planned Cost | Num | 19.6 | - | Â | Â | Â |
| Level | Depth of Subproject within the project | Int | 11 | - | Â | Â | Â |
| DUEDATE | Due Date | Date | 8 | - | Â | Â | Â |
| 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 | - | Â | Â | Â |
| BPLid | Business Place ID | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |