Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

ActiveSubinventories

ActiveSubinventories

Columns

Name Type Description
SubinventoryId Long SubinventoryId of ActiveSubinventories
SecondaryInventoryName [KEY] String SecondaryInventoryName of ActiveSubinventories
OrganizationId [KEY] Long OrganizationId of ActiveSubinventories
OrganizationCode String OrganizationCode of ActiveSubinventories
OrganizationName String OrganizationName of ActiveSubinventories
Description String Description of ActiveSubinventories
DisableDate Date DisableDate of ActiveSubinventories
InventoryATPCode Int InventoryATPCode of ActiveSubinventories
IncludeInATP String IncludeInATP of ActiveSubinventories
NettableCode Int NettableCode of ActiveSubinventories
Nettable String Nettable of ActiveSubinventories
ReservableType Int ReservableType of ActiveSubinventories
AllowReservations String AllowReservations of ActiveSubinventories
LocatorTypeCode String LocatorTypeCode of ActiveSubinventories
LocatorType String LocatorType of ActiveSubinventories
PickingOrder Int PickingOrder of ActiveSubinventories
QuantityTrackedCode Int QuantityTrackedCode of ActiveSubinventories
QuantityTracked String QuantityTracked of ActiveSubinventories
AssetInventoryCode Int AssetInventoryCode of ActiveSubinventories
AssetInventory String AssetInventory of ActiveSubinventories
SourceTypeCode String SourceTypeCode of ActiveSubinventories
SourceType String SourceType of ActiveSubinventories
SourceSubinventory String SourceSubinventory of ActiveSubinventories
SourceOrganizationId Long SourceOrganizationId of ActiveSubinventories
SourceOrganizationCode String SourceOrganizationCode of ActiveSubinventories
SourceOrganizationName String SourceOrganizationName of ActiveSubinventories
PreprocessingLeadTime Int PreprocessingLeadTime of ActiveSubinventories
ProcessingLeadTime Int ProcessingLeadTime of ActiveSubinventories
PostprocessingLeadTime Int PostprocessingLeadTime of ActiveSubinventories
LocationId Long LocationId of ActiveSubinventories
LocationName String LocationName of ActiveSubinventories
DepreciableCode Int DepreciableCode of ActiveSubinventories
Depreciable String Depreciable of ActiveSubinventories
StatusId Long StatusId of ActiveSubinventories
StatusCode String StatusCode of ActiveSubinventories
SubinventoryTypeCode String SubinventoryTypeCode of ActiveSubinventories
SubinventoryType String SubinventoryType of ActiveSubinventories

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
BindItemId Long bindItemId
BindTransactionTypeId Long bindTransactionTypeId
Finder String finder

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