📚 SAP Business One SDK Help

Table Name: MFLD

Table Description: MetaData Tables Fields

Field Description Type Size Related Default Value Constraints
TableName Table Name nVarChar 5 -      
FieldIndex Field Index Int 6 -      
Name Field Name nVarChar 20 -      
Alias Alias nVarChar 10 -      
Descr Description nVarChar 250 -      
Type Type VarChar 1 - A A DB Alpha
            M DB Memo
            N DB Numeric
            D DB Date
            B DB Binary
            I DB Auto Key
Size Size Int 6 -      
FieldType Field Type Num Int 6 -      
Visible Visible VarChar 1 - Y Y Yes
            N No
EditType Edit Type VarChar 1 -      
EditSize Edit Size Int 6 -      
RFile Related Table nVarChar 4 -      
ColHeading Column Heading nVarChar 30 -      
FrmHeading Form Heading nVarChar 30 -      
GroupNum Group Number Int 6 - 0 0 User
            -1 System
DefaultVal Default Value nVarChar 254 -      
DIStatus DI Status VarChar 1 - E N Not added to DI
            Y Added as Read/Write
            R Added as Read Only
            E NOT DEFINED
Dirty Dirty VarChar 1 - Y Y Yes
            N No
Flag1 Flag1 VarChar 1 - N Y Yes
            N No
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    
AssGrp Association Group nVarChar 16 -      
AssType Association Type nVarChar 2 - -1 -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
IsPersist Is Field Persistant VarChar 1 - Y Y Yes
            N No
Key Unique Field
PRIMARY Yes TableName
    FieldIndex
    ResCode
    RevCode