JDBC Driver for Oracle SCM

Build 22.0.8462

Subinventories

The Subinventories resource manages operations on subinventories.

Columns

Name Type Description
AssetSubinventory Int Determines whether or not to consider the inventory in the subinventory as an asset. Contains one of the following values. 1: asset subinventory. 2: not an asset subinventory. The default value is 1.
DefaultCountTypeCode String Abbreviation that identifies the replenishment type to use with Periodic Automatic Replenishment in the subinventory. A list of accepted values is defined in the lookup type INV_DEFAULT_REPLEN_COUNT_TYPE. The default value is 4.
DefaultLocStatusId String Value that uniquely identifies the default material status for the locators that reference this subinventory. The default value is 1.
Depreciable Int Determines whether or not the inventory in this subinventory is depreciable. Contains one of the following values. 1: depreciable subinventory. 2: not a depreciable subinventory. The default value is 2.
Description String Description of the subinventory.
DisableDate Date Date when the subinventory is disabled for use in the application.
LocationId String Value that uniquely identifies the location that references the subinventory.
LocatorControl String Type of locator control that references the subinventory. A list of accepted values is defined in the lookup type INV_SUB_LOCATOR_CONTROL. The default value is 1.
OrganizationId String Value that uniquely identifies the organization that references the subinventory.
PickingOrder Long Picking order for the subinventory.
ParLocation Int Determines whether or not the subinventory is a Periodic Automatic Replenishment location. Contains one of the following values. 1: Yes subinventory. 2: No, not the subinventory. The default value is 2.
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.
QuantityTracked Int Determines whether or not to track the subinventory.
SecondaryInventoryName String Name of the subinventory.
SourceOrganizationId String Value that uniquely identifies the source organization. Used while sourcing the material to this subinventory.
SourceSubinventory String Name of the source subinventory. Used while sourcing the material to this subinventory.
SourcingType String Sourcing type to use to replenish stock for this subinventory. A list of accepted values is defined in the lookup type INV_SOURCE_TYPES.
MaterialStatusId String Value that uniquely identifies the material status that references the subinventory. The default value is 1.
LocatorStructure String Value that uniquely identifies the locator structure for the subinventory when a locator controls the subinventory.
SubinventoryType String Type of subinventory, such as Storage or Receiving. A list of accepted values is defined in the lookup type INV_SUB_TYPE. The default value is 1.
OrganizationCode String Abbreviation that identifies the organization that references the subinventory.
SourceOrganizationCode String Abbreviation that identifies the source organization. Used while sourcing the material to this subinventory.
MaterialStatusCode String Abbreviation that identifies the material status that references the subinventory.
LocationCode String Abbreviation that identifies the value that identifies the location that references the subinventory.
DefaultLocStatusCode String Abbreviation that identifies the default material status to use for the locators for this subinventory.
FillKillToLookup String FillKill status for this subinventory. A list of accepted values is defined in the lookup type ORA_INV_TO_FILLKILL_OPTIONS. The default value is NEXT_LEVEL.
CountMethod String Indicates the method to use to replenish. Values include Two-Bin, Request, or Count. A list of accepted values is defined in the lookup type ORA_REPLENISHMENT_COUNT_METHOD. The default value is COUNT.
SubinventoryGroup String Name of the subinventory group.

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