JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ReceivingReceiptRequestslinesprocessingErrors

ReceivingReceiptRequestslinesprocessingErrors

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslinesprocessingErrors
LinesInterfaceTransactionId [KEY] Long LinesInterfaceTransactionId of ReceivingReceiptRequestslinesprocessingErrors
InterfaceErrorId [KEY] Long InterfaceErrorId of ReceivingReceiptRequestslinesprocessingErrors
InterfaceHeaderId Long InterfaceHeaderId of ReceivingReceiptRequestslinesprocessingErrors
InterfaceLineId Long InterfaceLineId of ReceivingReceiptRequestslinesprocessingErrors
BatchId Long BatchId of ReceivingReceiptRequestslinesprocessingErrors
ErrorMessage String ErrorMessage of ReceivingReceiptRequestslinesprocessingErrors
ErrorMessageName String ErrorMessageName of ReceivingReceiptRequestslinesprocessingErrors
ErrorType String ErrorType of ReceivingReceiptRequestslinesprocessingErrors
ColumnName String ColumnName of ReceivingReceiptRequestslinesprocessingErrors
TableName String TableName of ReceivingReceiptRequestslinesprocessingErrors

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CustomerId Long CustomerId
CustomerPartyName String CustomerPartyName
DocumentNumber String DocumentNumber
ExternalSystemTransactionReference String ExternalSystemTransactionReference
FromDate Datetime FromDate
FromOrganizationCode String FromOrganizationCode
FromOrganizationId Long FromOrganizationId
GroupId Long GroupId
HeaderInterfaceId Long HeaderInterfaceId
ItemId Long ItemId
ItemNumber String ItemNumber
OrganizationCode String OrganizationCode
OrganizationId Long 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
VendorId Long VendorId
VendorName String VendorName
VendorNumber String VendorNumber
Finder String finder

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