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

SQL

Service /

Service Call Activities - History

API ASC5

ASC5 - Service Call Activities - History 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
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
   ASC5.SrvcCallId AS 'Service Call No.', 
   ASC5.Line AS 'Row No.', 
   ASC5.ClgID AS 'Activity Code', 
   ASC5.ObjectType AS 'Object Type', 
   ASC5.LogInstanc AS 'Log Instance', 
   ASC5.UserSign AS 'User Signature', 
   ASC5.CreateDate AS 'Creation Date', 
   ASC5.UserSign2 AS 'User Signature 2', 
   ASC5.UpdateDate AS 'Date of Update', 
   ASC5.VisOrder AS 'Visual Order'
FROM ASC5 AS ASC5

Related information

OCLG SQL Table

OSCL SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

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