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 = New
1 = In process
2 = Closed		 Status 0 Select TicketStatus
Priority
Values List:
0 = Low
1 = 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 = Manually
1 = 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 = New
1 = 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
Jump to tables index