|
|
SAP Business One SDK 10.0 - Database Tables Reference |
KPI Set
Table Name: OKPS
Table Description: KPI Set
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| KpsCode | KPI Set Code | nVarChar | 15 | - | Â | Â | Â |
| KpsName | KPI Set Name | nVarChar | 100 | - | Â | Â | Â |
| KpsType | KPI Set Type | VarChar | 1 | - | S | S | Single |
| Â | Â | Â | Â | Â | Â | Q | Quarterly |
| Â | Â | Â | Â | Â | Â | M | Monthly |
| Â | Â | Â | Â | Â | Â | P | Multiple |
| FieldsNum | KPI Set Fields Number | Int | 11 | - | Â | Â | Â |
| CreateDate | Create Date - History | Date | 8 | - | Â | Â | Â |
| UserSign | Updating User - History | Int | 6 | OUSR | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | KpsCode |