InboundShipmentsshipmentLines
Tracks shipment line details, linking them to their respective headers for comprehensive management.
Columns
| Name | Type | Description |
| InboundShipmentsShipmentHeaderId [KEY] | Long | The unique identifier linking this shipment line to the corresponding shipment header. This identifier ensures accurate tracking of all items within a single inbound shipment. |
| ShipmentLineId [KEY] | Long | The unique identifier assigned to each individual shipment line. This identifier allows for detailed tracking of items within the shipment. |
| ShipmentHeaderId | Long | A system-generated identifier grouping multiple shipment lines under a single inbound shipment record. This identifier ensures a structured receiving process. |
| LineNumber | Long | The sequence number assigned to the shipment line. This sequence number determines the order in which items are processed within the shipment. |
| CreatedBy | String | The username or system identifier of the individual or process that created the shipment line record, ensuring accountability and auditability. |
| CreationDate | Datetime | The date and time when the shipment line was created. This information is used for tracking inventory receipt timelines and processing efficiency. |
| LastUpdateDate | Datetime | The date and time when the shipment line was last modified. This information ensures visibility into updates such as quantity adjustments or status changes. |
| LastUpdatedBy | String | The username or system identifier of the individual or process that made the last update to the shipment line record. This identifier allows for audit tracking. |
| QuantityShipped | Decimal | The total quantity of items that were shipped for this specific shipment line, recorded at the point of departure from the supplier or warehouse. |
| QuantityReceived | Decimal | The total quantity of items that have been received for this shipment line, helping to track discrepancies between shipped and received quantities. |
| QuantityAccepted | Decimal | The quantity of items from the shipment line that passed quality inspection and were accepted into inventory. |
| QuantityRejected | Decimal | The quantity of items from the shipment line that failed quality checks and were rejected upon receipt. |
| QuantityReturned | Decimal | The total quantity of items that were returned to the supplier due to damage, defects, or other issues. |
| UOMCode | String | The unit of measure (UOM) code that defines how the item quantity is measured, such as 'EA' (Each), 'KG' (Kilogram), or 'L' (Liter). |
| UnitOfMeasure | String | The description of the UOM used for the shipment line. This description ensures clarity in inventory records and transactions. |
| ItemId | Long | The unique identifier assigned to the item in the shipment line. This identifier links it to inventory and procurement records. |
| ItemNumber | String | The item number or SKU (Stock Keeping Unit) that uniquely identifies the product within the shipment. |
| ItemDescription | String | A detailed description of the item in the shipment. This description provides clarity on product specifications. |
| ItemRevision | String | The revision or version of the item. This information ensures that the correct design or specification is received and recorded in inventory. |
| OrganizationId | Long | The unique identifier for the organization that is receiving the shipment. This identifier ensures proper categorization within business operations. |
| OrganizationCode | String | A short code representing the organization where the shipment is being received. This code aligns with inventory and procurement systems. |
| SourceDocumentCode | String | The code identifying the originating document for the shipment, such as a purchase order (PO), transfer order (TO), or other procurement records. |
| POHeaderId | Long | The unique identifier linking this shipment line to the corresponding purchase order (PO) header. This identifier ensures traceability between ordered and received items. |
| POLineId | Long | The unique identifier for the specific line item in the purchase order associated with this shipment line. |
| POLineLocationId | Long | The unique identifier for the location within the purchase order where this shipment line is designated for delivery. |
| PONumber | String | The purchase order (PO) number associated with this shipment line. This PO number is used for tracking procurement transactions and matching invoices. |
| POLineNumber | Decimal | The specific line number on the purchase order that corresponds to this shipment line. This line number ensures proper alignment with procurement records. |
| POScheduleNumber | Decimal | The schedule number associated with the purchase order line. This schedule number indicates delivery timelines and commitments. |
| DestinationTypeCode | String | A code representing the type of destination where the shipment line is to be delivered, such as inventory, expense, or a work order. |
| DestinationType | String | A description of the destination type for the shipment line. This description clarifies whether the goods are intended for warehouse stock, direct consumption, or another use. |
| ShipmentLineStatusCode | String | A system-generated code indicating the current status of the shipment line, such as 'In Transit', 'Received', or 'Rejected'. |
| ShipmentLineStatus | String | A human-readable description of the current status of the shipment line. This description providesclarity on whether the goods have been received, accepted, or require further action. |
| SecondaryQuantityShipped | Decimal | The quantity shipped in an alternate UOM. This quantity is used when tracking inventory in dual units, such as cases and individual units. |
| SecondaryQuantityReceived | Decimal | The quantity received in an alternate UOM, ensuring that dual-unit tracking is accurate across inventory and procurement records. |
| SecondaryUOMCode | String | The UOM code for the secondary UOM associated with the item in this shipment line. This code enables dual-unit tracking for inventory. |
| SecondaryUOM | String | The description of the secondary UOM (UOM) used for tracking the item. This description ensures accurate conversions between primary and secondary units. |
| ASNLPNId | Long | The unique identifier linking this shipment line to an Advanced Shipment Notice (ASN) License Plate Number (LPN). This identifier is used for tracking containerized shipments. |
| SourcePackingUnit | String | The original packaging unit for the item in this shipment line. This information specifies whether the shipment was packed in cases, pallets, or other units. |
| TransferOrderHeaderId | Long | The unique identifier for the transfer order associated with this shipment line. This identifier ensures traceability of inter-organization or inter-location inventory transfers. |
| TransferOrderLineId | Long | The unique identifier for the specific line item within the transfer order. This identifier links the shipment line to the corresponding inventory transfer transaction. |
| TransferOrderNumber | String | The transfer order number associated with this shipment line. This number provides a reference for tracking inventory movements between locations or business entities. |
| TransferOrderLineNumber | Int | The sequence number of the transfer order line. This sequence number specifies the order in which items were processed for shipment and received. |
| ConsignmentLine | String | Indicates whether this shipment line is part of a consignment inventory agreement, where the supplier retains ownership of the goods until they are used or sold. |
| InventoryShipmentTransactionId | Long | The unique identifier for the inventory shipment transaction associated with this shipment line. This identifier ensures accurate tracking of goods movement within inventory records. |
| OriginalTOInvShipTransactionId | Long | A reference to the original transfer order inventory shipment transaction identifier. This reference is used for tracking related inventory movements and adjustments. |
| PackingSlip | String | The packing slip number for the shipment line, listing the contents, item details, and quantities shipped. |
| CountryOfOriginCode | String | A standardized country code representing the country of origin for the item in this shipment line. This country code ensures compliance with trade regulations. |
| CountryOfOrigin | String | The full name of the country where the item in this shipment line was manufactured or sourced, used for customs and regulatory compliance. |
| Subinventory | String | The specific subinventory location where the item will be received or stored. This location ensures proper inventory allocation within the warehouse. |
| LocatorId | Long | The unique identifier for the inventory locator within the warehouse. This identifier specifies the exact storage bin or shelf location for the received goods. |
| Locator | String | A human-readable name or code for the storage location where the item will be placed. This information facilitates warehouse organization and retrieval. |
| ContainerNumber | String | The unique identifier or tracking number for the container in which this shipment line was packed. This identifier aids in logistics and shipment tracking. |
| TruckNumber | String | The unique identifier or license plate number of the truck transporting the shipment. This identifier is used for tracking inbound freight. |
| BarCodeLabel | String | The barcode label associated with this shipment line. This label facilitates scanning and tracking during receiving and inventory processing. |
| Comments | String | Additional notes or remarks regarding the shipment line, such as special instructions, issues encountered, or other relevant details. |
| ReasonId | Long | The unique identifier for the reason associated with any adjustments, rejections, or special handling of this shipment line. |
| Reason | String | A description of the reason for adjustments, rejections, or special handling, ensuring transparency in inventory transactions. |
| RoutingHeaderId | Long | The unique identifier linking this shipment line to a specific routing process. This identifier defines how the shipment is processed upon receipt. |
| Routing | String | The routing method or process applied to this shipment line. This field determines how the goods are directed within the warehouse or supply chain. |
| TransferCost | Decimal | The total cost incurred for transferring this item within the organization. This cost includes handling and processing fees. |
| TransportationCost | Decimal | The total cost associated with transporting this shipment line. This cost includes freight charges, fuel costs, and carrier fees. |
| InterfaceTransactionId | Long | The unique identifier for the interface transaction used to integrate shipment data with external or enterprise resource planning (ERP) systems. |
| BackToBackOrder | String | Indicates whether this shipment line is part of a back-to-back order, where inventory is sourced from a supplier specifically to fulfill a sales order. |
| FromOrganizationId | Long | The unique identifier for the organization or warehouse from which the shipment originated. This identifier ensures accurate inventory transfer records. |
| FromOrganizationCode | String | The code representing the organization or warehouse that shipped the inventory. This code ensures proper tracking of inventory movements. |
| IntegrationStatus | String | The status of the shipment line's integration with enterprise systems. This status indicates whether data synchronization is successful or pending. |
| LotsCount | Long | The total number of lot-controlled units associated with this shipment line. This field ensures proper tracking of batch-managed inventory. |
| SerialsCount | Long | The total number of serialized items in this shipment line. This field ensures precise tracking of individually identifiable inventory units. |
| PrimaryUOMCode | String | The UOM code used for the primary quantity of the item in this shipment line. This code ensures standardization in inventory tracking and transactions. |
| PrimaryUnitOfMeasure | String | The full description of the primary UOM for the item. This description specifies how the inventory is counted (for example, 'Each,' 'Kilogram,' or 'Liter') |
| PrimaryQuantity | Decimal | The total quantity of the item received in its primary UOM. This field ensures consistency in stock management and order fulfillment. |
| SupplierItemNumber | String | The item number assigned by the supplier. This item number is used to match the shipment line item with supplier-provided documentation and procurement records. |
| HazardClassId | Long | The unique identifier linking the shipment line item to its designated hazard classification, ensuring compliance with hazardous materials regulations. |
| HazardClass | String | The hazard class assigned to the item. This classifiction indicates whether it contains dangerous goods requiring special handling (for example, 'Flammable', 'Corrosive', or 'Toxic Substances'). |
| UNNumberId | Long | The unique identifier for the United Nations (UN) number assigned to hazardous materials. This identifier is used for global classification and transportation compliance. |
| UNNumber | String | The official United Nations (UN) number associated with the hazardous material in this shipment line, ensuring compliance with international shipping regulations. |
| BindExpectedReceiptDate | Datetime | The expected receipt date for the shipment line. This date is used for scheduling inbound logistics and warehouse resource planning. |
| BindOrganizationCode | String | The code representing the receiving organization. This code ensures that shipment records are properly classified within the enterprise structure. |
| BindOrganizationId | Long | The unique identifier for the receiving organization associated with the shipment. This identifier ensures consistency in logistics and inventory management. |
| BindPOHeaderId | Long | The unique identifier linking the shipment line to its associated purchase order (PO) header. This identifier ensures traceability in procurement transactions. |
| BindPONumber | String | The purchase order (PO) number corresponding to this shipment line. This PO number allows for cross-referencing between ordered and received goods. |
| BindShipmentHeaderId | Long | The unique identifier linking the shipment line to its shipment header. This identifier ensures accurate tracking and reconciliation of shipment details. |
| BindShipmentNumber | String | The unique shipment number associated with this shipment line. This number is used for logistics tracking and supplier coordination. |
| BindSupplier | String | The supplier associated with this shipment line. This information ensures correct supplier tracking and procurement alignment. |
| BindTONumber | String | The transfer order (TO) number linked to this shipment line. This TO number ensures accurate tracking of inter-organizational inventory transfers. |
| BindTransferOrderHeaderId | Long | The unique identifier for the transfer order header associated with this shipment line. This identifier provides traceability for inventory movements. |
| BindVendorId | Long | The unique identifier linking the shipment line to the corresponding vendor. This identifier ensures accuracy in procurement, supplier payments, and reconciliation processes. |
| Finder | String | A reference field or search parameter used to locate or filter shipment line records. This field facilitates efficient retrieval of shipment data within the system. |