JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

CarriersshippingMethods

CarriersshippingMethods

Columns

Name Type Description
CarriersCarrierId [KEY] Long CarriersCarrierId of CarriersshippingMethods
OrganizationCarrierServiceId [KEY] Long OrganizationCarrierServiceId of CarriersshippingMethods
ShipMethodCode String ShipMethodCode of CarriersshippingMethods
ServiceLevelCode String The value that indicates the priority of transportation that affects how quickly goods are transported. Valid values include Next day, Overnight, Express, or Door to Door. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Carriers Lookups task.
ServiceLevel String ServiceLevel of CarriersshippingMethods
ModeOfTransportCode String The value that indicates the means used to deliver shipments to the customer. Valid values include Rail, Air, or Road. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Carriers Lookups task.
ModeOfTransport String ModeOfTransport of CarriersshippingMethods
ActiveFlag Bool Contains one of the following values: true or false. If true, then the shipping method is active. If false, then the shipping method is not active. The default value is true.
CreatedBy String CreatedBy of CarriersshippingMethods
CreationDate Datetime CreationDate of CarriersshippingMethods
LastUpdateDate Datetime LastUpdateDate of CarriersshippingMethods
LastUpdatedBy String LastUpdatedBy of CarriersshippingMethods

Pseudo-Columns

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

Name Type Description
CarrierId Long CarrierId
CarrierName String CarrierName
ManifestingEnabledFlag String ManifestingEnabledFlag
Finder String finder

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