Receiving Supply Details

The Receiving Supply Details view object stores the supply information that has been received in an inventory organization but isn't yet put away. It includes receipts created against all receiving documents, purchase orders, and advanced shipment notices created by suppliers, in-transit shipments, and transfer orders for an interorganization or intraorganization transfer.

Data Store Key : FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingSupplyExtractPVO

Primary Keys : SupplySourceId, SupplyTypeCode

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ChangeFlag	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.
ChangeType	Value that identifies the type of change to ignore for material requirements planning.
CountryOfOriginCode	Code that identifies the country of manufacture of this item.
CreatedBy	User who created the receiving supply record.
CreationDate	Date and time when the receiving supply record was created.
DestinationTypeCode	Code that identifies the destination type of the receiving transaction. A list of accepted values is defined in the lookup type RCV_DESTINATION_TYPE.
FromOrganizationId	Value that uniquely identifies the originating organization of the in-transit shipment or transfer order shipment.
FromSubinventory	Value that identifies the subinventory that's sending the in-transit shipment or transfer order shipment.
IntransitOwningOrgId	Value that uniquely identifies the owner organization for an in-transit shipment or transfer order shipment.
InvReservedAttribute1	Reserved for future inventory striping related functionality.
InvReservedAttribute2	Reserved for future inventory striping related functionality.
InvStripingCategory	Context name for inventory striping attributes.
InvUserDefAttribute1	Reserved for user-definable inventory striping information.
InvUserDefAttribute10	Reserved for user-definable inventory striping information.
InvUserDefAttribute2	Reserved for user-definable inventory striping information.
InvUserDefAttribute3	Reserved for user-definable inventory striping information.
InvUserDefAttribute4	Reserved for user-definable inventory striping information.
InvUserDefAttribute5	Reserved for user-definable inventory striping information.
InvUserDefAttribute6	Reserved for user-definable inventory striping information.
InvUserDefAttribute7	Reserved for user-definable inventory striping information.
InvUserDefAttribute8	Reserved for user-definable inventory striping information.
InvUserDefAttribute9	Reserved for user-definable inventory striping information.
ItemId	Value that uniquely identifies the item.
ItemRevision	Value that identifies an incremental change to the item.
JobDefinitionName	Name of the scheduled process that created or last updated the record.
JobDefinitionPackage	Value that identifies the package name of the scheduled process that created or most recently updated the record.
LastUpdateDate	Date and time when the user most recently updated the supply record.
LastUpdateLogin	Login associated with the user who most recently updated the supply record.
LastUpdatedBy	User who most recently updated the supply record.
LocationId	Value that uniquely identifies the ship-to location.
LpnId	Value that uniquely identifies the license plate number used for this supply.
ObjectVersionNumber	Value that identifies the 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.
PoDistributionId	Value that uniquely identifies the purchase order distribution.
PoHeaderId	Value that uniquely identifies the purchase order header.
PoLineId	Value that uniquely identifies the purchase order line.
PoLineLocationId	Value that uniquely identifies the purchase order schedule.
ProjectId	Value that uniquely identifies the inventory project.
Quantity	Quantity of the item associated with this supply record.
RcvTransactionId	Value that uniquely identifies the receiving transaction that created this supply record.
ReceiptDate	Date when the material is actually received.
ReqHeaderId	Value that uniquely identifies the requisition.
ReqLineId	Value that uniquely identifies the requisition line.
RequestId	Value that uniquely identifies the scheduled process request that created or last updated the supply record.
SecondaryQuantity	Value that identifies the supply quantity in terms of a secondary unit of measure of an item in the receiving organization.
SecondaryUomCode	Code that identifies the unit of measure for the secondary quantity.
ShipmentHeaderId	Value that uniquely identifies the inbound shipment.
ShipmentLineId	Value that uniquely identifies the inbound shipment line.
SupplySourceId	Value that uniquely identifies the supply source used to identify the receiving transaction that created this record.
SupplyTypeCode	Code that indicates the supply type. The default is RECEIVING for receiving supply records.
TaskId	Value that uniquely identifies the inventory task.
ToLocatorId	Value that uniquely identifies the destination locator.
ToOrgPrimaryQuantity	Value that identifies the supply quantity in terms of the primary unit of measure of an item in the receiving organization.
ToOrgPrimaryUomCode	Code that indicates the primary unit of measure of the item in the receiving organization.
ToOrganizationId	Value that uniquely identifies the receiving organization.
ToSubinventory	Name of the destination subinventory.
TransferOrderHeaderId	Value that uniquely identifies the transfer order header.
TransferOrderLineId	Value that uniquely identifies the transfer order line.
UomCode	Code that indicates the unit of measure for the actual supply quantity.