📚 SAP Business One SDK Help

Table Name: QWZ2

Table Description: Query Result Fields

Field Description Type Size Related Default Value Constraints
Code Query Code nVarChar 8 -      
Numerator Internal Number Int 11 -      
FileCode Table Name nVarChar 20 -      
FieldAlias Field Alias nVarChar 10 -      
Title Field Title nVarChar 30 -      
SortOrder Sort Order Int 11 -      
SortType Sort Type VarChar 1 - N Y Yes
            N No
GroupBy Group By VarChar 1 - N Y Yes
            N No
AgregType Agreggate Function Int 11 -      
CalcField Calculation Field nVarChar 254 -      
IsCalc Is Calculation VarChar 1 - N Y Yes
            N No
TmpAlias New Alias in Res. Table nVarChar 11 -      
TmpDescr New Description in Res. Table nVarChar 30 -      
Fld2Alias Field 2 Number nVarChar 10 -      
FileCode2 Field 2 Table Name nVarChar 20 -      
Agreg2Type Field 2 Aggregate Function Int 11 -      
FldOp Formula Operation Int 11 -      
FldCnstVal Field Const. Val. nVarChar 254 -      
Fld2CnsVal Field 2 Const. Val. nVarChar 254 -      
Key Unique Field
PRIMARY Yes Code
    Numerator