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 |