> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# s_list_shipment table

> A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments

## s\_list\_shipment Table (348)

A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments

## Fields

| Name         | Description                                                  | Type                                                      | Nullable |
| ------------ | ------------------------------------------------------------ | --------------------------------------------------------- | :------: |
| id           | Primary key                                                  | PK                                                        |    No    |
| list\_id     | Reference to the list                                        | FK [s\_list](./s-list.mdx)                                |    No    |
| shipment\_id | Reference to the shipment                                    | FK [s\_shipment](./s-shipment.mdx)                        |    No    |
| type         | Indicates if this is a static/dynamic spmlist or a selection | Int                                                       |    Yes   |
| status       | Status of shipment list                                      | Enum [ShipmentListStatus](./enums/shipmentliststatus.mdx) |    Yes   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/s_list_shipment.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=4f61f772ac99e32519c650dc9fa49a31" alt="s_list_shipment table relationship diagram" width="665" height="59" data-path="media/loc/en/database/tables/s_list_shipment.png" />

## Indexes

| Fields       | Types | Description |
| ------------ | ----- | ----------- |
| list\_id     | FK    | Index       |
| shipment\_id | FK    | Index       |

## Relationships

| Table                       | Description                                                                     |
| --------------------------- | ------------------------------------------------------------------------------- |
| [s\_list](./s-list)         | A list, dynamic or static                                                       |
| [s\_shipment](./s-shipment) | Contains info about one shipment. The addresses are stored in s\_shipment\_addr |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [s_list table](/en/database/tables/s-list.md)
- [s_shipment table](/en/database/tables/s-shipment.md)
- [Enum values for ShipmentListStatus](/en/database/tables/enums/shipmentliststatus.md)
- [ShipmentType table](/en/database/tables/shipmenttype.md)
- [ShipmentTypeReservation table](/en/database/tables/shipmenttypereservation.md)
- [s_shipment_addr table](/en/database/tables/s-shipment-addr.md)