|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Password Administration
Table Name: OPPA
Table Description: Password Administration
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal ID | Int | 11 | - | 1 | Â | Â |
| SecLevel | Security Level | nVarChar | 20 | - | Low | Low | Low |
| Â | Â | Â | Â | Â | Â | Medium | Medium |
| Â | Â | Â | Â | Â | Â | High | High |
| Â | Â | Â | Â | Â | Â | Custom | Custom |
| PwdExp | Password Expiration | Int | 11 | - | 90 | Â | Â |
| PwdMinLen | Password Minimum Length | Int | 11 | - | 4 | Â | Â |
| MinUppers | Password Min. Uppercase Chars. | Int | 11 | - | 0 | Â | Â |
| MinLowCase | Password Min. Lowercase Chars. | Int | 11 | - | 0 | Â | Â |
| MinDigits | Password Minimum Digits | Int | 11 | - | 0 | Â | Â |
| MinNonAlph | Password Min. Non-alphanumeric Char. | Int | 11 | - | 0 | Â | Â |
| NumPrevPwd | Pwd does not match pwd rules | Int | 11 | - | 0 | Â | Â |
| NumAuthLoc | No. of Authentications Before Acct is Locked | Int | 11 | - | 100 | Â | Â |
| PwdExample | Password Example | nVarChar | 128 | - | abcd | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |