Man made things having mass and shape that may be used to fulfil one or more business functions.
equipment_item_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
r_existence_kd_nm (FNK, M: CHAR VARYING(40))
equipment_item.ref_existence_kind
The existence kind for the equipment item e.g. actual, planned, required or predicted.
Defines a foreign key to table r_existence_kd.
equipment_type (O: CHAR VARYING(40))
catalog_equipment.identifier
The name of the catalog equipment.
This column has been duplicated through attribute equipment_item.catalog_equipment, which establishes the relationship between the original and duplicated column(s).
This column is a duplicate of column catalog_eqp.catalog_eqp_id.
description (O: CHAR VARYING(2000))
equipment_item.description
A description of the equipment item.
inventory_obj_id (O: CHAR VARYING(40))
inventory_object.identifier
An alphanumeric string such as a label or serial number, which acts to identify the object.
catalog_eqp_s (FSK, O: CHAR VARYING(19))
equipment_item.catalog_equipment
The catalog equipment used as the basis of construction or manufacture.
Defines a foreign key to table catalog_eqp.
r_naming_system_kd (FNK, O: CHAR VARYING(40))
inventory_object.ref_naming_system
The naming system in which the identifier is defined and unique.
Defines a foreign key to table r_naming_system.