|
|
SAP Business One SDK 10.0 - Database Tables Reference |
SQL query
Table Name: OSQL
Table Description: SQL query
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SqlCode | SQL query code | nVarChar | 254 | - | Â | Â | Â |
| SqlName | SQL query name | nVarChar | 254 | - | Â | Â | Â |
| SqlText | SQL text | Text | 16 | - | Â | Â | Â |
| ParamList | List of bound parameter names | nVarChar | 254 | - | Â | Â | Â |
| ParamDetai | Parameter details | nVarChar | 254 | - | Â | Â | Â |
| InternalS | Internal SQL text | Text | 16 | - | Â | Â | Â |
| LogInstanc | Log instance | Int | 11 | - | 0 | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | 2 | Â | Â |
| CreateDate | Created On | Date | 8 | - | Â | Â | Â |
| UpdateDate | Updated On | Date | 8 | - | Â | Â | Â |
| DataVers | Data version | Int | 11 | - | 1 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | SqlCode |