Available in Sage 50 Premium Accounting and higher.
Audit Trail Fields
The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.
Filename: AUDITTR.DAT
The AUDITTR.DAT file contains information about the use of the Sage 50 audit trail feature by your company.
- To add Sage 50 audit trail fields to your Crystal reports, select AUDITTR.DAT.
Indexes and Their Uses
This file has the following three keys:
0 = By Date
1 = By User ID and then by Date
2 = By Post Order
Fields
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. |