Available in Sage 50 Premium Accounting and higher.
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
The AUDITTR.DAT file contains information about the use of the Sage 50 audit trail feature by your company.
This file has the following three keys:
0 = By Date
1 = By User ID and then by Date
2 = By Post Order
The following table shows the fields available in the AUDITTR.DAT file and includes the type and size in number of bytes of each field.
|
Field Name |
Type |
Size |
Comment |
|---|---|---|---|
|
TimeStamp |
Date |
Time stamp on data entered by user tracked by audit trail. |
|
|
UserID |
ZString |
20 |
ID of user who entered data tracked by audit trail. |
|
Reference |
ZString |
39 |
Journal reference number or ID of the maintenance item. |
|
TransID |
ZString |
30 |
Main ID for journals. |
|
Action |
UBinary |
Action taken. Valid values include the following: 0 = Delete 1 = Add 2 = Change 3 = Void |
|
|
Type |
UBinary |
Audit trail event type. Possible values include: 0 = Maintenance Item 1 = Journal 2 = Ticket 3 = Other |
|
|
PostOrder |
UBinary |
Post order points to the entry in the JrnlHdr table. |
|
|
TicketType |
UBinary |
Type of time ticket used. Valid values include: 1 = Time 2 = Expense |
|
|
MainAmt |
Float |
Amount of new entry on a journal change. |
|
|
Description |
ZString |
160 |
Description of audit trail transaction. |