JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

B2bTradingPartnersdeliveryMethods

B2bTradingPartnersdeliveryMethods

Columns

Name Type Description
B2bTradingPartnersTradingPartnerId [KEY] Long B2bTradingPartnersTradingPartnerId of B2bTradingPartnersdeliveryMethods
DeliveryMethodId [KEY] Long Value that uniquely identifies the delivery method. It is a primary key that the application generates when it creates a delivery method record. This attribute is required.
DeliveryMethodName String Name of the delivery method. This attribute is required.
DeliveryMethodType String Value that identifies the type of delivery method. Valid values include One-Way Web Service or Request-Response Web Service.
Service String Value that identifies the external service of the delivery method.
B2bRoutingFlag Bool Contains one of the following values: true or false. If true, then the messages to the service provider are routed through the internal B2B gateway. If false, then the messages to the service provider are not routed through the internal B2B gateway. The default value is false.
SecurityPolicy String Value that indicates the security policy used with the delivery method.
UcmExportDocumentAccount String Value that specifies the location from where files are picked for outbound process.
RecipientEmailId String Value that uniquely identifies the email to which the outbound message is sent.
AttachXmlFlag Bool Contains one of the following values: true or false. If true, then the transformed payload is sent along with the email as attachment. If false, then the transformed payload is not sent along with the email as attachment. The default value is false.
ServiceUri String Value that specifies the service endpoint stored in topology manager.
CsfkeyUser String Value that stores the username in the credential store.
CsfkeyPassword String Value that stores the password in the credential store.
ServiceMeaning String Value that specifies the meaning of the service.
CreationDate Datetime Date when the user created the delivery method that the trading partner uses to send outbound messages.
LastUpdateDate Datetime Date when the user most recently updated the delivery method that the trading partner uses to send outbound messages.
FileName String Value that identifies the file that is being delivered using SFTP.
RemoteDir String Value that identifies the directory where outbound messages are delivered using SFTP.
SftpHost String Value that identifies the host name for outbound message delivery using SFTP.
SftpPort String Value that identifies the port for outbound message delivery using SFTP.

Pseudo-Columns

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

Name Type Description
TradingPartnerId Long TradingPartnerId
BindServiceProviderId Long bindServiceProviderId
Finder String finder

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