Menu

Audit Transactions

Sage 50 Audit Trail Transactions

The following is a list of Header and Line record columns optionally exported from the Sage 50 Audit Trail

Export Fields for Audit Trail Transaction Header

Tag Name

Data Type

Description

headerUniqueID

Integer

Unique ID for each header record which does not changed (First Split no in Sage 50, shown in Transaction list)

transNumber

Integer

SI141254

transOutstanding

Integer

1 means not paid.

outstanding

Double

Amount Outstanding

BANK_CHARGE_IS_CUSTOMER

Integer

Is Bank Charge Customer or Supplier (Read Only)

ACCOUNT_REF

Text 8

Sales/Purchase/Bank Account Reference

AMOUNT_PAID

Double

Total Amount Paid

BANK_CHARGE_ACCOUNT

Text 8

Bank Charge Customer/Supplier Ref (Read Only)

BANK_CODE

Text 8

Bank Account Reference

BANK_FLAG

Integer

Bank Reconciled Flag

CURRENCY

Integer

Currency for Transaction

CURRENCY_USED

Integer

Currency Used

DATE

Date

Transaction Date

DATE_AMENDED

Text 32

Date Transaction Amended

DATE_DUE

Date

Date Invoice is Due for Payment

DATE_FORECAST

Date

Forecast Date

DATE_LAST_CHARGE

Date

Date Interest Last Charged

DELETED_FLAG

Integer

Transaction Deleted Flag

DEPOSIT_DATE

Date

Bank deposited date

DEPOSIT_FLAG

Integer

Bank deposited flag

DETAILS

Text 60

Details

ELEC_TRANS

Integer

Electronic Transaction Flag

EURO_GROSS

Double

Euro Gross Amount

EURO_RATE

Double

Euro Rate

FINANCE_CHARGE

Integer

Finance Charge Flag

FIRST_SPLIT

Integer

Record Number in the SplitData collection

FORECAST_INCLUDE

Date

Included in Forecast

FOREIGN_AMOUNT_PAID

Double

Foreign Total Amount Paid

FOREIGN_GROSS

Double

Foreign Gross Amount

FOREIGN_NET_AMOUNT

Double

Foreign Net Amount

FOREIGN_RATE

Double

Foreign Rate For Euro Currency

FOREIGN_TAX_AMOUNT

Double

Foreign Tax Amount

INTEREST_RATE

Double

Interest Rate to Charge

INV_REF

Text 30

Invoice Reference Number

ISP_REFERENCE

Integer

Inv\Sop\Pop Reference (But can be edited in Sage 50)

JOB_REFERENCE

Text 60

Job Costing Reference

LAST_SPLIT

Integer

Record Number in the SplitData collection

NET_AMOUNT

Double

Net Amount

NEXT_ACCOUNT

Integer

Record Number for Next Account

NEXT_BANK

Integer

Record Number for Next Bank

NO_DISPUTED

Integer

Number of Disputed Splits

NO_OF_SPLIT

Integer

Number of Splits

OPENING_BALANCE_TRANS

Integer

Flag To State Is An Opening Balance Transaction

OVERRIDDEN_CLOSED_LEDGER_DATE

Date

The closed ledger date that was overridden at the time of posting

PAID_FLAG

Integer

Transaction Paid Flag

POSTED_DATE

Date

Posting Date

POSTING_LOCATION

Integer

Location Transaction Posted From

PRACTICE_SOLUTIONS_REFN

Text 60

Sage Practice Solutions Reference

PREV_ACCOUNT

Integer

Record Number for Previous Account

PREV_BANK

Integer

Record Number for Previous Bank

PRINTED_FLAG

Integer

Printed Flag

PROTX_REFN

Text 63

PROTX Reference

RECON_DATE

Date

Bank Reconciled Date

RECORD_CREATE_DATE

Date

Date and time when the record was created

RECORD_DELETED

Integer

Flag denoting if the record has been deleted

RECORD_MODIFY_DATE

Date

Date and time when the record was modified

REVALUATION_TRANS

Integer

Flag To State Is a Revaluation Transaction

SETT_DISCOUNT_RATE

Double

Settlement Discount Value on Header

TAX_AMOUNT

Double

Tax Amount

TYPE

Integer

Transaction Type

UNIQUE_REF

Integer

Unique Reference

USER_NAME

Text 32

User Name

USER_NAME_AMENDED

Text 32

User Name

VAT_FLAG

Integer

Vat Flag

recordNumber

Integer

Record number in Sage 50

Export Fields for Audit Trail Transaction Lines

Tag Name

Data Type

Description

uniqueID

Integer

Unique ID for each line record which does not changed (Split no in Sage 50, shown in Transaction list)

headerUniqueID

Integer

Unique ID for each header record USE TO RELATE THE TWO FILES RECORDS

invoiceNumber

Integer

Invoice/Order No which relates to Header

DATE

Date

Date

AMOUNT_PAID

Double

Total Amount Paid

BANK_FLAG

Integer

Bank Reconciled Flag

DELETED_FLAG

Integer

Transaction Deleted Flag

DEPOSIT_DATE

Date

Bank deposited date

DEPOSIT_FLAG

Integer

Bank deposited flag

DEPT_NUMBER

Integer

Department Number

DETAILS

Text 60

Details

DISPUTE_TYPE

Integer

Dispute Type

DOCTOR_LINK

Integer

Pointer to Fix by Doctor

FIRST_USAGE

Integer

Record Number of First Usage

FOREIGN_AMOUNT_PAID

Double

Foreign Total Paid Amount

FOREIGN_NET_AMOUNT

Double

Foreign Net Amount

FOREIGN_TAX_AMOUNT

Double

Foreign Tax Amount

FUND_NUMBER

Integer

Fund Number

GASDS_CLAIM_SUBMITTED

Integer

GASDS Claim Submitted

GIFT_AID

Integer

Gift Aid status

HAS_EXTERNAL_LINK

Integer

Sets whether the transaction has an external link (0 == No, 1 == Yes)

HEADER_NUMBER

Integer

Record Number of Header

INTERNAL_REF

Text 30

Extra Reference

LAST_USAGE

Integer

Record Number of Last Usage

NET_AMOUNT

Double

Net Amount

NEXT_NOMINAL

Integer

Record Number of Next Split for this Nominal

NEXT_SPLIT

Integer

Record Number of Next Split

NO_OF_USAGE

Integer

Number of Usages

NOMINAL_CODE

Text 8

Nominal Code

PAID_FLAG

Integer

Paid Flag

POSTED_DATE

Date

Posting Date

PREV_NOMINAL

Integer

Record Number of Previous Split for this Nominal

PREV_SPLIT

Integer

Record Number of Previous Split

PROJECT_ID

Integer

Project ID

RECORD_CREATE_DATE

Date

Date and time when the record was created

RECORD_DELETED

Integer

Flag denoting if the record has been deleted

RECORD_MODIFY_DATE

Date

Date and time when the record was created

STATUS

Integer

Disputed Status Flag

SMALL_DONATION

Integer

Small Donations

TAX_AMOUNT

Double

Tax Amount

TAX_CODE

Integer

Tax Code

TRAN_NUMBER

Integer

Unique Transaction Number as seen in the Customer\Supplier activity screen in the Sage 50

TYPE

Integer

Transaction Type

UNIQUE_REF

Integer

Unique Reference

USER_NAME

Text 32

User Name

VAT_FLAG

Integer

Vat Reconciled Flag

VAT_RECONCILED_DATE

Date

Date of VAT Reconciliation

VAT_RETURN_ID

Integer

Vat Return Identification Number