|
|
SAP Business One SDK 10.0 - Database Tables Reference |
User-Defined Values
Table Name: CSHS
Table Description: User-Defined Values
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| FormID | Form ID | nVarChar | 100 | - | Â | Â | Â |
| ItemID | Field | nVarChar | 52 | - | Â | Â | Â |
| ColID | Column ID | nVarChar | 128 | - | -1 | Â | Â |
| ActionT | Action | Int | 6 | - | 0 | 0 | Â |
| Â | Â | Â | Â | Â | Â | 1 | Valid Values |
| Â | Â | Â | Â | Â | Â | 2 | Query |
| QueryId | Query ID | Int | 11 | OUQR | Â | Â | Â |
| IndexID | Index | Int | 11 | - | Â | Â | Â |
| Refresh | Refresh | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| FieldID | Field | nVarChar | 60 | - | Â | Â | Â |
| FrceRfrsh | Force Refresh | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ByField | By Field | VarChar | 1 | - | N | Y | When Field Changes |
| Â | Â | Â | Â | Â | Â | N | When Exiting Altered Column |
| Â | Â | Â | Â | Â | Â | C | When Column Value Changes |
| Key | Unique | Field |
| PRIMARY | Yes | IndexID |
| DETAILS | Yes | FormID |
| Â | Â | ItemID |
| Â | Â | ColID |