biuan SAP® BUSINESS ONE SDK
DTW Service Call Solutions - Rows
API Service Calls / Service Call Solutions
SCL1 - Service Call Solutions - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
srvcCallID KEY UNIQUEService Call No.Int
11OSCL
Service Calls
PRIMARYYes
lineRow No.Int
6
-1
solutionIDSolution IDInt
11OSLT
Service Call Solutions
objTypeObject TypenVarChar
20
191
logInstancLog InstanceInt
11
userSignCreating UserInt
6OUSR
Users
createDateCreation DateDate
8
userSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
8
VisOredrVisual OrderInt
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


Service Call Solutions 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
Service Call Solutions OSLT SQL Table

Service Calls OSCL SQL Table

Users OUSR 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