Version: 2024 Sage 50 US
Columns
| Column Name | Data Type |
|---|---|
| Action | USMALLINT |
| Description | VARCHAR(160) |
| MainAmt | DECIMAL |
| PostOrder | UINTEGER |
| Reference | VARCHAR(39) |
| TicketType | USMALLINT |
| TimeStamp | UINTEGER |
| TransID | VARCHAR(30) |
| Type | USMALLINT |
| UserID | VARCHAR(20) |
Indexes
- ByDate:
- ByPostOrder:
- ByUserIDDate:
Foreign Keys
No foreign key metadata (or none defined).
Example Query
SELECT *
FROM Audit_Trail
LIMIT 0, 50;