Version: 2024 Sage 50 US
Columns
| Column Name | Data Type |
|---|---|
| AlertNum | USMALLINT |
| AlertType | USMALLINT |
| Amount | DECIMAL |
| ApplyType | USMALLINT |
| Bcc | VARCHAR(2000) |
| BudgetGuid | BINARY(16) |
| Cc | VARCHAR(2000) |
| ConditionType | USMALLINT |
| FromAccount | VARCHAR(20) |
| GUID | BINARY(16) |
| IncludeNote | UTINYINT |
| IncludeStandardMsg | UTINYINT |
| LastUpdateCounter | UINTEGER |
| Note | VARCHAR(2000) |
| SendEmail | UTINYINT |
| Subject | VARCHAR(500) |
| To_ | VARCHAR(2000) |
| ToAccount | VARCHAR(20) |
Indexes
- ByAlertNum:
- ByAlertType:
- ByApplyType:
- ByGUID:
Foreign Keys
No foreign key metadata (or none defined).
Example Query
SELECT *
FROM Alerts
LIMIT 0, 50;