Skip to main content
Mitratech Success Center

EApptDetail

EApptDetail

EApptDetail contains all categories added to appointment records. Each time a category is added to an appointment record, an entry is made in this table in the database.

In Object Navigator, EApptDetail is not displayed when you traverse using the detailList--> bridge. Instead, a list of all categories that have been defined for the object definition appears. This list is labeled Category. From each category, you can traverse to a table called Detail Fields, which displays all custom fields belonging to the category you selected.

For more information about how custom field values are stored in the database, see Object Model: Custom Fields.

Object: EApptDetail (E_APPT_DETAIL)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

               

Rules

Temp/Wiz

category-->

CATEGORY_ID 
(NUMBER)

Category

x

x

YRecently
Viewed
Record

object

The category of the appointment with which the details are associated.

   

owner-->

ENTERPRISE_OBJECT_ID (NUMBER)

   

x

TAppointment

object

The appointment with which the custom fields are associated.

   

isManual

IS_MANUAL (NUMBER)

 

x

   

boolean

Specifies whether the category is added manually or automatically to the appointment.

Categories are added automatically when they are the parent of the category that is added manually.

0 - Added Automatically
1 - Added Manually

   

primary
Key

PRIMARY_KEY 
(NUMBER)

 

x

   

int

The unique ID of the appointment category record.

   

version

VERSION(NUMBER)

 

x

   

int

Indicates how many times the added category was updated.

   
  • Was this article helpful?