JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryItemSerialNumbers

The Inventory Item Serial Numbers resource manages the current serial numbers for items in organizations.

Columns

Name Type Description
OrganizationId String Value that uniquely identifies the organization.
OrganizationCode String Abbreviation that identifies the organization.
OrganizationName String Name of the organization.
InventoryItemId String Value that uniquely identifies the inventory item.
ItemNumber String Name of the inventory item.
ItemDescription String ItemDescription of InventoryItemSerialNumbers
SerialNumber String Serial number that identifies the inventory item.
SubinventoryCode String SubinventoryCode of InventoryItemSerialNumbers
LocatorId String LocatorId of InventoryItemSerialNumbers
Locator String Locator of InventoryItemSerialNumbers
LotNumber String LotNumber of InventoryItemSerialNumbers
Revision String Revision of InventoryItemSerialNumbers
StatusId String Value that uniquely identifies the material status.
StatusCode String Abbreviation that identifies the status of the item.
UsageCode String UsageCode of InventoryItemSerialNumbers
Usage String Usage of InventoryItemSerialNumbers
ShippedDate Datetime ShippedDate of InventoryItemSerialNumbers
ReceiptDate Datetime ReceiptDate of InventoryItemSerialNumbers
Allocated String Allocated of InventoryItemSerialNumbers
Reserved String Reserved of InventoryItemSerialNumbers
Supplier String Name of the supplier.
SupplierLot String Number that identifies the supplier lot.
SupplierSerialNumber String Serial number assigned to the item by its supplier.

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