---
updatedAt: 2026-08-18T18:39:20.000Z
agentTools:
  projectIndex: https://stockpit.readme.io/llms.txt
---

# Queries

Addresses store the postal and contact details of customers, suppliers and other entities. They are not directly queryable: addresses are available as subqueries of customers, suppliers and companies.

# Available queries

No direct query for address. Address are available as subqueries of customers, suppliers, ...

***

# Available fields

| id <span style={{ fontWeight: "normal" }}>- [Int](/reference/data-types#int) </span> |
| :----------------------------------------------------------------------------------- |
| Unique identifier of the address                                                     |

| label <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :-------------------------------------------------------------------------------------------- |
| Label of the address                                                                          |

| country <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :---------------------------------------------------------------------------------------------- |
| Country code (UK, FR, ...)                                                                      |

| address\_1 <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :------------------------------------------------------------------------------------------------- |
| Line 1 of the address                                                                              |

| address\_2 <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :------------------------------------------------------------------------------------------------- |
| Line 2 of the address                                                                              |

| postal\_code <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :--------------------------------------------------------------------------------------------------- |
| Postal code                                                                                          |

| city <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :------------------------------------------------------------------------------------------- |
| City (New-York, Paris, ...)                                                                  |

| state <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :-------------------------------------------------------------------------------------------- |
| State                                                                                         |

| phone <span style={{ fontWeight: "normal" }}>- [String](/reference/data-types#string) </span> |
| :-------------------------------------------------------------------------------------------- |
| Phone number                                                                                  |

<br />