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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
callID KEY UNIQUECall IDInt
11
PRIMARYYes
subjectSubjectnVarChar
127
customerCustomer CodenVarChar
15OCRD
Business Partner
custmrNameCustomer NamenVarChar
100OCRD
Business Partner
contctCodeContact PersonInt
11OCPR
Contact Persons
manufSNMfr Serial No.nVarChar
36
internalSNSerial NumbernVarChar
36
contractIDContract No.Int
11OCTR
Service Contracts
cntrctDateContract End DateDate
8
resolDateResolution DateDate
8
resolTimeResolution TimeInt
6
free_1WarrantyVarChar
Y) Yes
N) No
1
N
free_2Warranty End DateDate
8
originOriginInt
6OSCO
Service Call Origins
itemCodeItem No.nVarChar
20OITM
Items
itemNameItem DescriptionnVarChar
100
itemGroupItem GroupInt
6OITB
Item Groups
statusStatusInt
6OSCS
Service Call Statuses
-3
priorityPriorityVarChar
L) Low
M) Medium
H) High
1
L
callTypeCall TypeInt
6OSCT
Service Call Types
problemTypProblem TypeInt
6OSCP
Service Call Problem Types
assigneeHandled byInt
6OUSR
Users
descrptionDescriptionText
16
objTypeObject TypenVarChar
20
191
logInstancLog InstanceInt
11
userSignCreating UserInt
6OUSR
Users
createDateCreation DateDate
8
createTimeCreation TimeInt
6
closeDateClosing DateDate
8
closeTimeClosing TimeInt
6
userSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
8
SCL1CountInternalSCL1CountInt
11
0
SCL2CountInternalSCL2CountInt
11
0
isEntitledEntitle for ServiceVarChar
N) Not Entitled
C) Valid contract exists
1
N
insIDInstall Card No.Int
11OINS
Customer Equipment Card
technicianTechnicianInt
11OHEM
Employees
resolutionResolutionText
16
Scl1NxtLnSCL1 Next LineInt
11
Scl2NxtLnSCL2 Next LineInt
11
Scl3NxtLnSCL3 Next LineInt
11
Scl4NxtLnSCL4 Next LineInt
11
Scl5NxtLnSCL5 Next LineInt
11
isQueueBelongs to a QueueVarChar
N) No
Y) Yes
1
N
QueueQueuenVarChar
20OQUE
Queue
resolOnDatResolution on DateDate
8
resolOnTimResolution on TimeInt
6
respByDateResponse by DateDate
8
respByTimeResponse by TimeInt
6
respOnDateResponse on DateDate
8
respOnTimeResponse on TimeInt
6
respAssignAssigned for ResponseInt
6OUSR
Users
AssignDateAssigned DateDate
8
AssignTimeAssigned TimeInt
6
UpdateTimeUpdated TimeInt
6
responderResponderInt
6OUSR
Users
TransferedYear TransferVarChar
1
N
InstanceInstanceInt
6
0
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
Series KEYSeriesInt
6NNM1
Documents Numbering - Series
SERIESNo
HandwrttenManual NumberingVarChar
Y) Yes
N) No
1
N
PIndicatorPeriod IndicatornVarChar
10OPID
Period Indicator
' '
StartDateStart DateDate
8
StartTimeStart TimeInt
11
EndDateEnd DateDate
8
EndTimeEnd TimeInt
11
DurationService Call DurationNum
20
DurTypeDuration UoMVarChar
M) Minutes
H) Hours
D) Days
1
M
ReminderReminderVarChar
Y) Yes
N) No
1
N
RemQtyReminder QuantityNum
20
RemTypeReminder UoMVarChar
M) Minutes
H) Hours
D) Days
1
M
RemDate KEYReminder DateDate
8
REMDATENo
RemSentReminder SentVarChar
Y) Yes
N) No
1
N
RemTime KEYReminder TimeInt
6
REMTIMENo
LocationLocationInt
6OCLO
Meetings Location
-1
AddrNameAddress NamenVarChar
50
AddrTypeAddress TypeVarChar
S) Ship To
B) Bill to
1
S
StreetStreetnVarChar
100
CityCitynVarChar
100
RoomRoomnVarChar
50
StateStatenVarChar
3OCST
States
CountryCountrynVarChar
3OCRY
Countries
DisplInCalDisplay in CalendarVarChar
Y) Yes
N) No
1
N
SupplCodeSupplementary CodenVarChar
127
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
NumAtCardCustomer Ref. No.nVarChar
100
ProSubTypeProblem SubtypeInt
6OPST
Service Call Problem Subtype

Table relationship map

SELECT statement

SELECT OSCL.callID AS 'Call ID', OSCL.subject AS 'Subject', OSCL.customer AS 'Customer Code', OSCL.custmrName AS 'Customer Name', OSCL.contctCode AS 'Contact Person', OSCL.manufSN AS 'Mfr Serial No.', OSCL.internalSN AS 'Serial Number', OSCL.contractID AS 'Contract No.', OSCL.cntrctDate AS 'Contract End Date', OSCL.resolDate AS 'Resolution Date', OSCL.resolTime AS 'Resolution Time', OSCL.free_1 AS 'Warranty', OSCL.free_2 AS 'Warranty End Date', OSCL.origin AS 'Origin', OSCL.itemCode AS 'Item No.', OSCL.itemName AS 'Item Description', OSCL.itemGroup AS 'Item Group', OSCL.status AS 'Status', OSCL.priority AS 'Priority', OSCL.callType AS 'Call Type', OSCL.problemTyp AS 'Problem Type', OSCL.assignee AS 'Handled by', OSCL.descrption AS 'Description', OSCL.objType AS 'Object Type', OSCL.logInstanc AS 'Log Instance', OSCL.userSign AS 'Creating User', OSCL.createDate AS 'Creation Date', OSCL.createTime AS 'Creation Time', OSCL.closeDate AS 'Closing Date', OSCL.closeTime AS 'Closing Time', OSCL.userSign2 AS 'Updating User', OSCL.updateDate AS 'Date of Update', OSCL.SCL1Count AS 'InternalSCL1Count', OSCL.SCL2Count AS 'InternalSCL2Count', OSCL.isEntitled AS 'Entitle for Service', OSCL.insID AS 'Install Card No.', OSCL.technician AS 'Technician', OSCL.resolution AS 'Resolution', OSCL.Scl1NxtLn AS 'SCL1 Next Line', OSCL.Scl2NxtLn AS 'SCL2 Next Line', OSCL.Scl3NxtLn AS 'SCL3 Next Line', OSCL.Scl4NxtLn AS 'SCL4 Next Line', OSCL.Scl5NxtLn AS 'SCL5 Next Line', OSCL.isQueue AS 'Belongs to a Queue', OSCL.Queue AS 'Queue', OSCL.resolOnDat AS 'Resolution on Date', OSCL.resolOnTim AS 'Resolution on Time', OSCL.respByDate AS 'Response by Date', OSCL.respByTime AS 'Response by Time', OSCL.respOnDate AS 'Response on Date', OSCL.respOnTime AS 'Response on Time', OSCL.respAssign AS 'Assigned for Response', OSCL.AssignDate AS 'Assigned Date', OSCL.AssignTime AS 'Assigned Time', OSCL.UpdateTime AS 'Updated Time', OSCL.responder AS 'Responder', OSCL.Transfered AS 'Year Transfer', OSCL.Instance AS 'Instance', OSCL.DocNum AS 'Document Number', OSCL.Series AS 'Series', OSCL.Handwrtten AS 'Manual Numbering', OSCL.PIndicator AS 'Period Indicator', OSCL.StartDate AS 'Start Date', OSCL.StartTime AS 'Start Time', OSCL.EndDate AS 'End Date', OSCL.EndTime AS 'End Time', OSCL.Duration AS 'Service Call Duration', OSCL.DurType AS 'Duration UoM', OSCL.Reminder AS 'Reminder', OSCL.RemQty AS 'Reminder Quantity', OSCL.RemType AS 'Reminder UoM', OSCL.RemDate AS 'Reminder Date', OSCL.RemSent AS 'Reminder Sent', OSCL.RemTime AS 'Reminder Time', OSCL.Location AS 'Location', OSCL.AddrName AS 'Address Name', OSCL.AddrType AS 'Address Type', OSCL.Street AS 'Street', OSCL.City AS 'City', OSCL.Room AS 'Room', OSCL.State AS 'State', OSCL.Country AS 'Country', OSCL.DisplInCal AS 'Display in Calendar', OSCL.SupplCode AS 'Supplementary Code', OSCL.Attachment AS 'Attachment', OSCL.AtcEntry AS 'Attachment Entry', OSCL.NumAtCard AS 'Customer Ref. No.', OSCL.ProSubType AS 'Problem Subtype' FROM OSCL AS OSCL

Related information


Service Calls ServiceCalls Object· Table: OSCL
ServiceCalls is a business object that represents the service calls table in the Service module. This object enables you to: Add a service call. Retrieve a service call by its key. Update a service call. Remove a service call. Save the...

OSCL SQL Table

Users OUSR SQL Table

Service Call Types OSCT SQL Table

Contact Persons OCPR SQL Table

Service Contracts OCTR SQL Table

Countries OCRY SQL Table

Business Partner OCRD SQL Table

Customer Equipment Card OINS SQL Table

Items OITM SQL Table

Item Groups OITB SQL Table

Meetings Location OCLO SQL Table

Service Call Origins OSCO SQL Table

Period Indicator OPID SQL Table

Service Call Problem Types OSCP SQL Table

Service Call Problem Subtype OPST SQL Table

Queue OQUE SQL Table

Documents Numbering - Series NNM1 SQL Table

States OCST SQL Table

Service Call Statuses OSCS SQL Table

Employees OHEM SQL Table



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