Database Table "hyp_Relationship"
Table Description
The Relationship table which includes the Phone calls and Emails.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| File Number | Integer | 0 | Edit | Hidden Read Only Key Field |
FileNumber | |
| When | FixDT | 0 | Edit | Read Only Key Field |
When | |
| Who | String | 40 | Edit | Read Only | Who | |
| What | Values List: 0 = Phone Call1 = Meeting 2 = Incoming EMail 3 = Outgoing EMail 4 = User Notes 5 = System Note 6 = Not Arrived to a Meeting (deceive) 7 = Chat App |
Status | 0 | Select | Read Only | What |
| Abstract | String | 800 | Memo | Abstract | ||
| PhoneCall Result | Values List: 0 = null, Empty1 = No Answer 2 = Left a Message 3 = Short Conversation 4 = Long Conversation |
Status | 0 | Select | PhonecallResult | |
| Next Phone call On | FixDT | 0 | SelectEdit | NextPhoneCallOn | ||
| Next Phone call By | String | 40 | PopupList | NextPhoneCallBy | ||
| Department / Category | String | 40 | Select | DepartmentCategory | ||
| Contact Person | String | 105 | PopupList | ContactPerson | ||
| Meeting Key | Real | 0 | Edit | Hidden Read Only |
MeetingKey | |
| Basic File Name | String | 32 | Edit | Hidden Read Only |
BasicFileName | |
| Link to Document Type | Values List: 0 = null, Empty1 = Service 2 = Opportunity |
Status | 0 | Select | Hidden Read Only |
LinkToDocumentType |
| Link to Document Key | Real | 0 | Edit | Hidden Read Only |
LinkToDocumentKey |