SCL1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Service / Service Calls / Service Call Solutions - Rows

DTW Service Call Solutions - Rows

API Service Calls / Service Call Solutions

SCL1 - Service Call Solutions - Rows Table

SBO SQL database table details

Field	Description	Type	Size	Related	Default	Primary_Key	Unique
srvcCallID ^KEY ^UNIQUE	Service Call No.	Int	11	OSCL Service Calls		PRIMARY	Yes
line	Row No.	Int	6		-1
solutionID	Solution ID	Int	11	OSLT Service Call Solutions
objType	Object Type	nVarChar	20		191
logInstanc	Log Instance	Int	11
userSign	Creating User	Int	6	OUSR Users
createDate	Creation Date	Date	8
userSign2	Updating User	Int	6	OUSR Users
updateDate	Date of Update	Date	8
VisOredr	Visual Order	Int	11

Table relationship map

SELECT statement

SELECT
   SCL1.srvcCallID AS 'Service Call No.', 
   SCL1.line AS 'Row No.', 
   SCL1.solutionID AS 'Solution ID', 
   SCL1.objType AS 'Object Type', 
   SCL1.logInstanc AS 'Log Instance', 
   SCL1.userSign AS 'Creating User', 
   SCL1.createDate AS 'Creation Date', 
   SCL1.userSign2 AS 'Updating User', 
   SCL1.updateDate AS 'Date of Update', 
   SCL1.VisOredr AS 'Visual Order'
FROM SCL1 AS SCL1

Related information

ServiceCallSolutions Object· Table: SCL1

ServiceCallSolutions is a child object of the ServiceCalls object in the Service module. The service call solutions are associated with the Knowledge Base Solutions table. Source table: SCL1.

Parent: Service Calls ServiceCalls Object· Table: OSCL
OSLT SQL Table

OSCL SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
ServiceCalls

Object
ServiceCallSolutions

Method

Add

Delete

SetCurrentLine

Property

Count

LineNum

SolutionID

UserFields

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