biuan SAP® BUSINESS ONE SDK
SQL Service / Service Calls
API OISR
OISR - Service Calls Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RequestNum KEY UNIQUERequest No.Int
11
PRIMARYYes
Open_DateStart DateDate
8
Open_TimeStart TimeInt
11
Task_IdRequest No. in SAP Business OneInt
11
ContactContact PersonnVarChar
30
PhoneTelephonenVarChar
20
TaskTypeRequest TypeInt
0
1) Error
2) Complaints
6
0
DscriptionCall DescriptionnVarChar
127
AnswerTroubleshootingText
16
StatusCall StatusVarChar
O) Open
C) Closed
1
O

SELECT statement

SELECT OISR.RequestNum AS 'Request No.', OISR.Open_Date AS 'Start Date', OISR.Open_Time AS 'Start Time', OISR.Task_Id AS 'Request No. in SAP Business One', OISR.Contact AS 'Contact Person', OISR.Phone AS 'Telephone', OISR.TaskType AS 'Request Type', OISR.Dscription AS 'Call Description', OISR.Answer AS 'Troubleshooting', OISR.Status AS 'Call Status' FROM OISR AS OISR

Related information
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates