Inventory Material Statuses
The Inventory Material Statuses view object contains information to control the transactions that can be performed on an item.
Data Store Key : FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvMaterialStatusesExtractPVO
Primary Keys : Language, StatusId
Initial Extract Date : InvStatusTlPEOCreationDate
Incremental Extract Date : InvStatusTlPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| InvMaterialStatusBPEOAvailabilityType | Value that indicates if the material in this status should be included in the netting calculations for planning. |
| InvMaterialStatusBPEOCreatedBy | User who created the inventory material status. |
| InvMaterialStatusBPEOCreationDate | Date and time when the user created the inventory material status. |
| InvMaterialStatusBPEOEnabledFlag | Contains one of the following values: 1 or 2. If 1, then the material status is active. If 2, then the material status isn't active. The default value is 1. |
| InvMaterialStatusBPEOInventoryAtpCode | Code that identifies if the material in this status should be included in the available-to-promise calculations. |
| InvMaterialStatusBPEOJobDefinitionName | Name of the scheduled process that created or most recently updated the inventory material status. |
| InvMaterialStatusBPEOJobDefinitionPackage | Package name of the scheduled process that created or most recently updated the inventory material status. |
| InvMaterialStatusBPEOLastUpdateDate | Date and time when the user most recently updated the inventory material status. |
| InvMaterialStatusBPEOLastUpdateLogin | Login that the user used when updating the inventory material status. |
| InvMaterialStatusBPEOLastUpdatedBy | User who most recently updated the inventory material status. |
| InvMaterialStatusBPEOLocatorControl | Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the locator. If 2, then the material status can't be assigned to locator. The default value is 2. |
| InvMaterialStatusBPEOLotControl | Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the lot. If 2, then the material status can't be assigned to the lot. The default value is 2. |
| InvMaterialStatusBPEOLpnControl | Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the license plate number. If 2, then the material status can't be assigned to the license plate number. The default value is 2. |
| InvMaterialStatusBPEOObjectVersionNumber | Number of times the object row has been updated. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| InvMaterialStatusBPEORequestId | Value that uniquely identifies the request of the scheduled process that created or most recently updated the inventory material status. |
| InvMaterialStatusBPEOReservableType | Contains one of the following values: 1 or 2. If 1, then the material status can allow reservations. If 2, then the material status can't allow reservations. The default value is 2. |
| InvMaterialStatusBPEOSerialControl | Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the serial number. If 2, then the material status can't be assigned to the serial number. The default value is 2. |
| InvMaterialStatusBPEOStatusId | Value that uniquely identifies the status that control the transactions that can be performed on an item. |
| InvMaterialStatusBPEOZoneControl | Contains one of the following values: 1 or 2. If 1, then the material status can be assigned to the subinventory. If 2, then the material status can't be assigned to the subinventory. The default value is 2. |
| InvStatusTlPEOCreatedBy | User who created the material status. |
| InvStatusTlPEOCreationDate | Date and time when the user created the material status. |
| InvStatusTlPEODescription | Description of the inventory material status.. |
| InvStatusTlPEOLastUpdateDate | Date and time when the user most recently updated the material status. |
| InvStatusTlPEOLastUpdateLogin | Login that the user used when updating the material status. |
| InvStatusTlPEOLastUpdatedBy | User who most recently updated the material status. |
| InvStatusTlPEOObjectVersionNumber | Number of times the object row has been updated. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| InvStatusTlPEOSourceLang | Code that identifies the language in which the contents of the translatable columns were originally created. |
| InvStatusTlPEOStatusCode | Name of the material status. |
| Language | Code that identifies the language into which the contents of the translatable columns are translated. |
| StatusId | Value that uniquely identifies the material status. |