Database Table "hyp_Meetings"
Table Description
Normal StorageAll of the meetings from the last 6 months, and the future meetings. |
Archive StorageAll of the meetings that from 6 months ago or earlier. |
Deleted Storage(Recycle)All of the cancelled meetings. |
Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
---|---|---|---|---|---|---|
Key | Real | 0 | Edit | Hidden Read Only Key Field |
Key | |
For User | String | 40 | Select | Mandatory | ForUser | |
Subject | String | 120 | SelectEdit | Mandatory /G:1 | Subject | |
From Hour | Hour | 0 | Edit | Mandatory | FromHour | |
Until Hour | Hour | 0 | Edit | Mandatory | UntilHour | |
Status | Values List: 0 = Tentative1 = Confirmed 2 = Cancelled |
Status | 0 | Select | Status | |
Starts | FixDT | 0 | SelectEdit | Mandatory | Starts | |
Ends | FixDT | 0 | SelectEdit | Mandatory | Ends | |
Location | String | 120 | SelectEdit | Location | ||
Number of Participants | Integer | 0 | Edit | NumberOfParticipants | ||
Public Shared Notes | String | 1000 | Memo | PublicSharedNotes | ||
Popup Window | Values List: 00 = Never01 = On Time 02 = 15 Minutes Before 03 = 30 Minutes Before 04 = 45 Minutes Before 05 = 1 Hour Before 06 = 1.5 Hours Before 07 = 2 Hours Before 08 = 3 Hours Before 09 = 4 Hours Before 10 = 6 Hours Before |
Status | 0 | Select | PopupWindow | |
Private | String | 1 | Edit | Hidden | Private | |
Summary Status | Values List: 0 = No Need1 = Waiting for User 2 = Complete 3 = Postpone 24hr |
Status | 0 | Select | Hidden | SummaryStatus |
Meeting Summary | String | 1000 | Memo | MeetingSummary | ||
Sequence | Integer | 0 | Edit | Read Only | Sequence | |
Invited by Email | String | 1 | Edit | Hidden | InvitedByEmail | |
UniqueID | String | 140 | Edit | Read Only | Uniqueid | |
Organizer Mail Address | String | 80 | Edit | Read Only | OrganizerMailAddress | |
Attendees List | String | 120 | Edit | Read Only Mandatory /G:1 |
AttendeesList | |
Agency | Status | 0 | Select | Hidden | Agency | |
Created On | FixDT | 0 | Edit | Read Only | CreatedOn | |
Created By | String | 40 | Edit | Read Only | CreatedBy | |
Last Update | FixDT | 0 | Edit | Read Only | LastUpdate | |
Updated By | String | 40 | Edit | Read Only | UpdatedBy | |
Parent Meeting Key | Real | 0 | Edit | Hidden Read Only |
ParentMeetingKey | |
Repeating Original Meeting Key | Real | 0 | Edit | Hidden Read Only |
RepeatingOriginalMeetingKey | |
Link to Document Type | Values List: 0 = null, Empty1 = Service 2 = Opportunity 3 = Task |
Status | 0 | Select | Read Only | LinkToDocumentType |
Link to Document Key | Real | 0 | Edit | Read Only | LinkToDocumentKey | |
Color | Integer | 0 | PopupList | Color |