JDBC Driver for Oracle SCM

Build 22.0.8462

SubinventoriesitemSubinventories

The Item Subinventories resource manages operations on item subinventories.

Columns

Name Type Description
SubinventoriesOrganizationId String SubinventoriesOrganizationId of SubinventoriesitemSubinventories
SubinventoriesSecondaryInventoryName String SubinventoriesSecondaryInventoryName of SubinventoriesitemSubinventories
FixedLotMultiple Int Value of the fixed lot multiple. Used while sourcing the material for the item. You can source an item only in this value.
InventoryItemId String Value that uniquely identifies the inventory item.
MinimumMaximumPlanningCode Int Abbreviation that determines whether to enable min-max planning for the item subinventory. A list of accepted values is defined in the lookup type INV_MATERIAL_PLANNING.
MaximumMinmaxQuantity String Maximum quantity for min-max replenishment.
MaximumOrderQuantity String Maximum order quantity for replenishment.
MinmaxQuantityUOM String Abbreviation that identifies the unit of measure to use for the min-max quantities.
MinmaxQuantityUOMMeasure String Unit of measure to use for the min-max quantities.
MinimumMinmaxQuantity String Minimum quantity for min-max replenishment.
MinimumOrderQuantity String Minimum order quantity for replenishment.
PostprocessingLeadTime Long Post processing lead time to use while sourcing the item.
PreprocessingLeadTime Long Preprocessing lead time to use while sourcing the item.
ProcessingLeadTime Long Processing lead time to use while sourcing the item.
SecondaryInventory String Subinventory that references the item.
SourceOrganizationId String Value that uniquely identifies the source organization. Used while sourcing the material for the item to this subinventory.
SourceSubinventory String Name of the source subinventory. Used while sourcing the material for the item to this subinventory.
SourceOrderingUOM String SourceOrderingUOM of SubinventoriesitemSubinventories
SourceOrderingUOMMeasure String Unit of measure to use for sourcing.
SourceType String Sourcing type to use to replenish stock for the item to this subinventory. A list of accepted values is defined in the lookup type INV_SOURCE_TYPES. The default value is 6.
ItemNumber String Name that identifies the product or material in the subinventory.
SourceOrganizationCode String Abbreviation that identifies the source organization. Used while sourcing the material for the item to this subinventory.
ParLevel String Level that the application uses for the item subinventory during periodic automatic replenishment.
ParMaximumQuantity String Maximum quantity to use during periodic automatic replenishment.
ParUOMCode String Abbreviation that identifies the unit of measure to use for quantities during periodic automatic replenishment.
ParUOMMeasure String Unit of measure to use for quantities during periodic automatic replenishment.
DefaultCountTypeCode String Abbreviation that identifies the type of periodic automatic replenishment. A list of accepted values is defined in the lookup type INV_DEFAULT_REPLEN_COUNT_TYPE. The default value is 4.
CountRequired String Contains Y or N. Y: the application requires counting during periodic automatic replenishment for the item in the locator. N: the application does not require this counting.
QuantityCountTolerance String Count tolerance percent to use before the application does not allow the count. This tolerance prevents data entry mistakes when counting, and prevents ordering too much quantity for the replenishment request.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462