InventoryItemLots
InventoryItemLots
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 |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
BindInventoryItemId | Long | bindInventoryItemId |
BindItemNumber | String | bindItemNumber |
BindLotNumber | String | bindLotNumber |
BindOrganizationCode | String | bindOrganizationCode |
Finder | String | finder |