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.