InventoryItemLots
The Inventory Item Lots resource manages lot numbers for items in an organization.
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | Value that uniquely identifies the organization. |
| OrganizationCode | String | Abbreviation that identifies the organization. |
| OrganizationName | String | Name of the organization. |
| InventoryItemId [KEY] | Long | Value that uniquely identifies the inventory item. |
| ItemNumber | String | Name of the inventory item. |
| ItemDescription | String | ItemDescription of InventoryItemLots |
| LotNumber [KEY] | 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 | Long | 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 |
| UniqueDeviceIdentifier | String | Value that uniquely identifies the device. |
| ItemPrimaryImageURL | String | ItemPrimaryImageURL of InventoryItemLots |
| BindInventoryItemId | Long | BindInventoryItemId of InventoryItemLots |
| BindItemNumber | String | BindItemNumber of InventoryItemLots |
| BindLotNumber | String | BindLotNumber of InventoryItemLots |
| BindOrganizationCode | String | BindOrganizationCode of InventoryItemLots |
| Finder | String | Finder of InventoryItemLots |
| Param_CycleCountHeaderId | Long | Param_CycleCountHeaderId of InventoryItemLots |
| Param_InventoryItemId | Long | Param_InventoryItemId of InventoryItemLots |
| Param_LocatorId | Long | Param_LocatorId of InventoryItemLots |
| Param_OrganizationId | Long | Param_OrganizationId of InventoryItemLots |
| Param_Subinventory | String | Param_Subinventory of InventoryItemLots |
| Param_TransactionTypeId | Long | Param_TransactionTypeId of InventoryItemLots |