SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

OnhandQuantityDetails

The On-hand Quantity Details resource manages details about the on-hand quantity in the primary UOM or secondary UOM. You can query for various quantities, such as on-hand, receiving, inbound, reserved, or consigned.

Columns

Name Type Description
OrganizationId [KEY] Long OrganizationId of OnhandQuantityDetails
OrganizationCode String OrganizationCode of OnhandQuantityDetails
InventoryItemId [KEY] Long InventoryItemId of OnhandQuantityDetails
ItemNumber String ItemNumber of OnhandQuantityDetails
SubinventoryCode [KEY] String SubinventoryCode of OnhandQuantityDetails
LocatorId [KEY] Long LocatorId of OnhandQuantityDetails
LotNumber [KEY] String LotNumber of OnhandQuantityDetails
OnhandQuantity Decimal OnhandQuantity of OnhandQuantityDetails
SecondaryOnhandQuantity Long SecondaryOnhandQuantity of OnhandQuantityDetails
ReceivingQuantity Decimal ReceivingQuantity of OnhandQuantityDetails
SecondaryReceivingQuantity Decimal SecondaryReceivingQuantity of OnhandQuantityDetails
ReservedQuantity Decimal ReservedQuantity of OnhandQuantityDetails
SecondaryReservedQuantity Decimal SecondaryReservedQuantity of OnhandQuantityDetails
InboundQuantity Decimal InboundQuantity of OnhandQuantityDetails
SecondaryInboundQuantity Decimal SecondaryInboundQuantity of OnhandQuantityDetails
ConsignedQuantity Decimal ConsignedQuantity of OnhandQuantityDetails
SecondaryConsignedQuantity Decimal SecondaryConsignedQuantity of OnhandQuantityDetails
OwningOrganizationId Long OwningOrganizationId of OnhandQuantityDetails
OwningOrganization String OwningOrganization of OnhandQuantityDetails
SerialNumber [KEY] String SerialNumber of OnhandQuantityDetails
PrimaryUOMCode String PrimaryUOMCode of OnhandQuantityDetails
SecondaryUOMCode String SecondaryUOMCode of OnhandQuantityDetails
Finder String Finder of OnhandQuantityDetails

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060