udpersonSmall Table (140)
Some tooltip text!
• 8 minutes to read
• 8 minutes to read
User-defined fields
Fields
Name | Description | Type | Null |
---|---|---|---|
udpersonSmall_id | Primary key | PK | |
long01 | long value 1, indexed | Id | ● |
long02 | long value 2, indexed | Id | ● |
long03 | long value 3, indexed | Id | ● |
long04 | long value 4, indexed | Id | ● |
long05 | long value 5, not indexed | Id | ● |
long06 | long value 6, not indexed | Id | ● |
long07 | long value 7, not indexed | Id | ● |
long08 | long value 8, not indexed | Id | ● |
long09 | long value 9, not indexed | Id | ● |
long10 | long value 10, not indexed | Id | ● |
long11 | long value 11, not indexed | Id | ● |
long12 | long value 12, not indexed | Id | ● |
long13 | long value 13, not indexed | Id | ● |
long14 | long value 14, not indexed | Id | ● |
long15 | long value 15, not indexed | Id | ● |
long16 | long value 16, not indexed | Id | ● |
long17 | long value 17, not indexed | Id | ● |
long18 | long value 18, not indexed | Id | ● |
long19 | long value 19, not indexed | Id | ● |
long20 | long value 20, not indexed | Id | ● |
long21 | long value 21, not indexed | Id | ● |
long22 | long value 22, not indexed | Id | ● |
long23 | long value 23, not indexed | Id | ● |
long24 | long value 24, not indexed | Id | ● |
long25 | long value 25, not indexed | Id | ● |
long26 | long value 26, not indexed | Id | ● |
long27 | long value 27, not indexed | Id | ● |
long28 | long value 28, not indexed | Id | ● |
long29 | long value 29, not indexed | Id | ● |
long30 | long value 30, not indexed | Id | ● |
long31 | long value 31, not indexed | Id | ● |
long32 | long value 32, not indexed | Id | ● |
long33 | long value 33, not indexed | Id | ● |
long34 | long value 34, not indexed | Id | ● |
long35 | long value 35, not indexed | Id | ● |
long36 | long value 36, not indexed | Id | ● |
long37 | long value 37, not indexed | Id | ● |
long38 | long value 38, not indexed | Id | ● |
long39 | long value 39, not indexed | Id | ● |
long40 | long value 40, not indexed | Id | ● |
long41 | long value 41, not indexed | Id | ● |
long42 | long value 42, not indexed | Id | ● |
long43 | long value 43, not indexed | Id | ● |
long44 | long value 44, not indexed | Id | ● |
long45 | long value 45, not indexed | Id | ● |
long46 | long value 46, not indexed | Id | ● |
long47 | long value 47, not indexed | Id | ● |
long48 | long value 48, not indexed | Id | ● |
long49 | long value 49, not indexed | Id | ● |
long50 | long value 50, not indexed | Id | ● |
long51 | long value 51, not indexed | Id | ● |
long52 | long value 52, not indexed | Id | ● |
long53 | long value 53, not indexed | Id | ● |
long54 | long value 54, not indexed | Id | ● |
long55 | long value 55, not indexed | Id | ● |
long56 | long value 56, not indexed | Id | ● |
long57 | long value 57, not indexed | Id | ● |
long58 | long value 58, not indexed | Id | ● |
long59 | long value 59, not indexed | Id | ● |
long60 | long value 60, not indexed | Id | ● |
string01 | string value 1, indexed | String(39) | ● |
string02 | string value 2, indexed | String(39) | ● |
string03 | string value 3, indexed | String(39) | ● |
string04 | string value 4, indexed | String(39) | ● |
string05 | string value 5, not indexed | String(39) | ● |
string06 | string value 6, not indexed | String(39) | ● |
string07 | string value 7, not indexed | String(39) | ● |
string08 | string value 8, not indexed | String(39) | ● |
string09 | string value 9, not indexed | String(39) | ● |
string10 | string value 10, not indexed | String(39) | ● |
string11 | string value 11, not indexed | String(39) | ● |
string12 | string value 12, not indexed | String(39) | ● |
string13 | string value 13, not indexed | String(39) | ● |
string14 | string value 14, not indexed | String(39) | ● |
string15 | string value 15, not indexed | String(39) | ● |
string16 | string value 16, not indexed | String(39) | ● |
string17 | string value 17, not indexed | String(39) | ● |
string18 | string value 18, not indexed | String(39) | ● |
string19 | string value 19, not indexed | String(39) | ● |
string20 | string value 20, not indexed | String(39) | ● |
string21 | string value 21, not indexed | String(39) | ● |
string22 | string value 22, not indexed | String(39) | ● |
string23 | string value 23, not indexed | String(39) | ● |
string24 | string value 24, not indexed | String(39) | ● |
string25 | string value 25, not indexed | String(39) | ● |
string26 | string value 26, not indexed | String(39) | ● |
string27 | string value 27, not indexed | String(39) | ● |
string28 | string value 28, not indexed | String(39) | ● |
string29 | string value 29, not indexed | String(39) | ● |
string30 | string value 30, not indexed | String(39) | ● |
string31 | string value 31, not indexed | String(39) | ● |
string32 | string value 32, not indexed | String(39) | ● |
string33 | string value 33, not indexed | String(39) | ● |
string34 | string value 34, not indexed | String(39) | ● |
string35 | string value 35, not indexed | String(39) | ● |
string36 | string value 36, not indexed | String(39) | ● |
string37 | string value 37, not indexed | String(39) | ● |
string38 | string value 38, not indexed | String(39) | ● |
string39 | string value 39, not indexed | String(39) | ● |
string40 | string value 40, not indexed | String(39) | ● |
double01 | double value 1, indexed | Double | ● |
double02 | double value 2, indexed | Double | ● |
double03 | double value 3, indexed | Double | ● |
double04 | double value 4, indexed | Double | ● |
double05 | double value 5, not indexed | Double | ● |
double06 | double value 6, not indexed | Double | ● |
double07 | double value 7, not indexed | Double | ● |
double08 | double value 8, not indexed | Double | ● |
double09 | double value 9, not indexed | Double | ● |
double10 | double value 10, not indexed | Double | ● |
Indexes
Fields | Types | Description |
---|---|---|
udpersonSmall_id | PK | Clustered, Unique |
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 |
---|---|
person | Persons in a company or an organizations. All associates have a corresponding person record |
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
- Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent.