Table Name: OISR
Table Description: Service Calls
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RequestNum | Request No. | Int | 11 | - | Â | Â | Â |
| Open_Date | Start Date | Date | 8 | - | Â | Â | Â |
| Open_Time | Start Time | Int | 11 | - | Â | Â | Â |
| Task_Id | Request No. in SAP Business One | Int | 11 | - | Â | Â | Â |
| Contact | Contact Person | nVarChar | 30 | - | Â | Â | Â |
| Phone | Telephone | nVarChar | 20 | - | Â | Â | Â |
| TaskType | Request Type | Int | 6 | - | 0 | 0 | Explanation |
| Â | Â | Â | Â | Â | Â | 1 | Error |
| Â | Â | Â | Â | Â | Â | 2 | Complaints |
| Dscription | Call Description | nVarChar | 254 | - | Â | Â | Â |
| Answer | Troubleshooting | Text | 16 | - | Â | Â | Â |
| Status | Call Status | VarChar | 1 | - | O | O | Open |
| Â | Â | Â | Â | Â | Â | C | Closed |
| Key | Unique | Field |
| PRIMARY | Yes | RequestNum |