Item Supply Details

The Item Supply Details view object stores incoming supply information for an organization. It includes purchase orders and advanced shipment notices created by suppliers, in-transit shipments, and transfer orders for an interorganization or intraorganization transfer. The Item Supply Details view object specifies where the supply is present as indicated by the supply type attribute.

Data Store Key : FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InventorySupplyExtractPVO

Primary Keys : InventorySupplyPEOSupplySourceId, InventorySupplyPEOSupplyTypeCode

Initial Extract Date : InventorySupplyPEOCreationDate

Incremental Extract Date : InventorySupplyPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
InventorySupplyPEOCategoryId	Value that uniquely identifies the item category.
InventorySupplyPEOChangeFlag	Contains one of the following values: Y or N. If Y, then the records are marked to be processed by the Supply Update function. If N, then the records aren't marked to be processed by the Supply Update function. The default value is null.
InventorySupplyPEOChangeType	Type of change to ignore for material requirements planning.
InventorySupplyPEOCostGroupId	Value that uniquely identifies the cost group to which inventory belongs.
InventorySupplyPEOCreatedBy	User who created the record.
InventorySupplyPEOCreationDate	Date and time when the user created the record.
InventorySupplyPEODestinationTypeCode	Code that indicates the destination type. Valid values are work order or inventory.
InventorySupplyPEOExpectedDeliveryDate	Date when the purchased items are expected to be delivered. The postprocessing lead time is added to the receipt date to get the expected delivery date.
InventorySupplyPEOFromOrganizationId	Value that uniquely identifies the sending organization for interorganization shipment.
InventorySupplyPEOFromSubinventory	Subinventory that's sending the interorganization shipment.
InventorySupplyPEOIntransitOwningOrgId	Value that uniquely identifies the owner organization for interorganization shipment.
InventorySupplyPEOItemId	Value that uniquely identifies the inventory item.
InventorySupplyPEOItemRevision	Number of times the item has been revised.
InventorySupplyPEOJobDefinitionName	Name of the scheduled process that created or last updated the supply record.
InventorySupplyPEOJobDefinitionPackage	Name of the package of the scheduled process that created or last updated the supply record.
InventorySupplyPEOLastUpdateDate	Date and time when the user most recently updated the supply record.
InventorySupplyPEOLastUpdateLogin	Login that the user used when updating the supply record.
InventorySupplyPEOLastUpdatedBy	User who most recently updated the supply record.
InventorySupplyPEOLocationId	Value that uniquely identifies the purchase order line location.
InventorySupplyPEOMrpDestinationTypeCode	Code that indicates the current destination type for the material requirement planning. The destination type code remains as INVENTORY when a requisition is created and converted to a purchase order.
InventorySupplyPEOMrpExpectedDeliveryDate	Date when the material requirement planning is expected to be delivered.
InventorySupplyPEOMrpPrimaryQuantity	Processed quantity of material requirement planning in terms of primary unit of measure of item in the destination organization.
InventorySupplyPEOMrpPrimaryUom	Primary unit of measure of material requirement planning processed for an item in destination organization.
InventorySupplyPEOMrpToOrganizationId	Value that uniquely identifies the current destination organization of material requirement planning. The destination organization can be changed before the receipt.
InventorySupplyPEOMrpToSubinventory	Destination subinventory of material requirement planning. The destination subinventory can be changed until the delivery is made.
InventorySupplyPEONeedByDate	Date when the inventory is originally needed.
InventorySupplyPEOObjectVersionNumber	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.
InventorySupplyPEOPoDistributionId	Value that uniquely identifies the purchase order distribution number.
InventorySupplyPEOPoHeaderId	Value that uniquely identifies the purchase order header.
InventorySupplyPEOPoLineId	Value that uniquely identifies the purchase order line.
InventorySupplyPEOPoLineLocationId	Value that uniquely identifies the purchase order line location.
InventorySupplyPEOQuantity	Quantity of the item associated with the inbound documents.
InventorySupplyPEORcvTransactionId	Value that uniquely identifies the receiving transaction.
InventorySupplyPEOReceiptDate	Date when the inventory is expected or actually received depending on the supply type.
InventorySupplyPEOReqHeaderId	Value that uniquely identifies the requisition.
InventorySupplyPEOReqLineId	Value that uniquely identifies the requisition line.
InventorySupplyPEORequestId	Value that uniquely identifies the request of the scheduled process that created or last updated the supply record.
InventorySupplyPEOShipmentHeaderId	Value that uniquely identifies the shipment.
InventorySupplyPEOShipmentLineId	Value that uniquely identifies the shipment line.
InventorySupplyPEOSupplySourceId	Value that uniquely identifies the supply source to identify the requisition, purchase order, shipment, or receiving transaction depending on SUPPLY_TYPE_CODE.
InventorySupplyPEOSupplyTypeCode	Code that indicates the supply type. Values include Purchase Order, Receiving, Shipment, Requisition, and Transfer Order.
InventorySupplyPEOToOrgPrimaryQuantity	Supply quantity in terms of primary unit of measure of item in destination organization.
InventorySupplyPEOToOrgPrimaryUomCode	Code that indicates the primary unit of measure of the item in destination organization.
InventorySupplyPEOToOrganizationId	Value that uniquely identifies the destination organization.
InventorySupplyPEOToSubinventory	Name of the destination subinventory.
InventorySupplyPEOTransferOrderHeaderId	Value that uniquely identifies the transfer order header.
InventorySupplyPEOTransferOrderLineId	Value that uniquely identifies the transfer order line.
InventorySupplyPEOUomCode	Code that indicates the unit of measure for the actual supply quantity.
OrgParameterPEOOrganizationId	Value that uniquely identifies the organization.