> ## 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 table

> A list, dynamic or static

## s\_list Table (344)

A list, dynamic or static

## Fields

| Name                   | Description                                                                      | Type                             | Nullable |
| ---------------------- | -------------------------------------------------------------------------------- | -------------------------------- | :------: |
| id                     | Primary key                                                                      | PK                               |    No    |
| type                   | Dynamic/static                                                                   | type                             |    No    |
| name                   | The name of the list                                                             | String(255)                      |    No    |
| washed                 | Date when this list was last washed(not used until v2)                           | DateTime                         |    Yes   |
| washing\_percent       | How far the washing has gotten (not used until v2)                               | Short                            |    Yes   |
| flag                   | Not used                                                                         | Short                            |    Yes   |
| number\_of\_elements   | How many elements this list contains                                             | Int                              |    Yes   |
| folder\_id             | The folder which this link belongs to. -1 indicates that the link is on the root | Int                              |    No    |
| dbi\_agent\_id         | Integration agent (eJournal)                                                     | FK [dbi\_agent](./dbi-agent.mdx) |    No    |
| dbi\_key               | The primary key for the integrated entry in the external datasource.             | String(255)                      |    No    |
| dbi\_last\_syncronized | Last external syncronization.                                                    | DateTime                         |    No    |
| dbi\_last\_modified    | When the entry was last modified.                                                | DateTime                         |    No    |

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

## Indexes

| Fields                 | Types       | Description |
| ---------------------- | ----------- | ----------- |
| dbi\_agent\_id         | FK          | Index       |
| dbi\_key               | String(255) | Index       |
| dbi\_last\_syncronized | DateTime    | Index       |
| dbi\_last\_modified    | DateTime    | Index       |

## Relationships

| Table                                  | Description                                                                                                          |
| -------------------------------------- | -------------------------------------------------------------------------------------------------------------------- |
| [dbi\_agent](./dbi-agent)              | DBI agent settings                                                                                                   |
| [s\_dyn\_criteria](./s-dyn-criteria)   | Contains criterias for a dynamic list.                                                                               |
| [s\_list\_customer](./s-list-customer) | Elements in a customer list.                                                                                         |
| [s\_list\_element](./s-list-element)   | Elements in a static list.                                                                                           |
| [s\_list\_shipment](./s-list-shipment) | A connector between shipment and list so that one shipment can have many lists, and one list can have many shipments |
| [s\_washing\_list](./s-washing-list)   | Unused table that is ment to be used for active washing in spm v2                                                    |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [s_list_element table](/en/database/tables/s-list-element.md)
- [s_list_customer table](/en/database/tables/s-list-customer.md)
- [s_list_shipment table](/en/database/tables/s-list-shipment.md)
- [s_washing_list table](/en/database/tables/s-washing-list.md)
- [UDList table](/en/database/tables/udlist.md)
- [Blocked tables list](/en/online/mirroring/blocked-tables.md)