ShipmentsshippingCosts
Tracks detailed cost data for shipments, supporting financial reporting and logistics cost analysis.
Columns
Name | Type | Description |
ShipmentsDeliveryId [KEY] | Long | Unique identifier for the delivery associated with the shipment. |
FreightCostId [KEY] | Long | Unique identifier for the freight cost associated with the shipment. |
DeliveryDetailId | Long | Identifier for the specific delivery detail related to the shipment. |
LPNId | Long | License Plate Number (LPN) identifier for the shipment. |
PackingUnit | String | The packing unit used for shipment handling. |
ShippingCostTypeId | Long | Identifier for the type of shipping cost applied to the shipment. |
ShippingCost | String | Total shipping cost incurred for the shipment line. |
ShippingCostTypeCategoryCode | String | System-generated code for the category of shipping cost. |
ShippingCostTypeCategory | String | Category of the shipping cost, such as freight or handling. |
Amount | Decimal | The monetary amount associated with the shipping cost. |
CurrencyCode | String | Code representing the currency used for the shipping cost. |
CurrencyName | String | Full name of the currency used for the shipping cost. |
ConversionRateTypeCode | String | Code representing the type of currency conversion rate used. |
ConversionRateType | String | Type of currency conversion rate applied to the transaction. |
ConversionRate | Decimal | Exchange rate applied to convert currency values. |
ConversionDate | Date | Date when the currency conversion was applied. |
CreatedBy | String | User or process that created the shipping cost record. |
CreationDate | Datetime | Date and time when the shipping cost record was created. |
LastUpdatedBy | String | User or process that last updated the shipping cost record. |
LastUpdateDate | Datetime | Date and time when the shipping cost record was last updated. |
BaseItem | String | Primary item associated with the shipment. |
DeliveryId | Long | Identifier for the delivery linked to the shipment. |
EndAssemblyItemNumber | String | Final assembled item number for the shipped product. |
Finder | String | Internal reference or tracking identifier for the shipment. |
IntegrationStatus | String | Current integration status of the shipment within external systems. |
Item | String | Item being shipped, identified by its unique product number. |
LineStatus | String | Current processing status of the shipment line. |
OrderNumber | String | Customer or internal order number linked to the shipment. |
OrderType | String | Type of order associated with the shipment, such as sales or transfer orders. |
OrderTypeCode | String | System-generated code representing the type of order. |
ParentPackingUnit | String | Parent packing unit containing this shipment line. |
PickWave | String | Identifier for the picking wave in which this shipment was processed. |
QuickShipStatus | String | Status indicator for expedited shipping processing. |
RcvShipmentLineId | Long | Receiving shipment line identifier for inbound processing. |
Shipment | String | Reference identifier for the entire shipment. |
ShipmentSet | String | Grouping of shipments processed together as a set. |
ShipToCustomer | String | Name or identifier of the customer receiving the shipment. |
ShipToPartyId | String | Unique identifier for the party designated as the shipment recipient. |
SourceOrder | String | Originating order that generated this shipment. |
SourceOrderFulfillmentLine | String | Fulfillment line reference from the source order. |
SourceOrderFulfillmentLineId | String | Unique identifier for the source order's fulfillment line. |
SourceOrderLine | String | Reference to the specific order line in the source order. |
SourceSystemId | String | Identifier for the source system that created this shipment record. |
TradeComplianceStatus | String | Indicates whether the shipment complies with trade regulations. |
TransportationPlanningStatus | String | Current transportation planning status for the shipment. |