|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MetaData Tables
Table Name: MTBL
Table Description: MetaData Tables
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Name | Table Name | nVarChar | 5 | - | Â | Â | Â |
| ViewOrder | View Order | Int | 6 | - | 30 | -1 | Invisible |
| Â | Â | Â | Â | Â | Â | 10 | Administration |
| Â | Â | Â | Â | Â | Â | 20 | Administration Plus |
| Â | Â | Â | Â | Â | Â | 30 | Master Data |
| Â | Â | Â | Â | Â | Â | 40 | Document Line |
| Â | Â | Â | Â | Â | Â | 50 | Document |
| Â | Â | Â | Â | Â | Â | 60 | Log File |
| Â | Â | Â | Â | Â | Â | 70 | Payment Line |
| Â | Â | Â | Â | Â | Â | 80 | Payments |
| Type | Table Type | Int | 6 | - | 1 | 1 | User OM |
| Â | Â | Â | Â | Â | Â | 2 | User |
| Â | Â | Â | Â | Â | Â | 3 | System OM |
| Â | Â | Â | Â | Â | Â | 4 | System |
| Descr | Description | nVarChar | 254 | - | Â | Â | Â |
| Category | Category | Int | 6 | - | 0 | Â | Â |
| SubCateg | Sub Category | Int | 6 | - | 0 | Â | Â |
| Dirty | Dirty | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Created | Creation Date | Date | 8 | - | Â | Â | Â |
| Updated | Update Date | Date | 8 | - | Â | Â | Â |
| InfoCtgory | Information Category | Int | 6 | - | 0 | Â | Â |
| ResCode | Resource Code from RSBD | Int | 11 | - | -1 | Â | Â |
| RevCode | Revision Code | Int | 11 | - | -1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Name |
| Â | Â | ResCode |
| Â | Â | RevCode |