Menu

Other Data

Sage 50 All other Data Exported

The data exported for non tansactional data uses the same tag names as PostTrans for Excel

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

asdSelect "Edit Content" from the Edit (Pencil Icon) Action Menu.