InventoryMovementRequests
InventoryMovementRequests
Columns
| Name | Type | Description |
| OrganizationId | Long | Value that uniquely identifies the organization. |
| OrganizationCode | String | Abbreviation that identifies the organization. |
| OrganizationName | String | Name of the source organization. |
| HeaderId [KEY] | Long | HeaderId of InventoryMovementRequests |
| RequestNumber | String | Number that identifies the movement request. |
| Description | String | Description of the movement request. |
| RequiredDate | Datetime | Date when the movement request is required. |
| TransactionTypeId | Long | Value that uniquely identifies the type of the transaction. |
| TransactionType | String | Name of the transaction type. |
| MoveOrderType | Long | MoveOrderType of InventoryMovementRequests |
| MovementRequestType | String | MovementRequestType of InventoryMovementRequests |
| StatusCode | Long | Value that uniquely identifies the header status for the movement request. A list of accepted values is defined in the lookup type INV_TXN_REQUEST_STATUS. |
| Status | String | Value that indicates the status for the movement request header. |
| SourceSubinventory | String | Abbreviation that identifies the source subinventory. |
| DestinationSubinventory | String | Abbreviation that identifies the destination subinventory. |
| DestinationAccount | String | Number that indicates the destination account for the movement request. |
| DestinationAccountId | Long | Value that uniquely identifies the destination account. |
| SubmitApprovalFlag | Bool | Contains one of the following values: True or False. If True, then the movement request is submitted for approval. If False, then the movement request isn't submitted for approval. The default value is False. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindItemNumber | String | bindItemNumber |
| BindLineStatus | String | bindLineStatus |
| BindMovementRequestNumber | String | bindMovementRequestNumber |
| BindMovementRequestType | String | bindMovementRequestType |
| BindOrganizationCode | String | bindOrganizationCode |
| BindUserName | String | bindUserName |
| Finder | String | finder |