JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryItemLots

The Inventory Item Lots resource manages lot numbers for items in an organization.

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 InventoryItemLots
LotNumber String Number that identifies the lot.
ParentLotNumber String Number that identifies the parent lot.
ActiveLotCode String Abbreviation that indicates the status of the lot. A list of accepted values is defined in the lookup type ORA_INV_LOT_ACTIVE. The default value is 2.
ActiveLot String Value that indicates the status of the lots. A list of accepted values is defined in the lookup type ORA_INV_LOT_ACTIVE. The default value is Yes.
OriginationTypeCode String Abbreviation that identifies the origination type of the lots. A list of accepted values is defined in the lookup type INV_LOT_ORIGINATION_TYPE. The default value is 0.
OriginationType String Value that identifies the origination type of the lots. A list of accepted values is defined in the lookup type INV_LOT_ORIGINATION_TYPE. The default value is Lot master.
StatusId String Value that uniquely identifies the material status.
StatusCode String Abbreviation that identifies the status of the item.
Grade String Abbreviation that identifies the grade of the item.
ExpirationActionCode String Abbreviation that identifies the expiration action.
ExpirationAction String Expiration action.
OriginationDate Datetime Date when the warehouse created the lot.
ExpirationDate Datetime Date when the warehouse expired the lot.
MaturityDate Datetime Date when the item matures.
ExpirationActionDate Datetime Date when the warehouse performed the expiration action.
HoldUntilDate Datetime Date when the hold expires.
RetestDate Datetime Date when the lot is retested. This attribute is based on the lot origination date and the retest interval.
DisabledCode String DisabledCode of InventoryItemLots
Disabled String Disabled of InventoryItemLots

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