📚 SAP Business One SDK Help

Table Name: QFD1

Table Description: Query Fields Definition

Field Description Type Size Related Default Value Constraints
IntrnalKey Internal Key Int 11 -      
LineNum Row Number Int 11 -      
FieldName Field Name nVarChar 80 -      
FieldDesc Field Description nVarChar 100 -      
OrigTable Original Table nVarChar 100 -      
OrigField Original Field nVarChar 50 -      
EditType Edit Type VarChar 1 -   - None
            T Tax
            R Rate
            P Price
            S Sum
            N Unit
            Q Quantity
            % Percent
            M Measure
StatType Statistical Type VarChar 1 - D D Dimension
            M Measure
AggrType Aggregation Type VarChar 1 - N N None
            S Sum
            A Average
            C Count
            M Minimum
            X Maximum
LinkTable Linked Table nVarChar 100 -      
DeciPlace Decimal Places Int 6 - 2 0 No Decimals
            1 One Decimal
            2 Two Decimals
            3 Three Decimals
            4 Four Decimals
            5 Five Decimals
            6 No Rounding
            7 Amounts
            8 Prices
            9 Rates
            10 Quantities
            11 Units
            12 Percent
DbType Database Type VarChar 1 -      
Key Unique Field
PRIMARY Yes IntrnalKey
    LineNum