InventoryMovementRequestslinesinventoryStripingDFF
InventoryMovementRequestslinesinventoryStripingDFF
Columns
Name | Type | Description |
InventoryMovementRequestsHeaderId [KEY] | Long | InventoryMovementRequestsHeaderId of InventoryMovementRequestslinesinventoryStripingDFF |
LinesLineId [KEY] | Long | LinesLineId of InventoryMovementRequestslinesinventoryStripingDFF |
LineId [KEY] | Long | Value that uniquely identifies the movement request line. |
ProjectId | Long | Value that uniquely identifies the project. This attribute is derived from the source document for the pick wave movement requests created for sales orders, transfer orders, and work orders. The attribute is entered when creating the requisition movement request if the transaction type is enabled for projects. |
ProjectId_Display | String | Number that identifies the project. This attribute is derived from the source document for the pick wave movement requests created for sales orders, transfer orders, and work orders. The attribute is entered when creating the requisition movement request if the transaction type is enabled for projects. |
TaskId | Long | Value that uniquely identifies the task. This attribute is derived from the source document for the pick wave movement requests created for sales orders, transfer orders, and work orders. The attribute is entered when creating the requisition movement request if the transaction type is enabled for projects. |
TaskId_Display | String | Number that identifies the task. This attribute is derived from the source document for the pick wave movement requests created for sales orders, transfer orders, and work orders. The attribute is entered when creating the requisition movement request if the transaction type is enabled for projects. |
CountryOfOriginCode | String | Abbreviation that identifies the country of origin. This attribute is not applicable for movement request. |
CountryOfOriginCode_Display | String | Value that identifies the country of origin. This attribute is not applicable for movement request. |
_FLEX_Context | String | Descriptive flexfield context name for inventory striping attributes. |
_FLEX_Context_DisplayValue | String | Descriptive flexfield context display value for inventory striping attributes. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
HeaderId | Long | HeaderId |
BindItemNumber | String | bindItemNumber |
BindLineStatus | String | bindLineStatus |
BindMovementRequestNumber | String | bindMovementRequestNumber |
BindMovementRequestType | String | bindMovementRequestType |
BindOrganizationCode | String | bindOrganizationCode |
BindUserName | String | bindUserName |
Finder | String | finder |