SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

TransferOrderstransferOrderLines

Manages details of lines within transfer orders, supporting effective order execution and tracking.

Columns

Name Type SupportedFinders Description
TransferOrdersHeaderId [KEY] Long Unique identifier for the transfer order header.
LineId [KEY] Long Unique identifier for the transfer order line.
LineNumber Int Line number within the transfer order.
HeaderId Long PrimaryKey Reference to the transfer order header.
HeaderNumber String Transfer order header number.
InterfaceStatusLookup String Lookup code for interface processing status.
InterfaceStatus String Status of the transfer order line interface.
FulfillmentStatusLookup String Lookup code for fulfillment status.
FulfillStatusMeaning String Meaning of the fulfillment status.
SourceTypeLookup String Source type lookup for the transfer order.
SourceOfTransferOrder String Source application for the transfer order.
SourceOrganizationId Long ID of the source organization.
SourceOrganizationCode String Code of the source organization.
SourceOrganizationName String Name of the source organization.
SourceSubinventoryCode String Code of the source subinventory.
DestinationOrganizationId Long ID of the destination organization.
DestinationOrganizationCode String Code of the destination organization.
DestinationOrganizationName String Name of the destination organization.
DestinationSubinventoryCode String Code of the destination subinventory.
DestinationTypeLookup String Lookup code for destination type.
DestinationType String Type of destination (Inventory, Expense).
DestinationLocationId Long ID of the destination location.
DestinationLocationCode String Code of the destination location.
DestinationLocationName String Name of the destination location.
DestinationAddressFirstLine String First line of the destination address.
DestinationAddressSecondLine String Second line of the destination address.
DestinationAddressThirdLine String Third line of the destination address.
DestinationAddressFourthLine String Fourth line of the destination address.
DestinationCity String City of the destination.
DestinationState String State of the destination.
DestinationPostalCode String Postal code of the destination.
DestinationCountry String Country of the destination.
MaterialReturnRequired String Indicates if material return is required.
StatusLookup String Lookup code for line status.
TransferOrderLineStatus String Current status of the transfer order line.
InventoryItemId Long Unique identifier for the inventory item.
ItemNumber String Item number associated with the transfer order.
ItemRevision String Revision number of the item.
NeedByDate Datetime Date when the item is needed.
ScheduledShipDate Datetime Scheduled shipping date.
QuantityUOMCode String Unit of measure (UOM) code for requested quantity.
QuantityUOMName String UOM name for requested quantity.
RequestedQuantity Decimal Quantity requested for transfer.
ShippedQuantity Decimal Quantity shipped from the source.
ReceivedQuantity Decimal Quantity received at the destination.
DeliveredQuantity Decimal Quantity delivered to the recipient.
SecondaryQuantityUOMCode String Secondary UOM code.
SecondaryQuantityUOMName String Secondary UOM name.
SecondaryRequestedQuantity Decimal Quantity requested in secondary UOM.
SecondaryShippedQuantity Decimal Quantity shipped in secondary UOM.
SecondaryReceivedQuantity Decimal Quantity received in secondary UOM.
SecondaryDeliveredQuantity Decimal Quantity delivered in secondary UOM.
UnitPrice Decimal Unit price of the item in transfer.
FreightCarrierId Long Unique identifier for the freight carrier.
CarrierName String Name of the freight carrier.
ModeOfTransportLookup String Lookup code for mode of transport.
ModeOfTransport String Mode of transportation (Air, Rail).
ServiceLevelLookup String Lookup code for service level.
ServiceLevel String Service level of the shipment.
ShipMethodDescription String Description of the shipping method.
ShipmentPriorityLookup String Lookup code for shipment priority.
ShipmentPriority String Shipment priority level (High, Medium, Low).
OriginalHeaderId Long Original header ID for linked orders.
OriginalTransferOrder String Original transfer order number.
OriginalLineId Long Original line ID for linked orders.
OriginalTransferOrderLine String Original transfer order line number.
RequisitionId Long Unique identifier for the requisition.
RequisitionLineId Long Unique identifier for the requisition line.
RequisitionLineNumber String Requisition line number.
RequesterId Long ID of the requester of the transfer.
RequesterName String Name of the requester of the transfer.
InterfaceErrMsgCode String Error message code for interface processing.
InterfaceErrMsgText String Detailed error message for interface processing.
PlannerId Long ID of the supply chain planner.
PlannerName String Name of the supply chain planner.
ChangeStatusLookup String Lookup code for change status.
ChangeStatus String Current status of the requested change.
ChangeRequestedDate Datetime Date when the change was requested.
Comments String Additional comments on the transfer order line.
SourceHeaderId Long ID of the source transaction header.
SourceLineId Long ID of the source transaction line.
InclNonrecoverableTax Decimal Amount of non-recoverable tax included.
InclRecoverableTax Decimal Amount of recoverable tax included.
NoninclNonrecoverableTax Decimal Non-included non-recoverable tax.
NoninclRecoverableTax Decimal Non-included recoverable tax.
CurrencyCode String Currency code for financial transactions.
AgreementPtrId Long Reference ID for the agreement.
FirmPlanningScheduleLookup String Lookup code for firm planning schedule.
FirmPlanningSchedule String Firm planning schedule details.
InterfaceSourceCode String Source code for interface processing.
BackToBack String Indicates if the transfer is a back-to-back request.
OriginalRequestLineId Long ID of the original request line.
ActionSourceType String Type of action source.
NoteToReceiver String Notes for the receiving party.
NoteToSupplier String Notes for the supplier.
Reprice String Indicates if re-pricing is required.
ChangePartyId Long ID of the party initiating the change.
ChangeInitiatingPersonName String Name of the person initiating the change.
Region String Region associated with the transfer order.
Action String Action to be performed on the transfer order.
AllowItemSubstitution String Indicates if item substitution is allowed.
AllowItemSubstitutionMeaning String Description of the item substitution rule.
ItemSubstituted String Indicates if an item was substituted.
ItemSubstitutedMeaning String Description of the substituted item.
InitialRequestedQuantity Decimal Initial requested quantity before changes.
RequisitionNumber String Requisition number linked to the transfer.
Finder String Utility field for locating transfer order lines.
PBatch String FindByShippingBatch Batch identifier for the transfer order.
PDestinationOrganization String FindByTransferOrderDetails Destination organization for the transfer order.
PItemNumber String FindByTransferOrderDetails Item number associated with the transfer order.
PLineNumber String FindByTransferOrderDetails Line number within the transfer order.
PLineStatus String FindByTransferOrderDetails Current 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.
PTransactionOrigin String FindByTransferOrderDetails Transaction origin of the transfer order.
PTransferOrder String FindByTransferOrderDetails Reference number for the transfer order.

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