# shipment\$1stop


**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| shipment\$1stop | shipment\$1stop\$1id, shipment\$1id | 

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  shipment\$1stop\$1id  |  string  |  Yes  |  Shipment stop ID.  | 
|  shipment\$1id1  |  string  |  Yes  |  Shipment ID.  | 
|  sequence  |  int  |  No  |  Sequence of the shipment.  | 
|  company\$1id1  |  string  |  No  |  Company ID.  | 
|  site\$1id1  |  string  |  No  |  Site ID.  | 
|  planned\$1arrival\$1start\$1dttm  |  timestamp  |  No  |  Planned start date and time for the shipment arrival.  | 
|  planned\$1arrival\$1end\$1dttm  |  timestamp  |  No  |  Planned end date and time for the shipments arrival.  | 
|  planned\$1departure\$1start\$1dttm  |  timestamp  |  No  |  Planned start date and time for the shipment departure.  | 
|  planned\$1departure\$1end\$1dttm  |  timestamp  |  No  |  Planned end date and time for the shipment departure.  | 
|  actual\$1arrival\$1start\$1dttm  |  timestamp  |  No  |  Actual start date and time for the shipment arrival.  | 
|  actual\$1arrival\$1end\$1dttm  |  timestamp  |  No  |  Actual end date and time for the shipments arrival.  | 
|  actual\$1departure\$1start\$1dttm  |  timestamp  |  No  |  Actual start date and time for the shipment departure.  | 
|  actual\$1departure\$1end\$1dttm  |  timestamp  |  No  |  Actual end date and time for the shipment departure.  | 
|  appointment\$1number AWS Supply Chain web application will display this column as *appointment\$1number*.  |  string  |  No  |  Appointment number.  | 
|  delivery\$1number  |  string  |  No  |  Delivery number of the shipment.  | 
|  source\$1event\$1id  |  string  | No |  ID of the event created in the source system.   | 
|  source\$1update\$1dttm  |  timestamp  |  No  |  Date time stamp of the update made in the source system.  | 

1Foreign key

**Foreign key (FK)**

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


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| company\$1id | Organization | company | id | 
| site\$1id | Network | site | id | 
| shipment\$1id | Inbound | shipment | id |