JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

InventoryOnhandBalanceslotslotSerials

The Lot Serials resource gets the serial numbers associated with an inventory balance record for a lot-serial controlled item.

Columns

Name Type Description
InventoryOnhandBalancesInventoryItemId [KEY] Long InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesLocatorId [KEY] Long InventoryOnhandBalancesLocatorId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesOrganizationId [KEY] Long InventoryOnhandBalancesOrganizationId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesOwningPartySiteId [KEY] Long InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesRevision [KEY] String InventoryOnhandBalancesRevision of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesSubinventoryCode [KEY] String InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesSubinventoryGroup [KEY] String InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesSummaryLevel [KEY] String InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalanceslotslotSerials
LotsLotNumber [KEY] String LotsLotNumber of InventoryOnhandBalanceslotslotSerials
LotsOwningPartySiteId [KEY] Long LotsOwningPartySiteId of InventoryOnhandBalanceslotslotSerials
SerialNumber [KEY] String SerialNumber of InventoryOnhandBalanceslotslotSerials
MaterialStatusId Long MaterialStatusId of InventoryOnhandBalanceslotslotSerials
InventoryProjectId [KEY] Long InventoryProjectId of InventoryOnhandBalanceslotslotSerials
InventoryTaskId [KEY] Long InventoryTaskId of InventoryOnhandBalanceslotslotSerials
CountryOfOriginCode [KEY] String CountryOfOriginCode of InventoryOnhandBalanceslotslotSerials
OwningPartySiteId [KEY] Long OwningPartySiteId of InventoryOnhandBalanceslotslotSerials
MaterialStatus String MaterialStatus of InventoryOnhandBalanceslotslotSerials
OwningPartySite String OwningPartySite of InventoryOnhandBalanceslotslotSerials
OwningPartyId Long OwningPartyId of InventoryOnhandBalanceslotslotSerials
OwningParty String OwningParty of InventoryOnhandBalanceslotslotSerials
InventoryProject String InventoryProject of InventoryOnhandBalanceslotslotSerials
InventoryTask String InventoryTask of InventoryOnhandBalanceslotslotSerials
CountryOfOrigin String CountryOfOrigin of InventoryOnhandBalanceslotslotSerials
Finder String Finder of InventoryOnhandBalanceslotslotSerials
InventoryItemId Long InventoryItemId of InventoryOnhandBalanceslotslotSerials
LocatorId Long LocatorId of InventoryOnhandBalanceslotslotSerials
OrganizationId Long OrganizationId of InventoryOnhandBalanceslotslotSerials
Revision String Revision of InventoryOnhandBalanceslotslotSerials
SubinventoryCode String SubinventoryCode of InventoryOnhandBalanceslotslotSerials
SubinventoryGroup String SubinventoryGroup of InventoryOnhandBalanceslotslotSerials
SummaryLevel String SummaryLevel of InventoryOnhandBalanceslotslotSerials

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