
| Field Name | Description | 1º Key | 2º Index | Foreign Key | Paradox Field Type | |
| Section | Section of Institution (Vertebrates, Plants etc.) | Alpha, 3 characters | ||||
| SpecimenNo | Long Integer | |||||
| LocPrefix | Locality | Alpha, 2 characters | ||||
| LocalityNo | Locality where specimen was collected | Locality | Long Integer | |||
| AccessionNo | Accession | Long Integer | ||||
| NoObjects | Alpha, 10 characters | |||||
| FieldNo | Alpha, 15 characters | |||||
| Type? | Logical |
| Field Name | Description | 1º Key | 2º Index | Foreign Key | Paradox Field Type | |
| Section | Section of Institution (Vertebrates, Plants etc.) | Specimen | Alpha, 3 characters | |||
| SpecimenNo | Specimen | Long Integer | ||||
| Acronym | Other institution, UCMP if it has more than one UCMP number | Acronym | Alpha, 15 characters | |||
| AltSpecNo | Other institution specimen number | Alpha, 15 characters | ||||
| Equivalency | To indicate if part of the specimen has been given a separate number | Alpha, 10 characters |