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.

What do you want to do next?