s21001 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.
Customer Column 0–Customer Column 9	Multipurpose fields for storing company specific attributes.
MS	Material Substitution: Indicates whether a material substitution is approved for a material, for the project related to a Delivery Request List (DRL).
Sub	Indicates whether a material is a substitute item.
OI	Overissue: The overissue status of material.

Field	Description
DRL Type	The type of a DRL. The values are Material and Summary.
DRL Number	The unique number to identify a DRL. When a new DRL is created, the DRL Number is automatically generated by the system according to the DRL number sequence. The sequence is increased by one every time a new DRL is created.
Project	The ID of a project related to a DRL.
Picking List Status	The status of a picking list related to a DRL. The value in the Picking List Status field is updated using the Status group.
Reservation Status	R: The reservation status of a DRL. The three statuses are: F (Fully Reserved): All materials in the DRL are reserved. P (Partially Reserved): Some materials in the DRL are reserved. N (Not Reserved): None of the materials in the DRL are reserved.
Difference	Indicates differences exist between a DRL and the related picking list in terms of material items or the sum of requested quantity of materials.
Batched Fabricate	Indicates the work order related to a DRL is created for batched fabricates.
Linked Summary DRL Number	The summary DRL number assigned to a material DRL.
Activity	The ID of an activity related to a DRL. The valid activities are defined and marked as active in the s11001 Project Gantt View screen. To define or update the Activity field, you can manually select an activity ID or use the Show Activity Status functionality. For more information, see View activity status from s21001.
Work Order	The ID of the work order through which a DRL is related to a job. You can relate multiple DRLs to the same work order and job combination to schedule requisition of materials for different dates towards the same job.
Job	The ID of a job related to a DRL. A work order contains multiple jobs.
Activity Site	The ID of a site related to an activity. The value in the Activity Site field is the location where the activity is performed and the materials are requested.
Time Correction	The allowed time difference between the planned starting date of an activity and the actual starting date. The unit of the time difference (days, weeks, months, and so on) is defined in the d0073 ERM System Settings dialog.
Site MTO Identification	The ID of the Site Material Take-Off (MTO) related to a DRL.
Material Allocation Id	The ID of the material allocation run which generated the related DRL to hold material reservations through the s23003 Material Allocation Run screen.
Material Allocation Package Id	The ID of the material allocation package which generated a DRL.
Manual set Production Date	Indicates the Production Date for a DRL is manually assigned by a user and cannot be modifed by any update in the schedule.
Production Date	The date when the materials requested in a DRL are required for production. If the DRL status is Complete or Warehouse Dispatch List, and no Production Date is specified, the default date is a sum of the start date of the activity and the value in the Time Correction field.
Production Group	The ID of a production group related to a part list item.
Foreman	The name of the foreman who requires the material.
Responsible Planner	The user responsible for a DRL.
Total Installation Norm	The total installation norm hours for the items in a DRL. The norm hours value is a sum of the installation norm hours per DRL item multiplied with the required quantity of the DRL item. The installation norm for an item is defined in the s70005 Product Codes and Norms screen.
Fabricate	The ID of a fabricate related to a part list for which a DRL is created.
Subcontractor	The ID of a subcontractor assigned to receive the materials in a DRL.
Transport Address	The ID of the address where the materials in a DRL are transported for delivery.
Stock Site	The ID of a site where the materials in a DRL are received and stored.
Remark	The comments related to a DRL. When generating a picking list, the remark is copied to the picking list as a display only attribute.

Field	Description
R	The reservation status of a summary DRL. The three statuses are: F: (Fully Reserved): All materials in the DRL are reserved. P: (Partially Reserved): Some materials in the DRL are reserved. N: (Not Reserved): None of the materials in the DRL are reserved.
DRL No	The unique number to identify a summary DRL.
Pick Lst Stat	The status of a picking list related to a summary DRL. The value in the Picking List Status field is updated using the Status group.
Diff	Difference: Indicates differences exist between a summary DRL and the related picking list in terms of material items or the sum of requested quantity of materials.
Proj	The ID of a project related to a summary DRL.
Activity	The ID of an activity related to a summary DRL.
Corr	Time Correction: The allowed time difference between the planned starting date of an activity and the actual starting date related to a summary DRL. The unit of the time difference (days, weeks, months, and so on) is defined in the d0073 ERM System Settings dialog.
Fabricate	The ID of a fabricate related to a part list for which a summary DRL is created.
Man P Date	Manual Set Production Date: Indicates the Production Date for a summary DRL is manually assigned by a user and cannot be modifed by any update in the schedule.
Prod Date	Production Date: The date when the materials requested in a summary DRL are required for production. If the DRL status is Complete or Warehouse Dispatch List, and no Production Date is specified, the default date is a sum of the start date of the activity and the value in the Time Correction field.
Mat All Id	Material Allocation ID: The ID of the material allocation run which generated the related summary DRL to hold material reservations through the s23003 Material Allocation Run screen.
Resp Planner	Responsible Planner: The user responsible for a summary DRL.
Foreman	The name of the foreman who requires the material related to a summary DRL.
Transp Addr	Transport Address: The ID of the address where the materials in a summary DRL are transported for delivery.
Tot Install Norm	Total Installation Norm: The total installation norm hours for the items in a summary DRL.
Remark	The comments related to a summary DRL.
Work Order	The ID of the work order through which a summary DRL is related to a job.
Job	The ID of a job related to a summary DRL. A work order contains multiple jobs.
Site MTO Id	The ID of the Site MTO related to a summary DRL.
Subcontractor	The ID of a subcontractor assigned to receive the materials in a summary DRL.
BF	Batched Fabricate: Indicates the work order related to a summary DRL is created for batched fabricates.

Field	Description
Line Number	The number to identify individual items in a DRL.
Material Description	The description of a DRL item.
Requested Quantity	The required quantity of a DRL item.
System	The ID of the main system related to a DRL item.
Compartment	The ID of a project compartment related to a DRL item.
Linked to Line No	When a DRL item is split into two DRL items, the Linked to Line No field contains the Line Number of the split DRL item.
Revision	The revision number of a DRL item.
Requested Unit	The unit of measure for the value in the Requested Quantity field.
Cost Account	The number to identify the primary financial cost account related to a DRL item.
Mark or Relation Code	The mark or relation code related to a DRL item. The value in the Mark or Relation Code field is used as a sorting criteria when you generate and print a picking list for a DRL. For example, you can specify whether materials can be packed together in the store before sending the materials to production.
Link Type	The type of operation that created a DRL item. The possible link types are: Substitute: The DRL item is created to substitute another DRL item. Cancel Requirement: The DRL item is created to cancel all or parts of a requirement from the linked DRL item. Postpone (RTS): The DRL item is created for a material that was returned to stock for reissue against the same DRL at a later time. Cancel Requirement (RTS): The DRL item is created to hold a part of the original DRL item quantity that was in excess and returned to stock.
Material Category	The ID of a material category related to a DRL item.
Material Type	The code of a material type related to a DRL item.
Standard Material Number	The ID of a standard material related to a project component in the Item Id field.
Dimensions	The dimensions of a DRL item.
Part	The code to identify the position on the drawing where the material is located.
No Pick	Indicates whether the issue of a material from stock is recorded through a picking list. If the No Pick checkbox is selected, a DRL item does not appear in the s60030 Warehouse Dispatch List and is not placed on any picking list.
Material Preparation	The material preparation milestone that specifies which preparation template is used for the material.
Item Id	The ID of a material defined as the DRL item.
Type	The type of a material defined as the DRL item.
Parent Material	The parent material of a supplementary item.
Unit Weight	The unit weight of a material defined as the DRL item.
Total Weight	The total weight of a DRL item.
Overissue No	The ID of the material overissue instance used to fulfill the requirement in the DRL item.
Part List Number	The ID of the part list for which a part list item exists in the DRL.
Pipeline Number	The ID of a pipeline related to a piping MTO line.
Material Control Section	The ID of a material control section related to a general MTO line.
Construction Area	The ID of a construction area related to an MTO line.
MTO-Line	The ID of a pipeline or a material control section within a construction area.
Sheet Number	The sheet number related to the value defined in the MTO-Line field.
Discipline	The ID of a drawing discipline related to the value defined in the MTO-Line field.
Part List Line Number	The part list line number related to a DRL item.
Production Drawing	The ID of the production drawing related to a DRL item.
Outstanding Part List Quantity	The quantity of materials in a part list yet to be billed out to a DRL.
MTO Identification	If a DRL is created from a site MTO, then the value in the MTO Identification field is the ID of the site MTO for which the material is required.
Model Tag Id	The ID of the Marine Dabacon model tag.
Model Type Ref	The ID of the Marine Dabacon model type.
Reservation Status	The reservation status of a DRL item.
Picking List Quantity	The quantity of material related to a picking list.
Picked Quantity	The quantity of material that is picked to match and adjust towards the requested quantity.
Return to Stock Quantity	The quantity of material that is returned to the stock.
Close-Out Quantity	The quantity of material not issued from stock against a picking list, at the time of the close-out operation.
Close-Out Disposition	The handling of a closed out DRL item. For example, if a DRL item is closed out because of a change in schedule, then the unused materials are released from the current DRL and made available for another DRL, and the Close-Out Disposition field displays Release to other DRL.
Available at Site	The quantity of material available for use within the site defined in the Stock Site field.
Holding Project	The total stock holding of a DRL item for a project in a requested unit.
On Order	The total quantity of a DRL item on closed Purchase Orders (POs) which is not yet delivered.
Holding Total	The total stock holding of a DRL item in a requested unit.
Product Code	The product code related to a DRL item.
Installation Norm	The total installation norm hours required for a DRL item.
Norms Qty	The quantity used for norms calculation.
Norms Unit	The unit of measure for the value in the Norms Qty field.

Field	Description
DRL Item Text	The comments related to a DRL item.
Part List Item Text	The technical text related to a part list item.

Field	Description
Project	The ID of a project related to a stock holding.
Supplementary Item Id	The unique code to identify the supplementary item related to a material.
Site	The unique code to identify a site where the material is stored.
Store	The unique code to identify a storehouse within a site.
Location	The unique code to identify a specific location within a storehouse.
Quarantine	Indicates whether the location is 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 managed in stock.

Field	Description
Instance Id	The ID of the specific instance of a material.
Pur No	The unique number to identify the PO related to the requested material.
Position	The PO position number related to the requested material.
Certificate Id	The ID of the certificate registered against the requested material.
Charge Id	The charge ID registered on any certificate selected in the Certificate Id field. Charge ID is applicable for suppliers of steel materials.
Suppl Batch Id	The batch number of a supplier registered on any certificate selected in the Certificate Id field.
Expire Date	The date when the requested material expires.
Remark	The comments related to a requested material.

AVEVA Enterprise Resource Management

s21001 Field descriptions

Table of Contents

s21001 Field descriptions

Related Links