Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

TransferOrderstransferOrderLines

TransferOrderstransferOrderLines

Columns

Name Type Description
TransferOrdersHeaderId [KEY] Long TransferOrdersHeaderId of TransferOrderstransferOrderLines
LineId [KEY] Long LineId of TransferOrderstransferOrderLines
LineNumber Int LineNumber of TransferOrderstransferOrderLines
HeaderId Long HeaderId of TransferOrderstransferOrderLines
HeaderNumber String HeaderNumber of TransferOrderstransferOrderLines
InterfaceStatusLookup String InterfaceStatusLookup of TransferOrderstransferOrderLines
InterfaceStatus String InterfaceStatus of TransferOrderstransferOrderLines
FulfillmentStatusLookup String FulfillmentStatusLookup of TransferOrderstransferOrderLines
FulfillStatusMeaning String FulfillStatusMeaning of TransferOrderstransferOrderLines
SourceTypeLookup String SourceTypeLookup of TransferOrderstransferOrderLines
SourceOfTransferOrder String SourceOfTransferOrder of TransferOrderstransferOrderLines
SourceOrganizationId Long SourceOrganizationId of TransferOrderstransferOrderLines
SourceOrganizationCode String SourceOrganizationCode of TransferOrderstransferOrderLines
SourceOrganizationName String SourceOrganizationName of TransferOrderstransferOrderLines
SourceSubinventoryCode String SourceSubinventoryCode of TransferOrderstransferOrderLines
DestinationOrganizationId Long DestinationOrganizationId of TransferOrderstransferOrderLines
DestinationOrganizationCode String DestinationOrganizationCode of TransferOrderstransferOrderLines
DestinationOrganizationName String DestinationOrganizationName of TransferOrderstransferOrderLines
DestinationSubinventoryCode String DestinationSubinventoryCode of TransferOrderstransferOrderLines
DestinationTypeLookup String DestinationTypeLookup of TransferOrderstransferOrderLines
DestinationType String DestinationType of TransferOrderstransferOrderLines
DestinationLocationId Long DestinationLocationId of TransferOrderstransferOrderLines
DestinationLocationCode String DestinationLocationCode of TransferOrderstransferOrderLines
DestinationLocationName String DestinationLocationName of TransferOrderstransferOrderLines
DestinationAddressFirstLine String DestinationAddressFirstLine of TransferOrderstransferOrderLines
DestinationAddressSecondLine String DestinationAddressSecondLine of TransferOrderstransferOrderLines
DestinationAddressThirdLine String DestinationAddressThirdLine of TransferOrderstransferOrderLines
DestinationAddressFourthLine String DestinationAddressFourthLine of TransferOrderstransferOrderLines
DestinationCity String DestinationCity of TransferOrderstransferOrderLines
DestinationState String DestinationState of TransferOrderstransferOrderLines
DestinationPostalCode String DestinationPostalCode of TransferOrderstransferOrderLines
DestinationCountry String DestinationCountry of TransferOrderstransferOrderLines
MaterialReturnRequired String MaterialReturnRequired of TransferOrderstransferOrderLines
StatusLookup String StatusLookup of TransferOrderstransferOrderLines
TransferOrderLineStatus String TransferOrderLineStatus of TransferOrderstransferOrderLines
InventoryItemId Long InventoryItemId of TransferOrderstransferOrderLines
ItemNumber String ItemNumber of TransferOrderstransferOrderLines
ItemRevision String ItemRevision of TransferOrderstransferOrderLines
NeedByDate Datetime NeedByDate of TransferOrderstransferOrderLines
ScheduledShipDate Datetime ScheduledShipDate of TransferOrderstransferOrderLines
QuantityUOMCode String QuantityUOMCode of TransferOrderstransferOrderLines
QuantityUOMName String QuantityUOMName of TransferOrderstransferOrderLines
RequestedQuantity Double RequestedQuantity of TransferOrderstransferOrderLines
ShippedQuantity Double ShippedQuantity of TransferOrderstransferOrderLines
ReceivedQuantity Double ReceivedQuantity of TransferOrderstransferOrderLines
DeliveredQuantity Double DeliveredQuantity of TransferOrderstransferOrderLines
SecondaryQuantityUOMCode String SecondaryQuantityUOMCode of TransferOrderstransferOrderLines
SecondaryQuantityUOMName String SecondaryQuantityUOMName of TransferOrderstransferOrderLines
SecondaryRequestedQuantity Double SecondaryRequestedQuantity of TransferOrderstransferOrderLines
SecondaryShippedQuantity Double SecondaryShippedQuantity of TransferOrderstransferOrderLines
SecondaryReceivedQuantity Double SecondaryReceivedQuantity of TransferOrderstransferOrderLines
SecondaryDeliveredQuantity Double SecondaryDeliveredQuantity of TransferOrderstransferOrderLines
UnitPrice Double UnitPrice of TransferOrderstransferOrderLines
FreightCarrierId Long FreightCarrierId of TransferOrderstransferOrderLines
CarrierName String CarrierName of TransferOrderstransferOrderLines
ModeOfTransportLookup String ModeOfTransportLookup of TransferOrderstransferOrderLines
ModeOfTransport String ModeOfTransport of TransferOrderstransferOrderLines
ServiceLevelLookup String ServiceLevelLookup of TransferOrderstransferOrderLines
ServiceLevel String ServiceLevel of TransferOrderstransferOrderLines
ShipMethodDescription String ShipMethodDescription of TransferOrderstransferOrderLines
ShipmentPriorityLookup String ShipmentPriorityLookup of TransferOrderstransferOrderLines
ShipmentPriority String ShipmentPriority of TransferOrderstransferOrderLines
OriginalHeaderId Long OriginalHeaderId of TransferOrderstransferOrderLines
OriginalTransferOrder String OriginalTransferOrder of TransferOrderstransferOrderLines
OriginalLineId Long OriginalLineId of TransferOrderstransferOrderLines
OriginalTransferOrderLine String OriginalTransferOrderLine of TransferOrderstransferOrderLines
RequisitionId Long RequisitionId of TransferOrderstransferOrderLines
RequisitionNumber String RequisitionNumber of TransferOrderstransferOrderLines
RequisitionLineId Long RequisitionLineId of TransferOrderstransferOrderLines
RequisitionLineNumber String RequisitionLineNumber of TransferOrderstransferOrderLines
RequesterId Long RequesterId of TransferOrderstransferOrderLines
RequesterName String RequesterName of TransferOrderstransferOrderLines
InterfaceErrMsgCode String InterfaceErrMsgCode of TransferOrderstransferOrderLines
InterfaceErrMsgText String InterfaceErrMsgText of TransferOrderstransferOrderLines
PlannerId Long PlannerId of TransferOrderstransferOrderLines
PlannerName String PlannerName of TransferOrderstransferOrderLines
ChangeStatusLookup String ChangeStatusLookup of TransferOrderstransferOrderLines
ChangeStatus String ChangeStatus of TransferOrderstransferOrderLines
ChangeRequestedDate Datetime ChangeRequestedDate of TransferOrderstransferOrderLines
Comments String Comments of TransferOrderstransferOrderLines
SourceHeaderId Long SourceHeaderId of TransferOrderstransferOrderLines
SourceLineId Long SourceLineId of TransferOrderstransferOrderLines
InclNonrecoverableTax Double InclNonrecoverableTax of TransferOrderstransferOrderLines
InclRecoverableTax Double InclRecoverableTax of TransferOrderstransferOrderLines
NoninclNonrecoverableTax Double NoninclNonrecoverableTax of TransferOrderstransferOrderLines
NoninclRecoverableTax Double NoninclRecoverableTax of TransferOrderstransferOrderLines
CurrencyCode String CurrencyCode of TransferOrderstransferOrderLines
AgreementPtrId Long AgreementPtrId of TransferOrderstransferOrderLines
FirmPlanningScheduleLookup String FirmPlanningScheduleLookup of TransferOrderstransferOrderLines
FirmPlanningSchedule String FirmPlanningSchedule of TransferOrderstransferOrderLines
InterfaceSourceCode String InterfaceSourceCode of TransferOrderstransferOrderLines
BackToBack String BackToBack of TransferOrderstransferOrderLines
OriginalRequestLineId Long OriginalRequestLineId of TransferOrderstransferOrderLines
ActionSourceType String ActionSourceType of TransferOrderstransferOrderLines
NoteToReceiver String NoteToReceiver of TransferOrderstransferOrderLines
NoteToSupplier String NoteToSupplier of TransferOrderstransferOrderLines
Reprice String Reprice of TransferOrderstransferOrderLines
ChangePartyId Long ChangePartyId of TransferOrderstransferOrderLines
ChangeInitiatingPersonName String ChangeInitiatingPersonName of TransferOrderstransferOrderLines
Region String Region of TransferOrderstransferOrderLines
Action String Action of TransferOrderstransferOrderLines
AllowItemSubstitution String AllowItemSubstitution of TransferOrderstransferOrderLines
AllowItemSubstitutionMeaning String AllowItemSubstitutionMeaning of TransferOrderstransferOrderLines
ItemSubstituted String ItemSubstituted of TransferOrderstransferOrderLines
ItemSubstitutedMeaning String ItemSubstitutedMeaning of TransferOrderstransferOrderLines

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
Finder String finder
PBatch String pBatch
PDestinationOrganization String pDestinationOrganization
PItemNumber String pItemNumber
PLineNumber String pLineNumber
PLineStatus String pLineStatus
PScheduledShipDate Datetime pScheduledShipDate
PSourceOrganization String pSourceOrganization
PTransactionOrigin String pTransactionOrigin
PTransferOrder String pTransferOrder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839