About Inventory standard fields
- Last UpdatedSep 19, 2023
- 7 minute read
Although you can configure custom fields at the individual item level, you configure most standard fields in the System Configuration folder under the Inventory configuration item. The standard fields under the Inventory configuration item are common throughout the module.
List of Inventory standard fields
Inventory has the following standard fields.
|
Standard Field |
Description |
|---|---|
|
Activity Id |
The ActivityID standard field contains a unique identifier for a planned activity. The identifier originates in the business planning and logistics system. AVEVA™ Production Management uses this property to match Planning records with Inventory records when using the Match Movements to Plan feature. |
|
Adjustment Method |
The Adjustment Method standard field specifies the method of adjustment. The adjustment method can be absolute (adjusted by amount) or percentage (adjusted by percentage). For example, if you select absolute and enter 50, the balance adjusts by +50 units. If you enter -50, the balance reduces by 50 units. If you select percentage and enter 10, the balance adjusts by an increase of 10% of the value. If you enter -10, the balance is reduced by 10%. |
|
Adjustment Type |
The Adjustment Type standard field specifies the type of adjustment. The adjustment type can be Lot, Material or Lot Group. |
|
Balance |
The Balance standard field contains the calculated balance of material for this movement. |
|
Comment |
The Comments standard field contains any comments about the material movement. |
|
Confirmed By |
The ConfirmedBy standard field contains the name of the user who confirmed the record. |
|
Confirmed Date Time |
The ConfirmedDateTime field contains the date and time when the user confirmed the record. |
|
Contribution |
The Contribution standard field contains the value of a contribution amount. |
|
Contribution Type |
The Contribution Type standard field contains the name of a category of source characteristics that define an original trait for a lot. |
|
Contributor |
The Contributor standard field contains a contribution type value, such as Supplier A. |
|
Created By |
The CreatedBy standard field contains the name of the creator of the record. If AVEVA™ Production Management created the record, the field does not contain a value. |
|
Created Date Time |
The CreatedDateTime standard field contains the creation date and time of the record. |
|
Destination Equipment |
The DestinationEquipment standard field contains the name of the destination work center. |
|
Destination Equipment Identifier |
The DestinationEquipmentIdentifier standard field contains the unique identifier from an external system for the destination equipment. |
|
Destination Lot |
The DestinationLot standard field contains the name of the destination lot. |
|
Destination Lot Group |
The DestinationLotGroup standard field contains the lot group that the material was moved into during a material movement. |
|
Destination Material |
The DestinationMaterial standard field contains the name of the material at the destination location. |
|
Destination Material Class |
The DestinationMaterialClass standard field contains the name of the material class to which the destination material belongs. |
|
Destination Material Class Identifier |
The DestinationMaterialClassIdentifier standard field contains the unique identifier from an external system for the material class to which the destination material belongs. |
|
Destination Material Identifier |
The DestinationMaterialIdentifier standard field contains the unique identifier from an external system for the material at the destination location. |
|
Destination Quantity |
The DestinationQuantity standard field contains the quantity of material at the destination location. |
|
Destination Units |
The DestinationUnits standard field contains the units of the material moved to the destination location. |
|
Error Level |
The Error Level standard field specifies error level for filtering purposes. The Filter builder in Production Analyst allows filtering on Error Level for events. The filter options are: None, Both, Error, Warning. |
|
Error Message |
The ErrorMessage standard field contains the error information that results from processing movement events. |
|
Has Pending Changes |
The HasPendingChanges standard field indicates whether the movement event has pending changes for Inventory reprocessing. |
|
Id |
The Id standard field contains a unique ID that a database generated for the record. |
|
Is Confirmed |
The IsConfirmed standard field indicates whether the record is confirmed. |
|
Is Debt Lot |
The IsDebtLot standard field indicates whether the lot is a debt lot. A debt lot has a negative balance and must be repaid. |
|
Is Deleted |
The IsDeleted standard field indicates whether the status of the record is deleted. AVEVA™ Production Management does not physically delete records; it marks the record with a flag to indicate a deleted record. You can filter deleted records from view, but they remain available in case you want to view them again. |
|
Is Finalized |
Indicates whether the movement event is finalized. A finalized movement event cannot be changed. |
|
Is Manual |
The IsManual standard field indicates whether a user or AVEVA™ Production Management created the record. |
|
Last Modified |
The LastModified standard field contains the time that the data was last modified. Last Modified is captured on non-system generated changes to custom and standard fields. This does not include Record creation and Confirmation as they have their own fields. System generated records will show the LastModified field as blank. |
|
Last Modified By |
The LastModifiedBy standard field shows the last AVEVA™ Production Management user to modify the record. Last Modified By is captured on non-system generated changes to custom and standard fields. This does not include Record creation and Confirmation as they have their own fields. System generated records will show the LastModifiedBy field as blank. |
|
Location Identifier |
The LocationIdentifier is a unique identifier for a reporting point from an external system. For example, a reporting point in SAP has an identifier. You enter the SAP identifier into the LocationIdentifier property so that AVEVA™ Production Management recognizes the SAP reporting point. The LocationIdentifier cannot be the same as any other LocationIdentifier or EquipmentIdentifier. |
|
Lot |
A Lot is a uniquely identifiable amount of material. For accounting and production control purposes, the plant treats a material lot as a unit in processing. You can generate unique identifiers for material lots, and you can configure AVEVA™ Production Management to track them at key measurement points known in AVEVA Production Management as Work Centers. In AVEVA™ Production Management, the terms material lot and lot are interchangeable. |
|
Lot Behavior |
Specifies the lot behavior of a reporting point or work center, such as LIFO, FIFO, Mixed, Selective, WeightedAverage. The lot behavior describes the queuing behavior of a lot as it enter or leaves a work center. When specified at the reporting point level, the lot behavior setting overrides the setting specified at the parent work center level. |
|
Lot Group |
A lot group enables you to define specific lots as being related to each other, or belonging to the same group. When lots are moved in and out of work centers, this can impact the queue behavior. You can specify that lots belonging to a specific lot group are prioritized in the queue. |
|
Material |
A Material standard field contains the name of a material, which is a substance that the plant uses and produces such as raw materials, work-in-process, and finished goods. |
|
Material Class |
The MaterialClass standard field contains the name of a material class, which is a group of materials that are related and organized into a category of materials. |
|
Material Class Identifier |
The MaterialClassIdentifier standard field contains the unique identifier for a material class from an external system. For example, a material class in SAP has an identifier. You enter the SAP identifier into the MaterialClassIdentifier property in AVEVA™ Production Management so that AVEVA™ Production Management recognizes the SAP material class. |
|
Material Identifier |
The MaterialIdentifier standard field contains the unique identifier for material from an external system. For example, a material in SAP has an identifier. You enter the SAP identifier into the MaterialIdentifier property in AVEVA™ Production Management so that AVEVA™ Production Management recognizes the SAP material. |
|
Modified By |
The ModifiedBy standard field contains the name of the last user to modify the record. |
|
Modified Date Time |
The ModifiedDateTime field contains the date and time when the record was last modified. |
|
Movement Direction |
The MovementDirection standard field contains the direction of the material movement can be inbound or outbound. |
|
Movement Event Id |
The MovementEventId standard field contains the unique identifier for the movement event. |
|
Movement Event Identifier |
The MovementEventIdentifier standard field is a unique identifier for movement events. |
|
Movement Location |
The Movement Location field specifies the location of the Movement. |
|
Movement Type |
The MovementType standard field contains the type of movement: auto, manual, or adjustment. |
|
Object Id |
The ObjectId standard field contains the full name of the reporting point for the record; for example, Plant.Area1.Process4.ProductionLine. The default display name for this field is Location. |
|
Operations Definition Identifier |
The OperationsDefinitionIdentifier standard field contains the unique identifier for the operation definition, which is a defined portion of an operation. |
|
Operations Segment Identifier |
The OperationsSegmentIdentifier standard field contains the unique identifier for the operation segment, which is a defined portion of an operation. |
|
Quality Location |
The Quality Location field specifies the location of the Quality record. |
|
Quality Record Identifier |
The Quality Record Identifier standard field contains a unique identifier (defined externally) to identify a Quality event. |
|
Quantity |
The Quantity standard field contains the quantity of material. |
|
Record Date Time |
The RecordDateTime field is a creation timestamp provided by an external system to check that AVEVA™ Production Management recognizes the most up-to-date value for the record. |
|
Sample Date Time |
The SampleDateTime standard field contains the collection date and time of the data, which may or may not be the same as the creation date and time of the record. |
|
Sample Identifier |
The SampleIdentifier standard field is an identifier for movements that AVEVA™ Production Management matches with a unique RecordIdentifier field on a Quality record. For example, two movements into StockpileA have a SampleIdentifier of ESID1. Later, when you add a Quality record, you enter ESID1 in the RecordIdentifier field. AVEVA™ Production Management uses the value entered in the Quality RecordIdentifier field to match the record with any movements where the SampleIdentifier is ESID1. |
|
Source Equipment |
The SourceEquipment standard field contains the name of the source work equipment. |
|
Source Equipment Identifier |
The SourceEquipmentIdentifier standard field contains the unique identifier from an external system for the source equipment. |
|
Source Lot |
The SourceLot standard field contains the name of the source lot. |
|
Source Lot Group |
The SourceLotGroup standard field contains the lot group that the material was sourced from during a material movement. |
|
Source Material |
The SourceMaterial standard field contains the name of the material at the source location. |
|
Source Material Class |
The SourceMaterialClass standard field contains the name of the material class to which the source material belongs. |
|
Source Material Identifier |
The SourceMaterialIdentifier standard field contains the unique identifier from an external system for the material at the source location. |
|
Source Material Class Identifier |
The SourceMaterialClassIdentifier standard field contains the unique identifier from an external system for the material class to which the source material belongs. |
|
Source Quantity |
The SourceQuantity standard field contains the quantity of material at the source location. |
|
Source Units |
The SourceUnits standard field contains the units of the material moved from the source location. |
|
Units |
The Units standard field contains the units used for materials in Inventory. |