JDBC Driver for Oracle SCM

Build 22.0.8462

InventoryAttributeTransactionRequestslines

Value that identifies the inventory attribute transaction request line number.

Columns

Name Type Description
InventoryAttributeTransactionRequestsHeaderId String InventoryAttributeTransactionRequestsHeaderId of InventoryAttributeTransactionRequestslines
HeaderId String Value that identifies the inventory attribute transaction request header number.
LineId String Value that identifies the inventory attribute transaction request line number.
LineNumber Int Number that identifies the inventory attribute transaction request line number.
SourceLineId String Value that uniquely identifies the project transfers initiated by Oracle Fusion Supply Chain Orchestration.
OrganizationId String Value that uniquely identifies the organization.
OrganizationCode String Organization for which the project transfer transaction is requested.
InventoryItemId String Value that uniquely identifies the inventory item.
ItemNumber String Identifies the inventory item number.
RequestedQuantity String Quantity requested for project transfer.
RequestedUOMCode String Unit of measure for the requested quantity.
RequestedUnitOfMeasure String Quantity requested for the item in its primary unit of measure.
TransferQuantity String Transferred quantity of the item.
ProjectId String Value that uniquely identifies the source project for the project transfer transactions.
ProjectNumber String Number that identifies the source project for the project transfer transactions.
TaskId String Value that uniquely identifies the source task for the project transfer transactions.
TaskNumber String Number that identifies the source project for the project transfer transactions.
TransferProjectId String Value that uniquely identifies the destination project for the project transfer transactions.
TransferProjectNumber String Number that identifies the destination project for the project transfer transactions.
TransferTaskId String Value that uniquely identifies the destination task for the project transfer transactions.
TransferTaskNumber String Number that identifies the destination project for the project transfer transactions.
StatusCode String Indicates the status of the inventory transaction attribution request line. Valid values are Open and Closed.
Status String Indicates the status of the inventory transaction attribution request line.
SecondaryRequestedQuantity String Quantity requested for project transfer in its secondary unit of measure.
SecondaryUOMCode String Abbreviation that identifies the secondary unit of measure that does not have a fixed conversion from the primary unit of measure. In accordance with dual unit of measure record-keeping, SecondaryUOMCode enables industries to maintain and use inventory in both quantity and weight units of measure, or in volume and length units of measure.
SecondaryRequestedUnitOfMeasure String Secondary unit of measure in which an item can be transacted.
SecondaryTransferQuantity String Transferred quantity of an item in its secondary unit of measure.

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