|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MetaData Tables DKeys
Table Name: MDKY
Table Description: MetaData Tables DKeys
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TableName | Table Name | nVarChar | 5 | - | Â | Â | Â |
| HKeyIndex | HKey Index | Int | 6 | - | Â | Â | Â |
| DKeyIndex | DKey Index | Int | 6 | - | Â | Â | Â |
| FieldName | Field in Key | nVarChar | 20 | - | Â | Â | Â |
| Upper | Upper | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 11 | - | 0 | Â | Â |
| UsrSgnAttr | User Sign For Attribs Change | Int | 11 | - | -1 | Â | Â |
| ResCode | Resource Code from RSBD | Int | 11 | - | -1 | Â | Â |
| RevCode | Revision Code | Int | 11 | - | -1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TableName |
| Â | Â | HKeyIndex |
| Â | Â | DKeyIndex |
| Â | Â | ResCode |
| Â | Â | RevCode |