InventoryItemLots
Manages lot numbers for items within organizations, facilitating inventory control and traceability.
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | The unique identifier for the organization managing the inventory lot. This identifier ensures accurate tracking of stock ownership and operational reporting. |
| OrganizationCode | String | The abbreviation that represents the organization responsible for the inventory lot. This abbreviation ensures clear identification in multi-organization environments. |
| OrganizationName | String | The full name of the organization managing the inventory lot. This name ensures proper assignment of transactions to business entities. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item associated with the lot. This identifier ensures traceability of item-level inventory across transactions. |
| ItemNumber | String | The unique identifier assigned to the inventory item. This identifier ensures accurate tracking and reporting of inventory at the item level. |
| ItemDescription | String | The description of the inventory item, providing a user-friendly reference for inventory management and reporting. |
| LotNumber [KEY] | String | The unique number assigned to the lot for inventory tracking. This number ensures traceability of lot-controlled inventory for compliance, quality control, and expiration tracking. |
| ParentLotNumber | String | The unique identifier for the parent lot. This identifier is used for tracking lot relationships in split or merged inventory scenarios. |
| ActiveLotCode | String | The status code that indicates whether the lot is active or inactive. Accepted values are defined in the lookup type ORA_INV_LOT_ACTIVE. |
| ActiveLot | String | The status of the lot, indicating whether it is currently active for transactions. Accepted values are defined in the lookup type ORA_INV_LOT_ACTIVE. |
| OriginationTypeCode | String | The code representing the origination type of the lot (for example, 'Manufactured' or 'Purchased'). Accepted values are defined in the lookup type INV_LOT_ORIGINATION_TYPE. |
| OriginationType | String | The description of the origination type of the lot, defining whether the inventory was produced in-house or sourced externally. |
| StatusId | Long | The unique identifier for the material status associated with the lot. This identifier ensures accurate classification of inventory availability. |
| StatusCode | String | The status code assigned to the lot, indicating its availability for use (for example, 'Available', 'Hold', or 'Expired'). |
| Grade | String | The grade classification of the inventory item within the lot, supporting quality control and grading standards. |
| ExpirationActionCode | String | The code representing the action to be taken when the lot reaches expiration (for example, 'Destroy' or 'Hold'). |
| ExpirationAction | String | The description of the action applied to the lot when it reaches expiration. This description ensures proper handling of expired inventory. |
| OriginationDate | Datetime | The date when the lot was created in the warehouse. This date supports traceability and quality control measures. |
| ExpirationDate | Datetime | The date when the lot expires and is no longer available for consumption. This date ensures proper inventory rotation and regulatory compliance. |
| MaturityDate | Datetime | The date when the inventory item within the lot reaches maturity. This date supports quality management and production planning. |
| ExpirationActionDate | Datetime | The date when the expiration action was performed on the lot. This date ensures accurate tracking of inventory lifecycle events. |
| HoldUntilDate | Datetime | The date until which the lot is placed on hold. This dawte ensures control over restricted inventory before its release for consumption. |
| RetestDate | Datetime | The date when the lot is scheduled for retesting to assess its continued usability. This date supports quality control measures. |
| DisabledCode | String | The status code indicating whether the lot is disabled. This code ensures control over restricted inventory items. |
| Disabled | String | Indicates whether the lot is disabled and unavailable for transactions. This field ensures accurate stock visibility and compliance. |
| UniqueDeviceIdentifier | String | The unique device identifier (UDI) assigned to the inventory item. This identifier ensures compliance with medical device regulations. |
| ItemPrimaryImageURL | String | The URL of the primary image associated with the inventory item. This URL supports product visibility and catalog integration. |
| BindInventoryItemId | Long | The identifier linking the inventory item to system bindings for integration purposes. This identifier ensures accurate data mapping in transactions. |
| BindItemNumber | String | The inventory item number used in system bindings to ensure consistency in inventory tracking across integrated platforms. |
| BindLotNumber | String | The lot number used in system bindings to ensure accurate lot tracking in integrated systems. |
| BindOrganizationCode | String | The organization code used in system bindings to ensure accurate tracking of lot ownership across systems. |
| Finder | String | The lookup reference used to retrieve and manage inventory lot records. This reference facilitates efficient searching, reporting, and system queries. |
| Param_CycleCountHeaderId | Long | The unique identifier for the cycle count header associated with the lot. This identifier ensures accurate stock reconciliation during cycle counting. |
| Param_InventoryItemId | Long | The unique identifier linking the inventory item to cycle count and transaction processes. This identifier ensures accurate tracking during inventory adjustments. |
| Param_LocatorId | Long | The unique identifier for the locator where the lot is stored. This identifier ensures accurate tracking of inventory placement within a warehouse. |
| Param_OrganizationId | Long | The unique identifier for the organization conducting the cycle count or inventory transaction involving the lot. |
| Param_Subinventory | String | The subinventory where the lot is stored. This subinventory ensures accurate tracking of inventory location within an organization. |
| Param_TransactionTypeId | Long | The unique identifier for the transaction type associated with the lot movement. This identifier ensures proper classification of inventory transactions. |