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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TableName KEY UNIQUETable NamenVarChar
5
PRIMARYYes
FieldIndexField IndexInt
6
NameField NamenVarChar
20
AliasAliasnVarChar
10
DescrDescriptionnVarChar
127
TypeTypeVarChar
A) DB Alpha
M) DB Memo
N) DB Numeric
D) DB Date
B) DB Binary
I) DB Auto Key
1
A
SizeSizeInt
6
FieldTypeField Type NumInt
6
VisibleVisibleVarChar
Y) Yes
N) No
1
Y
EditTypeEdit TypeVarChar
1
EditSizeEdit SizeInt
6
RFileRelated TablenVarChar
4
ColHeadingColumn HeadingnVarChar
30
FrmHeadingForm HeadingnVarChar
30
GroupNumGroup NumberInt
0
-1) System
6
0
DefaultValDefault ValuenVarChar
127
DIStatusDI StatusVarChar
N) Not added to DI
Y) Added as Read/Write
R) Added as Read Only
E) NOT DEFINED
1
E
DirtyDirtyVarChar
Y) Yes
N) No
1
Y
Flag1Flag1VarChar
Y) Yes
N) No
1
N
UpdateDateUpdate DateDate
8
UpdateTimeUpdate TimeInt
11
0
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1
AssGrpAssociation GroupnVarChar
16
AssTypeAssociation TypenVarChar
-1)
OT) Object Type
O1) Object Key Seg. 1
O2) Object Key Seg. 2
O3) Object Key Seg. 3
O4) Object Key Seg. 4
O5) Object Key Seg. 5
O6) Object Key Seg. 6
AO) Array Offset
A1) Array Key 1
A2) Array Key 2
A3) Array Key 3
2
-1
IsPersistIs Field PersistantVarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT MFLD.TableName AS 'Table Name', MFLD.FieldIndex AS 'Field Index', MFLD.Name AS 'Field Name', MFLD.Alias AS 'Alias', MFLD.Descr AS 'Description', MFLD.Type AS 'Type', MFLD.Size AS 'Size', MFLD.FieldType AS 'Field Type Num', MFLD.Visible AS 'Visible', MFLD.EditType AS 'Edit Type', MFLD.EditSize AS 'Edit Size', MFLD.RFile AS 'Related Table', MFLD.ColHeading AS 'Column Heading', MFLD.FrmHeading AS 'Form Heading', MFLD.GroupNum AS 'Group Number', MFLD.DefaultVal AS 'Default Value', MFLD.DIStatus AS 'DI Status', MFLD.Dirty AS 'Dirty', MFLD.Flag1 AS 'Flag1', MFLD.UpdateDate AS 'Update Date', MFLD.UpdateTime AS 'Update Time', MFLD.UsrSgnAttr AS 'User Sign For Attribs Change', MFLD.ResCode AS 'Resource Code from RSBD', MFLD.RevCode AS 'Revision Code', MFLD.AssGrp AS 'Association Group', MFLD.AssType AS 'Association Type', MFLD.IsPersist AS 'Is Field Persistant' FROM MFLD AS MFLD

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