JDBC Driver for Oracle SCM

Build 22.0.8462

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 String InventoryOnhandBalancesInventoryItemId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesLocatorId String InventoryOnhandBalancesLocatorId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesOrganizationId String InventoryOnhandBalancesOrganizationId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesOwningPartySiteId String InventoryOnhandBalancesOwningPartySiteId of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesRevision String InventoryOnhandBalancesRevision of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesSubinventoryCode String InventoryOnhandBalancesSubinventoryCode of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesSubinventoryGroup String InventoryOnhandBalancesSubinventoryGroup of InventoryOnhandBalanceslotslotSerials
InventoryOnhandBalancesSummaryLevel String InventoryOnhandBalancesSummaryLevel of InventoryOnhandBalanceslotslotSerials
LotsLotNumber String LotsLotNumber of InventoryOnhandBalanceslotslotSerials
LotsOwningPartySiteId String LotsOwningPartySiteId of InventoryOnhandBalanceslotslotSerials
SerialNumber String SerialNumber of InventoryOnhandBalanceslotslotSerials
MaterialStatusId String MaterialStatusId of InventoryOnhandBalanceslotslotSerials
InventoryProjectId String InventoryProjectId of InventoryOnhandBalanceslotslotSerials
InventoryTaskId String InventoryTaskId of InventoryOnhandBalanceslotslotSerials
CountryOfOriginCode String CountryOfOriginCode of InventoryOnhandBalanceslotslotSerials
OwningPartySiteId String OwningPartySiteId of InventoryOnhandBalanceslotslotSerials
MaterialStatus String MaterialStatus of InventoryOnhandBalanceslotslotSerials
OwningPartySite String OwningPartySite of InventoryOnhandBalanceslotslotSerials
OwningPartyId String OwningPartyId of InventoryOnhandBalanceslotslotSerials
OwningParty String OwningParty of InventoryOnhandBalanceslotslotSerials
InventoryProject String InventoryProject of InventoryOnhandBalanceslotslotSerials
InventoryTask String InventoryTask of InventoryOnhandBalanceslotslotSerials
CountryOfOrigin String CountryOfOrigin of InventoryOnhandBalanceslotslotSerials

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