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 |