📚 SAP Business One SDK Help

Table Name: OALT

Table Description: Alerts Management

Field Description Type Size Related Default Value Constraints
Code Internal Number Int 11 -      
Name Name nVarChar 254 -      
Type Type VarChar 1 - U S System Alert
            U User Alert
Priority Priority VarChar 1 - 1 0 Low
            1 Normal
            2 High
Active Active Alert VarChar 1 - N Y Yes
            N No
NumOfParam No. of Parameters Int 11 -      
ParamData Parameters Text 16 -      
Params Parameters Text 16 -      
NumOfDocs Documents Numbers Int 11 -      
DocsData Documents Text 16 -      
Docs Documents Text 16 -      
UserText MEMO Text 16 -      
QueryId Query Int 11 -      
FrqncyType Frequency Type VarChar 1 - H S Minutes
            H Hours
            D Days
            W Weeks
            M Months
FrqncyIntr Frequency Int 11 - 1    
ExecDaY Day of Execution Int 6 - 1    
ExecTime Execution Hour Int 11 - 800    
LastDate Execution Date Date 8 -      
LastTIME Execution Time Int 6 -      
NextDate Next Date Date 8 -      
NextTime Next Hour Int 6 -      
UserSign User Signature Int 6 OUSR      
History Save History VarChar 1 - N Y Yes
            N No
QCategory Query Category Int 11 OUQR      
Key Unique Field
PRIMARY Yes Code
ACTIVE No Active
NAME No Name