SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

ShipmentTransactionRequestsshipmentscosts

The Costs for Shipments resource manages details about the shipping costs for shipments.

Columns

Name Type Description
ShipmentTransactionRequestsTransactionId [KEY] Long ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentscosts
ShipmentsDeliveryInterfaceId [KEY] Long ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentscosts
FreightCostInterfaceId [KEY] Long FreightCostInterfaceId of ShipmentTransactionRequestsshipmentscosts
ShippingCostType String Type of cost that is predefined in the application.
Amount Decimal Amount for the shipping cost for each unit.
Currency String Abbreviation that identifies the currency of the shipping cost.
ConversionRate Decimal Rate of the currency conversion.
ConversionDate Date Date when the currency conversion occurred.
ConversionRateTypeCode String Abbreviation that identifies the type of currency conversion.
Subinventory String Subinventory to use when fulfilling the item to be shipped.
Locator String Concatenated name of the inventory locator that provides the source for material that ships.
CreatedBy String CreatedBy of ShipmentTransactionRequestsshipmentscosts
CreationDate Datetime CreationDate of ShipmentTransactionRequestsshipmentscosts
LastUpdatedBy String LastUpdatedBy of ShipmentTransactionRequestsshipmentscosts
LastUpdateDate Datetime LastUpdateDate of ShipmentTransactionRequestsshipmentscosts
Carrier String Carrier of ShipmentTransactionRequestsshipmentscosts
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ShipmentTransactionRequestsshipmentscosts
Finder String Finder of ShipmentTransactionRequestsshipmentscosts
FromActualShipDate Datetime FromActualShipDate of ShipmentTransactionRequestsshipmentscosts
FromInitialShipDate Datetime FromInitialShipDate of ShipmentTransactionRequestsshipmentscosts
Item String Item of ShipmentTransactionRequestsshipmentscosts
ModeOfTransportCode String ModeOfTransportCode of ShipmentTransactionRequestsshipmentscosts
Order String Order of ShipmentTransactionRequestsshipmentscosts
PackingUnit String PackingUnit of ShipmentTransactionRequestsshipmentscosts
ServiceLevelCode String ServiceLevelCode of ShipmentTransactionRequestsshipmentscosts
ShipFromOrganizationCode String ShipFromOrganizationCode of ShipmentTransactionRequestsshipmentscosts
Shipment String Shipment of ShipmentTransactionRequestsshipmentscosts
ShipmentLine Long ShipmentLine of ShipmentTransactionRequestsshipmentscosts
SoldToCustomer String SoldToCustomer of ShipmentTransactionRequestsshipmentscosts
ToActualShipDate Datetime ToActualShipDate of ShipmentTransactionRequestsshipmentscosts
ToInitialShipDate Datetime ToInitialShipDate of ShipmentTransactionRequestsshipmentscosts
TransactionId Long TransactionId of ShipmentTransactionRequestsshipmentscosts

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