JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ShippingCosts

ShippingCosts

Columns

Name Type Description
ShippingCostId [KEY] Long ShippingCostId of ShippingCosts
ShippingCostTypeId Long Value that uniquely identifies the type of shipping cost.
ShippingCostType String Name of the type of shipping cost.
ShippingCostTypeCategoryCode String ShippingCostTypeCategoryCode of ShippingCosts
ShippingCostTypeCategory String ShippingCostTypeCategory of ShippingCosts
Amount Double Amount for the shipping cost.
Currency String Abbreviation that identifies the currency for the amount of this shipping cost.
CurrencyName String Name of the currency for the amount of this shipping cost.
ConversionRateTypeCode String Abbreviation that identifies the type of currency conversion.
ConversionRateType String Type of currency conversion.
ConversionRate Double Conversion rate to use for the currency conversion.
ConversionDate Date Date when the currency was converted.
CreatedBy String CreatedBy of ShippingCosts
CreationDate Datetime CreationDate of ShippingCosts
LastUpdatedBy String LastUpdatedBy of ShippingCosts
LastUpdateDate Datetime LastUpdateDate of ShippingCosts
ShipmentLine Long Value that uniquely identifies the shipment line.
ShipmentId Long Value that uniquely identifies the shipment.
Shipment String Name of the material shipment.
PackingUnitId Long Value that uniquely identifies the packing unit.
PackingUnit String Number that identifies the packing unit.
SourceSystemId Long SourceSystemId of ShippingCosts
SourceSystem String SourceSystem of ShippingCosts
SourceOrder String SourceOrder of ShippingCosts
SourceOrderLine String SourceOrderLine of ShippingCosts
SourceOrderFulfillmentLine String SourceOrderFulfillmentLine of ShippingCosts
SourceOrderFulfillmentLineId Long SourceOrderFulfillmentLineId of ShippingCosts
OrganizationId Long OrganizationId of ShippingCosts
OrganizationCode String OrganizationCode of ShippingCosts
OrganizationName String OrganizationName of ShippingCosts

Pseudo-Columns

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

Name Type Description
Finder String finder

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