s20011 Field descriptions

Material Id

The ID of a standard material. Material Id is unique within a material set, that is, two different standard materials can have the same ID provided they belong to different material sets. Material sets are defined and maintained in the s20025 Standard Material Set screen.

To automatically generate a Material Id, in the d0073 ERM System Settings dialog, select the Use Generated No for Std Material checkbox.

Description

The description of a standard material.

Type

The information type of a standard material. The data in the Type field is reused in a Request For Quote (RFQ), a Purchase Order (PO), a drawing part list, a picking list, and so on.

Material Type

The code to identify the grouping of a standard material, such as, pipe, cables, valves, and so on.

If the Use Material Type as required checkbox in the d0073 ERM System Settings dialog is selected, then the Material Type field is a mandatory field.

Material Special Group

The unique code to identify the material special group related to a standard material. Based on the group selected, a concept tab (with title same as the selected group) appears in the screen. By default, the different material special groups are:

• DOO: Doors

• EL: El-Fitting

• EQU: Equipment

• INS: Instruments

• INT: Interior Material

• PIP: Pipes

• UG: User Group

• VAL: Valves and Fittings

  You can define other material special groups as per requirements in the s20002 Material Special Group screen. Each material special group is linked to a material special group concept defined in the s20009 Material Special Group Concept screen.

Unit

The unit of measure for a standard material. Only the user assigned as T Resp (Technical Responsible) for a standard material can update the Unit of the standard material, provided the material is not related to a project component, a drawing part list, a Delivery Request List (DRL), a Technical Material Requisition (TMR), an RFQ, a PO, or registered in stock.

External Status

The external status of a standard material. There are four statuses:

• Preliminary: Indicates the default status of the standard material. At the Preliminary stage, the standard material is not available for use throughout AVEVA Enterprise Resource Management.

• Fully Validated: Indicates the standard material is available for use throughout AVEVA Enterprise Resource Management.

• Not to be Used: Indicates the standard material is not available for use due to a temporary restriction (the supply is restricted or alternatives are being evaluated) or a permanent hold (the material is obsolete). If the standard material is already assigned to a Part List (PL) or a PO, you can continue to use the standard material. However, the standard material is not available for addition to any new PL or PO.

• Ready For Delete: Indicates you can delete the standard material in case a clean up of the reference data is performed. At the Ready For Delete stage, the standard material is not available for use throughout AVEVA Enterprise Resource Management.

Standard Material Status

Indicates the status of a standard material. If the Standard Material Status checkbox is selected, the standard material is available for use throughout AVEVA Enterprise Resource Management.

T Resp

Technical Responsible: The technical handler responsible for a standard material.

Standard Material Set

The ID of the material set related to a standard material. A standard material set is used to group the standard materials required for a project.

Product and Service Code

The product and service code related to a standard material.

System

The ID of the system related to a standard material.

Cost Account

The unique number to identify the primary financial cost account related to a standard material.

Classification Code

The unique material classification code to identify the classification of a standard material.

Material Category

The ID of the standard material category related to a standard material. The value in the Material Category field indicates whether a material is controlled as a standard stock material or a project related material. The valid categories are defined and marked as active in the s00001 Standard Material Categories screen.

Dimension

The dimensions of a standard material.

Size

The size and unit of a standard material.

Weight

The weight of a standard material. Weight is used in drawing part lists to calculate the total weight of a drawing in DRLs.

Shelf Life Req

Shelf Life Required: Indicates you have to register shelf life details (expiry date) of a standard material during the material receipt process.

Certificate Req

Certificate Required: Indicates you have to register a certificate document as received when a standard material is received to the stock or a warehouse.

Attachment Rel

Indicates external documents are related to a standard material.

Ext Chg

External Change: Indicates a standard material is updated from an external system through the API.

Del Des Category

Delivery Designation Category: Indicates whether a standard material is for fabrication purpose or installation purpose.

Project Restrictions

The project restrictions applicable to a standard material. The three values are:

• Exclude: Indicates you can use the standard material in all projects except for the projects listed in the Project Restriction tab.

• Include: Indicates you can use the standard material only for the projects listed in the Project Restriction tab.

• None: Indicates there is no restriction and you can use the standard material in any project.

Commodity Code

The commodity code related to a standard material.

Material Preparation

The material preparation milestone and description specifying the template used for a standard material.

Buyer Group

The unique code to identify a group of buyers responsible for purchasing a standard material.

NATO No

The NATO Stock Number (NSN) related to a standard material. The number is assigned by the National Codification Bureau (NCB) to each approved item identification.

Technical Text

The technical text for a standard material. The information in the Technical Text field is transferred to TMRs, POs, and RFQs.

1st Unit

The first alternative unit of measure for a standard material.

1st Coef

The coefficient for the first alternative unit of measure.

2nd Unit

The second alternative unit of measure for a standard material.

2nd Coef

The coefficient for the second alternative unit of measure.

3rd Unit

The third alternative unit of measure for a standard material.

3rd Coef

The coefficient for the third alternative unit of measure.

Manufacturer

The manufacturer of a standard material.

Inspection Code

The unique code to identify the inspection status of a standard material. The Inspection Code is automatically included in the PO position when the standard material is related to a PO.

Treatment Code

The unique code to identify and group materials that require same kind of handling and treatment. The Treatment Code is displayed when you receive materials in the s60028 Stock item Delivery Registration screen.

Dflt Site Id

Default Site Id: The unique ID of the default site where the standard materials are received and stored.

Dflt Storehouse

Default Storehouse: The unique code to identify the default storehouse within a site.

Dflt Location

Default Location: The unique code to identify the default location within a storehouse.

Replacement For

The unique code to identify a standard material that is replaced by another standard material.

Replaced By

The unique code to identify a standard material that is used as a replacement for another standard material.

Substitute

The unique code to identify a substitute material for a standard material.

Quan/Box

Quantity per Box: The quantity of material expected to be delivered per box or per package. The total number of boxes to purchase is determined based on the ordered quantity and the value in the Quan/Box field.

Min Order

Minimum Order: The minimum quantity of material you can reorder when reaching the Reorder Point (ROP).

Max Order

Maximum Order: The maximum quantity of material you can reorder when reaching the ROP.

Saleable Code

The unique code to identify the saleable status of a material. For example, a saleable code to indicate how valid the material is on the market and whether you can purchase the material again.

Order Policy

The unique code to identify which reorder calculation method is used for reordering a material.

ROP

Reorder Point: The stock level at which a material can be reordered.

ROQ

Reorder Quantity: The quantity of material to reorder when reaching the ROP.

Factor

The calculation factor used when calculating the ROP. If the value in the Order Policy field is E (Order by Wilson: Wilson formula), the Factor field is mandatory.

Overdelivery Tolerance (%)

The default overdelivery tolerance percentage for a material. When you add the material to a PO, the value in the Overdelivery Tolerance (%) field is copied to the PO.

Supplier Id

The unique ID to identify a supplier.

Name 1

The company name of a supplier.

Lead Time

The time taken (in days) to receive materials from a supplier after an order is placed.

Fixed Price

The fixed price defined for a standard material.

Average Price

The average price defined for a standard material. The average price value is calculated using the value of the present stock holding for the material and the value of the material at the time of receiving or invoicing, based on the set up in the d0073 ERM System Settings dialog.

Replace Price

The latest PO price for a standard material. The value in the Replace Price field is updated at the time of receiving or invoicing, based on the set up in the d0073 ERM System Settings dialog.

Currency

The default system currency set up in the d0073 ERM System Settings dialog.

Customer Column 0–Customer Column 9

Multipurpose fields for storing company specific attributes.

Hand of Door

The direction in which a door swings when opened. For example, for a door that swings right when opened, enter R.

Sill Type/Height

The sill type and sill height of a door.

Holder

The specifications of a door holder.

Closer

The specifications of a door closer.

Hand Stop side

Indicates the door handle is placed on the stop side of a door.

Hand Hinge side

Indicates the door handle is placed on the hinge side of a door.

Handle Height

The vertical height at which the handle is placed on a door.

Hinge Color

The color of a hinge on a door.

Leaf Col Stop side

The color of a door leaf on the stop side.

Leaf Col Hinge side

The color of a door leaf on the hinge side.

Frame Color

The color of the door frame.

Lock Case

The description of the lock case of a door.

Lock Cylinder

The description of the lock cylinder of a door.

Sound Reduction

The classification of sound reduction related to a door.

Counterweight

Indicates counterweight is included for a door.

Certificate

The type of certification for a door.

Ind

Indicates whether a door is open or closed. If the Ind checkbox is selected, the door is closed.

Req Power

Required Power: The power requirement for a door.

Voltage

The voltage requirement for a door.

Air

Indicates a door uses air pressure.

Spare Part

Indicates that spare parts are included in the delivery.

Ip-Enclosure

The standard classification system indicating the protection level of a casing or enclosure, denoted by an IP (Ingress Protection) rating.

El Power(W)

The nominal power in unit of measure Watt.

Voltage(V)

The nominal voltage in unit of measure Volt.

Current(A)

The nominal current in unit of measure Ampere.

Frequency(Hz)

The frequency of the voltage in unit of measure Hertz.

Spare Part

Indicates that spare parts are included in the delivery.

Req Power(kW)

Required Power (kW): The nominal input power required for an equipment in unit of measure Kilowatt.

E/F

Indicates whether the power is an estimate value or a fixed value. The valid values are E for estimated and F for fixed. The default value is E.

Motor power(kW)

The motor power required for an equipment in unit of measure Kilowatt.

Voltage(V)

The nominal voltage specified for an equipment in unit of measure Volt.

Current(A)

The nominal current specified for an equipment in unit of measure Ampere.

Motor Speed

The motor speed specified for an equipment.

Frequency(Hz)

The specified on board frequency in unit of measure Hertz.

Motor

Indicates an electric motor is included in the delivery.

Electric

Indicates an external electric supply is required.

Air

Indicates an external air pressure supply is required.

Steam

Indicates an external steam supply is required.

Water

Indicates an external water (cooling or heating) supply is required.

Oil

Indicates an external oil (lubrication, fuel, or hydraulic) supply is required.

Equip Draw

The drawing ID of an equipment.

Char 1–Char 10

User defined character fields.

Numeric 1–Numeric 10

User defined numeric fields.

Protect Type

The type of protection well used for an instrument.

Range

The range of measurement.

Unit

The unit of measure for the value in the Range field.

Limit/H

The high alarm limit in the unit same as that of the value in the Range field.

Limit/L

The low alarm limit in the unit same as that of the value in the Range field.

Set Point

The special value you can set for an instrument.

Sign Type

Signal Type: The signal transmission method used by the transmitters.

Unit

The unit of measure for a signal.

Pro No

Protection Number: The material number of the protection well used for an instrument.

Crit/Gen

Indicates whether the alarm is critical or general.

Sup Grp

Suppression Group: The suppression group to which an alarm is connected.

Delay

The delay before an action takes place. The delay is measured in seconds.

Sep

Separate Instrument: The details of the separate instrument incase the measurement is indicated elsewhere.

Channel

The channel number of the automation system.

Card

The card number of the automation system.

Mimi

The mimic display number of the automation system.

Connect Draw

The connection drawing number.

Location Draw

The location drawing number.

Req Power(W)

Required Power: The nominal power requirement in unit of measure Watt.

E/F

Indicates whether the power is an estimate value or a fixed value. The valid values are E for estimated and F for fixed. The default value is E.

Voltage(V)

The nominal voltage in unit of measure Volt.

Remark

The comments related to a standard material.

Dn

The nominal size of a pipe.

Pn

The designed pressure rating of a pipe.

Pipe Class

The classification of a pipe.

Du(mm)

The external diameter of a pipe in unit of measure millimeter.

S(mm)

The wall thickness of a pipe in unit of measure millimeter.

Max Work Press(Bar)

Maximum Work Pressure (Bar): The maximum system working pressure in unit of measure Bar.

Min Work Temp(C)

Minimum Work Temperature (C): The minimum system working temperature in unit of measure degree Celsius.

Max Work Temp(C)

Maximum Work Temperature (C): The maximum system working temperature in unit of measure degree Celsius.

Insulation

Indicates insulation is included for a pipe.

Mat Group

Material Group: The material group related to the material of a pipe.

Standard No

The standard number of a pipe.

Material1–Material2

The materials used for a pipe.

Surface Treatment1–Surface Treatment2

The surface treatment of a pipe, such as, rubberized or hot zinged.

Pipe Connections1–Pipe Connections2

The specifications for pipe connections.

Char 1–Char 10

User defined character fields.

Numeric 1–Numeric 10

User defined numeric fields.

Char 1–Char 10

User defined character fields.

Numeric 1–Numeric 10

User defined numeric fields.

Spare Part

Indicates that spare parts are included in the delivery.

Connect

The connection standard of a valve or a fitting, such as ISO, DIN, and so on.

Length(mm)

The distance between the connection flanges in unit of measure millimeter.

Mat Group

The first three numbers of the standard material number.

Standard No

The complete standard material number of a valve or a fitting.

Dn

The nominal size of a valve or a fitting.

Pn

The designed pressure rating of a valve or a fitting.

Pipe Class

The classification of a valve or a fitting.

Max Press(Bar)

Maximum Pressure (Bar): The maximum system working pressure in unit of measure Bar.

Min Work Temp(C)

Minimum Work Temperature (C): The minimum system working temperature in unit of measure degree Celsius.

Max Work Temp(C)

Maximum Work Temperature (C): The maximum system working temperature in unit of measure degree Celsius.

Mat Body

The material used for a valve body or a fitting body.

Mat Insert 1–Mat Insert 3

The material used for valve or fitting components, such as disc, shaft, spindle, seat, lining, seal, bearings, and so on.

Pneum

Indicates a pneumatic actuator is included for a valve.

Hydra

Indicates a hydraulic actuator is included for a valve.

Elect

Indicates an electric actuator is included for a valve.

Double

Indicates the actuator is a double acting actuator.

Solo

Indicates the actuator is a single acting actuator.

Open

Indicates a valve or a fitting is in open position.

Closed

Indicates a valve or a fitting is in close position.

Cont

Indicates there is continuous monitoring of a valve or a fitting position.

Sing/Spr Return

Indicates the actuator is equipped with a built in solenoid valve.

Site

The unique ID of a site where a standard material is received and stored.

Dflt Storehouse

Default Storehouse: The unique code to identify the default storehouse within a site.

Dflt Location

Default Location: The unique code to identify the default location within a storehouse.

Buyer Group

The unique code to identify a group of buyers responsible for purchasing a material for a specific site.

SMC

Standard Material Category: The material category related to a material. Indicates whether a material is controlled as a standard stock material or a project related material. The valid categories are defined and marked as active in the s00001 Standard Material Categories screen.

SC

Saleable Code: The unique code to identify the saleable status of a material. For example, a saleable code to indicate how valid the material is on the market and whether you can purchase the material again.

OP

Order Policy: The unique code to identify which reorder calculation method is used for reordering a material.

Quan/Box

Quantity per Box: The quantity of material expected to be delivered per box or per package. The total number of boxes to purchase is determined based on the ordered quantity and the value in the Quan/Box field.

ROP

Reorder Point: The stock level at which a material can be reordered.

Lead Time

The time taken (in days) to receive materials from a supplier after an order is placed.

ROQ

Reorder Quantity: The quantity of material to reorder when reaching the Reorder Point (ROP).

Factor

The calculation factor used when calculating the ROP. If the value in the Order Policy field is E (Order by Wilson: Wilson formula), the Factor field is mandatory.

Min Order

Minimum Order: The minimum quantity of a standard material you can reorder when reaching the ROP.

Max Order

Maximum Order: The maximum quantity of a standard material you can reorder when reaching the ROP.

Supplier Id

The site specific primary supplier preferred for purchasing a standard material.

AVMS

Always Visible in Material Status: Indicates a standard material is always visible in the material status for a specific site even if requirements or stock holdings exist for the material.

Purchase Agreement

The ID of the Purchase Agreement (PA) related to a standard material.

Pos No

Position Number: The PA position related to a standard material.

Description

The description of the PA related to a standard material.

Valid Until

The date till when the PA is valid.

Supplier Id

The ID of a supplier related to the PA.

Supplier Name

The name of a supplier related to the PA.

Project

The ID of a project related to a stock holding.

Suppl Item Id

Supplementary Item Id: The ID of a supplementary item.

Site

The code to identify a site where the materials are stored.

Store

The code to identify a storehouse within a site.

Location

The code to identify a specific location within a storehouse.

Quarantine

Indicates a location is a quarantine location and you cannot use the materials in a quarantine location.

Holding

The current stock holding of a material in a specific location, storehouse, and site.

Unit

The unit of measure in which materials are received from a supplier and managed in stock.

Supplier Id

The unique ID to identify a supplier related to a standard material.

Name 1

The company name of a supplier related to a standard material.

Insp Code

Inspection Code: The inspection code for a supplier and material combination.

Proj

The ID of the project for which restrictions are applicable on the related standard material.

Description

The description of a project for which restrictions are applicable on the related standard material.

Scheme

The measurement scheme to show description and sizes.

Description

The description of a standard material for the scheme defined in the Scheme field, for example, description in imperial or metric.

Tech Text

The technical (long) text of a standard material for the scheme defined in the Scheme field. You can transfer the technical text to requisitions, RFQs, and POs for detailing the description of the standard material.

Dimension

The dimension of a standard material for the scheme defined in the Scheme field.

Size 1–Size 4 (Display)

The four values used to represent the sizes of a standard material throughout the system. You can enter any alphanumeric value for the display size.

Size 1–Size 4 (Numeric)

The four values used to represent the numeric value of the sizes defined in the Size 1 (Numeric), Size 2 (Numeric), Size 3 (Numeric), and Size 4 (Numeric) fields.

Unit 1–Unit 4

The unit of measure for the values defined in the Size 1 (Numeric), Size 2 (Numeric), Size 3 (Numeric), and Size 4 (Numeric) fields.

Doc Id

Document Id: The unique code to identify a document related to a standard material.

Description

The description of a document related to a standard material.

Type

The unique code to identify a document type.

R

Restriction: The restriction status of a URL according to the rules maintained in the s00040 Hyperlink Restrictions screen. The R field is applicable only for hyperlink attachments.

Link or File

Indicates whether an attachment is a file or a hyperlink.

Attachment Type

The type of attachment. The valid attachment types are defined in the s00072 Attachment Type screen. The Attachment Type field helps in grouping and categorization of the attachments.

Rev Status

Revision Status: Indicates the status of a revision. There are three statuses:

• Green: The revision is the latest released revision.

• Yellow: The revision is the latest unreleased revision.

• Red: The revision is retired or outdated.

Revision

The revision number of an attachment. When you create a new revision, the revision number increases by one.

Link Ver

Link Version: Indicates the version number of the owning entity, such as POs and TMRs.

Id / Filename

The ID of a hyperlink or the name of a file attachment.

Title/Description

The title of a hyperlink or the description of a file attachment.

Stat

Status: Indicates the status of an attachment. If the Stat checkbox is selected, the attachment is active.

Owner

The user who is the owner of a hyperlink attachment. If the attachment is owned by a PO or a TMR version, the Owner field is empty.

Ext Visible

Externally Visible: Indicates an attachment is visible in external systems, such as the Supplier Portal.

Links

Indicates whether an attachment is linked to or from another entity, such as a PO or a TMR.

Url

The URL of a hyperlink attachment.

Pur No

The unique code to identify the PO related to a standard material.

Pos No

The PO position number related to a standard material.

Del Date

The delivery date for a PO position.

Price

The calculated unit price defined in the PO position.

Cur

The currency defined for a PO related to a standard material.

Price (Sys Cur)

The calculated unit price defined according to the system currency set in the d0073 ERM System Settings dialog.

Suppl ID

The ID of the supplier related to the PO position.

Supplier Name

The name of the supplier related to the PO position.

External Reference

The ID of a standard material in an external application, such as AVEVA E3D.