JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials

ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials

Columns

Name Type Description
ShipmentsDeliveryId [KEY] Long ShipmentsDeliveryId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
OuterpackingunitsLPNId [KEY] Long OuterpackingunitsLPNId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
ShipmentlinesShipmentLine [KEY] Long ShipmentlinesShipmentLine of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
FromSerialNumber [KEY] String FromSerialNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
ToSerialNumber String ToSerialNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
UniqueLineNumber [KEY] Long UniqueLineNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
TransactionTempId Double TransactionTempId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
DeliveryDetailId Double DeliveryDetailId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
SupplierSerialNumber String SupplierSerialNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
AttributeDFF String attributeDFF
StandardDFF String standardDFF
SerialNumbers String serialNumbers

Pseudo-Columns

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

Name Type Description
BaseItem String BaseItem
DeliveryId Long DeliveryId
EndAssemblyItemNumber String EndAssemblyItemNumber
IntegrationStatus String IntegrationStatus
Item String Item
LineStatus String LineStatus
OrderNumber String OrderNumber
OrderType String OrderType
OrderTypeCode String OrderTypeCode
ParentPackingUnit String ParentPackingUnit
PickWave String PickWave
QuickShipStatus String QuickShipStatus
RcvShipmentLineId Long RcvShipmentLineId
ShipToCustomer String ShipToCustomer
ShipToPartyId String ShipToPartyId
Shipment String Shipment
ShipmentSet String ShipmentSet
SourceOrder String SourceOrder
SourceOrderFulfillmentLine String SourceOrderFulfillmentLine
SourceOrderFulfillmentLineId String SourceOrderFulfillmentLineId
SourceOrderLine String SourceOrderLine
SourceSystemId String SourceSystemId
TradeComplianceStatus String TradeComplianceStatus
TransportationPlanningStatus String TransportationPlanningStatus
Finder String finder

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