value_type
Defines the set of possible numerical observations, including actual, planned or forecast.
The fields for the value_type table are listed in the following table.
| Field | Type | Comments |
|---|---|---|
value_type_cd |
string(50) | Required |
value_type_name |
string(200) | Required |
language_cd |
string(50) | Optional. This value must reference a row in the language table. |
tenant_cd |
string(50) | Optional. This value must reference a row in the tenant table. |
value_type code snippet
You can use the following SQL Code snippet to retrieve master data in the format that is required by the upsert API.
For example, if you lost the original files that are used to load master data, you can use the snippet to retrieve the data, make changes, and submit the changes by using the upsert API.
The command must be on a single line, not as shown here.
SELECT M.VALUE_TYPE_CD, M.VALUE_TYPE_NAME, L.LANGUAGE_CD, T.TENANT_CD FROM
SYSREC.MASTER_VALUE_TYPE M JOIN SYSREC.LANGUAGE L ON M.LANGUAGE_ID =
L.LANGUAGE_ID JOIN SYSREC.MASTER_TENANT T ON M.TENANT_ID = T.TENANT_ID;