SSIS Components for Oracle Fusion Cloud SCM

Build 23.0.8839

ReceivingReceiptTransactionRequestsDFF

ReceivingReceiptTransactionRequestsDFF

Columns

Name Type Description
ReceivingReceiptTransactionRequestsInterfaceTransactionId [KEY] Long ReceivingReceiptTransactionRequestsInterfaceTransactionId of ReceivingReceiptTransactionRequestsDFF
InterfaceTransactionId [KEY] Long InterfaceTransactionId of ReceivingReceiptTransactionRequestsDFF
_FLEX_Context String Descriptive flexfield context name for receipt transaction requests.
_FLEX_Context_DisplayValue String Descriptive flexfield context display name for receipt transaction requests.

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
DocumentNumber String DocumentNumber
ExternalSystemTransactionReference String ExternalSystemTransactionReference
FromDate Datetime FromDate
GroupId Long GroupId
ItemId String ItemId
ItemNumber String ItemNumber
OrganizationCode String OrganizationCode
OrganizationId String OrganizationId
POHeaderId Long POHeaderId
ProcessingStatusCode String ProcessingStatusCode
RMANumber String RMANumber
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId
ShipmentHeaderId Long ShipmentHeaderId
ShipmentNumber String ShipmentNumber
SourceDocumentCode String SourceDocumentCode
ToDate Datetime ToDate
TransactionStatusCode String TransactionStatusCode
TransactionType String TransactionType
TransferOrderHeaderId Long TransferOrderHeaderId
Finder String finder

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