# shipment\$1lot
<a name="replenishment-shipment-lot-entity"></a>

**Primary key (PK)**

The table below lists the colum names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| shipment\$1lot | id, product\$1id, tpartner\$1id, order\$1id, shipment\$1id, order\$1line\$1id, package\$1id | 

The table below lists the column names supported by the data entity:


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes  |  Shipment ID. Unique shipment identifier.  | 
|  product\$1id2  |  string  |  Yes  |  Product ID. Unique product identifier.  | 
|  serial\$1number  |  string  |  No  |  Unique serial number assigned to the lot. Serial numbers are often used for tracking and traceability purposes, particularly in industries where lot-level tracking is crucial.  | 
|  lot\$1qty  |  double  |  Yes  |  Quantity or number of units within the specific lot. It allows you to track the size or volume of each lot.  | 
|  mfg\$1date  |  timestamp  |  No  |  Manufacturing date.  | 
|  expiry\$1date  |  timestamp  |  No  |  Expiry date.  | 
|  tpartner\$1id2  |  string  |  No1  |  Partner that is sending the shipment. For example, shipments generated under POs, this will be vendors.  | 
|  order\$1id  |  string  |  No1  |  Order ID.  | 
|  shipment\$1id2  |  string  |  Yes1  |  Shipment ID. Unique shipment identifier.  | 
|  order\$1line\$1id2  |  string  |  No1  |  Order line ID.  | 
|  package\$1id2  |  string  |  No1  |  Package ID. One shipment can have multiple packages in EDI.  | 
|  source\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.   | 
|  source\$1update\$1dttm  |  timestamp  |  No  |  Date timestamp of the update made in the source system.  | 

1You must enter a value. When you ingest data from SAP or EDI, the default value for *string* is SCN\$1RESERVED\$1NO\$1VALUE\$1PROVIDED.

2Foreign key

1Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| product\$1id | Inbound | shipment | product\$1id | 
| tpartner\$1id | Inbound | shipment | supplier\$1tpartner\$1id | 
| order\$1id | Inbound | shipment | order\$1id | 
| shipment\$1id | Inbound | shipment | id | 
| order\$1line\$1id | Inbound | shipment | order\$1line\$1id | 
| package\$1id | Inbound | shipment | package\$1id |