|
|
SAP Business One SDK 10.0 - Database Tables Reference |
KPI Set Array 1
Table Name: KPS1
Table Description: KPI Set Array 1
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| KpsCode | KPI Set Code | nVarChar | 15 | - | Â | Â | Â |
| LineNum | KPI Line Number | Int | 11 | - | Â | Â | Â |
| KpiName | KPI Name | nVarChar | 100 | - | Â | Â | Â |
| KpiValue1 | KPI Value 1 | Num | 19.6 | - | Â | Â | Â |
| KpiValue2 | KPI Value 2 | Num | 19.6 | - | Â | Â | Â |
| KpiValue3 | KPI Value 3 | Num | 19.6 | - | Â | Â | Â |
| KpiValue4 | KPI Value 4 | Num | 19.6 | - | Â | Â | Â |
| KpiValue5 | KPI Value 5 | Num | 19.6 | - | Â | Â | Â |
| KpiValue6 | KPI Value 6 | Num | 19.6 | - | Â | Â | Â |
| KpiValue7 | KPI Value 7 | Num | 19.6 | - | Â | Â | Â |
| KpiValue8 | KPI Value 8 | Num | 19.6 | - | Â | Â | Â |
| KpiValue9 | KPI Value 9 | Num | 19.6 | - | Â | Â | Â |
| KpiValue10 | KPI Value 10 | Num | 19.6 | - | Â | Â | Â |
| KpiValue11 | KPI Value 11 | Num | 19.6 | - | Â | Â | Â |
| KpiValue12 | KPI Value 12 | Num | 19.6 | - | Â | Â | Â |
| KpiValue13 | KPI Value 13 | Num | 19.6 | - | Â | Â | Â |
| KpiValue14 | KPI Value 14 | Num | 19.6 | - | Â | Â | Â |
| KpiValue15 | KPI Value 15 | Num | 19.6 | - | Â | Â | Â |
| KpiValue16 | KPI Value 16 | Num | 19.6 | - | Â | Â | Â |
| KpiValue17 | KPI Value 17 | Num | 19.6 | - | Â | Â | Â |
| KpiValue18 | KPI Value 18 | Num | 19.6 | - | Â | Â | Â |
| KpiValue19 | KPI Value 19 | Num | 19.6 | - | Â | Â | Â |
| KpiValue20 | KPI Value 20 | Num | 19.6 | - | Â | Â | Â |
| KpiValue21 | KPI Value 21 | Num | 19.6 | - | Â | Â | Â |
| KpiValue22 | KPI Value 22 | Num | 19.6 | - | Â | Â | Â |
| KpiValue23 | KPI Value 23 | Num | 19.6 | - | Â | Â | Â |
| KpiValue24 | KPI Value 24 | Num | 19.6 | - | Â | Â | Â |
| KpiValue25 | KPI Value 25 | Num | 19.6 | - | Â | Â | Â |
| KpiValue26 | KPI Value 26 | Num | 19.6 | - | Â | Â | Â |
| KpiValue27 | KPI Value 27 | Num | 19.6 | - | Â | Â | Â |
| KpiValue28 | KPI Value 28 | Num | 19.6 | - | Â | Â | Â |
| KpiValue29 | KPI Value 29 | Num | 19.6 | - | Â | Â | Â |
| KpiValue30 | KPI Value 30 | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | KpsCode |
| Â | Â | LineNum |
| NAME | Yes | KpsCode |
| Â | Â | KpiName |