OSQR - biuan.com SDK Developer - SAP® Business ONE (SBO)

API OSQR

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
IntrnalKey ^KEY ^UNIQUE	Internal Key	Int		11		PRIMARY	Yes
QCategory	Query Group	Int		11
QName ^KEY ^UNIQUE	Query Name	nVarChar		100		QNAME_K	Yes
QString	Query	Text		16
QType	Query Type	VarChar	R) Regular W) Wizard G) Report Generator	1	R
ColumnSize	Column Size	nVarChar		100
DBType	DB Type	Int		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

biuan SAP® BUSINESS ONE

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