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. |