Shipments
Provides comprehensive details about shipments, enabling searches by multiple attributes and integration with external systems for tracking, packing, costs, and compliance.
Columns
Name | Type | Description |
Shipment | String | Unique identifier for the shipment, used to track and reference the shipment in the system. |
DeliveryId [KEY] | Long | Identifier for the delivery associated with the shipment. This is used to link the shipment to its delivery record. |
ShipmentDescription | String | A text description providing more context or details about the shipment. |
InitialPickupDate | Date | The date on which the shipment is initially scheduled to be picked up from the origin. |
InitialPickupDateTime | Datetime | The exact date and time the shipment is scheduled for pickup. This is used for precise scheduling. |
BillOfLading | String | A document that serves as a receipt for goods being shipped and is used to track the shipment. |
GrossWeight | Decimal | The total weight of the shipment, including the packaging materials, in the unit of measure (UOM) defined by the weight unit. |
NetWeight | Decimal | The weight of the actual goods in the shipment, excluding packaging materials. |
TareWeight | Decimal | The weight of the packaging materials used in the shipment. |
WeightUOMCode | String | The unit of measure (UOM) code representing how weight is measured for the shipment (for example, KG, LB). |
WeightUOM | String | The UOM for weight used in the shipment (for example, Kilogram, Pound). |
EquipmentTypeId | Long | Identifier for the type of equipment used in the shipment, such as a truck, container, or pallet. |
EquipmentType | String | Describes the type of equipment used to transport the shipment (for example, Flatbed, Container, Pallet). |
Equipment | String | Description of the specific equipment used for the shipment, providing more details than the equipment type. |
SealNumber | String | A unique number assigned to the seal that secures the shipment, often used for security and verification purposes. |
Volume | Decimal | The total volume of the shipment, including packaging. This measurement helps determine the storage space required. |
VolumeUOMCode | String | The UOM code for the volume of the shipment (for example, Cubic meters, Liters). |
VolumeUOM | String | The UOM for the volume used in the shipment (for example, Cubic Meter, Liter). |
CarrierId | Long | Unique identifier for the carrier handling the shipment, used to link to the carrier's details. |
Carrier | String | Name of the carrier responsible for transporting the shipment (for example, FedEx, UPS, DHL). |
CarrierNumber | String | Carrier number associated with the shipment. This is used to uniquely identify the carrier's shipment. |
ModeOfTransportCode | String | Code representing the mode of transport for the shipment (for example, Sea, Air, Road). This helps categorize the transport method. |
ModeOfTransport | String | Descriptive term for the mode of transport used in the shipment (for example, Air, Sea, Truck). |
ServiceLevelCode | String | Code representing the level of service chosen for the shipment (for example, Standard, Express, Overnight). |
ServiceLevel | String | Description of the service level for the shipment, outlining how quickly or securely the shipment will be delivered. |
ShippingMethodCode | String | Code representing the method used to ship the goods (for example, Ground, Air Freight, Express). |
ShippingMethod | String | Descriptive term for the shipping method used for the shipment (for example, Ground, Air Freight, Sea Freight). |
Waybill | String | Waybill number associated with the shipment. This is a reference number for the shipment's travel. |
PackingSlipNumber | String | Number associated with the packing slip, which provides details about the items included in the shipment. |
ActualShipDate | Date | The date the shipment was actually dispatched from the warehouse or origin. |
ActualShipDateTime | Datetime | The exact date and time when the shipment was actually dispatched, providing precise information on the shipping time. |
UltimateDropoffDate | Date | The final date on which the shipment is scheduled to be delivered to the recipient or destination. |
UltimateDropoffDateTime | Datetime | The final date and time on which the shipment is scheduled to be delivered. |
FreightTermsCode | String | Code representing the freight payment terms for the shipment (for example, Prepaid, Collect). |
FreightTerms | String | Description of the freight terms, detailing who is responsible for the payment of shipping charges. |
FOBCode | String | Code representing the Free on Board (FOB) status of the shipment, indicating the point at which responsibility for the shipment transfers. |
FOB | String | Descriptive term for the Free on Board (FOB) status, showing whether the responsibility for the shipment lies with the buyer or the seller. |
FOBSiteId | Long | Unique identifier for the site where the shipment's Free on Board (FOB) point is located. |
FOBSiteNumber | String | FOB site number, used to identify the specific location of the shipment's Free on Board (FOB) point. |
FOBLocationId | Long | Identifier for the specific location from which the shipment's Free on Board (FOB) is measured. |
FOBAddress1 | String | First address line for the Free on Board (FOB) site. |
FOBAddress2 | String | Second address line for the Free on Board (FOB) site. |
FOBAddress3 | String | Third address line for the Free on Board (FOB) site. |
FOBAddress4 | String | Fourth address line for the Free on Board (FOB) site. |
FOBCity | String | City of the Free on Board (FOB) site. |
FOBCounty | String | County of the Free on Board (FOB) site. |
FOBPostalCode | String | Postal code of the Free on Board (FOB) site. |
FOBRegion | String | Region of the Free on Board (FOB) site. |
FOBState | String | State of the Free on Board (FOB) site. |
FOBCountry | String | Country of the Free on Board (FOB) site. |
DockCode | String | Code identifying the dock location where the shipment is loaded for transport. |
CODAmount | Decimal | Amount to be collected on delivery (COD) for the shipment. This is paid by the recipient. |
CODPaidBy | String | Name of the person or entity responsible for paying the COD amount. |
CODCurrencyCode | String | Currency code for the COD amount (for example, USD, EUR). |
CODRemitTo | String | Address or entity to which the COD amount should be remitted. |
ASNDateSent | Date | Date when the Advanced Shipment Notice (ASN) was sent to the receiving party. |
ASNDateTimeSent | Datetime | Exact date and time when the Advanced Shipment Notice (ASN) was sent. |
ConfirmedDate | Date | Date when the shipment was confirmed by the responsible party. |
ConfirmedDateTime | Datetime | Exact date and time when the shipment was confirmed. |
ConfirmedBy | String | Name of the person or system that confirmed the shipment. |
LoadingSequenceRule | Decimal | Loading sequence rule for determining the order in which goods are loaded for shipment. |
LoadingOrderRuleCode | String | Code for the loading order rule, which specifies how shipment items should be arranged in the transport vehicle. |
LoadingOrderRule | String | Descriptive term for the rule used to determine the loading order of shipment items. |
ProblemContactReference | String | Reference number or identifier for the contact person handling any problems related to the shipment. |
OrganizationId | Long | Identifier for the organization handling the shipment. |
OrganizationCode | String | Code representing the organization responsible for shipping. |
OrganizationName | String | Name of the organization managing the shipment. |
RcvShipmentNumber | String | Reference number for the received shipment, linking it to the receiving process. |
RcvShipmentHeaderId | Long | Unique identifier for the header of the received shipment. |
ShipmentStatusCode | String | Code representing the current status of the shipment (for example, In Transit, Delivered). |
ShipmentStatus | String | Descriptive term representing the current status of the shipment. |
CreatedBy | String | Name of the person or system that created the shipment record. |
CreationDate | Datetime | Date and time when the shipment record was created. |
LastUpdatedBy | String | Name of the person or system that last updated the shipment record. |
LastUpdateDate | Datetime | Date and time when the shipment record was last updated. |
SourceSystemId | Long | Identifier for the source system from which the shipment data originated. |
SourceSystem | String | Name of the source system from which the shipment record was generated. |
ShipFromLocationId | Long | Location identifier for the source from which the goods are shipped. |
ShipFromAddress1 | String | First address line for the ship-from location. |
ShipFromAddress2 | String | Second address line for the ship-from location. |
ShipFromAddress3 | String | Third address line for the ship-from location. |
ShipFromAddress4 | String | Fourth address line for the ship-from location. |
ShipFromCity | String | City of the ship-from location. |
ShipFromCounty | String | County of the ship-from location. |
ShipFromPostalCode | String | Postal code of the ship-from location. |
ShipFromRegion | String | Region of the ship-from location. |
ShipFromState | String | State of the ship-from location. |
ShipFromCountry | String | Country of the ship-from location. |
ShipToLocationId | Long | Location identifier for the destination to which the shipment is being sent. |
ShipToAddress1 | String | First address line for the ship-to location. |
ShipToAddress2 | String | Second address line for the ship-to location. |
ShipToAddress3 | String | Third address line for the ship-to location. |
ShipToAddress4 | String | Fourth address line for the ship-to location. |
ShipToCity | String | City of the ship-to location. |
ShipToCounty | String | County of the ship-to location. |
ShipToPostalCode | String | Postal code of the ship-to location. |
ShipToRegion | String | Region of the ship-to location. |
ShipToState | String | State of the ship-to location. |
ShipToCountry | String | Country of the ship-to location. |
TransportationReasonCode | String | Code indicating the reason for transporting the shipment (for example, Export, Domestic). |
TransportationReason | String | Descriptive term for the reason the shipment is being transported. |
PortOfLoading | String | Port where the shipment is loaded before transportation begins. |
PortOfDischarge | String | Port where the shipment is unloaded upon arrival. |
NumberOfOuterPackingUnits | Decimal | The total number of outer packing units in the shipment. |
EarliestPickupDate | Datetime | The earliest possible date when the shipment can be picked up from the origin. |
LatestPickupDate | Datetime | The latest possible date when the shipment can be picked up from the origin. |
EarliestDropoffDate | Datetime | The earliest possible date when the shipment can be delivered to the destination. |
LatestDropoffDate | Datetime | The latest possible date when the shipment can be delivered to the destination. |
ShipToPartyId | Long | Unique identifier for the party receiving the shipment. |
ShipToCustomer | String | Name of the customer receiving the shipment. |
ShipToCustomerNumber | String | Customer number used to identify the party receiving the shipment. |
ShipToPartySiteId | Long | Unique identifier for the party site receiving the shipment. |
ShipToPartySiteNumber | String | Site number for the party receiving the shipment. |
SoldToPartyId | Long | Unique identifier for the party that purchased the shipment. |
SoldToCustomer | String | Name of the customer who purchased the shipment. |
SoldToCustomerNumber | String | Customer number for the party that purchased the shipment. |
Supplier | String | Name of the supplier providing the goods in the shipment. |
SupplierPartyNumber | String | Supplier party number associated with the shipment. |
LogisticsServiceProviderCustomerId | Long | Unique identifier for the logistics service provider customer. |
LogisticsServiceProviderCustomer | String | Name of the logistics service provider customer. |
LogisticsServiceProviderCustomerNumber | String | Logistics service provider customer number. |
TransportationShipment | String | Reference to the transportation shipment. |
DistributedOrganizationFlag | Bool | Flag indicating if the shipment is associated with a distributed organization. |
CommercialInvoice | String | Commercial invoice number associated with the shipment. |
PlannedFlag | Bool | Flag indicating whether the shipment is planned. |
AutomaticallyPackFlag | Bool | Flag indicating whether the shipment is automatically packed. |
EnableAutoshipFlag | Bool | Flag indicating if the shipment is enabled for auto-shipping. |
TransportationShipmentFromEvent | String | Reference to the event that triggered the transportation shipment. |
TransportationShipmentCompleteFromEvent | String | Reference to the event that marks the transportation shipment as complete. |
TradeComplianceScreenedFromEvent | String | Reference to the trade compliance screening event for the shipment. |
ExternalSystemTransactionReference | String | External system reference for tracking the transaction. |
BaseItem | String | Base item associated with the shipment. |
EndAssemblyItemNumber | String | End assembly item number for the shipment. |
Finder | String | Search field used to locate the shipment record. |
IntegrationStatus | String | Status indicating the integration state of the shipment record. |
Item | String | Item associated with the shipment. |
LineStatus | String | Status of the shipment line (for example, Open, Closed). |
OrderNumber | String | Order number associated with the shipment. |
OrderType | String | Type of order associated with the shipment. |
OrderTypeCode | String | Order type code for the shipment. |
ParentPackingUnit | String | Packing unit from which the shipment items are packed. |
PickWave | String | Pick wave associated with the shipment. |
QuickShipStatus | String | Status of the quick shipping process for the shipment. |
RcvShipmentLineId | Long | Received shipment line identifier for tracking purposes. |
ShipmentSet | String | Shipment set identifier for the shipment. |
SourceOrder | String | Source order associated with the shipment. |
SourceOrderFulfillmentLine | String | Source order fulfillment line for the shipment. |
SourceOrderFulfillmentLineId | String | Identifier for the source order fulfillment line. |
SourceOrderLine | String | Source order line for the shipment. |
TradeComplianceStatus | String | Status indicating the trade compliance status of the shipment. |
TransportationPlanningStatus | String | Transportation planning status for the shipment. |