📚 SAP Business One SDK Help

Table Name: OUQR

Table Description: Queries

Field Description Type Size Related Default Value Constraints
IntrnalKey Internal Key Int 11 -      
QCategory Query Category Int 11 OQCN      
QName Query Description nVarChar 100 -      
QString Query Text 16 -      
QType Query Type VarChar 1 - W R Regular
            W Wizard
            G Report Generator
            S Stored Procedure
ColumnSize Column Size nVarChar 100 -      
DBType DB Type Int 11 -      
QLastDate Last Upload Date Date 8 -      
QLastTime Last Upload Time Int 6 -      
Xslt XSLT Transformation Text 16 -      
MenuItem Specify Menu Item VarChar 1 - N Y Yes
            N No
MenuCapt Menu Caption nVarChar 254 -      
FatherMenu Parent Menu ID Int 11 -      
MenuPos Menu Position Int 6 -      
MenuUid Menu UID nVarChar 32 -      
CommandID Menu Command ID Int 11 -      
UpdateDate Last Update Date Date 8 -      
LastUpdate Last Update Time Int 11 -      
LogInstanc Log Instance Int 11 - 0    
CreateDate Created On Date 8 -      
ChangeDate Change Date Date 8 -      
CreateTS Creatn Time - Incl. Secs Int 11 -      
UpdateTS Update Full Time Int 11 -      
UserSign Created By Int 6 -      
UserSign2 Updated By Int 6 -      
AnaActive Analytics Active VarChar 1 - N Y Yes
            N No
DisplTile Display UDQ as Tile VarChar 1 - N Y Yes
            N No
UseNmParam Include Parameters VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes IntrnalKey
    QCategory
QNAME_K Yes QName
    QCategory