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. |