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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindInventoryItemId | Long | bindInventoryItemId |
| BindItemNumber | String | bindItemNumber |
| BindLotNumber | String | bindLotNumber |
| BindOrganizationCode | String | bindOrganizationCode |
| Finder | String | finder |