|
|
SAP Business One SDK 10.0 - Database Tables Reference |
UDQ Parameters
Table Name: QFD2
Table Description: UDQ Parameters
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| IntrnalKey | Internal Key | Int | 11 | - | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ParamName | Parameter Name | nVarChar | 80 | - | Â | Â | Â |
| ParamDesc | Parameter Description | nVarChar | 100 | - | Â | Â | Â |
| StartIndex | Start Index | nVarChar | 254 | - | Â | Â | Â |
| SqlType | Parameter Type | Int | 6 | - | Â | Â | Â |
| SqlTypNm | Parameter Type Name | nVarChar | 50 | - | Â | Â | Â |
| DbTypeId | Database Type ID | VarChar | 1 | - | Â | Â | Â |
| DbSize | Database Size | Int | 11 | - | Â | Â | Â |
| DftValue | Default Value | nVarChar | 254 | - | Â | Â | Â |
| IsMulti | Is Multiple | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Mandatory | Is Mandatory | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EditType | Edit Type | VarChar | 1 | - | Â | Â | Â |
| RTable | Related Table | nVarChar | 100 | - | Â | Â | Â |
| RColumn | Related Column | nVarChar | 100 | - | Â | Â | Â |
| ValidVal | Valid Values | nVarChar | 254 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | IntrnalKey |
| Â | Â | ParamName |