JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ShipmentLineTransactionRequestsshipmentLinesDFF

ShipmentLineTransactionRequestsshipmentLinesDFF

Columns

Name Type Description
ShipmentLineTransactionRequestsTransactionId [KEY] Long ShipmentLineTransactionRequestsTransactionId of ShipmentLineTransactionRequestsshipmentLinesDFF
ShipmentlinesDeliveryDetailInterfaceId [KEY] Long ShipmentlinesDeliveryDetailInterfaceId of ShipmentLineTransactionRequestsshipmentLinesDFF
DeliveryDetailInterfaceId [KEY] Long Value that uniquely identifies the shipment line.
_FLEX_Context String Descriptive flexfield context name for shipment lines.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for shipment lines.

Pseudo-Columns

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

Name Type Description
BaseItem String BaseItem
BaseItemId Long BaseItemId
Carrier String Carrier
CarrierId Long CarrierId
CarrierNumber String CarrierNumber
EndAssemblyItem String EndAssemblyItem
FromRequestedDate Datetime FromRequestedDate
FromScheduledShipDate Datetime FromScheduledShipDate
InitialDestinationId Long InitialDestinationId
Item String Item
ItemId Long ItemId
ModeOfTransportCode String ModeOfTransportCode
OrderTypeCode String OrderTypeCode
OrganizationCode String OrganizationCode
OrganizationId Long OrganizationId
OrganizationName String OrganizationName
ServiceLevelCode String ServiceLevelCode
ToRequestedDate Datetime ToRequestedDate
ToScheduledShipDate Datetime ToScheduledShipDate
TransactionId Long TransactionId
TransportationShipment String TransportationShipment
Finder String finder

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