📚 SAP Business One SDK Help

Table Name: OKPI

Table Description: Key Performance Indicator Package

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
Code KPI Code nVarChar 250 -      
Name KPI Name nVarChar 250 -      
Desc Description nVarChar 254 -      
ValueType Value Type nVarChar 200 -      
ValueQid Value Query Number Int 11 -      
ViewName Value View Name nVarChar 250 -      
ViewCtg View Catalog nVarChar 250 -      
ViewSyn View Synonym nVarChar 250 -      
TrendType Trend Type nVarChar 250 -      
TrendQid Trend Query Number Int 11 -      
GoalValue Goal Value Num 19.6 -      
GoalQid Goal Query Number nVarChar 11 -      
GoalDesc Goal Description nVarChar 250 -      
CalcFrml Calculation Formula nVarChar 250 -      
Visible Visible For Front End VarChar 1 - Y    
SBetter Smaller Value is Better VarChar 1 - Y    
Author Creator nVarChar 32 -      
Version Version nVarChar 13 -      
CreateDate Create Date Date 8 -      
CreateTime Create Time Int 6 -      
IsSystem Is System VarChar 1 - N    
MeasUnit Measuring Unit nVarChar 50 - 0    
RevSign Reverse Sign VarChar 1 - N    
Unit Unit nVarChar 250 -      
Key Unique Field
PRIMARY Yes AbsEntry
NAME Yes Name