ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

StockingLocations

Service that's used to create stocking-location records in the RCL_STOCK_LOCATION table to store additional attributes for inventory organizations and subinventories.

Columns

Name Type Description
StockLocationId [KEY] Long Value that uniquely identifies the stocking location.
OrganizationId Long Value that uniquely identifies the inventory organization with associated attributes related to stocking locations defined in service logistics.
OrganizationCode String Abbreviation that identifies the inventory organization with associated attributes related to stocking locations defined in service logistics.
Subinventory String Name of the subinventory with associated attributes related to stocking locations defined in service logistics.
Condition String Condition of subinventory stocking locations. Valid values are Usable and Defective. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_CONDITION.
LocationType String Type of location. Valid values are TECHNICIAN, UNMANNED, MANNED, and SITE_DEDICATED. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_TYPE. You can't add additional location types.
LocationTypeMeaning String Description of the location type. Valid values are Technician, Unmanned Warehouse, Manned Warehouse, and Site Dedicated Warehouse. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_TYPE. You can't add additional location types.
ConditionMeaning String Value that indicates the condition of subinventory stocking locations. Valid values are Usable and Defective. A list of accepted values is defined in the lookup type ORA_RCL_STOCK_LOC_CONDITION.
Finder String Finder of StockingLocations

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