SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: OALR
Table Description: Alerts
| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Internal Number |
Int |
11 |
- |
|
|
|
| Type |
Type |
VarChar |
1 |
- |
A |
A |
Alert |
| |
|
|
|
|
|
M |
Message |
| Priority |
Priority |
VarChar |
1 |
- |
1 |
0 |
- |
| |
|
|
|
|
|
1 |
|
| |
|
|
|
|
|
2 |
mHighPriority |
| TCode |
Template Code |
Int |
11 |
OALT |
|
|
|
| Subject |
Subject |
nVarChar |
254 |
- |
|
|
|
| UserText |
MEMO |
Text |
16 |
- |
|
|
|
| DataCols |
No. of Columns |
Int |
11 |
- |
|
|
|
| DataParams |
Data |
Text |
16 |
- |
|
|
|
| MsgData |
Data |
Text |
16 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| Attachment |
Attached File |
Text |
16 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| AltType |
Alert Type |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
C |
Inventory Cycle |
| Key |
Unique |
Field |
| PRIMARY |
Yes |
Code |
| USER |
No |
UserSign |