resource_type
These records categorize resources.
The two supported resource types are asset and agent.
An asset is a piece of equipment that is used in
the production process. An agent is the operator
of the equipment.
The fields in the resource_type table are listed in the following table.
| Field | Type | Comments |
|---|---|---|
resource_type_cd |
string(50) | Required |
resource_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. |
resource_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.RESOURCE_TYPE_CD, M.RESOURCE_TYPE_NAME, L.LANGUAGE_CD, T.TENANT_CD FROM
SYSREC.MASTER_RESOURCE_TYPE M JOIN SYSREC.LANGUAGE L ON M.LANGUAGE_ID =
L.LANGUAGE_ID JOIN SYSREC.TENANT T ON M.TENANT_ID = T.TENANT_ID;