Item Subinventory Details
The Item Subinventory Details view object contains information about the item subinventories configured for an inventory organization.
Data Store Key : FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvItemSubinventoryPVO
Primary Keys : OrganizationId, InventoryItemId, SecondaryInventory
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
Attribute1 | Segment for the Item Subinventory descriptive flexfield. |
Attribute10 | Segment for the Item Subinventory descriptive flexfield. |
Attribute11 | Segment for the Item Subinventory descriptive flexfield. |
Attribute12 | Segment for the Item Subinventory descriptive flexfield. |
Attribute13 | Segment for the Item Subinventory descriptive flexfield. |
Attribute14 | Segment for the Item Subinventory descriptive flexfield. |
Attribute15 | Segment for the Item Subinventory descriptive flexfield. |
Attribute2 | Segment for the Item Subinventory descriptive flexfield. |
Attribute3 | Segment for the Item Subinventory descriptive flexfield. |
Attribute4 | Segment for the Item Subinventory descriptive flexfield. |
Attribute5 | Segment for the Item Subinventory descriptive flexfield. |
Attribute6 | Segment for the Item Subinventory descriptive flexfield. |
Attribute7 | Segment for the Item Subinventory descriptive flexfield. |
Attribute8 | Segment for the Item Subinventory descriptive flexfield. |
Attribute9 | Segment for the Item Subinventory descriptive flexfield. |
AttributeCategory | Context name for the user descriptive flexfield. |
CountRequired | Value that determines whether the count is required. |
CreatedBy | User who created the item subinventory. |
CreationDate | Date and time when the user created the item subinventory. |
DefaultCountTypeCode | Code that indicates the type of replenishment count. Valid values include Order PAR, On-Hand Quantity, and Order Quantity. If this attribute isn't specified, the Default Replenishment Count Type specified for the subinventory will be used. |
FixedLotMultiple | Value that indicates the fixed lot multiplier when determining the item replenishment quantity. |
InventoryItemId | Value that uniquely identifies the inventory item. |
InventoryPlanningCode | Code that identifies the inventory planning method. |
JobDefinitionName | Name of the scheduled process that created or last updated the item subinventory. |
JobDefinitionPackage | Package name of the scheduled process that created or last updated the item subinventory. |
LastUpdateDate | Date and time when the user most recently updated of the item subinventory. |
LastUpdateLogin | Session login associated with the user who most recently updated the item subinventory. |
LastUpdatedBy | User who most recently updated the item subinventory. |
MaxMinmaxQuantity | Maximum quantity for the associated item subinventory. |
MaximumOrderQuantity | Maximum order quantity for the associated item subinventory. |
MinMinmaxQuantity | Minimum quantity for the associated item subinventory. |
MinimumOrderQuantity | Minimum order quantity for the associated item subinventory. |
MinmaxQuantityUom | Code that identifies the unit of measure associated with the minimum and maximum quantities. |
ObjectVersionNumber | Number of times the object row has been updated. This attribute is used to implement optimistic locking. 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. |
OrganizationId | Value that uniquely identifies the organization. |
ParLevel | Level at which the item quantity should be stocked. If the count falls below this quantity, it's used to calculate the reorder quantity if the PAR maximum quantity isn't specified. |
ParMaxQty | Maximum quantity at which the item quantity should be stocked. If the count falls below the PAR level, this value is used to calculate the reorder quantity. If not specified, the PAR level will be used. |
ParUomCode | PAR level unit of measure associated with the item. This value is automatically defaulted based on the item entered. |
PickingOrder | Sequence to use when picking the item from the subinventory. |
PostprocessingLeadTime | Postprocessing lead time to use when sourcing the item. |
PreprocessingLeadTime | Preprocessing lead time to use when sourcing the item. |
PrimarySubinventoryFlag | Contains one of the following values: true or false. If true, then the subinventory is primary. If false, then the subinventory is secondary. The default value is true. |
ProcessingLeadTime | Processing lead time to use when sourcing the item. |
QtyCountTolerance | Allowed count tolerance used to determine whether the count is valid. |
RequestId | Value that uniquely identifies the request of the scheduled process that created or last updated the row. |
SecondaryInventory | Name of the subinventory. |
SourceOrganizationId | Value that uniquely identifies the organization to use when sourcing the item. |
SourceSubinventory | Subinventory to use when sourcing the item. |
SourceType | Type of the subinventory. |