biuan SAP® BUSINESS ONE SDK
API OUQR / / User Queries
OUQR - Queries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IntrnalKey KEY UNIQUEInternal KeyInt
11
PRIMARYYes
QCategoryQuery CategoryInt
11OQCN
Query Catagories
QName KEY UNIQUEQuery DescriptionnVarChar
100
QNAME_KYes
QStringQueryText
16
QTypeQuery TypeVarChar
R) Regular
W) Wizard
G) Report Generator
S) Stored Procedure
1
W
ColumnSizeColumn SizenVarChar
100
DBTypeDB TypeInt
11
QLastDateLast Upload DateDate
8
QLastTimeLast Upload TimeInt
6
XsltXSLT TransformationText
16

Table relationship map

SELECT statement

SELECT OUQR.IntrnalKey AS 'Internal Key', OUQR.QCategory AS 'Query Category', OUQR.QName AS 'Query Description', OUQR.QString AS 'Query', OUQR.QType AS 'Query Type', OUQR.ColumnSize AS 'Column Size', OUQR.DBType AS 'DB Type', OUQR.QLastDate AS 'Last Upload Date', OUQR.QLastTime AS 'Last Upload Time', OUQR.Xslt AS 'XSLT Transformation' FROM OUQR AS OUQR

Related information


User Queries UserQueries Object· Table: OUQR
The UserQueries object enables to define user queries in the Queries Manager. Source table: OUQR.

OUQR SQL Table

Query Catagories OQCN 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