SSIS Components for Oracle Fusion Cloud SCM

Build 23.0.8839

SupplyRequestssupplyRequestLinestransferCostRequestDetails

SupplyRequestssupplyRequestLinestransferCostRequestDetails

Columns

Name Type Description
SupplyRequestsSupplyOrderReferenceNumber [KEY] String SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyRequestLinestransferCostRequestDetails
InterfaceBatchNumber String Number that identifies the batch of supply requests that are sent to Oracle Supply Chain Orchestration Cloud to create supplies. The batch consists of one or more supply requests.
TransferCostAmount Double Amount for the transfer cost on a transfer order line.
TransferCostCurrencyCode String Code that identifies the currency for the transfer cost amount.
TransferCostTypeName [KEY] String Name of the shipping cost type. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Cost Types task.
TransferCostOperation String Indicates whether the transfer cost line is to be created, updated, or canceled. Values include CREATE, UPDATE, and CANCEL.

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
SupplyOrderReferenceNumber String SupplyOrderReferenceNumber
BindDestOrganizationCode String bindDestOrganizationCode
BindDocumentNumber String bindDocumentNumber
BindItemNumber String bindItemNumber
BindNeedByDate Datetime bindNeedByDate
BindSupplyOrderNumber String bindSupplyOrderNumber
BindSupplyOrderReferenceNumber String bindSupplyOrderReferenceNumber
BindSupplyOrderSource String bindSupplyOrderSource
BindSupplyRequestDate Datetime bindSupplyRequestDate
BindSupplyStatus String bindSupplyStatus
BindSupplyType String bindSupplyType
Finder String finder

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