SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

ShipmentTransactionRequestsshipmentscosts

Tracks shipping cost details for shipments associated with transaction requests.

Columns

Name Type SupportedFinders Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the transaction request associated with shipment costs.
ShipmentsDeliveryInterfaceId [KEY] Long Unique identifier for the delivery interface linked to the shipment transaction costs.
FreightCostInterfaceId [KEY] Long Unique identifier for the freight cost associated with the shipment transaction.
ShippingCostType String Type of shipping cost, as predefined in the application.
Amount Decimal Total amount charged for the shipping cost per unit.
Currency String Currency in which the shipping cost is denominated.
ConversionRate Decimal Conversion rate used if the shipping cost is in a different currency.
ConversionDate Date Date when the currency conversion was applied.
ConversionRateTypeCode String Code identifying the type of currency conversion applied.
Subinventory String Subinventory from which the item is sourced for shipment fulfillment.
Locator String Full name of the inventory locator used as the source for the shipped material.
CreatedBy String User who created the shipment cost record.
CreationDate Datetime Date and time when the shipment cost record was created.
LastUpdatedBy String User who last updated the shipment cost record.
LastUpdateDate Datetime Date and time when the shipment cost record was last updated.
Carrier String FindByAttributes Carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String FindByAttributes Reference ID for the corresponding transaction in an external system.
Finder String Identifier used to locate or retrieve shipment cost transaction requests.
FromActualShipDate Datetime FindByAttributes Start date range for actual shipment departure.
FromInitialShipDate Datetime FindByAttributes Start date range for initially planned shipment departure.
Item String FindByAttributes Item associated with the shipment transaction cost.
ModeOfTransportCode String FindByAttributes Code representing the mode of transport for shipment.
Order String FindByAttributes Order number linked to the shipment transaction cost.
PackingUnit String FindByAttributes Packing unit associated with the shipment transaction cost.
ServiceLevelCode String FindByAttributes Code representing the service level for the shipping method.
ShipFromOrganizationCode String FindByAttributes Code representing the ship-from organization.
Shipment String FindByAttributes Name of the shipment associated with the transaction.
ShipmentLine Long FindByAttributes Line item number within the shipment transaction request.
SoldToCustomer String FindByAttributes Customer to whom the shipment is sold.
ToActualShipDate Datetime FindByAttributes End date range for actual shipment departure.
ToInitialShipDate Datetime FindByAttributes End date range for initially planned shipment departure.
TransactionId Long PrimaryKey Unique identifier of the shipment transaction request.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770