Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentTransactionRequestsshipmentsouterPackingUnitscosts

Tracks and manages cost details associated with outer packing units, enabling cost analysis and reporting for shipment processes.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long Unique identifier for the shipment transaction request related to outer packing unit costs.
ShipmentsDeliveryInterfaceId [KEY] Long Identifier for the interface managing shipment delivery within the transaction request.
OuterpackingunitsLPNInterfaceId [KEY] Long Unique identifier for the License Plate Number (LPN) associated with the outer packing unit.
FreightCostInterfaceId [KEY] Long Identifier for the freight cost entry associated with this outer packing unit.
ShippingCostType String Type of shipping cost assigned to the packing unit, such as handling fees or fuel surcharges.
Amount Decimal Monetary value of the shipping cost for each unit in the packing process.
Currency String Currency code representing the currency used for the shipping cost (for example, USD, EUR).
ConversionRate Decimal Exchange rate applied if the shipping cost needs currency conversion.
ConversionDate Date Date when the currency conversion was applied to the shipping cost.
ConversionRateTypeCode String Code representing the type of exchange rate applied (for example, Corporate, Spot, User-defined).
Subinventory String Name of the subinventory where the item is stored before shipment.
Locator String Detailed inventory locator that provides the source location for the shipped material.
CreatedBy String User or system that created the cost record for the outer packing unit.
CreationDate Datetime Timestamp indicating when the cost record was created.
LastUpdatedBy String User or system that last modified the cost record.
LastUpdateDate Datetime Timestamp indicating when the cost record was last updated.
Errors String Error messages related to processing shipping costs, if any.
DFF String Descriptive flexfield (DFF) capturing additional attributes for the cost record.
Carrier String Name of the carrier responsible for transporting the shipment.
ExternalSystemTransactionReference String Reference ID linking the transaction request to an external system.
Finder String Searchable reference field for locating specific shipment cost records.
FromActualShipDate Datetime Start date range for the actual shipment date associated with the cost record.
FromInitialShipDate Datetime Start date range for the originally planned shipment date.
Item String Item identifier or name related to the outer packing unit cost.
ModeOfTransportCode String Code representing the mode of transport for the shipment (for example, air, sea, land).
Order String Order number associated with the shipment.
PackingUnit String Unique identifier or name of the packing unit containing the shipment.
ServiceLevelCode String Code representing the level of service for the shipment (for example, express, standard).
ShipFromOrganizationCode String Code identifying the organization location from which the shipment originates.
Shipment String Unique identifier or name of the shipment.
ShipmentLine Long Line number corresponding to a specific item in the shipment.
SoldToCustomer String Customer to whom the shipment is sold.
ToActualShipDate Datetime End date range for the actual shipment date associated with the cost record.
ToInitialShipDate Datetime End date range for the originally planned shipment date.
TransactionId Long Unique transaction ID linking this cost record to the shipment transaction request.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175