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
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 |
BindItemNumber | String | bindItemNumber |
BindLineStatus | String | bindLineStatus |
BindMovementRequestNumber | String | bindMovementRequestNumber |
BindMovementRequestType | String | bindMovementRequestType |
BindOrganizationCode | String | bindOrganizationCode |
BindUserName | String | bindUserName |
Finder | String | finder |