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

# udappntsmall table

> User-defined fields

## udappntsmall Table (228)

User-defined fields

## Fields

| Name             | Description                  | Type       | Nullable |
| ---------------- | ---------------------------- | ---------- | :------: |
| udappntsmall\_id | Primary key                  | PK         |    No    |
| long01           | long value 1, indexed        | Id         |    Yes   |
| long02           | long value 2, indexed        | Id         |    Yes   |
| long03           | long value 3, indexed        | Id         |    Yes   |
| long04           | long value 4, indexed        | Id         |    Yes   |
| long05           | long value 5, not indexed    | Id         |    Yes   |
| long06           | long value 6, not indexed    | Id         |    Yes   |
| long07           | long value 7, not indexed    | Id         |    Yes   |
| long08           | long value 8, not indexed    | Id         |    Yes   |
| long09           | long value 9, not indexed    | Id         |    Yes   |
| long10           | long value 10, not indexed   | Id         |    Yes   |
| long11           | long value 11, not indexed   | Id         |    Yes   |
| long12           | long value 12, not indexed   | Id         |    Yes   |
| long13           | long value 13, not indexed   | Id         |    Yes   |
| long14           | long value 14, not indexed   | Id         |    Yes   |
| long15           | long value 15, not indexed   | Id         |    Yes   |
| long16           | long value 16, not indexed   | Id         |    Yes   |
| long17           | long value 17, not indexed   | Id         |    Yes   |
| long18           | long value 18, not indexed   | Id         |    Yes   |
| long19           | long value 19, not indexed   | Id         |    Yes   |
| long20           | long value 20, not indexed   | Id         |    Yes   |
| long21           | long value 21, not indexed   | Id         |    Yes   |
| long22           | long value 22, not indexed   | Id         |    Yes   |
| long23           | long value 23, not indexed   | Id         |    Yes   |
| long24           | long value 24, not indexed   | Id         |    Yes   |
| long25           | long value 25, not indexed   | Id         |    Yes   |
| long26           | long value 26, not indexed   | Id         |    Yes   |
| long27           | long value 27, not indexed   | Id         |    Yes   |
| long28           | long value 28, not indexed   | Id         |    Yes   |
| long29           | long value 29, not indexed   | Id         |    Yes   |
| long30           | long value 30, not indexed   | Id         |    Yes   |
| long31           | long value 31, not indexed   | Id         |    Yes   |
| long32           | long value 32, not indexed   | Id         |    Yes   |
| long33           | long value 33, not indexed   | Id         |    Yes   |
| long34           | long value 34, not indexed   | Id         |    Yes   |
| long35           | long value 35, not indexed   | Id         |    Yes   |
| long36           | long value 36, not indexed   | Id         |    Yes   |
| long37           | long value 37, not indexed   | Id         |    Yes   |
| long38           | long value 38, not indexed   | Id         |    Yes   |
| long39           | long value 39, not indexed   | Id         |    Yes   |
| long40           | long value 40, not indexed   | Id         |    Yes   |
| long41           | long value 41, not indexed   | Id         |    Yes   |
| long42           | long value 42, not indexed   | Id         |    Yes   |
| long43           | long value 43, not indexed   | Id         |    Yes   |
| long44           | long value 44, not indexed   | Id         |    Yes   |
| long45           | long value 45, not indexed   | Id         |    Yes   |
| long46           | long value 46, not indexed   | Id         |    Yes   |
| long47           | long value 47, not indexed   | Id         |    Yes   |
| long48           | long value 48, not indexed   | Id         |    Yes   |
| long49           | long value 49, not indexed   | Id         |    Yes   |
| long50           | long value 50, not indexed   | Id         |    Yes   |
| long51           | long value 51, not indexed   | Id         |    Yes   |
| long52           | long value 52, not indexed   | Id         |    Yes   |
| long53           | long value 53, not indexed   | Id         |    Yes   |
| long54           | long value 54, not indexed   | Id         |    Yes   |
| long55           | long value 55, not indexed   | Id         |    Yes   |
| long56           | long value 56, not indexed   | Id         |    Yes   |
| long57           | long value 57, not indexed   | Id         |    Yes   |
| long58           | long value 58, not indexed   | Id         |    Yes   |
| long59           | long value 59, not indexed   | Id         |    Yes   |
| long60           | long value 60, not indexed   | Id         |    Yes   |
| string01         | string value 1, indexed      | String(39) |    Yes   |
| string02         | string value 2, indexed      | String(39) |    Yes   |
| string03         | string value 3, indexed      | String(39) |    Yes   |
| string04         | string value 4, indexed      | String(39) |    Yes   |
| string05         | string value 5, not indexed  | String(39) |    Yes   |
| string06         | string value 6, not indexed  | String(39) |    Yes   |
| string07         | string value 7, not indexed  | String(39) |    Yes   |
| string08         | string value 8, not indexed  | String(39) |    Yes   |
| string09         | string value 9, not indexed  | String(39) |    Yes   |
| string10         | string value 10, not indexed | String(39) |    Yes   |
| string11         | string value 11, not indexed | String(39) |    Yes   |
| string12         | string value 12, not indexed | String(39) |    Yes   |
| string13         | string value 13, not indexed | String(39) |    Yes   |
| string14         | string value 14, not indexed | String(39) |    Yes   |
| string15         | string value 15, not indexed | String(39) |    Yes   |
| string16         | string value 16, not indexed | String(39) |    Yes   |
| string17         | string value 17, not indexed | String(39) |    Yes   |
| string18         | string value 18, not indexed | String(39) |    Yes   |
| string19         | string value 19, not indexed | String(39) |    Yes   |
| string20         | string value 20, not indexed | String(39) |    Yes   |
| string21         | string value 21, not indexed | String(39) |    Yes   |
| string22         | string value 22, not indexed | String(39) |    Yes   |
| string23         | string value 23, not indexed | String(39) |    Yes   |
| string24         | string value 24, not indexed | String(39) |    Yes   |
| string25         | string value 25, not indexed | String(39) |    Yes   |
| string26         | string value 26, not indexed | String(39) |    Yes   |
| string27         | string value 27, not indexed | String(39) |    Yes   |
| string28         | string value 28, not indexed | String(39) |    Yes   |
| string29         | string value 29, not indexed | String(39) |    Yes   |
| string30         | string value 30, not indexed | String(39) |    Yes   |
| string31         | string value 31, not indexed | String(39) |    Yes   |
| string32         | string value 32, not indexed | String(39) |    Yes   |
| string33         | string value 33, not indexed | String(39) |    Yes   |
| string34         | string value 34, not indexed | String(39) |    Yes   |
| string35         | string value 35, not indexed | String(39) |    Yes   |
| string36         | string value 36, not indexed | String(39) |    Yes   |
| string37         | string value 37, not indexed | String(39) |    Yes   |
| string38         | string value 38, not indexed | String(39) |    Yes   |
| string39         | string value 39, not indexed | String(39) |    Yes   |
| string40         | string value 40, not indexed | String(39) |    Yes   |
| double01         | double value 1, indexed      | Double     |    Yes   |
| double02         | double value 2, indexed      | Double     |    Yes   |
| double03         | double value 3, indexed      | Double     |    Yes   |
| double04         | double value 4, indexed      | Double     |    Yes   |
| double05         | double value 5, not indexed  | Double     |    Yes   |
| double06         | double value 6, not indexed  | Double     |    Yes   |
| double07         | double value 7, not indexed  | Double     |    Yes   |
| double08         | double value 8, not indexed  | Double     |    Yes   |
| double09         | double value 9, not indexed  | Double     |    Yes   |
| double10         | double value 10, not indexed | Double     |    Yes   |

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

## Indexes

| Fields   | Types      | Description |
| -------- | ---------- | ----------- |
| long01   | Id         | Index       |
| long02   | Id         | Index       |
| long03   | Id         | Index       |
| long04   | Id         | Index       |
| string01 | String(39) | Index       |
| string02 | String(39) | Index       |
| string03 | String(39) | Index       |
| string04 | String(39) | Index       |
| double01 | Double     | Index       |
| double02 | Double     | Index       |
| double03 | Double     | Index       |
| double04 | Double     | Index       |

## Relationships

| Table                        | Description                                                                                                                                                                 |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [appointment](./appointment) | Tasks, appointments, followups, phone calls; and documents (document\_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |

## Replication Flags

* Area Management controlled table. Contents replicated to satellites and traveller databases.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [Working with custom objects and fields in API](/en/custom-objects/reference/index.md)
- [appointment table](/en/database/tables/appointment.md)
- [extra_tables table](/en/database/tables/extra-tables.md)
- [ext_table table](/en/database/tables/ext-table.md)
- [Database table listing](/en/database/tables/index.md)
- [extra_tables_result table](/en/database/tables/extra-tables-result.md)
