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

SQL

Others /

Upgrade queries history

API SHQR

SHQR - Upgrade queries history Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
Version ^KEY ^UNIQUE	Version	Int		11		PRIMARY	Yes
TableId	Metadata CAB	nVarChar		4
Instance	Query instance	Int		6
DoBefore	Do Before	VarChar	Y) Yes N) No	1	Y
QurString	Query String	Text		16
ServerType	Server Type	Int		11	0

SELECT statement

SELECT
   SHQR.Version AS 'Version', 
   SHQR.TableId AS 'Metadata CAB', 
   SHQR.Instance AS 'Query instance', 
   SHQR.DoBefore AS 'Do Before', 
   SHQR.QurString AS 'Query String', 
   SHQR.ServerType AS 'Server Type'
FROM SHQR AS SHQR

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates