biuan SAP® BUSINESS ONE SDK
API MVAL
MVAL - MetaData Tables Fields Vals Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableName KEY UNIQUETable NamenVarChar
5
PRIMARYYes
FieldIndexField IndexInt
6
ValIndexVal IndexInt
6
ValueValuenVarChar
127
DescrDescriptionnVarChar
127
UpdateDateUpdate DateDate
8
UpdateTimeUpdate TimeInt
11
0
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
DiEnumCodeDI Enum CodeInt
11
DiEnItCodeDI Enum Item CodeInt
11
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
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




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