|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Master Data Cleanup - Log
Table Name: MDC1
Table Description: Master Data Cleanup - Log
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | OMDC | Â | Â | Â |
| LineID | Line ID | Int | 11 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | - | Â | Â | Â |
| ObjectKey | Object Key | nVarChar | 20 | - | Â | Â | Â |
| Name | Name | nVarChar | 200 | - | Â | Â | Â |
| LastDate | Last Transaction Date | Date | 8 | - | Â | Â | Â |
| Action | Action | VarChar | 1 | - | Â | R | Remove |
| Â | Â | Â | Â | Â | Â | D | Deactivate |
| ObjectCode | Object Code | nVarChar | 100 | - | Â | Â | Â |
| ActFailed | Action Failed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| OrigAction | Original Action | VarChar | 1 | - | Â | R | Remove |
| Â | Â | Â | Â | Â | Â | D | Deactivate |
| SubObjType | Subobject Type | nVarChar | 20 | - | Â | Â | Â |
| SubObjKey | Subobject Key | nVarChar | 50 | - | Â | Â | Â |
| SubObjNam1 | Subobject Name 1 | nVarChar | 50 | - | Â | Â | Â |
| SubObjNam2 | Subobject Name 2 | nVarChar | 50 | - | Â | Â | Â |
| SubObjNam3 | Subobject Name 3 | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineID |