SAP Business One SDK 10.0 - Database Tables Reference
-
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 |