...
| Info |
|---|
| In the user interface are the lookup tables are called Company Parameters (from version 8.0 Godfather) and previously they were called Price Parameters, which is a name (this name is used also in implementation projects project folder structure). |
A lookup table is defined by an entry in the LookupTable table. Each row in this table defines a lookup table. The rows of each one of these lookup tables are stored in one of the value tables. The LookupTable has the following properties:
uniqueNamePrimary key. A string that is used to refer to the table. Contrary to the property name, it does not have to be unique. It is the combination of uniqueName, validAfter, and simulationSet that uniquely identifies a lookup table.
validAfterPrimary key. Specifies a date after which this lookup table can be used. When multiple lookup tables share the same name, the lookup table with the most recent validAfter date will be used.
simulationSetPrimary key. A nullable string that forms
type & valueTypeThese properties do not have meaning on their own, but the combination determines which value table will be used. When the type is SIMPLE, the valueType determines the type of value. When the type is RANGE, the valueType determines the type of the key.
statusValue of the TimedObjectStatus enumeration. Determines whether — or whether – or in what context — the context – the lookup table will be used.
labelThe text that will be displayed to the end -user — to user – to represent the lookup table.
formatTypeOnly relevant for simple lookup tables. Specifies how the value in the key-value-pair will be formatted in the frontend application.
Value Tables
The value tables store the actual rows of the lookup table. It is the combination of LookupTable.type and LookupTable.valueType that determines which value type table will be used. The table below contain these details.
type (string) | valueType (string) | Table (class) |
|---|---|---|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
MatrixLookupTableValue
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIXMatrixLookupTableValueThe MatrixLookupTableValue has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.name – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.| Info |
|---|
When the LookupTable.valueType is MATRIX, the name of the key is name — rather – rather than key1. |
MatrixLookupTableValue2Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue2Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX2MatrixLookupTableValue2KeyThe MatrixLookupTableValue2Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..2 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue3Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue3Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX3MatrixLookupTableValue3KeyThe MatrixLookupTableValue3Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..3 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue4Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue4Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX4MatrixLookupTableValue4KeyThe MatrixLookupTableValue4Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..4 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue5Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue5Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX5MatrixLookupTableValue5KeyThe MatrixLookupTableValue5Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..5 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.MatrixLookupTableValue6Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the MatrixLookupTableValue6Key table.
LookupTable.type – MATRIXLookupTable.valueType – MATRIX6MatrixLookupTableValue6KeyThe MatrixLookupTableValue6Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..6 – Primary key(s), whose combination uniquely identifies a single lookup table row.attribute1..30 – Fields that can be customized with attribute metadata.LookupTableValue
The LookupTableValue table is used for two different types of lookup tables:
If the
LookupTable.typeisSIMPLE,SIMPLE_REAL_KEY,SIMPLE_INT_KEY, orSIMPLE_DATE_KEY, then theLookupTableValuetable is used to store key-value pairs. In this case, theLookupTable.valueTypedefines the type of the value in the key-value pair. The key is determined byLookupTable.type, while the value is determined by theLookupTable.valueType.If the
LookupTable.typeisRANGE, then theLookupTableValuetable is used to store key-value pairs, where the value is a pair of integers. This pair denotes a range. In this case, theLookupTable.valueTypedefines the type of the key in the key-value pair.
| Note |
|---|
The LookupTable.valueType is used for different purposes depending on the LookupTable.type. |
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the LookupTableValue table.
LookupTable.type – SIMPLE | SIMPLE_REAL_KEY | SIMPLE_INT_KEY | SIMPLE_DATE_KEY | RANGELookupTable.valueType – REAL | INT | STRING | DATELookupTableValueThe LookupTableValue has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.name – A primary key that can be used to uniquely identify a row. If LookupTable.type is RANGE, the LookupTable.valueType determines the type of name. Otherwise, the type of name is determined by LookupTable.type.value – If and only if the LookupTable.type is not RANGE, this property is used to store a value. The type of the value is determined by LookupTable.valueType.lowerBound – If and only if the type is RANGE, this property is used to store an integer that denotes the minimum value.upperBound – If and only if the type is RANGE, this property is used to store an integer that denotes the maximum value.JsonLookupTableValue
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the JsonLookupTableValue table.
LookupTable.type – JSONLookupTable.valueType – JSONJsonLookupTableValueThe JsonLookupTableValue has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.name – Primary key(s), whose combination uniquely identifies a single lookup table row.attributeExtension___<fieldName> – arbitrary number of attributeExtension fields, which can be used in the same way as attribute1..30 on matrix tables. The fields with String type do not have limited size.JsonLookupTableValue2Key
When an instance of LookupTable has the following combination of type and valueType, the lookup table’s rows will be stored in the JsonLookupTableValue2Key table.
LookupTable.type – JSONLookupTable.valueType – JSON2JsonLookupTableValue2KeyThe JsonLookupTableValue2Key has the following properties:
lookupTable.id – A reference to the LookupTable row to which this row belongs. This property can be used in queries, but will not be part of the results.key1..2 – Primary key(s), whose combination uniquely identifies a single lookup table row.attributeExtension___<fieldName> – arbitrary number of attributeExtension fields, which can be used in the same way as attribute1..30 on matrix tables. The fields with String type do not have limited size.