Calculation Grid Item (CGI1..CGI6)

Since version 10.0

Calculation Grid Item represents one line item of the Calculation Grid.

Fields

id – (Long) ID of the item.

calculationGridId – (Long) ID of the Calculation Grid to which this item belongs.

key1..6 – (String) Value of the key#, used to uniquely identify what is on the item (e.g. unique name of the Business Unit, Product Group, Customer Sales Org, etc.).

label – (String) Description of the item for the user.

comments – (String) Can be used for comments about e.g. calculated price, etc.

workStatus – (String) Status of the user’s work on this item. This is manually set by the user, while working with the item, to capture what was already done. See

Work Status Options

.

attribute1..100 – (String) Stores results of item calculation logic elements (with Display Mode Everywhere or CalculationGrid. Which logic elements will be mapped to which attributes is decided in the setup/configuration of the calculation grid.

dirty – (Boolean) Flag to indicate that the item marked for another round of recalculation by the formula.

isCompleted – (Boolean) Flag to indicate, that the item is successfully calculated.