JDBC Driver for Oracle Fusion Cloud SCM

Build 26.0.9770

TransferOrderstransferOrderLinestransferLineItemSubstitutes

TransferOrderstransferOrderLinestransferLineItemSubstitutes

Columns

Name Type SupportedFinders Description
TransferOrdersHeaderId [KEY] Long Value that uniquely identifies the transfer order header
TransferOrderLinesLineId [KEY] Long Value that uniquely identifies the transfer order line
InventoryItemId Long Value that uniquely identifies the inventory item
ItemNumber String Number that identifies the inventory item
PrimaryUOMCode String Code that identifies the primary unit of measure
UnitOfMeasure String Unit of measure for the inventory item
OrganizationId Decimal Value that uniquely identifies the organization
ShippedQuantity Decimal Quantity of items shipped
Finder String Finder method identifier for querying with specific filter criteria
HeaderId Long PrimaryKey Unique identifier for the transfer order header
PBatch String FindByShippingBatch Shipping batch identifier for the transfer order line
PDestinationOrganization String FindByTransferOrderDetails Destination organization for the transfer order line
PItemNumber String FindByTransferOrderDetails Item number for the transfer order line
PLineNumber String FindByTransferOrderDetails Line number for the transfer order line
PLineStatus String FindByTransferOrderDetails Status of the transfer order line
PScheduledShipDate Datetime FindByTransferOrderDetails Scheduled ship date for the transfer order line
PSourceOrganization String FindByTransferOrderDetails Source organization for the transfer order line
PTransactionOrigin String FindByTransferOrderDetails Transaction origin for the transfer order line
PTransferOrder String FindByTransferOrderDetails Transfer order number for the transfer order line

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770