Sage 50 UK CLEARED_TRAN_RANGE Columns
| Name | Type | Length | Precision | Notes | Example |
|---|---|---|---|---|---|
| CATE_ID | INTEGER | 4 | 10 | Clear Audit Trail Event ID | |
| START_TRAN_NUMBER | INTEGER | 4 | 10 | Start Transaction Number | |
| END_TRAN_NUMBER | INTEGER | 4 | 10 | End Transaction Number | |
| RECORD_CREATE_DATE | 16 | 0 | Date and time when the record was created. | ||
| RECORD_MODIFY_DATE | 16 | 0 | Date and time when the record was modified. | ||
| RECORD_DELETED | TINYINT | 2 | 3 | Flag denoting if the record has been deleted or not. |