Database Table "hyp_Service Ticket"
Table Description
The service tickets primary table of Hyper.Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
---|---|---|---|---|---|---|
Ticket Number | Integer | 0 | Edit | Read Only Key Field |
TicketNumber | |
Ticket Status | Values List: 0 = New1 = In process 2 = Closed |
Status | 0 | Select | TicketStatus | |
Priority | Values List: 0 = Low1 = Normal 2 = High |
Status | 0 | Select | Priority | |
Entity Number | Integer | 0 | Edit | Read Only | EntityNumber | |
Entity Full Name | String | 105 | PopupList | Mandatory | EntityFullName | |
About Order No. | Real | 0 | PopupList | AboutOrderNo | ||
About a Person | String | 40 | PopupList | Mandatory | AboutAPerson | |
Ticket Source | Values List: 0 = Manually1 = Public Website 2 = Service Website 3 = Software Process 4 = Withdraw Request |
Status | 0 | Select | TicketSource | |
Subject Category | String | 80 | Edit | SubjectCategory | ||
Subject / Complain | Message / Request | String | 800 | Memo | Mandatory | SubjectComplain |
Complainer Name | Name | 60 | SelectEdit | ComplainerName | ||
Return to Phone | Phone | 20 | Edit | ReturnToPhone | ||
Return to Email | String | 80 | Edit | ReturnToEmail | ||
Withdraw Amount | Money | 0 | Edit | WithdrawAmount | ||
Withdraw Currency | String | 5 | Select | WithdrawCurrency | ||
Created On | FixDT | 0 | Edit | Read Only | CreatedOn | |
Created By | String | 40 | Edit | Read Only | CreatedBy | |
Handling Responsibility | Values List: 0 = Everyone (all users)1 = For Agency 2 = For Department 3 = For Specific User 4 = Allow Agency to help 5 = Allow Department to help |
Status | 0 | Select | HandlingResponsibility | |
Agency | Status | 0 | Select | Agency | ||
Department / Category | String | 40 | Select | DepartmentCategory | ||
For User | String | 40 | PopupList | ForUser | ||
Work Process | String | 30 | Select | Spare Field | WorkProcess | |
Last Step | String | 50 | Edit | Read Only | LastStep | |
Next Step | String | 50 | Edit | Read Only | NextStep | |
Next Step Deadline | FixDT | 0 | SelectEdit | Read Only | NextStepDeadline | |
Handling Deadline | FixDT | 0 | SelectEdit | HandlingDeadline | ||
Complainer Feedback | String | 200 | TextMemo | ComplainerFeedback | ||
Closed On | FixDT | 0 | Edit | Read Only | ClosedOn | |
Closed By | String | 40 | Edit | Read Only | ClosedBy | |
Pink Status | Values List: 0 = New1 = Waiting for Service Manager 2 = Waiting for Service Order 3 = Waiting for Field Service Technician 4 = Waiting for the Complainer to send documents 5 = Completed with Full Customer's Satisfaction 6 = Completed by Compromise with the Customer 7 = Completed Against the will of the Customer 8 = Declined 9 = Cancelled by |
Status | 0 | Select | Spare Field | PinkStatus |
Old Doc Reference | String | 20 | Edit | Read Only | OldDocReference | |
Old Software Name | String | 10 | Edit | Read Only | OldSoftwareName |