JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryMovementRequestslines

The Lines for Inventory Movement Requests resource manages lines for movement requests.

Columns

Name Type Description
InventoryMovementRequestsHeaderId String InventoryMovementRequestsHeaderId of InventoryMovementRequestslines
HeaderId String HeaderId of InventoryMovementRequestslines
LineId String LineId of InventoryMovementRequestslines
LineNumber String LineNumber of InventoryMovementRequestslines
InventoryItemId String Value that uniquely identifies the inventory item.
ItemNumber String Name of the inventory item.
ItemDescription String ItemDescription of InventoryMovementRequestslines
ItemRevision String Value that indicates the revision of the inventory item.
TransactionTypeId String Value that uniquely identifies the type of transaction.
TransactionType String Name of the transaction type.
RequiredDate Datetime Date when the movement request line is required.
RequesterName String Name of the person who requested the movement.
RequesterId String Value that uniquely identifies the person who requested the movement.
Reason String Name of the movement request reason.
ReasonId String Value that uniquely identifies the movement request reason.
Order String Order of InventoryMovementRequestslines
Reference String Reference to the movement request.
RequestedQuantity String Quantity requested for the item.
QuantityDelivered String QuantityDelivered of InventoryMovementRequestslines
UOMCode String Abbreviation that identifies the unit of measure of the line quantity.
UOMName String Name of the unit of measure of the line quantity.
SecondaryRequestedQuantity String Quantity requested for the item in the secondary unit of measure.
SecondaryQuantityDelivered String SecondaryQuantityDelivered of InventoryMovementRequestslines
SecondaryUOMCode String SecondaryUOMCode of InventoryMovementRequestslines
SecondaryUOMName String SecondaryUOMName of InventoryMovementRequestslines
StatusDate Date StatusDate of InventoryMovementRequestslines
StatusCode Long Value that uniquely identifies the line 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 line.
CreatedBy String CreatedBy of InventoryMovementRequestslines
SourceSubinventory String Abbreviation that identifies the source subinventory.
SourceLocatorId String Value that uniquely identifies the source stock locator.
SourceLocator String Description of the source stock locator.
ReferenceTypeCode Long ReferenceTypeCode of InventoryMovementRequestslines
ReferenceSourceType String ReferenceSourceType of InventoryMovementRequestslines
DestinationSubinventory String Abbreviation that identifies the destination subinventory.
DestinationLocatorId String Value that uniquely identifies the destination stock locator.
DestinationLocator String Description of the destination stock locator.
DestinationAccountId String Value that uniquely identifies the destination account.
DestinationAccount String Number that indicates the destination account for the movement request.
ShipToLocationId String Value that uniquely identifies the destination location.
ShipToLocation String ShipToLocation of InventoryMovementRequestslines
LotNumber String Number that identifies the lot for the inventory item. This attribute is used when the warehouse places the item under lot control.
Grade String Grade of InventoryMovementRequestslines
ToSerialNumber String Ending serial number in a range of serial numbers that tracks items that are in inventory. The application uses this attribute when the warehouse places the item under serial control.
FromSerialNumber String Starting serial number in a range of serial numbers that tracks items that are in inventory. The application uses this attribute when the warehouse places the item under serial control.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462