biuan SAP® BUSINESS ONE SDK
API OQCN / / Query Categories
OQCN - Query Catagories Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CategoryId KEY UNIQUECategory IDInt
11
PRIMARYYes
CatName KEYCategory NamenVarChar
50
CAT_NAME_KNo
PermMaskPermissionsnVarChar
20
NNNNNNNNNNNNNNNNNNNN
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
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 OQCN.CategoryId AS 'Category ID', OQCN.CatName AS 'Category Name', OQCN.PermMask AS 'Permissions', OQCN.DataSource AS 'Data Source', OQCN.UserSign AS 'User Signature' FROM OQCN AS OQCN

Related information


Query Categories QueryCategories Object· Table: OQCN
QueryCategories is a business object that represents the query categories in the Queries Manager. This object enables you to: Add a query category. Retrieve a query category by its key. Update a query category. Save the object in XML...

OQCN 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