|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Project Plan Steps
Table Name: APJ1
Table Description: Project Plan Steps
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| StepCode | Step Code | Int | 11 | - | Â | Â | Â |
| Father | Father Step Code | Int | 11 | - | Â | Â | Â |
| VisOrder | Visual Order | Int | 11 | - | Â | Â | Â |
| Level | Node Level | Int | 11 | - | Â | Â | Â |
| StepName | Step Name | nVarChar | 254 | - | Â | Â | Â |
| StepInfo | Step Info | nVarChar | 254 | - | Â | Â | Â |
| StepNotes | Step Notes | nVarChar | 254 | - | Â | Â | Â |
| StepLink | Step Link to Menu ID | nVarChar | 32 | - | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| EndDate | End Date | Date | 8 | - | Â | Â | Â |
| IsComplete | Is Complete | VarChar | 1 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | Â | Â | Â |
| Owner | Owner | nVarChar | 254 | OUSR | Â | Â | Â |
| Status | Status | Int | 11 | - | 0 | Â | Â |
| Duration | Duration | Num | 19.6 | - | Â | Â | Â |
| PlanTime | Planned Time | Num | 19.6 | - | Â | Â | Â |
| AtcEntry | Attachment Entry | Int | 11 | OATC | Â | Â | Â |
| TotalPTime | Total Planned Time | Num | 19.6 | - | Â | Â | Â |
| QueryID | Step Link Query ID | Int | 11 | OUQR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | StepCode |
| Â | Â | LogInstanc |