This association shows the fulfillment of a planned, required or predicted material by an actual material.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
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).
material_fulfillment.fulfill
Defines the material that satisfies this fulfillment association with a planned, expected or required material. fulfill_s: Implements a foreign key to a row in one of the tables projected from entity material depending on the value of the next column (See below). fulfill_t: Defines the name of the referenced table. Possible values are: bulk_material, document, equipment_item (@material).
material_fulfillment.fulfillment
Specifies the material which represents the planned material. fulfillment_s: Implements a foreign key to a row in one of the tables projected from entity material depending on the value of the next column (See below). fulfillment_t: Defines the name of the referenced table. Possible values are: bulk_material, document, equipment_item (@material).
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".