biuan SAP® BUSINESS ONE SDK
SQL Others / MetaData Tables
API MTBL
MTBL - MetaData Tables Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Name KEY UNIQUETable NamenVarChar
5
PRIMARYYes
ViewOrderView OrderInt
-1) Invisible
10) Administration
20) Administration Plus
30) Master Data
40) Document Line
50) Document
60) Log File
70) Payment Line
80) Payments
6
30
TypeTable TypeInt
1) User OM
2) User
3) System OM
4) System
6
1
DescrDescriptionnVarChar
127
CategoryCategoryInt
6
0
SubCategSub CategoryInt
6
0
DirtyDirtyVarChar
Y) Yes
N) No
1
Y
CreatedCreation DateDate
8
UpdatedUpdate DateDate
8
InfoCtgoryInformation CategoryInt
6
0
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1

SELECT statement

SELECT MTBL.Name AS 'Table Name', MTBL.ViewOrder AS 'View Order', MTBL.Type AS 'Table Type', MTBL.Descr AS 'Description', MTBL.Category AS 'Category', MTBL.SubCateg AS 'Sub Category', MTBL.Dirty AS 'Dirty', MTBL.Created AS 'Creation Date', MTBL.Updated AS 'Update Date', MTBL.InfoCtgory AS 'Information Category', MTBL.ResCode AS 'Resource Code from RSBD', MTBL.RevCode AS 'Revision Code' FROM MTBL AS MTBL

Related information
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