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

API MDKY

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
TableName ^KEY ^UNIQUE	Table Name	nVarChar		5		PRIMARY	Yes
HKeyIndex	HKey Index	Int		6
DKeyIndex	DKey Index	Int		6
FieldName	Field in Key	nVarChar		20
Upper	Upper	VarChar	Y) Yes N) No	1	Y
UpdateDate	Update Date	Date		8
UpdateTime	Update Time	Int		11	0
UsrSgnAttr	User Sign For Attribs Change	Int		11	-1
ResCode	Resource Code from RSBD	Int		11	-1
RevCode	Revision Code	Int		11	-1

SELECT statement

SELECT
   MDKY.TableName AS 'Table Name', 
   MDKY.HKeyIndex AS 'HKey Index', 
   MDKY.DKeyIndex AS 'DKey Index', 
   MDKY.FieldName AS 'Field in Key', 
   MDKY.Upper AS 'Upper', 
   MDKY.UpdateDate AS 'Update Date', 
   MDKY.UpdateTime AS 'Update Time', 
   MDKY.UsrSgnAttr AS 'User Sign For Attribs Change', 
   MDKY.ResCode AS 'Resource Code from RSBD', 
   MDKY.RevCode AS 'Revision Code'
FROM MDKY AS MDKY

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