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 |