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

# uddocsmall table

> User-defined fields

## uddocsmall Table (230)

User-defined fields

## Fields

| Name           | Description                  | Type       | Nullable |
| -------------- | ---------------------------- | ---------- | :------: |
| uddocsmall\_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/uddocsmall.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=a9ec99129724282df7575e03110ed3b5" alt="uddocsmall table relationship diagram" width="402" height="59" data-path="media/loc/en/database/tables/uddocsmall.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                                                                                                                                                                                                                                                                                                                               |
| ---------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [document](./document) | Documents, this table is an extension of the Appointment table.  There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a 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)
- [Working with Upsert](/en/api/bulk-operations/mass-operations/upsert.md)
- [document table](/en/database/tables/document.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)
