Calculation Grid Item (CGI1..CGI6)

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.