biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Activities / Activity Subjects
DTW Business Partners / Activity / Activity Subjects
API Contacts / Subject
OCLS - Activity Subjects Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
6
PRIMARYYes
NameNamenVarChar
20
Type KEY UNIQUERelated TypeInt
6OCLT
Activity Types		-1typeYes
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OCLS.Code AS 'Code', OCLS.Name AS 'Name', OCLS.Type AS 'Related Type', OCLS.DataSource AS 'Data Source', OCLS.UserSign AS 'User Signature' FROM OCLS AS OCLS

Related information


 v9.0  Subject Subject Property· Table: OCLS
Sets or returns the subject of the activity.Field name: CntctSbjct.
· Table: OCLG    Parent: Contacts Contacts Object· Table: OCLG
OCLS SQL Table

Activity Types OCLT 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates