biuan SAP® BUSINESS ONE SDK
API OSQR
OSQR - Standard Queries Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
IntrnalKey KEY UNIQUEInternal KeyInt
11
PRIMARYYes
QCategoryQuery GroupInt
11
QName KEY UNIQUEQuery NamenVarChar
100
QNAME_KYes
QStringQueryText
16
QTypeQuery TypeVarChar
R) Regular
W) Wizard
G) Report Generator
1
R
ColumnSizeColumn SizenVarChar
100
DBTypeDB TypeInt
11

SELECT statement

SELECT OSQR.IntrnalKey AS 'Internal Key', OSQR.QCategory AS 'Query Group', OSQR.QName AS 'Query Name', OSQR.QString AS 'Query', OSQR.QType AS 'Query Type', OSQR.ColumnSize AS 'Column Size', OSQR.DBType AS 'DB Type' FROM OSQR AS OSQR

Related information




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