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

# udtempSmall table

> User-defined fields. During conversion of user defined fields the data is stored in this table.

## udtempSmall Table (144)

User-defined fields. During conversion of user defined fields the data is stored in this table.

## Fields

| Name            | Description                  | Type       | Nullable |
| --------------- | ---------------------------- | ---------- | :------: |
| udtempSmall\_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/udtempSmall.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=1ee3380c7ff889228592c15cce6a38b1" alt="udtempSmall table relationship diagram" width="124" height="59" data-path="media/loc/en/database/tables/udtempSmall.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [udtempLarge table](/en/database/tables/udtemplarge.md)
- [udpersonSmall table](/en/database/tables/udpersonsmall.md)
- [udprojectSmall table](/en/database/tables/udprojectsmall.md)
- [udcontactSmall table](/en/database/tables/udcontactsmall.md)
- [message_header table](/en/database/tables/message-header.md)
- [Working with custom objects and fields in API](/en/custom-objects/reference/index.md)
