|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Documents for Approval - Authorizers
Table Name: WDD1
Table Description: Documents for Approval - Authorizers
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| WddCode | Internal ID | Int | 11 | - | Â | Â | Â |
| StepCode | Stage Key | Int | 11 | OWST | Â | Â | Â |
| UserID | Authorizer Code | Int | 11 | OUSR | Â | Â | Â |
| Status | Status | VarChar | 1 | - | W | W | Pending |
| Â | Â | Â | Â | Â | Â | Y | Approved |
| Â | Â | Â | Â | Â | Â | N | Rejected |
| Remarks | Remarks | nVarChar | 254 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| CreateDate | Request Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Request Time | Int | 6 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 6 | - | Â | Â | Â |
| SortId | Sort Code | Int | 6 | - | Â | Â | Â |
| AuthUpdDat | Authorizer last update date | Date | 8 | - | Â | Â | Â |
| AuthUpdTim | Authorizer last update time | Int | 11 | - | Â | Â | Â |
| Substt | Substitute Authorizer User ID | Int | 11 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | WddCode |
| Â | Â | StepCode |
| Â | Â | UserID |