Man made things having mass and shape that may be used to fulfil one or more business functions.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
identifier (M: CHAR VARYING(80))
material.identifier
The unique name of the material.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
r_existence_kind (FNK, M: CHAR VARYING(80))
material.ref_existence_kind
The existence kind of the material e.g. actual, planned, required, or predicted.
Defines a foreign key to table r_existence_kind.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
kind_s (FSK, O: CHAR VARYING(19))
material.kind
The class which asserts the fundamental nature of the material.
Defines a foreign key to table material_class.
naming_system (FNK, O: CHAR VARYING(80))
material.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.