s22041 Field descriptions

Field	Description
SI	Status Indicator: Indicates the status of a record related to validation errors, warnings, and updates.
Defined By	The ID of a user who created a record.
Defined At	The date and time when a record was created.
Updated By	The ID of a user who updated a record.
Updated At	The date and time when a record was updated.
Updated Application	The application used to update a record.
Defined Application	The application used to create a record.
Customer Column 0–Customer Column 9	Multipurpose fields for storing company specific general Material Take-Off (MTO) attributes.

Field	Description
Project	The ID of a project related to a general MTO line.
Description	The description of a project related to a general MTO line.
Status	Indicates the status of a project. If the project is closed, you cannot update any information for the project.
Template	Indicates a project is a template project. A template project is a standard project that can help set up projects with the same method and structure as the template project. If the Template checkbox is selected, the project is not included in material status calculations or budget calculations.
Discipline	The ID of a drawing discipline related to a general MTO line.

Field	Description
Discipline	The ID and description of a drawing discipline related to a general MTO line.
Construction Area	The ID and description of a construction area related to a general MTO line.
Material Control Section	The ID of a material control section related to a general MTO line.
Specification	The ID and description of a specification related to the material control section defined in the Material Control Section field.
Version	The version number of a general MTO line. When you reopen a general MTO line, the version number increases by one.
MR Number	Material Requisition Number: The ID of the Material Requisition (MR) in which all the items related to a general MTO line are allocated when you generate a Technical Material Requisition (TMR), based on the setup defined in the s400001 Requisition Register screen. You can allocate individual MTO items to different TMRs by selecting a different MR for each MTO item.
MTO-Line	The ID of a material control section for which a general MTO line is created.
Sheet Number	The sheet number in a drawing related to a general MTO line. To update the Sheet Number field, in the MTO Type field, ensure you select an MTO type for which the value in the MTO Quality field is Actual.
Model Status	The status of a material control section within a 3D modeller such as AVEVA E3D.
MTO Status	The status of a general MTO line. The values are: No MTO: Indicates MTO items are not allocated to the general MTO line. Working: Indicates MTO items are allocated to the general MTO line. Confirmed: Indicates the section and the construction area related to a general MTO line is confirmed and the general MTO line is ready for approval. The Confirmed status is applicable only for MTO types for which the value in the MTO Quality field is Actual. Approved: Indicates the general MTO line is approved and the working quantity of all the MTO items is copied as the approved quantity. The MTO items are available for requisition and construction. Superseded: Indicates the actual MTO for a general MTO line is approved and the estimate is superseded. The Superseded status is applicable only for MTO types for which the value in the MTO Quality field is Estimate. Retired: Indicates the general MTO line and all the related MTO items are retired. If you retire an approved general MTO line, the approved quantity for all the MTO items related to the general MTO line are updated to 0 and the material requirements are removed from the s50022 Material Status List screen.
Issuance with Un-issued Sub-Assy/Fab	The issuance method of a general MTO line when the general MTO line contains sub-assemblies and fabricates. A sub-assembly is part of a drawing. There are three values: Allow: You can approve the general MTO line even if the related fabricates are not issued. Auto & Issue Open Items: You can approve the general MTO line, and automatically issue the related fabricates which are not issued. Deny: You cannot issue the general MTO line if the related fabricates are not issued.
MTO Type	The ID of an MTO type related to a general MTO line.
MTO Quality	The quality of the MTO type defined in the MTO Type field. The values are Actual and Estimate.
MTO Locked for Updates	Indicates a general MTO line is locked for updates. Only the user who locked the general MTO line can make changes. To make changes, you can unlock the general MTO line.
On Hold Reason	The reason for the on hold state of a general MTO line.
System	The ID of a system for the material control section related to a general MTO line.
Drawing No	The drawing number related to a general MTO line.
Drawing Id	The system generated ID of a drawing related to a general MTO line. The value in the Drawing Id is automatically generated using a combination of the values in the Drawing No and the Sheet Number fields.
Drawing Revision	The revision number of the drawing defined in the Drawing No field.
Ref Drawing Number	The ID of a reference drawing related to a material control section which includes the MTO line defined in the MTO Line field, such as a General Arrangement drawing.
Installation Norms Hours	The number of hours required to install all the items in a general MTO line.
Total Weight	The total weight of all the items in a general MTO line. The total weight of a general MTO line is the sum of the values in the Total Weight field of each general MTO item.
Line Items Without Weight	The number of items in a general MTO line for which the weight is not defined in the related material catalogue.
Insulated	Indicates one or more items in a general MTO line is insulated.
Painted	Indicates one or more items in a general MTO line is painted.
Allow Incomplete Spec	Indicates you can add incomplete specification items to a general MTO line.

Field	Description
Delivery Designation	The ID and description of a delivery designation related to a general MTO line. The valid values are defined in the s22012 Delivery Designations screen.
Site	The ID and description of a site where the items in a general MTO line are delivered.
Activity	The ID and description of a construction activity for which the items in a general MTO line are delivered.
Activity start date correction	The allowed time difference between the planned start date of an activity and the actual start date of the activity.
Delivery Date	The delivery date for the items in a general MTO line.

Field	Description
Line Number	The unique number to identify the individual items within a general MTO line.
Ver	Version: The version number of a general MTO line at which the related general MTO item was last updated.
Imp	Implied: Indicates a general MTO item is added as an implied item from a rule defined in the s21016 Implied Item Rules screen.
Specification	The name and description of a specification added as a general MTO item.
Catalogue	The ID of a catalogue related to the specification defined in the Specification field.
Branch Code	Indicates a material is resolved through the branch table related to the specification defined in the Specification field.
Short Code	The code to identify a component within a specification.
Option Code	The option code related to the short code defined in the Short Code field.
Size Attribute	The name of an attribute used to specify the size of a specification.
Size 1–Size 4	The size attribute values for a specification.
Size Unit	The unit of measure in which the size of a specification is defined.
Representation	The attribute representation used to specify the size of a specification.
Component Type	The component type related to the specification defined in the Specification field.
Delivery Designation	The ID and description of a delivery designation related to a general MTO item.
Material Category	The ID of a material category related to a general MTO item.
Type	Material Type: The code to identify the grouping of a general MTO item, for example, pipes, cables, and so on.
Material Dimension	The physical dimensions of a general MTO item.
Item Id	The ID of a material added as a general MTO item.
Description	The description of a material added as a general MTO item.
Working Quantity	The required quantity of a general MTO item.
Issued Quantity	The quantity of a general MTO item issued through a picking list.
Reserved Quantity	The quantity of a general MTO item reserved through a Delivery Request List (DRL) or a picking list.
Engineering On Hold Qty	The quantity of a general MTO item in the on hold state. You can update the Engineering On Hold Qty field only if the value in the MTO Status field of the general MTO line related to the general MTO item is Working or Confirmed.
On Hold Reason	The reason for the on hold state of a general MTO item.
Unit	The unit of measure for a general MTO item.
Set Quantity	The number of general MTO items in a set for a specification component.
Confirmed Quantity	The confirmed quantity of a general MTO item. The value is calculated as the difference between the values in the Working Quantity and the Engineering On Hold Qty fields.
Last Issued Qty	Approved Quantity: The quantity of a general MTO item required in construction. The value is calculated as the difference between the values in the Working Quantity and the Engineering On Hold Qty fields.
Previous Approved Quantity	The quantity of a general MTO item approved in the previous approval process.
Last Estimate Quantity	The last approved estimate quantity of a general MTO item.
For Requisition	Indicates a general MTO item exists as a requisition in a part list, a DRL, or a picking list. If the For Requisition checkbox is cleared, the general MTO item is not available for requisition in the s50022 Material Status List screen.
For Construction	Indicates a general MTO item is for construction. If the For Construction checkbox is cleared, all the purchase requirements for the general MTO item is cancelled and not included as material requirements in the s50022 Material Status List screen and the s50017 Buyers Queue screen.
Supply Responsibility	The ID of a supply responsibility rule related to a general MTO item as defined in the s21018 Supply Responsibility Matrix screen. Based on the supply responsibility rule defined in the Supply Responsibility field, the For Construction and the For Requisition checkboxes of the general MTO item are updated.
MR Number	Material Requisition Number: The ID of the MR in which the general MTO item is allocated when you generate a TMR based on the setup defined in the s400001 Requisition Register screen.
Site	The ID of a site where the general MTO item is required.
Site Rule	The ID of a site allocation rule related to a general MTO item. The valid values are defined in the s21019 Site Allocation Setup screen.
Unit Weight	The default weight of a material per unit.
Line Item Unit Weight	The unit weight of the material added as a general MTO item.
Total Weight	The total weight of a general MTO item. The total weight is the value in the Line Item Unit Weight field multiplied with the value in the Working Quantity field.
Activity	The ID of an activity related to a general MTO item.
Description	The description of an activity related to a general MTO item.
Activity Correction	The allowed time difference between the planned start date of an activity and the actual start date of the activity related to a general MTO item.
Delivery Date	The delivery date for a general MTO item.
System	The ID of a system related to a general MTO item.
Norms Qty	The quantity used for norms calculation.
Norms Unit	The unit of measure for the value in the Norms Qty field.
Insulated	Indicates a general MTO item is insulated.
Painted	Indicates a general MTO item is painted.
Material Preparation	The material preparation milestone that specifies which preparation template is used for the material added as a general MTO item.

Field	Description
Part List Line Item Text	The comments related to a general MTO item.
Tech Mat Desc	Technical Material Description: The technical details related to a general MTO item.

Field	Description
Model Type Ref	Model Type Reference: The ID of the model type of a general MTO item in AVEVA Marine or AVEVA E3D.
Model Tag Id	The tag ID of the 3D model of a general MTO item in AVEVA Marine or AVEVA E3D.

AVEVA Enterprise Resource Management

s22041 Field descriptions

Table of Contents

s22041 Field descriptions

Related Links