|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Blocked Personal Data
Table Name: OBPD
Table Description: Blocked Personal Data
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DatSubType | Data Subject Type | nVarChar | 4 | - | Â | OCRD | Business Partner |
| Â | Â | Â | Â | Â | Â | OCPR | Contact Person |
| Â | Â | Â | Â | Â | Â | OHEM | Employee |
| Â | Â | Â | Â | Â | Â | OUSR | User |
| Â | Â | Â | Â | Â | Â | CPN1 | Campaign - BP |
| Â | Â | Â | Â | Â | Â | OUDO | User-Defined Object |
| DatSubKey | Data Subject Key No.1 | nVarChar | 15 | - | Â | Â | Â |
| DatSubKey2 | Data Subject Key No.2 | nVarChar | 50 | - | Â | Â | Â |
| TableName | Table Name | nVarChar | 21 | - | Â | Â | Â |
| KeyValue1 | Key Value No.1 | nVarChar | 50 | - | Â | Â | Â |
| KeyValue2 | Key Value No.2 | nVarChar | 50 | - | Â | Â | Â |
| KeyValue3 | Key Value No.3 | nVarChar | 50 | - | Â | Â | Â |
| KeyValue4 | Key Value No.4 | nVarChar | 50 | - | Â | Â | Â |
| KeyValue5 | Key Value No.5 | nVarChar | 50 | - | Â | Â | Â |
| FieldName | Field Name | nVarChar | 52 | - | Â | Â | Â |
| EncryptVal | Encryption Value | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encryption Initialization Vector | nVarChar | 100 | - | Â | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Creation Time | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | -1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| DATA_SUBJ | No | DatSubType |
| Â | Â | DatSubKey |
| Â | Â | DatSubKey2 |
| TABL_FIELD | No | TableName |
| Â | Â | KeyValue1 |
| Â | Â | KeyValue2 |
| Â | Â | KeyValue3 |
| Â | Â | KeyValue4 |
| Â | Â | KeyValue5 |
| Â | Â | FieldName |