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

SQL Others / MetaData Tables Fields Vals

API MVAL

MVAL - MetaData Tables Fields Vals Table

SBO SQL database table details

Field	Description	Type	Size	Default	Primary_Key	Unique
TableName ^KEY ^UNIQUE	Table Name	nVarChar	5		PRIMARY	Yes
FieldIndex	Field Index	Int	6
ValIndex	Val Index	Int	6
Value	Value	nVarChar	127
Descr	Description	nVarChar	127
UpdateDate	Update Date	Date	8
UpdateTime	Update Time	Int	11	0
UsrSgnAttr	User Sign For Attribs Change	Int	11	-1
DiEnumCode	DI Enum Code	Int	11
DiEnItCode	DI Enum Item Code	Int	11
ResCode	Resource Code from RSBD	Int	11	-1
RevCode	Revision Code	Int	11	-1

SELECT statement

SELECT
   MVAL.TableName AS 'Table Name', 
   MVAL.FieldIndex AS 'Field Index', 
   MVAL.ValIndex AS 'Val Index', 
   MVAL.Value AS 'Value', 
   MVAL.Descr AS 'Description', 
   MVAL.UpdateDate AS 'Update Date', 
   MVAL.UpdateTime AS 'Update Time', 
   MVAL.UsrSgnAttr AS 'User Sign For Attribs Change', 
   MVAL.DiEnumCode AS 'DI Enum Code', 
   MVAL.DiEnItCode AS 'DI Enum Item Code', 
   MVAL.ResCode AS 'Resource Code from RSBD', 
   MVAL.RevCode AS 'Revision Code'
FROM MVAL AS MVAL

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