Table where all types of Alert are recorded
Data model

Fields
Field |
Type |
Description |
id* |
INT |
Unique identifier of the table |
idcategoryparent* |
INT |
Category identifier Father. |
isactive* |
BIT |
Dialing to identify if the record is in an active/inactive state |
name* |
NVARCHAR (100) |
Alert Type Name |
referencevalue |
NVARCHAR (200) |
Reference value for calculation of scheduled date of orders for definition of Alert generation |
Primary Key
References
Column |
Referenced Table |
Referenced column |
Name |
idcategoryparent* |
Bod. AFW_ALERT_CATEGORY |
id |
FK01_AFLS_ALERT_TYPE |