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

SQL Service / Service Calls / Service Call Activities

DTW Service Call Activities

API Service Calls / Service Call Activities

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	Int	6		-1
ClgID	Activity Code	Int	11	OCLG Activities
ObjectType	Object Type	nVarChar	20		191
LogInstanc	Log Instance	Int	11
UserSign	User Signature	Int	6	OUSR Users
CreateDate	Creation Date	Date	8
UserSign2	User Signature 2	Int	6	OUSR Users
UpdateDate	Date of Update	Date	8
VisOrder	Visual Order	Int	11

Table relationship map

SELECT statement

SELECT
   SCL5.SrvcCallId AS 'Service Call No.', 
   SCL5.Line AS 'Row', 
   SCL5.ClgID AS 'Activity Code', 
   SCL5.ObjectType AS 'Object Type', 
   SCL5.LogInstanc AS 'Log Instance', 
   SCL5.UserSign AS 'User Signature', 
   SCL5.CreateDate AS 'Creation Date', 
   SCL5.UserSign2 AS 'User Signature 2', 
   SCL5.UpdateDate AS 'Date of Update', 
   SCL5.VisOrder AS 'Visual Order'
FROM SCL5 AS SCL5

Related information

ServiceCallActivities Object· Table: SCL5

ServiceCallActivities is a child object of the ServiceCalls object in the Service module. The service call activities are associated with the Activities with Business Partners table. Source table: SCL5.

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

OSCL SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
ServiceCalls

Object
ServiceCallActivities

Method

Add

Delete

SetCurrentLine

Property

ActivityCode

Count

LineNum

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