|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MCOL
Table Name: MCOL
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| guid | Guid | nVarChar | 36 | - | Â | Â | Â |
| fatherId | Object Id | nVarChar | 36 | - | Â | Â | Â |
| lineNum | Line Number | Int | 11 | - | Â | Â | Â |
| colName | Column Name | nVarChar | 50 | - | Â | Â | Â |
| colType | Column Type | VarChar | 1 | - | Â | Â | Â |
| colSize | Column Size | Int | 11 | - | Â | Â | Â |
| linkObjId | Link to Object Id | nVarChar | 36 | - | Â | Â | Â |
| note | Note | nVarChar | 254 | - | Â | Â | Â |
| defaultVal | Default Value | nVarChar | 254 | - | Â | Â | Â |
| editSize | Edit Size | Int | 11 | - | Â | Â | Â |
| mandatory | Mandatory | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| editType | Edit Type | VarChar | 1 | - | Â | Â | Â |
| rdOnlyAdd | Read Only for Add Mode | VarChar | 1 | - | Â | Â | Â |
| rdOnlyUpd | Read Only for Update Mode | VarChar | 1 | - | Â | Â | Â |
| supresZero | Supress Zero | VarChar | 1 | - | Â | Â | Â |
| locale | Localization | nVarChar | 254 | - | Â | Â | Â |
| onListEvt | On List Event | VarChar | 1 | - | Â | Â | Â |
| onChgEvt | On Change Event | VarChar | 1 | - | Â | Â | Â |
| noteSid | String Id | Int | 11 | - | Â | Â | Â |
| width | Width | Int | 11 | - | Â | Â | Â |
| noteList | Listview Note | nVarChar | 254 | - | Â | Â | Â |
| noteLstSid | String id of list view note | Int | 11 | - | Â | Â | Â |
| fieldType | Field Type | Int | 11 | - | Â | Â | Â |
| diType | DI API Fields | VarChar | 1 | - | Â | Â | Â |
| diBatType | DI Batch Mode Type | VarChar | 1 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | fatherId |
| Â | Â | lineNum |
| GUID | Yes | guid |
| COL_NAME | No | fatherId |
| Â | Â | colName |