biuan SAP® BUSINESS ONE SDK
SQL Business Partners / Activity Status
DTW Administration / Setup / Business Partners / Activity Status
API OCLA / Activity Status
OCLA - Activity Status Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
statusID KEY UNIQUEStatus IDInt
11
PRIMARYYes
nameStatus NamenVarChar
30
descriptioStatus DescriptionnVarChar
127
LockedLockedVarChar
Y) Yes
N) No
1
N

SELECT statement

SELECT OCLA.statusID AS 'Status ID', OCLA.name AS 'Status Name', OCLA.descriptio AS 'Status Description', OCLA.Locked AS 'Locked' FROM OCLA AS OCLA

Related information


Activity Status ActivityStatus Object· Table: OCLA
ActivityStatus is a business object that enables to define statuses for Task type activities in the Business Partners module. This object enables you to: Add a status to the statuses list. Retrieve a status by its key. Update a status of...

OCLA 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